Chapter 7 Payroll Project - Excel Instructions using Excel...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
NAME - LAST FIRST MIDDLE MF x SALARY $ W/H WEEKLY RATE $ ALLOW. HOURLY RATE $ 17.65 OVERTIME RATE $ 26.48 20___ PAYDAY OTHER CK. OASDI HI DEDUCTIONS NO. AMOUNT 10,293.40 1,028.60 11,322.00 701.96 164.17 810.00 347.59 2.26 505.24 216.80 8,573.98 1 10/9 80 17.65 1,412.00 0 26.48 0.00 12,734.00 87.54 20.47 63.00 43.35 1.27 63.01 8.00 672 1,125.36 2 10/23 80 17.65 1,412.00 4 26.48 105.92 14,251.92 94.11 22.01 78.00 46.60 1.37 67.74 24.50 682 1,183.59 3 11/6 80 17.65 1,412.00 26.48 0.00 15,663.92 87.54 20.47 63.00 43.35 1.27 63.01 8.00 692 1,125.36 4 11/20 64 17.65 1,129.60 26.48 0.00 16,793.52 70.04 16.38 33.00 34.68 1.02 50.41 24.50 703 899.57 5 12/4 80 17.65 1,412.00 8 35.30 282.40 18,487.92 105.05 24.57 105.00 52.02 1.52 75.61 8.00 712 1,322.63 6 12/18 80 17.65 1,412.00 12 35.30 423.60 20,323.52 113.81 26.62 108.00 56.35 1.65 81.91 25.50 723 1,421.76 8,189.60 811.92 9,001.52 558.09 130.52 450.00 276.35 8.10 401.69 0.00 98.50 7,078.27 18,483.00 1,840.52 20,323.52 1260.05 294.69 1,260.00 623.94 10.36 906.93 315.30 15,652.25 Checkpoint 9,001.52 Checkpoint NAME - LAST FIRST MIDDLE x SALARY $ 58,500 /yr. W/H WEEKLY RATE $ 1,125.00 ALLOW. HOURLY RATE $ 28.13 OVERTIME RATE $ 20___ PAYDAY OTHER CK. OASDI HI DEDUCTIONS NO. AMOUNT 23,125.00 23,125.00 1433.75 335.31 2,291.00 709.94 4.63 1,031.95 132.30 17,186.12 1 10/9 80 2,250.00 25,375.00 139.50 32.63 171.00 69.08 2.03 100.41 673 1,735.35 2 10/23 80 2,250.00 27,625.00 139.50 32.63 171.00 69.08 2.03 100.41 26.40 683 1,708.95 3 11/6 80 2,250.00 29,875.00 139.50 32.63 171.00 69.08 2.03 100.41 693 1,735.35 4 11/20 80 2,250.00 32,125.00 139.50 32.63 96.00 69.08 2.03 100.41 500.00 26.40 704 1,283.96 5 12/4 80 2,250.00 34,375.00 139.50 32.63 96.00 69.08 2.03 100.41 500.00 713 1,310.36 6 12/18 80 2,250.00 36,625.00 139.50 32.63 96.00 69.08 2.03 100.41 500.00 26.40 1,283.96 13,500.00 0.00 13,500.00 837.00 195.77 801.00 414.48 12.18 602.45 1,500.00 79.20 9,057.93 36,625.00 0.00 36,625.00 2270.75 531.08 3,092.00 1,124.42 16.81 1,634.40 1,500.00 211.50 26,244.05 Checkpoint 13,500.00 Checkpoint S.S. ACCOUNT NO. Plant Mixer Operator PA 537-10-3481 DEPARTMENT OCCUPATION WORKS IN (STATE) SEX GROUP INSURANCE UNIION DUES OTHER STATUS BONNO Anthony Victor OTHER DEDUCTIONS INFORMATION MARITAL M REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID $55,000 --$.30/M $9 each pay 5 AMOUNT EARNINGS FICA HRS. RATE AMOUNT HRS. SEX QTR. TOT. SIMPLE YEAR-TO-DATE FIT SIT SUTA CIT RATE S.S. ACCOUNT NO. Sales Sales Manager PA 486-03-8645 YR. TOT. 20,323.52 DEPARTMENT OCCUPATION WORKS IN (STATE) GROUP INSURANCE UNIION DUES OTHER STATUS FERGUSON James Claude OTHER DEDUCTIONS INFORMATION MARITAL M REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID $88,000 -- $.30/M 500.00 5 AMOUNT EARNINGS FICA HRS. RATE AMOUNT HRS. QTR. TOT. SIMPLE YEAR-TO-DATE FIT SIT SUTA CIT RATE YR. TOT. 36,625.00
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
NAME - LAST FIRST MIDDLE MF x SALARY $ 2,080.00 /mo. W/H WEEKLY RATE $ 480.00 ALLOW. HOURLY RATE $ 12.00 OVERTIME RATE $ 18.00 20___ PAYDAY OTHER CK. OASDI HI DEDUCTIONS NO. AMOUNT 6,300.00 6,300.00 390.60 91.35 639.00 193.41 1.26 281.14 37.80 4,665.44 1 10/9 80 900.00 7,200.00 55.80 13.05 71.00 27.63 0.81 40.16 674 691.55 2 10/23 80 900.00 8,100.00 55.80 13.05 71.00 27.63 0.81 40.16 10.50 684 681.05 3 11/6 80 900.00 9,000.00 55.80 13.05 71.00 27.63 0.81 40.16 694 691.55 4 11/20 80 900.00 9,900.00 55.80 13.05 71.00 27.63 0.81 40.16 10.50 705 681.05 5 12/4 80 960.00 10,860.00 59.52 13.92 80.00 29.47 0.86 42.84 714 733.39 6 12/18 80 960.00 11,820.00 59.52 13.92 80.00 29.47 0.86 42.84 10.50 722.89 5,520.00 0.00 5,520.00 342.24 80.04 444.00 169.46 4.96 246.33 31.50 4,201.47 11,820.00 0.00 11,820.00 732.84 171.39 1,083.00 362.87 6.22 527.47 69.30 8,866.91 Checkpoint 5,520.00 Checkpoint NAME - LAST FIRST MIDDLE x SALARY $ 2,925.00 /mo. W/H WEEKLY RATE $ 675.00 ALLOW. HOURLY RATE $ 16.88 OVERTIME RATE $ 20___ PAYDAY OTHER CK. OASDI HI DEDUCTIONS NO. AMOUNT 5,400.00 5,400.00 334.80 78.30 332.00 165.78 1.08 240.98 31.50 4,215.56 1 10/9 80 1,350.00 6,750.00 83.70 19.58 55.00 41.45 1.22 60.24 675 1,088.82 2 10/23 80 1,350.00 8,100.00 83.70 19.58 55.00 41.44 1.22 60.24 15.90 685 387.92 3 11/6 80 1,350.00 9,450.00 83.70 19.58 128.00 41.45 1.22 60.24 695 1,015.81 4 11/20 80 1,350.00 10,800.00 83.70 19.58 92.00 41.45 1.22 60.24 250.00 15.90 706 785.92 5 12/4 80 1,350.00 12,150.00 83.70 19.58 92.00 41.45 1.22 60.24 250.00 715 801.82 6 12/18 80 1,350.00 13,500.00 83.70 19.58 92.00 41.45 1.22 60.24 15.90 1,035.92 8,100.00 0.00 8,100.00 502.20 117.46 514.00 248.67 7.32 361.46 47.70 5,116.20 13,500.00 0.00 13,500.00 837.00 195.76 846.00 414.45 8.40 602.44 79.20 9,331.76 Checkpoint 8,100.00 Checkpoint SEX S.S. ACCOUNT NO. Office Executive Secretary PA 213-09-4567 DEPARTMENT OCCUPATION WORKS IN (STATE) GROUP INSURANCE UNIION DUES OTHER STATUS FORD Catherine Louise OTHER DEDUCTIONS INFORMATION MARITAL S REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID $35,000--$.30/M 2 AMOUNT EARNINGS FICA HRS. RATE AMOUNT HRS.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/13/2011 for the course AC 354 taught by Professor Worms during the Winter '11 term at Pennsylvania State University, University Park.

Page1 / 39

Chapter 7 Payroll Project - Excel Instructions using Excel...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online