Spreadsheet: 764352d1642693785-days-on-hand-formula-shifting-results-days-on-hand-formula_solution
Sheet: Sheet1

 | [NAME] | 2022|01 | 2022|02 | 2022|03 | 2022|04 | 2022|05 | 2022|06 | 2022|07 | 2022|08 | 2022|09 | 2022|10 | 2022|11 | 2022|12 | 2023|01 | 2023|02 | 2023|03 | 2023|04 | 2023|05 | 2023|06 | 2023|07 | 2023|08 | 2023|09 | 2023|10 | 2023|11 | 2023|12 | 2024|01 | 2024|02
 | PLY M8 RUBIR C-C RC 60 60 VC MRCARB2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26
 | 6028 | 2022-01-02 00:00:00 | 2022-01-09 00:00:00 | 2022-01-16 00:00:00 | 2022-01-23 00:00:00 | 2022-01-30 00:00:00 | 2022-02-06 00:00:00 | 2022-02-13 00:00:00 | 2022-02-20 00:00:00 | 2022-02-27 00:00:00 | 2022-03-06 00:00:00 | 2022-03-13 00:00:00 | 2022-03-20 00:00:00 | 2022-03-27 00:00:00 | 2022-04-03 00:00:00 | 2022-04-10 00:00:00 | 2022-04-17 00:00:00 | 2022-04-24 00:00:00 | 2022-05-01 00:00:00 | 2022-05-08 00:00:00 | 2022-05-15 00:00:00 | 2022-05-22 00:00:00 | 2022-05-29 00:00:00 | 2022-06-05 00:00:00 | 2022-06-12 00:00:00 | 2022-06-19 00:00:00 | 2022-06-26 00:00:00
 | [NAME] | 191.25 | 345 | 270 | 82.5 | 95.75 | 109 | 160.25 | 122.25 | 135.5 | 148.75 | 162 | 226.5 | 291 | 208.5 | 177.25 | 94.75 | 104.2 | 216.15 | 216.15 | 174.35 | 132.55 | 90.74999999999994 | 48.94999999999994 | 7.149999999999935 | -34.65000000000007 | -34.65000000000007
 | Fcst |  | 75 | 75 | 38 | 38 | 0 | 38 | 38 | 38 | 38 | 38 | 38 | 82.5 | 82.5 | 82.5 | 41.8 | 41.8 | 0 | 41.8 | 41.8 | 41.8 | 41.8 | 41.8 | 41.8 | 0 | 0
 | [NAME] | 0 | 0 | 187.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Demand | 0 | 75 | 187.5 | 38 | 38 | 0 | 38 | 38 | 38 | 38 | 38 | 38 | 82.5 | 82.5 | 82.5 | 41.8 | 41.8 | 0 | 41.8 | 41.8 | 41.8 | 41.8 | 41.8 | 41.8 | 0 | 0
 | PO Placed | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | New PO | 153.75 | 0 | 0 | 51.25 | 51.25 | 51.25 | 0 | 51.25 | 51.25 | 51.25 | 102.5 | 102.5 | 0 | 51.25 | 0 | 51.25 | 153.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Batches | 3 |  |  | 1 | 1 | 1 |  | 1 | 1 | 1 | 2 | 2 |  | 1 |  | 1 | 3
 | End Inv | 345 | 270 | 82.5 | 95.75 | 109 | 160.25 | 122.25 | 135.5 | 148.75 | 162 | 226.5 | 291 | 208.5 | 177.25 | 94.75 | 104.2 | 216.15 | 216.15 | 174.35 | 132.55 | 90.74999999999994 | 48.94999999999994 | 7.149999999999935 | -34.65000000000007 | -34.65000000000007 | -34.65000000000007
 | Target | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 0 | 0
 | Days On Hand
 | [NAME] | 2022|01 | 2022|02 | 2022|03 | 2022|04 | 2022|05 | 2022|06 | 2022|07 | 2022|08 | 2022|09 | 2022|10 | 2022|11 | 2022|12 | 2023|01 | 2023|02 | 2023|03 | 2023|04 | 2023|05 | 2023|06 | 2023|07 | 2023|08 | 2023|09 | 2023|10 | 2023|11 | 2023|12 | 2024|01 | 2024|02
 | PLY M8 RUBIR C-C RC 60 60 VC MRCARB2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26
 | 6028 | 2022-01-02 00:00:00 | 2022-01-09 00:00:00 | 2022-01-16 00:00:00 | 2022-01-23 00:00:00 | 2022-01-30 00:00:00 | 2022-02-06 00:00:00 | 2022-02-13 00:00:00 | 2022-02-20 00:00:00 | 2022-02-27 00:00:00 | 2022-03-06 00:00:00 | 2022-03-13 00:00:00 | 2022-03-20 00:00:00 | 2022-03-27 00:00:00 | 2022-04-03 00:00:00 | 2022-04-10 00:00:00 | 2022-04-17 00:00:00 | 2022-04-24 00:00:00 | 2022-05-01 00:00:00 | 2022-05-08 00:00:00 | 2022-05-15 00:00:00 | 2022-05-22 00:00:00 | 2022-05-29 00:00:00 | 2022-06-05 00:00:00 | 2022-06-12 00:00:00 | 2022-06-19 00:00:00 | 2022-06-26 00:00:00
 | [NAME] | 191.25 | 345 | 270 | 82.5 | 95.75 | 109 | 160.25 | 122.25 | 135.5 | 148.75 | 162 | 226.5 | 291 | 208.5 | 177.25 | 94.75 | 104.2 | 267.4 | 267.4 | 225.6 | 183.8 | 141.9999999999999 | 100.1999999999999 | 58.39999999999993 | 16.59999999999992 | 16.59999999999992
 | Fcst |  | 75 | 75 | 38 | 38 | 0 | 38 | 38 | 38 | 38 | 38 | 38 | 82.5 | 82.5 | 82.5 | 41.8 | 41.8 | 0 | 41.8 | 41.8 | 41.8 | 41.8 | 41.8 | 41.8 | 0 | 0
 | [NAME] | 0 | 0 | 187.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Demand | 0 | 75 | 187.5 | 38 | 38 | 0 | 38 | 38 | 38 | 38 | 38 | 38 | 82.5 | 82.5 | 82.5 | 41.8 | 41.8 | 0 | 41.8 | 41.8 | 41.8 | 41.8 | 41.8 | 41.8 | 0 | 0
 | PO Placed | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | New PO | 153.75 | 0 | 0 | 51.25 | 51.25 | 51.25 | 0 | 51.25 | 51.25 | 51.25 | 102.5 | 102.5 | 0 | 51.25 | 0 | 51.25 | 205 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Batches | 3 |  |  | 1 | 1 | 1 |  | 1 | 1 | 1 | 2 | 2 |  | 1 |  | 1 | 4
 | End Inv | 345 | 270 | 82.5 | 95.75 | 109 | 160.25 | 122.25 | 135.5 | 148.75 | 162 | 226.5 | 291 | 208.5 | 177.25 | 94.75 | 104.2 | 267.4 | 267.4 | 225.6 | 183.8 | 141.9999999999999 | 100.1999999999999 | 58.39999999999993 | 16.59999999999992 | 16.59999999999992 | 16.59999999999992
 | Target | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 0 | 0
 | Days On Hand
 | Example after Solution | [NAME] | 2022|01 | 2022|02 | 2022|03 | 2022|04 | 2022|05 | 2022|06 | 2022|07 | 2022|08 | 2022|09 | 2022|10 | 2022|11 | 2022|12 | 2023|01 | 2023|02 | 2023|03 | 2023|04 | 2023|05 | 2023|06 | 2023|07 | 2023|08 | 2023|09 | 2023|10 | 2023|11 | 2023|12 | 2024|01 | 2024|02
 |  | PLY M12 RUBIR BB-BB RC 48 96 VC WBPCARB2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26
 |  | 5846 | 2022-01-02 00:00:00 | 2022-01-09 00:00:00 | 2022-01-16 00:00:00 | 2022-01-23 00:00:00 | 2022-01-30 00:00:00 | 2022-02-06 00:00:00 | 2022-02-13 00:00:00 | 2022-02-20 00:00:00 | 2022-02-27 00:00:00 | 2022-03-06 00:00:00 | 2022-03-13 00:00:00 | 2022-03-20 00:00:00 | 2022-03-27 00:00:00 | 2022-04-03 00:00:00 | 2022-04-10 00:00:00 | 2022-04-17 00:00:00 | 2022-04-24 00:00:00 | 2022-05-01 00:00:00 | 2022-05-08 00:00:00 | 2022-05-15 00:00:00 | 2022-05-22 00:00:00 | 2022-05-29 00:00:00 | 2022-06-05 00:00:00 | 2022-06-12 00:00:00 | 2022-06-19 00:00:00 | 2022-06-26 00:00:00
 |  | [NAME] | 1841.92 | 1804.848 | 1788.848 | 1721.848 | 1668.098 | 1628.098 | 1552.098 | 1511.098 | 1448.098 | 1355.098 | 1309.098 | 1269.098 | 1257.098 | 1213.098 | 1167.998 | 1094.298 | 1035.173 | 991.173 | 907.573 | 862.473 | 793.173 | 690.873 | 640.273 | 596.273 | 583.073 | 583.073
 |  | Fcst |  | 41 | 67 | 53.75 | 40 | 76 | 41 | 63 | 93 | 46 | 40 | 12 | 44 | 45.1 | 73.7 | 59.12500000000001 | 44 | 83.60000000000001 | 45.1 | 69.30000000000001 | 102.3 | 50.6 | 44 | 13.2 | 0 | 0
 |  | [NAME] | 39.072 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Demand | 39.072 | 41 | 67 | 53.75 | 40 | 76 | 41 | 63 | 93 | 46 | 40 | 12 | 44 | 45.1 | 73.7 | 59.12500000000001 | 44 | 83.60000000000001 | 45.1 | 69.30000000000001 | 102.3 | 50.6 | 44 | 13.2 | 0 | 0
 |  | PO Placed | 2 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | New PO | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Batches
 |  | End Inv | 1804.848 | 1788.848 | 1721.848 | 1668.098 | 1628.098 | 1552.098 | 1511.098 | 1448.098 | 1355.098 | 1309.098 | 1269.098 | 1257.098 | 1213.098 | 1167.998 | 1094.298 | 1035.173 | 991.173 | 907.573 | 862.473 | 793.173 | 690.873 | 640.273 | 596.273 | 583.073 | 583.073 | 583.073
 |  | Target | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 0 | 0
 |  | Days On Hand