Monthly Payroll Calculator

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