Question: Use the worksheet Vehicles for this problem. You will help a facilities department for a university analyze their vehicle data for decision support. Answer the

Use the worksheet Vehicles for this problem. You will help a facilities department for a university analyze their vehicle data for decision support. Answer the following questions based on your analysis of the data.

The sales manager would like to know the total maintenance costs according to each make, type and year of vehicles.
1. Which combination of the three parameters (i.e., make, type, and year) has the highest total maintenance cost and what is that cost?
2. Which combination has the lowest total maintenance cost and what is that cost?
Which department has the highest number of vehicles assigned? In this department, what type of vehicle is found the most and how many?
What is the average price of the Ford Trucks in the Housing & Residential Life department?
Which vehicle (make/type/year) has the highest odometer reading?
1. What is the vehicle make/type/year?
2. What is the odometer reading?
3. What department this vehicle assigned to?

A B D G H 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 251 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 SO 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 72 ID # YEAR MAKE TYPE 87 2002 Ford Sedan 195 2004 Ford Truck 503 2003 Chevrolet Sedan 678 1995 Ford Pickup 696 2000 Dodge Van 798 2003 Ford Van 817 2004 Chevrolet Van 818 2000 Chevrolet Pickup 829 1995 Ford Pickup 834 1991 Chevrolet Van 841 1999 Ford Sedan 865 2000 GMC Van 866 2001 Ford Sedan 874 2004 Ford Van 877 1996 Chevrolet Pickup 888 1999 Ford Sedan 897 2005 Ford Truck 904 1996 Chevrolet Sedan 1016 1997 Ford Pickup 1055 2004 Ford Van 1071 1993 Ford Van 1140 2003 Ford Truck 1167 2000 Ford Truck 1172 1995 Ford Sedan 1196 1998 Chevrolet Van 1374 1995 Chevrolet Sedan 1375 1999 Ford Pickup 1415 1997 GMC Van 1445 1996 Dodge Van 1455 1998 Ford Truck 1462 1997 GMC Van 1476 2002 Dodge Pickup 1575 2000 Chevrolet Pickup 1585 1999 Ford Sedan 1599 1996 Chevrolet Van 1602 1999 GMC Van 1642 2003 Chevrolet Sedan 1643 1998 Chevrolet Truck 1648 1992 Chevrolet Van 1649 2004 Chevrolet Pickup 1675 1999 Chevrolet Pickup 1678 2003 Ford Van 1680 2003 Chevrolet Pickup 1733 2005 Ford Pickup 1735 1993 Chevrolet Sedan 1776 1987 Chevrolet Sedan 1861 2003 Chevrolet Van 1878 1995 Chevrolet Van 1949 2004 Chevrolet Van 2020 2003 Ford Van 2021 1999 Dodge Van 2063 2001 Ford Sedan 207 2004 Ford Van 2084 1997 GMC Van 2112 1986 Ford Sedan 2124 2002 Ford Van 2126 2005 Ford Truck 2128 1994 Ford Van 2131 2001 Chevrolet Pickup 2132 1998 Chevrolet Pickup 2139 2004 Dodge Van 2141 2005 Ford Van 2142 2005 GMC Truck 2153 2001 Chevrolet Van 2166 1998 Chevrolet Van 2167 2003 Ford Truck 2353 2001 GMC Pickup 2364 1990 Chevrolet Sedan 2388 2001 Dodge Van 2412 2000 Ford Van 2489 2003 Chevrolet Van E F ODOMETER DEPARTMENT ASSIGNED 37780 Police & Security 19870 Telecomm 8900 Police & Security 73419 Housing & Residential Life 43907 Police & Security 24575 Housing & Residential Life 16896 Housing & Residential Life 37786 Housing & Residential Life 32765 Housing & Residential Life 138456 Property 59378 Printing Services 42313 Housing & Residential Life 49973 Police & Security 43678 Telecomm 50580 Property 62743 Police & Security 12703 Housing & Residential Life 53383 Police & Security 52728 Housing & Residential Life 3500 Dining Services 93484 Printing Services 29781 Property 39292 Housing & Residential Life 78740 Police & Security 53560 Housing & Residential Life 137534 Police & Security 45608 Housing & Residential Life 89006 Athletics 56788 Telecomm 76681 Housing & Residential Life 82091 Athletics 47222 Property 43896 Property 65404 Police & Security 52672 Printing Services 35860 Dining Services 44108 Property 43912 Housing & Residential Life 101712 Housing & Residential Life 2250 Printing Services 54741 Property 25126 Housing & Residential Life 23915 Housing & Residential Life 5272 Police & Security 110863 Property 81802 Housing & Residential Life 8993 Police & Security 56047 Housing & Residential Life 34474 Dining Services 22589 Housing & Residential Life 59800 Dining Services 62611 Police & Security 18755 Property 74309 Athletics 103123 Housing & Residential Life 36838 Printing Services 3670 Housing & Residential Life 99880 Athletics 31394 Housing & Residential Life 77104 Housing & Residential Life 10650 Property 5721 Housing & Residential Life 2800 Telecomm 32315 Telecomm 43038 Housing & Residential Life 14678 Dining Services 58570 Dining Services 92419 Athletics 33321 Housing & Residential Life 35497 Housing & Residential Life 26493 Property $ S $ S $ $ $ S $ $ $ S $ $ $ S $ $ $ $ $ S $ $ $ $ $ S $ $ $ S $ $ $ S $ $ $ $ $ $ $ $ $ $ $ S $ $ $ S $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ PRICE MAINTENANCE 20,888 S 1,933 18,682 $ 1,331 20,904 $ 939 11,866 $ 507 15,844 s 566 19,846 $ 168 20,824 $ 705 13,783 $ 1,594 5,000 $ 1,370 11,449 $ 1,235 20,315 $ 473 12,500 $ 30 15,090 $ 567 21,580 $ 28 14,130 $ 279 22,413 $ 112 22,724 $ 1,591 16,539 $ 1,641 14,757 $ 2,000 22,438 $ 695 12,149 $ 378 19,634 $ 575 15,366 S 3,491 15,871 $ 724 12,493 $ 1,299 20,453 $ 2,235 15,866 $ 72 16,748 $ 755 10,105 $ 345 12,850 $ 81 20,882 $ 980 11,232 $ 2,000 12,643 $ 603 22,674 $ 490 15,773 $ 2,933 16,356 $ 1,826 11,136 $ 2,000 7,200 $ 499 14,929 S 664 20.680 $ 370 9,839 $ 160 12,957 s 675 16,763 $ 1.775 15,914 $ 1,839 11,041 $ 964 14,993 $ 1,820 15,592 $ 1,871 15,930 $ 1,383 18,712 $ 1,025 22,045 $ 379 14,965 $ 1,948 18,872 $ 751 20,336 $ 402 14,187 $ 559 12,007 $ 1,350 11,518 S 2,000 9,471 $ 105 15,197 S 1,975 15.613 S 450 14,019 $ 594 11,985 $ 1,245 22,546 S 1,118 13,410 $ 257 14,109 $ 732 17,022 S 1,200 21,743 202 14,127 $ 1,255 11,630 $ 2,257 15,485 $ 118 9,025 $ 191 14,347 $ 1,002

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

S %20Assignment.pdf NFO 3130 Excel Decision Support System (DSS) Assignment The objective of this assignment is to introduce you to Data Analysis Tools of Microsoft Excel. In this assignment, you...

Problem 1 Use the worksheet Vehicles for this problem. You will help a facilities department for a university analyze their vehicle data for decision support. Answer the following questions based on...

Use the worksheet Vehicles for this problem. You will help a facilities department for a university analyze their vehicle data for decision support. Answer the following questions based on your...

Problem 1 Use the worksheet Vehicles for this problem. You will help a facilities department analyze their vehicle data for decision support. Answer the following questions based on your analysis of...

Information Systems at McDonalds McDonalds Corporation (McDonalds), a US-based global hamburger and fast food restaurant chain, had installed several Information Systems to for the operational...

Read the passage about Nissan and answer following questions based on it In 1999, Nissan was in a state of serious decline and had lost money in all but one of the previous eight years. Only Renaults...

Case Uttarakhand was formed on the 9th November 2000 as the 27th State of India, when it was carved out of Northern Uttar Pradesh. Located at the foothills of the Himalayan Mountain ranges, it is...

You have been hired as a consultant to help Ford Motor Company return to its glory days, when either Henry Ford or Alan Mulally ran the company. In doing so, you must produce a short report to Jim...

the word limit should be 800 to 1000 words so please give the answers as requirement. In summary, it's time to understand your parcel characteristics as well as how the carriers will view your...

Can social networking platforms, like FB, create money? If they can, should they be regulated? How can they be regulated?

Multiple factor responsible for the backwardness of agriculture in Pakistan? Give suggestion for their improvement in the light of government polices?

2. Open the VB2015\Chap08\Color Solution\Color Solution (Color Solution.sln) file. The btnDisplay_Click procedure should display the color of the item whose item number is entered by the user. All...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...