Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me in this basic maths assignment Q1You are considering some changes for some particular employees. a. If Jack Grey worked 40 hours per

Please help me in this basic maths assignment

Q1You are considering some changes for some particular employees.

a. If Jack Grey worked 40 hours per week and got a raise to $25 per hour, what would be his net pay?

b. Compared to the current week, if next week Samantha Collin's hourly wage was raised to $10 but she worked just

30 hours, what would be the difference in her net pay?

c. The bakery is considering having employees contribute a higher percentage of their regular pay to their

retirement. What would be the new retirement amount for Mike Nitsch, Gwen Manchester, and Stephanie Baker, if the retirement percentage was increased 0.50% for each of the three regular pay categories?

Q2As the human resource manager you need to optimize the payroll of your managers by correcting the overlap hours for Managers on Duty. The total amount of time you need to each manager is 30 hours a week. What is the amount that would save in net pay on a weekly basis and over the course of the year if you implemented this strategy?

Q3You are thinking of scheduling one driver in the morning and one driver in late afternoon for a total of 3 hours a day for each driver (7 days a week). What is the amount you would save in regular pay on a weekly basis and over a course of the year if you implement this strategy?

image text in transcribed
Comer Bakery Payroll Report Date: HOWHE Hour Pay After Pre-Tex Gotin Federal Federal Employcen Job Position Worked Jack Grey Chef Wage Regular Pay Retirement Deductions Security 5 1800 8 525.00 5 17840 Net Pay Busan Grey Chef $1375 5101 83 9 350,85 40 $1500 1600.00 $ 18.00 Mary Viright Chef $ 982.00 $ 18.92 61 18.40 1353 5 16,00 350 00 6 7:00 5 343-03 STL13 5 68.80 John Berry 263 25 Cashier 33 5 10.00 5 130 00 $ 79.73 Collyn Bear Cashier 323.40 $ 75 19 6 10,00 248 21 120.00 5 0.40 8 313 60 Wait Staff $10 19 23 $ 7291 Chris Hill 6 240.05 8 7 00 $ 161 00 5 3.22 3 137.78 Laura Goodwin Wait Staff 9 5.13 3 31.30 $ 7.00 $ 30 08 5 121.10 6210.00 5 205 30 Samantha Colons Wait Staff 34 $ 41.16 947 83 157.95 Wait Staff 25 $ 7,00 6 238.00 5470 8 233 24 Ed Loyd $ 7.00 $ 40.05 $ 175 00 9 3.50 8 171.50 5 179 01 $537 Steve Little $ 34.30 $ 39 87 Driver 28 9 8.DO $ 131 03 $ 7.13 Dover 42 $ 224.00 5 4.48 Mike Nitsch 8 215-52 $ 330 00 $ 43.90 5 108:43 56 72 8 325. 28 Manager 8 10.70 Gwen Manchester 9 252. 12 Stephanie Baker Manager 5 15,00 $ 140,00 5 1800 $ 075.00 $ 16.20 8 923 80 $ 17 03 $ 21 28 $ 104 76 5 1 30.95 5 121.78 5 132 23 402.02 9 102 52 Total Average Manmum Minimum 438 $ 134.00 $ 4084.00 $ 117.08 $ 4,506.92 9 360.31 $ 148.42 33.7 $ 10 31 $ 11.42 $ 912 38 $901 $ 1.00181 $ 331.30 $ 3.508 71 45 $ 15 00 $ 675.00 5 20 28 $ 084.73 $ 21.28 $ 70 20 581 08 $205.63 5 130.93 $ 152 23 $ 502 52 7.00 5 101.00 $ 3.22 5 157.78 8 5.13 531.30 $ 30.08 5 127, 10 Assumptions Box #T Tax Information Social Security Tax 3.23% Federal Tax Annual Income Baseline $ 38,000 00 Income Tax Bracket # 1 25.00% Income Tax Bracket #2 Assumption Box #1 Retirement Contribution Scale Retirement Regular Pay Percentage 5- 20 $ 400 00 800.DO

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Core Concepts Financial Analysis

Authors: Gary Giroux

1st Edition

047146712X, 9780471467120

More Books

Students also viewed these Accounting questions

Question

Question 3 of 4

Answered: 1 week ago