Forecasting Student Training Activity

This formula will help you determine how many students you can train at a given site while maintaining a healthy level of instructor activity. Training more students than shown by the formula is certainly possible with a committed Instructor core, however be aware of the potential risk of trying to maintain that student/instructor ratio long term.

To alter the formula, simply change the number in the "Default" cell.

If you choose to alter the formulas it is suggested that you start with small changes (I.e. .25 or .5)

Formula Defaults:

Average of Students per Course:

Average Number of Instructor Assignments Per Year:

Initial Default settings: Students per Course - 10.4 Assignments per Year - 7

Using the formula

A) Enter the site name (1st Column)

B) Enter the maximum number of students the range will allow (2nd Column)

C) Enter the number of instructors for the local area (3rd Column)

Maximum Numbers Possible

Site

Max Students on Range

Current Number of Instructors

Instructor Assignments

Seats to Offer

Range Groups to Schedule

Expected Number of Students Trained