Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I'm looking for a sales forecast template.
I have limited data:
2006 annual sales by customer Dec. 2007 sales by customer sales margin by customer My boss would like a 5 year sales/future earnins forecast - I would really appreciate some direction, or template to work with! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I'm looking for a sales forecast template.
"EllenG" wrote in message
... I have limited data: 2006 annual sales by customer Dec. 2007 sales by customer sales margin by customer My boss would like a 5 year sales/future earnins forecast - I would really appreciate some direction, or template to work with! Easy. List all your customers in order with their sales data. then, you need to hold meetings with the Account Managers in order to get their estimates of sales per customer for the next five years. then HALVE it. (I speak from long experience, particularly if a great part of the salesman's remuneration is commission!!!). The margin is just Sales times your expected (or calculated) margin %age..... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sales Forecast | Excel Discussion (Misc queries) | |||
Sales Forecast Question - Need Help! | Excel Discussion (Misc queries) | |||
Forecasting Sales using the Forecast Function | Excel Worksheet Functions | |||
How do I set up a sales forecast to predict sales per hour, when . | Excel Discussion (Misc queries) | |||
Best way to forecast individual sales territories? | Excel Discussion (Misc queries) |