Provide a very detailed answer for each cell

purchase price Perpetual Inventory System-Weighted Average sale value Junits price value l units units balance price value 100141 170 5 300 41 date loperation 1 Beg. Bal 2 purchase 5 sale/40 7 sale/80 10 purchase 12 sale/440 17sale/5 20 purchase 23 sale/75 27 purchase 29 sale/30 1607 250 8 Perpetual Inventory System-FIFO sale purchase price balance value date units value units price value units price operation 1 Beg. Bal 2 purchase 5 sale/40 7 sale/80 10 purchase 12 sale/440 17 sale/5 20 purchase 23 sale/75 27 purchase 250 29 sale/30 purchase price Perpetual Inventory System-LIFO balance units price value units price value 11004 date units value operation 1 Beg. Bal 2 purchase 170 5 sale/40 7 sale/80 10 purchase 12 sale/440 17 sale/5 20 purchase 23 sale/75 27 purchase 29 sale/30 Required: 1. Complete the above tables by formatting the cells to calculate the ending inventory using the three cost inventory methods 2. Calculate the cost of goods sold and ending inventory under the three inventory methods 3. Explain the impact of ending inventory and cost goods sold on the balance sheet and the income statement under the three inventory methods. 4. What happens in a situation where a parent company and its subsidary use different inventory costing methods? 5. Which of the three cost inventory methods is banned under IFRS and explain why, in your own words? (Please refer to the specific IFRS in your answer)