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.

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?

Transcribed Image Text:

Item # DR-114 DT-331 JB-678 EM-904 RT-923 KG-728 JB-678 DR-114 DT-331 Date purchased 1/25/2022 12/29/2022 2/17/2022 7/3/2022 12/20/2022 4/3/2021 11/5/2022 12/30/2022 5/5/2021 Quantity 150 60 1,200 450 920 670 375 250 890 Cost $ 1,200 $ 500 $ 6,500 $ 4,170 $ 2,200 $ 2,480 $ 800 $ $ 1,000 7,500 Warehouse ID Santa Clara Kentwood Oakland Elyria Cordele Tucson Kentwood Kentwood Elyria State CA MI CA OH GA AZ MI MI OH