FIFO 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 changes in the results