Our Services

Get 15% Discount on your First Order

PLEASE READ INSTRUCTIONS PROPERLY Forecasting Case Analysis MGT 3332 IMPORTANT:

April 3, 2024

PLEASE READ INSTRUCTIONS PROPERLY

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

1. Download the data file from Canvas site. Save the original download (just in case), and copy it into Excel spreadsheet.

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.

Period Price AIP ADV

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.

Grading Criteria

· Completeness/Correctness 70%

· Quality of Interpretations/Analysis 20%

· General Quality of Report/graphs/writing 10%

>Business & Finance homework help

Share This Post

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

Related Questions

Wk 6 – Apply: Summative Assessment: Earned Value Analysis Presentation Project managers need to be able to identify process improvements, processes to add, and

Wk 6 – Apply: Summative Assessment: Earned Value Analysis Presentation Project managers need to be able to identify process improvements, processes to add, and the business value in their project management processes because the components can either make money or lose money based on their cost and return to the

After discussing and potentially revising your thesis statement, it is time to outline your Research Paper. Do not underestimate the value of outlining!

After discussing and potentially revising your thesis statement, it is time to outline your Research Paper. Do not underestimate the value of outlining! You need a plan for completing this paper! Pay attention to “Preparing a Formal Outline,” beginning on page 441 of your textbook, and prepare your own Formal Outline, following

Around 1200-word research paper about Climate Change. Guide Questions： What is the history that has led to our current

Around 1200-word research paper about Climate Change. Guide Questions： What is the history that has led to our current understanding of the topic you are researching? Who were the scientists involved in the discovery / major advancements in the history and evolution of the subject (if your topic has any)?

RESPONSE INNOVATIVE INFORMATICS TOOLS AND APPLICATIONS TO CLINICAL PRACTICE Transforming Nursing

RESPONSE INNOVATIVE INFORMATICS TOOLS AND APPLICATIONS TO CLINICAL PRACTICE Transforming Nursing Read a selection of your colleagues’ blog posts and respond to two of your colleagues by expanding upon their responses or sharing additional or alternative perspectives. INNOVATIVE INFORMATICS TOOLS AND APPLICATIONS TO CLINICAL PRACTICE · Collapse SubdiscussionChinyere M Ofoegbu PEER #1 Chinyere M

2 [Note: To complete this template, replace the bracketed text with your own content. Remove this note before you submit your paper.] Final Project: [Name of

2 [Note: To complete this template, replace the bracketed text with your own content. Remove this note before you submit your paper.] Final Project: [Name of Project] [Name] Department of Psychology PSY-540-[Section Number] Cognitive Processes [Instructor Name] [Date] Problem Statement Contemporary Problem [Insert text.] Selected Area [Insert text.] Performance Issues

Instructions ASSIGNMENT 1: THEORIES OF DEVELOPMENT PRESENTATION In this assignment for this week you will need to create a Prezi. (www.prezi.com.

Instructions ASSIGNMENT 1: THEORIES OF DEVELOPMENT PRESENTATION In this assignment for this week you will need to create a Prezi. (www.prezi.com. Students can start a free 14 day trial) or PowerPoint that will highlight the important points of a theory that you will pick from this week’s reading and research.

Respond to the two posts. Due date 4/25/2024. 2.1 Discussion

Respond to the two posts. Due date 4/25/2024. 2.1 Discussion Love on Trial Cing As I reflect on my life, I find it hard to reflect on the time I feel like my love was on trial. I feel like I have never put myself in a situation where my

Consider the diagram below, use Dijkstra’s link-state routing algorithm compute the least cost path from X to all other nodes and show the resulting

Consider the diagram below, use Dijkstra’s link-state routing algorithm compute the least cost path from X to all other nodes and show the resulting forwarding table in x ………..

Instructions: Due Tuesday 03/3 At least 2 pages long with 3 peer-reviewed references. Mini Cases A14-53. Calculating

Instructions: Due Tuesday 03/3 At least 2 pages long with 3 peer-reviewed references. Mini Cases A14-53. Calculating ratios for companies within the same industry Select an industry you are interested in and select three companies within that industry. Obtain their annual reports by going to each company’s website and downloading

Definition of History: History is the study of past events, particularly human affairs. It encompasses the recording, analysis, and interpretation of

Definition of History: History is the study of past events, particularly human affairs. It encompasses the recording, analysis, and interpretation of events and their significance over time, often with the aim of understanding the present and anticipating the future. Lesson Notes for Form 1: Title: Introduction to History Objective: To

my name is Esteban Tankou below are the instructions for the assignment For this assignment, first read Glenn Lester et. al’s article “We Write Because We

my name is Esteban Tankou below are the instructions for the assignment For this assignment, first read Glenn Lester et. al’s article “We Write Because We Care: Developing Your Writerly Identity.”

Electronic monitoring is often seen as “a prison without bars.” However, when it comes to juvenile electronic monitoring, it is not considered punishment

Electronic monitoring is often seen as “a prison without bars.” However, when it comes to juvenile electronic monitoring, it is not considered punishment but is seen as rehabilitative. Young people who would otherwise be detained are placed on electronic monitoring which can be akin to house arrest. Violations can include

Assignment # 4-Research Paper Assignment Description: Research is synthesis and discovery. It creates opinions and shapes views. Your goal in this

Assignment # 4-Research Paper Assignment Description: Research is synthesis and discovery. It creates opinions and shapes views. Your goal in this paper is to solve a problem using the findings of other research projects. This means finding articles from the databases (especially the Opposing Viewpoints database) to support your solutions

Nursing Informatics in Health Care For this assessment, you will write a 4 pages evidence-based proposal to support the need

Nursing Informatics in Health Care For this assessment, you will write a 4 pages evidence-based proposal to support the need for a nurse informaticist in an organization who would focus on improving health care outcomes. First review the focus of the new nurse informaticist position you will propose by examining

The initial thread should be a minimum of 4 paragraphs for each part 1 and part 2. proper grammar and correct APA format are expected. Source no later than 5

The initial thread should be a minimum of 4 paragraphs for each part 1 and part 2. proper grammar and correct APA format are expected. Source no later than 5 years . Attachment below is the links to u

You will be assigned reading excerpts from the book, DivorcePoison, by Richard Warshak, as supplemental readings. Upon completion of theexcerpts, write a

You will be assigned reading excerpts from the book, DivorcePoison, by Richard Warshak, as supplemental readings. Upon completion of theexcerpts, write a personal reflection of what it was like to read thewords. Also answer the theme question, “How did you feel?.”