Make an Excel spreadsheet to compute gross wages due each employee under federal wage-hour law. See notes below. Ryan is normally paid $1,000 for a 40-hour workweek. One week, he works 46 hours. Latisha is normally paid $1,200 for a 40-hour workweek. One Monday she is out sick but receives 8 hours sick pay. She then works 40 hours Tuesday–Friday. Al is normally paid $500 for a 40-hour workweek. One week, he works 45 hours. Lee is normally paid $1,500 for a 40-hour workweek. To make up for leaving early one Friday, he works 44 hours this week.

Make an Excel spreadsheet to compute gross wages due each employee under federal wage-hour law. See notes below. Ryan is normally paid $1,000 for a 40-hour workweek. One week, he works 46 hours. Latisha is normally paid $1,200 for a 40-hour workweek. One Monday she is out sick but receives 8 hours sick pay. She then works 40 hours Tuesday–Friday. Al is normally paid $500 for a 40-hour workweek. One week, he works 45 hours. Lee is normally paid $1,500 for a 40-hour workweek. To make up for leaving early one Friday, he works 44 hours this week.

PAYROLL ACCT.,2019 ED.(LL)-TEXT

19th Edition

ISBN:9781337619783

Author:BIEG

Publisher:BIEG

Chapter2: Computing Wages And Salaries

Section: Chapter Questions

Problem 16PB: Jody Baush is a salaried employee who normally works a 35-hour week and is paid a weekly salary of...

See similar textbooks

Similar questions

Jody Baush is a salaried employee who normally works a 35-hour week and is paid a weekly salary of 735.00. The agreement that he has with his employer states that his salary is to cover all hours worked up to and including 40. This week, Baush worked 42 hours. Calculate his gross pay. Gross pay_________
Make an Excel spreadsheet to compute gross wages due each employee under federal wage-hour law. See notes below. a. Ryan is normally paid $1,000 for a 40-hour workweek. One week, he works 46 hours. b. Latisha is normally paid $1,200 for a 40-hour workweek. One Monday she is out sick but receives 8 hours sick pay. She then works 40 hours Tuesday–Friday. c. Al is normally paid $500 for a 40-hour workweek. One week, he works 45 hours. d. Lee is normally paid $1,500 for a 40-hour workweek. To make up for leaving early one Friday, he works 44 hours this week. THANK YOU FOR YOUR HELP.
Compute gross wages due each employee under federal wage-hour law: Latisha is normally paid $1,200 for a 40-hour workweek. One Monday she is out sick but receives 8 hours sick pay. She then works 40 hours Tuesday–Friday. Al is normally paid $500 for a 40-hour workweek. One week, he works 45 hours. Lee is normally paid $1,500 for a 40-hour workweek. To make up for leaving early one Friday, he works 44 hours this week.
Power is a contract worker. His basic pay is calculated at 40 hours at a normal rate of R50 per hour. In certain week, he worked 40 hours at normal rate. He then worked 13 hours overtime at 1,5 rate of the normal working hours. On Sunday and public holidays, he worked 7 hours at a rate of 2 times the normal rate. Calculate his gross pay. And calculate his net pay if the overtime and abnormal overtime rates remain the same per hour but Power worked for a four week month and that R1200 medical aid contribution is deducted.
Dennis Murphy is a salaried, nonexempt administrative assistant for Dionti Investments and is paid semimonthly. He is married filing joint with five dependents under 17. His annual salary is $91,000, and his standard workweek is 37.5 hours. During the pay period, he worked 10 hours overtime. Find the hourly rate, overtime rate, and the number of regular hours and overtime hours.
Determine the gross pay for each employee listed below. When necessary, round intermediate calculations and the final answer to the nearest cent. Clay Jones is paid time-and-a-half for all hours over 40. He worked 45 hours during the week. His regular pay rate is $25 per hour. $ Mary James worked 48 hours during the week. She is entitled to time-and-a-half for all hours in excess of 40 per week. Her regular pay rate is $20 per hour. $ Lori Terry is paid a commission of 10 percent of her sales, which amounted to $23,650. $ Nicole Smith's yearly salary is $95,500. During the week, she worked 46 hours, and she is entitled to time-and-a-half for all hours over 40. $
6. Compute gross wages due to each employee under federal wage-hour law: а. Nona is a salaried employee and is paid $900 for a 32-hour workweek. One week, she works 40 hours. b. Sal is normally paid $600 for a 40-hour workweek. One week, he works 45 hours.
Morris Lann works for Talbert Electronics. He is a shared employee; he works in the manufacturing department and has been trained to work the sales counter when needed. He was asked to work the sales counter for two days, five hours each day during other employees' vacations. When he works in the manufacturing department, he earns $16.50 per hour. Morris earns a $2.50 pay differential for working the sales counter. He worked a total of 39 hours and 30 minutes during the week. Morris is married filing joint with no dependents. Compute Morris’s pay for the week ending August 20 using the hundredth-hour system. (Do not round intermediate calculations. Round your final answers to 2 decimal places.)
Lenny Florita, an unmarried employee, works 50 hours in the week ended January 12. His pay rate is $11 per hour, and his wages are subject to no deductions other than FICA Social Security, FICA Medicare, and federal income taxes. He claims two withholding allowances. Compute his regular pay, overtime pay (for this company, workers earn 150% of their regular rate for hours in excess of 40 per week), and gross pay. Then compute his FICA tax deduction (use 6.2% for the Social Security portion and 1.45% for the Medicare portion), income tax deduction (use the wage bracket withholding table from 2nd image .), total deductions, and net pay. (Round your intermediate calculations and final answers to 2 decimal places.)
Susan Cejka receives an hourly wage of $11.25 for a 40-hour week of 5 days, 8 hours daily. For Saturday work, she is paid 1.5 times the regular rate. For Sunday work, she is paid 2 times the regular rate. One week, she worked 50 hours—4 hours of which were on Saturday and 6 hours on Sunday. Her total earnings for the week are _____.
Bert Garro is a waiter at La Bron House, where he receives a weekly wage of $75 plus tips for a 40-hour workweek. Garro's weekly tips usually range from $300 to $350. Round your answers to the nearest cent. a. Under the Fair Labor Standards Act, the minimum amount of wages that Garro must receive for a 40-hour workweek is$fill in the blank 1 b. Since La Bron House is in violation of the FLSA, the additional amount it should pay Garro each week to meet the minimum wage requirement for a tipped employee is (Hint: Employer must an additional amount to bring current gross of $75 up to minimum tipped wages.)$fill in the blank 2
Rocky is considering a new job that pays $12 per hour for a company subject to the Fair Labor Standards Act. How much can he expect to make for the year if he were to work an average of 42 hours per week? Assume that there are 52 weeks in a year. Give typing answer with explanation and conclusion