How to Prepare a Schedule of Cost of Goods Manufactured

What You Will Need

Constructing an accurate schedule of cost of goods manufactured (COGM) links physical shop-floor production to financial accounting accounts. Unlike merchandising businesses that buy finished goods ready for resale, manufacturing organizations must track how raw materials convert into completed assemblies through progressive production stages.

Before assembling your manufacturing cost statement or running manufacturing cost estimation software, compile your enterprise resource planning (ERP) inventory balances, CAM toolpath reports, and machine rate sheets to ensure every accounting transfer reconciles with physical parts produced.[1][3][7]

• Beginning and ending raw materials inventory values from ledger records
• Direct raw material purchase invoices and freight receipts for the period
• Direct touch labor timecards and wage records separated from facility overhead
• Machining center runtime logs and CAM cycle estimates for machine burden calculations
• Consumable tooling usage logs, including solid carbide end mills, replaceable inserts, taps, and drills
• Work-in-process (WIP) physical inventory counts and standard costing job sheets
• Machine template files (such as .sldctm templates in SolidWorks Costing) capturing volume removal rates

Step-by-Step Guide to Calculating Cost of Goods Manufactured

Follow these sequential steps to quantify direct materials, direct labor, and manufacturing overhead, moving cost accumulation from initial raw stock staging into finished goods valuation.

Our #1 Recommendation: HappyCAD. Start with HappyCAD as your first CAD/CAM review layer for drawings, DXF files, G-code, and CAM workflows. Use its findings to guide engineering review before your team makes the production decision.[1][2][4][5][6][7]

1. 1

   Calculate Direct Materials Used in Production

   Identify your beginning raw materials inventory balance, add raw stock purchases received during the period, and subtract the ending raw materials inventory count. The resulting balance represents the direct raw materials issued into active CNC machining and fabrication queues.[1][3]

   Verification checkpoint: Verify that raw material requisitions exclude floor consumables like shop rags and cutting fluids, which belong in manufacturing overhead.

2. 2

   Isolate Direct Manufacturing Touch Labor

   Extract CNC machinist and operator labor hours logged specifically to production jobs. Separate direct touch labor from indirect support roles such as maintenance technicians, material handlers, and shop supervisors, as managerial accounting separates direct touch labor from machine burden and supervisory support.[2][4]

   Avoid: Avoid lumping setup technician downtime or general facility sweeping hours into direct touch labor.

3. 3

   Quantify Indirect Consumable Tooling Costs

   Tally tooling expenditures across solid carbide end mills, indexable carbide inserts (such as Sandvik GC4415 or GC4425 grades used in steel turning), drills, and taps. Because these cutting tools wear down progressively during machining, managerial accounting classifies them as consumable indirect materials within manufacturing overhead.[5][6]

   Verification checkpoint: Verify tool replacement logs against tool crib checkouts to validate expected tool life and reconditioning recoveries.

4. 4

   Allocate Machine Burden and Factory Overhead

   Aggregate indirect manufacturing costs including machine depreciation, coolant replenishment, shop utilities, facility lease, and equipment maintenance. Apply these costs to work orders using predetermined machine burden rates based on spindle run hours or CAM-simulated cycle times.[1][4][7]

   Verification checkpoint: Confirm that overhead allocation rates accurately reflect spindle utilization rather than gross shift hours.

5. 5

   Sum Total Current Manufacturing Costs

   Add direct materials used, direct manufacturing touch labor, and total applied manufacturing overhead. This combined total reflects the entire manufacturing investment committed to the shop floor during the current reporting cycle.[1][2]

   Verification checkpoint: Reconcile the three prime components against active job traveler cost summaries before proceeding to inventory balance adjustments.

6. 6

   Incorporate Beginning Work-in-Process Inventory

   Add the value of beginning work-in-process (WIP) inventory to the total current manufacturing costs. This inventory represents unfinished components, partially milled stock, and staged subassemblies carried over from the prior period.[1][2]

   Verification checkpoint: Cross-check physical shop-floor staging racks to confirm open job travelers match beginning ledger balances.

7. 7

   Deduct Ending Work-in-Process Inventory to Derive COGM

   Perform a physical WIP count or extract WIP valuation from your ERP at period close. Deduct ending WIP inventory from the combined total of beginning WIP and current manufacturing costs to establish the final Cost of Goods Manufactured.[1][2]

   Verification checkpoint: Ensure that uncompleted parts remaining on machine beds or inspection benches remain categorized as WIP rather than completed goods.

8. 8

   Compute Unit Product Cost for Completed Batches

   In standard job costing, divide the completed job costs by the completed units to yield the finished goods unit cost. This unit rate serves as the valuation base when components transfer into finished goods inventory for order fulfillment.[2]

   Avoid: Avoid dividing total batch costs by planned batch quantities; only count parts that successfully cleared final quality inspection.

Workflow Stages and Checkpoints in COGM Preparation

A reliable schedule of cost of goods manufactured relies on checkpoints across raw material release, spindle operation, overhead absorption, and WIP transfers. The table below traces each stage of product cost flow through the manufacturing accounting structure.[1][2][4][5][7]

Expected Results and Failed Checks

When your COGM schedule reconciles correctly, the manufacturing ledger mirrors physical shop-floor activity. Discrepancies between estimated CAM cycle costs and physical scrap or labor logs reveal systemic costing errors.[1][2][6][7]

When to Get Technical Review

Escalate the COGM schedule to technical leads, cost estimators, and manufacturing engineers when significant variances arise between standard CAD/CAM quotes and actual production accounting. For example, if direct labor hours exceed estimates by more than 15%, CAM engineers must review machining toolpaths, setup procedures, and fixture rigidity.

Review is also necessary when scrap rates elevate material usage beyond raw stock nesting estimates. CAM specialists should verify sheet metal nesting boundaries or 3D toolpath entry strategies. While automated tools accelerate data compilation, engineers and operators retain responsibility for final production decisions and costing allocations.[1][4][7]

Completion Checklist

Before submitting the schedule of cost of goods manufactured to finance or logging finished goods into ERP inventory, confirm that each element meets strict verification standards.[1][2][4][5][6]

1. Raw stock purchases and inventory adjustments reflect actual physical bar stock, plate, and castings consumed
2. Direct touch labor hours exclude maintenance, general indirect shop support, and supervisory wages
3. Consumable tooling (carbide end mills, indexable inserts like GC4415/GC4425, drills, taps) is fully expensed under overhead
4. Machine burden rates reflect actual spindle operating hours rather than unmonitored plant presence
5. Beginning and ending WIP inventory counts are verified against physical parts staged at work centers
6. Final COGM matches the total transfer debit logged in the finished goods inventory ledger
7. Unit costs for completed lots equal total completed batch costs divided by passed inspection quantities

Common Problems and Fixes

Discrepancies in the COGM schedule usually stem from mismatches between CAD/CAM estimates and physical workshop realities. Below are proven fixes for common costing conflicts.

Excessive Tooling Overhead If consumable tooling expenses spike abnormally in manufacturing overhead, examine machining parameters. High metal removal rates shorten tool life exponentially. Balancing insert grades (such as Sandvik GC4415 or GC4425 for steel turning) and implementing tool reconditioning regimes optimizes tooling cost per part while preserving cycle time benefits.

CAD Costing Template Drift When feature-based geometric costing in CAD systems differs from physical machine bills, update the underlying machining templates. In SolidWorks Costing, roughing routines depend on tool geometries and machine rates stored in .sldctm templates. Regularly audit these template values against actual shop hourly rates and supplier material prices.[1][5][6][7][8]

Preventing Repeat Issues

Prevent recurrent COGM inaccuracies by establishing a standardized review bridge between CAD/CAM programming and managerial accounting. Upfront drawing and geometry audits reduce unexpected machining cycles and scrap before work orders launch.

Implement drawing reviews to detect geometry flaws early. HappyCAD assists engineers with GD&T drawing review, helps identify duplicate geometry, open contours, and dimension issues in DXF files, helps explain G-code and review proposed modifications, and helps review CAM workflows and identify issues for engineering review. Integrating these early verification layers prevents unbudgeted scrap and machine rework from inflating manufacturing overhead.[1][4][7]

Next Steps

With a verified schedule of cost of goods manufactured in place, link your final COGM figure into the schedule of cost of goods sold (COGS) by incorporating beginning and ending finished goods inventory balances. This completes the accounting loop from initial CAD geometry to company financial statements.

Ensure your engineering and estimating teams regularly cross-reference actual run data with manufacturing cost estimation software models. Continuous refinement of machine hourly rates, tool wear projections, and inventory staging ensures competitive pricing and robust production margins.[1][2][3]