LIFO & Average Cost periodic inventory methods. The Rock Shop shows the following data related to an item of inventory: Inventory, January 1 Purchase, January 9 Purchase, January 19 Inventory, January 31 100 units @ $5.00 300 units @ $5.40 70 units @ $6.00 120 units Instructions (a) What value should be assigned to COGS and ending inventory using LIFO? (b) What value should be assigned to COGS and ending inventory under Average Cost? Please prepare your answers in a Microsoft Excel spreadsheet or Word Document and submit below. As an alternative, you can prepare your answers on paper and either scan your work into a PDF or take a photo of the paper and submit. Make sure to show your work! Use the editor to format your