Please give me the answer in excel format. Screenshot of an excel answer is also fine.

5. Exercise Five: You are hired as a business consultant by Chelsea Hardware Stores to help them with their inventory control shown below. As part of your project, you need to solve the following problems, (a) if the company sells 7,750 units, find the Cost of Goods Sold under LIFO, (b) if the company sells 7,750 units, find the Cost of Goods Sold under FIFO, Date Total Cost Chelsea Hardware Stores Pool of Costs - Cost of Goods Available for Sale Explanation Units Unit Cost Beginning Inventory 2500 $ 10.00 Purchase 2000 $ 11.00 Purchase 3500 $ 12.00 Purchase 4200 $ 13.00 6/1 7/15 8/24 10/27 $ 25,000.00 $ 22,000.00 $ 42,000.00 $ 54,600.00