Please help, i need step by step explanation how you got the values for calculations. Don't make a table, it can be confusing and if you do just tell me where you got the numbers from step by step and in detail. Thanks a lot.

Case Defence sells smartphone cases and uses the perpetual inventory system. The following is information on the purchases and sales of Defender Box cases. On October 1, Case Defence had 27 units with a unit cost of $21.

		Purchases			Sales
Date		Units	Unit Cost		Units	Unit Price
Oct.	3	17	22
Oct.	6				22	$	57
Oct.	12	27	24
Oct.	19				27	$	57
Oct.	23	37	26
Oct.	30				32	$	57
Oct.	31	22	27

Required: 1. Calculate the dollar value of cost of goods sold and ending inventory for the month of October using the following methods. (Do not round intermediate calculations. Round weighted average all unit costs to two decimal places and round all other numbers to the nearest dollar.) Ending Inventory Cost of Goods Sold . FIFO b. Moving weighted average 2. Using your calculations in Part 1, complete the following table: (Do not round intermediate calculations. Round the final answers to nearest dollar.) FIFO Moving Weighted Average Sales Cost of goods sold Opportunity Gross profit 3-a. Which method produce the higher gross profit? O FIFO O Moving weighted average 3-b. Which method produce the higher ending inventory balance? O FIFO O Moving weighted average 4. Calculate the gross profit percentage for FIFO and Moving weighted average for the month of October. (Round the final answers to the nearest whole number.) Gross Profit percentage 1 FIFO % 2. Moving weighted average %