Cost of Goods Manufactured Calculator
Cost of goods manufactured is the total cost of the units that finished production in a period, whether or not they were sold. It feeds finished goods inventory and, once sold, cost of goods sold. This calculator walks the standard schedule from raw material to finished output.
Your numbers
Include freight-in and net of purchase returns and discounts.
Indirect labor, factory utilities, depreciation of plant equipment, supervision, indirect materials.
Your results
This calculator follows the standard managerial accounting schedule. Your costing policy (absorption rules, capitalized variances, scrap treatment) may change the inputs.
Unit cost vs units completed
Sweeps Units completed in period from 20000 to 100000, holding your other inputs fixed.
Automate the COGM schedule from your ERP
Optional: we review your cost accounts and show how the schedule can be produced directly from ERP data.
Optional. The tool and every export work without this. No spam.
How to use the calculator
Enter your period balances from the trial balance. Start with raw material beginning inventory, purchases and ending inventory to get direct materials used. Add direct labor and manufacturing overhead to get total manufacturing costs added, then adjust for the change in work in process. The result is COGM and the average cost per completed unit. Use the same period for every balance, and use units that actually completed, not units started.
- Use purchases net of returns and discounts, plus freight-in
- Overhead can be applied (at a predetermined rate) or actual, but be consistent
- Units completed excludes ending WIP, unless you convert WIP to equivalent units
- Run it monthly so the unit cost trend is visible
The formula and where COGM sits
COGM = beginning WIP + direct materials used + direct labor + manufacturing overhead - ending WIP. Direct materials used = beginning raw materials + purchases - ending raw materials. COGM then flows into the cost of goods sold schedule: beginning finished goods + COGM - ending finished goods = COGS. Mixing these up is the most common reporting error: COGM is production cost, COGS is cost of what you shipped.
Worked example and how to read it
With the default values, materials used are 625,000 and prime cost is 1,035,000. Adding 365,000 of overhead gives 1,400,000, and the 15,000 build in WIP lowers COGM to 1,385,000. Over 52,000 units that is about 26.63 per unit. Watch the overhead share: when it climbs while volume falls, fixed costs are spreading over fewer units, which the chart shows as unit cost rising at low volume.
Common mistakes and ERP notes
Do not include selling and administrative expense in COGM. Do not forget that standard cost systems carry variances: if your ERP posts purchase price, usage and efficiency variances to separate accounts, decide whether COGM is at standard or at actual. In SAP this sits in the production order settlement, in Infor SyteLine and Epicor in the job or work order close, and in NetSuite in the work order completion and variance postings. Reconcile the calculator to the general ledger before using the unit cost for pricing.
Frequently Asked Questions
What is the difference between COGM and COGS?
COGM is the cost of everything completed in production during the period. COGS is the cost of the goods actually sold. COGS equals beginning finished goods plus COGM minus ending finished goods, so the two differ by the change in finished goods inventory.
Does COGM include labor that is not direct?
Indirect labor such as supervisors, material handlers and maintenance on production equipment is part of manufacturing overhead, so it is included in COGM through the overhead line. Only direct labor goes on the direct labor line.
Should I use applied or actual overhead?
Either is valid, but be consistent with your books. With applied overhead, the over or under applied amount is usually cleared to COGS at period end. With actual overhead the unit cost moves with volume, which is why many plants prefer a predetermined rate.
Can I use this for a service or job shop?
Yes for a job shop, if you treat all completed jobs as the period output and enter units as jobs or standard hours. For a pure service business there is no manufacturing schedule, so COGM does not apply.
If your ERP already holds these balances, we can build a read-only view that produces the COGM schedule by plant and period without re-keying. Ask for an expert review of your costing flow.
Related Tools
Inventory Valuation Comparison Worksheet (FIFO, Average, Standard)
Compare ending inventory value under FIFO, weighted average and standard cost for each item, and see the total gap between methods.
Costing & FinanceWIP Inventory Valuation Worksheet (Standard Cost)
Value work in process at period end by job, using quantity, standard material and conversion cost, and percent complete for each.
Costing & FinanceDirect Labor Rate and Efficiency Variance Calculator
Break the difference between actual and standard direct labor cost into a rate variance and an efficiency variance.
Costing & FinanceManufacturing Month-End Close Checklist
A practical close checklist for manufacturing plants: cut-off, receipts, WIP, variances, overhead, inventory and reconciliations.
More Costing & Finance tools
See all- Manufacturing KPI Formula and Definitions Reference
- Manufacturing Cost Variance Types Reference
- Price, Volume and Cost Margin Variance Calculator
- Month End Reporting Readiness Checklist for Manufacturers
- OEE Improvement Value Calculator
- Improve OEE vs Buy a New Machine Calculator
- Six Sigma Project Savings Tracker Worksheet
- Should Cost Model Worksheet for Machined Parts
- Quote Assumptions and Exclusions Template