Can you finish this?
jgordneer
JillianGordneer_HealthInsuranceData_StartFile.xlsxSix-Year Weekly Salary
| Six-Year Weekly Salary | |||||||
| Name | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | Sparkline Chart |
| Frieze, Victor | $ 600.00 | $ 895.00 | $ 540.00 | $ 475.00 | $ 1,045.00 | $ 1,095.00 | |
| Zhao, Feng | $ 450.00 | $ 700.00 | $ 795.00 | $ 500.00 | $ 895.00 | $ 945.00 | |
| Banner, David | $ 300.00 | $ 475.00 | $ 500.00 | $ 650.00 | $ 790.00 | $ 1,200.00 | |
| Jenkins Jr., Robert | $ 350.00 | $ 475.00 | $ 275.00 | $ 275.00 | $ 765.00 | $ 815.00 | |
| Guttenberg, Monica | $ 975.00 | $ 1,025.00 | $ 1,075.00 | $ 1,125.00 | $ 1,175.00 | $ 1,225.00 | |
| Padilla, Jose | $ 500.00 | $ 750.00 | $ 250.00 | $ 300.00 | $ 680.00 | $ 800.00 | |
| Watkins, Mary | $ 400.00 | $ 250.00 | $ 400.00 | $ 400.00 | $ 400.00 | $ 750.00 | |
| Cavill, Henry | $ 700.00 | $ 750.00 | $ 820.00 | $ 950.00 | $ 1,000.00 | $ 1,300.00 |
Full-Time
| Full Time Health Insurance Costs | ||||||||||||||
| Employee Name | Department | Job Title | # of family members | Insurance Calculator | Weekly Salary | Weekly Insurance Premium | Employee Contribution | Employer Contribution | Percentage of Employer Contribution | Insurance Codes | ||||
| Frieze, Victor | Administration | Human Resources Manager | 3 | 0.11 | 1095.00 | 361.35 | 216.81 | 144.54 | 14.93% | INS3 | ||||
| Zhao, Feng | Concessions | Assistant Manager | 2 | 0.14 | 945.00 | 264.60 | 158.76 | 105.84 | 10.94% | INS2 | ||||
| Banner, David | Administration | Executive Assistant | 1 | 0.19 | 750.00 | 142.50 | 85.50 | 57.00 | 5.89% | INS2 | ||||
| Jenkins Jr., Robert | Maintenance | Foreman | 2 | 0.14 | 815.00 | 228.20 | 136.92 | 91.28 | 9.43% | INS2 | ||||
| Guttenberg, Monica | Administration | Manager | 3 | 0.11 | 1225.00 | 404.25 | 242.55 | 161.70 | 16.71% | INS3 | ||||
| Padilla, Jose | Concessions | Manager | 4 | 0.11 | 1150.00 | 506.00 | 303.60 | 202.40 | 20.91% | INS3 | ||||
| Watkins, Mary | Maintenance | Manager | 1 | 0.19 | 984.00 | 186.96 | 112.18 | 74.78 | 7.73% | INS2 | ||||
| Cavill, Henry | Concessions | Senior Attendant | 3 | 0.11 | 987.00 | 325.71 | 195.43 | 130.28 | 13.46% | INS3 | ||||
| Total | 7951 | 2419.57 | 1451.74 | 967.83 | ||||||||||
| Average | $ 302.45 | $ 181.47 | $ 120.98 | |||||||||||
| Maximum | $ 506.00 | $ 303.60 | $ 202.40 | |||||||||||
| Insurance Codes | Minimum | $ 142.50 | $ 85.50 | $ 57.00 | ||||||||||
| INS2 | less than 3 family members | |||||||||||||
| INS3 | 3 or more family members | |||||||||||||
| * The Insurance Calculator may vary due to family size and health care plan option |
Weekly Salary Chart
weekly salary sheet
Frieze, Victor Zhao, Feng Banner, David Jenkins Jr., Robert Guttenberg, Monica Padilla, Jose Watkins, Mary 0
