Please don't answer this question because the pictures are not good. I will repost this.

I have part A done and need help with part B. I keep getting the error shown in the attachment. Please show me how to fix this problem and to get the correct table.

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 100,000 pounds of grade 9 oranges and 120,000 pounds of grade 6 oranges on hand. The average 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 $1.50 and incurs a variable cost (consisting of labor costs, variable overhead costs, inventory costs, and so on) of $1.05. Each pound of oranges sold in bags yields a revenue of $1.50 and incurs a variable cost of $0.70.

1. Determine how Sunblessed can maximize its profit.
2. Use SolverTable to determine how a change in the cost per bag of oranges changes the optimal solution.
3. Use SolverTable to determine how a change in the amount of grade 9 oranges available affects the optimal solution.
4. Use SolverTable to determine how a change in the required average quality required for juice changes the optimal solution.

17 Selling and orange j Grade of orange Grade Actu --1 23 34 Vanable 25 Pu 41 x fx . apofange tap www $100 $2.45 $1.30 WETS $1.30 BESS $3.30 3138 OFTE dy ap Cartues of orange $2.00 51.30 Ca K 290000000 Ready Calculate SEAY 51.30 P4-46 Model 3030000 200000 $140.000 $180.000 $100 $100,000 0000000 sets WIS Cartas ce Comme 2666666667 320000 150000 80000 DHAST Contanite m 640000 640000 $100000 20 10000 190000-000 P4-46 Sensitivity Analysis 220000 150000 Parameters for oneway table Specify the the catal on f O DAR spec vale has a spo pe pi NG M 31 Came P4-48 Model P4-48 Sensitivity Analysis 1.50 v ( ww the Thing 16. P4-50 Model mes # 9 Invalid entry Don't include any ampty cells in the output range OK P4-30 Betty Analysis 3 . " Selling ranges and orange juice Variable mat Grade of orange - Grade 2 3 4 9.6. 10 11 12 11 -14 16 17 19 Adul 21 Pepired 96 Variable revenue Profe Dr. 11 311 341.00 BULL 31 13 31.25 KIM SET IN ALLA WID 431.5 sold Selling oranges and orange juice Bags of cranges Cartons of orange 235 12 1.35 Bags 19333333333335 MEGA GOSSE SUMB30 Cartons/ 20 53333333333333 SUMCRCIO Bags Cartonuice Bags Carton SUMPRODUCTABASC) SUMPRODUCTIA ACC The -BESPREE CIS CH legs Cartonsure - -8114 +827-416 -879-C Revenue 2 110.00 TD. BID CH C Prote Used -C 30-30 ictions Manager Create from Selection 220000 " 150000 Trace Dependents FRemove Arrows Fo 17 Selling and orange j Grade of orange Grade Actu --1 23 34 Vanable 25 Pu 41 x fx . apofange tap www $100 $2.45 $1.30 WETS $1.30 BESS $3.30 3138 OFTE dy ap Cartues of orange $2.00 51.30 Ca K 290000000 Ready Calculate SEAY 51.30 P4-46 Model 3030000 200000 $140.000 $180.000 $100 $100,000 0000000 sets WIS Cartas ce Comme 2666666667 320000 150000 80000 DHAST Contanite m 640000 640000 $100000 20 10000 190000-000 P4-46 Sensitivity Analysis 220000 150000 Parameters for oneway table Specify the the catal on f O DAR spec vale has a spo pe pi NG M 31 Came P4-48 Model P4-48 Sensitivity Analysis 1.50 v ( ww the Thing 16. P4-50 Model mes # 9 Invalid entry Don't include any ampty cells in the output range OK P4-30 Betty Analysis 3 . " Selling ranges and orange juice Variable mat Grade of orange - Grade 2 3 4 9.6. 10 11 12 11 -14 16 17 19 Adul 21 Pepired 96 Variable revenue Profe Dr. 11 311 341.00 BULL 31 13 31.25 KIM SET IN ALLA WID 431.5 sold Selling oranges and orange juice Bags of cranges Cartons of orange 235 12 1.35 Bags 19333333333335 MEGA GOSSE SUMB30 Cartons/ 20 53333333333333 SUMCRCIO Bags Cartonuice Bags Carton SUMPRODUCTABASC) SUMPRODUCTIA ACC The -BESPREE CIS CH legs Cartonsure - -8114 +827-416 -879-C Revenue 2 110.00 TD. BID CH C Prote Used -C 30-30 ictions Manager Create from Selection 220000 " 150000 Trace Dependents FRemove Arrows Fo