how would you solve this in excel? please show steps for all 5 questions, thank you!

Home Insert Draw Design Tell me Share O Comments Paste Font Paragraph Styles Dictate #1 The following Draft utput is based on a linear programming problem of minimizing the cost of renting cars luta-JVs and sport cars to use in various trips and accommodating passengers. Answer the questions below and show your calculations. Adjustable Cells Cell Name $B$2 Cars $C$2 Trucks $D$2 SUVs $E$2 Sport Final Reduced Objective Allowable Allowable Value Cost Coefficientlncrease Decrease 18 0 29 17.5 21.5 6 0 39 6 17.2 6 0 45 17.2 6 0 17.5 42 1E+30 17.5 Constraints Cell Name $F$4 Trips $F$5 Rugged trips $F$6 Short trips $F$7 Passengers Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 30 0 30 0 1E+30 12 34.5 12 8 0 18 21.5 18 4.8 0 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? Home Insert Draw Design Tell me Share O Comments Paste Font Paragraph Styles Dictate #1 The following Draft utput is based on a linear programming problem of minimizing the cost of renting cars luta-JVs and sport cars to use in various trips and accommodating passengers. Answer the questions below and show your calculations. Adjustable Cells Cell Name $B$2 Cars $C$2 Trucks $D$2 SUVs $E$2 Sport Final Reduced Objective Allowable Allowable Value Cost Coefficientlncrease Decrease 18 0 29 17.5 21.5 6 0 39 6 17.2 6 0 45 17.2 6 0 17.5 42 1E+30 17.5 Constraints Cell Name $F$4 Trips $F$5 Rugged trips $F$6 Short trips $F$7 Passengers Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 30 0 30 0 1E+30 12 34.5 12 8 0 18 21.5 18 4.8 0 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