Required: 1.Complete the above tables by formating the casing Excel to calculate the ending inventory using the three cost inventory methods 315 2. Calculate the cost of goods sold med ending inventory under the the inventory methods and record in a clearly labeled table 3/15 3. Explain the impact of ending inventory and cost goods sold on the balance sheet and the income swement under the three inventory methods. 6/15 4. Explain LIFO in terms of what is allowed under US GAAP VS IFRS 3/15