Complete the master inventory record using the math functionality of Sheets/Excel. Location (Shelves) # of Units Cost per unit Total cost Beginning inventory 20 $ 20.00 400 Jan 15 purchase 30 $ 25.00 750 Jan 20 purchase 35 $ 28.00 980 Jan 30 purchase 30 $ 30.00 900 Available Inventory 115 3030 January 25 Sales 52 Ending Inventory 63 each method calculation is on schedule below 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.