PLEASE FORMAT RESPONSE WITH SEPERATE COGS AND ENDING INVENORY. SHOW FIFO COGS and Ending Inventroy, LIFO COGS and Ending Inventory, and Weighted Average COGS and Ending Invenory. Show math and excel function. Again PLEASE SHOW COGS AND ENDING INVENORY SEPERATLEY. NOT TOGETHER.

Random, Inc. uses a PERPETUAL inventory system and has provided the following information: Complete the inventory costing schedules documenting details $($shelf$/$purchase location$)$ in the calculation of BOTH ending inventory and cost of goods sold. Use math functionality for calculations and reference$/$link to the master record for each detail. Making connections to the Master Inventory Record allows the worksheet to be used for analyzing potential changes in the results.