Back To Table of Contents

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
Print                          
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
                           

Back To Table of Contents

  Copyright, 2014, JaxWorks, All Rights Reserved.