Hi Rory!
More data required. There's all sorts of way the number of weeks
supply could be calculated.
For example you could used a fixed demand per week input and divide
that into the current supply. Or you could use a calculated moving
average demand per week. Or you might use figures based on this time
last year or this time last year adjusted by an inflator or deflator.
And then, what do you mean by weeks? Are you using all days or are you
using working days or are you using 6 days. Do you include public
holidays in your forward projection?
First you must define your objectives and goals and then the method
used and algorithms required will fall into place. In designing what
you should do, my first guide would be to look at how it is done at
present and then investigate whether, apart from being manual, it is
acceptable or whether it needs improvement.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Wednesday 23rd July: Armenia (Martyr's Day),
Egypt (Revolution Day), Equatorial Guinea (Bata's Fiesta), Fiji
(Constitution Day), Indonesia (National Children's Day), Oman
(National Day), Papua New Guinea (Remembrance Day), Syria (Egyptian
Revolution Day). Observances: Rastafarian (Birthday of Haile
Selassie), Neptunalia (Roman)
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.