BlogProduction
Actual production order cost: worksheet, open items and variances
A completed production order may still have open costs. Preserve the planned reference and explain the consumption, hours and rules behind recorded costs.
Editable order cost sheet and close checks
Review net consumption, rates, overhead, an open document and accepted units. Fictional data and ten cases; observed results remain blank.
What belongs in a production order cost sheet
The sheet needs an order reference, product or variant, planned version, quantities, cost sources and review status. KEPLER publishes planned and actual costing by order using raw materials, labor, overhead, time and recorded consumption. That list helps prepare questions; it does not establish that costs are complete when production marks an order finished.
In Odoo 18, planned cost depends on the bill of materials and operations; actual cost may differ because of components, duration and employee rates. The documentation states that the planned column updates to actual cost on completion. If you need comparison with the originally approved estimate, request a preserved reference or export of that version, then test the version you will use.
| Element | Required record | Decision before calculation |
|---|---|---|
| Direct material | Issues, returns, net quantity and applied value | Valuation method and reference date |
| Labor | Hours by operation, person or team and rate | What the rate includes; avoid duplicate time |
| Manufacturing overhead | Applied basis, rate and rule version | Included expenses and allocation method |
| External service | Order, receipt or approval and document | When it is reviewed and what remains open |
| Units and close | Accepted, held, lost and cost status | Denominator and treatment of each outcome |
Direct material, direct labor and overhead are the three groups to distinguish in the exercise. An external service may fall within them under your policy; it appears separately to track its document without adding it again elsewhere. Your accounting owner validates valuation, allocation and tax treatment. The worksheet checks business records rather than certifying accounts.
Fictional example: 1,900 planned and 2,200 recorded
| Item | Planned MXN | Recorded MXN | Explanation |
|---|---|---|---|
| Material | 10 kg × 100 = 1,000 | (12 kg issued − 1 returned) × 100 = 1,100 | One additional net kilogram |
| Labor | 2 h × 200 = 400 | 2.5 h × 200 = 500 | Half an additional hour |
| Applied overhead | 2 h × 150 = 300 | 2.5 h × 150 = 375 | Same hourly basis in this exercise |
| External finishing | 200 | 225 | Reviewed document for 225 |
| Total | 1,900 | 2,200 | Variance +300 |
| Accepted units | 100 | 90 | Do not confuse planned with accepted quantity |
The variance of 300 consists of 100 more in material, 100 in labor, 75 in overhead and 25 in finishing. Planned cost was 1,900 ÷ 100 = 19 per unit. Under the stated allocation, recorded cost is 2,200 ÷ 90 = 24.44 MXN per accepted unit, rounded for display. Preserve calculation precision; multiplying the displayed amount by ninety may not reconstruct the total exactly.
Finished production does not mean a closed cost sheet
Before receiving and reviewing the finishing document, OP-48 has 1,975 of verified included costs and finishing still open. Its estimate was 200, but do not record that as confirmed actual cost or as zero. Show subtotal, open estimate and owner. Once the document for 225 is approved, total cost becomes 2,200; paying that document later does not add another 225 to cost.
| State | What may be stated | What remains |
|---|---|---|
| Planned | Approved reference of 1,900 for 100 units | Record execution |
| Partial execution | Known consumption and time at the cutoff | Remaining production and sources |
| Production finished; costs open | 90 accepted; verified subtotal 1,975 | Finishing document and review |
| Costs reviewed for this scope | Total 2,200; documented unit-cost basis | Any additional company-required validation |
Scrap, rework and overhead: avoid counting the same cost twice
The eleven kilograms and 2.5 hours already include the example lot's effort. Adding another 10 × 19 as a “scrap cost” would duplicate an amount without another source. Preserve the ten lost units and reason without inventing a second expenditure. If your business separates loss, recovery or rework for another treatment, it needs a validated rule and references explaining allocation.
Also verify that the overhead rate does not include an expense added again separately. This exercise applies one basis of 2.5 hours; an entire general electricity bill is not assigned to OP-48 on top of a rate already covering it. Different footwear sizes can consume different amounts: do not average all variants without defining their allocation.
Editable sheet for planned, recorded and open order costs
Download the production order cost worksheet. It contains quantities, units, rates, example calculations, references and expected states, with blank fields for observations from your rehearsal. It does not execute formulas: copy anonymized records, verify every multiplication and total, and agree what approved means before using it to decide prices.
The order cost calculator helps compare amounts and units. Keep open costs unconfirmed and use the agreed denominator; calculation does not replace document review or allocation policy.
- Normal: reconstruct 11 net kg, 2.5 hours and the document for 225; total should be 2,200.
- Exception: keep finishing open without presenting the subtotal of 1,975 as final cost.
- Retry: import the same FAC-7 document twice; one cost of 225 remains, with visible attempts.
- Correction: an authorized late cost of 50 creates a revision of 2,250 and 25 per accepted unit; retain the earlier 2,200 close and the 1,900 budget.
- Denominator: if no units are accepted or held quantities remain unresolved, do not display division by zero or label them good to reduce unit cost.
Two different documents with the same amount are not necessarily duplicates. Use supplier, reference, order and item to decide. If you reopen a closed sheet, retain authorization, changes and reports requiring review. Do not release inventory again or record the same time twice when recalculating cost.
What to prepare when evaluating order costing software
Bring one completed order with its budget, issues and returns, hours, external services and accepted quantities; add another with a missing document. Production and accounting should define currency, valuation, overhead basis and close ownership. For shared data across variants, agree an allocation before requesting an “exact cost” dashboard.
The scrap guide explains physical balance; rework follows recovered units, and production stage tracking organizes progress and consumption. A free consultation about manufacturing software can review how to preserve sources, open items and versions of your cost sheet.
Frequently asked questions
The exercise distinguishes direct material, direct labor and manufacturing overhead. An external service must follow your business's validated classification and be counted once.
No. Planned cost is an approved reference; recorded cost uses execution and reviewed sources. Preserve the original reference even if software recalculates its displays when the order closes.
That depends on the agreed allocation and what you intend to measure. The example declares 90 accepted units and allocates all included costs to them. It is not a universal accounting policy.
No. Preserve an open review state and separate the estimate from confirmed amounts. The known subtotal must not be presented as a complete close.
Not by itself. Physical loss and already recorded cost are different views. An additional charge needs a source and rule that avoid duplicating included material, time or expenses.
Sources
Last updated: