Weeks of Supply

  • Thread starter Thread starter Rory Hudson
  • Start date Start date
R

Rory Hudson

Hello out there,

I am trying to see if there is a function that will
calculate week's of supply. Has anybody come across
anything? Please let me know , any help is greatly
appreciated
 
You need to supply more info on what you want to do. There is no
WeeksSupply() function, although you could roll your own.
 
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.
 
Back
Top