name: calculating your paycheck - weekly time card 1\nemployees that are paid by the hour must keep a time…

name: calculating your paycheck - weekly time card 1\nemployees that are paid by the hour must keep a time card. the time card lets the employer know when the employee reported for work, when they left and came back from lunch, and when they stopped working each day. total hours worked is the sum of the daily hours worked within a pay period. gross pay is the sum of regular pay and overtime pay. directions: calculate how many hours the following employees worked each day, the total hours they worked for the pay period, and then calculate their earnings.\nname: frank smith\nday date in out in out hours\nmon 6 - apr 8:00 12:00 12:30 6:00\ntues 7 - apr 8:00 12:30 1:00 5:00\nwed 8 - apr 7:45 11:15 11:45 4:30\nthur 9 - apr 7:45 11:30 12:00 4:10\nfri 10 - apr 8:15 1:00 1:30 5:30\nsat 11 - apr 10:00 3:00\ntotal hours worked\nregular pay: $8.50 per hour\novertime pay: 1.5 x regular pay for hours over 40\nfrank smith hours rate amount\nregular\novertime\ngross earnings\nname: karen brown\nday date in out in out hours\nmon 4 - jan 8:00 1:00 2:00 5:00\ntues 5 - jan 8:15 1:00 2:00 5:00\nwed 5 - jan 7:45 12:30 2:00 5:00\nthur 7 - jan 8:00 12:00 1:00 4:30\nfri 8 - jan 7:00 12:00 1:30 4:30\nsat 9 - jan 9:00 1:00 2:00 5:00\ntotal hours worked\nregular pay: $12.00 per hour\novertime pay: 1.5 x regular pay for hours over 40\nkaren brown hours rate amount\nregular\novertime\ngross earnings\nname: bill johnson\nday date in out in out hours\nmon 15 - dec 11:00 3:00 4:00 7:00\ntues 16 - dec 11:15 3:00 4:00 7:00\nwed 17 - dec 11:15 3:00 4:00 7:00\nthur 18 - dec 11:00 3:00 4:00 7:00\nfri 19 - dec 11:00 3:00 3:30 7:00\ntotal hours worked\nregular pay: $9.90 per hour\novertime pay: 1.5 x regular pay for hours over 40\nbill johnson hours rate amount\nregular\novertime\ngross earnings\nname: ted hall\nday date in out in out hours\nmon 1 - aug 5:00 9:00\ntues 2 - aug 4:00 8:00\nwed 3 - aug 6:30 11:00 12:00 5:00\nthur 4 - aug 6:45 11:30 12:00 3:00\nfri 5 - aug 9:00 1:00 1:30 5:30\nsat 6 - aug 5:00 9:00\nsun 7 - aug 8:00 12:00\ntotal hours worked\nregular pay: $8.70 per hour\novertime pay: 1.5 x regular pay for hours over 40\n2 x regular pay for all sunday hours\nted hall hours rate amount\nregular\novertime at 1.5 x\novertime at 2 x\ngross earnings
Answer
Explanation:
Step1: Calculate daily hours for Frank Smith
- Monday: Morning: $12 - 8=4$ hours, After - lunch: $6 - 1.5 = 4.5$ hours, Total = $4 + 4.5=8.5$ hours
- Tuesday: Morning: $12.5 - 8 = 4.5$ hours, After - lunch: $5 - 1=4$ hours, Total = $4.5+4 = 8.5$ hours
- Wednesday: Morning: $11.25 - 7.75 = 3.5$ hours, After - lunch: $4.5 - 1.75 = 2.75$ hours, Total = $3.5+2.75 = 6.25$ hours
- Thursday: Morning: $11.5 - 7.75 = 3.75$ hours, After - lunch: $4.167 - 1=3.167$ hours, Total = $3.75 + 3.167=6.917$ hours
- Friday: Morning: $13 - 8.25 = 4.75$ hours, After - lunch: $5.5 - 1.5 = 4$ hours, Total = $4.75+4 = 8.75$ hours
- Saturday: $13 - 10 = 3$ hours
- Total hours worked = $8.5+8.5 + 6.25+6.917+8.75+3=42.917$ hours
Step2: Calculate regular and overtime pay for Frank Smith
- Regular hours = 40 hours, Regular pay rate = $$8.50$ per hour, Regular pay = $40\times8.50=$340$
- Overtime hours = $42.917 - 40=2.917$ hours, Overtime pay rate = $1.5\times8.50=$12.75$ per hour, Overtime pay = $2.917\times12.75=$37.19$
- Gross earnings = $340+37.19=$377.19$
Step3: Calculate daily hours for Karen Brown
- Monday: Morning: $13 - 8 = 5$ hours, After - lunch: $5 - 2 = 3$ hours, Total = $5+3 = 8$ hours
- Tuesday: Morning: $13 - 8.25 = 4.75$ hours, After - lunch: $5 - 2 = 3$ hours, Total = $4.75+3 = 7.75$ hours
- Wednesday: Morning: $12.5 - 7.75 = 4.75$ hours, After - lunch: $5 - 2 = 3$ hours, Total = $4.75+3 = 7.75$ hours
- Thursday: Morning: $12 - 8 = 4$ hours, After - lunch: $4.5 - 1 = 3.5$ hours, Total = $4+3.5 = 7.5$ hours
- Friday: Morning: $12 - 7 = 5$ hours, After - lunch: $4.5 - 1.5 = 3$ hours, Total = $5+3 = 8$ hours
- Saturday: Morning: $13 - 9 = 4$ hours, After - lunch: $5 - 2 = 3$ hours, Total = $4+3 = 7$ hours
- Total hours worked = $8+7.75+7.75+7.5+8+7=46$ hours
Step4: Calculate regular and overtime pay for Karen Brown
- Regular hours = 40 hours, Regular pay rate = $$12$ per hour, Regular pay = $40\times12=$480$
- Overtime hours = $46 - 40 = 6$ hours, Overtime pay rate = $1.5\times12=$18$ per hour, Overtime pay = $6\times18=$108$
- Gross earnings = $480+108=$588$
Step5: Calculate daily hours for Bill Johnson
- Monday: Morning: $15 - 11 = 4$ hours, After - lunch: $7 - 4 = 3$ hours, Total = $4+3 = 7$ hours
- Tuesday: Morning: $15 - 11.25 = 3.75$ hours, After - lunch: $7 - 4 = 3$ hours, Total = $3.75+3 = 6.75$ hours
- Wednesday: Morning: $15 - 11.25 = 3.75$ hours, After - lunch: $7 - 4 = 3$ hours, Total = $3.75+3 = 6.75$ hours
- Thursday: Morning: $15 - 11 = 4$ hours, After - lunch: $7 - 4 = 3$ hours, Total = $4+3 = 7$ hours
- Friday: Morning: $15 - 11 = 4$ hours, After - lunch: $7 - 3.5 = 3.5$ hours, Total = $4+3.5 = 7.5$ hours
- Total hours worked = $7+6.75+6.75+7+7.5=35$ hours
- Regular hours = 35 hours, Regular pay rate = $$9.90$ per hour, Regular pay = $35\times9.90=$346.5$
- Overtime hours = 0 hours, Overtime pay = $0$
- Gross earnings = $$346.5$
Step6: Calculate daily hours for Ted Hall
- Monday: $9 - 5 = 4$ hours
- Tuesday: $8 - 4 = 4$ hours
- Wednesday: Morning: $11 - 6.5 = 4.5$ hours, After - lunch: $5 - 12 = 5$ hours, Total = $4.5+5 = 9.5$ hours
- Thursday: Morning: $11.5 - 6.75 = 4.75$ hours, After - lunch: $3 - 12 = 3$ hours, Total = $4.75+3 = 7.75$ hours
- Friday: Morning: $13 - 9 = 4$ hours, After - lunch: $5.5 - 1.5 = 4$ hours, Total = $4+4 = 8$ hours
- Saturday: $9 - 5 = 4$ hours
- Sunday: $12 - 8 = 4$ hours
- Total hours worked = $4+4+9.5+7.75+8+4+4=41.25$ hours
Step7: Calculate regular and overtime pay for Ted Hall
- Regular hours = 40 hours, Regular pay rate = $$8.70$ per hour, Regular pay = $40\times8.70=$348$
- Overtime hours at $1.5$x rate: $41.25 - 40=1.25$ hours, Overtime pay rate at $1.5$x = $1.5\times8.70=$13.05$ per hour, Overtime pay at $1.5$x = $1.25\times13.05=$16.31$
- Overtime hours at $2$x rate (Sunday): 4 hours, Overtime pay rate at $2$x = $2\times8.70=$17.4$ per hour, Overtime pay at $2$x = $4\times17.4=$69.6$
- Gross earnings = $348+16.31+69.6=$433.91$
Answer:
| Name | Regular Hours | Regular Rate | Regular Amount | Overtime Hours at 1.5x | Overtime Rate at 1.5x | Overtime Amount at 1.5x | Overtime Hours at 2x | Overtime Rate at 2x | Overtime Amount at 2x | Gross Earnings |
|---|---|---|---|---|---|---|---|---|---|---|
| Frank Smith | 40 | $$8.50$ | $$340$ | 2.917 | $$12.75$ | $$37.19$ | 0 | - | 0 | $$377.19$ |
| Karen Brown | 40 | $$12$ | $$480$ | 6 | $$18$ | $$108$ | 0 | - | 0 | $$588$ |
| Bill Johnson | 35 | $$9.90$ | $$346.5$ | 0 | - | 0 | 0 | - | 0 | $$346.5$ |
| Ted Hall | 40 | $$8.70$ | $$348$ | 1.25 | $$13.05$ | $$16.31$ | 4 | $$17.4$ | $$69.6$ | $$433.91$ |