IMPROVING DECISION MAKING: USE A SPREADSHEET TO SELECT SUPPLIERS Learning objectives In this project you will learn two different skills Technical skills related to using spreadsheet date functions, data filtering, DAVERAGE function. 0 Analytical skills related to analyzing supplier performance and pricing and selecting the best suppliers. Case assignment You will start with raw transactional data about suppliers organized as a large spreadsheet list. You will use the spreadsheet software to filter the data based on several different criteria to select the best suppliers for your company. You run a company that manufactures aircraft components. You have many competitors who are trying to offer lower prices and better service to customers, and you are trying to determine whether you can benefit from better supply chain management. Refer to the spreadsheet file " 605 Data Project Sheet" that contains a list of all of the items that your firm has ordered from its suppliers during the past three months. The fields in the spreadsheet file include vendor name, vendor identification number, purchaser's order number, item identification number and item description (for each item ordered from the vendor), cost per item, number of units of the item ordered (quantity), total cost of each order, vendor's accounts payable terms, order date, and actual arrival date [or each order]. Project Tasks to be executed 1. Apply the selected criteria by using your spreadsheet software to prepare reports to support your recommendations. Show how you use the date functions, data filtering, and DAVERAGE function. Some criteria to consider for identifying preferred suppliers include the supplier's track record for on-time deliveries, suppliers offering the best accounts payable terms, and suppliers offering lower pricing when the same item can be provided by multiple suppliers. You can come up with other criteria as well... [5points]. 2. Analyze the criteria that you would use to decide which would be your best supplier. Selecting an alternative requires to decide which criteria will you use to select among alternatives. [5 points]. [Should be done on a word document] 3. Prepare recommendations of how you can use the data in this spreadsheet database to improve your decisions about selecting suppliers. In other words what logic would you use to select the best supplier [5 points]