Spreadsheet: 764195d1642630059-days-on-hand-formula-shifting-results-days-on-hand-formula
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