Please solve using Excel and show calculations:

Problem 3 ABC Company uses a LIFO cost flow assumption for it inventory of tires and at the start of 2020 had the following beginning inventory layers: Year of LIFO Layer 1995 2001 2011 #Units 100 56 75 Cost per Unit $35 $43 $65 / During 2020 ABC was not able to purchase as many tires as it sold resulting in the need to include in cost of goods sold the cost of 95 units of its beginning inventory. The price of tires purchased in 2020 held constant throughout the year at $78 per tire. 1. How much would ABC report as LIFO liquidation in its 2020 financial statements? 2. As a financial analyst assigned to produce a detailed report on the results of operations for ABC in 2020, knowledge of the liquidation would results in you adjusting which ratio(s) in your report? Explain precisely how you would adjust the ratio(s) and the impact on the ratio(s) of your adjustment