Question
fill in blanks
Regular Pay: Overtime Pay: $12.00 per hour 1.5 x regular pay for hours over 40 2:00 Name: Karen Brown DATE IN MON 4-Jan 8:00
1 0
Add a comment Improve this question Transcribed image text
Answer #1
Hours Rate Amount
Regular 40 12 480
Overtime 6 18 108
Gross Earnings 588

Workings

Karen Brown
Day Hours
Mon 8
Tue 7.75
Wed 7.75
Thu 7.5
Fri 8
Sat 7
TOTAL 46

Book1- Excel AutoSave Oi Sign in Comments Share File Home Formulas Review View Help OTell me what you want to do Insert Draw

Add a comment
Know the answer?
Add Answer to:
fill in blanks Regular Pay: Overtime Pay: $12.00 per hour 1.5 x regular pay for hours...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • fill in blank Regular Pay: Overtime Pay: $8.50 per hour 1.5 x regular pay for hours...

    fill in blank Regular Pay: Overtime Pay: $8.50 per hour 1.5 x regular pay for hours over 40 Name: Frank Smith DAY DATE IN MON 6 Apr 8:00 TUES 7 -Apr 8:00 WED 8-Apr 7:45 THUR 9.Apr 7:45 FRI 10 Apr 8:15 11.Apr 10:00 Frank Smith Hours Rate Amount OUT IN OUT HOURS 12:00 12:30 6:00 12:30 1:00 5:00 11:15 11:45 4:30 11:30 12:00 4:30 1:00 1:30 3:00 Total Hours Worked Regular Overtime SAT Gross Earnings

  • fill in blanks HOURS Regular Pay: Overtime Pay: $9.90 per hour 1.5 x regular pay for hours over 40 Name: Bill Johnso...

    fill in blanks HOURS Regular Pay: Overtime Pay: $9.90 per hour 1.5 x regular pay for hours over 40 Name: Bill Johnson DAY DATE IN OUT IN OUT MON 15-Dec 11:00 3:00 4:00 TUES 16-Dec 11:15 3:00 4:00 7:00 WED 17-Dec 11:15 3:00 4:00 7:00 THUR 18-Dec 11:003:00 4:00 7:00 FRI 19-Dec 11:00 3:00 3:30 7:00 Total Hours Worked Hours Rate Amount Bill Johnson Regular Overtime Gross Earnings

  • fill in blank Name: Ted Hall HOURS DAY DATE IN OUT IN OUT 1-Aug 5:00 9:00 Regular Pay: $8.70 per hour MON TUES 2-Aug...

    fill in blank Name: Ted Hall HOURS DAY DATE IN OUT IN OUT 1-Aug 5:00 9:00 Regular Pay: $8.70 per hour MON TUES 2-Aug 4:00 Overtime Pay: 1.5 x regular pay for hours over 40 8:00 2 x regular pay for all Sunday hours 6:30 12:00 WED 3-Aug 11:00 5:00 Ted Hall THUR 6:45 12:00 3:00 4-Aug 11:30 Hours Rate Amount Regular FRI 5-Aug 9:00 1:00 1:30 5:30 Overtime at 1.5 x SAT 6-Aug 5:00 9:00 Overtime at 2 x...

  • 1.Calculate the Regular Pay and Overtime Pay based on a regular 40-hour workweek in cells F5...

    1.Calculate the Regular Pay and Overtime Pay based on a regular 40-hour workweek in cells F5 and G5 respectively. Pay overtime only for overtime hours. Note that the base work hours and overtime rate is given under the Assumptions section of the Payroll Data worksheet. In cell H5, calculate the Gross Pay based on the regular and overtime pay. 2. Write a formula in cell I5 to calculate the Taxable Pay. Multiply the number of dependents (given in column C)...

  • Exam # 1 (2) - Word (Product Activation Failed) Mailings Review View Tell me what you...

    Exam # 1 (2) - Word (Product Activation Failed) Mailings Review View Tell me what you want to do. T. Tyler Jacob is paid $15 per hour for a 40-hour work week with time-and-a-half for overtime, which is not charged to specific jobs. For the week of March 4. 10, Tyler's labor time record was as follows: Mon Tues Wed Thur Fri Sat Total Job B280 8 5 6 10 10 2 41 Machine maintenance 2 1 7 Total 8...

  • Code in PYTHON I have a small company. I need a payroll system that calculates the...

    Code in PYTHON I have a small company. I need a payroll system that calculates the pay and taxes for each employee. I have the following input files: • EmployeeData ENum,ELName,EFName,Work Area,HrlyRate 1101,Davis,Mike,7,24.85 1385,Smith,William,1,19.50 1524,White,James,3,23.50 1998,Stuart,Mary,1,25.00 2358,Scott,Richard,4,20.00 2765,Mills,Jason,5,21.00 2945,Schultz,Cindy,7,23.50 4789,Moffett,William,3,30.00 5304,Rangel,Ken,2,28.00 5521,Rodriguez,Teresa,4,29.00 6447,Butler,Craig,2,18.50 6512,Russell,Don,6,26.00 6614,Wilson,Keith,1,28.50 6749,Johnson,Darrell,6,32.00 7325,Butler,Eileen,4,17.00 7886,Williams,Gina,1,21.00 8356,Roberts,Judy,8,23.00 8466,Soto,Glen,8,22.50 9458,Cooper,Lia,4,26.50 9896,Bonds,Lisa,5,27.00 • TaxTable LRange,URange,TaxAmt 0.01,200.00,20.00 200.01,400.00,50.00 400.01,600.00,75.00 600.01,800.00,100.00 800.01,1000.00,120.00 1000.01,1200.00,150.00 1200.01,1400.00,180.00 1400.01,1600.00,220.00 1600.01,1800.00,250.00 1800.01,2000.00,300.00 2000.01,2200.00,325.00 2200.01,2500.00,350.00 starting at zero and ending at 2,500.00. • TimeCardData ENum,Day,DailyHours 1101,FRI,8.00 1101,MON,8.00 1101,THU,8.00...

  • IN PYTHON ONLY !! Program 2: Re-work program #5 (WeeklyHours) from the previous assignment such that...

    IN PYTHON ONLY !! Program 2: Re-work program #5 (WeeklyHours) from the previous assignment such that 1. The program prints out the day an employee worked most hours. 2. The program outputs are displayed in ascending order (stored) by Weekly Hours. Notice that we modifying method addHours()to display the outputs sorted by total weekly hours for each employee as shown below. Sample run 1: Employees Data:            Mon Tue Wed Thu Fri Sat Sun Employee1   5    3    2    9    6   ...

  • Based on the number of patients arriving at an emergency room in a local hospital, the...

    Based on the number of patients arriving at an emergency room in a local hospital, the scheduling manager determines that following number of nurses are needed for each day of a week: Mon Tue Wed Thur Fri Sat Sun 5 7 9 8 10 9 5 The manager hires nursing graduates. Assume each hired graduate will work consecutively for 4 days followed by 3 days off. Formulate the problem as an Linear Program to create a shift schedule for the...

  • IN PYTHON the original problem was Design (pseudocode) and implement (source code) a program (name it...

    IN PYTHON the original problem was Design (pseudocode) and implement (source code) a program (name it WeeklyHours) to compute the total weekly hours for 3 employees. The program main method defines a two-dimensional array of size 3x7 to store employers’ daily hours for the week. Each row represents one employee and each column represent one day of the week such that column 0 designates Monday, column 1 designates Tuesday, etc. The program main method populates the array with random numbers...

  • a) Calculate the Overtime Hours (Column F). The formula for Overtime Hours is based on each...

    a) Calculate the Overtime Hours (Column F). The formula for Overtime Hours is based on each employee’s Total Hours Worked and is dependent on which department the employee works in. If the Total Hours Worked (column D) is greater than the assigned hours designated by the employee’s department (as listed in the table on rows 24 and 25), then the Overtime Hours is the Total Hours Worked minus the assigned hours. If the employee’ Total Hours Worked are less than...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT