? zoom in?

ow. Update Salzman's earnings record to reflect the November 18 payroll. EMPLOYEE EARNINGS RECORD FOR THE PERIOD ENDED 20- KABLE EARNINGS DEDUCTIONS MPL. SOC. SEC. MEDICARE STATE INCOME HEALTH CREDIT MP. . SOC. SEC. FED INC. TAX TAX TAX TAX IN SUR. UNION TOTAL CK. NO. AMOUNT 363.00 363.00 0 22.51 5.26 12.71 12 72.60 125.08 121 237.92 489.50 489.50 11.00 30.35 7.10 17.13 12 97.90 175.49 229 314.02 MARITAL CIAL SECURITY NO. STATUS ALLOW. PAY RATE DATE OF BIRTH DATE HIRED NAME/ADDRESS EMP. NO. . 5 Activate widows ayroll Register columns. Payroll Register Instructions PAYROLL REGISTER FOR THE PERIOD ENDED 20-- EARNINGS TAXABLE EARNINGS DEDUCTIONS NAME NO. ALLOW. MARIT. STATUS REGULAR OVER TIME TOTAL CUM. TOTAL UNEMPL. COMP. SOC. SEC FED. INC. TAX SOC. SEC. TAX MEDICARE TAX STATE INCOME TAX HEALTH INSUR. CREDIT UNION TOTAL NET PAY CK. NO. 1 Berling, J. 3 M 480.00 72.00 552.00 648.00 40.18 9.40 22.68 5.00 149.6 226.85 421.15 1 1 2 Merz, L. 4 M 600.00 45.00 645.00 645.00 39.99 9.35 22.58 5.00 117.00 193.92 451.08 2 2 3 Goetz, K 2 M 440.00 440.00 440.00 27.28 6.38 15.40 5.00 91.30 145.36 294.64 3 3 4 Menick, J. 2 S 275.00 275.00 627.00 38.87 9.09 21.95 5.00 126.50 201.41 201.41 425.59 4 4 5 Morales, E 3 M 494.00 494.00 494.00 30.63 7.16 17.29 5.00 117.05 177.13 316.87 5 5 6 Heimbrock, J. 5 M 1.360.00 1.360.00 1.360.00 59.52 19.72 47.60 5.00 154.25 286.00 286.09 1073.91 6 6 7 Townsley, S. 2 M 252.00 252.00 324.00 20.09 4.70 11.34 5.00 83.05 124.18 199.82 7 7 8 Salzman, B. 2 M 374.00 374.00 915.00 365.00 56.73 13.27 32.03 5.00 130.00 237.02 677.98 8 8 9 Layton, E. 3 M 440.00 440.00 880.00 440.00 54.56 12.76 30.80 5.00 88.00 191.12 191.12 688.88 9 9 10 Thompson, D. 5 M 440.00 50.00 490.00 534,00 534.00 33.08 7.74 18.67 5.00 128.90 193.39 340.11 10 10 11 Vadillo C 2 S 481.00 481.00 689.00 42.72 9.99 24.12 5.00 139.11 220.93 468.07 11 11 12 5,636.00 166.50 5,803.00 7,555.50 805.00 443.64 109.55 264.44 55.00 1,324.76 2,197.40 5,358.10 12 General Journal W Employee Earnings Record 2. Assuming that the wages for the week ended November 18 were paid on November 21, prepare the journal entry for the p of this payroll. 3. The current employee earnings record for Beth Salzman is provided below. Upd General Journal Instructions Earnings Record Instructions PAC EARNINGS TAXABLE EA CUM. GENERAL JOURNAL 20-- PERIOD UNEMPL. ENDED REGULAR OVER TIME TOTAL TOTAL COMP. DATE ACCOUNT TITLE POS REF. DEBIT 11/4 330.00 33.00 363.00 6,145.50 363.00 1 Nov. 18 11/11 440.00 49.50 489.50 6,635.00 489.50 2 11/18 3 11/25 4 5 GENDER DEPARTMENT OCCUPATION SOCIAL SECU 7 8 Payroll Register Instructions Required: hoy. Prepare a payroll register for Trenkamp Collec Earnings/Unemployment Compensation colum employees.) Total the amount columns. 1. Prepare a payroll register for Trenkamp Collection Agency for the week ended November 18, 20-- (In the Taxable Earnings/Unemployment Compensation column, enter $365 for Salzman and $440 for Layton. Leave this column blank for all other employees.) Total the amount columns. 2. Assuming that the wages for the week ended this payroll. Payroll Register Instructions PAYROLL REGISTER FOR THE PERIOD ENDED 20-- 3. The current employee earnings record for Bet the November 18 payroll. Although this informa record. The necessary information is as follow EARNINGS TAXABLE EARNINGS DEDUCTIONS NAME NO. ALLOW. MARIT. STATUS REGULAR OVER TIME TOTAL CUM. TOTAL UNEMPL. COMP. SOC. SEC. FED. INC. TAX SOC. SEC. TAX MEDICARE TAX STATE INCOME TAX HEALTH INSUR. CREDIT UNION TOTAL NET PAY CK. NO. Name Beth F. Salzman 1 Berling, J. 3 M M 480.00 72.00 552.00 648.00 40.18 9.40 22.68 5.00 149.6 226.85 421.15 1 1 Address 12 Windmill Lane 2 Merz, L 4 M 600.00 45.00 645.00 645.00 39.99 9.35 22.58 5.00 117.00 193.92 451.08 2 2 Trumbull, CT 06611 8 3 Goetz, K. 2 M Employee No. 440.00 440.00 440.00 27.28 6.38 15.40 5.00 91.30 145.36 294.64 3 3 Gender Female 4 Menick, J. 2 S 275.00 275.00 627.00 38.87 9.09 21.95 5.00 126.50 201.41 425.59 4 4 Department Administration 5 | Morales, E. 3 M 494.00 494.00 494.00 30.63 7.16 17.29 5.00 117.05 177.13 316.87 5 5 Occupation Office Assistant 6 Heimbrock, J. 5 M 1,360.00 1,360.00 1,360.00 59.52 19.72 47.60 5.00 154.25 286.09 1073.91 6 0) Social Security No. 446-46-6321 7 Townsley, S 2 M 252.00 252.00 324.00 20.09 4.70 11.34 5.00 83.05 124.18 199.82 7 7 Marital Status Married 8 Salzman, B. 2 M 374.00 374.00 915.00 365.00 56.73 13.27 32.03 5.00 130.00 237.02 677.98 Co 8 Allowances 2 9 Layton, E. 3 M 440.00 440.00 880.00 440.00 54.56 12.76 30.80 5.00 88.00 191.12 688.88 9 9 Pay Rate $11.00 per hour 10 5 M Thompson, D. 440.00 50.00 490.00 534.00 33.08 7.74 18.67 5.00 128.90 193.39 340.11 10 10 Date of Birth 4/5/84 Date Hired 7/22 -- 11 Vadillo, C. 2 S 481.00 481.00 689.00 42.72 9.99 24.12 5.00 139.11 220.93 468.07 11 11 General Journal Employee Earnings Record X 2. Assuming that the wages for the week ended November 18 were paid on November 21, prepare the journal entry for the p of this payroll. 3. The current employee earnings record for Beth Salzman is provided below. Update Salzman's earnings record to reflect the November 18 payroll. General Journal Instructions Earnings Record Instructions EMPLOYEE EARNINGS RECORD FOR THE PERIOD ENDED 20-- PAC EARNINGS TAXABLE EARNINGS DEDUCTIONS GENERAL JOURNAL 20-- PERIOD CUM. UNEMPL. SOC. SEC. MEDICARE STATE INCOME HEALTH CREDIT ENDED REGULAR OVER TIME TOTAL TOTAL COMP. SOC. SEC. FED INC. TAX TAX TAX TAX IN SUR UNION TOTAL CK. NO. AMOUNT DATE ACCOUNT TITLE POST. REF. DEBIT CRED 11/4 330.00 33.00 363.00 6,145.50 363.00 363.00 0 22.51 5.26 12.71 12 72.60 125.08 12 237.92 1 Nov. 18 11/11 440.00 49.50 489.50 6,635.00 489.50 489.50 11.00 30.35 7.10 17.13 12 97.90 175.49 229 314.02 2 11/18 3 11/25 4 MARITAL 5 GENDER DEPARTMENT OCCUPATION SOCIAL SECURITY NO. STATUS ALLOW. PAY RATE DATE OF BIRTH DATE HIRED NAME/ADDRESS EMP. NO. 6 7 8 Instructions Chart of Accounts ASSETS REVENUE Abigail Trenkamp owns are operates the Trenkamp Collection Agency. Listed below are the name, number of allowances claimed, marital status, information from time cards on hours worked each day, and the hourly rate of each employee. All hours worked in excess of 40 hours for Monday through Friday are paid at 12 times the regular rate. All weekend hours are paid at double the regular rate. 101 Cash 401 Sales 142 Supplies 145 Prepaid Insurance EXPENSES 181 Office Equipment 511 Wages and Salaries Expense Trenkamp uses a weekly federal income tax withholding table. Social Security tax is withheld at the rate of 6.2% for the first $ 128,400 earned. Medicare tax is withheld at 1.45% and state income tax at 3.5%. Each employee has $12 withheld for health insurance. All employees use payroll deduction to the credit union for varying amounts as listed. 181.1 Accumulated Depreciation Office Equipment 521 Rent Expense 523 Office Supplies Expense LIABILITIES Trenkamp Collection Agency 533 Utilities Expense 535 Insurance Expense 202 Accounts Payable Payroll Information for the Week Ended November 18, 20-- 203 United Way Contributions Payable 541 Depreciation Expense-Office Equipment Employee No of Marital Hours Worked Hourly Credit Union Total Earnings 211 Employee Federal Income Tax Payable 549 Miscellaneous Expense 212 Social Security Tax Payable Name No. Allow. Status S S M T W T F Rate Deposit 1/1-11/11 213 Medicare Tax Payable Berling, James 1 3 M 2 2 9 8 8 9 10 $12 $149.60 $24,525 215 State Income Tax Payable Merz, Linda 2 4 M 0 0 8 8 8 8 10 15 117.00 30,480 216 Health Insurance Premiums Payable Goetz, Ken 3 2 M 0 0 6 7 8 9 10 13 91.30 23,400 217 Credit Union Payable Menick, Judd 4 2 S 8 8 0 0 8 8 9 13 126.50 26,325 Morales, Eva 5 3 M 0 0 8 8 8 6 8 13 117.05 24,730 EQUITY Heimbrock, Jacob 6 5 M 0 0 8 8 8 8 4 42 154.25 127,440 311 Capital Townsley, Sarah 7 2 M 4 0 6 6 6 6 4 12 83.05 21,425 313 Income Summary Salzman, Beth 8 2 M 6 2 8 8 6 6 6 11 130.00 6,635 321 Drawing Layton, Esther 9 3 M 0 0 8 8 8 8 8 11 88.00 5,635 Thompson. David 10 5 M. 0 2 10 9 7 7 10 14 128.90 25.830 Instructions Vadillo, Carmen 11 2 S 8 04 8 8 8 9 13 139.11 24, 115 w The Trenkamp Collection Agency follows the practice of drawing a single check for the net amount of the payroll and depositing the check in a special payroll account at the bank. Individual checks issued were numbered consecutively, beginning with No. 331. Required: 1. Prepare a payroll register for Trenkamp Collection Agency for the week ended November 18, 20-- (In the Taxable Earnings/Unemployment Compensation column, enter $365 for Salzman and $440 for Layton. Leave this column blank for all other employees.) Total the amount columns. 2. Assuming that the wages for the week ended November 18 were paid on November 21, prepare the journal entry for the payment of this payroll . 3. The current employee earnings record for Beth Salzman is provided in the working papers. Update Salzman's earnings record to reflect the November 18 payroll. Although this information should have been entered earlier, complete the required information on the earnings record. The necessary information is as follows: Name Beth F. Salzman Address 12 Windmill Lane Trumbull, CT 06611 Employee No. 8 Gender Female Department Administration Occupation Office Assistant Social Security No. 446-46-6321 ow. Update Salzman's earnings record to reflect the November 18 payroll. EMPLOYEE EARNINGS RECORD FOR THE PERIOD ENDED 20- KABLE EARNINGS DEDUCTIONS MPL. SOC. SEC. MEDICARE STATE INCOME HEALTH CREDIT MP. . SOC. SEC. FED INC. TAX TAX TAX TAX IN SUR. UNION TOTAL CK. NO. AMOUNT 363.00 363.00 0 22.51 5.26 12.71 12 72.60 125.08 121 237.92 489.50 489.50 11.00 30.35 7.10 17.13 12 97.90 175.49 229 314.02 MARITAL CIAL SECURITY NO. STATUS ALLOW. PAY RATE DATE OF BIRTH DATE HIRED NAME/ADDRESS EMP. NO. . 5 Activate widows ayroll Register columns. Payroll Register Instructions PAYROLL REGISTER FOR THE PERIOD ENDED 20-- EARNINGS TAXABLE EARNINGS DEDUCTIONS NAME NO. ALLOW. MARIT. STATUS REGULAR OVER TIME TOTAL CUM. TOTAL UNEMPL. COMP. SOC. SEC FED. INC. TAX SOC. SEC. TAX MEDICARE TAX STATE INCOME TAX HEALTH INSUR. CREDIT UNION TOTAL NET PAY CK. NO. 1 Berling, J. 3 M 480.00 72.00 552.00 648.00 40.18 9.40 22.68 5.00 149.6 226.85 421.15 1 1 2 Merz, L. 4 M 600.00 45.00 645.00 645.00 39.99 9.35 22.58 5.00 117.00 193.92 451.08 2 2 3 Goetz, K 2 M 440.00 440.00 440.00 27.28 6.38 15.40 5.00 91.30 145.36 294.64 3 3 4 Menick, J. 2 S 275.00 275.00 627.00 38.87 9.09 21.95 5.00 126.50 201.41 201.41 425.59 4 4 5 Morales, E 3 M 494.00 494.00 494.00 30.63 7.16 17.29 5.00 117.05 177.13 316.87 5 5 6 Heimbrock, J. 5 M 1.360.00 1.360.00 1.360.00 59.52 19.72 47.60 5.00 154.25 286.00 286.09 1073.91 6 6 7 Townsley, S. 2 M 252.00 252.00 324.00 20.09 4.70 11.34 5.00 83.05 124.18 199.82 7 7 8 Salzman, B. 2 M 374.00 374.00 915.00 365.00 56.73 13.27 32.03 5.00 130.00 237.02 677.98 8 8 9 Layton, E. 3 M 440.00 440.00 880.00 440.00 54.56 12.76 30.80 5.00 88.00 191.12 191.12 688.88 9 9 10 Thompson, D. 5 M 440.00 50.00 490.00 534,00 534.00 33.08 7.74 18.67 5.00 128.90 193.39 340.11 10 10 11 Vadillo C 2 S 481.00 481.00 689.00 42.72 9.99 24.12 5.00 139.11 220.93 468.07 11 11 12 5,636.00 166.50 5,803.00 7,555.50 805.00 443.64 109.55 264.44 55.00 1,324.76 2,197.40 5,358.10 12 General Journal W Employee Earnings Record 2. Assuming that the wages for the week ended November 18 were paid on November 21, prepare the journal entry for the p of this payroll. 3. The current employee earnings record for Beth Salzman is provided below. Upd General Journal Instructions Earnings Record Instructions PAC EARNINGS TAXABLE EA CUM. GENERAL JOURNAL 20-- PERIOD UNEMPL. ENDED REGULAR OVER TIME TOTAL TOTAL COMP. DATE ACCOUNT TITLE POS REF. DEBIT 11/4 330.00 33.00 363.00 6,145.50 363.00 1 Nov. 18 11/11 440.00 49.50 489.50 6,635.00 489.50 2 11/18 3 11/25 4 5 GENDER DEPARTMENT OCCUPATION SOCIAL SECU 7 8 Payroll Register Instructions Required: hoy. Prepare a payroll register for Trenkamp Collec Earnings/Unemployment Compensation colum employees.) Total the amount columns. 1. Prepare a payroll register for Trenkamp Collection Agency for the week ended November 18, 20-- (In the Taxable Earnings/Unemployment Compensation column, enter $365 for Salzman and $440 for Layton. Leave this column blank for all other employees.) Total the amount columns. 2. Assuming that the wages for the week ended this payroll. Payroll Register Instructions PAYROLL REGISTER FOR THE PERIOD ENDED 20-- 3. The current employee earnings record for Bet the November 18 payroll. Although this informa record. The necessary information is as follow EARNINGS TAXABLE EARNINGS DEDUCTIONS NAME NO. ALLOW. MARIT. STATUS REGULAR OVER TIME TOTAL CUM. TOTAL UNEMPL. COMP. SOC. SEC. FED. INC. TAX SOC. SEC. TAX MEDICARE TAX STATE INCOME TAX HEALTH INSUR. CREDIT UNION TOTAL NET PAY CK. NO. Name Beth F. Salzman 1 Berling, J. 3 M M 480.00 72.00 552.00 648.00 40.18 9.40 22.68 5.00 149.6 226.85 421.15 1 1 Address 12 Windmill Lane 2 Merz, L 4 M 600.00 45.00 645.00 645.00 39.99 9.35 22.58 5.00 117.00 193.92 451.08 2 2 Trumbull, CT 06611 8 3 Goetz, K. 2 M Employee No. 440.00 440.00 440.00 27.28 6.38 15.40 5.00 91.30 145.36 294.64 3 3 Gender Female 4 Menick, J. 2 S 275.00 275.00 627.00 38.87 9.09 21.95 5.00 126.50 201.41 425.59 4 4 Department Administration 5 | Morales, E. 3 M 494.00 494.00 494.00 30.63 7.16 17.29 5.00 117.05 177.13 316.87 5 5 Occupation Office Assistant 6 Heimbrock, J. 5 M 1,360.00 1,360.00 1,360.00 59.52 19.72 47.60 5.00 154.25 286.09 1073.91 6 0) Social Security No. 446-46-6321 7 Townsley, S 2 M 252.00 252.00 324.00 20.09 4.70 11.34 5.00 83.05 124.18 199.82 7 7 Marital Status Married 8 Salzman, B. 2 M 374.00 374.00 915.00 365.00 56.73 13.27 32.03 5.00 130.00 237.02 677.98 Co 8 Allowances 2 9 Layton, E. 3 M 440.00 440.00 880.00 440.00 54.56 12.76 30.80 5.00 88.00 191.12 688.88 9 9 Pay Rate $11.00 per hour 10 5 M Thompson, D. 440.00 50.00 490.00 534.00 33.08 7.74 18.67 5.00 128.90 193.39 340.11 10 10 Date of Birth 4/5/84 Date Hired 7/22 -- 11 Vadillo, C. 2 S 481.00 481.00 689.00 42.72 9.99 24.12 5.00 139.11 220.93 468.07 11 11 General Journal Employee Earnings Record X 2. Assuming that the wages for the week ended November 18 were paid on November 21, prepare the journal entry for the p of this payroll. 3. The current employee earnings record for Beth Salzman is provided below. Update Salzman's earnings record to reflect the November 18 payroll. General Journal Instructions Earnings Record Instructions EMPLOYEE EARNINGS RECORD FOR THE PERIOD ENDED 20-- PAC EARNINGS TAXABLE EARNINGS DEDUCTIONS GENERAL JOURNAL 20-- PERIOD CUM. UNEMPL. SOC. SEC. MEDICARE STATE INCOME HEALTH CREDIT ENDED REGULAR OVER TIME TOTAL TOTAL COMP. SOC. SEC. FED INC. TAX TAX TAX TAX IN SUR UNION TOTAL CK. NO. AMOUNT DATE ACCOUNT TITLE POST. REF. DEBIT CRED 11/4 330.00 33.00 363.00 6,145.50 363.00 363.00 0 22.51 5.26 12.71 12 72.60 125.08 12 237.92 1 Nov. 18 11/11 440.00 49.50 489.50 6,635.00 489.50 489.50 11.00 30.35 7.10 17.13 12 97.90 175.49 229 314.02 2 11/18 3 11/25 4 MARITAL 5 GENDER DEPARTMENT OCCUPATION SOCIAL SECURITY NO. STATUS ALLOW. PAY RATE DATE OF BIRTH DATE HIRED NAME/ADDRESS EMP. NO. 6 7 8 Instructions Chart of Accounts ASSETS REVENUE Abigail Trenkamp owns are operates the Trenkamp Collection Agency. Listed below are the name, number of allowances claimed, marital status, information from time cards on hours worked each day, and the hourly rate of each employee. All hours worked in excess of 40 hours for Monday through Friday are paid at 12 times the regular rate. All weekend hours are paid at double the regular rate. 101 Cash 401 Sales 142 Supplies 145 Prepaid Insurance EXPENSES 181 Office Equipment 511 Wages and Salaries Expense Trenkamp uses a weekly federal income tax withholding table. Social Security tax is withheld at the rate of 6.2% for the first $ 128,400 earned. Medicare tax is withheld at 1.45% and state income tax at 3.5%. Each employee has $12 withheld for health insurance. All employees use payroll deduction to the credit union for varying amounts as listed. 181.1 Accumulated Depreciation Office Equipment 521 Rent Expense 523 Office Supplies Expense LIABILITIES Trenkamp Collection Agency 533 Utilities Expense 535 Insurance Expense 202 Accounts Payable Payroll Information for the Week Ended November 18, 20-- 203 United Way Contributions Payable 541 Depreciation Expense-Office Equipment Employee No of Marital Hours Worked Hourly Credit Union Total Earnings 211 Employee Federal Income Tax Payable 549 Miscellaneous Expense 212 Social Security Tax Payable Name No. Allow. Status S S M T W T F Rate Deposit 1/1-11/11 213 Medicare Tax Payable Berling, James 1 3 M 2 2 9 8 8 9 10 $12 $149.60 $24,525 215 State Income Tax Payable Merz, Linda 2 4 M 0 0 8 8 8 8 10 15 117.00 30,480 216 Health Insurance Premiums Payable Goetz, Ken 3 2 M 0 0 6 7 8 9 10 13 91.30 23,400 217 Credit Union Payable Menick, Judd 4 2 S 8 8 0 0 8 8 9 13 126.50 26,325 Morales, Eva 5 3 M 0 0 8 8 8 6 8 13 117.05 24,730 EQUITY Heimbrock, Jacob 6 5 M 0 0 8 8 8 8 4 42 154.25 127,440 311 Capital Townsley, Sarah 7 2 M 4 0 6 6 6 6 4 12 83.05 21,425 313 Income Summary Salzman, Beth 8 2 M 6 2 8 8 6 6 6 11 130.00 6,635 321 Drawing Layton, Esther 9 3 M 0 0 8 8 8 8 8 11 88.00 5,635 Thompson. David 10 5 M. 0 2 10 9 7 7 10 14 128.90 25.830 Instructions Vadillo, Carmen 11 2 S 8 04 8 8 8 9 13 139.11 24, 115 w The Trenkamp Collection Agency follows the practice of drawing a single check for the net amount of the payroll and depositing the check in a special payroll account at the bank. Individual checks issued were numbered consecutively, beginning with No. 331. Required: 1. Prepare a payroll register for Trenkamp Collection Agency for the week ended November 18, 20-- (In the Taxable Earnings/Unemployment Compensation column, enter $365 for Salzman and $440 for Layton. Leave this column blank for all other employees.) Total the amount columns. 2. Assuming that the wages for the week ended November 18 were paid on November 21, prepare the journal entry for the payment of this payroll . 3. The current employee earnings record for Beth Salzman is provided in the working papers. Update Salzman's earnings record to reflect the November 18 payroll. Although this information should have been entered earlier, complete the required information on the earnings record. The necessary information is as follows: Name Beth F. Salzman Address 12 Windmill Lane Trumbull, CT 06611 Employee No. 8 Gender Female Department Administration Occupation Office Assistant Social Security No. 446-46-6321