How do I calculate a weeks supply of inventory on hand in excel?

[Guest]

I am a distribution analyst for a cat food company. I need to know how to
calculate the weeks of inventory I have on hand based on projected weekly
forecasts. For example, if I have 45 units on hand and a respective forecast
of 10 units per weeks, then I have a total of 4.5 weeks inventory
respectively. Needless to say this example is primative and my calculations
will not be as cut and dry, nor do I have to time to manually make the
calculation every day. So, I need to develop a formula that allows me to
count the number of cells in a certain range that when added respectively
will equal the value of a certain cell. Please help!

 

[BenjieLop]

From your description, I can conclude that the "45 units on hand" is the
sum of entries made in, say, a certain column. If this is the case then,
let us assume that the column range is A2:A100.

In another cell, let's say, is entered the weekly forecast. Let's
assume that for this example, the weekly forecast is in cell B2.

Your weeks inventory is then : =sum(A2:A100)/B2

Hope this concept will help you.

I am a distribution analyst for a cat food company. I need to know how
to
calculate the weeks of inventory I have on hand based on projected
weekly
forecasts. For example, if I have 45 units on hand and a respective
forecast
of 10 units per weeks, then I have a total of 4.5 weeks inventory
respectively. Needless to say this example is primative and my
calculations
will not be as cut and dry, nor do I have to time to manually make the
calculation every day. So, I need to develop a formula that allows me
to
count the number of cells in a certain range that when added
respectively
will equal the value of a certain cell. Please help!