Manufacturing Production Report Format in Excel (Daily and Weekly)
A manufacturing production report records what each line was supposed to make, what it made, what was good, and why time was lost. This worksheet replaces the usual Excel sheet: enter one row per line and shift and it calculates availability, performance, quality and OEE for you.
| Date | Shift | Line / machine | Planned time (min) | Downtime (min) | Ideal rate (parts/hour) | Total produced | Good units | Scrap + rework | Availability % | Performance % | Quality % | OEE % | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12 | 90.625 | 94.2529 | 97.0732 | 82.9167 | |||||||||
11 | 85.4167 | 90.7317 | 97.043 | 75.2083 | |||||||||
19 | 93.75 | 87.7778 | 97.5949 | 80.3125 | |||||||||
25 | 88.5417 | 89.4118 | 96.7105 | 76.5625 | |||||||||
7 | 94.7917 | 94.9451 | 98.3796 | 88.5417 |
Ideal rate is the fastest rate the line can run steadily on this part, not the average. Performance above 100 percent means the ideal rate is set too low. Add rows for each line and shift, then export to Excel for the weekly pack.
Populate this report from your ERP
Optional: we can map the columns to your production order and scrap tables.
Optional. The tool and every export work without this. No spam.
How to use this production report format
Add one row per line and shift. Enter planned production time and downtime in minutes, the ideal rate in parts per hour, total produced and good units. Scrap and the OEE factors calculate automatically. Use the date column to build a daily report, or export a full week to Excel and filter by line. Replace the sample rows with your own; the totals and first pass yield update as you edit.
What is a manufacturing data report
A manufacturing data report is a structured record of production facts for a period: quantities, time, losses and quality, usually by line, shift and part. It exists so that decisions about staffing, maintenance and scheduling rest on counted data. The core columns are always the same, even when the plant adds part number, work order, operator or reason codes.
- Identity: date, shift, line or machine, part and work order.
- Time: planned production time, downtime, and the reason for each stop.
- Output: total produced, good units, scrap and rework.
- Derived: availability, performance, quality and OEE.
The formulas behind the OEE columns
Availability is run time divided by planned time. Performance is actual output divided by what the ideal rate would have produced in the run time. Quality is good units divided by total produced. OEE is the product of the three, which reduces to good units times 60 divided by ideal rate times planned minutes. Example: 480 planned minutes, 45 down, ideal rate 60 per hour, 410 made and 398 good gives availability 90.6 percent, performance 94.0, quality 97.1, OEE about 82.9.
Where the data comes from and common mistakes
Produced and good quantities come from production order completions or machine counters; scrap comes from reject postings. Downtime comes from operator logs or MES. The usual mistakes are counting planned breaks as downtime, using an average rate as the ideal rate, and treating rework as good output. Agree the definitions once, write them on the report, and keep them stable, otherwise trends mislead.
Frequently Asked Questions
What should a daily production report contain?
At minimum: date, shift, line, planned time, downtime with reasons, produced and good quantities, scrap, and the headline KPIs. Add part numbers and work orders if you run several products per line, so the report ties back to your ERP.
How do I convert this to a weekly production report?
Add rows for each day, export to Excel, and use a pivot table on the line column. Sum produced, good and downtime, then recalculate OEE from the sums or average the daily values, whichever your plant has agreed to use.
Why is my performance percentage over 100?
The ideal rate you entered is lower than the line actually achieved. Set the ideal rate to the best sustained rate for that part, from the routing standard or a proven demonstration run, and keep it fixed so OEE stays comparable.
Is OEE the same as efficiency?
No. Labor or machine efficiency usually compares actual to standard hours. OEE includes availability, performance and quality against planned time, so it also exposes downtime and defects that an efficiency number can hide.
If this data already lives in your ERP or MES, we can generate the daily report automatically from it, and answer questions about it in plain language, on your own servers if required.
Related Tools
Manufacturing MIS Report Template
Fill in one monthly MIS report for a manufacturing company: production, quality, delivery, inventory and cost, with the ERP source of each number.
MES & Shop FloorShift Production Report Template
A fill-in shift report covering output versus target, scrap, downtime, safety, staffing and handover notes, exported as a ready to print document.
MES & Shop FloorInjection Molding OEE Calculator
Calculate availability, performance, quality and overall equipment effectiveness for a molding press from a shift or day of production data.
More MES & Shop Floor tools
See all- Line Balancing Worksheet
- SMED Changeover Reduction Worksheet
- Finite Capacity Scheduling Worksheet
- Production Schedule Template
- Bottleneck Analysis Calculator
- Drum Buffer Rope Buffer Sizing Calculator
- Production Schedule Adherence Calculator
- Production Schedule Release Checklist
- Daily Production Schedule Board Worksheet
Keep exploring
Free tools
- Manufacturing Daily Production Report FormatAn editable daily or shift production report by machine, with planned and good quantity, scrap, downtime and labor, plus calculated yield and plan attainment.
- Shift Production Report TemplateA fill-in shift report covering output versus target, scrap, downtime, safety, staffing and handover notes, exported as a ready to print document.
- Molding Shift Production Report TemplateA shift report for a molding department capturing output, downtime, scrap and issues for the next shift.
ERP fixes and how-tos
- How to Calculate OEE from MES Data and ERP StandardsHow to calculate OEE correctly from MES events and ERP routing standards: planned time, availability, performance, quality, ideal cycle time and common data traps.
- Infor LN Date Format: User, Language, Reports and IntegrationsHow date formats work in Infor LN: user and language settings, Web UI locale, reports, and how to handle date conversion in integrations and BODs.