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.
Don't use plagiarized sources. Get Your Custom Essay on
Answered! A small candy shop is preparing for the holiday season. The owner must decide how many bags of deluxe mix and…
GET AN ESSAY WRITTEN FOR YOU FROM AS LOW AS $13/PAGE
Please see the solution below:
|Raisins||Peanuts||Price||Number of bags||Limit|
|Deluxe Bag||0.666667||0.333333||$ 2.90||90||<=||110|
|Cost||$ 1.50||$ 0.60|