In the sales and inventory projection sheet below, I'm trying to avoid manual entry and ideally only have to adjust the input of column D.
Column L would monitor the inventory in column H, and look ahead 5 weeks (as this is how long an order takes to arrive). When the inventory 5 weeks ahead...