help
Shopaisha
excel2.xlsxCommissions
| Central Sierra Insurance Commission Sales and Bonuses | ||||||
| ID | Last Name | First Name | Branch | Commissions | Bonus Rate | Commissions with Bonus |
| 101 | Lingle | Bob | Cameron Park | $15,000 | ||
| 102 | McCartney | Lanita | Folsom | $12,000 | ||
| 103 | Santos | Eleesha | Cameron Park | $5,500 | ||
| 104 | Baxter | Roy | Granite Bay | $4,500 | ||
| 105 | Alaro | Jennifer | Folsom | $3,000 | ||
| 115 | Chan | Tami | Cameron Park | $3,000 | ||
| 117 | Althouse | Charlene | Granite Bay | $4,700 | ||
| 119 | Taylor | Juan | Granite Bay | $4,000 | ||
| 120 | Reza | Wayne | Cameron Park | $4,000 | ||
| 125 | Nevens | Cheryl | Cameron Park | $12,000 | ||
| Commisions and Bonuses by Branch | ||||||
| Cameron Park | ||||||
| Folsom | ||||||
| Granite Bay | ||||||
| Total | ||||||
| Average | ||||||
| Mode | ||||||
| Median |
By Policy
| Central Sierra Insurance | |||||
| Sales by Policy Type | |||||
| ID | Last Name | First Name | Branch | Type of Policy | Personal Line? |
| 101 | Lingle | Bob | Cameron Park | Automobile | |
| 102 | McCartney | Lanita | Folsom | Business Policy | |
| 103 | Santos | Eleesha | Cameron Park | Health | |
| 104 | Baxter | Roy | Granite Bay | Homeowners | |
| 105 | Alaro | Jennifer | Folsom | Life | |
| 115 | Chan | Tami | Cameron Park | Renters | |
| 117 | Althouse | Charlene | Granite Bay | Renters | |
| 119 | Taylor | Juan | Granite Bay | Automobile | |
| 120 | Reza | Wayne | Cameron Park | Business Policy | |
| 125 | Nevens | Cheryl | Cameron Park | Health | |
| 102 | McCartney | Lanita | Folsom | Homeowners | |
| 103 | Santos | Eleesha | Cameron Park | Life | |
| 117 | Althouse | Charlene | Granite Bay | Business Policy | |
| 104 | Baxter | Roy | Granite Bay | Health | |
| 105 | Alaro | Jennifer | Folsom | Homeowners | |
| 105 | Alaro | Jennifer | Folsom | Automobile | |
| 115 | Chan | Tami | Cameron Park | Life | |
| 102 | McCartney | Lanita | Folsom | Business Policy | |
| 103 | Santos | Eleesha | Cameron Park | Health | |
| 104 | Baxter | Roy | Granite Bay | Homeowners | |
| 105 | Alaro | Jennifer | Folsom | Business Policy | |
Tables
| Commission Level | Bonus Rate | Agent Name and Location | |
| 3000 | 1.50% | ||
| 6000 | 1.75% | ||
| 9000 | 1.90% | ||
| 12000 | 2.25% | ||
| 15000 | 2.50% | ||
| Policy Types | |||
| Automobile | |||
| Business Policy | |||
| Health | |||
| Homeowners | |||
| Life | |||
| Renters | |||
