Back To Table of Contents

Download This Workbook FREE

Media Forecast

For 2006
 
This worksheet helps you plan the monthly advertising amount your firm will use over the next year.
It also compares each month's actual expenditures to the forecast established at the beginning of the year.
                         
  RADIO   MAGAZINE   NEWSPAPER   DIRECT MAIL   BILLBOARD   TOTAL  
  Forecast Actual Forecast Actual Forecast Actual Forecast Actual Forecast Actual Forecast Actual
Jan $30,000 $40,000 $50,000 $40,000 $30,000 $40,000 $15,000 $16,000 $25,000 $30,000 $150,000 $166,000
Feb $20,000 $20,000 $40,000 $30,000 $20,000 $20,000 $15,000 $13,000 $30,000 $20,000 $125,000 $103,000
Mar $20,000 $20,000 $40,000 $30,000 $20,000 $20,000 $15,000 $13,000 $30,000 $20,000 $125,000 $103,000
Apr $30,000 $40,000 $50,000 $40,000 $30,000 $40,000 $15,000 $16,000 $25,000 $30,000 $150,000 $166,000
May $20,000 $20,000 $40,000 $30,000 $20,000 $20,000 $15,000 $13,000 $30,000 $20,000 $125,000 $103,000
Jun $30,000 $40,000 $50,000 $40,000 $30,000 $40,000 $15,000 $16,000 $25,000 $30,000 $150,000 $166,000
Jul $30,000 $40,000 $50,000 $40,000 $30,000 $40,000 $15,000 $16,000 $25,000 $30,000 $150,000 $166,000
Aug $30,000 $40,000 $50,000 $40,000 $30,000 $40,000 $15,000 $16,000 $25,000 $30,000 $150,000 $166,000
Sep $20,000 $20,000 $40,000 $30,000 $20,000 $20,000 $15,000 $13,000 $30,000 $20,000 $125,000 $103,000
Oct $30,000 $40,000 $50,000 $40,000 $30,000 $40,000 $15,000 $16,000 $25,000 $30,000 $150,000 $166,000
Nov $20,000 $20,000 $40,000 $30,000 $20,000 $20,000 $15,000 $13,000 $30,000 $20,000 $125,000 $103,000
Dec $20,000 $20,000 $40,000 $30,000 $20,000 $20,000 $15,000 $13,000 $30,000 $20,000 $125,000 $103,000
Year $300,000 $360,000 $540,000 $420,000 $300,000 $360,000 $180,000 $174,000 $330,000 $300,000 $1,650,000 $1,614,000
 

Back To Table of Contents

  Copyright, 2014, JaxWorks, All Rights Reserved.