Please help me with the following excel interpretation. (Question b, c) Thank you so much!!

OAK PRODUCTS, INC American American Spanish Spanish Captain Mate Product High Low King Queen Qty Produced Profit/Unit 100 40 53 72 $36$40 $45 $38 $35 $25 Total Profit$10,294.00 Starting Inventory Usage Total Product Resource Requirement Long Dowels 8 Short Dowels 4 Legs Heavy Seats Light Seats Heavy Rungs 6 Light Rungs Capt Rail Mate Rail Amber Rail Spanish Rail 1280 1900 1060 100 165 760 553 100 72 93 1280 1900 1090 190 170 1000 1000 110 72 93 85 12 12 12 5 0 Data Only Sensitivity Report 1 (g) Microsoft Excel 16.16 Sensitivity Report Worksheet: [Final - Q3.xlsx]Data Only Report Created: 2/28/19 3:22:45 PM Variable Cells Final Reduced Objective AllowableAllowable Cell $B$4 $C$4 Value 100 72 CoefficieniIncrease Decrease 1 40 1.0E+30 8.666666 10 20 1 1.0E+30 25 8.666666 1.0E+30 Name Cost 36 6.666666 ty Produced Captain ty Produced Mate ty Produced American High40 ty Produced American Low 53 ty Produced Spanish Kinq 0 ty Produced Spanish Queen 0 -8.666666667 45 38 35 26 13 E4 SG$4 Constraints Final Shadow Constraint AllowableAl1owable Value Price Cell J$9Long Dowels Usage JS10 Short Dowels Usage J$11 Legs Usage J$12Heavy Seats Usage JS13Light Seats Usage JS14 Heavy RungsUsage J$15 Light Rungs Usage JS16 Capt Rail Usage J$17Mate Rail Usage J$18Amber Rail Usage R.H. Side Increase Decrease 1200 954 30 90 Name 1280 3.194444444 90 90 1090 1.0E+30 190 1.0E+30 170 1.0E+30 1000 1.0E+30 1000 1.0E+30 110 1.0E+30 1280 1900 1060 100 165 760 553 100 240 447 10 10 10 85 72 93 85 1.0E+3 72 8.666666667 93 6.666666667 $JS19Spanish Rail Usage 10694 33.33333333 8.666666667 Mate Rail Usage 31.94444444 Data Only Sensitivity Report 1 OAK PRODUCTS, INC AmericanAmerican Spanish Spanish ta Mate High Low KingQueen Product Qty Produced Profit/Unit 85 17 50 Total Profit $6,589.00 $36$40 $45 $38$35$25 Starting InventoryUsage Total Product Resource Requirement 12 1280 1900 1090 190 170 1000 1000 110 72 93 85 1280 760 680 85 85 625 158 Long Dowels Short Dowels Legs Heavy Seats Light Seats Heavy Rungs Light Rungs Capt Rail Mate Rail Amber Rail Spanish Rail 12 12 8 0 17 68 85 0 170 Total Product Spanish-50% total American-40% total Data Only Sensitivity Report 1 Questions: (a) (1 point) If the profit on a Captain chair were $40 instead of $36, what would OP's new Total Profit be? (b) (1 point) What is the most OP would be willing to pay for one more Heavy Seat? (c) (4 points) Please ch oose yeso for each one of the following questions and explain your answer. e profit on a Mate chair were $45 instead of $40, would the production plan change? Yes/No Your reason: (ii) If the profit on a Mate chair were $30 instead of $40, would the production plan change? Yes/ No Your reason: (nIf the profit on a Spanish King chair were $40 instead of $35, would the production plan Yes/ No change? Your reason (iv) If the profit on a Captain chair were $35 instead of $36, would the production plan change? Yes/No Your reason: OAK PRODUCTS, INC American American Spanish Spanish Captain Mate Product High Low King Queen Qty Produced Profit/Unit 100 40 53 72 $36$40 $45 $38 $35 $25 Total Profit$10,294.00 Starting Inventory Usage Total Product Resource Requirement Long Dowels 8 Short Dowels 4 Legs Heavy Seats Light Seats Heavy Rungs 6 Light Rungs Capt Rail Mate Rail Amber Rail Spanish Rail 1280 1900 1060 100 165 760 553 100 72 93 1280 1900 1090 190 170 1000 1000 110 72 93 85 12 12 12 5 0 Data Only Sensitivity Report 1 (g) Microsoft Excel 16.16 Sensitivity Report Worksheet: [Final - Q3.xlsx]Data Only Report Created: 2/28/19 3:22:45 PM Variable Cells Final Reduced Objective AllowableAllowable Cell $B$4 $C$4 Value 100 72 CoefficieniIncrease Decrease 1 40 1.0E+30 8.666666 10 20 1 1.0E+30 25 8.666666 1.0E+30 Name Cost 36 6.666666 ty Produced Captain ty Produced Mate ty Produced American High40 ty Produced American Low 53 ty Produced Spanish Kinq 0 ty Produced Spanish Queen 0 -8.666666667 45 38 35 26 13 E4 SG$4 Constraints Final Shadow Constraint AllowableAl1owable Value Price Cell J$9Long Dowels Usage JS10 Short Dowels Usage J$11 Legs Usage J$12Heavy Seats Usage JS13Light Seats Usage JS14 Heavy RungsUsage J$15 Light Rungs Usage JS16 Capt Rail Usage J$17Mate Rail Usage J$18Amber Rail Usage R.H. Side Increase Decrease 1200 954 30 90 Name 1280 3.194444444 90 90 1090 1.0E+30 190 1.0E+30 170 1.0E+30 1000 1.0E+30 1000 1.0E+30 110 1.0E+30 1280 1900 1060 100 165 760 553 100 240 447 10 10 10 85 72 93 85 1.0E+3 72 8.666666667 93 6.666666667 $JS19Spanish Rail Usage 10694 33.33333333 8.666666667 Mate Rail Usage 31.94444444 Data Only Sensitivity Report 1 OAK PRODUCTS, INC AmericanAmerican Spanish Spanish ta Mate High Low KingQueen Product Qty Produced Profit/Unit 85 17 50 Total Profit $6,589.00 $36$40 $45 $38$35$25 Starting InventoryUsage Total Product Resource Requirement 12 1280 1900 1090 190 170 1000 1000 110 72 93 85 1280 760 680 85 85 625 158 Long Dowels Short Dowels Legs Heavy Seats Light Seats Heavy Rungs Light Rungs Capt Rail Mate Rail Amber Rail Spanish Rail 12 12 8 0 17 68 85 0 170 Total Product Spanish-50% total American-40% total Data Only Sensitivity Report 1 Questions: (a) (1 point) If the profit on a Captain chair were $40 instead of $36, what would OP's new Total Profit be? (b) (1 point) What is the most OP would be willing to pay for one more Heavy Seat? (c) (4 points) Please ch oose yeso for each one of the following questions and explain your answer. e profit on a Mate chair were $45 instead of $40, would the production plan change? Yes/No Your reason: (ii) If the profit on a Mate chair were $30 instead of $40, would the production plan change? Yes/ No Your reason: (nIf the profit on a Spanish King chair were $40 instead of $35, would the production plan Yes/ No change? Your reason (iv) If the profit on a Captain chair were $35 instead of $36, would the production plan change? Yes/No Your reason