Calculate the regression equation for preceding demand data

Assignment Help Operation Management

Reference no: EM13821758

I need all work completed in excel spread sheet with all steps and formulas screen shoted. Any and all work done by hand needs to be shown how to complete. If it can be competed in excel, it must be completed in excel and show all steps.

Historical demand for a product is:

DEMAND

January 12

February 11

March 15

April 12

May 16

June 15

Using a weighted moving average with weights of 0.60, 0.30, and 0.10, find the July forecast. Remember to use the largest weight for the most recent month.

Using the simple three-month moving average, find the July forecast.

Using single exponential smoothing with an α of .20 and a June forecast of 13, find the July forecast. Make whatever assumptions you wish.

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

Using the regression equation in d, calculate the forecast for July.

Reference no: EM13821758

Questions Cloud

Identify tim''s key success factors : You are a marketing consultant to Tim's Coffee Shoppe. A way for Tim's Coffee Shoppe to determine the advantages (or weaknesses) Tim's has as compared to their competitors is through doing a Competitive Profile Matrix (CPM). When you identify Tim'..

Explain the concept of transformational leadership : Explain the concept of transformational leadership. In what ways do transformational leaders affect subordinates

Increased competition due to data leakage from internet : When Technology Company faces increased competition due to data leakage from internet, what Business Information system could help them to face the competition that now has result of their research and technical details to their new product?

Experience in the public and nonprofit sector : Using the assigned readings, your work experience in the public and nonprofit sector, and the knowledge you have gained in this MPA program as a guide, address the following question in a detailed fashion:

Calculate the regression equation for preceding demand data : Using a weighted moving average with weights of 0.60, 0.30, and 0.10, find the July forecast. Remember to use the largest weight for the most recent month. Using the simple three-month moving average, find the July forecast. Using simple linear regre..

Write an essay about changing our lives : Write an essay about "Changing Our Lives".

Mis for decision making : There are many solutions today that can help organizations reduce their need for an in-house MIS for decision making or at least provide better storage solutions. With the amount of data that organizations collect and utilize, they need to conside..

Create and describe four different executional frameworks : Create and describe four different executional frameworks using the same USP. Describe a fifth framework

Playing politics is the most effective way : Why is it that sometimes "playing politics" is the most effective way of achieving objectives? Should an organization be concerned about it? why or why not?

User Account

All Pages