Capability template for finance and accounting
Production cost variance sheet
At period close the plant controller gets one sheet that separates material, labor and overhead differences from standard, by order and by product, with missing actuals and changed standards flagged. Each difference is a question for operations, never a cause.
Listed under
Add it to a workflow in the Fully Powered Planner, beside the teams and roles that will run it. Book a fit call
The outcome
When production closes for the period, the controller does not start from a pile of exports. The sheet is ready: for every closed order, what the standard cost card allowed for the good units made, what was actually booked, and the gap between them, split into material price and material usage, labor rate and labor efficiency, and overhead spending and overhead efficiency. The same figures are added up by element and by product, and every set of parts ties back to actual cost less standard cost.
The sheet is careful about what it does not know. An order with no labor hours posted does not get a labor variance of zero; it gets a flag and a question. A product whose standard changed during the period is named with the old and new figures, and an order that straddled the change is marked, so nobody reads a price gap that is really a standard update. Every difference over your limits becomes a question addressed to a named role in operations, written with the figures and no explanation. The controller verifies the arithmetic. Operations supplies and confirms any reason.
Nothing is posted, no standard cost is changed and no new standard is proposed.
Who starts the work, and when
The plant controller, or a cost accountant working for the controller, starts it once production actuals for the period have closed. It is run before the variance accounts are reviewed and before anyone explains the month to plant management. Operations answers the questions it produces, and the controller decides what goes into the close and the management pack.
What they supply
- The standard cost cards: one row per product and effective date, with the material quantity and price, labor hours and rate, and overhead rate per labor hour.
- The actuals for each closed order: product, start and close dates, good units, material quantity and cost, labor hours and cost, and overhead assigned to the order.
- A short settings note: plant name, period, currency, material unit, the limits that decide which differences become questions, and who in operations answers which kind of question.
What comes out
One fixed-order sheet: totals by element, a block for each order, totals by product, the flags (missing actuals, changed standards, anything else), the questions for operations, and a tie-out that shows the parts add up. Empty sections say "None." The worked example uses an invented plant and shows the full inputs as well as the result.
An invented example
Illustrative example with invented data. The plant, products, orders and every figure below are made up for this page. They stand for a small metal-parts plant closing October 2026, and describe nothing that happened anywhere.
What the controller supplies
Standard cost cards (default headers; per good unit; overhead rate per labor hour):
product,effective_from,std_material_qty,std_material_price,std_hours,std_labor_rate,std_overhead_rate
B-100,2026-01-01,2.5,4.00,0.40,30.00,20.00
H-200,2026-01-01,6.0,5.00,0.75,30.00,20.00
H-200,2026-10-15,6.0,5.50,0.75,30.00,20.00
Actuals for the closed orders (a blank cell means not recorded):
order,product,start_date,close_date,good_units,actual_material_qty,actual_material_cost,actual_hours,actual_labor_cost,actual_overhead
WO-1001,B-100,2026-10-01,2026-10-06,1000,2600,10660.00,430,13115.00,8300.00
WO-1002,B-100,2026-10-08,2026-10-13,1200,2985,11940.00,470,14100.00,9300.00
WO-2001,H-200,2026-10-05,2026-10-12,400,2450,12495.00,310,9300.00,6200.00
WO-2002,H-200,2026-10-13,2026-10-20,500,3020,16610.00,372,11160.00,7400.00
WO-1003,B-100,2026-10-20,2026-10-27,800,2010,8040.00,,,
Settings: Plant A (invented); period 2026-10-01 to 2026-10-31; currency in the plant's own units; material unit kg, with both files confirmed as holding material quantities in kg; overhead applied per labor hour; percentage limit 5; amount limit 250. Questions: material price to purchasing; everything else to the production supervisor; missing postings to the cost accountant; which standard governs an order to the controller. Sheet goes to the controller.
What comes out
PRODUCTION COST VARIANCE SHEET: Plant A, 2026-10-01 to 2026-10-31
For: the controller. Orders supplied: 5. Computed in full: 4. Computed in part or not at all: 1. Carrying a flag: 2. Amounts in the plant's currency, to the cent. U means actual is above standard; F means below. A difference is a question for operations, not a cause.
TOTALS BY ELEMENT
Material (5 orders): standard allowed 57,000.00; actual 59,745.00. Price 2,015.00 U. Usage 730.00 U. Total 2,745.00 U.
Labor (4 orders): standard allowed 46,650.00; actual 47,675.00. Rate 215.00 U. Efficiency 810.00 U. Total 1,025.00 U.
Overhead (4 orders): standard allowed 31,100.00; actual 31,200.00. Spending 440.00 F. Efficiency 540.00 U. Total 100.00 U.
Orders computed in full (4): material 2,705.00 U, labor 1,025.00 U, overhead 100.00 U; total 3,830.00 U. (Material above covers all orders with material computed, so it can differ from the material figure here.)
BY ORDER
WO-1001, B-100, 1,000 good units, standard from 2026-01-01:
- Material: allowed 2,500 kg, 10,000.00; actual 2,600 kg, 10,660.00. Price 260.00 U. Usage 400.00 U. Total 660.00 U.
- Labor: allowed 400.00 h, 12,000.00; actual 430.00 h, 13,115.00. Rate 215.00 U. Efficiency 900.00 U. Total 1,115.00 U.
- Overhead: allowed 8,000.00 (400.00 h at 20.00); actual 8,300.00. Spending 300.00 F. Efficiency 600.00 U. Total 300.00 U.
- Order total: 2,075.00 U (actual 32,075.00 against 30,000.00 allowed).
WO-1002, B-100, 1,200 good units, standard from 2026-01-01:
- Material: allowed 3,000 kg, 12,000.00; actual 2,985 kg, 11,940.00. Price 0.00. Usage 60.00 F. Total 60.00 F.
- Labor: allowed 480.00 h, 14,400.00; actual 470.00 h, 14,100.00. Rate 0.00. Efficiency 300.00 F. Total 300.00 F.
- Overhead: allowed 9,600.00 (480.00 h at 20.00); actual 9,300.00. Spending 100.00 F. Efficiency 200.00 F. Total 300.00 F.
- Order total: 660.00 F (actual 35,340.00 against 36,000.00 allowed).
WO-1003, B-100, 800 good units, standard from 2026-01-01:
- Material: allowed 2,000 kg, 8,000.00; actual 2,010 kg, 8,040.00. Price 0.00. Usage 40.00 U. Total 40.00 U.
- Labor: not computed, actual_hours and actual_labor_cost blank.
- Overhead: not computed, actual_overhead and actual_hours blank.
- Order total: not given, labor and overhead not computed.
WO-2001, H-200, 400 good units, standard from 2026-01-01:
- Material: allowed 2,400 kg, 12,000.00; actual 2,450 kg, 12,495.00. Price 245.00 U. Usage 250.00 U. Total 495.00 U.
- Labor: allowed 300.00 h, 9,000.00; actual 310.00 h, 9,300.00. Rate 0.00. Efficiency 300.00 U. Total 300.00 U.
- Overhead: allowed 6,000.00 (300.00 h at 20.00); actual 6,200.00. Spending 0.00. Efficiency 200.00 U. Total 200.00 U.
- Order total: 995.00 U (actual 27,995.00 against 27,000.00 allowed).
WO-2002, H-200, 500 good units, standard from 2026-01-01 (a later standard, from 2026-10-15, falls inside this order):
- Material: allowed 3,000 kg, 15,000.00; actual 3,020 kg, 16,610.00. Price 1,510.00 U. Usage 100.00 U. Total 1,610.00 U.
- Labor: allowed 375.00 h, 11,250.00; actual 372.00 h, 11,160.00. Rate 0.00. Efficiency 90.00 F. Total 90.00 F.
- Overhead: allowed 7,500.00 (375.00 h at 20.00); actual 7,400.00. Spending 40.00 F. Efficiency 60.00 F. Total 100.00 F.
- Order total: 1,420.00 U (actual 35,170.00 against 33,750.00 allowed).
BY PRODUCT
B-100, 3 orders: Material 640.00 U (3 orders). Labor 815.00 U (2 orders). Overhead 0.00 (2 orders).
H-200, 2 orders: Material 2,105.00 U (2 orders). Labor 210.00 U (2 orders). Overhead 100.00 U (2 orders).
FLAGS
Missing actuals: WO-1003: actual_hours, actual_labor_cost and actual_overhead blank; labor and overhead not computed.
Changed standards: H-200: material price from 5.00 to 5.50, effective 2026-10-15; WO-2002 (2026-10-13 to 2026-10-20) spans the date and is computed on 5.00; WO-2001 closed 2026-10-12 and is not affected.
Other: None.
QUESTIONS FOR OPERATIONS
1. WO-1001, labor efficiency: 430.00 h worked against 400.00 h allowed for 1,000 good units, 900.00 U, 7.5% of the 12,000.00 allowed. Production supervisor: what does production know about the hours on this order? Overhead efficiency on the same order (600.00 U, 7.5% of 8,000.00) is the same 30.00 hours at the overhead rate of 20.00, so this question stands for both.
2. WO-2002, material price: actual 16,610.00 for 3,020 kg, an average of 5.50 per kg, against a standard of 5.00; 1,510.00 U, 10.1% of the 15,000.00 allowed. The standard for H-200 material price changes to 5.50 on 2026-10-15, inside the order's dates. Controller: which standard governs this order? Purchasing: what does purchasing know about the price paid?
3. WO-1003, missing actuals: actual_hours, actual_labor_cost and actual_overhead are blank on an order closed 2026-10-27 with 800 good units. Cost accountant: have these been posted, and when will they be?
TIE-OUT
Material: price 2,015.00 + usage 730.00 = 2,745.00; actual 59,745.00 less allowed 57,000.00 = 2,745.00.
Labor: rate 215.00 + efficiency 810.00 = 1,025.00; actual 47,675.00 less allowed 46,650.00 = 1,025.00.
Overhead: spending 440.00 F + efficiency 540.00 U = 100.00 U; actual 31,200.00 less allowed 31,100.00 = 100.00.
Orders computed in full: material 2,705.00 + labor 1,025.00 + overhead 100.00 = 3,830.00.
Every figure traces to the standards file (standard cost cards, rows effective 2026-01-01 and 2026-10-15) and the actuals file (closed orders, October 2026). The sheet changes no standard cost and posts nothing.
How to read it
Two things stand out, and both are questions rather than answers. WO-2002 shows a large material price difference, but a new standard price took effect partway through that order, so the controller has to decide which standard applies before the number means anything. WO-1003 has no labor or overhead figures yet, so the sheet shows nothing for them instead of a zero, and the totals say how many orders each line covers. The questions are asked of the six parts (material price and usage, labor rate and efficiency, overhead spending and efficiency), not of totals: WO-1001 material totals 660.00 U, 6.6% of its allowed cost, but its price (2.6%) and usage (4.0%) are each under the limit, so it is shown and not asked about. The sheet gives no reason for any difference. The controller verifies the arithmetic, and operations confirms any explanation.
Where it fits
- Manufacturing, where standard costs are the yardstick and the close is when the gaps get explained.
- Hardware and physical technology, for product makers who run builds against a costed bill of materials and routing.
- Consumer brands, for brands that make their own goods and watch product cost closely.
- Finance and accounting, which owns the cost records and the close.
- Established businesses, where the plant has run long enough to have standards worth measuring against.
- Private equity & portfolios, where a portfolio plant reports the same variance view to its owners every period.
It sits beside two related capabilities and does not replace them. Budget-versus-actual variance commentary works from budget lines in the results; this one works from unit standards by order. Cost of poor quality worksheet sorts rework, scrap and return costs; this one never says why material or hours ran over.
What has to change for your company
Map your own column names and cost-card layout to the default headers. Set the review limits, the percentage and the amount a difference must reach before it becomes a question. Say who in operations answers material, labor, overhead and missing-posting questions. Confirm that overhead is applied on labor hours in your plant; if it is applied on machine hours or another base, the overhead rule needs rewriting before use. Decide whether the over-limit test is applied to the parts only (the default) or to totals as well, and whether the plant's fixed overhead needs a spending and volume split. Decide whether orders are listed by order number or by product, and who receives the finished sheet.
What has been checked
Fully Powered AI wrote this capability template. It was editorially reviewed on 10 November 2026. It was tried once, with Claude, on its invented example on 10 November 2026, and the record is published with it. That run was not blind: the model had seen the published example and an earlier run before it worked the arithmetic. No stop condition came up in the run. It has not yet been tested in a client environment or as a packaged version in ChatGPT, Claude, Copilot or Gemini.
Testing in your environment means running it on a closed period your controller already knows, with cases written in advance: an order with no labor posting, a standard that changed mid-order, a header that does not match. The controller recomputes every variance by hand before anyone relies on the sheet. Pilot acceptance-test preparation builds that test set, and what we test before we call an AI workflow ready shows the record we keep.
The full capability template
Everything above is the outline. The complete capability template is the working version: the roles, the inputs, the procedure, the exceptions and stop conditions, the output format, the reviewer checklist, the acceptance tests, the instructions for an AI assistant and what to customize for your company. It comes with a download and the link to its folder in Fully Powered’s public repository.
Free with an account. Sign in by email: no password and no card.
Next step
Put this capability to work for your team: on your plan, or built with you in a sprint.
Build this in a sprint
In a sprint, Fully Powered adapts this capability template to your rules, proves it on your own work and puts it in the hands of the roles that own it.
Two ways to begin: