Please help, also explain in detail how you got the values for the calculations like the formulas and how you got the numbers for the formulas. Thanks a lot. If you choose to make a table please explain what you did in the table step by step and how you got the values. Thanks

Problem 6-6A Alternative cost flows-perpetual LO2, 3 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 Units Unit Cost 17 22. Sales Units Unit Price 22 $ 57 27 24 Date Oct. 3 Oct. 6 Oct. 12 Oct. 19 Oct. 23 Oct. 30 Oct. 31 27 $ 57 37 26 32 $ 57 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 a FIFO b Moving weighted average 2. Using your calculations in Part 1, complete the following table: nearest dollar.) FIFO Moving Weighted Average Sales Cost of goods sold 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 %