McKay Merchandise has several warehouses for its inventory located around the United States. McKays controller has imported

Question:

McKay Merchandise has several warehouses for its inventory located around the United States. McKay’s controller has imported its inventory records into Excel. The following is a sample of the inventory records in that Excel file. Access the full data set online in the MyLab Accounting exercise.


image


Create a table in the Excel file provided in MyLab Accounting. Sort and filter that table to answer the following questions. Add dynamic column subtotals where needed.1. What items are in the Elyria warehouse, listed in Item # order? What item is listed first? What item is listed last?2. A manager needs to know which warehouses have Item # DR-114 in stock. List the warehouses in alphabetic order. What is the first warehouse in the list that has Item # DR-114 in stock? What is the third warehouse that has Item # DR-114 in stock? How many # DR-114 items are in stock? What is the total cost of the # DR-114 items in stock?3. Which warehouses have inventory items with a cost of more than $3,000? List the warehouses in alphabetic order. What is the first warehouse listed? What is the last warehouse listed?4. What inventory items in warehouses in California have a cost greater than $5,000? The inventory items should be listed in alphabetic order. What is the first inventory item listed? What is the fifth inventory item listed?5. What are the oldest three inventory items in the warehouses located in Ohio? What is the total cost of inventory in Ohio warehouses that was purchased in 2021?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Managerial Accounting

ISBN: 9780137858514

7th Edition

Authors: Karen W. Braun, Wendy M. Tietz

Question Posted: