345879 The any reported the following January purchases and sales data for its only prauct. The...

Transcribed Image Text:

345879 The any reported the following January purchases and sales data for its only prauct. The company uses a perpetual inventory system. REQUIRED: Determine the cost assigned to ending inventory and to cost of goods sold using FIFO. Each yellow cell must include a formula using cell references, EVEN IF THE FORMULA RESULT IS ZERO. Units Cost per Total Units Selling purchase unit Cost of Sold Price per Total Sales d 6 Date Purchase unit 10 Jan. 1 Beginning. 400: $10 $4,000 11 Sales 320 $30 $9,600 12 Purchase 600 12 7,200 13 Sales 480 14,400 14 Purchase 650: 14 9,100 15 Sales 590 17,700 16 Totals 1.650 $20,300 1.390; $41,700 17 18 19 Cost of Goods Sold - Perpetual FIFO: Units Sold @ Cost per unit Cost of 20 222222 Goods Sold Calculate cost of goods sold for the January 11 sale of 320 units. 320 units@ $10 per unit = $3,200 24 Calculate cost of goods sold for the January 17 sale of 480 units. units @ $10 per unit = units @ per unit = Total Cost of Goods Sold for January - 1,390 units Ending Inventory - Perpetual FIFO: 35 42 43 44 Units in Ending Inventor Total Ending Inventory for January - 260 units Cost per unit Inventor Balance 345879 The any reported the following January purchases and sales data for its only prauct. The company uses a perpetual inventory system. REQUIRED: Determine the cost assigned to ending inventory and to cost of goods sold using FIFO. Each yellow cell must include a formula using cell references, EVEN IF THE FORMULA RESULT IS ZERO. Units Cost per Total Units Selling purchase unit Cost of Sold Price per Total Sales d 6 Date Purchase unit 10 Jan. 1 Beginning. 400: $10 $4,000 11 Sales 320 $30 $9,600 12 Purchase 600 12 7,200 13 Sales 480 14,400 14 Purchase 650: 14 9,100 15 Sales 590 17,700 16 Totals 1.650 $20,300 1.390; $41,700 17 18 19 Cost of Goods Sold - Perpetual FIFO: Units Sold @ Cost per unit Cost of 20 222222 Goods Sold Calculate cost of goods sold for the January 11 sale of 320 units. 320 units@ $10 per unit = $3,200 24 Calculate cost of goods sold for the January 17 sale of 480 units. units @ $10 per unit = units @ per unit = Total Cost of Goods Sold for January - 1,390 units Ending Inventory - Perpetual FIFO: 35 42 43 44 Units in Ending Inventor Total Ending Inventory for January - 260 units Cost per unit Inventor Balance