I have a sheet with sales, stock and wks cover by 2 wks forward average
sales(asuming I don't get any more stock).

N.B. figures are actual and estimated.


Date Sales Stock wks cover
(K) (K)
wk1 200 800 3.5
wk2 220 750 2.9
wk3 240 720 2.4
wk4 280 760 2.2
wk5 310 790 2.1
wk6 390 840 2.5
wk7 350 890 2.9
wk8 320 940 -
wk9 300 900 -

What I need is to take away my sales estimates from my actual current
stock cover to give a better figure because I have big sales peeks.

Is this possible? Thanks

--
Matt