How to Calculate Production per Hour in Excel (4 Methods)

Method 1 – Using Target Efficiency and Working Period

Start with a productive facility that has 6 working units. Each unit has its own machine efficiency.
Before beginning mass production, each production house sets its own target efficiency.
To calculate production per hour, follow these steps:
- Record the total production hours.
- Divide the total production units by the total production hours. This method provides one way to calculate production per hour.
Alternatively, you can estimate production per hour using formulas based on observations over a specific time period.
To calculate production per hour using a formula, gather the following information:
- Target Efficiency
- Working Period
- Machine Efficiency
Use the following formula to calculate production per hour:

Production per Hour = (Target Efficiency x Working Period) x Machine Efficiency

In Excel:

=ROUND(($D$4/D7)*C7*100,2)

In the formula:

- $D$4 contains the Target Efficiency.
- D7 provides the Working Period.
- C7 contains Machine Efficiency.
- The ROUND function ensures the result is rounded to 2 decimal places.

You’ll see the estimated production per hour for all the units of the production house.

Gather the following information:
- Total Production Units Produced
- Total Elapsed Time (in hours)

=ROUND(C5/D5,0)

- Explanation
  - C5 carries Total Production Units.
  - D5 corresponds to the Total Elapsed Time (in hours).
  - The ROUND function ensures the result is rounded to the nearest whole number.

Drag the Fill Handle icon from cell E5 up to E10 to apply the same formula to all cells.

The calculated production per hour for all units will be displayed as shown in the image below:

The formula to calculate estimated production per hour for multiple factories is:

Production per Hour = (Target Efficiency x Working Period) x Machine Efficiency x No. of Factories

To calculate the estimated production per hour in Excel:
- Select cell F7.
- Insert the following formula:

=ROUND(($D$4/D7)*C7*E7*100,0)

- Explanation:
  - $D$4 contains the Target Efficiency.
  - D7 supplies the Working Period.
  - C7 contains Machine Efficiency.
  - E6 represents the No. of Factories.
  - The ROUND function ensures the result is rounded to the nearest whole number.
Press ENTER to execute the formula.
Drag the Fill Handle icon from cell F7 to F12 to apply the same formula to all cells.

After following these steps, you will see the estimated production per hour for all units as shown in the image below:

=ROUND(C5*E5/D5,0)

- Explanation:
  - C5 represents the Total Production Units.
  - E5 represents the Number of Factories.
  - D5 corresponds to the Total Elapsed Time (in hours).
  - The ROUND function ensures the result is rounded to the nearest whole number.
Press ENTER to execute the formula.
Drag the Fill Handle icon to the end of the Production per Hour column.