3-12 Improving Decision Making: Using Web Tools to Configure and Price an Automo
ID: 3848754 • Letter: 3
Question
3-12 Improving Decision Making: Using Web Tools to Configure and Price an Automobile Software skills: Internet-based software and MS Excel Business skills: Researching product information and pricing In this exercise, you will use software at car- selling Web sites to find product information about a car of your choice and use that information to make an important purchase decision. You will also evaluate two of these sites as selling tools. You are interested in purchasing a new Ford Escape (or some other car of your choice). Go to the Web site of CarsDirect ( www. carsdirect. com) and begin your investigation. Locate the Ford Escape. Research the various Escape models, choose one you prefer in terms of price, features, and safety ratings. Locate and read at least two reviews. Surf the Web site of the manufacturer, in this case Ford ( www. ford. com). Compare the information available on Ford’s Web site with that of CarsDirect for the Ford Escape. Try to locate the lowest price for the car you want in a local dealer’s inventory. Suggest improvements for CarsDirect. com and Ford. com.
3-12 Requirements: Answers will vary a great deal, and with the option of choosing a car other than the Ford Escape, each student will more than likely turn in a different report. Students are required to use an Excel spreadsheet to compare the auto information from each of the Web sites. This will allow them to see from line-to-line the differences and similarities between the prices, safety ratings, features, and so on. Also, students should write a brief summary of the reviews they read concerning the auto and in their final report tell which decision they made referring back to the reviews. The final report should also include a review of the Web sites with suggestions for improvement.
Please help with this question and prrovide an excel file so I can see how it was done! thanks!
Explanation / Answer
Car name
Model
Feature
Frontal Rating(Driver, passenger)
Side Rating (front seat,rear seat)
Price in cars.com
Price in ford.com
Ford Escape
2017 S 4dr Front-wheel Drive
Engine
2.5L I-4 168 HP 170.0 ft.lbs. @ 4,500 rpm
Transmission
6-spd SelectShift w/OD
Fuel Economy City
21.0 mpg
Fuel Economy Hwy
29.0 mpg
Bumper to Bumper Months/Miles
36/36,000
4.5
5
$20,374
$23,750
Ford Escape
2017 SE 4dr Front-wheel Drive
Engine
Standard:
1.5L I-4 179 HP 177.0 ft.lbs. @ 2,500 rpm
Available:
2.0L I-4 245 HP 275.0 ft.lbs. @ 3,000 rpm
Transmission
6-spd SelectShift w/OD
Fuel Economy City
23.0 mpg
Fuel Economy Hwy
30.0 mpg
Bumper to Bumper Months/Miles
36/36,000
6
5
$21,591
$25,250
Ford Escape
2017 SE 4dr 4x4
Engine
Standard:
1.5L I-4 179 HP 177.0 ft.lbs. @ 2,500 rpm
Available:
2.0L I-4 245 HP 275.0 ft.lbs. @ 3,000 rpm
Transmission
6-spd SelectShift w/OD
Fuel Economy City
22.0 mpg
Fuel Economy Hwy
28.0 mpg
Bumper to Bumper Months/Miles
36/36,000
4.5
5
$23,287
$24,880
Ford Escape
2017 titanium 4dr Front-wheel drive
Engine
Standard:
1.5L I-4 179 HP 177.0 ft.lbs. @ 2,500 rpm
Available:
2.0L I-4 245 HP 275.0 ft.lbs. @ 3,000 rpm
Transmission
6-spd SelectShift w/OD
Fuel Economy City
23.0 mpg
Fuel Economy Hwy
30.0 mpg
Bumper to Bumper Months/Miles
36/36,000
4.5
5
$25,469
$27,790
Ford Escape
2017 titanium 4dr 4x4
Engine
Standard:
1.5L I-4 179 HP 177.0 ft.lbs. @ 2,500 rpm
Available:
2.0L I-4 245 HP 275.0 ft.lbs. @ 3,000 rpm
Transmission
6-spd SelectShift w/OD
Fuel Economy City
22.0 mpg
Fuel Economy Hwy
28.0 mpg
Bumper to Bumper Months/Miles
36/36,000
$27,165
I found the car prices based on the pin code 70001
The four models are very efficient based on the safety rating.
i would prefer the 2017 S 4dr Front-wheel Drive ford model as it has a good fuel ecomnomy as compared to the rest, and its price is also the cheapest.
In reviews also that model got the most positive rating.
Ford.com offers higher prices to similar models as compared to cars.com, i would suggest to ford.com to reduce the prices to that it can give tough compitition to cars.com
Ford.com has a easier and user friendly interface as compared to cars.com.
cars.com should follow a modular design, and list the car models in a tabular format, and not list the car models from top to bottom.
Hope your question has been resolved. Please do not forget to like the answer.
Car name
Model
Feature
Frontal Rating(Driver, passenger)
Side Rating (front seat,rear seat)
Price in cars.com
Price in ford.com
Ford Escape
2017 S 4dr Front-wheel Drive
Engine
2.5L I-4 168 HP 170.0 ft.lbs. @ 4,500 rpm
Transmission
6-spd SelectShift w/OD
Fuel Economy City
21.0 mpg
Fuel Economy Hwy
29.0 mpg
Bumper to Bumper Months/Miles
36/36,000
4.5
5
$20,374
$23,750
Ford Escape
2017 SE 4dr Front-wheel Drive
Engine
Standard:
1.5L I-4 179 HP 177.0 ft.lbs. @ 2,500 rpm
Available:
2.0L I-4 245 HP 275.0 ft.lbs. @ 3,000 rpm
Transmission
6-spd SelectShift w/OD
Fuel Economy City
23.0 mpg
Fuel Economy Hwy
30.0 mpg
Bumper to Bumper Months/Miles
36/36,000
6
5
$21,591
$25,250
Ford Escape
2017 SE 4dr 4x4
Engine
Standard:
1.5L I-4 179 HP 177.0 ft.lbs. @ 2,500 rpm
Available:
2.0L I-4 245 HP 275.0 ft.lbs. @ 3,000 rpm
Transmission
6-spd SelectShift w/OD
Fuel Economy City
22.0 mpg
Fuel Economy Hwy
28.0 mpg
Bumper to Bumper Months/Miles
36/36,000
4.5
5
$23,287
$24,880
Ford Escape
2017 titanium 4dr Front-wheel drive
Engine
Standard:
1.5L I-4 179 HP 177.0 ft.lbs. @ 2,500 rpm
Available:
2.0L I-4 245 HP 275.0 ft.lbs. @ 3,000 rpm
Transmission
6-spd SelectShift w/OD
Fuel Economy City
23.0 mpg
Fuel Economy Hwy
30.0 mpg
Bumper to Bumper Months/Miles
36/36,000
4.5
5
$25,469
$27,790
Ford Escape
2017 titanium 4dr 4x4
Engine
Standard:
1.5L I-4 179 HP 177.0 ft.lbs. @ 2,500 rpm
Available:
2.0L I-4 245 HP 275.0 ft.lbs. @ 3,000 rpm
Transmission
6-spd SelectShift w/OD
Fuel Economy City
22.0 mpg
Fuel Economy Hwy
28.0 mpg
Bumper to Bumper Months/Miles
36/36,000
$27,165
$29,335Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.