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...
-
If you were offered $1,079.50 ten years from now in return for an investment of $500 currently, what annual rate of interest would you earn if you took the offer?
-
The life, in years, of a certain type of electrical switch has an exponential distribution with an average life 0 = 2. If 100 of these switches are installed in different systems, what is the...
-
True or False: If \(P W>0\), then \(I R R>M A R R\).
-
Tribke Enterprises collected the following data from its financial reports for 20X3: Stock price ............. $18.37 Inventory balance .........$300,000 Expenses (excluding OGS) .... $1,120,000...
-
1. (a) Make a sketch of the region D that is being integrated over by the following sum of integrals: 2-x2 Lo L " 1 dydx + === 1 dydx (b) Write ONE polar double integral whose value is the same as...
-
HealthFull Nurse-Run Clinic: Table 6.2 analyzes appointments that are lost (cannot be scheduled) because of limits to capacity. However, another problem at HealthFull Clinic is cancelled...
-
You are asked to use synthesis to write an argument. Take a specific position on an issue and support that position with information, reasons, and/or interpreted images. In other words, you must...
-
Name and describe the good or service you have selected. Include the brand name. Describe how this good or service is used. Describe at least three inputs needed to produce this good or service....
-
(1) The Chesapeake colonists experienced shorter, less fertile lives than their New England counterparts. (2) In 1640, for example, Chesapeake migrants had no more than a 50 percent chance of...
-
Now create a fifth table called cd titles. Include these columns; cd_title, cd_name, artist_id no. add a foreign key constraint that references the primary key in the cd_musicians table.
-
Show your understanding of the garbage can model by explaining what might be in the garbage can for decision making related to 3 of the 4 elements of the model (what is in garbage can from the...
-
Assuming Suppose that Katie is a big movie fan and enjoys renting movies from the local video rental outlet. Assume that she is willing to pay $10 for the first movie she rents for the weekend but...
-
The following financial statements apply to Baird Company: Revenues Expenses Cost of goods sold Selling expenses General and administrative expenses Interest expense Income tax expense Total expenses...
-
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...
-
Consider a strictly increasing and strictly concave utility function \(u\) and suppose that there exist \(N\) risky assets whose returns \(\left(\tilde{r}_{1}, \ldots, \tilde{r}_{N} ight)\) admit the...
-
Given an arbitrary frontier portfolio \(w^{*}\), with \(w^{*} eq w^{\mathrm{MVP}}\), there exists a unique frontier portfolio \(w^{\mathrm{zc}}\) such that...
-
Consider a strictly increasing and strictly concave utility function \(u\) and suppose that there exist a risk free asset with return \(r_{f}>0\) and \(N\) risky assets whose returns...
Study smarter with the SolutionInn App