Bubble Up Bottling Company Prepare forecast for the soft drink industry using Seasonal Model method.
Prepare market share forecast using Linear Regression method.
Calculate Bubble Up Company forecast by multiplying market share with industry forecast.
Answer to Computer Assignment FAQ:
Question #1) How to calculate Bubble up company forecast?
Steps:
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.
Question #2) How to write the report?
Executive Summary-- This is the summary of the report about one paragraph long.
Problem Definition-- Describe is your words what problem you are analyzing, e. g. forecasting industry sales and Bubble Up market share and then calculating Bubble Up sales forecast etc.
Solution Procedure-- Write about the models you are using and justify why that model is being used. For example, linear trend model should be used when the time series has linear trend.
Results-- Write the results of your analysis.
Conclusion and recommendation-- write any conclusions.