Docstoc

Payroll Analysis

Document Sample
Payroll Analysis Powered By Docstoc
					Payroll Analysis                                                                                                   Jan 1 - Dec 31, 2009

Summary                           % Earn
 Earnings Expense       163,985     100%
 Company Tax Expense     20,089      12%
 Benefit Expense         10,362       6%
Total Expenses          194,437     119%

Earnings Details                           Company Tax Details                          Benefit Details
 HOURLY RATE 1           80,362      49%    Social Security Company        10,167 51%    Workers Compensation   10,362 100%
 Prevailing wage         61,964      38%    CA - Unemployment Company       6,682 33%
 Prevailing OT           10,512       6%    Medicare Company                2,378 12%
 Overtime Hourly Rate     5,705       3%    Federal Unemployment              862 4%
 Prevailing Wage 2        3,678       2%    CA - Employment Training Tax      -    0%
 prevailing OT 2          1,180       1%
 HOURLY RATE 2              247       0%
 Prevailing DT              151       0%
 Prevailing DT 2            103       0%
 Hourly Shortage             72       0%
 overtime Shortage           14       0%
Total Earnings          163,985            Total Company Taxes             20,089       Total Benefits          10,362




Page 1 of 2                                                                                                              Jan 1 - Dec 31, 2009
Payroll Analysis                                          Jan 1 - Dec 31, 2009
Employee Details
Name               Earnings    %    Co Taxes   %    Benefits    % Ttl Exp      %
 Employee 1          35,560   22%       3,210 16%        312    3%    39,082 20%
 Employee 2          16,432   10%       1,747 9%       1,365   13%    19,544 10%
 Employee 3          15,262    9%       1,658 8%       1,162   11%    18,082 9%
 Employee 4          14,832    9%       1,625 8%       1,169   11%    17,626 9%
 Employee 5           8,392    5%       1,132 6%         516    5%    10,040 5%
 Employee 6           7,729    5%       1,081 5%         548    5%     9,358 5%
 Employee 7           6,668    4%         977 5%         792    8%     8,437 4%
 Employee 8           6,965    4%       1,020 5%         426    4%     8,411 4%
 Employee 9           6,965    4%       1,020 5%         426    4%     8,411 4%
 Employee 10          5,426    3%         795 4%         479    5%     6,700 3%
 Employee 11          4,406    3%         645 3%         345    3%     5,396 3%
 Employee 12          4,268    3%         625 3%         418    4%     5,312 3%
 Employee 13          4,005    2%         587 3%         292    3%     4,884 3%
 Employee 14          3,630    2%         532 3%          27    0%     4,189 2%
 Employee 15          2,996    2%         439 2%         183    2%     3,618 2%
 Employee 16          2,996    2%         439 2%         183    2%     3,618 2%
 Employee 17          2,500    2%         366 2%         192    2%     3,058 2%
 Employee 18          2,457    1%         360 2%         217    2%     3,034 2%
 Employee 19          2,191    1%         321 2%         204    2%     2,716 1%
 Employee 20          1,679    1%         246 1%         119    1%     2,044 1%
 Employee 21          1,679    1%         246 1%         119    1%     2,044 1%
 Employee 22          1,368    1%         200 1%         148    1%     1,716 1%
 Employee 23          1,225    1%         179 1%         308    3%     1,712 1%
 Employee 24          1,229    1%         180 1%         110    1%     1,519 1%
 Employee 25          1,148    1%         168 1%         113    1%     1,428 1%
 Employee 26            660    0%          97 0%          65    1%       821 0%
 Employee 27            630    0%          92 0%          62    1%       784 0%
 Employee 28            342    0%          50 0%          39    0%       431 0%
 Employee 29            200    0%          29 0%          12    0%       241 0%
 Employee 30            144    0%          21 0%          14    0%       179 0%
Totals              163,985            20,089         10,362         194,437




Page 2 of 2                                                    Jan 1 - Dec 31, 2009

				
DOCUMENT INFO
Description: This document sets forth a template spreadsheet than can be used to analyze data about a company's payroll expenses. The spreadsheet will calculate certain earnings details, such as the various rates that employees are paid; amounts paid for payroll tax, including state and federal; and benefits, such as workers' compensation. There is also a worksheet to calculate the amount of earnings, amount of tax, and amount of benefits paid to each individual employee. Company management can use this spreadsheet to analyze the company's overall payroll expenses or to analyze the payroll expenses of certain employees.
This document is also part of a package Employee Hiring Documents for your Business 31 Documents Included