Forecasting Case Analysis

MGT 3332

IMPORTANT:

·
All team members must do all parts of the project and compare results. DO NOT divide up parts of the project as many parts are related.

·
Teams must submit both Word and Excel files of their work to Canvas.

·
Do not submit any file until all team members agree on the deliverables.

·
Only one team member will submit the files. There is no second chance on submittal.

·
Post names of all contributing team members on top of Word file.

The Fresh Detergent Case

Enterprise Industries produces Fresh, a brand of liquid detergent. In order to more effectively manage its inventory, the company would like to better predict demand for Fresh. To develop a prediction model, the company has gathered data concerning demand for Fresh over the last 33 sales periods. Each sales period is defined as one month. The variables are as follows:

·
Period = Time period in month

·
Demand = Y = demand for a large size bottle of Fresh (in 100,000)

·
Price = the price of Fresh as offered by Ent. Industries

·
AIP = the Average Industry Price

·
ADV = Enterprise Industries Advertising Expenditure (in \$100,000) to Promote Fresh in the sales period.

·
DIFF = AIP – Price = the “price difference” in the sales period

IMPORTANT: Your downloaded data file should match both your section number and your team number. This is shown in both the file name and in the title line of the file. If you download and use the wrong data file for your team, you will fail the assignment!

2. Make time series scatter plots of all five variables (five graphs). Insert trend line, equation, and R-squared. Observe graphs and provide interpretation.

IMPORTANT:

· These and all other charts must be made in Excel. You can copy & paste them as images into your Word if you wish; otherwise, just refer in the word document to the Chart location in your Excel worksheet.

· These and all other charts should be of quality sufficient for presentation to senior management at Enterprise Industries. All charts should have titles, legends, and both axes labeled.

3. Construct scatter plots of Demand vs. DIFF and Demand vs. ADV, Demand vs. AIP, and Demand vs. Price. Insert fitted line, equation, and R-squared. Observe graphs and provide interpretation. Note that Demand is always on the Y axis.

4. Obtain the correlation matrix for all six variables and rank the variables that have strong correlation with Demand (must use absolute value.) Explain your findings in plain language.

5. Use 3-month and 6-month moving averages to predict the demand for October 2023. Find MAD for both forecasts and identify the preferred one based on each calculation. Is the moving average suitable method for forecasting for this data set? Explain your reasoning.

6. Use Exponential smoothing forecasts with alpha of 0.1, 0.2, …, 0.9 to predict October 2023 demand. Identify the value of alpha that results in the lowest MAD.

7. Find the monthly seasonal indices for the demand values using Simple Average (SA) method. Find the de-seasonalized demand values by dividing monthly demand by respective seasonal indices.

8. Use regression to perform trend analysis on the de-seasonalized demand values. Is trend analysis suitable for this data? Find MAD and explain the Excel Regression output (trend equation, r, r-squared, goodness of model).

9. Find the seasonally adjusted trend forecasts for October through December 2023.

10. Perform simple linear regression analysis with ADV as the independent variable to predict demand. Write the complete equation, find MAD and explain the Excel Regression output.
Make sure to use the de-seasonalized demand data for this model and all future models.

11. Repeat part (10) with DIFF as the independent variable.

12. Construct multiple linear regression model with Period, AIP, DIFF, and ADV as independent variables. Formulate the equation, find MAD, and explain the output. Rank variables based on their degree of contribution to the model. Observe significant F, R-squared, and p-values and explain.

13. Perform multiple linear regression analysis with Period, DIFF, and ADV as independent variables. Formulate the equation and find MAD. Which variable is the most significant predictor of demand? Rank the independent variables based on their degree of contribution to the model. Observe significant F, R-squared, and p-values and explain.

14. Use the model obtained in parts 13 and make forecasts for the following months. Make sure to seasonalize final forecasts.

Oct. 2023 \$7.44 \$7.78 \$11.03

Nov. 2023 \$7.58 \$7.83 \$11.63

Dec. 2023 \$7.93 \$8.08 \$11.83

15. Provide a case conclusion based on above analysis.

· Completeness/Correctness 70%

· Quality of Interpretations/Analysis 20%

· General Quality of Report/graphs/writing 10%

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

i want a excel sheet based on the report that i am uploading Running Head: CRYPTOCURRENCY DIVERSIFICATION 1CRYPTOCURRENCY

i want a excel sheet based on the report that i am uploading  Running Head: CRYPTOCURRENCY DIVERSIFICATION 1 CRYPTOCURRENCY DIVERSIFICATION 4 Student Name Tutor’s Name Course Date Abstract Legislative bodies, industry professionals, the media, and academics from various fields are finding cryptocurrency to be an intriguing subject. The study finds

Access 365/2019 Capstone – Level 3 Working with a Sales Database (EX.03)

Access 365/2019 Capstone – Level 3 Working with a Sales Database (EX.03)

Due Sunday 04/21Write a research paper between 10-12 pages in length.  You will be researching tax options to solve at least 3 issues for a company

Due Sunday 04/21 Write a research paper between 10-12 pages in length.  You will be researching tax options to solve at least 3 issues for a company of your choice.  You should make sure that at least 1 of these issues is related to a tax issue pertaining to being

• Due Sunday 04/14 @ pages APA with reference • Research Case G-8 (p.482) using current literature • Research Case G-13 (p.483) using current

• Due Sunday 04/14 @ pages APA with reference • Research Case G-8 (p.482) using current literature • Research Case G-13 (p.483) using current literature • Research Case G-16 (p.483) using current literature • Research Case G-19 (p.484) using current literature G-8 Ann is required under a pre-TCJA divorce decree

Describe the good. What are its main characteristics? What are some of the substitutes and complements for the good? Indicate whether the good is a

Describe the good. What are its main characteristics? What are some of the substitutes and complements for the good? Indicate whether the good is a normal good or an inferior good. Explain the reasons for your choice. Identify and describe the main nonprice factors that could cause an increase

Please respond to the following:Define a policy argument or claim that is specific and evaluative. Topics may include crime, global warming,

Please respond to the following: Define a policy argument or claim that is specific and evaluative. Topics may include crime, global warming, unemployment, whistleblowing, and others. Discuss the benefits of structuring arguments before and while developing written documents.

Distinguish between the income statement of a service company and a merchandising company. Identify at least two critical items of a multistep income

Distinguish between the income statement of a service company and a merchandising company. Identify at least two critical items of a multistep income statement of a merchandising company that are useful to creditors. Provide a rationale for your response.

Evaluate these TWO comments on the merit of their arguments. See if you agree or disagree with what they say and explain why. The comments refer to this

Evaluate these TWO comments on the merit of their arguments. See if you agree or disagree with what they say and explain why. The comments refer to this topic – “It is argued that expansionary monetary policy of US Fed and other central banks and the resulting near zero interest rates

Homework In  All Marketers are Liars, Godin discusses the effect of a customer’s worldview on their reaction to products and services,

Homework  In  All Marketers are Liars, Godin discusses the effect of a customer’s worldview on their reaction to products and services, as well as its impact on their purchasing decisions and recommendations to friends and family. Consider how Godin’s ideas apply to you, by responding to the questions below: ·

you need prepare a report based on the excel sheets that i have uploaded FN626: FINANCE LIVEASSIGNMENT 3: BITCOIN AND PORTFOLIO

you need prepare a report based on the excel sheets that i have uploaded  FN626: FINANCE LIVE ASSIGNMENT 3: BITCOIN AND PORTFOLIO DIVERSIFICATION Drawing on your modules to date and the Presentations made during Finance Live lectures, you are asked to complete the following individual project. Project “Given the returns

you need prepare a report based on the excel sheets that i have uploaded

you need prepare a report based on the excel sheets that i have uploaded

Assume you work in the marketing department for a luggage manufacturer.  You have been tasked with identifying cobranding opportunities.  Determine

Assume you work in the marketing department for a luggage manufacturer.  You have been tasked with identifying cobranding opportunities.  Determine  four companies/brands that would work well in being paired with the brand you choose.  Describe each of the cobranding opportunities in  detail.  Give  specific examples of how you would promote the two

Empowerment hub for young women speak in 1st person I will put my name in the spots  Business Plan Step 1: Topic Step 2: Background ResearchReview

Empowerment hub for young women speak in 1st person I will put my name in the spots  Business Plan Step 1: Topic Step 2: Background Research Review literature related to your      topic to understand the theoretical and practical aspects. Identify key concepts, theories,      and empirical findings relevant to your research

I need you to complete a presentation on ‘Financial Decision Making.’ Here are the specific requirements:Complete a PowerPoint presentation according

I need you to complete a presentation on ‘Financial Decision Making.’ Here are the specific requirements: Complete a PowerPoint presentation according to the requirements. Based on the PowerPoint, prepare a speech of approximately 15-20 minutes. Note: I have uploaded all the textbooks related to this course. I need you to

Use the file attached Visualization Plan. Please include the following You will make at least six charts, including at least one geographic map, at

Use the file attached  Visualization Plan. Please include the following  You will make at least six charts, including at least one geographic map, at least one bar, at least one table, and at least one line chart. Describe how your data set(s) will provide enough variables to create the required