Help with ending inventory and FIFO schedule 1 and LIFO schedule 2?

You are the vice president of finance of Sandy Alomar Corporation, a retail company that prepared two different schedules of gross margin for the first quarter ended March 31, 2017 These schedules appear below Sales Cost of Gross ($5 per unit) Goods Sold Margin $124,900 $25,100 129,400 20,600 Schedule 1 Schedule 2 $150,000 150,000 The computation of cost of goods sold in each schedule is based on the following data Cost Units per Unit Cost Total Beginning inventory, January 1 Purchase, January 10 Purchase, January 30 Purchase, February 11 Purchase, March 17 10,000 8,000 6,000 9,000 11,000 $4.00 $40,000 4.20 33,600 4.25 25,500 4.30 38,700 4.40 48,400 Jane Torville, the president of the corporation, cannot understand how two different gross margins can be computed from the same set of data. As the vice president of finance, you have explained to Ms. Torville that the two schedules are based on different assumptions concerning the flow of inventory costs, i.e., FIFO and LIFO. Schedules 1 and 2 were not necessarily prepared in this sequence of cost flow assumptions. Prepare two separate schedules computing cost of goods sold and supporting schedules showing the composition of the ending inventory under both cost flow assumptions