Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Employee Data A B D E F G - j Last Employee ID First Name H How many Total individual Status Hours days Worked worked?
Employee Data A B D E F G - j Last Employee ID First Name H How many Total individual Status Hours days Worked worked? Prior Med Hourly Exp Cover Rate Street Address Name 1 1 F F 15 1 S P 0 0 10 16 S F 14 1 2 101 3 102 4 103 5 104 6 105 35 134 36 135 Pollie Berry Smith Bread Brake Connors Healey Rollie 123 Here Rd Harry 54 There Ave Fred 1900 West St Fred 301A Main St Jake 2938 Where Cres Connie 345 Cherry Ln Trudy 876 Some Hill 6 S $10 $20 $25 $15 $15 $10 $20 P 12 1 1 9 S F 11 2 S P 0 0 10 S F 0 0 Employee Payroll ID Take Home Pay 1 2 3 A B C D E F G H Hours Overtime Income Employee Day of Regular Overtime Total Medical Worked Hours that Tax Month Pay Pay Pay Deduction that Day Day Deduction 119 15 7 $160.00 $210.00 $370.00 $14.80 $138.75 118 9 0 $135.00 $0.00 $135.00 $10.80 $50.63 128 1 8 0 $80.00 $0.00 $80.00 $3.20 $30.00 1 7 0 $70.00 $0.00 $70.00 $2.80 $26.25 108 15 6 0 $120.00 $0.00 $120.00 $4.80 $45.00 119 15 10 2 $160.00 $60.00 $220.00 $8.80 $82.50 1 1 $216.45 $73.58 $46.80 $40.95 $70.20 $128.70 4 5 35 36 106 Controls C D 1 E F How does the change in the highest pay rate affect the total take home pay so far? $3,108.73 $23.00 $3,088.84 $25.00 $3,108.73 $28.00 $3,138.56 $30.00 $3,158.45 A B Years of Prior Pay Rate Experience Per Hour 2 0 $10.00 3 5 $15.00 4 10 $20.00 5 15 $25.00 6 Type of Controls 7 Coverage S Medical Deduction 8 Rate 4% 9 10 Income Tax Rate 37.5% 11 12 Overtime Multiplier 1.5 8% Select the best formula for: 'Employee Payroll!!12 Income Tax Deduction is 37.5%, as given on the Controls sheet =Employee Payroll!G2*(1+0.375) =G2*(1+Controls!$B$10) =Employee Payroll!G2*(1+Controls! $B$10) =G2*(1+0.375) =Employee Payroll!G2*37.5% =G2*Controls!$B$10
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started