Reference no: EM131041108
Case : Bubble Up Bottling Company
Prepare forecast for the soft drink industry using Classical Decomposition method.
Prepare market share forecast using Linear Regression method.
Calculate Bubble Up Company forecast by multiplying market share with industry forecast.
Write a 2-3 page report single space to present your analysis and attach computer printouts to the report.
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?
Submit the report (2 to 3 pages long) in the following format.
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.
Attach computer outputs, graphs, charts to the report.
Attachment:- bubble_up_case_and_data.rar
|
Describe the policy changes would you would like to make
: Unfortunately for you, you have been elected President of the United States on a write in ballot. Your first priority is health care reform. Describe the policy changes would you would like to make
|
|
Being united in abussines combination
: Prior to being united in abussines combination Atkins inc and waterson corrparation had the following stockholders equity figures. Common stock 180000
|
|
What will be the impact on price and quantity in the market
: Using demand and supply analysis what will be the impact on price and quantity in the market for yoga services.
|
|
Assembly line capable of producing
: Presto frozen pizza company has determined that it needs an assembly line capable of producing 60 pizzas per hour. The following information is given for the company and its process.
|
|
How to calculate bubble up company forecast
: 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 f..
|
|
Estimates that next year its consumer loan portfolio
: EZ-Credit, Inc., has $80 million in consumer loans with an average interest rate of 13.5 percent. The bank also has $64 million in home equity loans with an average interest rate of 9 percent. Finally, the company owns $6 million in corporate secu..
|
|
What is the maximum profit it can make
: themarginal revenue schedule is MR = 540 - 0.6q2 and total fixed cost isRs. 65 what is the maximum profit it can make?
|
|
Screenshot example of a successful result
: You can see the Medusa software post a success result in this video. There is also a screenshot example of asuccessful result on page 84 of the textbook.
|
|
Find the deflection right and left side of center wheel
: Calculate the dynamic bending moment and deflection of rail with Winkler's theory under the point that is demonstrating - Find the deflection and moment right and left side of center wheel in cm regarding the day of your birth
|