Description of this paper

The Bubble Up Bottling Company of Brussels, Belgium, is interested in forecasting regional sales of Bubble U

Description

solution


Question

Question;he Bubble Up Bottling Company of Brussels, Belgium, is interested in forecasting regional sales of Bubble Up over the next two years. The company has analyzed Bubble Up?s market share for its region over the past twenty quarters. Market share has generally been growing as indicated in the following table:Year Season Bubble Up?s Market Share (in %)1 Winter 6.421 Spring 6.581 Summer 6.991 Fall 6.822 Winter 6.642 Spring 6.462 Summer 6.702 Fall 7.003 Winter 6.703 Spring 6.843 Summer 6.783 Fall 6.484 Winter 6.934 Spring 6.794 Summer 6.834 Fall 7.215 Winter 7.735 Spring 8.165 Summer 8.365 Fall 8.23During the same five-year period, total soft drink sales in the region (as measured in 100,000s of cases) have been as follows:Year Season Sales in Region (in 100,000s of cases)1 Winter 1141 Spring 1301 Summer 1581 Fall 1312 Winter 1142 Spring 1462 Summer 1772 Fall 1423 Winter 1243 Spring 1513 Summer 1753 Fall 1464 Winter 1324 Spring 1604 Summer 1844 Fall 1445 Winter 1345 Spring 1665 Summer 2055 Fall 148The company wants to forecast sales for the next two years (6 and 7).Calculate forecast for soft drink industry by using classical decomposition.Calculate Bubble Up Company's market share of the industry sales using linear regression model.Calculate Bubble Up company's forecast by taking market share percent of the industry sales. For example, if the industry sales for a quarter are 100,000 units and Bubble Up market share for the same quarter is 7%, then Bubble Up sales forecast for that quarter will be 7,000 units.

 

Paper#62219 | Written in 18-Jul-2015

Price : $25
SiteLock