Skip to content
Shop | Excel tracker

Cost per Part and Budget Tracker

Cost map, hour rates, cost per part, monthly budget and variances by cause with an action list.

Screenshot of the Cost per Part and Budget Tracker workbook with example data
Example data from the workbook.

How it works

  1. Enter the cost of your plant or area by type in 02 Cost Map and mark what is fixed and variable.
  2. Calculate the machine hour rate of your bottleneck and the labor hour rate in 03 Rates.
  3. Calculate the cost per part, contribution margin and break-even of your main product in 04 Part Cost. Use column C for scenarios.
  4. Every month: enter planned and actual output and actual costs in 05 Budget, the actual data in 06 Variances, and agree actions in 07 Actions.

Definitions used in the workbook

  • Machine hour rate: All machine costs of a year (depreciation, capital cost, space, energy, maintenance, tools) divided by planned running hours.
  • Conversion cost: Machining, operator, setup, assembly and test. Everything between material and finished part.
  • Contribution margin: Price minus variable cost. It pays the fixed costs first, then the profit.
  • Flexed budget: Variable costs at actual output, fixed costs at plan. The fair basis for comparing actual costs.

Sheets in the workbook

  1. Start
  2. Cost Map
  3. Rates
  4. Part Cost
  5. Budget
  6. Variances
  7. Actions

Who it is for

Plant and area managers who want to talk numbers with controlling.

The method behind the numbers

This workbook is part of the Cost and Controlling toolkits. The Starter Kit adds the guide and the checklist for the first 30 days. The Excellence Bundle adds playbook, workshop pack, templates, deck and the complete Excel system.

Newsletter

One Lean idea.
Every week.