Question

1) You are the scheduling coordinator for a small but growing airline. You must schedule exactly one flight out of Chicago to each of the following cities: Atlanta, Los Angeles, New York, and Peoria. The available departure slots are 8 a.m., 10 a.m., and 12 noon. Your airline has only two departure lounges so at most 2 flights can be scheduled per slot. Demand data suggests the following expected profit contribution per flight as a function of departure time:

Expected Profit Contribution in $1000s
	Time
Destination	8	10	12
Atlanta	10	9	8.5
Los Angeles	11	10.5	9.5
New York	17	16	15
Peoria	6.4	2.5	-1

Formulate a model to solve this problem in excel

Answer 1