Operations Floor: Calculator

Capacity utilization and productivity calculator

Enter the figures for one period, or for two to compare, and the calculator works out how much of the capacity is used, how many units fail inspection, how much each worker and each machine hour produces, what the inputs return, and how sharply profit would respond to a change in sales. Every result comes with its working in full.

Back to 5.6 Production planning

Status
HL onlyAO2, AO4
Worked example
Wrenhurst Cycles, a fictional bicycle maker

Section 01: How to use it

  1. Say what is produced, how labour and capital are measured, and whether units that fail inspection are reworked and sold or scrapped.

  2. Enter each period's figures. Untick the comparison to work with one period only.

  3. Read the measures side by side with the change between the periods, and see on the chart how the fixed cost of each unit falls as more of the capacity is used.

  4. Open the working for any measure, for either period. Your figures are kept on this device; download them as JSON or CSV, or print the page.

Where it sits in the course. Subtopic 5.6, Production planning (guide, pp. 34 to 35), is HL only. It names the capacity utilization rate, the defect rate, labour productivity, capital productivity, the productivity rate and operating leverage, at AO2 and AO4. The guide's list of formulas (p. 65) gives the capacity utilization rate and the productivity rate; the other measures use the standard forms in the notes on production planning, and say so in their workings.

Calculator

Wrenhurst Cycles, a fictional bicycle maker

Source: Simulated data HL only

Wrenhurst's assembly line, from the notes on production planning: September is the notes' own four-week month, 800 bikes built on a line that can build 1,000; October, a quieter month of 700 bikes on the same costs, is added here for the comparison. Every figure is simulated.

Your changes are kept in this browser, on this device only.

What is being produced
Capacity utilization counts every unit produced, since each used capacity; productivity counts good output only.
Figure

Productive capacity bikes The most that can be produced in the period with the present buildings, machines and staff.

Units produced (actual output) bikes

Units failing inspection bikes

Labour input workers In workers or labour hours, as chosen above.

Capital input machine hours

Selling price of one unit

Total costs of the period All the costs, fixed and variable: the total input.

Fixed costs of the period

These are the worked example's figures. With JavaScript on, you can enter your own and everything below is recalculated.

The measures

Measure September October Change
Capacity utilization rate guide formula80.0%70.0%−10.0 points
Defect rate2.00%3.00%+1.00 points
Labour productivity32.00 bikes per worker28.00 bikes per worker−4.00
Capital productivity2.00 bikes per machine hour2.00 bikes per machine hourno change
Productivity rate guide formula111.1%106.1%−5.1 points
Fixed cost per unit$150.00$171.43+$21.43
Degree of operating leverage4.007.00+3.00

"Guide formula" marks the two formulas the guide gives (p. 65); the others are standard forms, as in the notes on production planning. Changes in rates are in percentage points.

Capacity used

  • September80.0%
  • October70.0%

Capacity used Spare capacity 85%: from here, little room for a rush order or a breakdown (the platform's rule of thumb)

Reading. September: 80.0% of capacity is used: 800 of 1,000 bikes, leaving 200 bikes of spare capacity. October: 70.0% of capacity is used: 700 of 1,000 bikes, leaving 300 bikes of spare capacity.

From September to October, capacity utilization fell by 10.0 percentage points, the fixed cost carried by each bike rose from $150.00 to $171.43, the productivity rate fell by 5.1 points, the defect rate rose by 1.00 points. Operating leverage moved from 4.0 to 7.0: the closer output is to break-even, the more sharply profit responds to a change in sales.

Implication. There is room for more orders without strain, and the fixed costs are spread over a reasonable output.

Fixed cost per bike at each level of outputFixed cost per bike falls as output rises, because the same fixed costs are shared by more bikes: with fixed costs of $120,000, $1,200.00 at 100 bikes and $120.00 at full capacity of 1,000. September: 800 good bikes, $150.00 each; October: 700 good bikes, $171.43 each.$0$250$500$750$1,000$1,25002004006008001,000Output (bikes a month)Fixed cost per bikeCapacity 1,000September: $150.00October: $171.43
Chart The same fixed costs shared by more output: each period is marked on its curve. Simulated teaching data.
The chart's figures as a table
Output Share of capacity Fixed cost per unit
10010%$1,200.00
20020%$600.00
30030%$400.00
40040%$300.00
50050%$240.00
60060%$200.00
70070%$171.43
80080%$150.00
90090%$133.33
1,000100%$120.00

The workings

The workings for September.

Capacity utilization rate

Given
  • Actual output: bikes produced this month: 800
  • Productive capacity: 1,000 bikes
Formula
Capacity utilization rate = actual output ÷ productive capacity × 100
Substitution
= 800 ÷ 1,000 × 100
Working
800 ÷ 1,000 = 0.8000
0.8000 × 100 = 80.00%
Answer
80.0%

The guide gives this formula (p. 65).

Unit
per cent of productive capacity
Interpretation
80.0% of capacity is used: 800 of 1,000 bikes, leaving 200 bikes of spare capacity.
Business implication
There is room for more orders without strain, and the fixed costs are spread over a reasonable output.
Defect rate
Given
  • bikes that failed inspection: 16
  • bikes produced: 800
Formula
Defect rate = units that fail to meet the quality standard ÷ units produced × 100
Substitution
= 16 ÷ 800 × 100
Working
16 ÷ 800 = 0.0200
0.0200 × 100 = 2.00%
Answer
2.00%

The standard form; the guide's list of formulas does not give one.

Unit
per cent of the bikes produced
Interpretation
2.00% of the bikes produced failed inspection.
Business implication
Each defect costs twice: the rework or scrap, and any defect that reaches a customer. Preventing defects usually costs less than finding them.
Labour productivity
Given
  • Good output: 800 good bikes
  • Labour input, in workers: 25
Formula
Labour productivity = good output ÷ number of workers
Substitution
= 800 ÷ 25
Working
800 ÷ 25 = 32.000
Answer
32 bikes

The standard form; the guide's list of formulas does not give one.

Unit
good bikes per worker this month
Interpretation
Each unit of labour input produced 32.00 good bikes.
Business implication
Compare it across periods or with a rival: on its own the figure says little, and long hours can hold output up even when each hour produces less.
Capital productivity
Given
  • Good output: 800 good bikes
  • Capital input, in machine hours: 400
Formula
Capital productivity = good output ÷ capital input (machine hours)
Substitution
= 800 ÷ 400
Working
800 ÷ 400 = 2.000
Answer
2 bikes

The standard form; the guide's list of formulas does not give one.

Unit
good bikes per machine hour
Interpretation
The machines produced 2.00 good bikes for each unit of capital input.
Business implication
Idle or slow machines lower it; maintenance, better scheduling and fewer defects raise it without new investment.
Productivity rate
Given
  • Total output: good output × selling price: 800 × $500 = $400,000
  • Total input: all the costs of the period: $360,000
Formula
Productivity rate = total output ÷ total input × 100
Substitution
= $400,000 ÷ $360,000 × 100
Working
400,000 ÷ 360,000 = 1.1111
1.1111 × 100 = 111.11%
Answer
111.1%

The guide gives this formula (p. 65) without saying how to measure output and input. Both are valued in the same currency here, output at its selling price and input at its cost, so that the result is a percentage.

Unit
per cent: output value for each 100 of input value
Interpretation
Every $100 of inputs produced $111.11 of output, valued at selling prices.
Business implication
The rate rises when the same fixed inputs, such as the factory and the line, are spread over more good output.
Fixed cost per unit
Given
  • Fixed costs this period: $120,000
  • Good output: 800 good bikes
Formula
Fixed cost per bike = fixed costs ÷ good output
Substitution
= $120,000 ÷ 800
Working
120,000 ÷ 800 = 150.0000
Answer
$150.00

Shows why capacity utilization matters: the same fixed costs are shared by more units when more capacity is used.

Unit
$ of fixed costs carried by each bike
Interpretation
Each good bike carries $150.00 of the period's fixed costs.
Business implication
More output, from the same capacity, lowers this figure: the main reason a business wants high capacity utilization.
Degree of operating leverage
Given
  • Total contribution: total output − variable costs: $400,000 − $240,000 = $160,000
  • Operating profit: total contribution − fixed costs: $160,000 − $120,000 = $40,000
Formula
Degree of operating leverage = total contribution ÷ operating profit
Substitution
= $160,000 ÷ $40,000
Working
160,000 ÷ 40,000 = 4.0000
Answer
4.00

The guide names operating leverage but gives no formula. This is the degree of operating leverage, as in the notes on production planning; variable costs are total costs less fixed costs.

Unit
times: the percentage change in operating profit for each 1% change in sales
Interpretation
A 1% change in sales would change operating profit by about 4.0%.
Business implication
High operating leverage magnifies profit when sales rise and losses when they fall, so it suits stable demand better than unstable demand.

Section 02: What it leaves out

Every model simplifies. Say so in an answer, and say what else you would want to know.

  • Productive capacity is treated as fixed for the period. In practice it moves with shifts, overtime, maintenance and the mix of products.
  • The productivity rate values output at its selling price and input at its cost. The guide does not say how to measure them, so state your method in an answer.
  • Variable costs are taken as total costs minus fixed costs and assumed to rise in proportion to output, which is how operating leverage is worked out here. Real costs are rarely so tidy.
  • One figure for one period says little. The measures mean most compared over time or with a rival, and pushing one of them, such as utilization, can damage another, such as the defect rate.
  • The bands used in the reading (below 60%, 60 to 85%, 85 to 97%, and 97% and above) are the platform's rule of thumb, not an IB rule.

Section 03: Read and practise next