michael1980
New Member
Hi,
I’m currently in the process setting up a Stock/sales forecast with weeks stock cover. I currently calculate the weeks stock cover based on the current week sales. Current calculation is =balance/sales the following week.
Is there a better calculation taking into consideration the forward weeks as the sales volume is different be week?
Please see an example below.
Many thanks in advance.
I’m currently in the process setting up a Stock/sales forecast with weeks stock cover. I currently calculate the weeks stock cover based on the current week sales. Current calculation is =balance/sales the following week.
Is there a better calculation taking into consideration the forward weeks as the sales volume is different be week?
Please see an example below.
Many thanks in advance.