Random, Inc. uses a PERPETUAL inventory system and has provided the following information:

REQUIRED FOR POINTS:

$\backslash$table$[[1,$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\mathrm{.}00],[,$Jan $15$ purchase,$30,$$$,25\mathrm{.}00,],[,$Jan $20$ purchase,$35,$$$,28\mathrm{.}00,],[,$Jan $30$ purchase,$30,$$$,30\mathrm{.}00,],[,$Available Inventory,,,,$],[,$January $25$ Sales,$52,,,$each method calculation$],[,$Ending Inventory,,,,is on schedule below$],[2,\{$

$\backslash$table$[[$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.$],[$FIFO Cost of Goods Sold$]]\}],[]]$