CalculatorMasters

Accountants Material Cost (Hourly) Calculator

Calculate the direct material cost allocated to each productive labour hour using inventory, purchase and labour-hour figures.

Your Details

Overview

Use this calculator to estimate direct material cost per productive labour hour. Enter opening and closing material inventory, purchases, inbound freight, purchase reductions and the productive hours recorded for the same accounting period.

How it works

The calculator first adjusts material purchases by adding inbound freight and subtracting returns and discounts. It adds this net amount to opening inventory to find materials available for use, then subtracts closing inventory to estimate direct materials used. Finally, it divides materials used by productive labour hours. This creates a practical material-cost allocation per hour, provided the figures cover the same period and use a consistent inventory valuation basis.

How to use this calculator

  1. 1Enter the opening value of material inventory.
  2. 2Add material purchases and any inbound freight or delivery costs.
  3. 3Enter returns, supplier discounts and rebates that reduce purchase cost.
  4. 4Enter the closing material inventory value.
  5. 5Add productive labour hours for the same period and review the hourly material cost.

Example Calculation

Opening material inventory

$5,000

Material purchases

$25,000

Freight and delivery cost

$1,200

Purchase returns and discounts

$500

Closing material inventory

$6,200

Productive labour hours

1600

Material cost per productive hour

$15.31

Net material purchases are $25,700 and direct materials used are $24,500. Dividing this by 1,600 productive hours gives an estimated material cost of $15.31 per productive hour.

Frequently asked questions

What is material cost per productive hour?

It is the estimated value of direct materials used during a period divided by the productive labour hours worked in that period.

Why is closing inventory subtracted?

Closing inventory has not been consumed during the period, so subtracting it helps isolate the cost of materials actually used.

Should freight be included in material cost?

Inbound freight is commonly included when it is a cost of acquiring materials. Treatment can depend on your accounting policy and the nature of the cost.

Do purchase discounts reduce the calculation?

Yes. Supplier discounts, rebates and purchase returns generally reduce the net cost of materials acquired.

Which hours should be used in the calculation?

Use productive hours directly connected with production or jobs. Avoid mixing in unrelated administrative or idle time unless that matches your chosen costing method.

Does this include labour and overhead costs?

No. This calculator estimates direct material cost per hour only. Labour, overhead and margin must be considered separately if needed.

Explore Related Calculators

Accountants Material Cost (Daily) CalculatorCalculate the average daily cost of materials used from opening stock, purchases, direct material costs, closing stock and working days.Calculate →Accountants Material Cost (Monthly) CalculatorCalculate the cost of materials used during a month from opening inventory, purchases, delivery costs, returns and closing inventory.Calculate →Accountants Travel Expense CalculatorEstimate business travel costs, reimbursed amounts and the remaining expense to record or claim.Calculate →Accountants Travel Expense (Hourly) CalculatorEstimate travel costs using chargeable travel time, an hourly rate, mileage reimbursement, parking, tolls and other expenses.Calculate →

Assumptions and warnings

Assumptions

  • All inventory and purchase figures relate to the same accounting period.
  • Inventory values and purchases are measured using a consistent accounting method.
  • Productive labour hours represent hours that reasonably share the material cost.
  • The result is an allocation estimate and does not include labour, overhead, tax or profit margin.

Warnings

  • This calculator provides a costing estimate only and is not accounting, tax or financial advice.
  • Review inventory valuation, stock adjustments and cost-allocation methods before using results for financial reporting or pricing decisions.
Accountants Material Cost (Hourly) Calculator