Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Open the workbook named Quotes.xlsx located in the Chapter 8 folder, and save the file as Transport Quotes.xlsx. Examine the Analysis worksheet, and apply appropriate

image text in transcribed

  1. Open the workbook named Quotes.xlsx located in the Chapter 8 folder, and save the file as Transport Quotes.xlsx.

  2. Examine the Analysis worksheet, and apply appropriate names to cells D17:D20.

  3. Set up the structure of a one-variable data table on the Analysis worksheet that shows the car charge, mileage charge, gas expense, and total transportation expense given changes in the average price of gas from $2.20 to $3.80 by increments of $0.20.

  4. Instruct Excel to complete the one-variable data table.

Chapter 8

TROUBLESHOOTING: In order to complete the one-variable data table successfully, be sure to select the correct data table range. If you instruct Excel to complete an incorrect range, you cannot just delete any extra results that might have appeared at the bottom or right of the intended data table area. When you try to do so, you will receive the Cannot change part of a data table error message. You cannot delete only some results from a filled-in data table; you must delete all results values from a one- variable data table if you want to delete any results.

  1. Add headings and basic formatting to the data table so it has a more professional appearance.

  2. A few rows below the one-variable data table, create the structure for a two-variable data table that shows the total projected transportation expense given the interac- tion between average gas prices from $2.20 to $3.80 by increments of $0.20 and miles per gallon from 18 to 28 by increments of 2 miles per gallon.

  3. Instruct Excel to complete the two-variable data table.

  4. Add headings and some basic formatting to the data table so it has a more professional

    appearance.

  5. Save and close the Transport Quotes.xlsx workbook.

Rental Car Cost Analysis As of June 30, 2013 Car Rental Contract Terms Car type: Neekly rental car charge: Charge per mile: 2 Customer-related data Number of weeks renting car: Estimated number of miles to drive: Mid-size $185.00 $0.15 475 Gas-related data Average miles per gallon for car Average cost per gallon of gas 20 $2.85 $ Quote Customer Projected Costs of: Car charge Mileage charge Gas expenses Total projected transportation exp 370.00 71.25 67.69 508.94 $ Rental Car Cost Analysis As of June 30, 2013 Car Rental Contract Terms Car type: Neekly rental car charge: Charge per mile: 2 Customer-related data Number of weeks renting car: Estimated number of miles to drive: Mid-size $185.00 $0.15 475 Gas-related data Average miles per gallon for car Average cost per gallon of gas 20 $2.85 $ Quote Customer Projected Costs of: Car charge Mileage charge Gas expenses Total projected transportation exp 370.00 71.25 67.69 508.94 $

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Misunderstanding Financial Crises Why We Donot See Them Coming

Authors: Gary B. Gorton

1st Edition

019992290X, 0199986886, 9780199922901, 9780199986880

More Books

Students also viewed these Finance questions