Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Databases 28th British National Conference On Databases Bncod 28 Manchester Uk July 2011 Revised Selected Papers Lncs 7051

Authors: Alvaro A.A. Fernandes ,Alasdair J.G. Gray ,Khalid Belhajjame

2011th Edition

3642245765, 978-3642245763

More Books

Students also viewed these Databases questions