Please answer on excel and show all work. I will leave positive review.

Question 3 (9 marks - 18 minutes) Prestige Inc. sells a product called Jewel. The table shown provides the purchases and sales of the Jewel product during the month of April. Prestige uses a perpetual inventory system Purchases Sales Units Unit Cost Units Selling Price Unit Mar 1 Beginning inventory 450 $65 3 Purchase 120 60 4 Sales 188 10 Purchase 75 67 16 Sales 126 19 Sales 95 130 25 Sales 45 128 30 Purchase 340 71 $90 290 Required - 2. Applying FIFO methodology, calculate the total cost of purchases, cost of goods sold, and cost of ending inventory for the month of April. Please show your calculations (4 marks) b. Applying the average cost methodology, calculate the total cost of purchases, cost of goods sold, and cost of ending inventory for the month of April. Please show your calculations and round your results to two decimal points for presentation purposes (3 marks) c. Calculate the gross margin for each method (in proper form). Please compare each and provide a proper interpretation as to which is appropriate and advice you'd offer. (2 marks) (round any calculation to nearest 2 decimal places)