Spreadsheet: 709124d1608175541-adding-shipment-quantities-to-get-future-arrival-dates-inventory-status-example
Sheet: IncomingShipments

 | Model # | 12/9/2020 | 12/22/2020 | 12/29/2020 | 12/30/2020 | 1/6/2021 | 1/7/2021 | 1/12/2021 | 1/20/2021 | 2/20/2021 | 3/20/2021
 | P12-A-168 |  | 111 |  |  |  | 79 | 144 | 76 |  | 395
 | P12-A-168-RK |  | 100 |  |  |  | 140 | 100 |  |  | 300
 | P12-P12108 |  |  |  |  |  |  |  |  |  | 10
 | P12-P12108 |  |  |  |  |  |  | 5 |  | 2 | 4
 | P12-P12M-64 |  |  |  |  |  | 6 |  | 8 |  | 12
 | P12-VC11332 |  |  |  |  |  |  |  |  |  | 32
 | P12-VC11333 | 20 |  |  |  |  |  |  |  | 18 | 31
 | P12-VC11334 |  |  |  |  |  |  |  |  |  | 26
 | P12-VC9458 |  |  |  |  | 25 |  | 50 | 100 | 50 | 25
 | P12-PL2-241 |  | 101 | 84 |  | 44 | 111 | 15 | 53 |  | 250
 | P12-PL2-84-BLK |  | 17 | 23 |  |  | 40 |  | 32 |  | 46
 | P12-TIS |  | 40 |  |  |  |  | 37 | 43 |  | 62
 | P12-CTZ100 |  | 17 |  |  | 8 | 3
 | P12-BIKE-KKB32 |  | 3 |  |  |  | 4 |  | 1 |  | 15
 | P12-BIKE-KKB48 |  |  |  |  |  |  |  | 6 |  | 5
 | P12-BIKE-KKB64 |  | 5 |  |  |  | 4 |  |  |  | 3
 | P12-BIKE-DLC15 |  | 3 |  |  |  |  |  |  |  | 8
 | P12-BIKE-DLC25 |  |  |  |  |  |  |  | 2 |  | 5
 | P12-BIKE-DLC35 |  | 4 | 7 |  | 1 | 20 |  | 29 |  | 10
 | P12-BIKE-KB0 |  | 12 | 2 |  |  |  |  | 10 |  | 18
 | P12-BIKE-KB32 |  |  |  |  |  |  |  | 2 |  | 11
 | P12-BIKE-KB48 |  | 1 |  |  |  |  |  | 6 |  | 3
 | P12-BIKE-KB64 |  | 4 |  |  |  | 14 |  | 15 |  | 8
 | P12-BIKE-GPIO |  |  |  |  |  |  |  | 10
 | P12-LK2164-W |  |  |  |  |  | 6
 | P12-LK2168 |  | 71 | 13 | 76 | 25 |  |  | 54 |  | 45
 | P12-LK012 |  | 15 |  |  |  | 15 |  | 10 |  | 4
 | P12-LK012-RK |  |  |  |  |  |  |  |  |  | 5
 | P12-LK164-W |  |  |  |  |  | 7 |  | 13 |  | 25
 | P12-LK168 |  | 25 | 25 | 25 | 52 | 47 | 1 | 99 |  | 370
 | P12-LK32 |  |  |  |  |  | 6 | 2 | 12 |  | 3
 | P12-M-R24-AN |  |  |  |  |  |  | 1
 | P12-M-MADI2-A |  |  |  |  |  |  |  |  | 4 | 2
 | P12-MDS-16 |  |  |  |  |  | 20 |  | 4 |  | 15
 | P12-M-S4-A |  | 8 |  |  | 133 | 139 | 48 |  |  | 160
 | P12-ADI-A |  |  |  |  |  |  |  | 3 | 5 | 5
 | P12-M-S-A |  |  |  |  |  |  | 6 | 90 | 12
 | P12-M--A |  | 10 |  |  |  | 12 | 18 |  |  | 8
 | P12-SQ-5-RK19 |  | 30 | 50 |  |  |  |  |  |  | 46
 | P12-SQ-61 |  | 106 | 113 |  |  |  |  | 75 |  | 145
 | P12-SQ-55 |  | 78 |  |  | 66 | 72 |  | 96 |  | 135
 | P12-XTG10 |  | 122 | 47 |  |  |  |  |  |  | 24
 | P12-XTG10LY |  | 180 | 120 |  | 30 | 70 |  | 25 |  | 300
 | P12-XTG12LY |  |  |  |  |  |  |  | 200 |  | 6
 | P12-XTG14 |  | 20 |  |  |  | 20 |  | 63 |  | 32
 | P12-XTG14-RK19 |  |  | 21 |  |  |  | 12 |  |  | 24
 | P12-XTG16LY |  |  |  |  |  | 100 |  |  |  | 24
 | P12-XTG18 |  |  |  |  |  | 10 |  | 17 |  | 5
 | P12-XTG18-RK19 |  |  |  |  |  |  |  | 5 |  | 13
 | P12-XTG22LY |  | 40 |  |  |  |  |  | 42 |  | 12
 | P12-XTG24 |  | 40 |  |  | 37 |  |  | 10 |  | 6
 | P12-XTG420 |  |  |  |  |  |  |  |  | 2
 | P12-XTG428 |  |  |  |  | 5 | 1
 | P12-XTG436 |  |  |  |  |  |  |  |  | 6
 | P12-XTG6 |  | 90 |  |  |  |  |  | 18 |  | 108
 | P12-XTG60-10LY |  |  | 60 |  |  | 57 |  | 18 |  | 18
 | P12-XTG60-14LY |  | 13 | 2 |  |  | 40 |  | 70 |  | 124
 | P12-XTG6LY |  |  |  |  |  | 60 |  | 96 |  | 108
 | P12-XTGI10 |  | 28 |  |  |  | 200 |  | 360 |  | 160
 | P12-XTGI10LY |  | 160 |  |  |  | 200 |  | 240 |  | 392
 | P12-XTGI8 |  |  |  |  | 108 |  |  | 228 |  | 288