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