Question: Please solve using solver Piscataway Candy is preparing for the holiday season. The owner must decide how many bags of deluxe mix and how many

Please solve using solver Please solve using solver Piscataway Candy is
Piscataway Candy 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 Delight to put up. The deluxe mix has 6/10 pound raisins and 4/10 pound peanuts, and the standard mix has 1/2 pound raisins and 1/2 pound peanuts per bag. The shop has 120 pounds of raisin and 75 pounds of peanuts to work with. Peanuts cost $0.75 per pound and raisins cost $1.8 per pound. The deluxe mix will sell for $3.20 per pound and the standard will sell for $2.40 per pound. The owner estimates that no more than 120 bags of each type can be sold. a. Extract the problem data in a Product Mix Table. (3 points) b. Define Decision Variables (2 points) c. Develop the Objective Function (Profit = Revenue - Cost). Hints: you may calculate the profit per product or for both products together. You may also calculate it directly in the Product Mix Table. (5 points) d. Develop the constraints. (5 points) f. Solve the model using Excel Solver. Include excel file with your solution. (5 points)

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!