Question: please answer every question. Question 2. Take a scroenubot (anip tool) of you excel spretadabeet and save it. Chak on the image icose below and


Question 2. Take a scroenubot (anip tool) of you excel spretadabeet and save it. Chak on the image icose below and epload your screenthot file. Make sure it is big enough to read (20 polats) as shown bert: Then make sare that your formulas show completely it the eells, you may aced to widen some. Take a screenisot. the the same process as peevious question wo upload. (20 poins). 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 (as demonstrated in the lecture) to determine the following ( 60 points, 15 points each): - The deluxe mix takes 0.9 of a pound of raisins and 0.4 of a pound of neanuts. - The standard mix takes 0.7 of a pound of raisins and 0.6 of a pou Hide peme. For raisins your equation is : =0.9B3+0.7C3
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
