JLewis wrote:
I have a spreadsheet with current inventory on hand and the sales for each
month from the last year. I want to figure how many months our inventory on
hand will last based on the last years sales. For instance, WidgetA has 100
on hand and Mar, Apr, May, Jun & Jul sales were 5,10,15,40,60, respectively.
I know that we have 4.5 months supply, but I have to manually figure this
calculation. I have more than 400 items. This takes a long time to figure, is
there any way to automate the figuring of the months supply?
Look at this:
http://tinyurl.com/bndrvj
If you are having trouble making it work, put your worksheet on
www.savefile.com
and I will see if I can help.