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...