IT Spreadsheet
encdannekga
Unit_4_IP1.xlsxSheet1
| Company Name Sales Force Planning | ||||||
| Name | Employee ID | Salary | Product Knowledge Exam | Manager Rating | Overall Score | Layoff? |
| Banks, Jerry | 12348392.00 | $60,000 | 39 | 70 | ||
| Carlton, Sara | 18293849.00 | $52,000 | 98 | 84 | ||
| McMann, Marie | 48372937.00 | $57,500 | 70 | 86 | ||
| Oxley, James | 99837283.00 | $80,000 | 88 | 60 | ||
| Whittenridge, Travis | 23456789.00 | $57,000 | 99 | 76 | ||
| Yates, Richard | 40018327.00 | $90,000 | 109 | 77 | ||
| Abstract, Joseph | 53814866.00 | $99,012 | 61 | 84 | ||
| Crane, Niles | 35290967.00 | $69,017 | 99 | 83 | ||
| Keller, Helen | 65200445.00 | $59,021 | 72 | 99 | ||
| Nome, Buzz | 95109923.00 | $89,026 | 66 | 78 | ||
| Perkins, Percy | 25019401.00 | $93,030 | 92 | 77 | ||
| Waive, Catherine | 54928879.00 | $89,035 | 66 | 74 | ||
| Weasley, Harry | 12456392.00 | $90,375 | 80 | 77 | ||
| Porier, Ronald | 32453849.00 | $74,604 | 75 | 88 | ||
| Malfoy, Luke | 48375543.00 | $68,833 | 48 | 56 | ||
| Granger, Elenor | 99898783.00 | $83,062 | 88 | 88 | ||
| Burke, Alex | 23456711.00 | $87,291 | 93 | 87 | ||
| Nuix, James | 43018327.00 | $51,520 | 83 | 90 | ||
| Magnum, Peter | 53814866.00 | $52,749 | 77 | 69 | ||
| Resting, W. F. | 55290969.00 | $91,978 | 92 | 88 | ||
| Cappert, Cherise | 65200488.00 | $54,207 | 80 | 82 | ||
| Breaches, Savi | 95109920.00 | $78,436 | 91 | 89 | ||
| Daudio, Annette | 65019406.00 | $52,665 | 79 | 76 | ||
| Jerome, Ace | 44929879.00 | $66,894 | 65 | 80 | ||
| Total | $1,549,260 | |||||
| Company Savings | ||||||
| New Sales Force Salary | ||||||
| RECOMMENDATION: | ||||||
Sheet2
| Layoff Criteria (by score) | |
| 0 | Recommend for layoff |
| 70 | Evaluate Further |
| 85 | Keep |
