Question: can someone please answer this question with Solver on Excel PLEASE. and show steps. THANKS standard mix of Peanut/Raisin Delite to put up. The deluxe

can someone please answer this question withcan someone please answer this question with Solver on Excel PLEASE. and show steps. THANKS

standard mix of Peanut/Raisin Delite to put up. The deluxe mix has 2/3 pound raisins and 1/3 pound peanuts, and the standard mix has 1/2 pound raisins and 1/2 pound peanuts per bag. The shop has 90 pounds of raisins and 60 pounds of peanuts to work with. Peanuts cost $.60 per pound and raisins cost $1.50 per pound. The deluxe mix will sell for $4.00 for a one-pound bag, and the standard mix will sell for $3.45 for a one-pound bag. The owner estimates that no more than 200 bags of one type can be sold. a. If the goal is to maximize profits, how many bags of each type should be prepared? Deluxe bags bags Standard b. What is the expected profit? Profit $

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!