#2 i need an excel solver file and screenshots pls. U may upload the excel solver file on gdrive or any platforms

Transcribed Image Text:

McNaughton, Inc. produces two steak sauces: Spicy Diablo and mild Red Baron. These sauces are both made by blending two ingredients, A and B. A certain level of flexibility is permitted in the formulas for these products. The allowable percentages, along with revenue and cost data are given in the table below. Up to 40 quarts of A and 30 quarts of B could be purchased. McNaughton can sell as much of these sauces as it produces. Solve the LP problem whose objective is to maximize the net revenue from the sale of the sauces using the Solver. INGREDIENTS Sales Price per Quart Sauce A B Spicy Diablo At least 25% At least 50% $3.35 Red Baron At most 75% Cost per Quart $1.60 No explicit max or min $2.59 $2.85 Indicate whether the following changes in the resources will keep the current solution feasible and optimal. For cases where feasibility is maintained, determine the new optimum solution. The selling price of Red Baron is increased to $3.50. The cost of ingredient B is decreased by $1.50. The amount available for A is increased to 55 quarts. The allowable percentage of A in Red Baron is changed to at most 60%. McNaughton, Inc. produces two steak sauces: Spicy Diablo and mild Red Baron. These sauces are both made by blending two ingredients, A and B. A certain level of flexibility is permitted in the formulas for these products. The allowable percentages, along with revenue and cost data are given in the table below. Up to 40 quarts of A and 30 quarts of B could be purchased. McNaughton can sell as much of these sauces as it produces. Solve the LP problem whose objective is to maximize the net revenue from the sale of the sauces using the Solver. INGREDIENTS Sales Price per Quart Sauce A B Spicy Diablo At least 25% At least 50% $3.35 Red Baron At most 75% Cost per Quart $1.60 No explicit max or min $2.59 $2.85 Indicate whether the following changes in the resources will keep the current solution feasible and optimal. For cases where feasibility is maintained, determine the new optimum solution. The selling price of Red Baron is increased to $3.50. The cost of ingredient B is decreased by $1.50. The amount available for A is increased to 55 quarts. The allowable percentage of A in Red Baron is changed to at most 60%.