LIFO Inventory Value Calculator Cost of Goods Sold Units Sold Units Remaining Inventory Value Purchase Date 09/27/2019 09/28/2019 09/30/2019 10/02/2019 10/04/2019 10/05/2019 10/07/2019 10/12/2019 Units Purchased 500 675 600 550 725 500 525 650 Price per Unit $25.00 $25.00 $25.25 $25.50 $25.50 $25.85 $25.85 $26.00 Cost of Goods Purchased $12,500.00 $16,875.00 $15,150.00 $14,025.00 $18,487.50 $12,925.00 $13,571.25 $16,900.00 Total 4,725 $120,433.75 $0.00 $0.00 Instructions: Begin by completing Worksheet 1 and 2 (do not forget there are 2 worksheets in the Excel file!). You are to assume the firm sells 4,200 units between 9/27/2019 and 10/12/2019. Assume this is a new firm and the inventory balance was zero prior to 9/27/2019. Use the information from the TOTAL line item (row 17) to answer the following three questions