Question: 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.

How do I create the formula for cell J6? In cell J6,

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 Pay

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!