If the Overtime Rate is changed to 2 times the Regular Rate, how many employees would...

Transcribed Image Text:

If the Overtime Rate is changed to 2 times the Regular Rate, how many employees would earn a Net Pay more than $400? What is the total Net Pay for all employees? 2. If the Federal Tax Rate increases to 23%, how many employees earn Net Pay of more than $400? 3. Michael Dillon's boss is considering giving him a pay raise to $13.75 an hour. By how much would his Gross Pay change? Net Pay? Prepared by: Fed Tax Rate: SS Tax Rate: State Tax Rate: Overtime Rate: Employee Name Abbey Alvarez Aisha Callahan Clara Calderon Gregory Woods Kelly Larsen Kobe Fields Michael Dillon Philip Moore Sum 0.2 0.1 0.0 1.50 Employee ID 21875 21154 23455 27855 31851 33252 37881 29958 Pay Rate 10.25 12.75 12.25 11.50 13.25 13.95 12.75 14.25 Cookie Kingdom Shop Home Office Payroll Regular Hours 40 35 40 40 32 40 40 40 Regular Pay 410.00 446.25 490.00 460.00 424.00 558.00 510.00 570.00 Overtime Hours 2 NO6O 0 0 3.5 5.5 4.0 O Overtime Pay 20.50 0.00 73.50 0.00 46.38 76.73 51.00 0.00 Gross Pay 430.50 446.25 563.50 460.00 470.38 634.73 561.00 570.00 4,136 Fed Tax 86.10 89.25 112.70 92.00 94.08 126.95 112.20 114.00 827.27 SS Tax 43.05 44.63 56.35 46.00 47.04 63.47 56.10 57.00 413.64 State Tax 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Net Pay 301.35 312.38 394.45 322.00 329.27 444.31 329.70 399.00 2,895.45 If the Overtime Rate is changed to 2 times the Regular Rate, how many employees would earn a Net Pay more than $400? What is the total Net Pay for all employees? 2. If the Federal Tax Rate increases to 23%, how many employees earn Net Pay of more than $400? 3. Michael Dillon's boss is considering giving him a pay raise to $13.75 an hour. By how much would his Gross Pay change? Net Pay? Prepared by: Fed Tax Rate: SS Tax Rate: State Tax Rate: Overtime Rate: Employee Name Abbey Alvarez Aisha Callahan Clara Calderon Gregory Woods Kelly Larsen Kobe Fields Michael Dillon Philip Moore Sum 0.2 0.1 0.0 1.50 Employee ID 21875 21154 23455 27855 31851 33252 37881 29958 Pay Rate 10.25 12.75 12.25 11.50 13.25 13.95 12.75 14.25 Cookie Kingdom Shop Home Office Payroll Regular Hours 40 35 40 40 32 40 40 40 Regular Pay 410.00 446.25 490.00 460.00 424.00 558.00 510.00 570.00 Overtime Hours 2 NO6O 0 0 3.5 5.5 4.0 O Overtime Pay 20.50 0.00 73.50 0.00 46.38 76.73 51.00 0.00 Gross Pay 430.50 446.25 563.50 460.00 470.38 634.73 561.00 570.00 4,136 Fed Tax 86.10 89.25 112.70 92.00 94.08 126.95 112.20 114.00 827.27 SS Tax 43.05 44.63 56.35 46.00 47.04 63.47 56.10 57.00 413.64 State Tax 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Net Pay 301.35 312.38 394.45 322.00 329.27 444.31 329.70 399.00 2,895.45