Cost of Goods Sold (COGS) Calculator
Calculate COGS using beginning inventory, purchases, and ending inventory. Compare FIFO, LIFO, and weighted-average methods with gross profit analysis.
Calculate variable and fixed overhead variances: spending, efficiency, budget, and volume. Perform four-way overhead variance analysis for complete manufacturing cost control.
| Variance | Amount | F/U | % of Applied |
|---|---|---|---|
| VOH Spending ($8.16/hr โ $8.00/hr) ร 9,800.00 hrs | $1,600.00 | U | 0.9% |
| VOH Efficiency (9,800.00 โ 9,600.00) hrs ร $8.00/hr | $1,600.00 | U | 0.9% |
| VOH Total | $3,200.00 | U | 1.9% |
| FOH Budget $103,000.00 โ $100,000.00 | $3,000.00 | U | 1.7% |
| FOH Volume (10,000.00 โ 9,600.00) hrs ร $10.00/hr | $4,000.00 | U | 2.3% |
| FOH Total | $7,000.00 | U | 4.1% |
| Grand Total | $10,200.00 | U | 5.9% |
| Capacity % | Std Hours | Applied FOH | Volume Variance | Utilization |
|---|---|---|---|---|
| 60% | 6,000.00 | $60,000.00 | $40,000.00 U | 60% |
| 70% | 7,000.00 | $70,000.00 | $30,000.00 U | 70% |
| 80% | 8,000.00 | $80,000.00 | $20,000.00 U | 80% |
| 90% | 9,000.00 | $90,000.00 | $10,000.00 U | 90% |
| 100% | 10,000.00 | $100,000.00 | $0.00 F | 100% |
| 110% | 11,000.00 | $110,000.00 | $10,000.00 F | 110% |
| 120% | 12,000.00 | $120,000.00 | $20,000.00 F | 120% |
Overhead variance analysis decomposes the difference between actual overhead costs incurred and overhead applied to production into meaningful components. Variable overhead produces spending and efficiency variances. Fixed overhead produces budget and volume variances. Together, this four-way analysis provides complete insight into overhead cost control.
The variable overhead spending variance measures whether you paid more or less per hour of activity than the standard rate. The variable overhead efficiency variance is driven by labor or machine hour efficiency โ it's the overhead cost of using more or fewer hours than standard. The fixed overhead budget variance compares actual fixed overhead to budgeted. The fixed overhead volume variance measures the cost of operating above or below the denominator activity level used to set the fixed overhead rate.
This calculator performs the complete four-way overhead variance analysis with visual decomposition and capacity utilization insights.
Use the result to compare scenarios, test assumptions, and revisit the model when pricing, volume, or financing inputs change.
Overhead is often the largest and most complex manufacturing cost component. Unlike materials and labor, overhead contains many diverse costs (utilities, depreciation, supervision, maintenance) that behave differently. Variance analysis separates controllable variances (spending, efficiency) from volume-related variances that reflect capacity utilization decisions. Instant recalculation lets you test different assumptions side by side, giving you the confidence to act on data rather than gut instinct.
Variable OH Spending = (Actual Rate โ Std Rate) ร Actual Hours
Variable OH Efficiency = (Actual Hours โ Std Hours Allowed) ร Std VOH Rate
Fixed OH Budget = Actual FOH โ Budgeted FOH
Fixed OH Volume = (Denominator Hours โ Std Hours Allowed) ร Std FOH Rate
Std FOH Rate = Budgeted FOH รท Denominator HoursResult: $1,600 VOH spend F + $1,600 VOH eff U + $3,000 FOH budget U + $4,000 FOH volume U
SHA = 2 ร 4,800 = 9,600 hrs. VOH spending = ($80,000/9,800 โ $8) ร 9,800 = โ$1,600 F. VOH efficiency = (9,800 โ 9,600) ร $8 = $1,600 U. FOH rate = $100,000/10,000 = $10/hr. FOH budget = $103,000 โ $100,000 = $3,000 U. FOH volume = (10,000 โ 9,600) ร $10 = $4,000 U.
The four-way overhead variance framework is the most detailed and informative approach. Variable overhead gets spending and efficiency variances (analogous to price and quantity for materials). Fixed overhead gets budget and volume variances. This separation is critical because each variance has different causes, different responsible parties, and different corrective actions.
The FOH volume variance is fundamentally a measure of capacity utilization. If you budgeted 10,000 machine hours and only used 8,000, the volume variance shows the $20,000 cost of 2,000 unused capacity hours. This idle capacity cost is an important management metric, though it's not controllable at the operational level.
For cost control, focus on the spending variances (both VOH and FOH). These are directly controllable. Efficiency variance is controlled by the same actions that improve labor efficiency. Volume variance requires sales or strategic decisions. A complete overhead variance report, combined with material and labor variances, gives management a better view of manufacturing cost performance.
Last updated:
The fixed overhead rate is based on a denominator activity level (expected capacity). If actual production differs from this level, the amount of fixed overhead applied differs from the budget. The volume variance captures this difference. It measures the cost of unused capacity (unfavorable) or extra capacity utilized (favorable).
Four-way separates VOH into spending + efficiency and FOH into budget + volume (4 variances). Three-way combines VOH spending and FOH budget into a single "spending" variance, plus VOH efficiency and FOH volume (3 variances). Two-way combines further into budget (spending + efficiency) and volume. Four-way provides the most detail.
The volume variance reflects capacity utilization, which is typically a senior management or sales responsibility โ not a production floor issue. Low production volume (unfavorable volume variance) may result from weak sales demand, not from manufacturing inefficiency. This is why many companies report volume variance separately from controllable variances.
Using practical capacity (maximum sustainable output) as the denominator creates a lower fixed OH rate and a larger volume variance during normal operations. Using normal capacity (average expected over years) creates a higher rate and smaller volume variance. The choice affects product costing and the visibility of unused capacity cost.
Actual variable overhead cost per hour exceeds the standard rate. Causes include utility rate increases, higher supply costs, maintenance material cost increases, or unanticipated variable overhead items. It's the overhead equivalent of the material price variance.
Under absorption costing, applied overhead (standard rate ร standard hours allowed) flows to product cost. All four variances together explain the difference between applied and actual overhead. At period end, the net overhead variance (over/under-applied) is typically closed to COGS.
Calculate COGS using beginning inventory, purchases, and ending inventory. Compare FIFO, LIFO, and weighted-average methods with gross profit analysis.
Classify and analyze direct vs. indirect costs. Calculate cost ratios, overhead burden, and model cost structure scenarios for better pricing and profitability decisions.
Classify fixed and variable costs, calculate cost behavior ratios, and analyze how total costs change with volume. Includes high-low method and break-even analysis.