PLEASE SHOW ALL THE WORKINGS STEP BY STEP AND IF POSSIBLE DO IT ON EXCEL. THANKS

4.15 Allocating cost (weighted average formula), reporting gross profit and applying the NRV rule ** Nanning Ltd wholesales bicycles. It uses the perpetual method and allocates cost to inventories using the LO4, 5, 6, 7 moving weighted average formula. The company's reporting date is 31 March. At 1 March 2024, inventories on hand consisted of 400 bicycles at $92 each and 54 bicycles at $96 each. During the month ended 31 March 2024, the following inventories transactions took place (all purchase and sales transactions are on credit). March 1 Sold 200 bicycles for $150 each. Five bicycles were returned by a customer. They had originally cost $92 each and were sold for $150 each. Purchased 60 bicycles at $94 each. Purchased 80 bicycles at $98 each. 15 Sold 62 bicycles for $165 each. 17 Returned one damaged bicycle to the supplier. This bicycle had been purchased on 9 March. 22 Sold 74 bicycles for $155 each. Purchased 82 bicycles at $104 each. Two bicycles, sold on 22 March, were returned by a customer. The bicycles were badly damaged so it was decided to write them off. They had originally cost $94 each. Required Calculate the cost of inventories on hand at 31 March 2024 and the cost of sales for the month of March. (Round the average unit cost to the nearest cent, and round the total cost amounts to the nearest dollar.) 2. Prepare the inventories general ledger control account (in T-format) as it would appear at 31 March 2024. 3. Calculate the gross profit on sales for the month of March 2024