Your car gets 28 miles per gallon (mpg) at 55 miles per hour (mph) and 22...

 

Transcribed Image Text:

Your car gets 28 miles per gallon (mpg) at 55 miles per hour (mph) and 22 mpg at 65 mph. At what speed should you make a 500-mile trip: a. If gas costs $ 2.50 per gallon and your time is worth $18 per hour? b. If gas costs $3.25 per gallon and your time is worth $15 per hour? c. If gas costs $3.75 per gallon and your time is worth $12 per hour? d. Build a spreadsheet in excel to calculate the total trip cost for gas costs of $2.50, $3.25, and $3.75, and values of time of $10, $12, $15, 18 and $20 per hour. Do two tables: one at 55mph and one at 65 mph Show all the necessary work and attach your answers as a word and/or excel file ONLY below. Your car gets 28 miles per gallon (mpg) at 55 miles per hour (mph) and 22 mpg at 65 mph. At what speed should you make a 500-mile trip: a. If gas costs $ 2.50 per gallon and your time is worth $18 per hour? b. If gas costs $3.25 per gallon and your time is worth $15 per hour? c. If gas costs $3.75 per gallon and your time is worth $12 per hour? d. Build a spreadsheet in excel to calculate the total trip cost for gas costs of $2.50, $3.25, and $3.75, and values of time of $10, $12, $15, 18 and $20 per hour. Do two tables: one at 55mph and one at 65 mph Show all the necessary work and attach your answers as a word and/or excel file ONLY below.

Answer rating: 100% (QA)

To calculate the speed at which you should make a 500mile trip we can use the concept of fuel consum... View the full answer