Question: Question 3 [20 marks] Using the spreadsheet in Figure 1, answer questions (a) to (c) accordingly. a) Calculate the total amount of hours work and

Question 3 [20 marks] Using the spreadsheet in Figure 1, answer

questions (a) to (c) accordingly. a) Calculate the total amount of hours

Question 3 [20 marks] Using the spreadsheet in Figure 1, answer questions (a) to (c) accordingly. a) Calculate the total amount of hours work and salary for Sally Hertz. Write a formula in E12 and F12. [6 Marks] b) Write a formula to calculate Highest salary in B23. [3 Marks] c) Write a formula to calculate Lowest salary in B24. [3 Marks) d) Write a formula to calculate Average salary in B25. [3 Marks) B D F PAYROLL RECORDS JANUARY 2020 1 2 3 Total Hours Worked Salary 4 Employee 5 John Abhot 6 Terry Burke 7 Linda Carlson 8 Krista Carter 9 John Dole 10 James Erickson 11 Fred Gretchen 12 Sally Hertz 13 Melanie Jackson 14 Peter Lorne 15 Mike McDonald 16 Lyle O'Toole 17 Samantha Reimer 18 William Peterson 19 Randy Wilkes 20 Alex Zimmerman 21 22 23 Highest Salary 24 Lowest Salary 25 Average Salary Hours Overtime Hours 36.00 2.00 40.00 2.00 22.00 2.00 25.00 2.00 39.00 2.00 40.00 9.00 39.00 9.00 13.00 9.00 35.00 9.00 40.00 9.00 19.00 9.00 40.00 5.00 25.00 5.00 33.00 5.00 29.00 5.00 40.00 11.00 Pay Rate (/hour) $12.00 $15.00 $12.00 $15.00 $9.00 $12.00 $20.00 $12.00 $12.00 $12.00 $9.00 $15.00 $12.00 $9.00 $15.00 $12.00 Figure 1

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

FACULTY OF COMMERCE, MANAGEMENT AND LAW Assignment Questions AAM3691/2022 ASSIGNMENT QUESTIONS ASSIGNMENT 1 55 000 QUESTION 1 (30 MARKS) ABC Company ("ABC") is a company that manufactures bill boards...

AAM3691/2022 ASSIGNMENT QUESTIONS ASSIGNMENT 1 QUESTION 1 (30 MARKS) ABC Company ("ABC") is a company that manufactures billboards which is based in Ondangwa. The owner of ABC has little accounting...

Pls I need to know the right way to solve the essay question properly Question 1- 30 marks (1.5 marks each - suggested time 22 minutes) PLEASE CIRCTE THE CORRECT RESPONSE. UNCLEAR RESPONSES WILL NOT...

ROUND-OFF YOUR ANSWER TO THE NEAREST ZERO DECIMAL PLACE!!! Question 2 22 Marks The following information was extracted from JJ Traders books for 31 May 2019 financial year. JJ requested you to assist...

Answer ALL questions in this paper. [100 MARKS] QUESTION 1 (20 Marks) 1.1 REQUIRED Calculate Annes remuneration for 15 April 2022. (4 marks) INFORMATION The normal wage of Anne is R200 per hour and...

FINAL ONLINE SUMMATIVE ASSESSMENT PROGRAMME Bachelor of Business Administration Honours Postgraduate Diploma in Business Management Postgraduate Diploma in Family Business Management MODULE...

could you assist me in completing this pass paper please MGMT2023 Financial Management 1- Final Exam of Semester 2, 2014 Study Guide Exam format & instructions 1) The Final Exam will be 2 hours and...

Help me please. In the month of September, all of the walmart grocery stores in Virginia sold 429,382 eggs. In that same month, all of the walmart grocery stores in Texas sold 283,054 eggs. How many...

For a fully continuous 5-year deferred whole life insurance of 1000, you are given: (i) If death occurs during the deferral period, premiums are refunded without interest. (ii) x++ = 0.02 for 2 0....

Statement of operations. The following are annual account balances as of September 30, 20X1, for Snead Hospital. Prepare the portion of the statement of operations ending with operating income for...

1 3 . Assume that interest rate parity holds, and the euro s interest rate is 9 % while the U . S . interest rate is 1 2 % . Then the euro s interest rate increases to 1 1 % while the U . S ....

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

If the tax rate is 40 percent, compute the beforetax real interest rate and the after-tax real interest rate in each of the following cases. a. The nominal interest rate is 10 percent and the...

Assume that the reserve requirement is 20%. Also assume that banks do not hold excess reserves and there is no cash held by the public. The Federal Reserve decides that it wants to expand the money...

It is often suggested that the Federal Reserve try to achieve zero inflation. If we assume that velocity is constant, does this zero-inflation goal require that the rate of money growth equal zero?...