assume the following data for Keira shoes for the month of may 2020

- please show your working in computer format

Question 21 Question (8 marks) Assume the following data for Keira Shoes for the month of May 2020: Total cost $4,000 6,300 Date 1 May 2020 5 May 2020 8 May 2020 10 May 2020 15 May 2020 30 May 2020 Description Beginning balance Purchase Sales @S.P. -$120 Purchase Sales @ S.P. =$120 Purchase Units /unit cost 100 units @ $40 150 units@$42 80 units 50 units @$43 110 100 units @$44 2,150 4,400 S.P.:Selling price Required: Round up answers to the nearest cent (2 decimal places). Assume periodic inventory system for both requirements. 1. 1a. 1b. 1c. 2. If Keira Shoes uses a periodic inventory system, for each of () Average cost and (1) First-in, First-out (FIFO) methods, calculate: the ending Inventory cost, cost of sales (COS) and gross profit (GP). If the net realisable value of ending inventory per unit is $42.50, how will it change your calculations for each of the cost methods in Requirement (1). If no change indicate no change. If there is a change for the method, recalculate: the ending inventory cost, cost of sales (COS) and gross profit (GP). 2a. 2b. 2c. (4 Descaladih DLL QUIET STUDY AREA Please be considerate of your fellow students by NO food or drinks and by refraining from having noisy Students failing to comply may be asked to leave