JC Marshal
New Member
- Joined
- Apr 17, 2013
- Messages
- 1
What is the best formula or best way to make an adjustable / variable monthly sales forecast that takes into account a time delay for training before sales are recognized?
I am building a Monthly Sales Forecast that is based on a variable number of new sales people being hired and a variable number of months for training to be completed prior to the first full month of sales.
Example: Training period = 2 months; New Hires per month = 2, Sales per fully trained sales agent = $1000
The table should be able to adjust sales amounts based on any adjustment to the training period. Also, is it possible to use a partial training period such as 2.5 months and have a half month of sales reported in the correct cell?
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD="align: center"]Month #
[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]# of New Sales People[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]10[/TD]
[/TR]
[TR]
[TD="align: center"]Total Estimated Sales[/TD]
[TD="align: center"]$0[/TD]
[TD="align: center"]$0[/TD]
[TD="align: center"]$2000[/TD]
[TD="align: center"]$4000[/TD]
[TD="align: center"]$6000[/TD]
[/TR]
</tbody>[/TABLE]
I am building a Monthly Sales Forecast that is based on a variable number of new sales people being hired and a variable number of months for training to be completed prior to the first full month of sales.
Example: Training period = 2 months; New Hires per month = 2, Sales per fully trained sales agent = $1000
The table should be able to adjust sales amounts based on any adjustment to the training period. Also, is it possible to use a partial training period such as 2.5 months and have a half month of sales reported in the correct cell?
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD="align: center"]Month #
[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]# of New Sales People[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]10[/TD]
[/TR]
[TR]
[TD="align: center"]Total Estimated Sales[/TD]
[TD="align: center"]$0[/TD]
[TD="align: center"]$0[/TD]
[TD="align: center"]$2000[/TD]
[TD="align: center"]$4000[/TD]
[TD="align: center"]$6000[/TD]
[/TR]
</tbody>[/TABLE]