Re: project - predicting inventory for six years

From: Tushar Mehta (tmUnderscore200310_at_tushar-mehta.SeeOhEm)
Date: 10/25/04 

Date: Mon, 25 Oct 2004 21:00:55 GMT

Before getting into how to do this in XL, how would you create a model
to address the issue? The professor must have taught you how to do
some kind of analysis. What was that? And, how would that apply to
this problem?

Also, before you go too far, do some cross-checking. If 6% of the
population of 13,500 shops in the store, how many people would that be?
Based on that, how many scanners per customer did you sell in 2003? Is
that realistic? 

-- 
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <OSCStudent.1ep9lh@excelforum-nospam.com>, 
OSCStudent.1ep9lh@excelforum-nospam.com says...
> 
> I am a college student and could really use some help on this project I
> have due soon. We are to predict how much stock our company needs based
> on some hard numbers we have. For example, we sold 2299 scanners in
> 2003. We also have the information that the towns population is 13,500
> and increases by 192 people each year. We also know that 6% of the
> population shops in the store each year. So for each item and that kind
> of information for each, we have to come up with the formuals to predict
> how much stock we will need. With that as an example, how would I come
> up with a formula? P.S- we can put in the population, increase each
> year, and the percentage of people that shop in the store each year
> somewhere on the spread*** so it will be easier for us to use them in
> the formulas, but nothing else can be hard coded.
> 
> 
>
Loading