Please use attachment as a template and show full steps including making sure that categories are fully viewable.

Sunblessed Juice Company sells bags of oranges and cartons of orange juice. Sunblessed grades oranges on a scale of 1 (poor) to 10 (excellent). At present, Sunblessed has 220,000 pounds of grade 6 oranges and 150,000 pounds of grade 9 oranges on hand. The aver- age quality of oranges sold in bags must be at least 7, and the average quality of the oranges used to produce orange juice must be at least 8. Each pound of oranges that is used for juice yields a revenue of $2.25 and incurs a variable cost (consisting of labor costs, variable overhead costs, inventory costs, and so on) of $1.35. Each pound of oranges sold in bags yields a revenue of $2.00 and incurs a variable cost of $1.20.

a. Determine how Sunblessed can maximize its profit.

b. Use SolverTable to determine how a change in the cost per bag of oranges changes the optimal solution.

c. Use SolverTable to determine how a change in the amount of grade 6 oranges available affects the optimal solution.

d. Use SolverTable to determine how simultaneous changes in the required average quality required for juice and the average quality required for bags change the optimal solution

Open recovered workbooks? Your recent changes were save. A1 : X fx Selling oranges and orange juice A C D E F 1 Selling oranges and orange juice 2 3 Revenues, variable costs 4 Juice 5 Revenue 6 Variable cost 7 8 Grades used to make juice and bags 9 Grade Available 10 11 12 Sold 14 Required average quality 15 16 18 Quality constraints 19 20 Actual 21 22 Required 24 Total variable cost 25 Total revenue 26 27 Profit 28 123 em 5678 222=221EE 29 30 31 33 31 36 Plannin Ready P4-46 Model Calculate Bags Juice Bags Juice Bags Juice Used Bags P4-40 Sensitivity Analysis P4-48 Model 8 P4