Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Strawberry Fields payroll 1-20-2009

VIEWS: 4 PAGES: 7

									Strawberry Fields Department Store
the smart way to shop

Author    Type your name here
Date       2/23/2012
Purpose   To track payroll data
                                                 Strawberry Fields Department Store
                                                         Employee Payroll
                        Hourly                                          Overtime               Withholding
             Name       Wage        Hours Worked     Regular Hours       Hours   Gross Pay         Tax
          Jackson              10              50                  40        10          550             154
          Chavez              7.2              41                  40          1       298.8          83.664
          Brown                 8              40                  40          0         320             89.6
          Morales               9              42                  40          2         387          108.36
          Thomas              9.2              40                  40          0         368          103.04
          Gonzales             10              30                  30          0         300              84
          Synder               14              44                  40          4         644          180.32
          Franklin           6.35              40                  40          0         254           71.12
          Kennedy             7.2              40                  40          0         288           80.64
          Willson              10              33                  33          0         330             92.4
          Johnson            6.35             42.5                 40        2.5    277.8125         77.7875
          Schmitz             7.2              40                  40          0         288           80.64
Totals                                                                             4305.6125       1205.5715


Assumptions                                                                        Summary
Overtime rate                                                     1.5              Average Gross Pay
Withholding tax                                               28.00%               Highest Gross Pay
Social Security/Medicare tax                                   7.65%               Lowest Gross Pay




Notes:
1. Withholding tax is calculated on the taxable pay
2. Social Security tax is calculated on the employee's gross pay
Soc Sec
  Tax        Net Pay
    42.075    353.925
  22.8582    192.2778
     24.48     205.92
  29.6055    249.0345
    28.152    236.808
     22.95     193.05
    49.266    414.414
    19.431    163.449
    22.032    185.328
    25.245    212.355
21.252656    178.7723
    22.032    185.328
329.37936    2770.662




  $358.80
  $644.00
  $254.00
                                                                             Strawberry Fields Department Store
                                                                                          Employee Payroll
                                     Hourly
                         Name        Wage       Hours Worked       Regular Hours     Overtime Hours
                       Jackson         $10.00            50.00               40.00              10.00
                       Chavez           $7.20            41.00               40.00               1.00
                       Brown            $8.00            40.00               40.00
                       Morales          $9.00            42.00               40.00               2.00
                       Thomas           $9.20            40.00               40.00
                       Gonzales        $10.00            30.00               30.00
                       Synder          $14.00            44.00               40.00               4.00
                       Franklin         $6.35            40.00               40.00
                       Kennedy          $7.20            40.00               40.00
                       Willson         $10.00            33.00               33.00
                       Johnson          $6.35            42.50               40.00               2.50
                       Schmitz          $7.20            40.00               40.00
Totals



Assumptions
Overtime rate                                                                  1.5
Withholding tax                                                            28.00%
Social Security/Medicare tax                                                7.65%




Notes:
1. Withholding tax is calculated on the taxable pay
2. Social Security tax is calculated on the employee's gross pay



401K Savings Rate         10.25%
Fields Department Store
mployee Payroll
                                          Withholding    Soc Sec                 401K
            Gross Pay     W2 Taxable          Tax          Tax      401K Plan   Savings    Net Pay
               $550.00         $493.63        $138.22      $42.08   Yes           $56.38    $313.34
               $298.80         $268.17          $75.09     $22.86   Yes           $30.63    $170.23
               $320.00         $287.20          $80.42     $24.48   Yes           $32.80    $182.30
               $387.00         $347.33          $97.25     $29.61   Yes           $39.67    $220.47
               $368.00         $368.00        $103.04      $28.15   No             $0.00    $236.81
               $300.00         $269.25          $75.39     $22.95   Yes           $30.75    $170.91
               $644.00         $644.00        $180.32      $49.27   No             $0.00    $414.41
               $254.00         $254.00          $71.12     $19.43   No             $0.00    $163.45
               $288.00         $258.48          $72.37     $22.03   Yes           $29.52    $164.07
               $330.00         $296.18          $82.93     $25.25   Yes           $33.83    $188.00
               $277.81         $277.81          $77.79     $21.25   No             $0.00    $178.77
               $288.00         $258.48          $72.37     $22.03   Yes           $29.52    $164.07
              $4,305.61                      $1,126.31    $329.38                          $2,566.84



          Summary
          Average Gross Pay                               $358.80
          Highest Gross Pay                               $644.00
          Lowest Gross Pay                                $254.00

          Today's Date        23-Feb-12
                                                                                   Strawberry Fields Department Store
                                                                                           Employee Payroll
                                      Hourly
                       Name           Wage      Hours Worked       Regular Hours   Overtime Hours




Totals



Assumptions
Overtime rate
Withholding tax
Social Security/Medicare tax




Notes:
1. Withholding tax is calculated on the taxable pay
2. Social Security tax is calculated on the employee's gross pay



401K Savings Rate
rry Fields Department Store
 Employee Payroll
                                            Withholding   Soc Sec                401K
               Gross Pay       W2 Taxable       Tax         Tax     401K Plan   Savings   Net Pay




           Summary
           Average Gross Pay
           Highest Gross Pay
           Lowest Gross Pay

           Today's Date

								
To top