Schedule Of Cost Of Goods Manufactured Example

The schedule of cost of goods manufactured example is a vital tool for manufacturers seeking to track production expenses, evaluate efficiency, and determine the cost of items that move from work‑in‑process (WIP) to finished‑goods inventory. By presenting a clear, step‑by‑step breakdown of direct materials, direct labor, and manufacturing overhead, this schedule not only satisfies accounting standards but also equips managers with actionable insights for pricing, budgeting, and strategic decision‑making.

Introduction

In any manufacturing environment, understanding how costs flow through the production process is essential for accurate financial reporting and effective cost control. Day to day, while the concept may seem straightforward, many businesses struggle to assemble a comprehensive schedule that captures every cost component correctly. The cost of goods manufactured (COGM) schedule consolidates all production‑related expenses incurred during a specific period, culminating in the total cost of goods that have been completed. This article demystifies the COGM schedule, walks you through a detailed schedule of cost of goods manufactured example, and highlights common pitfalls to avoid.

What Is Cost of Goods Manufactured?

Cost of goods manufactured represents the total manufacturing cost of products that were completed during an accounting period. It differs from the cost of goods sold (COGS), which reflects the cost of inventory actually sold to customers. COGM is the bridge between the beginning and ending inventories of work in process (WIP) and is calculated as follows:

[ \text{COGM} = \text{Total Manufacturing Costs} + \text{Beginning WIP Inventory} - \text{Ending WIP Inventory} ]

• Total Manufacturing Costs = Direct Materials Used + Direct Labor + Manufacturing Overhead
• Direct Materials Used = Beginning Raw Materials + Purchases – Ending Raw Materials

Understanding each component is crucial because errors in any line item will distort the final COGM figure, leading to inaccurate financial statements and misguided managerial decisions.

Components of a Schedule of Cost of Goods Manufactured

A well‑structured schedule typically includes the following sections:

1. Direct Materials

   • Beginning raw‑materials inventory
   • Purchases of raw materials
   • Ending raw‑materials inventory
   • Direct materials used (the net amount that actually entered production)

2. Direct Labor

   • Wages paid to production workers
   • Payroll taxes and benefits directly tied to manufacturing labor

3. Manufacturing Overhead

   • Indirect materials (e.g., lubricants, cleaning supplies)
   • Indirect labor (e.g., supervisors, maintenance staff)
   • Utilities, depreciation of factory equipment, rent, insurance, and other factory‑related expenses

4. Work‑in‑Process (WIP) Inventory

   • Beginning WIP inventory
   • Ending WIP inventory

5. Cost of Goods Manufactured

   • The final total after adjusting for WIP changes

These sections are presented in a schedule of cost of goods manufactured format, making it easy for accountants, auditors, and managers to trace each cost element.

Detailed Schedule of Cost of Goods Manufactured Example

Below is a realistic example for a fictitious company, Acme Widgets, Inc., covering the month of June. All figures are in thousands of dollars unless otherwise noted.

How the Numbers Were Derived

• Direct Materials Used:
  (45 + 210 - 30 = 225)

• Total Direct Labor:
  Production wages of $120,000 plus payroll taxes/benefits of $18,000 equal $138,000.

• Manufacturing Overhead:
  Summing all indirect costs yields $75,000.

• Total Manufacturing Costs:
  (225 + 138 + 75 = 438)

• COGM Calculation:
  (438 + 20 - 35 = 423)

  Continue exploring with our guides on words that begin and end with w and wordly wise lesson 10 answers.

The final $423,000 represents the cost of all widgets that were completed in June and transferred from WIP to finished‑goods inventory.

Step‑by‑Step Guide to Preparing the Schedule

1. Gather Raw‑Materials Data

• Retrieve beginning raw‑materials balance from the prior period’s ending balance.
• Record all purchases during the period, including freight‑in and

2. Capture Direct‑Labor Hours and Rates

Pull the time‑cards or labor‑tracking system for every shop‑floor employee. Multiply each worker’s hourly rate by the total regular and overtime hours logged during the month. Add the employer’s share of payroll taxes, benefits, and any shift differentials. The resulting figure is the total direct‑labor cost that will flow into the schedule.

3. Compile All Manufacturing‑Overhead Items Create a master list of every expense that cannot be traced directly to a single unit:

• Indirect‑material purchases (e.g., lubricants, cleaning agents)
• Supervisory wages and other indirect‑labor costs
• Factory utilities such as electricity, water, and steam - Depreciation calculated on a straight‑line basis for machines and tooling - Factory rent and property taxes allocated to the production area
• Insurance covering plant property and equipment
• Repairs and maintenance of production equipment

Assign each line item to a cost‑pool, then total the pools to obtain the overall overhead charge for the period.

4. Determine Beginning and Ending Work‑In‑Process (WIP) Balances Locate the WIP ledger at the start of the month (opening balance) and at month‑end (closing balance). These amounts are usually derived from the WIP‑to‑Finished‑Goods reconciliation in the general ledger. If the system does not track WIP automatically, use the following formula:

[ \text{Opening WIP} = \text{Previous period’s ending WIP} ] [ \text{Closing WIP} = \text{Physical count of unfinished units} \times \text{Estimated cost per unit} ]

5. Compute the Cost of Goods Manufactured (COGM)

Apply the standard COGM equation:

[\text{COGM} = \text{Total Manufacturing Costs} + \text{Opening WIP} - \text{Closing WIP} ]

Where Total Manufacturing Costs equal the sum of Direct Materials Used, Total Direct Labor, and Total Manufacturing Overhead.

6. Cross‑Check with Cost of Goods Sold (COGS)

After the COGM figure is finalized, compare it to the COGS reported on the income statement. The reconciliation typically looks like:

[ \text{Beginning Finished‑Goods Inventory} + \text{COGM} - \text{Ending Finished‑Goods Inventory} = \text{COGS} ]

If the numbers do not align, revisit each component of the schedule—especially the WIP adjustments—as even a small mis‑allocation can cause a material variance.

7. Document Assumptions and Supporting Schedules

Prepare a short footnote that explains any estimates used, such as:

• The method chosen for depreciation (straight‑line vs. accelerated)
• The basis for allocating factory overhead (plant‑wide rate vs. departmental rates)
• The basis for valuing ending inventories (FIFO, weighted‑average, etc.)

Including these disclosures enhances auditability and provides context for management analysis.

Practical Example (Continued)

Assume the following additional figures for Acme Widgets:

• Beginning finished‑goods inventory: $80 k
• Ending finished‑goods inventory: $110 k Using the COGM of $423 k from the earlier table, the COGS calculation proceeds as:

[ 80 + 423 - 110 = 393 \text{ (thousand dollars)} ]

Thus, the income statement would reflect $393 k of cost of goods sold for June.

Common Pitfalls and How to Avoid Them

end WIP when the actual cut-off is at production completion | Align WIP timing with production schedules; adjust for any in-process units that cross the reporting period.

• Ignoring overhead variances - Fixed overhead applied using a standard rate may differ from actuals, creating a variance that should be analyzed and reported.

• Overlooking scrap and spoilage - These costs can be significant in manufacturing; ensure they are captured in the appropriate cost category.

Conclusion

Preparing an accurate cost of goods manufactured schedule is essential for understanding production efficiency, controlling costs, and ensuring reliable financial reporting. By systematically gathering data, classifying costs correctly, and reconciling inventory changes, accountants can produce a schedule that not only supports the income statement but also provides valuable insights for management decision-making. Attention to detail—especially in tracking work-in-process and allocating overhead—prevents common errors and enhances the credibility of the financial statements. With these practices in place, organizations can confidently use their COGM figures to drive operational improvements and strategic planning.

You might be surprised how often this gets overlooked.