REQ: I need help working out this function.

Giganews Newsgroups
Subject: REQ: I need help working out this function.
Posted by:  Matthew Webb (matthew.we…@net1.demon.co.uk)
Date: Sun, 26 Oct 2003

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

Replies