how do I forecast a 15% increase over 7 months?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Do you mean to say have estimates of transactions, YTD sales days, and
monthly sales days already projected for the next 7 months? If so, and
if you're assuming those numbers are static, then yes, you should be
able to similarly project staffcount by figuring out the year-end
number and working backward.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modeling sales rep ramp 1
Using macro to set chart title with a variable month 2
Excel Getting an annualized figure based on YTD in Excel 1
Automatically rotate Months and Data 3
How do I add together only cells formatted in the same colour? 4
Forecasting with formulas HELP 1
Recalculating Monthly Production Forecasts 14
Forecasting Data Increases 1

Back
Top