need help
rude-1
file.xlsxEmployees
| Central Sierra | |||||||||
| Employee ID | First Name | Last Name | Branch | Title | Department | Start Date | Base Monthly Salary | Bonus | Total Monthly Salary |
| 101 | Bob | Lingle | Cameron Park | CEO | Administration | 01-Jan-12 | 15000 | ||
| 102 | Lanita | McCartney | Cameron Park | Chief Operating Office | Administration | 01-Jan-12 | 12000 | ||
| 103 | Eleesha | Santos | Cameron Park | Insurance Agent | Health and Benefits | 10-Feb-12 | 5500 | ||
| 104 | Roy | Baxter | Granite Bay | Insurance Agent | Property and Casualty | 11-Feb-12 | 4500 | ||
| 105 | Jennifer | Alaro | Folsom | Administrative Assistant | Administration | 13-Apr-12 | 3000 | ||
| 115 | Tami | Chan | Cameron Park | Administrative Assistant | Health and Benefits | 07-May-12 | 3000 | ||
| 117 | Charlene | Althouse | Granite Bay | Large Group Specialist | Property and Casualty | 01-Jul-12 | 4700 | ||
| 119 | Juan | Taylor | Granite Bay | Insurance Agent | Insurance Sales | 01-Sep-12 | 4000 | ||
| 120 | Wayne | Reza | Cameron Park | Insurance Agent | Health and Benefits | 19-Nov-12 | 4000 | ||
| 125 | Cheryl | Nevens | Cameron Park | Chief Information Officer | Administration | 07-Jan-13 | 12000 | ||
| Branch Totals | |||||||||
| Cameron Park | |||||||||
| Folsom | |||||||||
| Granite Bay | |||||||||
| Total | |||||||||
Branch
| Central Sierra | ||||||
| Branch | Address | City | State | Zip | Phone | Fax |
| Cameron Park | 3360 Coach Lane | Cameron Park | CA | 95682-8454 | (530) 672-3232 | (530) 672-1111 |
| Folsom | 75 Natoma St. #B1 | Folsom | CA | 95630-2640 | (916) 458-5555 | (916) 458-6666 |
| Granite Bay | 6132 Del Oro Road | Granite Bay | CA | 95746-9007 | (916) 791-8787 | (916) 791-9999 |
Bonus
| Central Sierra | |
| Base Monthly Salary | Bonus |
| 3000 | 3% |
| 6000 | 3% |
| 9000 | 2% |
| 12000 | 2% |
| 15000 | 1% |
