Change the staffing equation to in the spreadsheet to: 4L + S. This is simply increasing the staff required for long haul flights by a factor of 2. Start with the following in the Solver template: Arrival constraint = 6 Maintenance constraint= 5 Staffing constraint = 9 Run cases by going to Data and then Solver and changing the numbers in the template to alter the constraints as you deem appropriate.

(1) What is the revenue for the case where the arrival, maintenance and staffing constraints are 6, 8 and 9, respectively?

(A) $700 (B) $1500 (C) $1000 (D) $900 (E) $200

(2) What is the value of increasing the maintenance constraint from 7 to 8 at a constant arrival constraint of 6 and staffing constraint of 9?

(A) $80 (B) $200 (C) $400 (D) -$200 (E) None of the above

(3) What is the value of increasing the staffing constraint from 9 to 10 when the maintenance constraint is 5 and the arrival constraint is 6?

(A) $0 (B) $100 (C) $200 (D) -$200 (E) -$100

(4) Holding the arrival constraint constant at 6 and the staffing constraint at 9, at what level of the maintenance constraint does the system constraint shift (Hint: start with a maintenance constraint of 5 and walk it up to 6, 7 etc. Your answer should be the last change before the revenue stops increasing)?

(A) 7 to 8 (B) 8 to 9 (C) 9 to 10 (D) 10 to 11

D13 fD11+E11 Revenue 1100 Arrival constraint 9 Maintenance constraint 5 Staffing constraint 17 27 D13 fD11+E11 Revenue 1100 Arrival constraint 9 Maintenance constraint 5 Staffing constraint 17 27