Spreadsheet: 845441d1696958058-pivot-with-multiple-tabs-as-range-forecasts-and-orders-10102023
Sheet: PRI

Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI |  | Order Date | PO | Description | Item Code | Qty |  | Order Date | PO | Description | Item Code | Qty
PRIME BLU RAZZ 12/16Z BTL | 09723 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-10-04 00:00:00 | 296862 | PRIME GRAPE 12/16Z BTL | 09727 | 25 |  | 2023-03-16 00:00:00 | 297155 | PRIME GRAPE 12/16Z BTL | 09727 | 12
PRIME BLU RAZZ 3/8/16Z BTL | 10753
PRIME ENRGY BL 24/12Z CN | 10579 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-10-24 00:00:00 | 296897 | PRIME GRAPE 12/16Z BTL | 09727 | 25 |  | 2023-03-16 00:00:00 | 297161 | PRIME ORANGE 12/16Z BTL | 09725 | 12
PRIME ENRGY IC 24/12Z CN | 11006
PRIME ENRGY LE 24/12Z CN | 10580 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-11-15 00:00:00 | 296911 | PRIME TROP PNC 12/16Z BTL | 09726 | 25 |  | 2023-03-16 00:00:00 | 297169 | PRIME ORANGE 12/16Z BTL | 09725 | 12
PRIME ENRGY OR 24/12Z CN | 10581
PRIME ENRGY ST 24/12Z CN | 10583 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-11-15 00:00:00 | 296913 | PRIME GRAPE 12/16Z BTL | 09727 | 25 |  | 2023-03-16 00:00:00 | 297171 | PRIME GRAPE 12/16Z BTL | 09727 | 12
PRIME ENRGY TR 24/12Z CN | 10582
PRIME GRAPE 12/16Z BTL | 09727 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-06 00:00:00 | 297010 | PRIME GRAPE 12/16Z BTL | 09727 | 25 |  | 2023-03-16 00:00:00 | 297177 | PRIME ORANGE 12/16Z BTL | 09725 | 12
PRIME ICE POP 12/16Z BTL | 10157
PRIME ICE POP 3/8/16Z BTL | 10754 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-20 00:00:00 | 297095 | PRIME ORANGE 12/16Z BTL | 09725 | 25 |  | 2023-03-16 00:00:00 | 297187 | PRIME GRAPE 12/16Z BTL | 09727 | 12
PRIME LEMN LIM 12/16Z BTL | 09724
PRIME LEMN LIM 3/8/16Z BTL | 10755 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-03-03 00:00:00 | 297120 | PRIME ORANGE 12/16Z BTL | 09725 | 25 |  | 2023-04-04 00:00:00 | 297231 | PRIME GRAPE 12/16Z BTL | 09727 | 12
PRIME LEMONADE 12/16Z BTL | 10968
PRIME [NAME] 12/16Z BTL | 10392 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-03-03 00:00:00 | 297123 | PRIME LEMN LIM 12/16Z BTL | 09724 | 25 |  | 2023-04-04 00:00:00 | 297239 | PRIME GRAPE 12/16Z BTL | 09727 | 12
PRIME [NAME] 3/8/16Z BTL | 10756
PRIME ORANGE 12/16Z BTL | 09725 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-03-03 00:00:00 | 297124 | PRIME GRAPE 12/16Z BTL | 09727 | 25 |  | 2023-04-04 00:00:00 | 297241 | PRIME ORANGE 12/16Z BTL | 09725 | 12
PRIME STRWB WT 12/16Z BTL | 10597
PRIME STRWB WT 3/8/16Z BTL | 10758 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-03-10 00:00:00 | 297148 | PRIME ICE POP 12/16Z BTL | 10157 | 25 |  | 2023-04-04 00:00:00 | 297243 | PRIME ORANGE 12/16Z BTL | 09725 | 12
PRIME TROP PNC 12/16Z BTL | 09726
PRIME TROP PNC 3/8/16Z BTL | 10757 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-03-10 00:00:00 | 297150 | PRIME GRAPE 12/16Z BTL | 09727 | 25 |  | 2023-04-04 00:00:00 | 297245 | PRIME GRAPE 12/16Z BTL | 09727 | 12
PRIME GLOWBRY 12/16.9Z BTL | 11073
PRIME GLOWRARE 12/16.9Z BTL | 11163 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-08-31 00:00:00 | 297445 | PRIME ENRGY TR 24/12Z CN | 10582 | 8
PRIME GLOWULTR 12/16.9Z BTL | 11164 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRIME ENRGY BL 24/12Z CN | 10579 | 12
Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI
PRIME BLU RAZZ 12/16Z BTL | 09723
PRIME BLU RAZZ 3/8/16Z BTL | 10753
PRIME ENRGY BL 24/12Z CN | 10579
PRIME ENRGY IC 24/12Z CN | 11006
PRIME ENRGY LE 24/12Z CN | 10580
PRIME ENRGY OR 24/12Z CN | 10581
PRIME ENRGY ST 24/12Z CN | 10583
PRIME ENRGY TR 24/12Z CN | 10582
PRIME GRAPE 12/16Z BTL | 09727
PRIME ICE POP 12/16Z BTL | 10157
PRIME ICE POP 3/8/16Z BTL | 10754
PRIME LEMN LIM 12/16Z BTL | 09724
PRIME LEMN LIM 3/8/16Z BTL | 10755
PRIME LEMONADE 12/16Z BTL | 10968
PRIME [NAME] 12/16Z BTL | 10392
PRIME [NAME] 3/8/16Z BTL | 10756
PRIME ORANGE 12/16Z BTL | 09725
PRIME STRWB WT 12/16Z BTL | 10597
PRIME STRWB WT 3/8/16Z BTL | 10758
PRIME TROP PNC 12/16Z BTL | 09726
PRIME TROP PNC 3/8/16Z BTL | 10757
PRIME GLOWBRY 12/16.9Z BTL | 11073
PRIME GLOWRARE 12/16.9Z BTL | 11163
PRIME GLOWULTR 12/16.9Z BTL | 11164