Integrated Excel Problem 184 (Static) A sneaker outlet has made the following wholesale purchases of new running shoes: 12 pairs at $45,18 pairs at $40, and 20 pairs at $50. An inventory taken last week indicates that 23 pairs are still in stock. Required: Use the above information to answer the following 1. What is the ending inventory purchase for 20 sneakers? 2. Calculate the ending inventory quantity for sneakers purchased at $18 a pair 3. Calculate the ending inventory amount for sneakers purchased at $18 a pair 4. Calculate the cost of this inventory by FIFO: Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect