\fA B C D E F G H K Microsoft Excel 16.0 Answer Report Worksheet: [Book1]Sheet1 Report Created: 4/17/2022 5:35:56 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.062 Seconds. Iterations: 6 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative 13 14 Objective Cell (Max) Cell Name Original Value Final Value 16 SB$20 Net Ruturns(in million $) (in million s) 0.240819941 0.240819941 18 19 Variable Cells Cell Name Original Value Final Value Integer SBSS Education (in million $) 3.303191489 3.303191489 Contin 22 $8$9 Home (In million $) 4.069148936 4.069148936 Contin $8$10 Car (in million $) 1.627659574 1.627659574 Contin 25 Constraints Cell Name Cell Value Formula Status Slack 28 SB$13 Total Loan (in million $) 9 58$13=SDS14 Not Binding 0.303191489 $8$15 Home Loan (in million $) 4.069148936 $8$15>=$0$15 Not Binding 2.719148936 $8$16 Car Loan (in million $) 1.627659574 $8$16>=$0$16 Binding SBS17 Total Bad Debt (in million S) 0.1125 $8$17