NovaCart · Resource Planning & Capacity Intelligence
Every figure below is generated from DC_Capacity_Forecast.xlsx — a demand-allocation model that turns a single network-wide sales forecast into per-DC, per-time-window delivery forecasts, with capacity risk detection, staffing needs, and what-if scenario simulation. This page opens instantly from a build-time snapshot; use Reload live from Excel to re-read the workbook directly when serving this project over a web server.
The recurring spikes are demand rolling forward from DCs that close one day a week
Average across the horizon
Sorted highest to lowest; red = overflow/high risk, grey = surplus
Network-wide daily items, capacity-constrained prediction
Capping a bad forecast at capacity can hide real model error — this separates the two
Share of demand fulfilled same-day (not deferred)
DC / time-window slots with deferred demand still unresolved when the 30-day forecast ends
| DC ID | DC Name | Service Type | State | Time Scope | Undelivered Items |
|---|
+50% capacity scenario, ranked by economic value
At-risk DCs paired with the best-fitting surplus donor DC
| At-Risk DC | Utilization | Donor DC | Donor Utilization | Type Match | Suggested Transfer (shifts/day) |
|---|