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 will use Excel's "What..If Analysis," Data Tables, Goal Seek, Solver capabilities and other features to answer questions. The problems will not tell you which Excel feature to use and how to use it. You are supposed to apply most of what was provided in the Excel Demo Instructions using demo data sets. The submissions must be uploaded via the Canvas link. Instructions: Download the Excel file ExcelDSSDataxdsx from the course web site on the Canvas and save It on your local system as your Ninemet username directy In the web browsez After saving the file, fill in your name, thisjclass number/section, and submission date on the cover-page. Then open a Word document, write your full name at the top of the document, and save the document as your Ninernet username. As you work on the problems, you will be required to provide your answers on the Word document. Make sure you clearly number each answer so the grader knows what question you are answering in the Word document. Also, ensure that your analysis work is clearly shown in the Excel file in the proper tab and labeled as well as copied over to Word document in support of the answer. Answers in the Word documents without clear evidence of analysis in the Excel will not get any credit. Files without proper naming d answers without proper question number identification will not be given any points. 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 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? b. Which combination has the lowest total maintenance cost and what is that cost? Which department has what type of vehicle is found the most and how many? the highest number of vehicles assigned? In this department, 2. 3. What is the average price of the Ford Trucks in the Housing & Residential Life 4. Which vehicle (make/type/year) has the highest odometer reading? department? 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 will use Excel's "What..If Analysis," Data Tables, Goal Seek, Solver capabilities and other features to answer questions. The problems will not tell you which Excel feature to use and how to use it. You are supposed to apply most of what was provided in the Excel Demo Instructions using demo data sets. The submissions must be uploaded via the Canvas link. Instructions: Download the Excel file ExcelDSSDataxdsx from the course web site on the Canvas and save It on your local system as your Ninemet username directy In the web browsez After saving the file, fill in your name, thisjclass number/section, and submission date on the cover-page. Then open a Word document, write your full name at the top of the document, and save the document as your Ninernet username. As you work on the problems, you will be required to provide your answers on the Word document. Make sure you clearly number each answer so the grader knows what question you are answering in the Word document. Also, ensure that your analysis work is clearly shown in the Excel file in the proper tab and labeled as well as copied over to Word document in support of the answer. Answers in the Word documents without clear evidence of analysis in the Excel will not get any credit. Files without proper naming d answers without proper question number identification will not be given any points. 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 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? b. Which combination has the lowest total maintenance cost and what is that cost? Which department has what type of vehicle is found the most and how many? the highest number of vehicles assigned? In this department, 2. 3. What is the average price of the Ford Trucks in the Housing & Residential Life 4. Which vehicle (make/type/year) has the highest odometer reading? department