Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started