ACCT 2101 - Fall 2019 Comprehensive Problem 4-3 On January 1, 2019, John Smith launched a computer services.com . Technology Business Solutions (TBS), that is organized as a corporation and provides consulting services, computer system installations, and custom program development. Smith adopts the calendar year for reporting purposes. Technology Business Solutions does not use reversing entries and therefore, all revenue and expense accounts have zero beginning balances as of June 1, 2019 In June, the sixth month of operation, the following payroll transactions took place: YTD June Cumulative Hours June Pay Earnings as of Name Worked Rate Pay Per May 31, 2019 Blair, L 90 $121050 hour $2,000.00 Dill, C. n/a $1,000 a month $1,500.00 Downer, 1. n/a $950 $ 1 month $2,500.00 Hem, 170 $9 hour $120. 005 n/a $950 5 month $1,200.00 Troup, P. 130 $10 1380 hour $1,400.00 Wando, c. $8 520 hour $180.00 Will, A. n/a $1,200 1200 month $1,100.00 65 Additional information is as follows: 1. A normal work month is 160 hours. Any time over 160 hours is paid at 150% of the normal hourly rate, 2. The employee's state income tax withholding is at a rate of 6.0% and federal income tax withholding is at a rate of 7.5 3. Gross pay is subject to social security taxes at a 6.2% rate, on an annual limit of $118,500 Medicare taxes are 1.45% of gross earnings. These taxes are matched by the employer. No one had earned more than $118,500 during the months leading up to December 4. TBS has 100 participation in a $2.50 per month employee charitable contribution program. These contributions are withheld from the employee's monthly pay 5. TBS pays for workers' compensation insurance at a rate of 2.2% of gross pay. None of this cost is paid by the employee. 6. TBS provides employees with health insurance, however the cost is fully paid by the employees. All employees enroll in the health insurance. The rate is 5235 per month, per employee. 7. TBS's payroll is subject to federal (0.8%) and state (2.55%) unemployment taxes on the first $7,000 of each employee's gross pay. 8. TBS contributes 3.30% of gross pay for each employee to a retirement account. Employees do not contribute to this plan. Requirements: 1. Complete a payroll register by calculating gross pay, all payroll deductions and net pay per employee and in total as shown below: Federal Social State Gross Income Security Income Charitable Health Net Earnings Tax Tax Medicare Tax Contributions Insurance Earnings 2. Calculate all employer related payroll expenses as well (a similar form could be used). 3. Prepare all necessary payroll related journal entries and the related payroll expenses as of June 30. The payroll for June will be paid on July 5. Prepare your journal entries in total only (do not prepare a journal entry for each employee) Technology Business Solutions 4. Post your journal Unadjusted Trial Balance entries to t-accounts 30 Jun-19 5. Prepare the adjusted Cash 45.367.00 trial balance by posting Accounts Recenate 23.250.00 the payroll journal Mowance for Bad Debt entries/t-account Prepaid Rent 52500 balances to the trial Prepaid Insurance L110.00 Computer Supplies inventory balance given for June Merchandise inventory 2,538.00 30 here. Estimated Returns Inventory 120.00 6. Prepare a multi-step Office Equipment Accumulated Depreciation income statement for Computer Equipment 20.000.00 TBS for the month Accumulated Depreciation 2.500.00 ended June 30 Accounts Payable 1.150.00 Refunds Payable 281.54 Unearned Revenue 7. Prepare a balance Retained Earnings 8.962.00 sheet in classified form Common Stock 71.000.00 for TBS at June 30. Didende Computer Services Revenge 14350.00 Sales Revenue 11.400.00 Cost of Goods Sold 5.950.00 Depreciation expense Office equipment 133.00 Depreciation expense-Computer equipment 417.00 Insurance Exp 185.00 Rent Expense 825.00 Computer Supplies Expense 1132.00 Advertising Expense 340.00 Mileage Expense 192.00 Miscellaneous pense 85.00 Repairs Expense 465 54 Bad Debt Expense 207.00 112.982.54 112.502.54 Norkers Comp ACCT 2101 - Fall 2019 Comprehensive Problem 4-3 On January 1, 2019, John Smith launched a computer services.com . Technology Business Solutions (TBS), that is organized as a corporation and provides consulting services, computer system installations, and custom program development. Smith adopts the calendar year for reporting purposes. Technology Business Solutions does not use reversing entries and therefore, all revenue and expense accounts have zero beginning balances as of June 1, 2019 In June, the sixth month of operation, the following payroll transactions took place: YTD June Cumulative Hours June Pay Earnings as of Name Worked Rate Pay Per May 31, 2019 Blair, L 90 $121050 hour $2,000.00 Dill, C. n/a $1,000 a month $1,500.00 Downer, 1. n/a $950 $ 1 month $2,500.00 Hem, 170 $9 hour $120. 005 n/a $950 5 month $1,200.00 Troup, P. 130 $10 1380 hour $1,400.00 Wando, c. $8 520 hour $180.00 Will, A. n/a $1,200 1200 month $1,100.00 65 Additional information is as follows: 1. A normal work month is 160 hours. Any time over 160 hours is paid at 150% of the normal hourly rate, 2. The employee's state income tax withholding is at a rate of 6.0% and federal income tax withholding is at a rate of 7.5 3. Gross pay is subject to social security taxes at a 6.2% rate, on an annual limit of $118,500 Medicare taxes are 1.45% of gross earnings. These taxes are matched by the employer. No one had earned more than $118,500 during the months leading up to December 4. TBS has 100 participation in a $2.50 per month employee charitable contribution program. These contributions are withheld from the employee's monthly pay 5. TBS pays for workers' compensation insurance at a rate of 2.2% of gross pay. None of this cost is paid by the employee. 6. TBS provides employees with health insurance, however the cost is fully paid by the employees. All employees enroll in the health insurance. The rate is 5235 per month, per employee. 7. TBS's payroll is subject to federal (0.8%) and state (2.55%) unemployment taxes on the first $7,000 of each employee's gross pay. 8. TBS contributes 3.30% of gross pay for each employee to a retirement account. Employees do not contribute to this plan. Requirements: 1. Complete a payroll register by calculating gross pay, all payroll deductions and net pay per employee and in total as shown below: Federal Social State Gross Income Security Income Charitable Health Net Earnings Tax Tax Medicare Tax Contributions Insurance Earnings 2. Calculate all employer related payroll expenses as well (a similar form could be used). 3. Prepare all necessary payroll related journal entries and the related payroll expenses as of June 30. The payroll for June will be paid on July 5. Prepare your journal entries in total only (do not prepare a journal entry for each employee) Technology Business Solutions 4. Post your journal Unadjusted Trial Balance entries to t-accounts 30 Jun-19 5. Prepare the adjusted Cash 45.367.00 trial balance by posting Accounts Recenate 23.250.00 the payroll journal Mowance for Bad Debt entries/t-account Prepaid Rent 52500 balances to the trial Prepaid Insurance L110.00 Computer Supplies inventory balance given for June Merchandise inventory 2,538.00 30 here. Estimated Returns Inventory 120.00 6. Prepare a multi-step Office Equipment Accumulated Depreciation income statement for Computer Equipment 20.000.00 TBS for the month Accumulated Depreciation 2.500.00 ended June 30 Accounts Payable 1.150.00 Refunds Payable 281.54 Unearned Revenue 7. Prepare a balance Retained Earnings 8.962.00 sheet in classified form Common Stock 71.000.00 for TBS at June 30. Didende Computer Services Revenge 14350.00 Sales Revenue 11.400.00 Cost of Goods Sold 5.950.00 Depreciation expense Office equipment 133.00 Depreciation expense-Computer equipment 417.00 Insurance Exp 185.00 Rent Expense 825.00 Computer Supplies Expense 1132.00 Advertising Expense 340.00 Mileage Expense 192.00 Miscellaneous pense 85.00 Repairs Expense 465 54 Bad Debt Expense 207.00 112.982.54 112.502.54 Norkers Comp