Production Line Planner

Monthly capacity vs demand with OEE, scrap and changeovers, cost per unit, profit, and a current vs +1 shift vs +1 machine comparison

🔒 Your data stays in your browser: nothing you type or upload is sent to a server.

How it works

OEE (overall equipment effectiveness) multiplies three losses: availability (is it running?), performance (is it fast enough?) and quality (is the output good?). A world-class line sits around 85 %; most plants run at 40 to 60 %, which means plenty of hidden capacity before buying a machine. This is a monthly spreadsheet-style model, not a discrete-event simulation: it has no queues, random breakdowns or work-in-progress, so treat results as planning estimates.

Formula

OEE = availability × performance × quality units = available minutes ÷ (60 ÷ (speed × performance) + changeover ÷ batch) good units = units × (1 − scrap) profit = price × sold − materials − labour − energy − fixed payback = investment ÷ extra monthly profit

Common questions

Why is labour a fixed cost in the scenarios?

Because operators are paid for the shift whether or not there is demand. That is exactly why adding a shift only pays when demand is larger than your current capacity.

Related tools