The Qwetzel Company adopted the dollar-value LIFO method for inventory valuation at the beginning of 2009. The following information about the inventory at the end of each year is available from the company records: Using Excel, produce a schedule that calculates ending inventory at dollar-value LIFO at the end of each year. Make your spreadsheet as plain or fancy as you like, but make sure it does all the math and get the answers right