Hourly Production Target Calculator
Build an hour-by-hour production board for one shift. Every clock hour gets its own target after breaks, planned stops and changeovers, with a running total. Print it as an A4 board, or fill in the actuals here and watch the gap. Updates as you type.
Your shift
Use clock times for the breaks. The defaults are the worked example below.
Pick Fill in actuals on the board below. Actuals stay in this browser and are not part of the share link.
Hour-by-hour board
One row per clock hour. Each hour is rounded so the rows add up exactly to the shift total.
| Hour | Planned minPlanned min | Target | Cumulative targetCum. target | Actual | Cumulative actualCum. actual | Gap | Cumulative gapCum. gap | Reason and action |
|---|
Write the actual in the first minutes after each hour. If an hour is behind, write the reason and the action in that row.
Print and Copy as CSV use the board as shown. Actuals and reasons are saved in this browser only, not in the share link; Copy as CSV keeps them. Long reasons are trimmed in print (two lines, or one on boards over 16 rows) and kept in full in Copy as CSV. The printed actuals board leaves out Cumulative actual; the gap columns show the difference.
The working, with your numbers
Get a second opinion on this result
Send it to the OEE Lab team. A Fabrico OEE specialist reads your numbers and gets back to you by email. To keep the result, use Copy link, Copy as CSV or Print above.
No newsletter, no spam. What you enter here, this result and its link go to the OEE Lab team. Privacy
A paper board shows the gap once an hour. A signal shows it live.
Fabrico counts output from the PLC or IoT sensors, with AI cameras where a machine has no usable signal, and shows target against actual live per line and per shift. When the line stops, the operator gives the cause. Where cameras are fitted, video of a stop is streamed on request, not stored. EU customers are hosted on AWS in Frankfurt.
Request a demoWhat the hourly production target calculator does
It builds the hour-by-hour board many plants keep next to the line: one row per clock hour, a target for each hour, a running total, and empty columns for the actual count and the reason when an hour falls short.
The target for each hour follows the minutes the line can really run in that hour. A break, a start-up, a meeting, cleaning or a changeover takes its minutes out of the hour it falls in, and a break that runs over the hour is split between the two rows. The shift can start at any minute and can cross midnight.
Print the board on one A4 page, or switch to Fill in actuals and type the count each hour. The page then shows the gap per hour, the cumulative gap and, if you add the good units, an OEE estimate for the hours so far.
The formulas
Hour target = producing minutes × ideal rate per minute × target %
- Clock minutes in a row: 60, or less for a part hour at the start or end of the shift.
- Planned minutes = clock minutes - breaks (if the line stops) - planned stops. This is the hour's share of planned production time.
- Producing minutes = planned minutes - changeover. The changeover stays in planned time, because OEE counts it as availability loss.
- Cumulative target = the sum of the hour targets so far. Each hour is rounded so that the rows add up exactly to the shift total.
- Gap = actual - target, and cumulative gap = cumulative actual - cumulative target. A minus sign means behind.
- Stops and speed (A × P) = units made × ideal cycle time ÷ planned minutes of the hours filled in. Quality = good units ÷ units made. OEE = A × P × Q.
The OEE the board asks for is the shift target ÷ (planned minutes × ideal rate per minute). It sits below your target % when you enter a changeover, because the changeover minutes stay in planned time but make no units. For the OEE time model behind this, see the OEE loss tree simulator.
Worked example: the default numbers
Example: a line runs from 06:00 to 14:00 and stops for a 15 minute break at 09:00 and a 30 minute meal at 11:45. The shift opens with a 10 minute start-up and a 5 minute meeting, has a 20 minute changeover in the 10:00 hour and ends with 15 minutes of cleaning. The ideal rate is 600 units an hour, 10 a minute, and the target is 70% OEE, so a minute of running is worth 7 units.
| Hour | Off the line | Producing min | Target | Cumulative |
|---|---|---|---|---|
| 06:00-07:00 | start-up 10, meeting 5 | 45 | 315 | 315 |
| 07:00-08:00 | none | 60 | 420 | 735 |
| 08:00-09:00 | none | 60 | 420 | 1,155 |
| 09:00-10:00 | break 15 | 45 | 315 | 1,470 |
| 10:00-11:00 | changeover 20 | 40 | 280 | 1,750 |
| 11:00-12:00 | meal, first 15 of 30 | 45 | 315 | 2,065 |
| 12:00-13:00 | meal, last 15 of 30 | 45 | 315 | 2,380 |
| 13:00-14:00 | cleaning 15 | 45 | 315 | 2,695 |
Planned production time is 480 - 45 minutes of breaks - 30 minutes of planned stops = 405 minutes. Take out the 20 minute changeover and 385 minutes are left to produce, so the shift target is 385 × 10 × 70% = 2,695 units. Over planned time the board asks for 2,695 ÷ (405 × 10) = 66.5% OEE, because the changeover sits inside planned time.
A flat target of 2,695 ÷ 8 = 337 an hour would ask the changeover hour, which has 40 minutes to run, for the same 337 as a full hour, which can make 420 at the same pace. The board would show red after the changeover and green in the early hours for the same pace, and the team would stop trusting it.
Now fill in the first five hours: 280, 410, 430, 300 and 220 units, 1,640 in all, of which 1,600 are good. The cumulative target at 11:00 is 1,750, so the line is 110 behind. Those five hours hold 270 planned minutes, worth 2,700 units at the ideal rate. Stops and speed together give 1,640 ÷ 2,700 = 60.7%, quality is 1,600 ÷ 1,640 = 97.6%, and the OEE estimate is 1,600 ÷ 2,700 = 59.3%.
How to run an hour-by-hour board
- Build it before the shift. Enter the start time, breaks, planned stops and any changeover, then print the board or keep this page open on a screen at the line.
- Agree who writes the count and when. Usually the operator or the team leader, in the first minutes after each hour, from the machine counter rather than an estimate.
- Write a reason for every hour that misses. Short and specific, with the action taken. "Machine stopped" tells nobody anything; "label jam at the labeller, splice changed" does.
- Watch the cumulative gap. One bad hour can be won back. A cumulative gap that grows hour after hour is a pattern, and it needs help from outside the line.
- Agree when to escalate. For example, the team leader calls maintenance or quality when the cumulative gap passes one full hour of target. Pick a rule that fits your line and write it on the board.
- Close the loop at handover. Read the reasons, pick the one that cost most, and give it an owner for the next shift.
A board like this is the first step of target against actual tracking. For how plants take it further, with counts from the machine and targets per line and shift, Fabrico has a guide to target vs actual production tracking.
The first and last hours of a shift are often the weakest; the guides on first hour of shift losses and end of shift losses show what to look for in those rows.
Common mistakes
- One flat target for every hour. Break and changeover hours always look behind and full hours always look ahead. Give each hour its own minutes.
- Setting the target at 100% of the ideal rate. Every hour misses, every row is red, and the board stops meaning anything. Use OEE, or performance only with a realistic percentage.
- Counting a changeover twice. If your target % is an average that already includes changeovers, entering the changeover here takes the same minutes off again.
- Leaving breaks in when the line stops. If nobody covers the break, it is not planned production time. See how to count breaks in OEE.
- Filling the board at the end of the shift. Counts and reasons written from memory are guesses. Write each hour as it ends.
- Reading performance over 100%. If the stops and speed figure comes out above 100%, the ideal rate is too low or a count is wrong; see performance over 100%.
Hourly production target FAQ
How do you calculate an hourly production target?
Take the minutes the line can produce in that clock hour: 60, minus any break the line stops for, planned stops and changeover. Multiply by the ideal rate per minute and by your target percentage. In the default example a full hour is 60 × 10 × 70% = 420 units, and the hour with a 20 minute changeover is 40 × 10 × 70% = 280.
Should the target drop in an hour with a break?
Yes, if the line stops for the break. A flat target makes every break hour look behind and every full hour look ahead, so the team learns to ignore the board. If a relief crew keeps the line running, set the break switch to no and the hour keeps its full target.
Should I set the hourly target on OEE or on performance?
On OEE if you want a target the line can meet on a normal day, with room for short stops and scrap. On performance only if you want every lost minute to show up as a gap. Either way, use the fastest proven rate as the ideal, not the average.
What goes in the reason column?
The cause of a missed hour in plain words, from the operator, and what was done about it: for example, label jam at the labeller, 12 minutes, splice changed. One cause per line, written during the shift, not from memory at the end.
Can an hour-by-hour board calculate OEE?
Only in part. With the units made each hour it gives availability and performance together, because it does not know how long the line was stopped. Add the good units and it also gives quality and an OEE estimate. To split stops from slow running you need the stop times.
Does it work for a night shift that crosses midnight?
Yes. Enter the start time and the shift length, for example 22:00 and 8 hours. The rows run past midnight, and a break at 02:00 lands in the 02:00 to 03:00 row.