Innov8 PSA Forecast: accessible HTML prototype for Coca-Cola Consolidated
PSA Forecast
by Superchannel · 6mo
by Superchannel · 6mo
331,633
PSA Forecast
by VPO · 6mo
by VPO · 6mo
331,633
PMC Forecast
6mo
6mo
—
FFA Forecast
12.5w
12.5w
—
Final Forecast
12.5w
12.5w
331,633
Operational Forecast
8w
8w
331,633
PSA NAOU Import
last generated —
last generated —
—
Deployment Plan
331,633
Production Plan
331,633
NAOU Size of the Prize
Annual Total US
4,000,000
Scaling
20%
Est. CCCI Annual
800,000
Est. CCCI Weekly
15,385
PSA · 13w Total
648,356
Per Week: 49,873
PSA · 52w Total
648,356
PMC · 13w Total
—
computed
PMC · 52w Total
—
computed
PSA Comments (Required)
Select single, multiple, or ALL
Managed By
<multiple> ▾
Owned By
<multiple> ▾
Confirmed: Owned By + Managed By selections can merge — e.g. Kroger "Owned By" + Safeway "Managed By."
VPO (CS / Outlet) — determined off-line for MVP
| Load-In | Replen | Total | |
|---|---|---|---|
| CS | 4 | 7 | — |
| # of Weeks | 1 | 51 | 52 |
Confirmed: # of Outlets = 26w Volume > 0 and Status = Active.
DOWNSTAIRS · PSA by Managed By
| Managed By | Outlets | Load-In | Replen | 13wk Total | 52wk Total (PSA) |
|---|---|---|---|---|---|
| WALMART | 790 | 3,160 | 5,530 | 69,520 | 285,190 |
| WALMART NHM | 154 | 616 | 1,078 | 13,552 | 55,594 |
| MEIJER | 100 | 400 | 700 | 8,800 | 36,100 |
| KROGER CINCINNATI | 105 | 420 | 735 | 9,240 | 37,905 |
| KROGER COLUMBUS | 103 | 412 | 721 | 9,064 | 37,183 |
| KROGER CENTRAL | 97 | 388 | 679 | 8,536 | 35,017 |
| KROGER LOUISVILLE | 86 | 344 | 602 | 7,568 | 31,046 |
| KROGER NASHVILLE | 72 | 288 | 504 | 6,336 | 25,992 |
| KROGER MID ATLANTIC | 107 | 428 | 749 | 9,416 | 38,627 |
| KROGER DELTA | 59 | 236 | 413 | 5,192 | 21,299 |
| KROGER ATLANTA | 12 | 48 | 84 | 1,056 | 4,332 |
| SAFEWAY | 111 | 444 | 777 | 9,768 | 40,071 |
| Walmart Total | 944 | 3,776 | 6,608 | 83,072 | 340,784 |
| Kroger Total | 641 | 2,564 | 4,487 | 56,408 | 231,401 |
Select single, multiple, or ALL
Bus Segment
HOME MARKET; ON PREMISE ▾
PPG
SSD 12oz Can 12pk Core (2ct) ▾
Bev Product
COCA-COLA CHERRY ZERO ▾
Managed By
<ALL> ▾
Timeframe
Delivered history used to weight the PSA Mix % by Source Plant.
DELIVERED by Source Plant → PSA Mix % → Annual PSA
| Source Plant | Source Plant Descr. | Delivered | PSA Mix % | Annual PSA |
|---|---|---|---|---|
| C000 | JOHNSON CITY, TN DC | −50* | — | — |
| C001 | MORRISTOWN, TN DC | −50* | — | — |
| C003 | LOUISVILLE, KY DC | 64,155 | 5.48% | 49,303 |
| C004 | KNOXVILLE, TN DC | 25,731 | 2.20% | 19,774 |
| C005 | CLEVELAND, TN DC | 10,700 | 0.91% | 8,223 |
| C006 | LEXINGTON, KY DC | 30,618 | 2.61% | 23,530 |
| C007 | PADUCAH, KY DC | 6,335 | 0.54% | 4,868 |
| C014 | NORFOLK, VA DC | 24,773 | 2.12% | 19,038 |
| C016 | STAUNTON, VA DC | 5,517 | 0.47% | 4,240 |
| C017 | FREDERICKSBURG, VA DC | 14,884 | 1.27% | 11,438 |
| C021 | SALISBURY, MD DC | 16,435 | 1.40% | 12,630 |
| C024 | BALTIMORE, MD DC (HANOVER) | 66,943 | 5.72% | 51,445 |
* Negative delivered values are ignored in the PSA Mix % calculation.
PSA Comments (Required)
Large Store
Small Store
Value
Drug
Club
On Premise
250,000
400,000
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
250,000
400,000
650,000 Total (Final PSA)
Dataset Summary
| Bus Segment: | HOME MARKET; ON PREMISE |
| Superchannel: | LARGE STORE |
| PPG: | SSD 12oz Can 12pk Core (2ct), SSD 12oz Can 12pk Flavors (2ct) |
Superchannel Comments
Timeframe
○ ALL
+ ○ 2020
○ 1
○ 2
○ 3
○ 4
Delivered Wkly Avg 93,735 · # of Wks 2/8 · Totals 187,470 / 71,000
Load-InReplen
Large Store
Small Store
Value
Drug
Club
On Premise
250,000
650,000 Total (Final PSA)
Filter Drawer
×
PSA Forecast
2026 Cherry Diet Coke 12oz 12pk
In Market:
LTO/Sustaining
LTO/Sustaining
PSA
PMC
FFA
PMC
FFA
Filter the canvas by:
Bus Segment▾
Superchannel▾
PPG▾
Bev Product▾
Managed By▾
Owned By▾