Spreadsheet: 713611d1610823609-need-formula-to-match-each-weeks-target-to-forward-volumes-restarting-each-week-210117-lead-time-problem
Sheet: SKU PLANNER

 | Forecast @ | 0.1 | Wks 27-31 |  |  | Base7 | Split% | Buffers | Week | 20-28 | W/C | 2021-01-04 00:00:00 |  | Base % | 1.15 | Week |  | 20-29 | W/C | 2021-01-11 00:00:00 | Base % | 1.15 | Week |  | 20-30 | W/C | 2021-01-18 00:00:00 | Base % | 0.77 | Week | 20-31 | W/C | 2021-01-25 00:00:00 |  | Base % | 0.78 | Week |  | 20-32 | W/C | 2021-02-01 00:00:00 | Base % | 0.7 | Week | 20-33 | W/C | 2021-02-08 00:00:00 |  | Base % | 0.7 | Week | 20-34 | W/C | 2021-02-15 00:00:00 |  | Base % | 0.85 | Week | 20-35 | W/C | 2021-02-22 00:00:00 |  | Base % | 0.65
 | Range | Code |  |  |  | Qtys | % | Units | Starting Stock Pos | S/Ratio | Inbound | Sales | Forecast | Unfilled orders | L/Time | Opening Stock | S/Ratio | Inbound | Sales | Forecast | Unfilled orders | L/Time | Opening Stock | S/Ratio | Inbound | Sales | Forecast | Unfilled orders | L/Time | Opening Stock | S/Ratio | Inbound | Sales | Forecast | Unfilled orders | L/Time | Opening Stock | S/Ratio | Inbound | Sales | Forecast | Unfilled orders | L/Time | Opening Stock | S/Ratio | Inbound | Sales | Forecast | Unfilled orders | L/Time | Opening Stock | S/Ratio | Inbound | Sales | Forecast | Unfilled orders | L/Time | Opening Stock | S/Ratio | Inbound | Sales | Forecast | Unfilled orders | L/Time
 |  | Code 1 |  |  |  |  |  |  | 39 |  |  | 357 |  |  |  |  |  |  |  |  |  |  |  |  | 171 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 126 |  |  |  |  |  |  | 42 |  |  |  |  |  |  | 0
 |  | Code 2 |  |  |  |  |  |  | 16 |  |  | 259 |  |  |  |  |  |  |  | 1000 |  |  |  |  | 294 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 42 |  |  |  |  |  |  | 42 |  |  |  |  |  |  | 84
 |  | Code 3 |  |  |  |  |  |  | 21 |  |  | 147 |  |  |  |  |  |  |  |  |  |  |  |  | 140 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
 |  | Code 4 |  |  |  |  |  |  | 74 |  |  | 630 |  |  |  |  |  |  |  |  |  |  |  |  | 336 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 84 |  |  |  |  |  |  | 252
 |  | Code 5 |  |  |  |  |  |  | 48 |  |  | 383 |  |  |  |  |  |  |  |  |  |  |  |  | 168 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
 |  | Code 6 |  |  |  |  |  |  | 18 |  |  | 130 |  |  |  |  |  |  |  |  |  |  |  |  | 28 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
 |  | Code 7 |  |  |  |  |  |  | 13 |  |  | 142 |  |  |  |  |  |  |  |  |  |  |  |  | 53 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 37 |  |  |  |  |  |  | 74
 |  | Code 8 |  |  |  |  |  |  | 4 |  |  | 31 |  |  |  |  |  |  |  |  |  |  |  |  | 87 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
 |  | Code 9 |  |  |  |  |  |  | 4 |  |  | 21 |  |  |  |  |  |  |  |  |  |  |  |  | 102 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
 |  | Code 10 |  |  |  |  |  |  | 5 |  |  | 32 |  |  |  |  |  |  |  |  |  |  |  |  | 98 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 84
 |  | Code 11 |  |  |  |  |  |  | 9 |  |  | 28 |  |  |  |  |  |  |  |  |  |  |  |  | 56 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
 |  | Code 12 |  |  |  |  |  |  | 7 |  |  | 24 |  |  |  |  |  |  |  |  |  |  |  |  | 84 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
 |  | Code 13 |  |  |  |  |  |  | 3 |  |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
 |  | Code 14 |  |  |  |  |  |  | 3 |  |  | 21 |  |  |  |  |  |  |  |  |  |  |  |  | 37 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If value more than 50% of V + AB, generates [NAME] in Col AD, AY and BF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If Sales/Forecast vols are higher than will be available at any point, Lead Time shows as 1 week more than weeks left in Range (e.g. Lead Time in W5 is seven weeks, but there are only six weeks left in range).
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Need to adjust fomrula so [NAME] that cannot be met at any time show "PO" in the Unfilled Order cols.