BUS 103 – Excel Final Project
Transportation Costs Research and Summarize
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 know that hybrid vehicles are
available, so you decide to research them as well as gas-only cars. You decide to
research the fuel costs associated with various types of vehicles.
Part 1: Create a requirement document using MS Word, pertinent to this project. Follow Figure 3-2 on Page EX 115 shown in the excel textbook as a sample. A requirement document lists the needs (objective), source of data (in this case
supplied by you), calculations, (you will be performing), and chart requirements.
Save your requirement document as yourlasname final project requirement
document. Upload to web access along with excel project file.
Part II: Research the gas mileage for six vehicles: three should run only on gas, others should be hybrid vehicles; (no 100% electrical vehicles). 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 1200 miles. Develop a worksheet
following the general layout in Table 3-14 that shows the fuel cost analysis. Use
the formulas listed in Table 3-15 and the concepts and techniques presented in
chapter 3 to create the worksheet. You will need to find the average price of gas
for your market.
Include this below listed required elements in your worksheet:
1. When listing car names, include car type such as Gas 1–Toyota Camry, or
Hybrid 1-Chevy Malibu.
2. Use absolute reference in your formulas when referencing assumption in
3. Add a chart showing the cost comparisons as an embedded chart. Format the
4. Apply appropriate formatting to the data and labels in the worksheet. Apply
appropriate numbering format to the numbers in the worksheet. Use Cell
styles where applicable.
5. Name the sheet Fuel Cost Analysis.
6. Add any other appropriate formatting if you desire.
Vehicle Model and Name Miles Per Gallon Fuel Cost 1 Month Fuel Cost 1 Year Fuel Cost 3 Years Gas 1 Formula A Formula B Formula C
Distance per Month
Price of Gas
Fuel Cost Analysis
Fuel Cost Analysis Formula 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
Part III: Answer the following questions in a new sheet named Answer.
1. You made several decisions while creating the workbook for this
assignment. Why did you select the chart type used to compare fuel costs?
2. What other costs might you want to consider when making your purchase
Save your file as yourlastname 103 excel final.
Upload (1) Requirement document and (2) 103 excel final file to Web Access.
- BUS 103 – Excel Final Project
- Transportation Costs
- Research and Summarize