Need help : formula to calculate stock cover in months

[samike]

Forecast


Product qty on hand Stock cover (months) jan feb mar apr may jun jul aug sep oct nov dec
Spoons 600 ??? 30 20 60 80 70 120 200 210 90 80 10 2

[AliGW]

Welcome to the forum!

Please provide more information about what you are trying to do.

[samdora]

Hello,

I am wondering if it is possible to write a formula in excel to calculate forward coverage.

For example.


Beginning Inventory = 1000
Month 1 Forecast = 500
Month 2 Forecast = 200
Month 3 Forecast = 500

Coverage = 2.6 Months

I am looking for a formula I can apply to about 100 items in excel table

[samdora]

Book1 - ILLUSTRATION.xlsx

Please assist to present in excel table

[AliGW]

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

[samike]

Apologies i logged in using the wrong username. I am representing below my concerns in the attached file.
Book1 - ILLUSTRATION.xlsx

[AliGW]

Why do you have two accounts?

[samike]

Hi AliGW,

I tried opening from my phone . was not sure the first account was succesful. I later opened another one. You can delete " samdora" as i am okay with " samike"

Thanks

[JohnTopley]

Please Login or Register  to view this content.

=Stock_cover($C3,$F3:$P3)

[samike]

Hi John,

Thanks I am grateful . This was helpful....

Please advise me, i tried to edit stock on hand , this result is seen " #NAME? ...What do i do in this situation.


Regards,

[JohnTopley]

i tried to edit stock on hand

????

don't understand as "Stock on Hand" is just data which can be any numeric value.

The formula is in column D.