Busch Gardens Sweets is preparing for Spring Break. They prepare two sizes of Peanut and Raisin...

Transcribed Image Text:

Busch Gardens Sweets is preparing for Spring Break. They prepare two sizes of Peanut and Raisin Delight and need to calculate how many bags of deluxe and standard mixes they can produce. The deluxe mix takes 1 pound of raisins and 0.6 of a pound of peanuts. The standard mix takes 0.5 of a pound of raisins and 0.4 of a pound of peanuts. The shop has 90 pounds of raisins and 60 pounds of peanuts. The profit on the deluxe mix is $3.20 and the standard mix profit is $2.50. The owner wants no more than 100 bags of each type prepared. Do not forget the non-negativity constraint and remember that you cannot sell partial bags (whole numbers only). Use Excel Solver (as demonstrated in the lecture) to determine the ; a. The optimal number of Deluxe Mix to prepare (15 points). b. The optimal number of Standard Mix to prepare (15 points). c. What is the optimal profit? Include the formula using actual numeric values, NOT cell location. (25 points) d. How many pounds of raisins are needed to achieve optimal profit? (15 points) e. How many pounds of peanuts are needed to achieve optimal profit? (15 points) f. If the profit on the deluxe bags was increased to $4, would the number of deluxe bags increase or decrease? By how many? (15 points) Busch Gardens Sweets is preparing for Spring Break. They prepare two sizes of Peanut and Raisin Delight and need to calculate how many bags of deluxe and standard mixes they can produce. The deluxe mix takes 1 pound of raisins and 0.6 of a pound of peanuts. The standard mix takes 0.5 of a pound of raisins and 0.4 of a pound of peanuts. The shop has 90 pounds of raisins and 60 pounds of peanuts. The profit on the deluxe mix is $3.20 and the standard mix profit is $2.50. The owner wants no more than 100 bags of each type prepared. Do not forget the non-negativity constraint and remember that you cannot sell partial bags (whole numbers only). Use Excel Solver (as demonstrated in the lecture) to determine the ; a. The optimal number of Deluxe Mix to prepare (15 points). b. The optimal number of Standard Mix to prepare (15 points). c. What is the optimal profit? Include the formula using actual numeric values, NOT cell location. (25 points) d. How many pounds of raisins are needed to achieve optimal profit? (15 points) e. How many pounds of peanuts are needed to achieve optimal profit? (15 points) f. If the profit on the deluxe bags was increased to $4, would the number of deluxe bags increase or decrease? By how many? (15 points)

Answer rating: 100% (QA)

To solve this problem using Excel Solver follow these steps a S... View the full answer