KAJAL Payroll Data pze4yo-narban_exploring_e02_grader_h2.xlsx
Metropolitan Zoo
Gift Shop Department
Name Regular Pay Gross Pay Taxable Pay FICA Net Pay
Abram 2 $ 9.95 48 $ 398.00 $ 119.40 $ 517.40 $ 417.40 $ 104.35 $ 39.58 $ 373.47
Acosta 1 $ 9.55 48 382.00 114.60 496.60 446.60 111.65 37.99 346.96
Bordeaux 3 $ 11.75 50 470.00 176.25 646.25 496.25 138.95 49.44 457.86
Higinbotham 1 $ 11.75 35 411.25 - 411.25 361.25 90.31 31.46 289.48
Ianziti 1 $ 10.00 40 400.00 - 400.00 350.00 87.50 30.60 281.90
Jaussi 1 $ 9.55 44 382.00 57.30 439.30 389.30 97.33 33.61 308.37
Ling 3 $ 15.75 40 630.00 - 630.00 480.00 134.40 48.20 447.41
Munoz 2 $ 12.25 20 245.00 - 245.00 145.00 21.75 18.74 204.51
Riley 3 $ 13.35 38 507.30 - 507.30 357.30 89.33 38.81 379.17
Sabey 2 $ 10.00 45 400.00 75.00 475.00 375.00 93.75 36.34 344.91
Trujillo 1 $ 9.95 15 149.25 - 149.25 99.25 14.89 11.42 122.94
Weston 2 $ 11.75 41 470.00 17.63 487.63 387.63 96.91 37.30 353.42
Totals $ 4,844.80 $ 560.18 $ 5,404.98 $ 4,304.98 $ 1,081.11 $ 413.48 $ 3,910.39
Assumptions Tax Rate # of Hours Gross Pay Net Pay
Base Work Hours 40 $0 15% Average 38.7 $ 450.41 $ 325.87
Overtime rate 1.5 $250 22% Highest 50.0 $ 646.25 $ 457.86
FICA rate 7.65% $300 25% Lowest 15.0 $ 149.25 $ 122.94
Deduct per Depend $ 50.00 $450 28%
$525 31%
Notes
1. The base workweek is 40 hours. Regular pay is based on hourly wage and hours worked up to 40.
2. Overtime pay is based on overtime hours, the hourly wage, and the overtime rate.
3. The gross pay is the total of the regular pay and overtime pay.
5. Federal withholding tax is calculated on the taxable pay based on the tax table.
6. FICA is calculated on the employee's gross pay.
7. The net pay is based on the gross pay, federal withholding tax, and FICA.
No. of
Dependents
Hourly
Wage
Hours
Worked
Overtime
Pay
Federal
Withholding Tax
Taxable
Pay
Summary
Statistics
4. The taxable pay is the difference between the gross pay
and the product of the number of dependents and ded uction per dependent.
