How to Determine the average output in Excel
For this example, we will create a worksheet given the start and end dates of a certain production line. In order to determine the average output of this production line, we will need to use the production line’s output over the start and end dates. With that said, here is how we would go about calculating the average daily production.
How to Calculate Average Daily Production
- Open Microsoft Excel (Any version including 97, 2003 and 2007)
- Select cell B1 and type 9/14/2007 as your end date.
- Select cell B2 and type 9/14/2004 as your start date
- Type 84,350 in cell B3. This is your production lines output over the period
- Select cell B5 and type the following formula: =B3/(B1-B2).
Doing this will give you the average daily output. You should now be set.
