Accountants Material Cost (Hourly) Calculator Examples
Worked examples showing how inventory, purchases and productive hours affect material cost per hour.
These examples show the sequence from adjusted purchases to direct materials used and the final hourly material-cost allocation. Each assumes all values refer to one consistent accounting period.
Workshop with regular monthly purchasing
Medium-volume workshop monthly costing
Input Summary
Opening inventory
$5,000
Purchases
$25,000
Freight in
$1,200
Returns and discounts
$500
Closing inventory
$6,200
Productive hours
1,600 hours
Calculation Breakdown
- 1Net purchases$25,000 + $1,200 - $500$25,700
- 2Materials used$5,000 + $25,700 - $6,200$24,500
- 3Hourly material cost$24,500 / 1,600$15.31 per hour
Result Summary
Hourly material cost
$15.31 per hour
Accountants Material Cost (Hourly) Calculator
The estimated direct material cost is $15.31 per productive hour.
Small repair business with lower volume
Low-volume service and repair month
Input Summary
Opening inventory
$1,800
Purchases
$6,500
Freight in
$300
Returns and discounts
$100
Closing inventory
$2,100
Productive hours
320 hours
Calculation Breakdown
- 1Net purchases$6,500 + $300 - $100$6,700
- 2Materials used$1,800 + $6,700 - $2,100$6,400
- 3Hourly material cost$6,400 / 320$20.00 per hour
Result Summary
Hourly material cost
$20.00 per hour
Accountants Material Cost (Hourly) Calculator
The estimated direct material cost is $20.00 per productive hour.
Production period with a stock build
Growing manufacturer building stock
Input Summary
Opening inventory
$12,000
Purchases
$48,000
Freight in
$2,000
Returns and discounts
$1,000
Closing inventory
$20,000
Productive hours
2,500 hours
Calculation Breakdown
- 1Net purchases$48,000 + $2,000 - $1,000$49,000
- 2Materials used$12,000 + $49,000 - $20,000$41,000
- 3Hourly material cost$41,000 / 2,500$16.40 per hour
Result Summary
Hourly material cost
$16.40 per hour
Accountants Material Cost (Hourly) Calculator
The estimated direct material cost is $16.40 per productive hour.
High-output fabrication team
High-volume fabrication quarter
Input Summary
Opening inventory
$30,000
Purchases
$140,000
Freight in
$6,000
Returns and discounts
$4,000
Closing inventory
$26,000
Productive hours
8,000 hours
Calculation Breakdown
- 1Net purchases$140,000 + $6,000 - $4,000$142,000
- 2Materials used$30,000 + $142,000 - $26,000$146,000
- 3Hourly material cost$146,000 / 8,000$18.25 per hour
Result Summary
Hourly material cost
$18.25 per hour
Accountants Material Cost (Hourly) Calculator
The estimated direct material cost is $18.25 per productive hour.
How to Read Your Results
Net material purchases show purchases after adding inbound freight and deducting returns, rebates and discounts.
Materials available for use combines opening inventory with net purchases.
Direct materials used excludes the value of stock still on hand at the period end.
Material cost per productive hour is a period-level allocation, not necessarily the exact cost of every individual job.
Compare periods only when inventory valuation and the definition of productive hours are consistent.
Assumptions & Important Notes
- All example currency figures are illustrative and use the same unspecified currency.
- Inventory values are assumed to be measured consistently from the start to the end of each period.
- Productive hours are assumed to relate directly to the activity consuming materials.
- The examples exclude labour, overhead, sales costs and margin.
Related Examples
Frequently Asked Questions
Can material cost per hour be negative?
A negative result can occur if closing inventory exceeds opening inventory plus net purchases. This often indicates a data, timing or inventory-adjustment issue that should be reviewed.
Why can two periods have similar purchases but different hourly material costs?
Changes in opening or closing inventory and changes in productive hours both affect the result.
Can this calculation be used for a service business?
It can be useful where the business consumes identifiable materials or parts. It may be less meaningful where materials are insignificant.
Should the result be rounded?
For reporting, currency results are commonly shown to two decimal places, while underlying calculations can retain more precision.
Ready to calculate your own result?
Use the live calculator with your own inputs, timing, and preferences.