WILMORE PAPER COMPANY

Advertising Budget Model

Time Series Analysis by Burcu Arikan, Spring 2008

Introduction Specification Estimation Verification Validation Budget

Introduction

Time-series analysis allows researchers to predict future values of time series variables. In time-series analysis, researchers look for systematic patterns in the data in order to make inferences about future data outcomes. The belief that the past behavior of a variable may continue into the future constitutes the rational basis behind the use of time series forecasting. In the business world, companies must plan for the future on a permanent basis if they are to capitalize on market opportunities and timely address potential problems. Time series can make a valuable contribution in this quest.

In this study, 30 quarters of advertising expenditures and sales data for Anheuser-Busch (see below) were analysed with the purpose of predicting future Anheuser-Busch sales.

To attain our objective, a four-step building process is followed: (I) Specification, (II) Estimation, (III) Verification, and (IV) Validation. Each one of these stages is detailed in the corresponding linked page of this website.

TABLE 1: ADVERTISING EXPENDITURES AND SALES

Quarters Year Adv $ (1000s) Sales $ (1000's)
Fall 2000 158 389
Winter 2001 218 483
Spring 2001 600 599
Summer 2001 666 633
Fall 2001 749 728
Winter 2002 699 823
Spring 2002 964 1001
Summer 2002 1100 1490
Fall 2002 1251 1823
Winter 2003 1566 1919
Spring 2003 1488 2506
Summer 2003 1776 2671
Fall 2003 1888 2722
Winter 2004 1802 2922
Spring 2004 1880 2991
Summer 2004 2253 3833
Fall 2004 2211 3811
Winter 2005 2340 3900
Spring 2005 2681 4200
Summer 2005 2821 4321
Fall 2005 2931 4333
Winter 2006 3123 4376
Spring 2006 3100 4321
Summer 2006 3452 4411
Fall 2006 3631 4512
Winter 2007 3588 4523
Spring 2007 3621 4577
Summer 2007 3735 4576
Fall 2007 3822 4577
Winter 20008 3991 4611