Please check my work. Thank you.

Part A

Use theACT350_CTTemplate_Mod5_option1.xlsxfile (in the module folder) to compute the cost of goods sold under the following situations:

1. Periodic system, FIFO cost flow
2. Perpetual system, FIFO cost flow
3. Periodic system, LIFO cost flow
4. Perpetual system, LIFO cost flow
5. Periodic system, weighted-average cost flow
6. Perpetual system, moving-average cost flow

Data given Units Unit Cost a) Periodic FIFO Units Unit cost Cost 1-Jan Beginning inventory 4,190 $20 2-Mar Sale 4,190 $20 $83,800 12-Feb Purchase 4,630 $25 31-May Sale 4,630 $115,750 2-Mar Sale 3,640 $38 8,820 $199,550 18-Apr Purchase 5,950 $28 31-May Sale 5,180 $40 a) Perpetual FIFO Units Unit cost Cost 2-Mar Sale 4,190 $20 $83,800 Total Units Sold 8,820 31-May sale 4.630 $25 $115,750 8,820 $199,550 c) Periodic LIFO Units Unit cost Cost 2-Mar Sale 3,640 $25 $91,000 31-May Sale 5,180 $28 $145,040 8,820 $236,040Perpetual LIFO Purchases Sales (Cost of Goods Sold) Balance (Ending Inventory) Units Unit cost Cost Units Unit cost Cost Units Unit cost Cost 1-Jan Beg Inv 4190 $ 20 $ 83,800 4,190 $20 $83,800 12-Feb Purchase 4,630 $ 25 $ 115,750 990 $25 $24,750 2-Mar Sale 3,640 5 25 $91,000 18-Apr Purchase 5,950 $ 28 $ 166,600 770 $28 $21,560 31-May Sale 5,180 S 28 $ 145,040 Totals 14,770 $ 366,150 8,820 $ 236,040 5,950 $ 130,110Periodic weighted average Total Units Sold 8.820 Units Unit cost Cost Beginning Inventory 4,190 $20 $83,800 Purchases 4,630 $25 $115,750 Purchases 5.950 $28 $166,600 14,770 $366,150 Weighted Average/Per Unit $24.79 Cost of Goods Sold $218,649f) Perpetual Moving Average Purchases Sales (Cost of Goods Sold) Balance (Ending Inventory) Units Unit cost Cost Units Unit cost Cost Units Unit cost Cost Weighted Average Cost per Unit 1-Jan Beg Inv 4,190 $20 $ 83,800 $20.00 12-Feb Purchase 4,630 $25 $ 115,750 $22.62 2-Mar Sale 3,640 $22.62 $82,354 5,180 $22.62 $117,172 $22.62 18-Apr Purchase 5,950 $28 $ 166,600 $25.50 31-May Sale 5,180 $25.50 $132,090 5,950 $25.50 $151,725 $25.50 Totals 14,770 $ 366,150 8,820 $ 214,444 5,950 $ 268,897