| Company Data for CRM Technologies |
| Salesperson Region Assignment | | | Commission rates lookup Table |
| Cameron | North | | 20000 | 3% |
| Jackie | North | | 35000 | 5% |
| Jose | South | | 50000 | 7% |
| Marc | South |
| Heidi | East |
| Matthew | East |
| Alison | West |
| Derek | West |
| Linda | Midwest |
| | 750 | 400 | 400 | 600 | 500 | 500 | 400 | 475 | 475 | 500 | 550 | 750 |
| Monthly Sales by Salesperson |
| | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
| Cameron | $ 47,880.00 | $ 27,665.00 | $ 19,890.00 | $ 23,834.00 | $ 40,260.00 | $ 36,180.00 | $ 37,444.00 | $ 42,698.00 | $ 26,055.00 | $ 39,996.00 | $ 41,202.00 | $ 34,160.00 |
| Jackie | $ 32,376.00 | $ 26,104.00 | $ 37,000.00 | $ 39,648.00 | $ 30,050.00 | $ 36,300.00 | $ 35,997.00 | $ 42,486.00 | $ 28,665.00 | $ 22,876.00 | $ 42,315.00 | $ 51,120.00 |
| Jose | $ 57,936.00 | $ 21,844.00 | $ 21,715.00 | $ 31,020.00 | $ 40,260.00 | $ 33,550.00 | $ 34,068.00 | $ 19,618.00 | $ 28,665.00 | $ 20,672.00 | $ 37,449.00 | $ 34,850.00 |
| Marc | $ 47,992.00 | $ 34,845.00 | $ 20,280.00 | $ 36,920.00 | $ 26,840.00 | $ 32,778.00 | $ 19,304.00 | $ 38,659.00 | $ 32,256.00 | $ 37,863.00 | $ 32,550.00 | $ 29,138.00 |
| Heidi | $ 48,507.00 | $ 27,486.00 | $ 33,198.00 | $ 44,667.00 | $ 33,055.00 | $ 41,344.00 | $ 29,913.00 | $ 40,810.00 | $ 33,408.00 | $ 38,241.00 | $ 38,704.00 | $ 59,202.00 |
| Matthew | $ 48,963.00 | $ 17,102.00 | $ 24,745.00 | $ 33,888.00 | $ 31,356.00 | $ 28,896.00 | $ 21,629.00 | $ 33,345.00 | $ 20,808.00 | $ 22,914.00 | $ 26,160.00 | $ 62,488.00 |
| Alison | $ 41,184.00 | $ 31,815.00 | $ 23,460.00 | $ 29,736.00 | $ 40,128.00 | $ 25,326.00 | $ 31,626.00 | $ 38,860.00 | $ 34,456.00 | $ 23,439.00 | $ 34,112.00 | $ 43,000.00 |
| Derek | $ 35,994.00 | $ 22,396.00 | $ 31,049.00 | $ 45,056.00 | $ 36,600.00 | $ 30,350.00 | $ 35,210.00 | $ 38,793.00 | $ 38,592.00 | $ 20,706.00 | $ 39,000.00 | $ 47,190.00 |
| Linda | $ 31,746.00 | $ 27,216.00 | $ 20,280.00 | $ 50,688.00 | $ 40,401.00 | $ 44,092.00 | $ 36,144.00 | $ 26,910.00 | $ 32,424.00 | $ 36,600.00 | $ 46,221.00 | $ 46,386.00 |
| Number of Sales Calls per Month |
| | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
| Cameron | 64 | 59 | 53 | 50 | 35 | 37 | 67 | 69 | 44 | 56 | 40 | 48 |
| Jackie | 61 | 54 | 44 | 58 | 55 | 45 | 61 | 72 | 43 | 36 | 60 | 72 |
| Jose | 41 | 51 | 72 | 72 | 63 | 41 | 34 | 67 | 54 | 58 | 43 | 73 |
| Marc | 56 | 66 | 41 | 34 | 50 | 57 | 68 | 46 | 58 | 69 | 54 | 39 |
| Heidi | 49 | 54 | 61 | 71 | 53 | 62 | 61 | 45 | 64 | 73 | 54 | 38 |
| Matthew | 63 | 35 | 65 | 45 | 64 | 37 | 44 | 42 | 55 | 44 | 65 | 49 |
| Alison | 64 | 44 | 68 | 37 | 67 | 36 | 38 | 65 | 52 | 55 | 47 | 62 |
| Derek | 66 | 74 | 48 | 36 | 34 | 35 | 59 | 40 | 63 | 54 | 65 | 58 |
| Linda | 72 | 56 | 39 | 58 | 51 | 43 | 66 | 43 | 71 | 65 | 65 | 46 |
| Monthly Revenues by Region |
| | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
| North | $ 80,256.00 | $ 53,769.00 | $ 56,890.00 | $ 63,482.00 | $ 70,310.00 | $ 72,480.00 | $ 73,441.00 | $ 85,184.00 | $ 54,720.00 | $ 62,872.00 | $ 83,517.00 | $ 85,280.00 |
| South | $ 105,928.00 | $ 56,689.00 | $ 41,995.00 | $ 67,940.00 | $ 67,100.00 | $ 66,328.00 | $ 53,372.00 | $ 58,277.00 | $ 60,921.00 | $ 58,535.00 | $ 69,999.00 | $ 63,988.00 |
| East | $ 97,470.00 | $ 44,588.00 | $ 57,943.00 | $ 78,555.00 | $ 64,411.00 | $ 70,240.00 | $ 51,542.00 | $ 74,155.00 | $ 54,216.00 | $ 61,155.00 | $ 64,864.00 | $ 121,690.00 |
| West | $ 77,178.00 | $ 54,211.00 | $ 54,509.00 | $ 74,792.00 | $ 76,728.00 | $ 55,676.00 | $ 66,836.00 | $ 77,653.00 | $ 73,048.00 | $ 44,145.00 | $ 73,112.00 | $ 90,190.00 |
| Midwest | $ 31,746.00 | $ 27,216.00 | $ 20,280.00 | $ 50,688.00 | $ 40,401.00 | $ 44,092.00 | $ 36,144.00 | $ 26,910.00 | $ 32,424.00 | $ 36,600.00 | $ 46,221.00 | $ 46,386.00 |
| Monthly Expenses by Region |
| | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
| North | $ 73,960.00 | $ 48,794.67 | $ 52,718.18 | $ 58,710.91 | $ 63,497.78 | $ 64,420.00 | $ 65,260.88 | $ 75,536.00 | $ 47,902.86 | $ 53,393.33 | $ 75,237.33 | $ 78,527.27 |
| South | $ 95,158.22 | $ 51,390.22 | $ 35,995.83 | $ 62,146.00 | $ 59,712.50 | $ 57,852.57 | $ 46,747.43 | $ 54,420.58 | $ 51,767.50 | $ 53,031.11 | $ 59,332.50 | $ 59,655.67 |
| East | $ 88,723.00 | $ 39,218.29 | $ 53,148.70 | $ 70,826.67 | $ 57,359.63 | $ 59,533.33 | $ 46,099.25 | $ 65,885.63 | $ 49,794.40 | $ 51,962.50 | $ 59,377.60 | $ 105,305.71 |
| West | $ 68,530.75 | $ 47,466.57 | $ 49,452.44 | $ 65,107.43 | $ 70,055.20 | $ 47,396.67 | $ 62,266.33 | $ 72,181.92 | $ 61,873.33 | $ 39,626.88 | $ 64,973.00 | $ 78,305.71 |
| Midwest | $ 28,210.86 | $ 23,680.00 | $ 17,900.00 | $ 44,446.86 | $ 37,728.18 | $ 38,793.14 | $ 32,626.00 | $ 24,065.71 | $ 29,371.00 | $ 31,500.00 | $ 42,598.90 | $ 40,759.43 |
| Monthly Profit Margin |
| | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
| North | 8% | 9% | 7% | 8% | 10% | 11% | 11% | 11% | 12% | 15% | 10% | 8% |
| South | 10% | 9% | 14% | 9% | 11% | 13% | 12% | 7% | 15% | 9% | 15% | 7% |
| East | 9% | 12% | 8% | 10% | 11% | 15% | 11% | 11% | 8% | 15% | 8% | 13% |
| West | 11% | 12% | 9% | 13% | 9% | 15% | 7% | 7% | 15% | 10% | 11% | 13% |
| Midwest | 11% | 13% | 12% | 12% | 7% | 12% | 10% | 11% | 9% | 14% | 8% | 12% |
| Monthly Marketing Expenses by Region |
| | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
| North | $ 24,879.36 | $ 13,442.25 | $ 13,653.60 | $ 12,696.40 | $ 16,171.30 | $ 21,744.00 | $ 19,094.66 | $ 18,740.48 | $ 13,680.00 | $ 17,604.16 | $ 16,703.40 | $ 23,025.60 |
| South | $ 29,659.84 | $ 10,770.91 | $ 13,018.45 | $ 20,382.00 | $ 14,762.00 | $ 15,918.72 | $ 13,876.72 | $ 12,238.17 | $ 14,011.83 | $ 11,707.00 | $ 18,899.73 | $ 14,717.24 |
| East | $ 28,266.30 | $ 10,255.24 | $ 16,803.47 | $ 20,424.30 | $ 19,323.30 | $ 21,072.00 | $ 11,339.24 | $ 14,831.00 | $ 12,469.68 | $ 14,677.20 | $ 18,161.92 | $ 23,121.10 |
| West | $ 18,522.72 | $ 16,805.41 | $ 13,082.16 | $ 17,202.16 | $ 21,483.84 | $ 15,032.52 | $ 17,377.36 | $ 21,742.84 | $ 16,801.04 | $ 13,243.50 | $ 16,815.76 | $ 21,645.60 |
| Midwest | $ 9,841.26 | $ 6,804.00 | $ 3,853.20 | $ 14,192.64 | $ 11,716.29 | $ 8,818.40 | $ 10,481.76 | $ 5,382.00 | $ 8,754.48 | $ 6,954.00 | $ 13,404.09 | $ 12,988.08 |
| Number of New Customers added Monthly |
| | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
| North | 4 | 9 | 6 | 9 | 5 | 6 | 10 | 10 | 7 | 5 | 5 | 6 |
| South | 7 | 6 | 7 | 7 | 10 | 6 | 8 | 8 | 5 | 5 | 6 | 10 |
| East | 7 | 9 | 9 | 7 | 8 | 7 | 7 | 7 | 8 | 9 | 6 | 6 |
| West | 6 | 7 | 8 | 8 | 7 | 6 | 8 | 6 | 8 | 12 | 6 | 5 |
| Midwest | 7 | 7 | 10 | 9 | 7 | 7 | 8 | 6 | 9 | 7 | 7 | 5 |
| Number of customers lost Monthly |
| | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
| North | 4 | 4 | 2 | 3 | 2 | 1 | 4 | 3 | 4 | 1 | 1 | 3 |
| South | 2 | 2 | 1 | 2 | 2 | 4 | 4 | 2 | 3 | 4 | 2 | 1 |
| East | 4 | 1 | 4 | 1 | 1 | 2 | 2 | 3 | 2 | 1 | 2 | 2 |
| West | 1 | 2 | 3 | 2 | 1 | 3 | 3 | 4 | 2 | 3 | 3 | 1 |
| Midwest | 2 | 3 | 1 | 2 | 3 | 3 | 2 | 1 | 3 | 2 | 1 | 4 |
M2341asdf
DashboardProjectDataCRMSales.xlsx
