Use the table below to answer the following question(s)using the standard Solver.
Below is the spreadsheet for Memphis Designs fixed cost model:

-What is the total cost incurred by the company?
A)$ 8,637.50
B)$ 10,756.80
C)$ 7,289.62
D)$ 9,582.75

Question

Use the table below to answer the following question(s)using the standard Solver.
Below is the spreadsheet for Memphis Designs fixed cost model:
 
-What is the total cost incurred by the company?
A)$ 8,637.50 
B)$ 10,756.80 
C)$ 7,289.62 
D)$ 9,582.75

Quizplus · Accepted Answer

By solving the model using Solver and changing the values of the decision variables (x1, x2, and x3), the objective function (total cost) is minimized to $8,637.50, which is the answer to the first question. The best choice for Memphis Designs is to produce 48 units of product A, 33 units of product B, and 20 units of product C, as this combination results in the lowest total cost.

Use the Table Below to Answer the Following Question(s)using the Standard