date Loperation units purchase sale Beg. Bal price value units Iprice Ivalue price value balance 2 purchase 150 120 sale/40 7 sale/80 10 purchase 12 sale/240 310 17 sale/5 20 purchase 23 sale/75 170 27 purchase 260 29 sale/30 Perpetualinventory System date operation units purchase sale price value units price value units value balance 1 Ben Bal alpurchase 120 150 El salako no purchase 12 salon40 17 5 195 20 purchase date operation Inits purchase Perpetual Inventory System sale 1Ben Bal price value Inits price value balance purchase 150 10 purchase 310 12 salaR40 17 sale5 23 sala 75 29 sale 30 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 Marks 2. Calculate the costof goods sold and ending inventory under the three inventory meit d record in a clearly labeled table 3/10. 3. Explain the impact of ending inventory and costgoods sold on the balance sheet and the income statementunder the three inventory methods. 4/10 This assignmentis worth 10% ofyour course assessmentand should be completed and submitled to me via email no later than 4 pmon June 25, from your PMU accountnotyour 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 assignmentwrite: ACCT 3312 Excel Assignment