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 Ending