Please tell me what data i need to enter to complete these two excel assignments
ID: 2563785 • Letter: P
Question
Please tell me what data i need to enter to complete these two excel assignments.
Ferris Company began 2016 with 4,000 units of its principal product The cost of each unit is $6 Merchandise transactions for the month of January 2016 are as follows Purchases Date of Purchase Units Unit Cost Total Cost Jan 10 Jan. 18 3,000 $7S21,000 4.000 32,000 Totals 7,000 $53,000 'Includes purchase price and cost of freight Sales Jan 5 Jan. 12 Jan 20 Date of SaleUnits 2.000 1,000 3,000 Total 6.000 5,000 units were on hand at the end of the month Required Galculate January's ending inventory and cost of goods sold for the month using each of the following afternatives oGoods Available for Sate I Costof Goods Sold Perodic RFO Endieg tnventory Petedlc FIrO # of units 1 cast er 1 EndingExplanation / Answer
Perpectual LIFO Cost of Goods Available for Sale Cost of Goods Sold Jan-5 Cost of Goods Sold Jan-12 Cost of Goods Sold Jan-20 Ending Inventory Units Cost per Unit Cost of Goods Available for Sale Units Cost per Unit Cost of Goods Sold Units Cost per Unit Cost of Goods Sold Units Cost per Unit Cost of Goods Sold Units Cost per Unit Ending Inventory Beginning Inventory 4000 $ 6.00 $ 24,000 2000 $ 6.00 $ 12,000 2000 $ 6.00 $ 12,000 Purchases Jan-10 3000 $ 7.00 $ 21,000 As on Jan-05, This Purchase is not happened 1000 $ 7.00 $ 7,000 2000 $ 7.00 $ 14,000 Jan-18 4000 $ 8.00 $ 32,000 As on Jan-05, This Purchase is not happened As on Jan-12, This Purchase is not happened 3000 $ 8.00 $ 24,000 1000 $ 8.00 $ 8,000 Total 11000 $ 77,000 2000 $ 12,000 1000 $ 7,000 3000 $ 24,000 5000 $ 34,000 Perpectual Average Inventory on Hand Cost of Goods Sold Units Cost per Unit Total Units Cost per Unit Total Beginning Inventory 4000 $ 6.0000 $ 24,000 Sale on January-05 (2000) $ 6.0000 $ (12,000) 2000 $ 6.0000 $ 12,000 Subtotal Average Cost 2000 $ 6.0000 $ 12,000 Purchase on January-10 3000 $ 7.0000 $ 21,000 Subtotal Average Cost 5000 $ 6.6000 $ 33,000 Sale on January-12 (1000) $ 6.6000 $ (6,600) 1000 $ 6.6000 $ 6,600 Subtotal Average Cost 4000 $ 6.6000 $ 26,400 Purchase on January-18 4,000 $ 8.0000 $ 32,000 Subtotal Average Cost 8000 $ 7.3000 $ 58,400 Sale on January-20 (3000) $ 7.3000 $ (21,900) 3000 $ 7.3000 $ 21,900 Ending Inventory 5,000 $ 7.3000 $ 36,500 6000 $ 40,500 Have filled all the columns with correct data and as of the visibility of your question, have done all the requiremnts.