This calculator uses direct materials, direct labor, and both variable and fixed manufacturing overhead to determine full product cost.
Cost Structure Graph
Example Data Table
| Direct Materials | Direct Labor | Variable MOH | Fixed MOH | Units Produced | Units Sold | Beg. Inv. Units | Beg. Inv. Cost/Unit | Selling Price/Unit |
|---|---|---|---|---|---|---|---|---|
| $45,000 | $32,000 | $16,000 | $22,000 | 5,000 | 4,200 | 300 | $21.50 | $30.00 |
| $58,000 | $37,500 | $19,500 | $25,000 | 6,200 | 5,600 | 400 | $22.75 | $33.00 |
| $39,500 | $27,200 | $14,300 | $18,500 | 4,300 | 3,850 | 250 | $20.90 | $28.50 |
Use these sample values to test cost allocation, inventory valuation, and profit analysis.
Formula Used
1) Current Manufacturing Cost
Current Manufacturing Cost = Direct Materials + Direct Labor + Variable Manufacturing Overhead + Fixed Manufacturing Overhead
2) Current Absorption Cost Per Unit
Current Absorption Cost Per Unit = Current Manufacturing Cost ÷ Units Produced
3) Goods Available Cost
Goods Available Cost = Beginning Inventory Value + Current Manufacturing Cost
4) Weighted Average Unit Cost
Weighted Average Unit Cost = Goods Available Cost ÷ Goods Available Units
5) Cost of Goods Sold
COGS = Units Sold × Weighted Average Unit Cost
6) Ending Inventory Value
Ending Inventory Value = Ending Inventory Units × Weighted Average Unit Cost
7) Gross Profit
Gross Profit = Sales Revenue − Cost of Goods Sold
8) Operating Income
Operating Income = Gross Profit − Variable Selling and Admin − Fixed Selling and Admin
How to Use This Calculator
Step 1: Enter total direct materials, direct labor, variable manufacturing overhead, and fixed manufacturing overhead for the period.
Step 2: Enter units produced, units sold, beginning inventory units, and beginning inventory cost per unit.
Step 3: Add selling price per unit plus variable and fixed selling and administrative expenses.
Step 4: Click the calculate button to display the result section above the form.
Step 5: Review full manufacturing cost, weighted average unit cost, COGS, ending inventory, gross profit, and operating income.
Step 6: Use the export buttons to save results as CSV or PDF for reporting, pricing reviews, or management analysis.
FAQs
1) What does absorption costing include?
Absorption costing includes direct materials, direct labor, variable manufacturing overhead, and fixed manufacturing overhead in product cost. It treats fixed factory overhead as inventoriable until units are sold.
2) Why is fixed manufacturing overhead included?
This method assigns all manufacturing costs to produced units. Fixed factory overhead becomes part of inventory first, then moves to cost of goods sold when inventory is sold.
3) Does this calculator use weighted average costing?
Yes. When beginning inventory exists, the calculator combines beginning inventory cost with current production cost and uses a weighted average finished goods unit cost.
4) What is the difference between COGS and ending inventory?
COGS is the cost assigned to sold units. Ending inventory is the manufacturing cost assigned to unsold units that remain on hand at period end.
5) Can I use this for pricing decisions?
Yes. The calculator helps estimate full unit cost, margins, and operating income. That supports markup planning, profitability analysis, and cost recovery decisions.
6) Are selling and administrative costs part of absorption cost?
No. Selling and administrative costs are period expenses. They affect operating income, but they are not included in inventory valuation or product manufacturing cost.
7) What happens if units sold exceed goods available?
The calculator stops and shows a validation message. Units sold cannot exceed beginning inventory units plus units produced for the same period.
8) When is absorption costing commonly required?
It is commonly used for external financial reporting, inventory valuation, standard cost analysis, management reviews, and manufacturing profitability reporting.