The question above needs to be solved by using the excel format below 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 1 (lowest quality) to 5 (highest quality). The following table summarizes Holiday's current inventory of fruit. Grade 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? i Holiday Fruit Company 3 Input Data 4 Unit profit 5 Quality grade required Baskets $2.50 3.75 Juice $1.75 2.5 7 Fruit inventory Grade Baskets Juice Uued Supply Total Production 16 Quality Control Constraints 17 Grade points produced 19 Grade points needed 21 Pro Summary 22 P