Home › Excel case studies › Production Downtime & Defect Analysis (OEE)

Production Downtime & Defect Analysis (OEE)

A plant with 5 lines and 3 shifts is missing deliveries and scrapping more. Measure real efficiency and find what’s stealing the time. **What you’ll learn:** Availability, Performance, Quality and OEE from summed totals Cleaning shift logs with inconsistent line and shift names Downtime Pareto and a Line x Shift comparison

Open this Excel case study

Work on a realistic business scenario for data analytics and business analytics practice. See the full details and get the assignment on Cellgrids.

View case study → Free Excel formula practice

All Excel case studies · Excel interview prep · Excel formulas