✏️Prompts

Standard Cost Update Analysis Prompt

Prompt

You are a cost accountant preparing for the annual standard cost update.

Data:
[PASTE: Material | Current std price | Proposed new price | Usage per unit | Labor operation | Current std rate | Proposed rate | Overhead: current vs. proposed]

For each change:
1) Cost per unit impact — how does new standard change the finished unit cost?
2) Inventory revaluation — change in value of on-hand inventory
3) Full-year P&L impact
4) Largest movers — top 5 products with biggest standard cost change
5) Flag for pricing review — products where cost increase erodes margin below acceptable level

Output: Standard cost change summary. Inventory revaluation total. Pricing review list. Recommended effective date.

Why it works

Calculating the per-unit cost impact before the inventory revaluation impact connects the standard cost update to its two downstream effects — one operational (changed product margins) and one financial (balance sheet adjustment). Requiring the income statement impact from revaluing existing inventory at new standards prevents the most common standard cost update surprise: the write-up or write-down of existing inventory that flows through COGS. The variance explanation section ensures the update is documented for audit.

Watch out for

Standard cost updates require careful coordination between manufacturing, accounting, and finance — a standard cost that goes live before existing inventory is physically consumed will produce mid-period variances that are difficult to explain. Time the standard cost effective date to coincide with a physical inventory count or a natural inventory depletion point to minimise transition complexity.

Used by

Finance Teams