How do I estimate sales for a prospective year?
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"
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?
"Jim Cone" wrote:
What are you selling?
--
Jim Cone
Portland, Oregon USA
"baseballchick"
wrote in message
How do I estimate the Sales for a coming year? How do I calculate it.
|