Demand Planning & Inventory Dashboard

The challenge

Weekly production was ramping with no visibility into output scaling, inventory on hand, or how customer orders would draw it down.

• Weekly production was scaling fast with no visibility into output trajectory. Capacity was doubling on a predictable curve, and no tool tracked where it was headed.
• Customer commitments were managed in spreadsheets and memory. Recurring weekly orders, one-time pickups, and tentative holds were not consolidated anywhere.
• No way to answer the basic question: given current production and known orders, when does inventory run out?

The solution

• Capacity projection engine models production with an exponential doubling formula, with manual overrides for weeks where capacity deviates from the curve.
• Recurrence engine expands weekly, biweekly, monthly, and quarterly commitments into concrete scheduled deliveries, merged with one-time orders from the CRM.
• Drag-and-drop week and month views with utilization color coding let operators reschedule commitments and immediately see the impact on capacity.

Technology stack

• CRM integration
• Capacity projection engine

Measurable results

• Real-time supply-demand visibility replaced a mental model that broke every time a new customer came on board.
• Recurring order automation eliminated the weekly spreadsheet reconciliation that consumed the first hour of every Monday.
• TV dashboard mode gives the production floor a live view of upcoming demand without needing to check a phone or laptop.