Please create a spreadsheet for the following question. You will need to save the spreadsheet on your computer and then upload/attach the file to this question. 1. During June, the following changes in inventory item 27 took place: ( 30 points) June 1 Balance 1,400 units @ $24 14 Purchased 800 units @ $36 24 Purchased 700 units @ $30 8 Sold 400 units @ $50 10 Sold 1,000 units @ $40 29 Sold 500 units @ $44 Perpetual inventories are maintained. Instructions What is the cost of the ending inventory for item 27 under the following methods? (Show calculations.) (a) FIFO (b) LIFO