You are a military training analyst in charge of initial training for the XXX career field and must decide how to best train the new recruits to satisfy the requirements for skilled recruits. There are six different courses (A, B, C, D, E, F) used for training in the XXX career field and four different sequences of courses that can be taken to achieve the required skill level. These sequences are A-E, B, C-F, and A-D-F. The table below provides information on the six courses.

There are 100 recruits available for training and a demand for 100 skilled recruits. Assume all recruits pass each course and that you are trying to put students in classes in order to minimize the total cost of training. Assume non-integer solutions are acceptable. Further, assume each course will be held.
a.Draw a network flow diagram describing the problem.
b.Formulate the associated network flow linear program.
c.Implement a spreadsheet model and use Risk Solver Platform (RSP) to obtain a solution to the problem. Use your model to answer 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?
Next, assume that not all students pass each course. In fact only 90% of the students pass courses A, E, and F and only 95% of the students pass courses B, C, and D. Each course is considered independent. The requirement for 100 skilled recruits remains. Your job is now to determine the number of recruits to place into the training program to obtain the 100 trained recruits while continuing to minimize the total cost of training.
d.Re-draw the network flow diagram describing the problem to accommodate the above changes.
e.Formulate the associated generalized network flow linear program.
f. Implement a spreadsheet model of this changed model and use Risk Solver Platform (RSP) to obtain a solution to the expanded problem. How many recruits are needed and what is the change in total training cost?

Question

You are a military training analyst in charge of initial training for the XXX career field and must decide how to best train the new recruits to satisfy the requirements for skilled recruits. There are six different courses (A, B, C, D, E, F) used for training in the XXX career field and four different sequences of courses that can be taken to achieve the required skill level. These sequences are A-E, B, C-F, and A-D-F. The table below provides information on the six courses.
  
There are 100 recruits available for training and a demand for 100 skilled recruits. Assume all recruits pass each course and that you are trying to put students in classes in order to minimize the total cost of training. Assume non-integer solutions are acceptable. Further, assume each course will be held. 
a.Draw a network flow diagram describing the problem.
b.Formulate the associated network flow linear program.
c.Implement a spreadsheet model and use Risk Solver Platform (RSP) to obtain a solution to the problem. Use your model to answer 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?
Next, assume that not all students pass each course. In fact only 90% of the students pass courses A, E, and F and only 95% of the students pass courses B, C, and D. Each course is considered independent. The requirement for 100 skilled recruits remains. Your job is now to determine the number of recruits to place into the training program to obtain the 100 trained recruits while continuing to minimize the total cost of training.
d.Re-draw the network flow diagram describing the problem to accommodate the above changes.
e.Formulate the associated generalized network flow linear program.
f. Implement a spreadsheet model of this changed model and use Risk Solver Platform (RSP) to obtain a solution to the expanded problem. How many recruits are needed and what is the change in total training cost?

Quizplus · Accepted Answer

The Answer of 
You are a military training analyst in charge of initial training for the XXX career field and must decide how to best train the new recruits to satisfy the requirements for skilled recruits. There are six different courses (A, B, C, D, E, F) used for training in the XXX career field and four different sequences of courses that can be taken to achieve the required skill level. These sequences are A-E, B, C-F, and A-D-F. The table below provides information on the six courses.
  
There are 100 recruits available for training and a demand for 100 skilled recruits. Assume all recruits pass each course and that you are trying to put students in classes in order to minimize the total cost of training. Assume non-integer solutions are acceptable. Further, assume each course will be held. 
a.Draw a network flow diagram describing the problem.
b.Formulate the associated network flow linear program.
c.Implement a spreadsheet model and use Risk Solver Platform (RSP) to obtain a solution to the problem. Use your model to answer 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?
Next, assume that not all students pass each course. In fact only 90% of the students pass courses A, E, and F and only 95% of the students pass courses B, C, and D. Each course is considered independent. The requirement for 100 skilled recruits remains. Your job is now to determine the number of recruits to place into the training program to obtain the 100 trained recruits while continuing to minimize the total cost of training.
d.Re-draw the network flow diagram describing the problem to accommodate the above changes.
e.Formulate the associated generalized network flow linear program.
f. Implement a spreadsheet model of this changed model and use Risk Solver Platform (RSP) to obtain a solution to the expanded problem. How many recruits are needed and what is the change in total training cost?

You Are a Military Training Analyst in Charge of Initial