Microsoft Excel 16.0 Answer Report Worksheet: [Question 1b.xlsx]Question 1b Report Created: 2022/09/21 00:51:25 Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0 Seconds. Iterations: 2 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0,000001 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1% Objective Cell (Max) Cell Name Original Value Final Value $D$6 Unit Profit Total Profit 74000 74000 Variable Cells Cell Name Original Value Final Value Integer $B$5 Num to make Split Finger 500 500 Contin $C$5 Num to make Sausage Finger 150 150 Contin Constraints Cell Name Cell Value Formula Status Slack $D$9 Cutting and Sewing Used 725 $D$9=0 Not Binding 500 $C$5 Num to make Sausage Finger 150 $C$5>=0 Not Binding 150Microsoft Excel 16.0 Sensitivity Report Worksheet: [Question 1b.xlsx]Question 1b Report Created: 2022/09/21 00:51:25 Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 Num to make Split Finger 500 0 100 140 20 $C$5 Num to make Sausage Finger 150 O 160 40 93,33333333 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $D$9 Cutting and Sewing Used 725 0 900 1E+30 175 $D$10 Finishing Used 300 60 300 100 166,6666667 $D$11 Packaging and Shipping Used 100 560 100 35 25Microsoft Excel 16.0 Limits Report Worksheet: [Question 1b.xlsx]Question 1b Report Created: 2022/09/21 00:51:25 Objective Cell Name Value $D$6 Unit Profit Total Profit 74000 Variable Lower Objective Upper Objective Cell Name Value Limit Result Limit Result $B$5 Num to make Split Finger 500 0 24000 500 74000 SC$5 Num to make Sausage Finger 150 0 50000 150 74000