Required: 1.Complete the above tables by formatting the cells using Excel to calculate the ending inventory using the three cost inventory methods 3/10 2. Calculate the cost of goods sold and ending inventory under the three inventory methods and record in a clearly labeled table 3/10. 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/10 This assignment is worth 10% of your course assessment and should be completed and submitted to me via email no later than 4 pm on June 25, from your PMU account not your private email. Make sure you have your name and ID on your assignment + class code. (ACCT 3312). In the subject line of your email when you send your completed assignment write: ACCT 3312 Excel Assignment date operation 1 Beg. Bal 2 purchase 5 sale/40 7 sale/80 10 purchase 12 sale/240 17 sale/5 20 purchase 23 sale/75 27 purchase 29 sale/30 purchase price units value 150 6 310 4 170 7 260 8 Perpetual Inventory System-Weighted Average sale units price value units price 120 balance value 4 date operation 1 Beg. Bal 2 purchase purchase price units value 150 6 310 4 170 7 260 8 7 sale/80 12 sale/240 17 sale/5 20 purchase 23 sale/75 27 purchase 29 sale/30 balance price 120 5 sale/40 10 purchase units Perpetual Inventory System-FIFO sale price value units value 4 date operation 1 Beg. Bal 2 purchase purchase price units value 150 6 310 4 170 7 260 8 7 sale/80 12 sale/240 17 sale/5 20 purchase 23 sale/75 27 purchase 29 sale/30 balance price 120 5 sale/40 10 purchase units Perpetual Inventory System-LIFO sale price value units value 4