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.

$1.$ The sales manager would like to know the total maintenance costs according to each make, type and

year of vehicles.

a$.$ Which combination of the three parameters $($i$.$e$.,$ make, type, and year$)$ has the highest total

maintenance cost and what is that cost?

b$.$ Which combination has the lowest total maintenance cost and what is that cost?

$2.$ Which department has the highest number of vehicles assigned? In this department, what type of

vehicle is found the most and how many?

$3.$ What is the average price of the Ford Trucks in the Housing & Residential Life department?

$4.$ Which vehicle $($make$/$type$/$year$)$ has the highest odometer reading?

a$.$ What is the vehicle make$/$type$/$year$?$

b$.$ What is the odometer reading?

c$.$ What department this vehicle assigned to$?$

Problem $2$

Use the worksheets Disks and Advertising Model for this problem. Disks, Inc. sells several types of

professional Frisbee disks. Mike Smith, the general manager of the company has created an Income

statement, based on the various data he has, in the worksheet named Disks. The Advertising Model

worksheet shows how many units of the disks can be sold for different levels of advertising. Using Excel

DSS capabilities, help Mike answer the following questions.

$1.$ Mike Smith wants to know how the Insurance & Maintenance $($I&M$)$ expenses for Regular disks

impacts the net income for Regular disks. The I&M expenses can vary between $$3500$ and $$5000$

$($assume step size of $$250)$ and the price per unit of Regular disks can vary between $$12$ and $$24$

$($assume step size of $$2).$ Show the net income values for Regular disks under the various combinations

of I&M expenses and price per unit as above?

a$.$ What is the net income for Regular disks when I&M expense is $$4500$ and price per unit is $$18?$

b$.$ What Excel feature did you use to answer this question?