Need a little help: I have projected sales by item listed in 52 columns for the 52 weeks of the year. I also have a total available Finished Goods inventory column along with a column of Finished Goods on order and the date these Finished Goods will be coming in to our facility for each item. How can I create a formula that will sum the projected sales of each item starting with the current business week that I am in and then add each subsequent projected sales week and at the same time subtracting the inventory available against those summed projected sales to show me what month I may or may not run out before the next order of Finished Goods inventory comes into our facility. It would seem I need to create a formula that sums the sales and at the same time reduce the inventory by that summation in addtion to looking at the due dates of the Finished Goods coming in to our facility to see exactly when I will run out. This seems rather complicated. Any ideas would be greatly appreciated.

Regards

Gene