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 |