budget plan for monthly tracking

The attached PDF document was developed in order to facilitate monthly tracking of expenses against plan for all natural account groupings within a regional marketing communications budget (details made generic for confidentiality).

  • Page 1 shows the overview of the plan for the year with breakouts of the straight-line budget-to-date, variance to straight-line, outlook and variance-to-outlook. The monthly totals below shows monthly expenses or plan by account; months with actuals posted to the GL are shown in green, months with projections only are shown in blue.
  • Page 2 shows the planned media mix by dollars for the year.
  • Pages 3 and 4 show tracking by account group for months (January and February) with actuals posted to the GL
  • Page 5 shows a month (March) with projections only. As financial results are posted to the GL, months were switched from projections to actuals.