i need answer with only 4 columns:

date / purchase / cost of good sold / balance.

with details and calculations please, its okay if on paper

for all the three questions (fifo,lifo,avrg)

Question #2 Dockers Inc. begin business on January 1,20X1. Information on its inventory purchases and sales during 20x1 follows: Total January 1 March 10 April 15 September 11 November 12 December 1 December 29 Units Available for Sale Units 8,000 10,000 12,000 10,000 6,000 7,500 6,500 60,000 Inventory Purchases Cost per Unit 5.00 5.10 5.30 5.55 5.75 5.85 6.10 328,125 Total March 3 September 2 December 5 Units Unsold Units 6,000 24,000 10,000 40,000 Inventory Sales Price per Unit 9.00 9.50 10.00 382,000 Required: a) Determine the cost of ending inventory and cost of goods sold using the perpetual inventory system under each of the following inventory costing methods: i) First in, first-out ii) Last in, first-out iii) Average inventory valuation