Use the Excel Solver Printouts that follow to answer the question below:Calista’s Bakery makes two types of cookies which are sold to Doggie Day Care centers in Greensboro. Both are sold in two pound bags. Both the Pumpkin Bars and the Carob Bars have a per unit profit of $5.00. The cookies ha different requirements for ingredients. The Pumpkin Bars use 1 pound of flour and 4 cups of oatmeal per batch. The Carob Bars require 2 pounds of flour, 3 cups of batmeal. She has 40 pounds of flour and 120 cups of oatmeal available. Calista is concerned about the proper product mix for the cookies and has instructed her marketing manager, Izabella to determine the optimal product mix. Izabella, who took a Management Science course, created linear programming model and ran it in Excel Solver (she defined X1 as the number of bags of Pumpkin Bars and X2 as the number of bags of Carob Bars). Use the Excel Solver Results to answer the following questions about thi problem.
The values of the decision variables at the optimal solution are
a. 160
b. X1 = 24, X2 = 8
c. Constraint 1 = 40, Constraint 2 = 120
d. None of the above is correct
Leave a Reply