How to Make Daily Production Report in Excel (Download Free Template)

Essential Parts of a Daily Production Report

• The list of products, order ID, number of orders, and delivery or a completion date of each step.
• Cumulative progress of each step and percentage of completion of total orders.

How to Make a Daily Production Report in Excel

Steps to Make a Daily Production Report in Excel

We’ll create a template for a garment production facility report.

• We have a fixed order number, product name, color, order quantity, and the last date of Shipment.
• Let’s assume the company needs to produce 1% more product than the order quantity.
• You have fours steps in the production:
  1. Cutting
  2. Stitching
  3. Packing
  4. Shipment
• We have to show the progress by adding the total number and percentage of completion in each step.
• We also show the remaining shipment days to help prioritize the products which have less time remaining.

Step 1 – Create a Blank Report

• Make a data table by listing the steps and procedures of the production.

Step 2 – Convert to a Table

• Select all the cells needed and go to the top ribbon.
• Go to the Insert tab and choose the Table option. There will open a window.
• Check the box My table has headers.
• Press OK. 

• You will get a sorting option under each header.

Step 3 – Input Product Data

• Use sample data or the data from your company to fill in the values you have.

Step 4 – Make a New Worksheet

• Copy and paste the worksheet. We named the first one as MainPage and renamed the second one to the current date.

Step 5 – Insert Formulas for Total Values

These formulas will be used:

• On the page with the date for the name, use this formula for the Total Cutting Column

• To write this formula manually, write ‘ = ’ and press on the cell F5 and write ‘+’, then go to the Main Page worksheet and select the G5 cell. Then you will see the same command written above.
• This command will sum the column Today Cutting from this worksheet and Total Cutting column from the Main Page worksheet. 

Input the following commands in the Total Stitching, Total Packing, and Total Shipment columns, respectively.

Total Stitching:

Total Packing:

Total Shipment:

Step 6 – Calculate the Cutting Percentage

The following formula will be used:

• Go to the first cell of the column in the table and write this formula.

• You can also insert the following:

Step 7 – Calculate the Balance Columns

• Stitching Balance – difference between Total Cutting and Total Stitching.
• Use one of the following formulas in the column.

OR

• Packing Balance: Remaining amount of unpacked products, equal to Total Stitching – Total packing.
• Insert the following formula in the column.

OR

Step 8 – Add the Remaining Shipment Days Column

• Add another column to calculate the remaining shipment days. 
• Select the cells in the column, go to the top ribbon, and select the General Format. 
• Use this formula to calculate the remaining shipment days:

Step 9 – Save the Workbook

• Input the daily data in the blank columns as per the headings.

• Go to File, then to Save As, select the location, name the file and press Save.

Step 10 – Open and Rename the Worksheet for the Next Day

• On the next day, you will use this file to make a new one.
• Rename the Worksheet as per the date. Right-click on the worksheet name and select Rename.

Step 11 – Save the Workbook for the Next Day and Copy the Total Columns

• Input the day’s date in the date cell. Save the file with a new name to use the new date.
• Copy the cells of columns named Total Cutting, Total stitching, Total Packing, and Total Shipment. 

Step 12 – Paste the Total Columns to the Main Page

• Go to the MainPage worksheet.
• Paste the cells there as per column respectively by using Ctrl + V.

Step 13 – Delete the Cells of Today’s Columns

• Go to today’s worksheet.
• Delete the cells in the columns named Today Cutting, Today stitching, Today Packing, and Today Shipment. 

Final Step – Input New Data

• Input today’s data in those deleted cells.

• Repeat these steps to make the report for the next day.

Use Conditional Formatting to Highlight Remaining Shipment Days

• Select the cells of the column and select the Conditional Formatting option in the Home tab.
• Select Color Scales. 
• Select the first option on the list.

• The lowest values are in red color, which will help you to identify the closest shipment day of any product.

Things to Remember

• After clicking on the top-right corner where the cell name shows, you will see a drop-down menu. Here, Table 1 is mentioning the table on the Main Page and Table 15 is mentioning the table on the second page.

• Save the file with a new date as the name daily and repeat Steps 11 and onward to make the changes to the new sheet.
• You can customize this file as per your demand.

Download the Free Template

Related Articles

• How to Create an Expense Report in Excel
• How to Make Production Report in Excel
• How to Create an Income and Expense Report in Excel
• How to Make Daily Activity Report in Excel
• How to Make Monthly Report in Excel
• How to Make a Monthly Expense Report in Excel

<< Go Back to Report in Excel | Learn Excel