Strayer Bus599 week 8 part 2 help
shanta1
week_4_excel.xlsxSheet1
| Marketing Expense Budget | Jan | Feb | Oct | Dec | 2014 | 2015 |
| Advertising | $15,000 | $15,000 | $20,000 | $10,000 | $150,000 | $250,000 |
| Websites | $2,000 | $3,000 | $2,000 | $2,000 | $25,000 | $28,000 |
| Catalogs | $3,000 | $11,800 | $8,000 | $5,000 | $113,300 | $125,000 |
| Promotions | $0 | $0 | $15,000 | $0 | $16,000 | $18,000 |
| Literature | $0 | $0 | $0 | $0 | $20,200 | $22,000 |
| Shows | $0 | $7,000 | $0 | $0 | $7,000 | $8,000 |
| PR | $0 | $0 | $0 | $0 | $1,000 | $1,000 |
| Service | $1,000 | $0 | $0 | $0 | $31,000 | $34,000 |
| Seminars | $2,000 | $1,000 | $500 | $250 | $10,250 | $11,000 |
| Training | $5,000 | $5,000 | $5,000 | $5,000 | $60,000 | $66,000 |
| Other | $1,000 | $1,000 | $1,000 | $1,000 | $12,000 | $15,000 |
| Total Marketing Expenses | $29,000 | $43,800 | $51,500 | $23,250 | $445,750 | $578,000 |
| %of Sales | 6.24% | 9.36% | 6.77% | 3.75% | 7.48% | 8.82% |
| Contribution Margin | $114,310 | $123,238 | $80,161 | $72,035 | $913,563 | $1,108,926 |
| Contribution Margin/Sales | 31.07% | 26.33% | 10.54% | 11.63% | 15.30% | 16.92% |
