Calculate the regression equation for preceding demand data

Assignment Help Operation Management

Reference no: EM132157292

Historical demand for a product is:

DEMAND

January 20

February 19

March 23

April 20

May 24

June 23

a. Using a weighted moving average with weights of 0.40 (June), 0.40 (May), and 0.20 (April), find the July forecast. (Round your answer to 1 decimal place.) July forecast

b. Using a simple three-month moving average, find the July forecast. (Round your answer to 1 decimal place.) July forecast

c. Using single exponential smoothing with ? = 0.30 and a June forecast = 14, find the July forecast. (Round your answer to 1 decimal place.) July forecast

d. Using simple linear regression analysis, calculate the regression equation for the preceding demand data. (Do not round intermediate calculations. Round your intercept value to 1 decimal place and slope value to 2 decimal places.) Y = + t

e. Using the regression equation in d, calculate the forecast for July. (Do not round intermediate calculations. Round your answer to 1 decimal place.) July forecast.

Reference no: EM132157292

Questions Cloud

Discuss how bernie madoff was able to conduct the fraud : Discuss how Bernie Madoff was able to conduct the fraud? What does it say about human nature?

How social media provides channels of communication : Describe how social media provides channels of communication. Discuss why shared resources are important.

Develop vision and foresight to prosper this century : Each of use need to develop vision and foresight to prosper this century.

What is the most important thing to know : What is the most important thing to know when programming in C#?

Calculate the regression equation for preceding demand data : Using simple linear regression analysis, calculate the regression equation for the preceding demand data.

Assess how a change agent can influence the generation : Assess how a change agent can influence the generation, direction, success or failure of a change initiative.

What are your goals for professional development : Use the questions in the table in chapter 3 on page 101 of your textbook as a guide as you write your personal philosophy of nursing.

Perspective so they can improve their recruitment process : What would you share with them about recruitment from an applicant’s perspective so they can improve their recruitment process?

An activity on an arrow network : Under what causes of action will Tabitha most likely succeed in her suit against Tessa? An activity on an arrow network.

User Account

All Pages