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.

Perform the following tasks:

Part 1: Research the gas mileage for eight vehicles: four 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, six months, and two years. Assume that in a typical month, you will drive 1,250 miles. Develop a worksheet following the general layout in Table 3–9 that shows the fuel cost analysis. Use the formulas listed in Table 3–10 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.

Part 2: You made several decisions while creating the workbook for this assignment: how to lay out the data in the worksheet and which chart types to use. What was the rationale behind each of these decisions? What other costs might you want to consider when making your purchase decision?
 
 

Transcribed Image Text:

Table 3-9 Fuel Cost Analysis Vehicle Gas 1 Gas 2 Gas 3 Gas 4 Hybrid 1 Hybrid 2 Hybrid 3 Hybrid 4 Assumptions Miles Per Gallon Distance per Month 1,250 Price of Gas Fuel Cost 1 Month Fuel Cost 6 Months Fuel Cost 2 Years Formula B Formula A Formula C ||||||| 21|||||| ||||||| Table 3-9 Fuel Cost Analysis Vehicle Gas 1 Gas 2 Gas 3 Gas 4 Hybrid 1 Hybrid 2 Hybrid 3 Hybrid 4 Assumptions Miles Per Gallon Distance per Month 1,250 Price of Gas Fuel Cost 1 Month Fuel Cost 6 Months Fuel Cost 2 Years Formula B Formula A Formula C ||||||| 21|||||| |||||||