Daily Production Report Sheet

Track daily production output, machine utilization, downtime, and rejection rates with this simple Excel sheet.

Track Production Efficiency

The Daily Production Report (DPR) is the heartbeat of the shop floor. It provides a snapshot of what happened during the shift, highlighting successes and bottlenecks.

What Data Should Your DPR Capture?

Data Point	Why It Matters	How to Measure
Target Quantity	Sets performance expectation	Based on cycle time × shift hours
Actual Quantity	Real production output	Count finished pieces
Rejection Qty	Quality performance indicator	Count defective parts
Downtime (minutes)	Lost production time	Log every stoppage with reason
Operator Name	Accountability & skill tracking	Record who ran the machine
Raw Material Used	Material consumption tracking	Weight/quantity issued vs consumed

How to Fill the DPR (Step-by-Step)

For each shift:

Shift Start: Note shift timing (e.g., Day: 8 AM - 4 PM), supervisor name, and operator names.
Set Target: Based on work order, calculate expected production for the shift.
Record Production: At end of shift, count all completed parts (OK pieces).
Log Rejections: Count and categorize rejected parts by defect type.
Track Downtime: For every stoppage, note: Time, Duration, Reason (breakdown, material shortage, power cut, etc.).
Material Consumption: Record quantity of raw material consumed during shift.
Supervisor Sign-off: Supervisor verifies data and signs the report.
Handover: Submit DPR to production manager and next shift supervisor.

Sample DPR Entry from a CNC Shop

Date: 10-Feb-2026 | Shift: Day (8 AM - 4 PM) | Machine: CNC Lathe #2

Operator: Ramesh Kumar
Item Produced: Shaft - SKU: SH-100
Target Quantity: 120 pieces
Actual Produced: 105 pieces (OK)
Rejected: 8 pieces (6 - Dimensional, 2 - Surface finish)
Downtime: 45 minutes (Tool change: 20 min, Material wait: 25 min)
Raw Material Used: 52 kg MS Rod
Remarks: Tool wore out faster than expected. Need to order new carbide inserts.

Achievement: 87.5% (105/120) |{" "} OEE: ~82%

Calculating Key Metrics from DPR

Use DPR data to calculate:

Production Efficiency: (Actual / Target) × 100
Example: (105/120) × 100 = 87.5%
Rejection Rate: (Rejected / Total Produced) × 100
Example: (8/113) × 100 = 7%
Machine Utilization: ((Shift Hours - Downtime) / Shift Hours) × 100
Example: ((480 - 45) / 480) × 100 = 90.6%

Common Mistakes

⚠️
Incomplete Downtime Reasons: Writing “Machine Issue” instead of specific problem hides root causes.
⚠️
Inflated Numbers: Operators reporting false production to meet targets.
⚠️
Not Collecting DPR Daily: Waiting till week-end makes data inaccurate.
⚠️
No Supervisor Verification: Unchecked data leads to wrong decisions.

Best Practices

Shift Handover Meeting: Outgoing shift supervisor briefs incoming supervisor using DPR.
Daily Review: Production manager reviews all DPRs every morning.
Trend Analysis: Plot weekly graphs of efficiency, rejection, and downtime.
Operator Training: Teach operators why accurate reporting helps them too (better planning = less pressure).
Digital Photos: Click photo of DPR and share on production WhatsApp group for visibility.