Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How do I create the formula for cell J6? In cell J6, calculate the salary due on the first day. The salary due is equal
How do I create the formula for cell J6?
In cell J6, calculate the salary due on the first day. The salary due is equal to the Straight Time worked multiplied by the hourly rate in cell B6 plus the Overtime multiplied by the hourly rate times 1.5 (Carol will receive time-and-a-half for each overtime hour.) Use an absolute reference to cell B6.
J6 Capshaw Family Dentist 2 Estimate of Take Home Pay ry Personal Information Working Schedule 4 5 Name 6 Hourly Rate 7 Federal Marital Status 8 State Marital Status 9 Withholding Allowances 10 11 Total Straight Time Hours 12 Total Overtime Hours 13 Total Hours 14 Total Pa 15 16 17 Federal Income Tax 18 Social Securit 19 Medicare 20 Georgia Income Tax Date 4/10/2017 8:00 AM 4/11/2017 8:00 AM 4/12/2017 8:30 AM 4/13/2017 8:00 AM10:30 AM 4/14/2017 10:00 AM7:00 PM 4/15/2017 8:00 AM 3:00 PM 4/16/2017 11:30 AM 4/17/2017 8:00 AM 4/18/2017 8:00 AM 4/19/2017 10:45 AM 3:30 PM Carol Lemke Clock In Clock Out Total Hours Straight Time Overtime Payment $16.25 7.50 5.00 8.50 2.50 9.00 7.00 6.25 10.50 6.50 4.75 7.50 5.00 8.00 2.50 8.00 7.00 6.25 8.00 6.50 4.75 0.00 0.00 0.50 0.00 1.00 0.00 0.00 2.50 0.00 0.00 3:30 PM 1:00 PM 5:00 PM 5:45 PM 6:30 PM 2:30 PM Deductions 22 Total Deductions 23 Total Withholding Rate 24 Take Home PayStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started