Enter the appropriate numbers/formulas

Question # 00142978 Posted By: solutionshere Updated on: 11/29/2015 11:49 PM Due on: 12/29/2015
Subject Accounting Topic Accounting Tutorials:
Question
Dot Image
PAYROLL REGISTER GLO-BRITE PAINT COMPANY
Marital Status No. W/H Allow. Time Record Regular Earnings Overtime Earnings Total Earnings Deductions Net Paid Taxable Earnings Labor Cost Distribution
NAME S M T W T F S S M T W T F S Hrs. Rate Per Hour Amount Hrs. Rate Per Hour Amount OASDI HI FIT SIT SUTA CIT Group Ins. Union Dues SIMPLE Ck. No. Amount OASDI HI FUTA SUTA Admin. Office Sales Plant
Payday, October 9, 20-- For Period Ending October 3, 20-- Checkpoints
Bonno, A. M 4 8 8 8 8 8 8 8 8 8 8 80 17.65 1,412.00 1,412.00 87.54 20.47 54.00 43.35 1.13 54.47 8.00 672 1,143.04 1,412.00 1,412.00 1,412.00 Total earnings 14,162.77
Ferguson, J. M 5 8 8 8 8 8 8 8 8 8 8 80 2,250.00 2,250.00 139.50 32.63 153.00 69.08 1.80 86.80 673 1,767.19 2,250.00 2,250.00 2,250.00 Net paid 11,058.80
Ford, C. S 2 8 8 8 8 8 8 8 8 8 8 80 900.00 900.00 55.80 13.05 65.00 27.63 0.72 34.72 674 703.08 900.00 900.00 700.00 900.00 900.00
Mann, D. M 4 8 8 8 8 8 8 8 8 8 8 80 1,350.00 1,350.00 83.70 19.58 48.00 41.45 1.08 52.08 675 1,104.11 1,350.00 1,350.00 1,350.00 1,350.00 1,350.00
O'Neill, J. M 3 8 8 8 8 8 8 8 8 8 8 80 2,307.69 2,307.69 143.08 33.46 204.00 70.85 1.85 89.03 676 1,765.42 2,307.69 2,307.69 2,307.69
Russell, V. S 1 8 8 8 8 8 8 8 8 8 8 80 690.00 690.00 42.78 10.01 54.00 21.18 0.55 26.62 677 534.86 690.00 690.00 690.00 690.00 690.00
Ryan, N. M 4 8 8 8 8 8 8 8 8 8 8 80 18.00 1,440.00 1,440.00 89.28 20.88 58.00 44.21 1.15 55.55 8.00 678 1,162.93 1,440.00 1,440.00 1,440.00
Sokowski, T. M 2 8 8 8 8 8 8 8 8 8 8 80 2,050.00 2,050.00 127.10 29.73 187.00 62.94 1.64 79.08 679 1,562.51 2,050.00 2,050.00 2,050.00
(Student) S 1 8 8 8 8 4 8 8 8 8 4 72 7.50 540.00 540.00 33.48 7.83 33.00 16.58 0.43 20.83 680 427.85 540.00 540.00 540.00 540.00 540.00
Williams, R. S 0 8 8 D 8 8 8 8 8 8 8 80 1,223.08 1,223.08 75.83 17.73 156.00 37.55 0.98 47.18 681 887.81 1,223.08 1,223.08 1,223.08
TOTALS 14,162.77 14,162.77 878.09 205.37 1,012.00 434.82 11.33 546.36 0.00 16.00 0.00 11,058.80 14,162.77 14,162.77 3,280.00 3,480.00 2,307.69 3,353.08 3,600.00 4,902.00
Payday, October 23, 20-- For Period Ending October 17, 20-- Checkpoints
Bonno, A. M 4 8 8 8 8 8 4 8 8 8 8 8 80 17.65 1,412.00 4 26.48 105.92 1,517.92 94.11 22.01 64.00 46.60 1.21 58.56 16.50 8.00 682 1,206.93 1,517.92 1,517.92 1,517.92 Total earnings 14,484.69
Ferguson, J. M 5 8 8 8 8 8 8 8 8 8 8 80 2,250.00 2,250.00 139.50 32.63 153.00 69.08 1.80 86.80 26.40 683 1,740.79 2,250.00 2,250.00 2,250.00 Net paid 11,131.63
Ford, C. S 2 4 8 8 8 8 8 8 8 8 8 80 900.00 900.00 55.80 13.05 65.00 27.63 0.72 34.72 10.50 684 692.58 900.00 900.00 800.00 900.00
Mann, D. M 4 8 8 8 8 8 8 8 8 8 8 80 1,350.00 1,350.00 83.70 19.58 48.00 41.45 1.08 52.08 15.90 685 1,088.21 1,350.00 1,350.00 250.00 1,250.00 1,350.00
O'Neill, J. M 3 8 8 8 8 8 8 8 8 8 8 80 2,307.69 2,307.69 143.08 33.46 204.00 70.85 1.85 89.03 27.00 686 1,738.42 2,307.69 2,307.69 2,307.69
Russell, V. S 1 8 8 8 8 8 8 8 8 8 8 80 690.00 690.00 42.78 10.01 54.00 21.18 0.55 26.62 8.10 687 526.76 690.00 690.00 70.00 690.00 690.00
Ryan, N. M 4 8 8 8 8 8 8 8 8 8 8 8 80 18.00 1,440.00 8 27.00 216.00 1,656.00 102.67 24.01 84.00 50.84 1.32 63.89 16.80 8.00 688 1,304.47 1,656.00 1,656.00 1,656.00
Sokowski, T. M 2 8 8 8 8 8 8 8 8 8 8 80 2,050.00 2,050.00 127.10 29.73 187.00 62.94 1.64 79.08 24.00 689 1,538.51 2,050.00 2,050.00 2,050.00
(Student) S 1 8 8 8 8 4 8 8 8 8 4 72 7.50 540.00 540.00 33.48 7.83 33.00 16.58 0.43 20.83 6.30 690 421.55 540.00 540.00 540.00 540.00 540.00
Williams, R. S 0 8 8 8 8 8 8 8 8 8 8 80 1,223.08 1,223.08 75.83 17.73 156.00 37.55 0.98 47.18 14.40 691 873.41 1,223.08 1,223.08 1,223.08
TOTALS 14,162.77 321.92 14,484.69 898.05 210.04 1,048.00 444.70 11.58 558.79 165.90 16.00 0.00 11,131.63 14,484.69 14,484.69 860.00 3,280.00 2,307.69 3,353.08 3,600.00 5,223.92
Payday, November 6, 20-- For Period Ending October 31, 20-- Checkpoints
Bonno, A. M 4 8 8 8 8 8 8 8 8 8 8 80 17.65 1,412.00 1,412.00 87.54 20.47 54.00 43.35 1.13 54.47 8.00 692 1,143.04 1,412.00 1,412.00 1,412.00 Total earnings 14,130.48
Ferguson, J. M 5 8 8 8 8 8 8 8 8 8 8 80 2,250.00 2,250.00 139.50 32.63 153.00 69.08 1.80 86.80 693 1,767.19 2,250.00 2,250.00 2,250.00 Net paid 10,897.23
Ford, C. S 2 8 8 8 8 8 8 8 8 8 8 80 900.00 900.00 55.80 13.05 65.00 27.63 0.72 34.72 694 703.08 900.00 900.00 900.00
Mann, D. M 0 8 8 8 8 8 8 8 8 8 8 80 1,350.00 1,350.00 83.70 19.58 124.00 41.45 1.08 52.08 695 1,028.11 1,350.00 1,350.00 1,350.00
O'Neill, J. M 3 8 8 8 8 8 8 8 8 8 8 80 2,307.69 2,307.69 143.08 33.46 204.00 70.85 1.85 89.03 696 1,765.42 2,307.69 2,307.69 2,307.69
Russell, V. S 2 8 8 8 8 6 8 8 8 8 8 78 672.94 672.94 41.72 9.76 30.00 20.66 0.54 25.96 697 544.30 672.94 672.94 380.00 672.94
Ryan, N. M 4 8 8 8 8 8 8 8 8 8 8 80 18.00 1,440.00 1,440.00 89.28 20.88 58.00 44.21 1.15 55.55 8.00 698 1,162.93 1,440.00 1,440.00 1,440.00
Sokowski, T. S 2 8 8 8 8 8 8 8 8 8 8 80 2,050.00 2,050.00 127.10 29.73 272.00 62.94 1.64 79.08 699 1,477.51 2,050.00 2,050.00 2,050.00
(Student) S 1 8 8 8 8 4 8 8 8 8 4 72 7.50 540.00 540.00 33.48 7.83 33.00 16.58 0.43 20.83 700 427.85 540.00 540.00 370.00 540.00 540.00
Williams, R. S 0 8 8 8 7 8 8 8 8 8 8 79 1,207.85 1,207.85 74.89 17.51 153.00 37.08 0.97 46.60 701 877.80 1,207.85 1,207.85 1,207.85
TOTALS 14,130.48 14,130.48 876.09 204.90 1,146.00 433.83 11.31 545.12 0.00 16.00 0.00 10,897.23 14,130.48 14,130.48 370.00 920.00 2,307.69 3,320.79 3,600.00 4,902.00
Payday, November 13, 20-- For Period Ending November 14, 20-- Checkpoints
Williams, R. S 0 6 8 7 7 6 D D 8 6 8 136 2,079.32 2,079.32 128.92 30.15 348.00 63.84 1.66 80.22 14.40 702 1,412.13 2,079.32 2,079.32 2,079.32 Total earnings 2,079.32
Net paid 1,412.13
TOTALS 2,079.32 2,079.32 128.92 30.15 348.00 63.84 1.66 80.22 14.40 0.00 0.00 1,412.13 2,079.32 2,079.32 0.00 0.00 0.00 2,079.32 0.00 0.00
Payday, November 20, 20-- For Period Ending November 14, 20-- Checkpoints
Bonno, A. M 4 8 8 8 8 8 8 8 8 64 17.65 1,129.60 1,129.60 70.04 16.38 26.00 34.68 0.90 43.58 16.50 8.00 703 913.52 1,129.60 1,129.60 1,129.60 Total earnings 12,640.23
Ferguson, J. M 5 8 8 8 8 8 8 8 8 8 8 80 2,250.00 2,250.00 139.50 32.63 78.00 69.08 1.80 86.80 26.40 500.00 704 1,315.79 2,250.00 2,250.00 2,250.00 Net paid 8,240.91
Ford, C. S 2 8 8 8 8 8 8 8 8 8 8 80 900.00 900.00 55.80 13.05 65.00 27.63 0.72 34.72 10.50 705 692.58 900.00 900.00 900.00
Mann, D. M 0 8 8 8 8 8 8 8 8 8 8 80 1,350.00 1,350.00 83.70 19.58 88.00 41.45 1.08 52.08 15.90 250.00 706 798.21 1,350.00 1,350.00 1,350.00
O'Neill, J. M 3 8 8 8 8 8 8 8 8 8 8 80 2,307.69 2,307.69 143.08 33.46 99.00 70.85 1.85 89.03 27.00 700.00 707 1,143.42 2,307.69 2,307.69 2,307.69
Russell, V. S 2 6 8 8 8 8 8 8 8 8 8 78 672.94 672.94 41.72 9.76 30.00 20.66 0.54 25.96 8.10 708 536.20 672.94 672.94 672.94
Ryan, N. M 4 8 8 8 8 8 8 8 8 8 8 80 18.00 1,440.00 1,440.00 89.28 20.88 38.00 44.21 1.15 55.55 16.80 8.00 200.00 709 966.13 1,440.00 1,440.00 1,440.00
Sokowski, T. S 2 8 8 8 8 8 8 8 8 8 8 80 2,050.00 2,050.00 127.10 29.73 272.00 62.94 1.64 79.08 24.00 710 1,453.51 2,050.00 2,050.00 2,050.00
(Student) S 1 8 8 8 8 4 8 8 8 8 4 72 7.50 540.00 540.00 33.48 7.83 33.00 16.58 0.43 20.83 6.30 711 421.55 540.00 540.00 540.00 540.00
TOTALS 12,640.23 12,640.23 783.70 183.30 729.00 388.08 10.11 487.63 151.50 16.00 1,650.00 8,240.91 12,640.23 12,640.23 0.00 540.00 2,307.69 2,112.94 3,600.00 4,619.60
Payday, December 4, 20-- For Period Ending November 28, 20-- Checkpoints
Bonno, A. M 4 8 8 8 8 8 8 8 8 8 8 8 80 17.65 1,412.00 8 35.30 282.40 1,694.40 105.05 24.57 90.00 52.02 1.36 65.37 8.00 1,348.03 1,694.40 1,694.40 . 1,694.00 Total earnings 14,431.09
Ferguson, J. M 5 8 8 8 8 8 8 8 8 8 8 80 2,250.00 2,250.00 139.50 32.63 153.00 69.08 1.80 86.80 1,767.19 2,250.00 2,250.00 2,250.00 Net paid
Ford, C. S 2 8 8 8 8 8 8 8 8 8 8 80 900.00 900.00 55.80 13.05 65.00 27.63 0.72 34.72 703.08 900.00 900.00 900.00
Mann, D. M 4 8 8 8 8 8 8 8 8 8 8 80 1,350.00 1,350.00 83.70 19.58 124.00 41.45 1.08 52.08 1,028.11 1,350.00 1,350.00 1,350.00
O'Neill, J. M 3 8 8 8 8 8 8 8 8 8 8 80 2,307.69 2,307.69 143.08 33.46 204.00 70.85 1.85 89.03 1,765.42 2,307.69 2,307.69 2,307.69
Russell, V. S 1 8 8 8 8 8 8 8 8 8 8 80 690.00 690.00 42.78 10.01 30.00 21.18 0.55 26.62 558.86 690.00 690.00 690.00
Ryan, N. M 4 8 8 8 4 8 9 10 8 8 8 76 18.00 1,368.00 3 27.00 81.00 1,449.00 89.84 21.01 56.00 44.48 1.16 55.90 8.00 1,172.61 1,449.00 1,449.00 1,449.00
Sokowski, T. M 2 8 8 8 8 8 8 8 8 8 8 80 2,050.00 2,050.00 127.10 29.73 272.00 62.94 1.64 79.08 1,477.51 2,050.00 2,050.00 2,050.00
(Student) S 1 8 8 8 4 8 8 8 8 8 4 72 7.50 540.00 540.00 33.48 7.83 33.00 16.58 0.43 20.83 427.85 540.00 540.00 540.00
Woods, B. S 1 8 8 8 8 8 8 8 8 8 72 1,200.00 1,200.00 74.40 17.40 132.00 36.84 0.96 46.29 892.11 1,200.00 1,200.00 1,200.00
TOTALS 14,067.69 363.40 14,431.09 894.73 209.27 1,159.00 443.05 11.55 556.72 0.00 16.00 0.00 11,140.77 14,431.09 14,431.09 0.00 0.00 2,307.69 3,330.00 3,600.00 5,193.00
Payday, December 14, 20-- For Period Ending December 12, 20-- Checkpoints
Russell, V. Total earnings
Net paid
TOTALS
Payday, December 18, 20-- For Period Ending December 12, 20-- Checkpoints
Bonno, A. 5 9.00 Total earnings
Ferguson, J.









DEPARTMENT OCCUPATION WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE
Plant Mixer Operator PA M F 537-10-3481 BONNO Anthony Victor
x
OTHER DEDUCTIONS INFORMATION SALARY $ W/H MARITAL
GROUP INSURANCE UNIION DUES OTHER WEEKLY RATE $ ALLOW. STATUS
$55,000 --$.30/M $8 each pay HOURLY RATE $ 17.65 4 M
OVERTIME RATE $ 26.48
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE 10,293.40 1,028.60 11,322.00 701.96 164.17 810.00 347.59 9.06 436.78 216.80 8,635.64
1 10/9 80 17.65 1,412.00 0.00 12,734.00 87.54 20.47 54.00 43.35 1.13 54.47 8.00 672 1,143.04
2 10/23 80 17.65 1,412.00 4 26.48 105.92 14,251.92 94.11 22.01 64.00 46.60 1.21 58.56 24.50 682 1,206.93
3 11/6 80 17.65 1,412.00 0.00 15,663.92 87.54 20.47 54.00 43.35 1.13 54.47 8.00 692 1,1 Dot Image
Tutorials for this Question
  1. Tutorial # 00137516 Posted By: solutionshere Posted on: 11/29/2015 11:49 PM
    Puchased By: 2
    Tutorial Preview
    D.M48888888888801,350.001,350.0083.7019.5848.0041.451.0852.086751,104.111,350.001,350.001,350.001,350.001,350.00O'Neill, J.M38888888888802,307.692,307.69143.0833.46204.0070.851.8589.036761,765.422,307.692,307.692,307.69Russell, V.S1888888888880690.00690.0042.7810.0154.0021.180.5526.62677534.86690.00690.00690.00690.00690.00Ryan, N....
    Attachments
    SOLN.ZIP (18.96 KB)

Great! We have found the solution of this question!

Whatsapp Lisa