COGS Calculator

Measure inventory costs, margins, and unit economics with clarity. Review each cost driver carefully for stronger accounting decisions.

Calculator Inputs

This calculator uses a responsive input grid: 3 columns on large screens, 2 on medium screens, and 1 on mobile.

Plotly Graph

The chart compares major inventory cost components, ending inventory, and the final COGS result.

Example Data Table

Item Example Value Notes
Opening Inventory $40,000 Carried from the previous period.
Purchases $120,000 Inventory acquired during the period.
Freight In $6,000 Inbound transportation cost added to inventory.
Purchase Returns $3,000 Returned goods reduce purchase cost.
Purchase Discounts $2,000 Supplier discounts reduce inventory cost.
Direct Labor $18,000 Production labor tied directly to manufactured goods.
Factory Overhead $12,000 Allocated manufacturing overhead.
Other Inventory Costs $4,000 Other capitalized inventory-related costs.
Closing Inventory $35,000 Unsold stock remaining at period end.
Calculated COGS $160,000 Based on the example formula below.

Formula Used

Net Purchases = Purchases + Freight In − Purchase Returns − Purchase Discounts

Goods Available for Sale = Opening Inventory + Net Purchases + Direct Labor + Factory Overhead + Other Inventory Costs

COGS = Goods Available for Sale − Closing Inventory

Gross Profit = Sales Revenue − COGS

Gross Margin (%) = (Gross Profit ÷ Sales Revenue) × 100

Unit COGS = COGS ÷ Units Sold

Inventory Turnover = COGS ÷ Average Inventory

This setup works well for merchandisers and also supports basic manufacturing cost additions like direct labor and overhead.

How to Use This Calculator

  1. Enter the accounting period name and preferred currency symbol.
  2. Fill in opening inventory, purchases, freight, returns, and discounts.
  3. Add direct labor, factory overhead, and any other inventory-related costs.
  4. Enter closing inventory, sales revenue, units produced, and units sold.
  5. Click Calculate COGS to view the result above the form.
  6. Review gross profit, gross margin, turnover, unit cost, and supporting metrics.
  7. Use the CSV button for spreadsheet analysis and the PDF button for reports.

FAQs

1. What does COGS mean?

COGS means cost of goods sold. It represents the direct inventory-related cost of products sold during a period, excluding most selling and administrative expenses.

2. Why is closing inventory subtracted?

Closing inventory remains unsold at period end. Because it is still an asset, it should stay on the balance sheet instead of being charged to the period’s cost of sales.

3. Should freight in be included in COGS?

Yes, freight in is commonly added to inventory cost because it helps bring goods to a saleable condition and location. That makes it part of cost available for sale.

4. Are purchase returns and discounts deducted?

Yes. Returns and purchase discounts reduce the effective cost of acquiring inventory. Deducting them gives a more accurate net purchase figure for COGS analysis.

5. Can manufacturers use this calculator?

Yes. Manufacturers can include direct labor, factory overhead, and other inventory costs. That makes the tool useful for estimating production-related cost of goods sold.

6. What is a good gross margin?

A good gross margin depends on industry, pricing power, and operating model. Compare your result with past periods and industry benchmarks rather than relying on one fixed percentage.

7. Why track unit COGS?

Unit COGS helps evaluate pricing, profitability, and production efficiency. It is especially helpful when comparing product lines, planning promotions, or setting future selling prices.

8. What happens if units sold is zero?

The calculator will still compute COGS totals, but unit COGS will return zero to avoid division errors. Enter units sold for meaningful per-unit analysis.

Related Calculators

net profit margin calculatorlanded cost calculatorsales margin calculatorprofit markup calculatorretail margin calculator

Important Note: All the Calculators listed in this site are for educational purpose only and we do not guarentee the accuracy of results. Please do consult with other sources as well.