| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do I forecast a 15% increase over 7 months?
Excel 2003
I have a YTD actual productivity number and need to forecast what the productivity would need to be over each of the next 7 months to achieve a 15% full year increase. The result would need to include the Headcount reduction/increase for each month. Productivity = (transaction/headcount)*(YTD Sales Days/monthly Sales Days) I have each month's transactions, YTD Sales days and montly Sales Days. Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Graph Help- 12 month graph, but only want months that have passed | Charts and Charting in Excel | |||
| Calculate number of months between 2 dates | New Users to Excel | |||
| How do i change 15 months to read 1 year and 3 months? | Excel Discussion (Misc queries) | |||
| How do I calculate total of months that have passed? | Excel Discussion (Misc queries) | |||
| Best way to forecast individual sales territories? | Excel Discussion (Misc queries) | |||
Threaded Mode
