# How to Make Production Report in Excel (2 Common Variants)

Get FREE Advanced Excel Exercises with Solutions!

It is very important for every company to have records of their works. They keep their records through production reports and Excel is an amazing software to make production report. In this article, we are going to discuss making two different types of production reports in Excel.

## How to Make Production Report in Excel (2 Common Variants)

### 1. Making of Daily Production Report in Excel

We can make a daily production report using MS Excel.

Steps:

• First of all, Create a table. I have created a table to record Production in Percentage, Incomplete Quantity, and Incomplete Production in Percentage according to a particular product.

• Use Font groups in the Home tab to modify your dataset according to your choice.

• Input your data of a particular date.

• In order to find out Production in Percentage, use the following formula:
`=E6/D6`

Where Manufactured Quantity is divided by Target Quantity.

• AutoFill the rests.

• Now, Select Percentage from the Number group under the HomeÂ tab.

• To Calculate the Incomplete Quantity, use the following formula:
`=D6-E6`

Where Target Quantity is subtracted with the Manufactured Quantity.

• Use Fill Handle to AutoFillÂ till the last.

• To find out Incomplete Production in Percentage, use the following formula:
`=G6/D6`

Where Incomplete Quantity is divided by Target Quantity.

• Finally, AutoFill the rests.

• Click on Percentage to complete making the production report.

Thatâ€™s it. This is highlighting the production information on a daily basis. For the different companies, the template or need for information can be different, you may need to adjust a few columns.

### 2. Making of Monthly Production Report

We can also make monthly production report using Excel.

Steps:

• Form a table first. I have created a table to record Total Working Hours, Production Per Hour with the help of Manpower, Working Hours and Manufactured Quantity.

• Use the Font group in the Home tab to decorate the dataset.

• Use the following formula to calculate Total Working Hours :
`=D5*E5`

Where Manpower is multiplied with Working Hours.

• Then, fill the rests with AutoFill.

• We can calculate Production Per Hour using the following formula:
`=G5/F5`

Where Manufactured Quantity is divided by Total Working Hours.

• Use AutoFill for the remaining cells.

## Conclusion

I have tried to explain the procedure to make a production report in Excel in two different ways. Hopefully, it will be helpful for Excel users. For any more questions, comment below.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Naimul Hasan Arif

Hello everyone, I am Naimul Hasan Arif, graduated from Bangladesh University of Engineering and Technology (BUET). I am working as an Excel and VBA Content Developer. I try to remain dedicated to my duties and give my best with my skills & knowledge.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF