If is possible with formulas, thank you very much

2. Problem Two: John Coltrane Stores, ask you to help them with their inventory control shown below. Management wants you to solve the following problems, (a) if the company sells 6,271 units, find the cost of Goods Sold under LIFO, (b) if the company sells the 12,264 units, find the cost of Goods Sold under FIFO. Date 4/1 9/15 11/24 12/27 John Coltrane Convenience Store Pool of Costs Cost of Goods Available for Sale Explanation Units Unit Cost Total Cost Beginning inventory 1500 S 12.50 $ 18,750.00 Purchase 3500 S 16.78 $ 58,730.00 Purchase 4255 S 14.85 S 63.186.75 Purchase 5289 S 19.99 $ 105,727.11 HW17 pd Type here to search