excel
nani13122 
DataFile1.xlsxPayroll Summary
| Little Hills Medical Group Payroll Summary | ||||||
| Practice | Number of Employees | Average Years of Service | Total FICA | Federal Tax Withheld | Net Salary Payments | Retirement Benefit Payments |
| Pediatrics | ||||||
| Adult Internal Med | ||||||
| Obstetrics | ||||||
| Orthopedics | ||||||
| Group | ||||||
| Total |
Payroll Details
| Little Hills Medical Group Payroll Detail | ||||||||||||||
| Employee Last Name, First Name | Position | Practice | Years of Service | Pay Year to Date | Gross Pay This Week | Social Security Tax | Medicare Tax | Total FICA | Federal Tax | 401K Retirment | 401 K Company Match | Retirement Benefit | Total Retirement Benefits | Net Payment |
| Rollet, Heather | PA | Orthopedics | 0.1 | $ 20,400 | $ 600 | $ 18.00 | ||||||||
| Lake, Connie | PA | Obstetrics | 0.2 | $ 22,950 | $ 675 | $ 27.00 | ||||||||
| Antoine, Gerry | PA | Adult Internal Med | 0.5 | $ 24,820 | $ 730 | $ 36.50 | ||||||||
| Kade, Michael | PA | Pediatrics | 0.8 | $ 29,410 | $ 865 | $ 51.90 | ||||||||
| Long, Shari | Physician | Adult Internal Med | 1 | $ 78,200 | $ 2,300 | $ 207.00 | ||||||||
| James, Don | Physician | Orthopedics | 2 | $ 71,910 | $ 2,115 | $ 190.35 | ||||||||
| Patel, Sanjev | Physician | Adult Internal Med | 4 | $ 91,800 | $ 2,700 | $ 216.00 | ||||||||
| Washington, Janet | Physician | Pediatrics | 4 | $ 62,050 | $ 1,825 | $ 127.75 | ||||||||
| Shin, Burt | Physician | Obstetrics | 6 | $ 104,550 | $ 3,075 | $ 317.00 | ||||||||
| Kumar, Denise | Physician | Obstetrics | 7 | $ 115,600 | $ 3,400 | $ 317.00 | ||||||||
| Xu, Weimin | Physician | Orthopedics | 8 | $ 118,150 | $ 3,475 | $ 317.00 | ||||||||
| Dixey, Bernard | Physician | Orthopedics | 10 | $ 137,190 | $ 4,035 | $ 317.00 | ||||||||
| Blane, John | Physician | Pediatrics | 16 | $ 147,050 | $ 4,325 | $ 317.00 | ||||||||
| Li, Wei | Staff | Group | 0.7 | $ 19,550 | $ 575 | $ 23.00 | ||||||||
| Blanch, Maurice | Staff | Adult Internal Med | 1 | $ 19,618 | $ 577 | $ 34.62 | ||||||||
| Wan, Stanley | Staff | Pediatrics | 1 | $ 29,410 | $ 865 | $ 43.25 | ||||||||
| Harlen, Lori | Staff | Group | 2 | $ 22,950 | $ 675 | $ 33.75 | ||||||||
| Hothe, Peggy | Staff | Obstetrics | 4 | $ 26,180 | $ 770 | $ 30.80 | ||||||||
| Michaels, Angela | Staff | Group | 6 | $ 36,040 | $ 1,060 | $ 31.80 | ||||||||
| Daniels, Max | Staff | Orthopedics | 9 | $ 39,270 | $ 1,155 | $ 69.30 | ||||||||
