Hilton Merchandise has several warehouses for its inventory located around the United States. Hilton’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 Rocky River 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 # GR-113 in stock. List the warehouses in alphabetic order. What is the first warehouse in the list that has Item # GR-113 in stock? What is the third warehouse that has Item # GR-113 in stock? How many # GR-113 items are in stock? What is the total cost of the # GR-113 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 2018?

Transcribed Image Text:

Item # GR-113 DT-331 JB-678 EM-904 RT-923 KG-728 JB-678 GR-113 DT-331 Date purchased 1/25/2019 12/29/2019 2/17/2019 7/3/2019 12/20/2019 4/3/2018 11/5/2019 12/30/2019 5/5/2018 Quantity 155 50 1,000 375 810 570 275 150 900 Cost $ 1,100 $ 100 555 $ 555 5,500 3,130 3,200 2,150 900 700 1,900 Warehouse ID Oakland Forest Hills Santa Clara Rocky River Cordele Phoenix Forest Hills Forest Hills Rocky River State CA MI CA OH GA AZ MI MI OH