Course
|
Cost Per Trainee
|
Min. Num. of Trainees
|
Max. Num. of Trainees
|
A
|
25
|
15
|
40
|
B
|
55
|
10
|
50
|
C
|
30
|
15
|
50
|
D
|
10
|
15
|
50
|
E
|
20
|
10
|
50
|
F
|
15
|
10
|
50
|
There are 100 new trainees available for training and a demand for 100 skilled investment consultants. Assume all employees pass each course they are allocated to and that you are trying to assign employees to classes in order to minimize the total cost of training. Assume each course will be held.
In addition to the formulation, solution and Excel output you should provide the network flow diagram describing the problem and address the following questions:
What is the expected student load for each course?
Should any course be expanded?
Should any course or sequence be considered for elimination?