Reference no: EM133014325

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.