You manage a group of 40 pilots. Based on experience and skill level, 10 of the 40 are “Class A” pilots, 22 of the 40 are “Class B” fliers, and the remaining 8 are “Class C” pilots. (Class A pilots have a quality of ‘10’, Class “B: a quality of ‘9’, and Class C pilots a quality of ‘8′)

Over the next 10 weeks, you must have each of them attend some military professional development program classes (referred to as MPD). During that time, they are not available to perform normal work duties. Thus, you have to manage their scheduled training time to make sure the number of pilots available to perform normal work does not fall below ‘minimum’ numbers. 40 pilots

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

You have 7 different MPD classes that span the next 10 weeks. Three week classes can have all three pilot classes enroll – two week classes can only accommodate Class “A” and Class “B” (this is shown in the table below). Each MPD has a “learning value” parameter (measuring the effectiveness of that specific MPD class) and a “cost” (in units per person attending).

The total cost of the staffing model must not exceed 675 units.

The table below provides all needed information.

Starting (per person) (per person) (per person)
MPD Week Length Class C Value Cost
K 1 3 Yes 27 15
L 3 3 Yes 25 15
M 4 2 No 26 18
N 5 2 No 34 25
O 6 3 Yes 20 10
P 8 3 Yes 22 10
Q 9 2 No 28 22
Week Min Pilots Week Min Pilots
1 30 6 26
2 29 7 24
3 28 8 22
4 25 9 25
5 26 10 27

There are two additional requirements related to the number of pilots that can be assigned to each MPD. No more than 8 total pilots (Class “A” plus Class “B” plus “Class C”) can be assigned to any one MPD. And, no more than 5 pilots from a specific pilot “Class” can be assigned to any one MPD.

Create a linear prescriptive analytic model that will determine how to maintain proper staffing levels for normal work in your squadron while scheduling all 40 of your pilots in MPD classes. Your objective should be to maximize the “value” of the scheduled pilots to classes (must be integers). A simple objective function.


"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"