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.
Download Practice Workbook
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.