Ask Business Management Expert

Module - Case: LINEAR REGRESSION FORECASTING AND DECISION TREES

Linear Regression Forecasting

Assignment Overview

Scenario: You are a consultant who works for the Excellent Consulting Group. Your client, the ABC Furniture Company, believes that there may be a relationship between the number of customers who visit the store during any given month ("customer traffic") and the total sales for that same month. In other words, the greater the customer traffic, the greater the sales for that month. To test this theory, the client has collected customer traffic data over the past 12-month period, and monthly sales for that same 12-month period (Year 1).

Case Assignment

1. Using the customer traffic data and matching sales for each month of Year 1, create a Linear Regression (LR) equation in Excel. Use the Excel template provided (see "Module Case - LR -Year 1" spreadsheet tab), and be sure to include your LR chart (with a trend line) where noted. Also, be sure that you include the LR formula within your chart.

2. After you have developed the LR equation above, you will use the LR equation to forecast sales for Year 2 (see the second Excel spreadsheet tab labeled "Year 2 Forecast"). You will note that the customer has collected customer traffic data for Year 2. Your role is to complete the sales forecast using the LR equation from Step 1 above.

3. After you have forecast Year 2 sales, your Professor will provide you with 12 months of actual sales data for Year 2. You will compare the sales forecast with the actual sales for Year 2, noting the monthly and average (total) variances from forecast to actual sales.

4. To complete the Module Case, write a report for the client that describes the process you used above, and that analyzes the results for Year 2. (What is the difference between forecast vs. actual sales for Year 2-by month and for the year as a whole?) Make a recommendation concerning how the LR equation might be used by ABC Furniture Company to forecast future sales.

Data: Download the Module Case template here: Data chart for BUS520 Case 3. Use this template to complete your Excel analysis.

Assignment Expectations

Excel Analysis

• Accurate and complete Linear Regression analysis in Excel.

Written Report

• Length requirements: 4-5 pages minimum (not including Cover and Reference pages). NOTE: You must submit 4-5 pages of written discussion and analysis. This means that you should avoid use of tables and charts as "space fillers."

• Provide a brief introduction to/background of the problem.

• Your written (Word) analysis should discuss the logic and rationale used to develop the LR equation and chart.

• Provide complete, meaningful, and accurate recommendation(s) concerning how the ABC Furniture Company might use the LR equation to forecast future sales. (For example, how reliable is the LR equation in predicting future sales?) What other recommendations do you have for the client?

Module- SLP

LINEAR REGRESSION FORECASTING AND DECISION TREES

Decision Trees

Scenario: You are a consultant who works for the Excellent Consulting Group. You have learned about three different investment opportunities and need to decide which one is most lucrative. Following are the three investment options and their probabilities:

Option A: Real Estate development. This is a risky opportunity with the possibility of a high payoff, but also with no payoff at all. You have reviewed all of the possible data for the outcomes in the next 10 years and these are your estimates of the cash payoff and probabilities:

Required initial investment: $0.75 million

High NPV: $5 million, Pr = 0.5
Medium NPV: $2 million, Pr = 0.3
Low NPV: $0, Pr = 0.2

Option B: Retail franchise for Just Hats, a boutique-type store selling fashion hats for men and women. This also is a risky opportunity but less so than Option A. It has the potential for less risk of failure, but also a lower payoff. You have reviewed all of the possible data for the outcomes in the next 10 years and these are your estimates of the payoffs and probabilities:

Required initial investment: $0.55 million
High NPV: $3 million, Pr = 0.75
Medium NPV: $2 million, Pr = 0.15
Low NPV: $1 million, Pr = 0.1

Option C: High Yield Municipal Bonds. This option has low risk and is assumed to be a Certainty. So there is only one outcome with probability of 1.0:

Required initial investment: $0.75 million

NPV: $1.5 million, Pr = 1.0

Assignment

Develop an analysis of these three investments, and determine which of them you should choose. Be sure to account for cash paid for each of the three alternatives. If you do not recall how to do this, review the practice exercises in the Background page. Do your analysis in Excel using the Decision Tree add-in.

Write a report to your private investment company and explain your analysis and your recommendations. Provide a rationale for your decision.

Upload both your written report and Excel file with the decision tree analysis to the SLP 3 Dropbox.

SLP Assignment Expectations

Analysis

• Accurate and complete Excel analysis.

Written Report

• Length requirements: 2-3 pages minimum (not including Cover and Reference pages)
• Provide a brief introduction to/background of the problem.
• Written analysis that supports Excel analysis and provides thorough discussion of assumptions, rationale, and logic used.
• Complete, meaningful, and accurate recommendation(s).

Business Management, Management Studies

  • Category:- Business Management
  • Reference No.:- M92278439

Have any Question?


Related Questions in Business Management

Name a company that addressed a recent ethical problem in a

Name a company that addressed a recent ethical problem in a positive way. Also, explain how or if this positively affects us as a community?

When it is appropriate to use the trade-off process what

When it is appropriate to use the trade-off process. What conditions apply, and the technical evaluation criteria that might be used?

Need help with a essay with the following phrase for

Need help with a essay with the following phrase for analyzing : " Capitalism is at the heart of how people and organisations are managed in contemporary society" May i ask for a better explanation of the question? Also ...

How could these three tenets of the auburn creed be used to

How could these three tenets of the Auburn Creed be used to motivate others: "I believe that this is a practical word and that I can count only on what I earn. Therefore, I believe in work, hard work." "I believe in educ ...

How can these two tenets of the auburn creed by used in

How can these two tenets of the Auburn Creed by used in addressing teamwork issues: "I believe in honesty and truthfulness, without which I cannot win the respect and confidence of my fellow men." "I believe in the human ...

Discuss the advantages of having and interacting in a

Discuss the advantages of having and interacting in a diverse workplace. Consider the wide range of ideas and perspectives that a range of team members bring to a team, that are of differing ages, ethnic backgrounds and ...

Parmigiano-reggiano global recognition of geographical

Parmigiano-Reggiano: Global Recognition of Geographical Indications What historical factors have helped support the consortium's claims for the geographic specificity of Parmigiano-Reggiano and Parmesan? What are the eco ...

Communication planthis communication plan will be a roadmap

Communication Plan This communication plan will be a roadmap on how the new division will best be able to communicate with Biotech's corporate headquarters, suppliers, other divisions, and internally. This should lay out ...

Discuss strategies to obtain feedback from a customer and

Discuss strategies to obtain feedback from a customer and clients when working in sales.

Describe different networking methods and the advantages

Describe different networking methods and the advantages and disadvantages of them?

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As