Microsoft Excel 16.0 Answer Report Worksheet: [Book]Sheeti Report Created: 7/15/2021 8:13:24 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine 6 Engine: Simplex LP 7 Solution Time: 0.016 Seconds. 8 Iterations. 3 Subproblems: 0 9 Solver Options 10 Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling 11 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative 12 13 14 Objective Cell (Max) 15 Cell Name Original Value Final Value 16 $F$3 Objective Functions 45,522.22 17 18 19 Variable Cells 20 Cell Name 21 $B$2 Changing Variable Cells 1 22 $C$2 Changing Variable Cells x2 23 $D$2 Changing Variable Cells 3 24 SE$2 Changing Variable Cells 4 25 26 27 Constraints 28 Cell Name 29 $F$4 C1 30 $F$5 C2 31 $F$6 C3 32 $F$7 CA 33 SF$8 C5 Original Value Final Value Integer 175.56 Contin 0 57.78 Contin 500 Contin 0 Contin Cell Value Formula Status 72 $F$A<=$GSA Binding 1200 $F$5<=$G$S Binding 21593.33333 $F$6<=SGS6 Not Binding 233.3333333 SF$7<=$G$7 Not Binding 500 SF$8<=SG$8 Binding Slack 0 3,406.67 266.67 Which constraints are binding