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

### Using the 10k for the company Microsoft please complete the attached file.This file is too large to display.View in new window

Using the 10k for the company Microsoft please complete the attached file. This file is too large to display.View in new window

### Open the HomePrices.xlsx text file in Tableau.  Drag the Home Prices Spreadsheet into the data connection canvas. Run interpreter.  Review the Excel file

Open the HomePrices.xlsx text file in Tableau.  Drag the Home Prices Spreadsheet into the data connection canvas. Run interpreter.  Review the Excel file that Tableau generated. (Note that this dataset is formatted correctly) Create a bar chart showing the distribution of building types: Click on Sheet 1 Double-click on the

### Instructions: Due Thursday 04/18At least 3 paragraphs long with 3 peer-reviewed references.Why might it usually be desirable to settle a tax

Instructions: Due Thursday 04/18 At least 3 paragraphs long with 3 peer-reviewed references. Why might it usually be desirable to settle a tax dispute with an agent, rather than appealing to a higher level within the IRS? Also .. why might it sometimes be in your clients best interest to

### Instructions: Due Thursday 04/18At least 3 paragraphs long with 3 peer-reviewed references.Now that you have completed most of the class, what

Instructions: Due Thursday 04/18 At least 3 paragraphs long with 3 peer-reviewed references. Now that you have completed most of the class, what are some of biggest challenges that you think tax researchers are faced with and what are some ways to overcome those challenges?

### Please answers all the questions in the excel file according to the instruction i have provided and then provide me with the excel file with all the

Please answers all the questions in the excel file according to the instruction i have provided and then provide me with the excel file with all the answers. I really need help!

### I need some help! Part 1 Discussion Question1. How would you describe the basic components of WACC to a group of decision

I need some help!  Part 1 Discussion Question 1. How would you describe the basic components of WACC to a group of decision makers in a company? 2. On the most basic level, if a firm’s WACC is 12 percent, what does this mean? 3. In calculating the WACC, if

### In the fast-paced business world, maintaining a competitive edge often hinges on accessing the right talent at the right time. This is where staff

In the fast-paced business world, maintaining a competitive edge often hinges on accessing the right talent at the right time. This is where staff augmentation shines as a strategic solution.  To explore how staff augmentation can elevate your business operations, visit Sombrainc:    and discover tailored solutions designed to drive

### Analyze and define the problem to include possible political conflicts. Identify risks and challenges. Identify and construct policy alternatives and

Analyze and define the problem to include possible political conflicts. Identify risks and challenges. Identify and construct policy alternatives and solutions. Identify stakeholders and key roles. Identify funding opportunities, challenges, and budget cost factors; including saving measures. Select supportive and evaluative criteria. Identify incentives, subsidies, and potential benefits. Draw

### Provide a real public policy issue (local, state, or national) and select an appropriate criterion for policy prescription to use in deciding the

Provide a real public policy issue (local, state, or national) and select an appropriate criterion for policy prescription to use in deciding the policy’s effectiveness, efficiency, and adequacy. Provide some reasons why you selected the criterion (such as importance, application, or relevancy).

### Identify and discuss the six principles of control activities. Suggest the two most important principles for an online retail business versus a

Identify and discuss the six principles of control activities. Suggest the two most important principles for an online retail business versus a brick-and-mortar retail business. Provide support for your rationale.

### A MNC which has gone through an international stock market financing or international public debt market financing in the past 5 years, conduct a

A MNC which has gone through an international stock market financing or international public debt market financing in the past 5 years, conduct a comprehensive analysis on the decision making rational and provide an in-depth discussion about the related financial/business environment.

### 11 Foundational Concepts and Issues of Positive Psychology: The What and Why of HappinessI don’t think that my positive psychology story is

1 1 Foundational Concepts and Issues of Positive Psychology: The What and Why of Happiness I don’t think that my positive psychology story is all that unusual. In the mid-1990s I was happily engaged with investigating memory biases in depression (e.g., Watkins, 2002; Watkins, Martin, & Stern, 2000), but had

### Discussion 1.1 and 1.2 Respond to the following two discussion posts. Due 4/19/2024

Discussion 1.1 and 1.2 Respond to the following two discussion posts. Due 4/19/2024 A Prayer over You Kathryn     Prayer is such a powerful thing. I think praying for someone is one the most powerful things you can do for another. Prayer is my time where I feel like

### · Address the following prompts. · Prompt 1: In the section “Taking the Project Management Route”, the team is developing a schedule for

· Address the following prompts. · Prompt 1: In the section “Taking the Project Management Route”, the team is developing a schedule for the overall project. Discuss how a network diagram might come in handy for this task. What does the critical path have to do with this approach? Use

### Problem Set #7 Attached Files: ·  Building a Model – Marvel

Problem Set #7 Attached Files: ·  Building a Model – Marvel Renovations.xlsx  (18.835 KB) Start with the partial model in the file attached. Marvel Pence, CEO of Marvel’s Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the

### Can you calculate GMPV for the attached EXCEL sheet This file is too large to display.View in new window

Can you calculate GMPV for the attached EXCEL sheet  This file is too large to display.View in new window

### · Also, upload the work files from R (LastName_FirstName.r), separeated for Part 1,2 and 3. Excel is not suitable for this project and it will not

· Also, upload the work files from R (LastName_FirstName.r), separeated for Part 1,2 and 3. Excel is not suitable for this project and it will not be accepted. You must follow my code submission guideline. THERE IS NO EXCEPTION or PARTIAL CREDIT if you fail to comply. 1.  You MUST use

### This is a synthesis of research and common themes should form your supporting paragraphs

This is a synthesis of research and common themes should form your supporting paragraphs