Hello,
I am wondering if it is possible to write a formula in excel (without VBA) 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
The formula needs to work no matter how many months of coverage there are and be the same formula in every cell.
Here is an example of how my spreadsheet is laid out
January February March April May June
Beginning Inventory 1000 700 500 200 600 600
Forecast 500 200 500 600 200 200
Receipts 200 0 200 1000 200 100
Month's of Coverage ? ? ? ? ? ?
Any ideas on how this would work?
I am wondering if it is possible to write a formula in excel (without VBA) 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
The formula needs to work no matter how many months of coverage there are and be the same formula in every cell.
Here is an example of how my spreadsheet is laid out
January February March April May June
Beginning Inventory 1000 700 500 200 600 600
Forecast 500 200 500 600 200 200
Receipts 200 0 200 1000 200 100
Month's of Coverage ? ? ? ? ? ?
Any ideas on how this would work?