Manufacturing Dashboard (Excel): OEE, Downtime, Quality and SPC

Find where every planned hour went, price what winning it back is worth, and run the morning meeting from one printed page.

What is inside

• Loss Hunter: every planned hour of the month in the six big losses, per machine. Type how much of each loss you can win back: new OEE, extra good units, margin a year, payback, demand vs capacity.
• Dashboard: headline, 6 KPI cards, OEE loss waterfall, OEE by machine and shift, downtime Pareto, reliability map, daily output vs plan, cost of poor quality, fix-first list.
• Daily Review: one A4 page for one day.
• KPI Scorecard: 37 KPIs with target, status and a 12-month trend line.
• Quality & SPC: X-bar and R charts, Cp and Cpk, defects by product, first pass yield.
• Chart Library (16 charts), Advanced Analytics (11 methods).
• Data tabs: Production, Downtime, Defects, Measurements, Maintenance, Energy, Safety, Machines, Products, Specs, Settings.

Who it is for

• Plant managers, process and quality engineers, owners of small manufacturers.

Format

• One ZIP: the Excel workbook (.xlsx) + a PDF user guide.
• Needs Excel for Microsoft 365, Excel 2024 or Excel for the web (free at office.com). Excel 2019 / 2016 and Google Sheets cannot run its formulas.
• No macros, no add-ins. Windows and Mac.
• Comes with fictional sample data: replace it with yours in the data tabs.
• Instant download after payment.