Unit5_Excel_template_challenge_case(1)

Unit5_Excel_template_challenge_case(1) - Name: Pay for...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Weekley Time Card CHD Company Name: Janice Anderson SS #: XXX-XX-1234 Pay for Period Ending DATE: IN OUT IN OUT Tot Reg Hrs Monday 8/4 7:00 11:00 11:30 19:30 8:00 Tuesday 8/5 8:00 12:00 12:30 4:30 8:00 Wednesday 8/6 8:00 12:00 12:30 4:30 8:00 Thursday 8/7 7:00 11:00 12:30 5:30 8:00 Friday 8/8 8:00 12:00 12:30 4:30 8:00 Saturday 8/9 7:00 12:00 Sunday 8/10 HOURS RATE Regular 40 9.75 Overtime (1.5X) 9.75 1.5 14.63 10 14.63 Overtime (2.0X) Total Total earning is: $536.30 Withholding tax table10-3: 15.52 Social Security tax: 33.25 Medicare tax: 7.78 Total Deductions: 56.55 Net Pay:  $479.75
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Tot Over Hrs 4:00 1:00 5:00 GROSS PAY $390.00 $146.30 $536.30
Background image of page 2
#1 I've done the first one for you as an example Gross semi-monthly Semi Montly Sal Insurance semi $32,000  24 $1,333.33  106 Adjusted Gross  $1,227.33  Figure 7-4 page 238 141.67 425.01 Taxable Income $802.32  $380.32  from table 3a $57.05  $88.25  is the withholding tax Social Security Tax
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 05/16/2011 for the course BUS 250 taught by Professor Barrie during the Spring '10 term at Kaplan University.

Page1 / 6

Unit5_Excel_template_challenge_case(1) - Name: Pay for...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online