Scenario: You are the payroll manager at Widgets R Us. You need to calculate an employee's gross and net pay based on th
Posted: Fri Jul 01, 2022 9:08 am
- Scenario You Are The Payroll Manager At Widgets R Us You Need To Calculate An Employee S Gross And Net Pay Based On Th 1 (58.24 KiB) Viewed 35 times
- Scenario You Are The Payroll Manager At Widgets R Us You Need To Calculate An Employee S Gross And Net Pay Based On Th 2 (58.24 KiB) Viewed 35 times
- Scenario You Are The Payroll Manager At Widgets R Us You Need To Calculate An Employee S Gross And Net Pay Based On Th 3 (58.34 KiB) Viewed 35 times
- Scenario You Are The Payroll Manager At Widgets R Us You Need To Calculate An Employee S Gross And Net Pay Based On Th 4 (33.73 KiB) Viewed 35 times
Scenario: You are the payroll manager at Widgets R Us. You need to calculate an employee's gross and net pay based on the table below. The work week for this company is 40 hours. Sandy worked overtime this past week and would like to know what her gross and net pay will be. Sandy worked 48 hours for the week in question. Five (5) of the overtime hours were worked during a holiday, which are paid at double-time and the other three (3) overtime (over 40 hours) are paid at time-and-a-half. The timecard Sandy submitted declares the eight (8) overtime hours to be holiday pay. As the new manager, your job is to calculate her overtime correctly while demonstrating your understanding of ethics. Create your spreadsheet to calculate Sandy's pay. Prepare a Word document that explains your process. In the first paragraph write at least 100 words to explain how you will create the spreadsheet, the formulas, and functions you will use to calculate the hours worked, federal tax rate, state tax rate, FICA, Sandy's Gross pay, and Sandy's Net pay. Make sure you indicate which steps you will perform first and why (or if) the order is important.
After calculating the pay, write a professional memo to Sandy explaining why only five (5) hours were paid as holiday pay. The memo will be included in the second paragraph of the Word document. Write at least 100 words. In your explanation, include a summary of the company's policy, the ethics involved in accurately reporting time, and why it is important that Sandy report her time more accurately in the future. Conclude the document with your name and title. Assignment Requirements Note: The company policy is that Sandy is entitled to time-and-a-half for any hours worked over 40 and double-time for holiday hours. The overtime and holiday pay must be included in the paycheck and available by the end of the work week. Using Excel, calculate Sandy's gross pay and net pay. You must use a function(s) or formula(s).
Pay Rate: $10.00/Hour Hours Worked: Sandy's Gross Pay See above Federal Tax Rate: State Tax Rate: FICA Sandy's Net Pay 20% 10% 5%