Question: Hands - on MIS Project: Use a spreadsheet to select suppliersSoftware skills: spreadsheet date functions: data sorting, data filtering, AVERAGE functions. Business skills: Analyzing supplier
Handson MIS Project: Use a spreadsheet to select suppliersSoftware skills: spreadsheet date functions: data sorting, data filtering, AVERAGE functions. Business skills: Analyzing supplier performance and pricingIn this exercise, you will learn how to use spreadsheet software to improve management decisions about selecting suppliers. You will filter transactional data about suppliers based on several criteria to select the best suppliers for your company. The transactional data are given in the file: AssignmentdataxlsxYour job is to turn the data into meaningful information. In particular, your boss needs to compare the suppliers by their delivery time, AP terms, and item cost so that they can choose the better suppliers for future orders. Deliverable: A solution Excel spreadsheet that includes worksheets: Data original plus added column: Delivery days Delivery Time Table: Vendor No Name, Average delivery time AP Terms Table: Vendor No Name, Accounts payable terms Supplier item cost Table: Item Description, Cost, Vendor Name, filtered by item description
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
