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
.69 pound raisins and .31 pound peanuts, and the standard mix has
.57 pound raisins and .43 pound peanuts per bag. The shop has 82
pounds of raisins and 67 pounds of peanuts to work with.
Peanuts cost $.67 per pound and raisins cost $1.64 per pound. The
deluxe mix will sell for $2.76 per pound, and the standard mix will
sell for $2.68 per pound. The owner estimates that no more than 127
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 ______ bags
Standard ______ bags
b. What is the expected profit? Use Excel Solver. (Enter your answer based on the unrounded (not rounded) decision variable values from Part a. Round your answer to the nearest whole number. Omit the "$" sign in your response.)
Profit ______
https://support.office.com/en-us/article/load-the-solver-add-in-in-excel-612926fc-d53b-46b4-872c-e24772f078ca
Get Answers For Free
Most questions answered within 1 hours.