USA: +1 (725) 712-1730 
Sign in
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 Deilite to put up. The deluxe mix has 2/3 pound raisins and 1/3 pound peanuts per bag; 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 $0.60 per pound and raisins cost $1.50 per pound. The deluxe mix sells for $2.90 per pound and the standard mix sells for $2.55 per pound The owner estimated that no more than 110 bags of one type can be sold.
Must be solved using the solver in excel, I can’t figure out how to input the no more 110 bags of one type.
Expert Answer
Please see the solution below:
| Raisins | Peanuts | Price | Number of bags | Limit | ||
| Deluxe Bag | 0.666667 | 0.333333 | $ 2.90 | 90 | <= | 110 |
| Standard | 0.50 | 0.50 | $ 2.55 | 60 | <= | 110 |
| Total | 90 | 60 | ||||
| Cost | $ 1.50 | $ 0.60 | ||||
| Used | 90 | 60 | ||||
| <= | <= | |||||
| Available | 90 | 60 | ||||
| Revenue | 414 | |||||
| Cost | 171 | |||||
| Profit | 243 | |||||
