OEE Lab / Tools / Hourly Production Target Calculator

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.

Shift
h
Breaks and meals
If it keeps running, the break hours keep their full target.
min
min
min
min
A break that runs over the hour is split between the two rows. Breaks count in whole minutes, so 7.5 min is rounded to 8. Leave a row empty if you do not need it.
Planned stops
min
min
min
Planned stops come out of planned production time. A stop longer than the time left in its hour runs on into the next hour. If your plant counts cleaning inside OEE (Hansen counts machine clean plus changeover as a planned stop inside scheduled time), enter it as changeover instead.
Changeover (optional)
min
It stays in planned time, as OEE counts it, but the board makes no units in it. Set 0 if your target % already allows for changeovers.
Speed and target
The fastest proven speed for this product, not the average.
%
OEE: room for short stops, slow running and scrap, so a normal hour can meet it.
Defaults: 06:00 to 14:00, 600 units an hour, 70% OEE
Target for the shift
-
Sum of the hourly targets on the board
Planned time
-
Producing time
-
Target, full hour
-
Ideal, full hour
-
OEE the board asks
-
Off the line
-
Actuals so far
Made so far
-
Gap so far
-
Stops and speed (A × P)
-
OEE estimate
-

Pick Fill in actuals on the board below. Actuals stay in this browser and are not part of the share link.

The board sets the target. It does not measure the line. It knows the minutes you planned, not the stops that happened. A count written by hand is only as good as the person who writes it, and from hourly counts alone the board cannot split stop time from slow running. Use it to make each hour's gap visible and to collect the reasons.

Hour-by-hour board

One row per clock hour. Each hour is rounded so the rows add up exactly to the shift total.

HourPlanned minPlanned minTargetCumulative targetCum. targetActualCumulative actualCum. actualGapCumulative gapCum. gapReason 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

    Hour by hour

      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.

      Sent. A Fabrico OEE specialist will read your numbers and get back to you by email.

      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.

      See target against actual on your own lines: book a demo with a Fabrico consultant.

      Request a demo
      Our tools stay free either way.

      What 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.

      HourOff the lineProducing minTargetCumulative
      06:00-07:00start-up 10, meeting 545315315
      07:00-08:00none60420735
      08:00-09:00none604201,155
      09:00-10:00break 15453151,470
      10:00-11:00changeover 20402801,750
      11:00-12:00meal, first 15 of 30453152,065
      12:00-13:00meal, last 15 of 30453152,380
      13:00-14:00cleaning 15453152,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

      1. 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.
      2. 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.
      3. 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.
      4. 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.
      5. 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.
      6. 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.

      ← All OEE Lab tools · Open the OEE calculator