ATV Co. began operations on March 1 and uses a perpetual inventory system. It entered into purchases and sales for March as shown in the Tableau Dashboard.

Another part of this table

Boxes are 1 through 31 and the color of the box of 31 is green

Green boxes are NO ACTIVITY, 0 UNITS and $0 each

1 is Purchases, 100 units and $50 each

5 is Purchase, 400 units and $55 each

9 is Sales, 420 units and $85 each

18 is Purchase, 120 units and $60 each

25 is Purchase, 200 units $62 each

29 is Sales, 160 units and $95 each

1. Compute the cost assigned to ending inventory using FIFO. 2. Compute the cost assigned to ending inventory using LIFO. 3. Compute the cost assigned to ending inventory using Weighted Average.

Another part of this table

Another part of this table

Another part of this table

March Monday Tuesday Sunday Wednesday Thursday Friday Saturday Legend No Purchases or Sales Purchases Sales 4 9. 00 10 11 12 13 14 15 16 22 17 18 19 20 23 25 26 28 30 21 27 24 Compute the cost assigned to ending inventory using FIFO. Perpetual FIFO: Cost of Goods Sold Goods Purchased Inventory Balance # of units Cost per unit Cost per unit Cost per unit # of units sold # of units Date Cost of Goods Sold Inventory Balance 100 @ $ March 1 50.00 100 @ 50.00 5,000.00 %D March 5 March 9 March 18 March 25 March 29 Totals Compute the cost assigned to ending inventory using LIFO. Perpetual LIFO: Goods Purchased Cost of Goods Sold Inventory Balance # of # of units Cost per unit Cost of Goods Sold Cost per unit Date Cost per unit # of units Inventory Balance units sold 100 @ 50.00 = March 1 100 @ 50.00 5,000.00 March 5 March 9 March 18 March 25 March 29 Totals Required 2 Required 3 Required 1 Compute the cost assigned to ending inventory using Weighted Average. (Round your average cost per unit to 2 decimal places.) Weighted Average Perpetual: Goods Purchased Cost of Goods Sold Inventory Balance # of # of units Cost per unit Cost per unit Date Cost per unit Cost of Goods Sold # of units Inventory Balance sold units 100 @ 50.00 = 2$ March 1 100 @ 50.00 5,000.00 March 5 Average March 9 March 18 Average Average March 25 March 29 Totals