Rose Tree Regional Airline Assignment Problem
	Constants Section:
	Plane Data:
	Plane Type	Passenger Capacity	Cargo Capacity (ft3)	Operating Cost per Passenger- Mile	Operating Cost per Cargo- Mile	Available Fleet			Fill Legend
	Boeing 717	117	935	$0.110	$0.055	15				Changing Cells
	Bombardier CRJ700	78	150	$0.100	$0.050	18				Optimization Cell
	Embraer E170	70	156	$0.090	$0.045	12
	Airbus A220	133	838	$0.075	$0.035	5
	Fee Schedule:
	Destination	Average Ticket Price	Cargo Price/ft3
	Las Vegas	$213	$300.00
	Albuquerque	$263	$150.00
	Denver	$127	$200.00
	Cheyenne	$678	$200.00
	Boise	$133	$300.00
	Reno	$317	$125.00
	Phoenix	$274	$175.00
	Calculations and Results Section:	Daily Demand	Plane Assignment		Plane Utilization	Costs	Extra
	Destination	Distance from Salt Lake Hub	Daily Passenger Bookings	Daily Cargo Shipments ft3	Boeing 717	Bombardier CRJ700	Embraer E170	Airbus A220	Total Passenger Capacity	% of Passenger Capacity Utilized	Total Cargo Capacity	% of Cargo Capacity Utilized	Operating Cost	Add'l Cargo ft3 to be Added
	Las Vegas	313	750	1,500	1	1	1	1	398	188%	2,079	72%	$ 174,889
	Albuquerque	421	500	1,500	1	1	1	1	398	126%	2,079	72%	$ 195,765
	Denver	322	550	2,000	1	1	1	1	398	138%	2,079	96%	$ 185,553
	Cheyenne	321	100	1,500	1	1	1	1	398	25%	2,079	72%	$ 101,115
	Boise	257	750	1,000	1	1	1	1	398	188%	2,079	48%	$ 119,826
	Reno	372	500	750	1	1	1	1	398	126%	2,079	36%	$ 121,365
	Phoenix	439	1,250	500	1	1	1	1	398	314%	2,079	24%	$ 246,389
		Total/Avg	4,400	8,750	7	7	7	7	2,786	158%	14,553	60%	$ 1,144,901
													Total Cost
	Income Statement Section:
	Passenger Revenues:	$ 708,315.00
	Cargo Revenues:	$ 1,856,250.00
	Additional Cargo
	Total Revenues:	$ 2,564,565.00
	less Operating Costs:	$ 1,144,901.25
	Daily Gross Profit:	$ 1,419,663.75