The following Excel output is based on a linear programming problem of minimizing the cost of renting cars trucks SUVs and sport cars to use in various trips and accommodating passengers. Answer the questions below and show your calculations. Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$2 Cars 18 0 29 17.5 21.5 $C$2 Trucks 6 0 39 6 17.2 $D$2 SUVs 6 0 45 17.2 6 $E$2 Sport 0 17.5 42 1E+30 17.5 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$4 Trips 30 0 30 0 1E+30 $F$5 Rugged trips 12 34.5 12 8 0 $F$6 Short trips 18 21.5 18 4.8 0 $F$7 Passengers 150 1.5 150 24 24 1. What is the total cost? 2. How many cars should you rent? 3. You need to handle 20 short trips. What will be your cost? 4. The cost of a truck went up to $47. What will be your cost? 5. You have a budget of $1,050. How many passengers could you accommodate?