SmartHelping / Accounting / Excel
Absorption Costing Template
Understand the full manufacturing cost of each finished unit. Bring direct materials, direct labor and variable and fixed manufacturing overhead into one cost summary, then review profitability, break-even results and price-volume sensitivity.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
See the template in action
Walk through the costs, allocations and results.
Follow the video to see how production data, direct costs and manufacturing overhead feed the unit cost summary, income statement, break-even analysis and sensitivity table.
Template features
Connect manufacturing costs to unit economics.
Review the full cost of production, then evaluate how selling price and volume affect the result.
See the cost per unit and for the period
Bring direct materials, direct labor, variable manufacturing overhead and fixed manufacturing overhead into one absorption cost summary, with per-unit costs and totals for the period and units produced.
Connect overhead costs to production
Define cost drivers and application calculations for manufacturing overhead. Use direct labor hours, machine hours or units to translate overhead costs into a cost per finished unit.
Compare selling price and sales volume
Use the profitability sensitivity table to see how changes in units sold and selling price affect profit or loss.
Include selling and administrative costs
Review an example income statement for the period, with additional inputs for selling and administrative costs alongside the manufacturing cost analysis.
Review break-even production, revenue and price
See break-even units produced, break-even revenue and break-even price. The price calculation is based on units sold, while the units calculation shows the production volume needed.
Adapt the sections to your cost detail
The template includes extra rows across its sections for flexibility. Add or remove rows to fit the level of detail needed for your product and manufacturing process.
Cost components
Build the cost of a finished unit from the detail.
Start with the bill of materials and direct labor, then apply variable and fixed manufacturing overhead.
Build the bill of materials
Break down raw materials, subassemblies or components, packaging materials and consumables to calculate direct material cost per unit.
Calculate the labor required per unit
Enter direct labor hours to determine direct labor cost per unit. The labor-hours calculation also supports overhead drivers such as indirect labor cost per direct labor hour.
Apply the costs that vary with production
Define budgeted overhead costs and the relevant driver quantities, then apply the quantity required for one finished unit. The summary combines these costs with direct materials and labor into total variable cost per unit.
Allocate the fixed costs for the period
Include costs such as depreciation, building insurance and taxes, rent and lighting. Allocate the period total across production; adding fixed overhead per unit to total variable cost per unit gives the full absorption cost per unit.
Understanding manufacturing overhead
Turn overhead costs into a cost per unit.
The overhead sections help connect costs to the activity or production quantity that drives them. These examples show how the calculations work.
Direct labor hours
For indirect labor, define the cost per direct labor hour and multiply it by the direct labor hours required per unit. This converts the overhead into an indirect labor cost per finished unit.
Machine hours
For machine maintenance or electricity, define the total cost for a given number of machine hours. Apply the resulting hourly cost to the machine hours required per unit. A helper table supports the machine-hours-per-unit calculation.
Units as the driver
If $10,000 of indirect materials supports 1,000 units, the cost is $10 per unit. When the cost driver is already expressed per unit, the driver quantity for each finished unit is 1.
Fixed costs and timing
Enter total fixed manufacturing overhead for the same period as production. As units produced increase, the fixed cost per unit falls while the total fixed cost stays the same. Use a monthly, annual or other period consistently throughout the model. Variable overhead can start from a budgeted cost and driver quantity for another period, then be converted to the required per-unit basis.
How to use it
From production data to a profitability review.
Set the production period and volumes
Choose the period you want to analyze and enter units produced and units sold. Keep the period consistent with the fixed manufacturing costs you enter.
Build direct costs and overhead
Complete the bill of materials, direct labor hours, variable overhead drivers and fixed manufacturing overhead. Use the helper calculations to translate labor and machine time into per-unit quantities.
Review the absorption cost summary
Check direct material cost, direct labor cost, variable manufacturing overhead, total variable cost, fixed manufacturing overhead and total absorption cost per unit. Review the totals for the period as well.
Evaluate profit and break-even results
Use units sold multiplied by absorption cost per unit to calculate cost of goods sold for the analysis. Review the period income statement, add selling and administrative costs, and compare the break-even outputs and price-volume sensitivity table.
Who gets value from it
Built for the people producing, costing and pricing products.
Manufacturers
Understand the full cost of producing a finished unit, including direct costs and manufacturing overhead.
Cost accountants
Organize the bill of materials, labor and overhead allocations in a structured absorption costing analysis.
Operations teams
Connect production quantities, labor hours and machine hours to the cost per unit.
Owners and finance teams
Compare pricing, sales volume, profitability and the production levels needed to break even.
Also available in these bundles
Need more tools for costing and financial analysis?
This absorption costing template is included in the following SmartHelping collections.
Accounting Templates Bundle
Explore spreadsheets for accounting calculations, cost analysis and financial tracking.
View Accounting BundleManufacturing Templates Bundle
Explore templates for manufacturing costs, production planning and financial forecasts.
View Manufacturing BundleData Table Spreadsheets Bundle
Explore financial models and spreadsheets with sensitivity tables for comparing assumptions and outcomes.
View Data Table BundleSuper Smart Bundle
Get the complete SmartHelping template collection for operating forecasts, valuation, finance and more.
View Super Smart BundleRelated templates
Explore more costing and manufacturing tools.
Activity-based Costing Model
Allocate costs using activities and the drivers behind them.
Explore this templateJob Bidding Calculator
Estimate job costs and prepare a bid around the work required.
Explore this templateVolume Discount Pricing
Evaluate pricing across different purchase volumes and discount levels.
Explore this templateCash Conversion Cycle
Analyze the timing of inventory, receivables and payables through the cash conversion cycle.
Explore this templateBreak-even Analysis
Evaluate the sales and cost assumptions needed to reach break-even.
Explore this template21 Manufacturing Sensitivity Tables
Compare manufacturing assumptions with a collection of 21 sensitivity tables.
Explore this templateSimple Cost per Unit Calculator
Calculate the cost per unit with a simpler costing template.
Explore this templateManufacturing Plant Financial Model
Build a financial forecast for a manufacturing plant.
Explore this templateMade-to-Order Manufacturing Financial Model
Plan the financial performance of a made-to-order manufacturing business.
Explore this templateQuestions before you choose
A few useful details.
What does the absorption cost per unit include?
It includes direct material cost, direct labor cost, variable manufacturing overhead and fixed manufacturing overhead. The summary also shows total variable cost per unit before adding fixed manufacturing overhead.
Can I use a monthly or annual period?
Yes. Use a monthly, annual or other period as long as you apply it consistently throughout the model, particularly when entering total fixed manufacturing overhead and units produced.
How are units produced and units sold used?
The template includes separate inputs for production and sales volume. Absorption cost per unit multiplied by units sold provides the cost of goods sold for the analysis. Break-even price is based on units sold, while break-even units shows how many units need to be produced.
Can I use labor hours or machine hours to apply overhead?
Yes. Define the cost per driver unit, then apply the driver quantity required for one finished unit. The template includes a helper calculation for machine hours per unit, and the direct labor section provides labor-hours information.
What does the sensitivity table compare?
The profit/loss sensitivity table varies units sold and selling price so you can compare the profitability of different price and volume combinations.
Can I add or remove rows?
Yes. The template is designed with extra input space and supports adding or deleting rows to match the detail you need.
Is this template included in a bundle?
Yes. It is included in the Accounting Templates, Manufacturing Templates, Data Table Spreadsheets and Super Smart bundles linked above.
Bring direct costs and manufacturing overhead together
Understand the full cost behind each finished unit.
Purchase the absorption costing template for $45 and receive immediate access to the download.
