Perpetual inventory using LIFO The following units of a particular item were available for sale during the calendar year: 4,500 units at $38 Jan. 1 Apr. 19 Inventory Sale 2,900 units June 30 Purchase 4,400 units at $41 Sept. 2 Nov. 15 Sale Purchase 5,100 units 1,900 units at $42 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. Open spreadsheet