CIS Excel
MUMEI
EX11-1.xlsxProjected Sales
| 2018 Projected Sales | ||||||||
| Jan | Feb | Mar | Apr | May | Jun | Total | Percent of Total Sales | |
| New York | $98,475 | $75,189 | $71,423 | $84,664 | $91,926 | $98,244 | $519,921 | 31.68% |
| Toronto | $62,868 | $76,326 | $79,244 | $69,688 | $71,015 | $70,388 | $429,529 | 26.17% |
| London | $63,573 | $61,756 | $65,681 | $70,988 | $68,191 | $39,334 | $369,523 | 22.52% |
| Sydney | $41,043 | $55,657 | $64,539 | $63,708 | $46,868 | $50,224 | $322,039 | 19.62% |
| Total | $265,959 | $268,928 | $280,887 | $289,048 | $278,000 | $258,190 | $1,641,012 | |
| Percent of Total Sales | 16.21% | 16.39% | 17.12% | 17.61% | 16.94% | 15.73% | ||
Budgets
| 2018 Budgets | ||||||||
| Communications | Equipment | Advertising | Salaries | Rent | Entertainment | Travel | Total | |
| New York | $64,491 | $17,640 | $56,280 | $375,425 | $66,065 | $80,281 | $73,565 | $733,747 |
| Toronto | $70,452 | $18,645 | $44,442 | $391,859 | $55,900 | $81,330 | $71,435 | $734,063 |
| London | $68,217 | $16,712 | $43,522 | $373,796 | $60,586 | $81,425 | $70,920 | $715,178 |
| Sydney | $70,173 | $11,539 | $51,378 | $383,139 | $62,606 | $79,725 | $70,625 | $729,185 |
| $2,912,173 | ||||||||
| Constraints | ||||||||
| Total region budget | 775,000 | |||||||
| Minimum travel budget | 83,000 | |||||||
| Minimum entertainment budget | 95,000 | |||||||
| Total budget | 3,100,000 | |||||||
