View Full Version : Solved: Sales forecast
mariusc
01-25-2011, 11:57 PM
Hello,
I have the excel attached.
How can I estimate the forecast for the followings 5 years considering the info that I have already ?
Bob Phillips
01-26-2011, 01:04 AM
Surely, with only one year of data it is not possible to forecast. Is the trend up or down? With just one number there is no trend.
mariusc
01-26-2011, 01:06 AM
Hi James,
Trend is up
Bob Phillips
01-26-2011, 01:10 AM
But by how much? 5% per month, variable? Again, no information to use as a forecast.
mariusc
01-26-2011, 01:19 AM
2 %
Bob Phillips
01-26-2011, 01:59 AM
So just enter
=INT(B2*(1+2%))
in C2, and copy down and across
mariusc
01-26-2011, 02:16 AM
Thank you, James.
I didn`t knew about this posibility.
Bob Phillips
01-26-2011, 02:36 AM
It would be better to put the 2% in a cell and reference that cell. easier to change then.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.