Additive Manufacturing Job Costing Worksheet (Excel Export)
This worksheet costs additive and powder metallurgy jobs the way an estimator builds a quote: machine hours, material, post-process labor and outside processing, rolled into a job total and a cost per part. Edit the example rows, add your own, and export to Excel.
| Job / part | Process | Qty in job | Machine hours (job) (hr) | Machine rate ($/hr) | Material consumed (job) (kg) | Material price ($/kg) | Post-process labor (job) (hr) | Labor rate ($/hr) | Outside processing (job) | Machine cost | Material cost | Post-process cost | Job total | Cost per part | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
$1,824 | $372 | $1,508 | $3,704 | $154 | |||||||||||
$2,496 | $184 | $1,774 | $4,455 | $742 | |||||||||||
$3,355 | $646 | $2,366 | $6,367 | $796 | |||||||||||
$1,080 | $861 | $588 | $2,529 | $1 | |||||||||||
$2,850 | $2,880 | $2,820 | $8,550 | $0 |
Machine hours, material and post-process hours are for the whole job, not per part. Cost per part divides the job total by quantity. Example rows are illustrative, not benchmarks.
Costing from live job data
Optional: a review of moving machine hours and material lots from this sheet into ERP job costing.
Optional. The tool and every export work without this. No spam.
How to use it
Add one row per job or part. Enter quantity and the whole-job inputs: machine hours, the burdened machine rate, material consumed in kilograms and its price, post-process labor hours and rate, and any outside processing such as HIP or heat treat. Machine, material, post-process and job-total columns calculate on each row, and cost per part divides by quantity. The summary shows the cost mix across all jobs, so you can see where the money goes.
- Use job-level hours and kilograms, then let the sheet divide by quantity.
- Include supports and non-recycled powder in material consumed.
- Put sent-out heat treat, HIP, NDT and plating in outside processing.
The costing method
Machine cost = machine hours x rate. Material cost = kilograms consumed x price per kilogram. Post-process cost = labor hours x labor rate + outside processing. Job total is the sum of the three, and cost per part is job total divided by quantity. The cost-mix summary divides each category by the grand total. This direct-cost structure maps cleanly onto a standard cost rollup, where machine hours become a routing operation and material becomes a bill of materials line.
Using the cost mix
A high machine share points to nesting and build-rate improvements. A high material share points to alloy choice, powder reuse and support minimization. A high post-process share, common for thin, small or tight-tolerance parts, points to design for post-processing: fewer supports, machining stock only where needed, and batching heat treat. Compare the mix between processes. Press-and-sinter and MIM jobs carry low per-part post-process but need tooling, which this sheet does not amortize.
Common mistakes
Entering per-part values in job-level columns inflates or deflates cost by the quantity. Forgetting scrap is another: apply a yield factor by adding hours and material for reprints. Tooling for MIM and PM is a separate one-time cost that should be added to the outside column or quoted as non-recurring engineering. Finally, use rates from the same period; machine rates drift with utilization, so update them quarterly.
Frequently Asked Questions
How do I handle scrap or failed builds?
Estimate your first-pass yield and add the extra machine hours and material for the failed share to the job, or divide the job total by yield. Track actual failures to refine the assumption over time.
Can I use it for MIM and press-and-sinter?
Yes, choose the process and enter furnace or press hours, powder or feedstock kilograms and post-process labor. Add tooling as a one-time cost in outside processing or as a separate line, since it is not recurring per job.
What machine rate should I enter?
Divide annual machine cost (depreciation, service, gas, filters, floor space and operator share) by realistic available hours. Use actual utilized hours, not 8,760, or the rate will be too low.
How do I export it?
Use the export buttons to download the worksheet as Excel, CSV or PDF. Computed columns export as values, so keep the web version if you want to continue editing with formulas.
If these costs should come from live job data rather than a spreadsheet, we can map machine hours and material lots into your ERP job costing.
Related Tools
Additive Manufacturing Build Cost Estimator
Build-time and cost model for powder bed fusion jobs: recoat time, scan time, powder with recycle loss, setup and post-processing per part.
Costing & FinanceAdditive vs CNC Machining Cost Break-Even Calculator
Side-by-side total cost for metal AM and CNC machining across quantity, with fixed costs, batch setups and the crossover quantity.
MES & Shop FloorAM Parts per Build Plate Nesting Calculator
Grid nesting estimate for AM build plates with spacing, edge margin and practical nest efficiency, plus packing density and annual machine hours.
Engineering & PLMAM, MIM and PM Material Density and Process Reference
Lookup table of common AM, MIM and PM alloys with density, available routes and notes, for mass and cost calculations.
More Costing & Finance tools
See all- SAP QM Inspection Effort and Cost Calculator
- SAP Standard Cost Estimate BOM Rollup Calculator
- Legacy ERP Retirement Cost and Payback Calculator
- JD Edwards World Month-End Close Procedure Template
- Distributor Customer Credit Application Template
- Distributor Customer Profitability Worksheet
- Distributor GMROI and Inventory Turns Calculator
- Vendor Early Pay Discount Worksheet
- SyteLine Cost Rollup Variance Calculator
Keep exploring
Free tools
- Additive Manufacturing Build Cost EstimatorBuild-time and cost model for powder bed fusion jobs: recoat time, scan time, powder with recycle loss, setup and post-processing per part.
- Additive vs CNC Machining Cost Break-Even CalculatorSide-by-side total cost for metal AM and CNC machining across quantity, with fixed costs, batch setups and the crossover quantity.
- Job Costing Variance WorksheetCompare the estimated and actual quantity and rate on a job by cost element and split the difference into quantity and rate variance.
Guides
- Metal Additive Build Cost Per Part: Nesting, Plate Utilization and Powder ReuseWork out true cost per part on a metal additive build: plate utilization, nesting yield, machine hourly rate, powder reuse and failed build allowance explained.
- ERP for Additive Manufacturing Service Bureaus: What to Look ForWhat an ERP for a 3D printing service bureau needs: build jobs with child parts, powder lot genealogy, machine-hour costing, post-processing routings and quality records.
- Powder Lot Traceability and Build Records for Metal Additive PartsWhat traceability records metal additive parts need for aerospace and medical customers: powder lots, reuse, build logs, witness coupons, HIP, inspection and CoCs.
AI on your ERP
- AI on Infor SyteLine for Metal Fabricators: Quotes, Heat Lots, Routings and Job CostAI on Infor SyteLine for metal fabricators: quote and routing history, remnant and heat-lot traceability, outside processing, and job costing, kept private.
- AI for SYSPRO production and job costingHow AI reads SYSPRO WIP jobs, labor and material postings to explain job cost variances and late work orders, with read-only access and on-prem hosting.