Cost of Goods Manufactured (COGM) Excel Template

Written by True Tamplin, BSc, CEPF®

Reviewed by Subject Matter Experts

Updated on February 05, 2024

Introduction

Definition of Cost of Goods Manufactured (COGM)

COGM, also known as the cost of goods produced, is a financial metric that represents the total cost incurred by a company to manufacture or produce goods during a specific accounting period.

It encompasses all expenses related to the production process, including direct materials, direct labor, and manufacturing overhead costs.

Importance of COGM in Financial Management

COGM plays a pivotal role in financial management as it provides crucial information for various financial statements, budgeting, and decision-making processes.

It helps in determining the cost of inventory, evaluating cost control measures, setting competitive prices, and assessing overall business performance.

Purpose and Objectives of Calculating COGM

  1. Inventory Valuation: COGM is essential for accurately valuing the inventory on the balance sheet. It ensures that the cost of goods sold (COGS) reflects the actual production cost.
  2. Income Statement Preparation: COGM contributes to the preparation of the income statement by calculating the cost of goods sold, a key component of determining net income.
  3. Cost Control and Budgeting: Companies use COGM to monitor and control production costs. It aids in setting budgetary targets and identifying areas where cost reductions can be achieved.
  4. Pricing Decisions: Understanding the cost of goods manufactured is crucial when making pricing decisions. Companies need to ensure that their selling prices cover production costs and generate a profit.
  5. Financial Analysis and Performance Evaluation: COGM helps financial analysts and stakeholders assess a company's performance, profitability, and efficiency in the production process.

Components of COGM

COGM comprises several components that collectively represent the total cost of manufacturing. Let's explore these components in detail.

Direct Materials Costs

  1. Definition: Direct materials costs refer to the expenses incurred for the raw materials or components that are directly used in the manufacturing process. These materials are essential and can be traced directly to the finished product.
  2. Calculation and Measurement: Calculating direct materials costs involves summing the cost of all materials used in production, including purchases, transportation, and any applicable taxes.
  3. Examples: Examples of direct materials costs include the cost of steel in automobile manufacturing, fabric in clothing production, or flour in baking.

Direct Labor Costs

  1. Definition: Direct labor costs represent the wages and benefits paid to employees who are directly involved in the production process. These employees contribute to the transformation of raw materials into finished goods.
  2. Calculation and Measurement: Calculating direct labor costs requires tracking the hours worked by direct labor employees and multiplying them by their hourly wage rates or salaries.
  3. Examples: Direct labor costs include wages paid to assembly line workers, machine operators, and technicians involved in the manufacturing process.

Manufacturing Overhead Costs

  1. Definition: Manufacturing overhead costs encompass all indirect costs associated with production that cannot be directly traced to a specific product. These costs include rent, utilities, depreciation, and other expenses related to the production facility.
  2. Calculation and Allocation Methods: Allocating manufacturing overhead costs to products can be challenging. Common methods include using predetermined overhead rates based on machine hours, labor hours, or production volume.
  3. Examples: Manufacturing overhead costs may include rent for the production facility, depreciation of production equipment, and utility expenses.

Work in Progress (WIP) Inventory

  1. Definition and Significance: Work in Progress (WIP) inventory represents partially completed goods that are in various stages of the production process. It is significant as it reflects the value of materials and labor invested in unfinished products.
  2. Valuation Methods: WIP inventory can be valued using the weighted average cost method or the specific identification method, depending on the nature of the production process.
  3. Role in COGM Calculation: Changes in the WIP inventory levels between the beginning and end of the accounting period affect the calculation of COGM.

Beginning and Ending Finished Goods Inventory

  1. Definitions and Significance: Finished goods inventory comprises the completed products ready for sale. The beginning and ending finished goods inventory values are essential for calculating COGM accurately.
  2. Role in COGM Calculation: Changes in the finished goods inventory levels impact COGM calculation, as they represent the goods produced but not yet sold.

Calculating COGM

Step-by-step Calculation Process

Calculating COGM involves several steps, ensuring that all relevant components are considered accurately. Here is a step-by-step process for calculating COGM:

  1. Summing Direct Materials, Direct Labor, and Overhead Costs: Add up the total direct materials, direct labor, and manufacturing overhead costs incurred during the accounting period.
  2. Adjusting for Changes in WIP Inventory: Determine the change in WIP inventory between the beginning and end of the period. Subtract the decrease in WIP inventory (if any) and add the increase in WIP inventory (if any) to the total cost.
  3. Accounting for Changes in Finished Goods Inventory: Calculate the change in finished goods inventory between the beginning and end of the period. Subtract the decrease in finished goods inventory (if any) and add the increase in finished goods inventory (if any) to the total cost.
  4. Formula for Determining COGM: Use the following formula to calculate COGM:

    COGM = (Total Direct Materials + Total Direct Labor + Total Manufacturing Overhead) - (Change in WIP Inventory + Change in Finished Goods Inventory)

Example Calculation

Let's illustrate the COGM calculation with a hypothetical example:

  • Total Direct Materials Cost: $50,000
  • Total Direct Labor Cost: $30,000
  • Total Manufacturing Overhead Cost: $20,000
  • Change in WIP Inventory (Increase): $5,000
  • Change in Finished Goods Inventory (Decrease): $3,000

Using the formula mentioned above:

COGM = ($50,000 + $30,000 + $20,000) - ($5,000 - $3,000) = $102,000

In this example, the Cost of Goods Manufactured for the accounting period is $102,000.

Significance and Use of COGM

COGM serves various purposes and holds significant importance in financial management and decision-making. Let's explore how COGM is used in different aspects of business operations:

Income Statement Preparation

COGM is a fundamental component in the preparation of the income statement. It represents the cost of goods sold (COGS), which is subtracted from total revenues to calculate gross profit. Gross profit is a key indicator of a company's profitability and operational efficiency.

Inventory Valuation

COGM is crucial for accurately valuing inventory on the balance sheet. It ensures that the cost of goods sold (COGS) reflects the actual production cost. Accurate inventory valuation is essential for financial reporting and tax purposes.

Cost Control and Budgeting

Companies use COGM as a tool for monitoring and controlling production costs. By comparing actual COGM to budgeted COGM, organizations can identify cost overruns and implement cost-saving measures.

Pricing Decisions

Understanding the cost of goods manufactured is essential when making pricing decisions. Companies need to ensure that their selling prices cover production costs, including COGM, and generate a profit.

Financial Analysis and Performance Evaluation

Financial analysts, investors, and stakeholders use COGM to assess a company's performance, profitability, and efficiency in the production process.

It provides insights into how effectively a company manages its resources and controls production costs.

Recording COGM in Financial Statements

Income Statement

COGM is typically included in the income statement as a separate line item. It appears as the cost of goods sold (COGS), which is subtracted from total revenue to calculate gross profit.

The income statement also shows the net income after deducting all operating expenses.

Balance Sheet

On the balance sheet, COGM indirectly affects the values of inventory accounts. It ensures that the value of inventory reflects the actual production cost.

Changes in WIP inventory and finished goods inventory are recorded on the balance sheet, affecting the overall financial position of the company.

Cash Flow Statement

COGM indirectly impacts the cash flow statement as changes in inventory values can affect cash flows. An increase in WIP or finished goods inventory can tie up cash, while a decrease can release cash.

Challenges and Issues

Variability in Manufacturing Processes

Manufacturing processes can be highly variable, leading to challenges in accurately allocating overhead costs and determining the actual cost of production.

Changes in production volume, equipment breakdowns, and process variations can complicate COGM calculations.

Allocating Overhead Costs

Allocating manufacturing overhead costs to products can be complex, as there are multiple methods available.

Companies must choose an allocation method that best reflects the true consumption of overhead resources by each product.

Determining Appropriate Inventory Valuation Methods

Selecting the right inventory valuation method, such as FIFO (First-In-First-Out) or LIFO (Last-In-First-Out), can impact COGM and financial reporting.

The choice of method should align with the company's accounting policies and regulatory requirements.

Impact of External Factors on COGM

External factors, such as inflation, exchange rates, and changes in supplier costs, can affect the components of COGM, making it challenging to maintain consistent and accurate calculations.

COGM in Different Industries

Manufacturing vs. Service Industries

While COGM is primarily associated with manufacturing industries, service-based businesses may not have traditional COGM calculations.

Instead, they focus on cost of services rendered, which includes labor, materials, and overhead associated with delivering services.

COGM in Industries with Unique Cost Structures

Certain industries, like construction and aerospace, have unique cost structures due to the complexity and customization of their products.

COGM calculations in these industries may involve specialized methods and considerations.

Conclusion

In conclusion, understanding and calculating the Cost of Goods Manufactured (COGM) is essential for businesses engaged in production.

COGM serves as a critical financial metric, influencing income statement preparation, inventory valuation, cost control, pricing decisions, and financial analysis.

While COGM calculation can be complex and challenging due to various factors, its accurate determination is crucial for effective financial management and decision-making.

In an ever-changing business landscape, companies must continually refine their COGM management and reporting practices to adapt to evolving production processes and external factors.

By doing so, they can maintain financial transparency and make informed strategic decisions that drive success in the competitive marketplace.

Downloadable Template

Download a copy of the Cost of Goods Manufactured Excel Template here.


About the Author

True Tamplin, BSc, CEPF®

Facebook Linkedin Instagram Twitter Youtube

True Tamplin is a published author, public speaker, CEO of UpDigital, and founder of Finance Strategists.

True is a Certified Educator in Personal Finance (CEPF®), author of The Handy Financial Ratios Guide, a member of the Society for Advancing Business Editing and Writing, contributes to his financial education site, Finance Strategists, and has spoken to various financial communities such as the CFA Institute, as well as university students like his Alma mater, Biola University, where he received a bachelor of science in business and data analytics.

To learn more about True, visit his personal website, view his author profile on Amazon, or check out his speaker profile on the CFA Institute website.

Our Services

  • Connect With a Financial Advisor

Find Advisor Near You