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

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
ALANI ARCT WHT 24/12Z CN | 09580 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-09-06 00:00:00 | 297450 | ALANI PRO CHOC 12/12Z BTL | 10844 | 3
ALANI BERRYPOP 24/12Z CN | 10000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALANI PRO COOK 12/12Z BTL | 10843 | 3
ALANI BERRYPOP 4/6/12Z CN | 10522 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALANI PRO VANI 12/12Z BTL | 10847 | 3
ALANI BLU SLSH 2/12/12Z CN | 10303
ALANI BLU SLSH 24/12Z CN | 09581 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | 2023-09-11 00:00:00 | 297458 | ALANI BLU SLSH 24/12Z CN | 09581 | 1
ALANI BLU SLSH 4/6/12Z CN | 09664 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALANI BREEZBRY 24/12Z CN | 09582 | 2
ALANI BREEZBRY 2/12/12Z CN | 09615 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALANI BREEZBRY 4/6/12Z CN | 09620 | 1
ALANI BREEZBRY 24/12Z CN | 09582 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  | ALANI CHRY SLU 2/12/12Z CN | 09617 | 1
ALANI BREEZBRY 4/6/12Z CN | 09620 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  | ALANI CHRY SLU 24/12Z CN | 09583 | 6
ALANI CHRY SLU 2/12/12Z CN | 09617 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALANI CHRY SLU 4/6/12Z CN | 09619 | 2
ALANI CHRY SLU 24/12Z CN | 09583 |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  | ALANI COSMC ST 4/6/12Z CN | 09618 | 2
ALANI CHRY SLU 4/6/12Z CN | 09619 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALANI DREAM FL 24/12Z CN | 09762 | 2
ALANI COFF CAP 12/12Z BTL | 10379 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALANI HAWAI SH 4/6/12Z CN | 09621 | 1
ALANI COFF CAR 12/12Z BTL | 11081 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALANI JCY PEAC 4/6/12Z CN | 10499 | 1
ALANI COFF MAP 12/12Z BTL | 10380 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALANI MIMOSA 24/12Z CN | 09586 | 1
ALANI [NAME] BTL | 10381
ALANI COFF VAN 12/12Z BTL | 10382 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-09-11 00:00:00 | 297459 | ALANI CHRY SLU 24/12Z CN | 09583 | 14
ALANI COSMC ST 2/12/12Z CN | 09616 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALANI JCY PEAC 24/12Z CN | 10501 | 6
ALANI COSMC ST 24/12Z CN | 09854 |  |  |  |  |  |  |  |  |  |  | 4
ALANI COSMC ST 4/6/12Z CN | 09618 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-10 00:00:00 | 297483 | ALANI BLU SLSH 24/12Z CN | 09581 | 2
ALANI DREAM FL 24/12Z CN | 09762 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  | ALANI BREEZBRY 24/12Z CN | 09582 | 2
ALANI PRO CHOC 12/12Z BTL | 10844 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALANI BREEZBRY 4/6/12Z CN | 09620 | 2
ALANI PRO FRTY 12/12Z BTL | 10845 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALANI CHRY SLU 24/12Z CN | 09583 | 10
ALANI PRO MUNC 12/12Z BTL | 10846 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALANI COSMC ST 24/12Z CN | 09854 | 4
ALANI PRO COOK 12/12Z BTL | 10843
ALANI PRO STRW 12/12Z BTL | 10832
ALANI PRO VANI 12/12Z BTL | 10847
ALANI FRUIT BL 2/12/12Z CN | 09763
ALANI HAWAI SH 2/12/12Z CN | 10324
ALANI HAWAI SH 24/12Z CN | 09855
ALANI HAWAI SH 4/6/12Z CN | 09621
ALANI JCY PEAC 2/12/12Z CN | 10500
ALANI JCY PEAC 24/12Z CN | 10501 |  |  |  |  |  |  |  |  |  |  | 4
ALANI JCY PEAC 4/6/12Z CN | 10499
ALANI KIMADE 24/12Z CN | 11003 | 5077
ALANI KIMADE 4/6/12Z CN | 11005
ALANI KIWI GUA 24/12Z CN | 10813
ALANI KIWI GUA 4/6/12Z CN | 10812
ALANI MIMOSA 24/12Z CN | 09586
ALANI ROCKET P 24/12Z CN | 10113
ALANI ROCKET P 4/6/12Z CN | 10325
ALANI SELTZ BE 2/12/12Z CN | 09885
ALANI SELTZ VA 2/12/12Z CN | 09884
ALANI STIL WTR 12/1000ML BTL | 09589
ALANI STIL WTR 12/700ML | 09590
ALANI TROPSICL 24/12Z CN | 09587
ALANI WALMART 2/12/12Z CN | 10307
ALANI WITCH 12/12Z CN | 10309
ALANI WITCH 2/12/12Z CN | 10368
ALANI WITCH 24/12Z CN | 10367
ALANI WITCH 4/6/12Z CN | 10366 |  |  |  |  |  |  |  |  |  |  | 4
ALANI WTRML WA 2/12/12Z CN | 10327
ALANI WTRML WA 24/12Z CN | 09588 |  |  |  |  |  |  |  |  |  |  | 4
ALANI WTRML WA 4/6/12Z CN | 10328
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
ALANI ARCT WHT 24/12Z CN | 09580
ALANI BERRYPOP 24/12Z CN | 10000
ALANI BERRYPOP 4/6/12Z CN | 10522
ALANI BLU SLSH 2/12/12Z CN | 10303
ALANI BLU SLSH 24/12Z CN | 09581
ALANI BLU SLSH 4/6/12Z CN | 09664
ALANI BREEZBRY 2/12/12Z CN | 09615
ALANI BREEZBRY 24/12Z CN | 09582
ALANI BREEZBRY 4/6/12Z CN | 09620
ALANI CHRY SLU 2/12/12Z CN | 09617
ALANI CHRY SLU 24/12Z CN | 09583
ALANI CHRY SLU 4/6/12Z CN | 09619
ALANI COFF CAP 12/12Z BTL | 10379
ALANI COFF CAR 12/12Z BTL | 11081
ALANI COFF MAP 12/12Z BTL | 10380
ALANI [NAME] BTL | 10381
ALANI COFF VAN 12/12Z BTL | 10382
ALANI COSMC ST 2/12/12Z CN | 09616
ALANI COSMC ST 24/12Z CN | 09854
ALANI COSMC ST 4/6/12Z CN | 09618
ALANI DREAM FL 24/12Z CN | 09762
ALANI PRO CHOC 12/12Z BTL | 10844
ALANI PRO FRTY 12/12Z BTL | 10845
ALANI PRO MUNC 12/12Z BTL | 10846
ALANI PRO COOK 12/12Z BTL | 10843
ALANI PRO STRW 12/12Z BTL | 10832
ALANI PRO VANI 12/12Z BTL | 10847
ALANI FRUIT BL 2/12/12Z CN | 09763
ALANI HAWAI SH 2/12/12Z CN | 10324
ALANI HAWAI SH 24/12Z CN | 09855
ALANI HAWAI SH 4/6/12Z CN | 09621
ALANI JCY PEAC 2/12/12Z CN | 10500
ALANI JCY PEAC 24/12Z CN | 10501
ALANI JCY PEAC 4/6/12Z CN | 10499
ALANI KIMADE 24/12Z CN | 11003
ALANI KIMADE 4/6/12Z CN | 11005
ALANI KIWI GUA 24/12Z CN | 10813
ALANI KIWI GUA 4/6/12Z CN | 10812
ALANI MIMOSA 24/12Z CN | 09586
ALANI ROCKET P 24/12Z CN | 10113
ALANI ROCKET P 4/6/12Z CN | 10325
ALANI SELTZ BE 2/12/12Z CN | 09885
ALANI SELTZ VA 2/12/12Z CN | 09884
ALANI STIL WTR 12/1000ML BTL | 09589
ALANI STIL WTR 12/700ML | 09590
ALANI TROPSICL 24/12Z CN | 09587
ALANI WALMART 2/12/12Z CN | 10307
ALANI WITCH 12/12Z CN | 10309
ALANI WITCH 2/12/12Z CN | 10368
ALANI WITCH 24/12Z CN | 10367
ALANI WITCH 4/6/12Z CN | 10366
ALANI WTRML WA 2/12/12Z CN | 10327
ALANI WTRML WA 24/12Z CN | 09588
ALANI WTRML WA 4/6/12Z CN | 10328