Payroll Analysis

VIEWS: 8,479 PAGES: 2

More Info
									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
								
To top