Question: Problem 19-4 A small candy shop is preparing for the holiday season. The owner must decide how many bags of deluxe mix and how many

Problem 19-4 A small candy shop is preparing for the holiday season. The owner must decide how many bags of deluxe mix and how many bags of standard mix of Peanut/Raisin Delite to put up. The deluxe mix has 66 pound raisins and 34 pound peanuts, and the standard mix has 53 pound raisins and 47 pound peanuts per bag. The shop has 78 pounds of raisins and 63 pounds of peanuts to work with Peanuts cost $.63 per pound and raisins cost $1.56 per pound. The deluxe mix will sell for $2.64 per pound, and the standard mix will sell for $2.52 per pound. The owner estimates that no more than 123 bags of one type can be sold. a. If the goal is to maximize profits, how many bags of each type should be prepared? Use Excel Solver. (Round intermediate cost calculations to 2 decimal places and round your answers to the nearest whole number) Deluxe Standard COS bags bags b. What is the expected profit? Use Excel Solver. (Enter your answer based on the unrounded (not rounded) decision variable values from Parta. Round your answer to the nearest whole number. Omit the "$" sign in your response.) Profit
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
