Purchase Solution

# Overtime Excel

Not what you're looking for?

Overtime

You run a company with 6 employees. Create a spreadsheet that keeps track of the hours each employee works and determines their weekly salary. If they work 40 hours or less, they simply get their hourly wage times the number of hours worked. If they work overtime, anything over 40 hours gets paid time and a half; so 2 overtime hours gets paid for 3 hours worked.

a.) Compute the hours worked for the week for each employee.

b.) Enter a formula which computes the hours worked over 40 for each employee. If they worked no more than 40 hours, this formula should return 0.

c.) Enter a formula which computes the total weekly wage for the employees. The formula should give time and a half for any hours worked over 40. Format as currency to 2 decimal places.

Activity Description:
In this problem, you will calculate the total hours each employee worked and determine their weekly salary.

Steps to Perform:
1 Start Excel. Download and open the workbook named: Activity 3 Overtime

2 In cell I12, calculate the hours worked for the week by Jill Ackers. Fill cell I12 down the column to cell I17.

3 In cell I21, use the IF function to determine the hours worked over 40 by Jill Ackers. If the employee worked no more than 40 hours, the formula should return 0. Fill cell I21 down the column to cell I26.

4 In cell I30, use the IF function to calculate the total weekly wage for Jill Ackers. Fill cell I30 down the column to cell I35. Format cells I30:I35 as Currency with 2 decimal places.
Note: The formula should give time and a half for any hours worked over 40.

##### Solution Summary

All formulas, computations and solutions are in the Excel file.

Solution provided by:
###### Education
• MSc, California State Polytechnic University, Pomona
• MBA, University of California, Riverside
• BSc, California State Polytechnic University, Pomona
• BSc, California State Polytechnic University, Pomona
###### Recent Feedback
• "Excellent work. Well explained."
• "Can you kindly take a look at 647530 and 647531. Thanks"
• "Thank you so very much. This is very well done and presented. I certainly appreciate your hard work. I am a novice at statistics and it is nice to know there are those out there who really do understand. Thanks again for an excellent posting. SPJ"
• "GREAT JOB!!!"
• "Hello, thank you for your answer for my probability question. However, I think you interpreted the second and third question differently than was meant, as the assumption still stands that a person still independently ranks the n options first. The probability I am after is the probability that this independently determined ranking then is equal to one of the p fixed rankings. Similarly for the third question, where the x people choose their ranking independently, and then I want the probability that for x people this is equal to one particular ranking. I was wondering if you could help me with this. "

##### Free BrainMass Quizzes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

##### Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

##### Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

##### Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media