Question 1. Busch Gardens Sweets is preparing for the Halloween rush. They prepare two sizes of Peanut/Raisin Ghoulish Delight and need to calculate how many bags of deluxe and standard mixes they can produce. • The deluxe mix takes 0.9 of a pound of raisins and 0.4 of a pound of peanuts. • The standard mix takes 0.7 of a pound of raisins and 0.6 of a pound of peanuts. The shop has 100 pounds of raisins and 70 pounds of peanuts. The profit on the deluxe mix is $1.80 and the standard mix profit is $1.60. The owner wants no more than 110 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 Question 2. Take a screenshot (snip tool) of you excel spreadsheet and save it.
Question 1. Busch Gardens Sweets is preparing for the Halloween rush. They prepare two sizes
of Peanut/Raisin Ghoulish Delight and need to calculate how many bags of deluxe and standard
mixes they can produce.
• The deluxe mix takes 0.9 of a pound of raisins and 0.4 of a pound of peanuts.
• The standard mix takes 0.7 of a pound of raisins and 0.6 of a pound of peanuts.
The shop has 100 pounds of raisins and 70 pounds of peanuts.
The profit on the deluxe mix is $1.80 and the standard mix profit is $1.60. The owner wants no
more than 110 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
Question 2. Take a screenshot (snip tool) of you excel spreadsheet and save it.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images
