How can I incorporate a variable sales training period in a monthly sales forecast?

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?

Month #
12345
# of New Sales People246810
Total Estimated Sales$0$0$2000$4000$6000

<tbody>
</tbody>
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,008
Messages
5,834,866
Members
430,324
Latest member
bosphoruskid

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top