Go to the Premiums worksheet, which lists data about premiums Flamingo Guitars occasionally offers to include an accessory along with the sale of three types of deluxe guitars. The company wants to keep the total costs low when running the premium offers. Isabella wants to know how many premiums to offer of each type to minimize costs while running up to five premiums a year. Use Solver to find this information as follows:

a. Use the total cost of the premiums (cell E9, named Total_cost) as the objective cell in the Solver model, with the goal of minimizing the value.

b. Use the number of premiums offered (range B7:D7) as the changing variable cells.

c. Determine and enter the constraints based on the information provided in Table 2.

d. Use Simplex LP as the solving method to find a global optimal solution.

e. Solve the model, keeping the Solver solution.

Solver Constraints

Constraint	Cell or Range
The company offers at least one premium per category	B7:D7
The number of premiums is an integer	B7:D7
The company offers up to 3 premiums in the Premium 1 category	Premium_1 (cell B7)
The company offers up to 3 premiums in the Premium 2 category	Premium_2 (cell C7)
The company offers up to 3 premiums in the Premium 3 category	Premium_3 (cell D7)
The company offers at least 5 premiums per year	E7

Ey Changing Variable Cells: Subject to the Constraints: Make Unconstrained Variables Non-Negative Ey Changing Variable Cells: Subject to the Constraints: Make Unconstrained Variables Non-Negative