Enter production and cost data
Use the fields below to value unfinished goods, measure equivalent units, and reconcile production costs.
Example data table
These sample values match the default form inputs and demonstrate a typical weighted-average WIP valuation setup.
| Item | Example value |
|---|---|
| Opening WIP units | 250 |
| Units started | 1,200 |
| Completed units | 1,100 |
| Ending WIP units | 350 |
| Ending material completion | 80% |
| Ending labor completion | 55% |
| Ending overhead completion | 55% |
| Opening material, labor, overhead cost | $4,200, $1,800, $1,600 |
| Added material, labor, overhead cost | $21,000, $12,000, $9,500 |
| Calculated ending WIP cost | $8,821.55 |
Formula used
This calculator applies a weighted-average process costing approach to unfinished goods valuation.
- Total units to account for = Opening WIP units + Units started
- Total units accounted for = Completed units + Ending WIP units
- Equivalent units = Completed units + (Ending WIP units × Completion percentage)
- Total component cost = Opening component cost + Current period component cost
- Cost per equivalent unit = Total component cost ÷ Equivalent units
- Completed cost = Completed units × Sum of component cost rates
- Ending WIP cost = Sum of ending equivalent units × each component rate
- Cost reconciliation = Completed cost + Ending WIP cost
How to use this calculator
- Enter opening WIP units and units started for the period.
- Enter completed units and ending WIP units. These must reconcile with available units.
- Add ending completion percentages for materials, labor, and overhead.
- Enter opening costs and current period costs for each cost element.
- Click Calculate WIP to display cost assignment and reconciliation above the form.
- Use the CSV button for spreadsheet-friendly data and the PDF button for a printable report copy.
Frequently asked questions
1. What does work in progress mean in manufacturing?
Work in progress covers units that entered production but are not fully finished by period end. They contain partial material, labor, and overhead costs that still require valuation.
2. Which costing method does this calculator use?
It uses a weighted-average process costing method. Opening inventory costs and current period costs are blended before assigning values to completed units and ending WIP.
3. Why are completion percentages separated by cost element?
Materials often enter production earlier than labor or overhead. Separate percentages produce more accurate equivalent units and prevent distorted ending inventory values.
4. What happens if units do not reconcile?
The calculator shows an input error and stops the valuation. Reconcile opening units plus started units with completed units plus ending WIP before using the results.
5. Should completed units include transferred-out units?
Yes. Completed units should represent all units finished and transferred to the next department or to finished goods during the selected period.
6. Can I use this tool for monthly close reviews?
Yes. It is useful for monthly production reporting, inventory valuation, management review, and internal cost reconciliation when departments follow process costing.
7. Why does the calculator report cost differences?
Small differences may appear because displayed values are rounded. The underlying calculation uses unrounded values, which keeps the cost reconciliation mathematically consistent.
8. When should I export the report as CSV or PDF?
Use CSV when you need further analysis in spreadsheet software. Use PDF when you want a clean file for review packs, approvals, or archive records.