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. 3 Answer the following questions using the above information: double click in the answer bax and begin typing your answer; enter when done Which method provides the lowest tax expense? Explain. Which method provides the largest asiet value on the Balance Sheet? Explain why that might be important. What primary factor do we need to identify that affects our analysis and responses for the fint two questions? Explain. Which method would you choose? Explain. Complete the inventory costing schedules documenting details (shelf/purchase location) in 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. 3 Answer the following questions using the above information: double click in the answer bax and begin typing your answer; enter when done Which method provides the lowest tax expense? Explain. Which method provides the largest asiet value on the Balance Sheet? Explain why that might be important. What primary factor do we need to identify that affects our analysis and responses for the fint two questions? Explain. Which method would you choose? Explain. Complete the inventory costing schedules documenting details (shelf/purchase location) in