Which job earns most per hour of the thing we're short of?
One thing is full. Which jobs get its hours, what one more hour is worth, and whether overtime pays.
Best margin. Worst use of the machine.
The starting figures are a small engineering workshop's, with one machine everyone wants, or a design studio's senior designer, so swap in your own.
Ctrl+`
Starting figures · add your own
Overtime at £60 an hour, 46 working weeks, nothing you must do, and a second place work might get stuck.
The "at least" column is now in the job table: work you must do whatever it earns, a contract or a customer who brings the rest.
Not sure it's the machine?
Add the other places work might get stuck. For each, the hours it has a week and, in the job table, the hours each job takes there. The one a full order book overloads most is the one you're short of.
More a week from the same 40 machine hours, filled best first
£75
What one more machine hour is worth
On these figuresMix could do better
the work, countedby margin
Trevor says prototypes are the fun ones.
where the hours go40 machine hours
The next hours
Extra hours a week, and what each is worth
Now: 2 quick repairs, 2 short batches and all 3 prototypes, leaving £700 a week. Best first: all 15 quick repairs, about 6 short batches and no prototypes, leaving £2,125.
Left per machine hour: quick repairs £150, short batches £75 and prototypes £60. The best margin (£67 in every £100) belongs to prototypes, the worst use of the machine. Filled best first, that is all 15 quick repairs, about 6 short batches and no prototypes a week: about £2,100 a week after the £2,000 of fixed costs, against £700 now. That is about £1,400 a week, or £66,000 a year over 46 weeks. An extra machine hour is worth £75, so overtime at £60 an hour pays, for the first 7 hours a week.
£1,425more a weekMix could do better
Every job, ranked by the machine's hours
Money left is after each job's own costs, before fixed costs.
Job
Left each
Machine hours each
Left per machine hour
Now a week
Best a week
quick repairs
£150
1
£150
2
15
short batches
£300
4
£75
2
6.3
prototypes
£600
10
£60
3
0
Hours of the machine
40
40
Money left a week
£2,700
£4,125
Everything runs in your browser. Rough sums on the figures you typed, not financial advice. Weekly averages, before tax and VAT. Money left is before fixed costs, which stay the same whatever the mix.
Downloads propellr-bottleneck-reminder.ics. Opens in Outlook, Google or Apple calendars. No sign-up, no email.
9:00Check the mix againpropellrco.com/tools/bottleneck
How this works
When one thing is full, every job is competing for its hours. So each job is judged on what it leaves for each hour it holds that thing: its price, less the costs that come and go with it, divided by the hours it takes there.
The hours are then filled best first: as many of the top job as you could sell, then the next, until the hours run out. With one thing short, no other order leaves more. Jobs you must do go in first.
Wages, rent and the machine itself stay the same whichever jobs you do, so they aren't shared out over jobs. They come off at the end. Spreading them by hours would make the busy jobs look worse twice.
One more hour is worth what the next job waiting would leave with it. Overtime pays while that's more than the hour costs, and only until that job's demand runs out.
Jobs a week are averages: 6.3 a week is about 25 every four weeks.
Left each = price − costs that come and go with the job Left per machine hour = left each ÷ machine hours each Best mix = fill the machine's hours in order of left per hour, up to what you could sell Left a week = sum of left each × jobs a week − fixed costs
The least a job must leave, after its own costs, to earn its hours on the thing you're short of, by the hours it takes there and what an hour there earns now
Hours it takes
£50 an hour
£75 an hour
£100 an hour
£150 an hour
1 hour
£50
£75
£100
£150
2 hours
£100
£150
£200
£300
4 hours
£200
£300
£400
£600
8 hours
£400
£600
£800
£1,200
10 hours
£500
£750
£1,000
£1,500
20 hours
£1,000
£1,500
£2,000
£3,000
It leaves out set-up times between jobs, a second place that's also short, and whether customers who come for one job bring the others. Use "at least" for those.
We did one like it
The money · Advise
A new machine. Will it earn its keep?
A precision engineering business, 24 staff. The machine was already full, so new orders waited. Slow months went in the model before a second one was bought.