Power Bi homework
gorrin
MannersPayroll.xlsxSheet1
| Manners Payroll | |||||||||||||||||||
| Pay Period January 1-7, 2020 | |||||||||||||||||||
| Last Name | Fisrt Name | Employee # | Hourly Wage | Hours Worked | Regular Salary | OT Hourly Wage | OT Hours Worked | OT Salary | Gross Pay | Federal Income Tax | State Income Tax | FICA | Social Security Tax | Health Insurance | Dental Insurance | 401K | Union Dues | Stock Option Plan | Net Pay |
| Smith | John | 31496 | 21.75 | 40 | $870.00 | $163.13 | 5 | $1,033.13 | $45,240.00 | $3,619.20 | $2,714.40 | $1,809.60 | $1,357.20 | $70.19 | $3.25 | $867.50 | $35,666.16 | ||
| Thomas | Aaron | 29931 | 23.9 | 31 | $740.90 | $0.00 | 0 | $740.90 | $38,526.80 | $3,082.14 | $2,311.61 | $1,541.07 | $1,155.80 | $114.80 | $5.80 | $10.00 | $738.40 | $30,315.57 | |
| Mcdonald | Jacob | 13764 | 27.15 | 40 | $1,086.00 | $40.73 | 1 | $1,126.73 | $56,472.00 | $4,517.76 | $3,388.32 | $2,258.88 | $1,694.16 | $114.80 | $5.80 | $1,083.50 | $3.25 | $44,492.28 | |
| Cunnigham | Brenda | 41392 | 20 | 40 | $800.00 | $300.00 | 10 | $1,100.00 | $41,600.00 | $3,328.00 | $2,496.00 | $1,664.00 | $1,248.00 | $70.19 | $3.25 | $10.00 | $797.50 | $32,790.56 | |
| Tope | Jennifer | 33277 | 22.1 | 29 | $640.90 | $0.00 | 0 | $640.90 | $33,326.80 | $2,666.14 | $1,999.61 | $1,333.07 | $999.80 | $70.19 | $3.25 | $10.00 | $638.40 | $26,254.73 | |
| Tannucci | Matthew | 34930 | 21.98 | 22 | $483.56 | $0.00 | 0 | $483.56 | $25,145.12 | $2,011.61 | $1,508.71 | $1,005.80 | $754.35 | $114.80 | $5.80 | $10.00 | $481.06 | $19,744.04 | |
| Stones | Greg | 21543 | 24.12 | 40 | $964.80 | $217.08 | 6 | $1,181.88 | $50,169.60 | $4,013.57 | $3,010.18 | $2,006.78 | $1,505.09 | $70.19 | $3.25 | $962.30 | $3.25 | $39,560.54 | |
| Ropes | Angela | 27130 | 24.85 | 40 | $994.00 | $260.93 | 7 | $1,254.93 | $51,688.00 | $4,135.04 | $3,101.28 | $2,067.52 | $1,550.64 | $114.80 | $5.80 | $10.00 | $991.50 | $40,712.92 | |
| Dovens | Grace | 19965 | 28.25 | 38 | $1,073.50 | $0.00 | 0 | $1,073.50 | $55,822.00 | $4,465.76 | $3,349.32 | $2,232.88 | $1,674.66 | $114.80 | $5.80 | $10.00 | $1,071.00 | $3.25 | $43,978.78 |
| Bruce | Timothy | 21063 | 25 | 40 | $1,000.00 | $487.50 | 13 | $1,487.50 | $52,000.00 | $4,160.00 | $3,120.00 | $2,080.00 | $1,560.00 | $114.80 | $5.80 | $997.50 | $3.25 | $40,959.40 | |
| Rock | Louise | 31380 | 21.06 | 40 | $842.40 | $473.85 | 15 | $1,316.25 | $43,804.80 | $3,504.38 | $2,628.29 | $1,752.19 | $1,314.14 | $114.80 | $5.80 | $10.00 | $839.90 | $3.25 | $34,485.19 |
| Harris | Jack | 22619 | 24.75 | 40 | $990.00 | $742.50 | 20 | $1,732.50 | $51,480.00 | $4,118.40 | $3,088.80 | $2,059.20 | $1,544.40 | $70.19 | $3.25 | $10.00 | $987.50 | $3.25 | $40,595.76 |
| Jones | Kevin | 47318 | 20 | 15 | $300.00 | $0.00 | 0 | $300.00 | $15,600.00 | $1,248.00 | $936.00 | $624.00 | $468.00 | $70.19 | $3.25 | $10.00 | $297.50 | $12,250.56 | |
| Catamore | Dennis | 45601 | 21 | 40 | $840.00 | $252.00 | 8 | $1,092.00 | $43,680.00 | $3,494.40 | $2,620.80 | $1,747.20 | $1,310.40 | $114.80 | $5.80 | $10.00 | $837.50 | $34,386.60 | |
| Manchester | Michael | 39393 | 22 | 40 | $880.00 | $396.00 | 12 | $1,276.00 | $45,760.00 | $3,660.80 | $2,745.60 | $1,830.40 | $1,372.80 | $70.19 | $3.25 | $877.50 | $3.25 | $36,076.96 |
