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

Hands-on 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: Assignment1-data-2.xlsx.Your 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 4 worksheets:1. Data (original plus added column: Delivery days)2. Delivery Time Table: Vendor No., Name, Average delivery time)3. AP Terms (Table: Vendor No., Name, Accounts payable terms)4. 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!