BUS 103 – Excel Final Project Transportation Costs Research and Summarize

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

your formulas.

3. Add a chart showing the cost comparisons as an embedded chart. Format the

chart appropriately.

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.

Table 3-14

 

Table 3-15

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

Gas 2

Gas 3

Hybrid 1

Hybrid 2

Hybrid 3

Totals

Distance per Month

Price of Gas

Fuel Cost Analysis

Assumptions

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

decision?

Save your file as yourlastname 103 excel final.

Upload (1) Requirement document and (2) 103 excel final file to Web Access.