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 Which method provides the lowest tax expense? Explain. Which method provides the largest asset value on the Balance sheet? Erplan why thut might be important. What factor do we need to idensty that affects our analnis? Explain. Which method would you choose? Explain