Determining the Beginning and Ending Inventory from a Partial Spreadsheet: Periodic Inventory System

From the following partial spreadsheet, indicate the dollar amount of beginning and ending merchandise inventory to be used to compute cost of goods sold.

$\backslash$table$[[$ACCOUNT TITLE,ADJUSTMENTS,ADJUSTED TRIAL BALANCE$],[$DEBIT$,$CREDIT,DEBIT,CREDIT$],[$Merchandise Inventory,$60,000\mathrm{.}00,56,000\mathrm{.}00,60,000\mathrm{.}00,],[$Estimated Returns Inventory,$6,100\mathrm{.}00,5,400\mathrm{.}00,6,100\mathrm{.}00,],[$Supplies$,,4,700\mathrm{.}00,3,300\mathrm{.}00,],[$Prepaid Insurance,$1,1,600\mathrm{.}00,3,800\mathrm{.}00,],[$Customer Refunds Payable,,$2,200\mathrm{.}00,,7,200\mathrm{.}00$