Labor Burden Calculator by tyndale

VIEWS: 2,690 PAGES: 1

									    Labor Burden Calculator
    revised July 2007

    Enter data only into blue cells; yellow cells contain formulas

                                                       FICA wages limit 1               $   97,500
                                                      FUTA wages limit 1                $    7,000
                                                      SUTA wages limit 1                $   15,000

         For salaried employees --->                     Annual Salary 2             Wage Base
           For hourly employees --->                    Dollars per hour 2  $20.00        for           Labor
    Common Labor Burden Costs           Basis                            Amount Calculation            Burden
    FICA                                Regular pay to max. see above       7.65% $ 41,600           $    3,182
    FUTA                                Regular pay to max. see above       0.80% $        7,000     $        56
    SUTA                                Regular pay to max. see above       1.80% $ 15,000           $      270
    Workers' Comp                       Regular pay                        14.56% $ 41,600           $    6,057
    G/L Insurance                       Regular pay                         4.00% $ 41,600           $    1,664
    Health                              Lump sum per year                  $9,600 $ 41,600           $    9,600
    Vacation                            Hours per year                         80.0 $ 41,600         $    1,765
    Holiday                             Hours per year                         48.0 $ 41,600         $    1,059
    Picnics, Parties                    Lump sum per year                    $400 $ 41,600           $      400
    Tool/Gas/Vehicle                    Lump sum per month                    $200 $ 41,600          $    2,400
    Sick/Personal Days                  Hours per year                         24.0 $ 41,600         $      529
    Company Meetings                    Hours per month                          2.0 $ 41,600        $      529
    Training/Education                  Hours per year                         40.0 $ 41,600         $      882
    Cell/Mobile/Internet                Lump sum per month                      $25 $ 41,600         $      300
    Vehicle Fuel/Maint./Insurance       Lump sum per month                      $25 $ 41,600         $      300
    Miscellaneous                       Lump sum per month                      $10 $ 41,600         $      120
    Profit Share/Pension/401k           % of regular pay                    3.00% $ 41,600           $    1,248
    Additional Bonus                    $ per year                         $1,500 $ 41,600           $    1,500
                                                                           Total Labor Burden        $   31,862
                                                                         Annual Gross Wages          $   41,600
                                                                  Total Annual Burdened Cost         $   73,462
                                                       Labor Burden as a Percentage of Wages              76.6%
                                                                        Cost per billable hour 3     $    39.41
                                                                                  Billable Hours           1,864
    NOTES
1
    These values may change from year to year. A good source for current values is www.qbalance.com.
2
    This worksheet uses either salary or dollars per hour, but not both. If you enter an annual salary in
    cell D10, then any dollars per hour you enter in cell D11 will not be used. If you leave salary blank in
    cell D10, then you must enter a dollars-per-hour amount in cell D11.
3
    Not all hours for which an employee is paid are "billable." This formula assumes 2080 hours
    available for work annually. From that it subtracts hours paid for vacation, holidays, sick/personal
    leave, company meetings, and training/educatoin.

								
To top