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.