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 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? a. Which combination has the lowest total maintenance cost and what is that cost? b. 2. 3. 4. Which department has the highest number of vehicles assigned? In this department, what type of vehicle is found 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? a. b. c. What is the vehicle make/type/year? What is the odometer reading? What department this vehicle assigned to