LEAD Fuel Linear Program Model w/ Excel Solver

John Smith creates three types of aviation fuel (A, B, and C). He does this by blending four ingredients: Alky; Catalytic CG; SR Fuel; and ISO. John's production manager, Lisa Bonner, has compiled the data on ingredients and fuel types in Tables 1 and 2. Table 1 lists the supplies and values of the ingredients, as well as their key chemical properties, pressure, and octane rating. Table 2 lists the demand, prices, and chemical requirements of the three fuel types.

Table 1 (Data on Ingredients) Ingredient Alky CCG SRG ISO Supply (1000s) 125 140 150 120 Octane (low LEAD) 97 86 84 101 Octane (high LEAD) 104 96 88 110 Pressure 6 8 3 20 Value $4.15 $2.65 $2.25 $2.35 Table 2 (Data on Fuel) Fuel A B C Demand (1000s) 125 135 115 Max pressure 8 8 8 Min octane 91 98 100 LEAD Level Low High High Price $3.10 $3.65 $4.00