Quick question. We just started a new automotive business so i have no past data. I was wondering how i can make a forecast for new vehicle sales. Im forcasting for month 85 new vehicles. How can i make a formula to see if we are on track for the month of october? Thanks.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
A crystal ball would seem to be valuable
Seriously though, without past data what other data can you fall back on?
Are you a new vehicle dealership? (85 new vehicles, yes probably). Your manufacturer should be able to provide an insight into trends of that/those brands.
If this is a secondhand dealership have you some concept of local turnovers?
Then too, what is the economic climate in your location? Or for that matter the socioeconomic environment of your area, might that be relevant?
At this point you are about 1/3 of the way across the month. Are there any features which can provide a guide?
Ideally in a mathematical world one might expect 85 vehicles to sell over 31 days, ie 2.74 per day.
Dismissing those pressures above, which we probably can't compute, consider:
Format Column B as Number with 0 decimal places.
A1 holds 1/10/2017, A2 holds 1/10/2017, ... drag those dates down the column.
In B1 enter =85/31.
In B2 enter =B1+B$1 and drag that down the column.
In C1 enter =D1
In C2 enter =IF(D2=0,"",C1+D2) and then drag that down the column.
In Column D enter the actual number of vehicles sold for the day.
Now in Column B you have a theoretical projected accumulation of 2.7 vehicles per day. Column C shows the total sold to the date of the last sale.
Does that help?
Upvote
0
Similar threads
- Question
