Problem: CCC Company's inventory records show the following transactions for the month of August: Units Cost/unit 400 $ 3.20 Inventory, August 1 Purchaes: 8/4 8/18 8/25 Sales: 8/7 8/22 8/28 400 500 600 3.50 3.60 3.65 600 400 300 CCC Company uses the perpetual inventory method. Prepare three tables, one for FIFO, one for LIFO, and one for average cost, that shows the COGS and Ending Inventory for August. (Remember you must use formulas.) Prepare journal entries for all transactions for each method. CCC sold all of it's inventory at $7.00 per unit. Use separate tabs to organize yorr answer in a logical fashion. Label the tabs