Module 3

profileQueenQuanna
Capshaw.xlsx

Documentation

Capshaw Family Dentistry
Author
Date
Purpose To project take-home pay for an employee at Capshaw Family Dentistry

Work Schedule

Capshaw Family Dentistry
Estimate of Take Home Pay
Personal Information Working Schedule Federal Tax Rate
Name Date Clock In Clock Out Total Hours Straight Time Overtime Payment Withholding 0 1 2 3 4 5 6 7 8 9 10
Hourly Rate 8:00 AM 3:30 PM Single 10.92% 7.88% 4.85% 2.76% 0.74% 0% 0% 0% 0% 0% 0%
Federal Marital Status 8:00 AM 1:00 PM Married 5.65% 3.62% 1.60% 0% 0% 0% 0% 0% 0% 0% 0%
State Marital Status 8:30 AM 5:00 PM Supplemental 25.00% 25.00% 25.00% 25% 25% 25% 25% 25% 25% 25% 25%
Withholding Allowances 8:00 AM 10:30 AM
10:00 AM 7:00 PM State & Local Tax Rate
Total Straight Time Hours 8:00 AM 3:00 PM Withholding 0 1 2 3 4 5 6 7 8 9 10
Total Overtime Hours 11:30 AM 5:45 PM Single 4.34% 3.43% 2.52% 1.61% 0.77% 0.22% 0% 0% 0% 0% 0%
Total Hours 8:00 AM 6:30 PM Married 1-working 3.77% 2.86% 1.95% 1.15% 0.52% 0.13% 0% 0% 0% 0% 0%
Total Pay 8:00 AM 2:30 PM Married 2-working 4.43% 3.52% 2.61% 1.70% 0.80% 0.17% 0% 0% 0% 0% 0%
10:45 AM 3:30 PM
Deductions Social Security Tax Rate 6.20%
Federal Income Tax Medicare 1.45%
Social Security
Medicare
Georgia Income Tax
Total Deductions
Total Withholding Rate
Take Home Pay

&F &A &D