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

  • Thread starter count and sum function
  • Start date
C

count and sum function

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!
 
B

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top