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>
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Watch MrExcel Video

Forum statistics

Threads
1,123,057
Messages
5,599,545
Members
414,316
Latest member
ExcelLee

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