For perpertual inventory how do I calculate: FIFO cost of goods, ending inventory. LIFO cost of good goods, LIFO ending inventory. Weighted average cost of goods sold, and weighted average ending inventory

Random, Inc. uses a PERPETUAL inventory system and has provided the following information: REQUIRED FOR POINTS: 1 Complete the master inventory record using the math functionality of Sheets/Excel. 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 2 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 WEIGHTED AVERAGE Cost of Goods Sold WEIGHTED AVERAGE Ending Inventory