Skip to content

CPD lab · Costing, Close

Inventory valuation and obsolete stock

A stock count at month end: value each line at the lower of cost and NRV, provide for obsolete stock and send the lines nobody can value yet to a person, with your AI tool.

All the ways to get this lab

Comes with Costing and variances: standard, activity-based and cost to serve, and with the year. 29 labs open now.

The brief

You work in costing at Tarnbrook Engineering Supplies Ltd, a UK trade distributor of fixings, cable, hose and pump parts. It is Monday 9 November 2026 and the October stock valuation is being finalised. The stock count and month end were Saturday 31 October.

The pack has the stock listing (14 lines), an extract of recent purchase invoices, the stock valuation policy and the notes passed to finance by the stores and sales teams. Every company, person and figure is invented, so you can paste it into any AI tool.

Use your AI tool to decide the treatment of each of the 14 stock lines at 31 October 2026. Post nothing: your job is the table, for a person to review and post.

Follow the stock valuation policy file. In short: stock is carried at the lower of cost and net realisable value (NRV), where cost is the actual weighted average cost, the quantity is the counted quantity, and the tests are applied in the order the policy gives. The policy also sets the company's own rules for a count tolerance and for obsolete stock.

Give one line for each stock line, in the table columns sku, action, carrying_value_gbp, adjustment_gbp and note. All amounts are in pounds, net of VAT, with two decimals; write 0.00 rather than leaving a cell blank.

carrying_value_gbp is the value of the line in the accounts at 31 October 2026 after any write-down or provision. adjustment_gbp is the amount taken off cost to get there, shown as a positive number; 0.00 if none.

Action, one per line. VALUE_AT_COST: the line is carried at counted quantity x actual average cost, with nothing taken off. WRITE_DOWN: the line is carried at counted quantity x NRV because NRV is below cost; the adjustment is cost less that value. PROVIDE: the line is obsolete under the policy; the carrying value is 0.00 and the adjustment is the whole cost. QUERY: the line cannot be valued under the policy and goes to a person; write 0.00 in both amount columns.

Then write a short review note: what the AI got wrong, what you checked, and what goes to a person.

Objective: To be able to use an AI assistant to test a stock listing against a valuation policy, identifying write-downs, obsolete stock and costing errors, and to refer lines that cannot be valued to the right person.

What's in the pack

Every name, figure and email in the pack is invented. Use your own AI tool: Claude, ChatGPT, Copilot or Gemini.

  • stock-listing-31-oct-2026.csv

    The 14 stock lines at 31 October 2026: system and counted quantities, costs, NRV and last movement date

  • purchase-invoices-extract.csv

    Recent supplier invoices for four of the lines (net of VAT)

  • stock-policy.txt

    The stock valuation policy used at month end

  • stock-notes.txt

    Emails and notes passed to finance from the stores and sales teams, 30 October to 3 November

The traps

The pack has 8 deliberate traps: cases where AI tools often get it wrong and a person must check. We don't list them here. Finding them is the job, and your feedback names each one you missed.

What you submit

  1. Your result, as a table with the columns sku, action, carrying_value_gbp, adjustment_gbp, note.
  2. The prompt you used.
  3. A short review note, 150 to 350 words: what the AI got wrong, what you checked, and what goes to a person.

How it's marked

  • Your result, checked line by line against the answer key60%
  • Your review note, marked on traits40%

The review note's traits:

  • Policy applied in order
  • Figures worked and agreed
  • Lines that cannot be valued referred to a person
  • AI errors found and corrected
  • Stock data kept out of personal accounts

Pass at 80. Under 80, read the feedback and try again. Then write your reflection and copy the entry for your CPD record.

Price

  • Costing and variances: standard, activity-based and cost to serve, £39. The role track and its labs, this one included. No end date.
  • Everything for a year, £199. Every course, role track and lab for 365 days.
  • Monthly, £19.99 a month, cancel any time. Every lesson, plus 8 marked tasks a month, across every course, role track and lab.

Buying for a team, or want a lab built on your own process? CPD for employers.