Generate a sensitivity report on excel.

1. Summary

We are two owners of a gas station in Denton TX, called Great Value Gas. We provide three types of gasoline: 87 Octane, 89 Octane, and 91 Octane with profit margins of $00.10/Gallon, $00.15/Gallon, and $00.20/Gallon, respectively. 87 Octane requires 87% Isooctane and 13% Heptane. 89 Octane requires 89% Isooctane and 11% Heptane. 91 Octane requires 91% Isooctane and 9% Heptane. How do we make the most profit?

2. Decision Variables

x: Amount of 87 Octane

y: Amount of 89 Octane

z: Amount of 91 Octane

3. Resources

• 750 Gallons of Isooctane
• 450 Gallons of Heptane

4. Model

Max 00.10x + 00.15y + 00.20z

s.t.

.87x + .89y + .91z <=750

.13x + .11y + .09z <=450

x,y,z >= 0