The unadjusted balances in the general ledger of Mind Over Batter cake shop as of December 31, 2016 before adjusting ournal entries are as follows: S 6,750 Capital stock IS 6,850 Cash ES 3,900 Dividends S 3,425 Supplies RS 8,400 Service Revenue S Prepaid Insurance 56,300 S 24.300 41,750 Salary Expense Equipment Retained Earnings, Dec 1, 2016 S 22,925 Rent Expense S 6,000 Accumulated Depreciation IS 9,950 |Miscellaneous Expense S 1500 Adjustment data are as follows: a. Physical counts that the ending value of supplies on hand on December 31, 2016 is $900 b. Insurance expired for December is $1,100; c. Depreciation on equipment for this month is $1,600 d. Salary expense accrued for this month is $1,650 On the tabs indicated in this Excel file complete the following: Tab A On the basis of the tab A, journalize the adjusting journal entries as of December 31, 2016. B Prepare an End-of-Period Spreadsheet for Mind over Batter Cake Shop. NOTE: Accounts are sorted in right order. Tab Tab C On the basis of the work sheet in tab B, present in proper form: (1) income statement, (2) statement of retained earning (no additional investments were made), and (3) CLASSIFIED balance sheet. All in Tab C Tab D Generated closing journal entries in Tab D