Metro Mart Co. sells one product. Presented below is information for January 2022 for Metro. Date 1/1/22 Beginning Inventory 100 units at $5 each 1/11/22 Purchase 200 units at $6 each 1/13/22 Sales 250 units at $10 each 1/20/22 Purchase 150 units at $7 each 1/27/22 Sales 75 units at $13 each Using the Excel, compute the following costs: *Show your computations. If not, no credit. Costs of goods sold and ending inventory under weighted average cost (periodic). Costs of goods sold and ending inventory under LIFO (periodic) Costs of goods sold and ending inventory under FIFO (periodic) Costs of goods sold and ending inventory under moving average cost (perpetual). Costs of goods sold and ending inventory under LIFO (perpetual). Costs of goods sold and ending inventory under FIFO (perpetual)