Supply Chain Dashboard (Excel): Inventory, Reorders, Suppliers and Fill Rate

What you hold, what to order, which suppliers let you down, and whether customers get what they ordered.

What is inside

• Reorder Desk: every item projected 13 weeks ahead with the open purchase orders arriving: what is out, what to expedite, what to order now and this week, how much and from whom. What-if for demand, supplier delay and order cover.
• Dashboard: headline, 6 KPI cards, ABC-XYZ matrix, stock by category, cover vs lead time, supplier scorecard, stock by last use, usage forecast, reorder list.
• Weekly S&OP: one A4 page for one week.
• KPI Scorecard: 36 KPIs with target, status and a 12-month trend line.
• Inventory Planning (safety stock, reorder point, EOQ), Chart Library (16 charts), Advanced Analytics (11 methods).
• Data tabs: Items, Movements, Purchase Orders, Customer Orders, Suppliers, Settings.

Who it is for

• Operations, purchasing and warehouse managers; owners of businesses that hold stock.

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.