WIP variance: reconcile work in process and project costs

WIP variance compares recorded manufacturing work in process with a stated standard for the same unfinished work. First reconcile the recorded balance, then calculate what the remaining units should carry at their current production stage. A comparison with the full cost of completed units would overstate the allowance and hide differences.

State what WIP means in this report

Here WIP means manufacturing work in process, grouped by production order at a month-end cutoff. The report uses recorded materials and labor costs plus applied manufacturing overhead. Its comparison is the approved standard cost allowed for the units still unfinished, using separate material and conversion progress assumptions.

OpenStax's description of manufacturing product costs explains the flow: materials, labor and manufacturing overhead enter work in process, and completed product costs move into finished goods. The IRS inventory guidance also lists work in process among inventory categories. Its tax guidance does not determine a particular company's financial-reporting valuation policy.

Keep those purposes separate. This management variance is a diagnostic comparison. It is not a universal accounting adjustment, an inventory write-down calculation or a measure of unbilled services. The general variance analysis method provides the broader comparison framework.

Use two formulas and two independent checks

Closing recorded WIP = Opening recorded WIP + Materials added + Labor added + Overhead added − Completed costs transferred out

WIP variance = Closing recorded WIP − Standard cost allowed for closing unfinished production

The first formula proves the recorded balance rolled forward. The second asks whether that balance agrees with the declared standard. A correct rollforward can still contain an incorrect physical progress estimate, so neither check replaces the other.

Positive differences mean recorded costs exceed the allowance. Negative differences mean they fall below it. Use that direction consistently without assuming that every negative amount represents better production performance.

Start from production and cost exports

Take a production-order cost report, the closing WIP listing, material issues, labor charges and completion transfers for the same cutoff. Add the approved cost standards and operations' supported completion assessment. Preserve order, product, plant, date, units, cost category and valuation basis.

Match orders before aggregating. An order missing from one file should remain visible as an exception, rather than disappear from the comparison. Keep reclassifications and adjustments in their own columns if they exist. The simple example below assumes none, and all opening balances, additions and transfers use a consistent recorded-cost basis.

Do not compare gross order-to-date costs with only the units remaining in process. Completed production has already left WIP, even if the order itself is still open.

Worked example: reconcile three production orders

A US manufacturer closes September with three unfinished orders. These are the recorded cost movements, in USD. All dollar amounts are exact.

Order A closes at 20,000 + 30,000 + 12,000 + 6,000 − 40,000 = $28,000. The company rollforward is 35,000 + 60,000 + 28,000 + 14,000 − 81,000 = $56,000. That must match both the detailed closing WIP listing and the corresponding ledger control balance.

If the input columns B through F follow the order above, closing WIP in G2 is:

=B2+C2+D2+E2-F2

Fill down, then compare the sum with the independently exported closing balance. Transfers in this example go to finished goods; they do not become cost of goods sold simply because production finished.

Value the work that remains at standard

Operations confirms that material is added at the start of these orders. Every remaining unit therefore carries its full standard material amount. Labor and overhead are conversion costs and follow the supported conversion completion percentage.

The simplified standards below allow one conversion hour per completed unit. Standard labor is $100 per conversion hour and overhead is $50 per conversion hour. Equivalent conversion units therefore also represent allowed conversion hours in this example.

For order A, material is 100 × $150 = $15,000. Conversion units are 100 × 80% = 80, giving labor of 80 × $100 = $8,000 and overhead of 80 × $50 = $4,000. The standard allowance is $27,000.

Use the same cost scope on both sides. If recorded overhead uses another rate or activity base, disclose that difference and reconcile it separately. Overhead variance explains the rate, efficiency and absorption comparisons behind that review.

Compare the orders, then test the progress assumption

The $500 total conceals offsetting differences. Review A and B independently rather than dismissing them because they cancel. Finance traces the recorded costs; production confirms units, completion and material placement.

Now change one input: order A's supported conversion completion rises from 80% to 90%. Allowed conversion units rise from 80 to 90. Labor and overhead allowance rises by 10 × ($100 + $50) = $1,500, while material stays unchanged.

Order A's standard becomes $28,500, and total standard WIP becomes $57,000. With recorded WIP still $56,000, the total variance changes from positive $500 to negative $1,000. No recorded spending changed. The difference comes entirely from the progress assessment, which is why evidence for completion matters as much as arithmetic.

Where it goes wrong

• Full finished cost on unfinished units. Applying completed-unit conversion costs ignores remaining work.
• One completion percentage for everything. Material added at the start does not follow the same progress pattern as labor added throughout production.
• Mixed cutoffs. A completion recorded in one file after the reporting cutoff can leave costs and physical units in different periods.
• Net differences hiding order exceptions. The company total can look small while individual production orders need investigation.

The controller owns the valuation basis and ledger tie. Production owns the physical evidence, and cost accounting maintains standards. Together they explain whether a difference reflects usage, rates, progress or records. The resulting balance also feeds the inventory component of working capital.

Reconcile your WIP exports in Covirage

Bring your order cost movements, closing WIP listing, standards and supplied completion assessments. Covirage maps the columns, and its tools compute and check the comparisons; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See Covirage for industrial manufacturers for the supporting industry context.