Hilton Merchandise has several warehouses for its inventory located around the United States. Hiltons controller has imported

Question:

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?

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

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: