Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Case Study: For a weekly pay period, you know the following information about the payroll at Hopper Industries in Brampton. Friday is a statutory holiday.
Case Study: For a weekly pay period, you know the following information about the payroll at Hopper Industries in Brampton. Friday is a statutory holiday. Christie receives an annual salary of $44,880 based on a 36-hour workweek comprised of four, nine-hour days. She has two hours of overtime at time-and-a-half and did not work the statutory holiday. Marie is paid $16.75 per hour based on eight-hour days and a 40-hour workweek. All premium wages are paid at regulatory minimums. From Sunday to Saturday, she worked 8,0, 8, 8, 8, 3, and 8 hours, respectively. She will not receive another day off in lieu of the statutory holiday. Norm receives a graduated commission of 2.25% on his first $100,000 in sales and 4.15% on anything higher. His sales for one week were $123,000. Ignore his holiday or statutory earnings in your calculations. . Garth is paid a straight piecework wage of $1.12 per unit produced. He worked a total of 30 hours during the week, producing one unit every five minutes. Ignore his holiday or statutory earnings in your calculations. For all employees combined, determine the total regular earnings, overtime earnings, holiday earnings, and holiday worked earnings that Hopper Industries must report on its weekly company payroll report. Please prepare payrolls report using the excel document
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started