Cost of Goods Sold (COGS) Calculator

Calculate Cost of Goods Sold (COGS) for manufacturers based on finished goods inventory shifts and Cost of Goods Manufactured (COGM).

Finished Goods & Cost of Goods Sold (COGS) Schedule

Total Manufacturing COGS
—
Expensed against Revenue
Goods Available for Sale
—
Beg FG + COGM
FG Inventory Delta
—
Beg FG - End FG

Manufacturing COGS Formula

COGS = Beginning Finished Goods Inventory + Cost of Goods Manufactured (COGM) - Ending Finished Goods Inventory
  • Goods Available for Sale = Beginning Finished Goods + Cost of Goods Manufactured.
  • COGS: Cost transferred to the income statement when goods are sold to customers.
  • Ending Finished Goods: Unsold inventory remaining on the balance sheet at period end.

Step-by-Step Worked Example

Scenario: Quarterly COGS schedule with $200,000 sales revenue

Calculation Steps:

  1. Goods Available for Sale = $25,000 + $115,000 = $140,000
  2. Cost of Goods Sold (COGS) = $140,000 - $20,000 = $120,000
  3. Gross Profit Margin ($) = $200,000 - $120,000 = $80,000
  4. Gross Profit Margin (%) = ($80,000 / $200,000) × 100 = 40.0%
Result: Cost of Goods Sold (COGS) is $120,000. Against $200,000 revenue, gross profit is $80,000 (40.0% gross margin).

How to Use This Calculator

  1. 1Enter beginning finished goods inventory balance.
  2. 2Input Cost of Goods Manufactured (COGM) for the period.
  3. 3Enter ending finished goods inventory balance.
  4. 4Optionally specify total sales revenue to calculate gross profit dollars and margin %.

Assumptions & Limitations

  • Assumes finished goods inventory is valued at manufacturing cost.
  • Excludes non-manufacturing operating expenses.

Frequently Asked Questions

How does manufacturing COGS differ from retail COGS?

Retailers calculate COGS by adding merchandise purchases to beginning inventory. Manufacturers must first calculate Cost of Goods Manufactured (materials + labor + factory overhead + WIP changes) before determining COGS.

Related Cost Calculators

Manufacturing Inventory Cost Calculator

Calculate the total valuation of manufacturing inventory across Raw Materials, Work-in-Process (WIP) at completion stages, and Finished Goods.

Manufacturing Profit Margin Calculator

Calculate gross manufacturing profit margins and operating profit margins by separating direct manufacturing costs from non-manufacturing SG&A expenses.

Cost of Goods Manufactured (COGM) Calculator

Calculate Cost of Goods Manufactured (COGM) schedules under GAAP absorption accounting, tracking raw materials, direct labor, and WIP inventory changes.