Excel Intermediate
Shavone05
ex_k-1.xlsxProjected Sales
| 2011 Projected Sales | ||||||||
| Jan | Feb | Mar | Apr | May | Jun | Total | Percent of Total Sales | |
| U.S. | $75,598 | $53,876 | $55,722 | $51,706 | $85,063 | $75,409 | $397,374 | 30.32% |
| Canada | $53,776 | $59,774 | $63,012 | $58,970 | $56,211 | $57,346 | $349,089 | 26.64% |
| U.K. | $50,722 | $54,344 | $53,092 | $60,096 | $51,398 | $34,987 | $304,639 | 23.25% |
| Australia | $30,449 | $45,998 | $50,870 | $49,346 | $38,734 | $43,987 | $259,384 | 19.79% |
| Total | $210,545 | $213,992 | $222,696 | $220,118 | $231,406 | $211,729 | $1,310,486 | |
| Percent of Total Sales | 16.07% | 16.33% | 16.99% | 16.80% | 17.66% | 16.16% |
Budgets
| 2011 Budgets | ||||||||
| Communications | Equipment | Advertising | Salaries | Rent | Entertainment | Travel | Total | |
| U.S. | $62,863 | $18,456 | $55,722 | $371,706 | $65,409 | $81,457 | $61,946 | $717,559 |
| Canada | $68,765 | $19,451 | $43,012 | $388,970 | $55,346 | $79,435 | $59,834 | $714,813 |
| U.K. | $69,522 | $14,567 | $43,092 | $370,096 | $59,987 | $74,579 | $57,345 | $689,188 |
| Australia | $68,489 | $10,435 | $50,870 | $379,346 | $61,987 | $68,934 | $50,123 | $690,184 |
| $2,811,744 | ||||||||
| Constraints | ||||||||
| Total region budget | 750,000 | |||||||
| Minimum travel budget | 80,000 | |||||||
| Minimum entertainment budget | 93,000 | |||||||
| Total budget | 3,000,000 |
