$1.)$ Complete the master inventory record using the math functionality of Sheets$/$Excel$.$

$2.)$ Complete

REQUIRED FOR POINTS:

$\backslash$table$[[1,$Complete the master inventory record using the math functionality of Sheets$/$Excel$.],[,$Location $($Shelves$),$# of Units,,er unit,Total cost$],[$Beginning inventory,$20,$$$,24\mathrm{.}00,480],[$Jan $10$ purchase,$30,$$$,25\mathrm{.}00,750],[$Jan $22$ purchase,$35,$$$,28\mathrm{.}00,980],[$Jan $25$ purchase,$30,$$$,30\mathrm{.}00,900],[$Jan $30$ purchase,$15,$$$,31\mathrm{.}00,465],[$Available Inventory,$130,,,3575],[$January $24$ Sales,$61,,,$each method calcuktion$],[$Ending Inventory,$69,,,$is on schedule below$]]$the inventory costing schedules documenting each detail $($shelf$/$purchase date$)$ 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.