solve in an excel sheet

Question ! On January 15, 2022, ABC Inc., sold 1400 laptops to XYZ company. Prior to this sale, ABC's perpetual inventory records for these units included the following cost layers. Purchase date 15-Dec-20 10-Jan-21 Total on hand Quantity Unit Cost Total Cost 800 $40 $32,000 2400 44 105,600 3200 $137,600 3 s Instructions NOTE: I advise you to start from part b. Go to the next page to answer the question a. prepare a separate journal entry to record cost of goods sold relating to the January 15 sale of 1400 3 laptops, assuming that ABC usus: 1. Specific identification (600 of the units sold had been purchased on December 15, and remaining 800 had been purchased on January 10). 2. Average cost 3. LIFO 3 4. FIFO NOTE: SHOW ALL THE CALCULATIONS FOR THE JOURNAL ENTRIES LIKE WE DID IN PRACTICAL EXERCISES 5 b. Complete a subsidiary ledger recod for the laptops unsing each of the four inventory valuation methods lited above. Your inventory records should show both purchases of these products, the sale on January 15, and the balance on hand at December 15, January 10 and january 15