Monthly Payroll Calculator

Document Sample
Monthly Payroll Calculator Powered By Docstoc
					20__ Monthly Payroll Calculator




  Inputs:                                       Rate
 401K Contribution Rate                           3%
 Healthcare Rate                                 20%
 Overtime % (% of Total Available Hours)          6%
 Overtime Rate (% of Regular Pay)               150%
 Employee Tax Rate                               10%

20__                                            Jan              Feb              Mar               Apr             May              Jun               Jul             Aug              Sep               Oct             Nov              Dec                Total

 MANAGEMENT SALARIES
Avg. Monthly Salary                        $     5,000      $     5,000      $     5,000      $     5,000      $     5,000      $     5,000      $     5,000      $     5,000      $     5,000      $     5,000      $     5,000      $     5,000      $      60,000
# of Employees                                     26               28               31               31               31               31               31               31               31               32               32               32                  32
Dept. 1                                                6                6                7                7                7                7                7                7                7                8                8                8                   8
Dept. 2                                                7                7                7                7                7                7                7                7                7                7                7                7                   7
Dept. 3                                                8            10               12               12               12               12               12               12               12               12               12               12                  12
Dept. 4                                                5                5                5                5                5                5                5                5                5                5                5                5                   5
TOTAL MANAGEMENT SALARIES                  $   130,000      $   140,000      $   155,000      $   155,000      $   155,000      $   155,000      $   155,000      $   155,000      $   155,000      $   160,000      $   160,000      $   160,000      $    1,835,000



 HOURLY EMPLOYEE WAGES
Total Available Hours per Month                    173              173              173              173              173              173              173              173              173              173              173              173              2,080
Avg. Hourly Rate                           $     15.25      $     15.25      $     15.25      $     15.25      $     15.25      $     15.25      $     15.25      $     15.25      $     15.25      $     15.25      $     15.25      $     15.25      $       15.25
# of Employees                                         24               24               26               26               26               26               26               21               21               21               21               21                  21
  Contract                                             15               15               17               17               17               17               17               12               12               12               12               12                  12
  Technicians                                           9                9                9                9                9                9                9                9                9                9                9                9                   9
  Other                                                 0                0                0                0                0                0                0                0                0                0                0                0                   0
Total Hours Worked                               4,160            4,160            4,507            4,507            4,507            4,507            4,507            3,640            3,640            3,640            3,640            3,640             49,053
TOTAL REGULAR PAY                          $    63,440      $    63,440      $    68,727      $    68,727      $    68,727      $    68,727      $    68,727      $    55,510      $    55,510      $    55,510      $    55,510      $    55,510      $     748,063


OVERTIME
Overtime Hours (Hourly Employees Only)            250              250              270              270              270              270              270              218              218              218              218              218               2,943
% Overtime                                         6%               6%               6%               6%               6%               6%               6%               6%               6%               6%               6%               6%                  6%
Overtime Rate (1.5 x hourly rate)          $     22.88      $     22.88      $     22.88      $     22.88      $     22.88      $     22.88      $     22.88      $     22.88      $     22.88      $     22.88      $     22.88      $     22.88      $       22.88
TOTAL OVERTIME                             $     5,710      $     5,710      $     6,185      $     6,185      $     6,185      $     6,185      $     6,185      $     4,996      $     4,996      $     4,996      $     4,996      $     4,996      $      67,326


TOTAL HOURLY EMPLOYEE WAGES                $    69,150      $    69,150      $    74,912      $    74,912      $    74,912      $    74,912      $    74,912      $    60,506      $    60,506      $    60,506      $    60,506      $    60,506      $     815,389


BENEFITS
401k contribution (3%)                     $     1,903      $     1,903      $     2,062      $     2,062      $     2,062      $     2,062      $     2,062      $     1,665      $     1,665      $     1,665      $     1,665      $     1,665      $      22,442
Healthcare (Medical & Dental) (10%)        $    12,688      $    12,688      $    13,745      $    13,745      $    13,745      $    13,745      $    13,745      $    11,102      $    11,102      $    11,102      $    11,102      $    11,102      $     149,613
Other                                      $       -        $       -        $       -        $       -        $       -        $       -        $       -        $       -        $       -        $       -        $       -        $       -        $          -
Other                                      $       -        $       -        $       -        $       -        $       -        $       -        $       -        $       -        $       -        $       -        $       -        $       -        $          -
Other                                      $       -        $       -        $       -        $       -        $       -        $       -        $       -        $       -        $       -        $       -        $       -        $       -        $          -
TOTAL BENEFITS                             $    14,591      $    14,591      $    15,807      $    15,807      $    15,807      $    15,807      $    15,807      $    12,767      $    12,767      $    12,767      $    12,767      $    12,767      $     172,055


TAXES
Employee Tax                               $     6,344      $     6,344      $     6,873      $     6,873      $     6,873      $     6,873      $     6,873      $     5,551      $     5,551      $     5,551      $     5,551      $     5,551      $      74,806
TOTAL TAXES                                $     6,344      $     6,344      $     6,873      $     6,873      $     6,873      $     6,873      $     6,873      $     5,551      $     5,551      $     5,551      $     5,551      $     5,551      $      74,806



Total Payroll Expense                      $ 220,085        $ 230,085        $ 252,592        $ 252,592        $ 252,592        $ 252,592        $ 252,592        $ 233,824        $ 233,824        $ 238,824        $ 238,824        $ 238,824        $ 2,897,250
20__ Monthly Payroll Calculator
20__ Monthly Payroll Calculator
				
DOCUMENT INFO
Description: This Monthly Payroll Calculator should be used by company managers or human resources officers to calculate payroll expenses by month. This spreadsheet is divided between management salaries, hourly employee wages, benefits, and taxes. Expenses for each category are listed by month and the spreadsheet automatically calculates a yearly total per line item. Management or human resources can use this template to track payroll expenses or budget for anticipated personnel and staffing costs.
This document is also part of a package Bookkeeping Forms for your Business 49 Documents Included