For a weekly pay period, you know the following information about the payroll at Hopper Industries...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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.
Expert Answer:
Answer rating: 100% (QA)
Step 11 Answer is as follow Answer Calculations are as follow NAME WORK HRS WEEKLY PER ... View the full answer
Related Book For
Posted Date:
Students also viewed these general management questions
-
A salesperson receives an annual salary of $6,000 plus 8% of the value of the orders she takes. The annual value of these orders can be represented by a random variable with a mean of $600,000 and a...
-
The Coca-Cola Company reported the following information about its long-term debt in the notes to a recent financial statement (in millions): Long-term debt is comprised of the following: a. How much...
-
An analyst gathered the following information about a company whose fiscal year-end is December 31: Net income for the year was $10.5 million. Preferred stock dividends for $2 million were declared...
-
The inequality describes the range of monthly average temperatures T in degrees Fahrenheit at a certain location. (a) Solve the inequality. (b) If the high and low monthly average temperatures...
-
Explain why the absence of covered interest arbitrage possibilities can be characterized by two inequalities in the presence of bidask spreads in the foreign exchange and external currency markets.
-
An urn contains 17 balls marked LOSE and 3 balls marked WIN. You and an opponent take turns selecting a single ball at random from the urn without replacement. The person who selects the third WIN...
-
Refer to the data in Exercise 13-15. Compute the following financial ratios for the year 2009: Data From Exercise 13-15 Comparative financial statements for the Rahul Corporation for the year ended...
-
FIFO, LIFO, and Average Cost Determination LoBianco Company's record of transactions for the month of April was as follows. (a) Assuming that periodic inventory records are kept, compute the...
-
A project has an initial cost of $60,000, expected net cashinflows of $15,000 per year for 7 years, and a cost of capital of11%. What is the project's PI? (Hint: Begin by constructing a timeline.) 2...
-
Lily Zhang started a new business on January 1, 2020, called Zhang Consulting. She develops financial investment plans for young adults. During the business?s first year of operations, the following...
-
Two simple pendulums with equal lengths (L = 0.956m) and masses (m = 0.426kg) are separated by a distance D = 0.43m. The masses are connected to each other by a spring with un-compressed length D and...
-
Create a class Shape which performs the following. a. Provide a method areaCircle which takes one parameter radius as double, calculates 03 Marks and returns the area of the circle as double....
-
1) If the company changes the selling price per clock from $4,500 to $5,000, this will Decrease the breakeven volume from 100 to 83 clocks. 2) How small can the selling price be before the...
-
Stacy works for Visual Logic. Previously, the company's pool of over 500 000 potential survey respondents would require at least a month to hit the minimum threshold for an accurate survey sample...
-
APPLE'S MARKET CAPITALIZATION in 2001 was $7 billion, while Sony's was $55 billion. Apple introduced the iPod, a portable digital music player, in October 2001, and the iTunes music store 18 months...
-
Background Ant Financial is a major FinTech player and has built an empire which embraces; mobile and online payments, money market funds, comprehensive wealth management, digital banking, credit...
-
Sleep journal: What was your overall experience in logging your sleep? Did you notice any changes from the first week to the second week of your sleep log (keep the bio-psycho-social model in mind...
-
Name some of the various types of financial intermediaries described in the chapter and indicate the primary reason(s) each was created.
-
Assume that David and Tom Gardner of The Motley Fool (Fool.com) have impressed you since you first heard of their rather improbable rise to prominence in financial circles. You learn of a staff...
-
The following is selected financial information for Elko Energy Company for the year ended December 31, 2010: revenues, $66,000; expenses, $51,348; net income, $14,652. Required Prepare the 2010...
-
Maya Companys ending inventory includes the following items. Compute the lower of cost or market for ending inventory (a) As a whole (b) Applied separately to each product. Per Unit Product Units...
-
What are G.E. Moulton's fraud identifiers?
-
Give the percentages when CEOs and CFOs are involved in fraudulent financial fraud cases.
-
What was the pressure on Tracey Henderson, an executive of the Australia Football League, to steal?
Study smarter with the SolutionInn App