Purchase Solution

Overtime Excel

Not what you're looking for?

Ask Custom Question

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.

Attachments
Purchase this Solution
Solution Summary

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

Solution provided by:
J Pye, MSc
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. "
Purchase this Solution
Free BrainMass Quizzes
Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

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.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Operations Management

This quiz tests a student's knowledge about Operations Management

View More Free Quizzes
Related BrainMass Solutions

  • Payroll and Depreciation : Construction of an Excel Spreadsheet

    Ensure the employee works some overtime and weekend hours. 2. Compute the total regular hours, overtime hours and double time (Sundays) for the employee. 3.

  • Linear Programming / Transportation Problem : Minimizing Cost

    The solution given by Excel Solver was the following production schedule: Week 1: Produce 2 units in Regular, 2 units in Overtime Week 2: Produce 2 units in Regular, 0 units in Overtime Week 3: Produce 1 unit in Regular, 2 units in Overtime An

  • Aggregate production plan

    The excel file contains all the computations and explanations. The formulas used are given in excel sheet also.

  • Lineare Programming:

    Labor costs are $22 per hour using regular production time and $33 using overtime. Greenville has up to 2400 hours of regular production time available each month and up to 1000 additional hours of overtime available each month.

  • ANOVA for Overtime Work

    Calculations are done in excel. List of overtime hours for men: 6 3 6 2.5 5 List of overtime hours for women: 2.5 8 5 3.5 6 Questions: 1.

  • Mat, Piah and Din: Gross wages, direct, indirect wages

    I have created schedules in Excel that walk you through the process of finding base pay, overtime pay, and bonus pay. Then I sort into direct and indirect wages, putting the elements in the classification traditionally expected.

  • Operations and Inventory Utilization

    Please see the Excel files for the solution. A new staffing plan is determined based on seasonal demand patterns.

  • Expand production with overtime or lease another plant

    See the attached Excel file. The solution explains expanding production with overtime or lease another plant.

  • Production Level

    Product Mix and overtime decisions Excel corporation makes 3 products at its plants. The plant capacity is limited to 120,000 machine hours per year on a single shift basis. Direct material and direct labor costs are flexible.

View More Related Solutions