hello I need help with solving this probem the second part I have attached a excel file, please put down solution step by step so I kno how you got to the asnwer in the excel thank you

*Problem 6-5A (Part Level Submission) You are provided with the following Date June June June June June June June June *(a1) Correct ansYour answer is correct. Calculate cost per unit. (Round answ Weighted-average cost Attempts: 1 of 3 used *(a2) Calculate ending inventory, cost of g The ending inventory The cost of goods sold Gross profit Level Submission) ovided with the following information for Najera Inc. for the month ended June 30, 2017. Najera uses the periodic method for inventor Description 1 4 10 11 18 18 25 28 Quantity Beginning inventory Purchase Sale Sale return Purchase Purchase return Sale Purchase 40 136 115 12 58 9 66 35 Unit Cost or Selling Price $40 44 69 69 46 46 74 50 Your answer is correct. cost per unit. (Round answer to 2 decimal places, e.g. 5.25.) $ Entry field with correct answer 44.57 ending inventory, cost of goods sold, gross profit under each of the following methods. (1) LIFO. (2) FIFO. (3) Average-cost. (Round aver LIFO $ $ $ FIFO $ $ $ AVERAGE-COST $ $ $ riodic method for inventory. Average-cost. (Round average-cost method answers to 2 decimal places, e.g. 1,250.25 and other answers to 0 decimal places, e.g. 1,250 decimal places, e.g. 1,250. Use weighted-average unit cost rounded to 2 decimal places for computations.)