Docstoc

TBA Airlines

Document Sample
TBA Airlines Powered By Docstoc
					     A            B                      C              D           E   F         G         H              I                 J
 1   TBA Airlines Airplane Purchasing Problem
 2
 3                                 Small Airplane Large Airplane                                Range Name                Cells
 4       Unit Profit ($millions)         1              5                                       Capital Available         G8
 5                                                                                              CapitalPerUnitPurchased   C8:D8
 6                                                                 Capital     Capital          CapitalSpent              E8
 7                                  Capital Per Unit Purchased     Spent      Available         MaxSmallAirplanes         C14
 8          Capital ($millions)         5                50         100 <=      100             NumberPurchased           C12:D12
 9                                                                                              SmallAirplanes            C12
10                                                                           Total Profit       TotalProfit               G12
11                           Small Airplane Large Airplane                   ($millions)        UnitProfit                C4:D4
12        Number Purchased         0              2                              10
13                                <=
14   Maximum Small Airplanes       2

				
DOCUMENT INFO