G
Guest
I need to calculate the days coverage i have for my inventory. I start with
90660 units on 2-23 and then subtract my sales from my inventory. How many
days do i have before my inventory will go negative. I need to calulate this
daily over a period of time. Is there a formula i can use?
Date Days Cov Sales Iventory
FRI 02/23/07 90660
SAT 02/24/07 5D 10044 80616
SUN 02/25/07 4D 6696 73920
MON 02/26/07 3D 14580 59340
TUE 02/27/07 2D 18624 40716
WED 02/28/07 1D 18624 22092
THU 03/01/07 22656 -564
90660 units on 2-23 and then subtract my sales from my inventory. How many
days do i have before my inventory will go negative. I need to calulate this
daily over a period of time. Is there a formula i can use?
Date Days Cov Sales Iventory
FRI 02/23/07 90660
SAT 02/24/07 5D 10044 80616
SUN 02/25/07 4D 6696 73920
MON 02/26/07 3D 14580 59340
TUE 02/27/07 2D 18624 40716
WED 02/28/07 1D 18624 22092
THU 03/01/07 22656 -564