Question

Please do A,B,C, Analysis, AP-13a and AP-14a

AP-12AL034567 Zig Zag Robotics has the following adjustments to make at the end of September 2018, the end of its fiscal year. Sep 30 Unearned revenue of $850 has now been earned Sep 30 A count of the office supplies shows that 5430 worth of supplies still remains on hand Sep 30 Salaries accrued but not yet pald amount to $2430 Sep 30 Monthly depreciation on equipment was $600 The chart of accounts is shown below. Account Description Account Account Description Account: 101 OWNER'S EQUITY Rizzo, Capital Rizzo, Withdrawals 300 310 105 ASSETS Cash Accounts Receivable Office Supplies Equipment Accumulated Depreciation Equipment 110 120 REVENUE 130 Service Revenue 400 200 LIABILITIES Accounts Payable Unearned Revenue Salaries Payable EXPENSES Salaries Expense Depreciation Expense Supplies Expense 530 535 210 220 540 182

Answer 1

Book1 - Microsoft Excel Cla Home Insert Page Layout Formulas Data Review View Developer (?) X х AutoSum Calibri 11 Α Α΄ 2 Wrap Text General Fill - * Cut EB Copy Paste Format Painter Clipboard B I U F Merge & Center % 7 * .00 .00.0 Insert Delete Format Conditional Format Cell Formatting as Table Styles Styles 2 Clear Sort & Find & Filter - Select Font E Alignment Number Cells Editing A1 fr AP12 A A B D E F G H T J 1 AP12 A 2 a) 3 Zig Zag Robotics Spreadsheet 30th September 4 Trial Balance Debit Adjustments Debit Adjusted Trial Balance Debit Credit Credit Credit 3,000.00 950.00 $ $ $ $ 3,000.00 950.00 430.00 5,500.00 830.00 $ $ 400.00 $ $ 600.00 $ 5,500.00 $ $ $ 1,800.00 1,250.00 $ 2,430.00 5 6 Account Name 7 Cash 8 Accounts Receivable 9 Office Supplies 10 Equipment 11 Accumulated Depreciation-Equipment 12 Accounts Payable 13 Salary Payable 14 Unearned Revenue 15 Rizzo Capital 16 Rizzo Withdrawal 17 Service Revenue 18 Salaries Expense 19 Supplies Expense 20 Depreciation Expense 21 22 Total 23 24 lhi Sheet1 Sheet2 Sheet3 Select destination and press ENTER or choose Paste $ 2,400.00 $ 1,250.00 $ 2,430.00 $ 850.00 $ 4,030.00 850.00 $ $ 1,700.00 $ 4,030.00 $ 500.00 $ 500.00 $ 4,200.00 $ 850.00 $ 5,050.00 $ 2,200.00 $ $ $ 2,430.00 400.00 600.00 $ $ $ 4,630.00 400.00 600.00 $ 12,980.00 $ 12,980.00 $ 4,280.00 $ 4,280.00 $ 16,010.00 $ 16,010.00 Average: 14603.08667 Count: 307 Sum: 2190463 BE OM 100% Type here to search O x ENG 11:14 14-09-2020 D

Book1 - Microsoft Excel Cla Home Insert Page Layout Formulas Data Review View Developer (?) X х Σ AutoSum και * Cut EB Copy Calibri 11 Α Α΄ 2 Wrap Text General Fill - Paste B I U Fa Merge & Center % 7 * .00 .00.0 Insert Delete Format Format Painter Conditional Format Cell Formatting as Table Styles Styles 2 Clear Sort & Find & Filter - Select Editing Clipboard Font E Alignment Number Cells A1 fx AP12 A A B С D E F G H 1 24 b) 25 26 27 30th sep 2018 28 Date PR Credit Debit 850.00 Zig Zag Robotics Account Title and Explanation Unearned Revenue Service Revenue (Amount of Unearned service revenue being earned) 210 $ 4001 $ 850.00 29 30 400.00 540 $ 110 $ 400.00 2,430.00 31 30th sep 2018 32 33 34 30th sep 2018 35 36 37 30th sep 2018 38 39 Supplies Expenses($830-$430) Office Supplies (Amount of Supplies Expense) Salaries Expense Salaries Payable (Amount of accrued salaries) Depreciation Expense Accumulated Depreciation-Equipment (Amount of Depreciation Expense) 530 $ 220 $ 2,430.00 600.00 535 $ 1301 $ 600.00 40 41 Account No.-110 42 Office Supplies PR 43 Date Debit Credit 44 Description 01-Sep Balance 30-Sep Supplies Expense Balance $ 830.00 400.00 $ 430.00 45 5401 $ 46 Sheet1 Ready MI Sheet2 Sheet3 Average: 14603.08667 Count: 307 Sum: 2190463 BE 100% + Type here to search O x ENG 11:14 14-09-2020 D

Book1 - Microsoft Excel Cla Home Insert Page Layout Formulas Data Review View Developer (?) X х Σ AutoSum και Calibri 11 Α Α΄ Wrap Text General Fill - * Cut EB Copy Paste Format Painter Clipboard B I U Merge & Center % 9 * .00 .00.0 Insert Delete Format Conditional Format Cell Formatting as Table Styles Styles 2 Clear Sort & Find & Filter - Select Editing Font E Alignment Number Cells A1 fx AP12 A A B С D E F G H 1 41 Account No.-110 42 Office Supplies PR 43 Date Debit Credit 44 Description 01-Sep Balance 30-Sep Supplies Expense Balance $ 400.00 $ 830.00 5401 $ 430.00 45 46 47 48 Account No.-540 Supplies Expense PR 49 Date Credit Description 30-Sep Office Supplies Debit 110 $ Balance (Dr) $ 400.00 400.00 50 51 52 53 54 Account No.-210 Account No.-210 55 Unearned Revenue PR Debit Credit Description 01-Sep Balance 30-Sep Service Revenue Balance(Cr) $ 1,700.00 $ 850.00 4001 850 56 Date 57 58 59 60 61 62 Date 63 64 Account No.-400 Service Revenue PR Debit Credit Description 01-Sep Balance 30-Senlunearned Revenue Balance(Cr) $ 4,200.00 850.00 LS 5.050.00 210 $ Sheet1 Sheet2 Sheet3 Ready Average: 14603.08667 Count: 307 Sum: 2190463 OM 100% - + Type here to search 0x ENG 11:15 14-09-2020 D

Book1 - Microsoft Excel Cla Home Insert Page Layout Formulas Data Review View Developer (?) X х Σ AutoSum και Calibri 11 Α Α΄ 2 Wrap Text General Fill - * Cut EB Copy Paste Format Painter Clipboard B I U Merge & Center % 9 * .00 .00.0 Insert Delete Format Conditional Format Cell Formatting as Table Styles Styles 2 Clear Sort & Find & Filter - Select Editing Font E Alignment Number Cells A1 fx AP12 A A B С D E F G H 1 60 Account No.-400 61 Service Revenue PR 62 Date Debit Credit 63 Description 01-Sep Balance 30-Sep Unearned Revenue Balance(Cr) $ 4,200.00 850.00 $ 5,050.00 210 $ 64 65 66 67 Account No.-535 68 Date Depreciation Expense Description PR 30-Sep Accumulated Depreciation Credit Debit 130 $ Balance(Dr) $ 600.00 69 600.00 70 Account No.-130 71 72 73 74 Date 75 76 Accumulated Depreciation PR Debit Credit Description 01-Sep Balance 30-Sep Depreciation Expense Balance(Cr) $ 1,800.00 600.00 $ 2,400.00 535 $ 77 Account No.-530 78 79 80 Date Salaries Expense PR Debit Credit 81 Description 01-Sep Balance 30-Sep Salaries Payable Balance(Dr) $ 2,200.00 $ 4,630.00 220 $ 2,430.00 82 83 K Ready Sheet1 Sheet2 Sheet3 Average: 14603.08667 Count: 307 Sum: 2190463 BE @ 100% - Type here to search x Px ENG 11:15 14-09-2020 D

Book1 - Microsoft Excel Cla Home Insert Page Layout Formulas Data Review View Developer (?) X х Σ AutoSum και Calibri 11 Α Α΄ 2 Wrap Text General Fill - * Cut EB Copy Paste Format Painter Clipboard B I U Merge & Center % 9 * .00 .00.0 Insert Delete Format Conditional Format Cell Formatting as Table Styles Styles 2 Clear Sort & Find & Filter - Select Editing Font E Alignment Number Cells A1 fx AP12 A A B С D E F G H 1 78 Account No.-530 79 Salaries Expense PR 80 Date Debit Credit 81 Description 01-Sep Balance 30-Sep Salaries Payable Balance (Dr) $ 2,200.00 $ 4,630.00 2200 $ 2,430.00 82 83 84 85 Account No.-220 Salaries Payable PR Debit Credit Balance(Cr) $ 2,430.00 $ 2,430.00 530 86 87 Date Description 88 30-Sep Salaries Expense 89 90 Accounting spreadsheet is a mulicolum, it is used to completely display all opening balance, adjustement and final balance 91 accurately. It is prepared before preparing financial statements.Financial statements can be easily prepared without any mistake with this spreadsheet, because necessary 92 accounting information is clearly presented. 93 + Sheet1 Sheet1 Sheet2 Sheet3 Ready Average: 14603.08667 Count: 307 Sum: 2190463 BE W 100% - Type here to search O x ENG 11:15 14-09-2020 D

Book1 - Microsoft Excel Cla Home Insert Page Layout Formulas Data Review View Developer (?) X х Σ AutoSum και * Cut EB Copy Calibri 11 Α Α΄ Wrap Text General Fill - Paste B I U F Merge & Center % 1 * .00 .00.0 Insert Delete Format Format Painter Conditional Format Cell Formatting as Table - Styles Styles 2 Clear Sort & Find & Filter - Select Editing Clipboard Font E Alignment Number Cells A1 for AP12 A C F G H A B D E 95 Ans AP13A) Straight line Depreciation=(Cost-Residual 96 value)/Useful life 97 Cost $ 1,00,000.00 98 Residual value 0 99 Usseful life 5 100 Straight line Depreciation={(A)-(B))/(C) ($100000-0)/5= $ 20,000.00 101 Accumulated 102 Year Original cost of Equipment Depreciation Expense Depreciation Net Book Valuel 103 2018$ 1,00,000.00 $ 20,000.00 $ 20,000.00 $ 80,000.00 104 2019 $ 1,00,000.00 $ 20,000.00 $ 40,000.00 $ 60,000.00 105 2020 $ 1,00,000.00 $ 20,000.00 $ 60,000.00 $ 40,000.00 106 2021 $ 1,00,000.00 $ 20,000.00 $ 80,000.00 $ 20,000.00 1071 2022 $ 1,00,000.00 $ 20,000.00 $ 1,00,000.00 $ 108 109 Ans AP14A) Straight line Depreciation=(Cost-Residual 110 value)/Useful life 111 Cost $ 19,000.00 112 Residual value $ 1,000.00 113 Usseful life 3 114 Straight line Depreciation={(A)-(B))/(C) ($19000-1000)/3= $ 6,000.00 115 |In the 2018 Depreciation calculated for 10 months from 1st March to 31st Dec Sheet1 Sheet2 Sheet3 Ready MP Average: 14603.08667 Count: 307 Sum: 2190463 BE OM 100% - Type here to search O x ENG 11:15 14-09-2020 D

Book1 - Microsoft Excel Cla Home Insert Page Layout Formulas Data Review View Developer (?) X х Σ AutoSum και * Cut EB Copy Calibri 11 Α Α΄ 2 Wrap Text General Fill - Paste B I U Fa Merge & Center % 7 .00 .00.0 Insert Delete Format Format Painter Conditional Format Cell Formatting as Table Styles Styles 2 Clear Sort & Find & Filter - Select Editing Clipboard Font E Alignment Number Cells A1 fx AP12 A F G H A B С D E Accumulated 102 Year Original cost of Equipment Depreciation Expense Depreciation Net Book Valuel 103 2018 $ 1,00,000.00 $ 20,000.00 $ 20,000.00 $ 80,000.00 104 2019 $ 1,00,000.00 $ 20,000.00 $ 40,000.00 $ 60,000.00 105 2020 $ 1,00,000.00 $ 20,000.00 $ 60,000.00 $ 40,000.00 106 2021 $ 1,00,000.00 $ 20,000.00 s 80,000.00 $ 20,000.00 107 2022 $ 1,00,000.00 $ 20,000.00 $ 1,00,000.00 $ 108 109 Ans AP14A) Straight line Depreciation=(Cost-Residual 110 value)/Useful life 111 Cost $ 19,000.00 112 Residual value $ 1,000.00 113 Usseful life 3 114 Straight line Depreciation={(A)-(B))/(C) ($19000-1000)/3= $ 6,000.00 115 In the 2018 Depreciation calculated for 10 months from 1st March to 31st Dec Accumulated 116 Year Original cost of Equipment Depreciation Expense Depreciation Net Book Valuel 117 2018) $ 19,000.00 $ 5,000.00 $ 5,000.00 $ 14,000.00 118 2019 $ 19,000.00 $ 6,000.00 $ 11,000.00 $ 8,000.00 2020 $ 19,000.00 $ 6,000.00 $ 17,000.00 $ 2,000.00 120 2021 $ 19,000.00 $ 1,000.00 $ 18,000.00 $ 1,000.00 121 1221 + Sheet1 Sheet2 Sheet3 Ready Average: 14603.08667 119 Count: 307 Sum: 2190463 100% - Type here to search O x ENG 11:15 14-09-2020 D