Payroll Analysis

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