Download This Workbook FREE
Advertising Expenditures by Media |
|||||||||||||
| For the year ended 12/31/2002 | |||||||||||||
| This worksheet can be used to summarize actual advertising expenditures or to plan expenditures for an upcoming month period. It is made up of three common advertising media: print, broadcast, and direct mail. | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Totals | |
| Newspaper | $10,000 | $20,000 | $10,000 | $20,000 | $10,000 | $20,000 | $10,000 | $20,000 | $10,000 | $20,000 | $10,000 | $20,000 | $180,000 |
| Newspaper | $10,000 | $20,000 | $10,000 | $20,000 | $10,000 | $20,000 | $10,000 | $20,000 | $10,000 | $20,000 | $10,000 | $20,000 | $180,000 |
| Newspaper | $10,000 | $20,000 | $10,000 | $20,000 | $10,000 | $20,000 | $10,000 | $20,000 | $10,000 | $20,000 | $10,000 | $20,000 | $180,000 |
| Magazine | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $36,000 |
| Trade Journal | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $24,000 |
| Totals | $35,000 | $65,000 | $35,000 | $65,000 | $35,000 | $65,000 | $35,000 | $65,000 | $35,000 | $65,000 | $35,000 | $65,000 | $600,000 |
| Broadcast | |||||||||||||
| Radio | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $30,000 |
| Radio | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $24,000 |
| Radio | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $12,000 |
| Cable | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $30,000 |
| TV | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $12,000 |
| Totals | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $108,000 |
| Direct Mail | |||||||||||||
| Brochure | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $12,000 |
| Brochure | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $24,000 |
| Brochure | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $12,000 |
| Coupon | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $24,000 |
| Coupon | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $24,000 |
| Totals | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $96,000 |
| Other | |||||||||||||
| Point of Sale | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $24,000 |
| Other | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $24,000 |
| Other | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $24,000 |
| Other | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $24,000 |
| Totals | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $96,000 |
| Totals | $60,000 | $90,000 | $60,000 | $90,000 | $60,000 | $90,000 | $60,000 | $90,000 | $60,000 | $90,000 | $60,000 | $90,000 | $900,000 |
© Copyright, 2007, Jaxworks, All Rights Reserved.