This question has been answered
Question

27. Holiday Fruit Company buys oranges and processes them into gift

fruit baskets and fresh juice. The company grades the fruit it buys on a scale from 1 (lowest quality) to 5 (highest quality). The following table summarizes Holiday’s current inventory of fruit.
Grade                                      1       2       3       4      5
Supply (1000s of lbs)             90    225   300   100   75
Each pound of oranges devoted to fruit baskets results in a marginal profit of $2.50, whereas each pound devoted to fresh juice results in a marginal profit of $1.75. Holiday wants the fruit in its baskets to have an average quality grade of at least 3.75 and its fresh juice to have an average quality grade of at least 2.50.
a. Formulate an optimization model for this problem.
b. Implement your model in a spreadsheet and solve it.
c. What is the optimal solution?


Please provide mathematical equation and screen shot of solver solution

Answered by Expert Tutors
1 Attachment
9094687.xls
xls
The student who asked this rated it
Holiday Fruit Company buys oranges and processes them into gift fruit baskets and fresh juice. The company grades the fruit it buys on a scale from...
Get unstuck

292,177 students got unstuck by Course
Hero in the last week

step by step solutions

Our Expert Tutors provide step by step solutions to help you excel in your courses