Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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.
Table 2: 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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started