Lab $3$: Consider This: Your Turn: Transportation Costs

Apply your creative thinking and problem$-$solving skills to design and implement a solution.

Instructions Part $1$: You are thinking about buying a new vehicle, and you want to make

sure that you buy one that offers the highest fuel savings. You decide to research hybrid cars

as well as gas$-$only cars. Your friends are also interested in your results. Together, you decide

to research the fuel costs associated with various types of vehicles. Research the gas mileage

for six vehicles: three should run only on gas, and the others should be hybrid vehicles,

combining gas and battery power. After you find the gas mileage for each vehicle, you will use

formulas to calculate the fuel cost for one month, one year, and three years. Assume that in a

typical month, you will drive $500$ miles. Develop a worksheet following the general layout in

Table $3-12$ that shows the fuel cost analysis. Use the formulas listed in Table $3-13$ and the

concepts and techniques presented in this module to create the worksheet. You will need to

find the average price of gas for your market. ADD a chart showing the cost comparisons as an

embedded chart.

Table $3-12$ Fuel Cost Analysis

Table $3-13$ Fuel Cost Analysis Formulas

Formula A$=($Distance per Month$/$Miles per Gallon$)*$Price of Gas

Formula B $=(($Distance per Month$/$Miles per Gallon$)*$Price of Gas$)*12$

Formula C $=(($ Distance Per Month$/$Miles per Gallon$)*$Price of Gas$)*36$