please answer full question in detail.

CHAPTER 6 XYZ Company buys and sells cabinets and drawers for the last 5 years at their Michigan outlet. XYZ Company the furniture from the wholesaler and then sells the furniture to the customers from their retail outlet at Michigan The following information is for XYZ Company for the month ended July 30 2017. Date July 1 July 8 July 21 July 27 Description Quantity Opening Inventory 50 Purchase 230 Purchase 80 Purchase 40 Unit Cost 100 76 110 100 Sales 350 units XYZ Company uses the periodic method for inventory. Required: (1) Calculate Ending Inventory and Cost of Goods sold, under each of the following methods. (1) LIFO. (2) FIFO. (3) Average cost. Prove the amount allocated to cost of goods sold under the LIFO and FIFO method (2) From your calculations, analyze which method results in (1) The highest ending inventory, and (2) The highest cost of goods sold