How do I estimate sales for a prospective year?

[baseballchick]

How do I estimate the Sales for a coming year? How do I calculate it.

 

[Jim Cone]

What are you selling?
--
Jim Cone
Portland, Oregon USA



"baseballchick"
<[email protected]>
wrote in message
How do I estimate the Sales for a coming year? How do I calculate it.

 

[baseballchick]

Its for a Project and its VASES, I just need to know what I press or do to
get the estimate for the next year. Can u help?

 

[JoeU2004]

Its for a Project and its VASES, I just need to know what I press or
do to get the estimate for the next year.

Oh, that makes all the difference in the world. I just trashed a very long
message about the dangers of over-simplifying such endeavors. But for
school, we do it all the time :-(.

You wrote previously:

How do I estimate the Sales for a coming year? How do I calculate it.

Most likely, you will use the FORECAST function.

Do you have historical data for a year or more? If so, first, you should
chart it to verify that it demonstrates a linear trend. Do you need help
with that?

Also, did the class project specifications hint at any other factors that
might affect the prediction of future sales? For example, is the sale of
vases seasonal? (Vases make great gifts around Easter and Christmas.)


----- original messages -----

 

[Jim Cone]

You might try getting some national/regional projections for
your particular type of vase from publications, manufacturers or
industry organizations and applying those projections against
your sales for last year.

If for some reason you must use Excel...
Then post last years monthly sales in 12 adjacent cells in a column.
Select the data and hover the cursor over the bottom right
corner of the selection. It will turn into cross.
Drag down and you will get monthly projections.
As an alternative, drag the cross down while pressing the right mouse button.

I wouldn't bet the farm or your reputation on the accuracy of the forecast.
--
Jim Cone
Portland, Oregon USA



"baseballchick"
<[email protected]>
wrote in message
Its for a Project and its VASES, I just need to know what I press or do to
get the estimate for the next year. Can u help?

 

[Gord Dibben]

Based on what criterion(a)?

You must have some type of background data in order to estimate future
sales.

Or the services of a very good clairvoyant.


Gord Dibben MS Excel MVP