Question: 1) Calculate three forecasts using the following data. First, for periods 4 through 10, develop the exponentially smoothed forecasts using a forecast for period 3

1) Calculate three forecasts using the following data. First, for periods 4 through 10, develop the exponentially smoothed forecasts using a forecast for period 3 (F3) of 120.0 and an alpha of 0.3. Second, calculate the three-period moving-average forecast for periods 4 through 10. Third, calculate the weighted moving average for periods 4 through 10, using weights of .60, .30, and .10. Calculate the mean absolute deviation (MAD) and the cumulative sum of forecast error (CFE) for each forecasting procedure. Which forecasting procedure would you select? Why?

Month	Demand
1	120
2	115
3	125
4	119
5	127
6	114
7	120
8	124
9	116
10	137

Please solve by hand is possible.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Calculate three forecasts using the following data. First, for periods 4 through 11 , develop the exponentially smoothed forecasts using a forecast for period 3( F_3) of 120.0 and an alpha of 0.3. Sec

Question #2 Month Demand 1 45 2 48 3 43 4 48 5 49 6 54 7 47 8 50 9 46 10 47 Using the table above, calculate two forecasts using the following method:- First, for periods 4 through 10, develop the...

Which forecasting method would be chosen based on MAD? Group of answer choices Exponencial Smoothing Simple Moving Average Weighted Moving Average 2) Which forecasting method would be chosen based on...

I need your help with this: Can you please quote from the attached chapters / resource if possible? Corporations often use different costs of capital for different operating divisions. Using an...

This requires two forecasts. organic strategy, merger or acquisition growth strategy and analysis Week 8 Growth Analysis - Organic & Merger/Acquisition (Rev. 030917) MAKE SURE THAT YOU DOWNLOAD THE...

Hello, Can you help me with the following question for a mini case: f. Continue with the same assumptions for the No Change scenario from the previous question, but now forecast the balance sheet and...

Hello again, this is another class and I need your help again. I misunderstood the start date of the class so I'm a bit late for this first week so I'm sorry for having to ask you to finish some of...

i need answers for this homework. if possible with all the steps included Leadstar College of Management and Leadership Faculty of Business and Leadership FINANCIAL MANAGEMENT Assignment, Version-2...

please find the attachments and provide your solutions as appropriate soon. Leadstar College of Management and Leadership Faculty of Business and Leadership FINANCIAL MANAGEMENT Assignment, Version-2...

Develop a brief answer to each of the following questions. 1. Which account would be most likely to have an account balance that is not normal? 2. A company incurs a cost for a part that is needed to...

Describe how a WBS and a schedule work together.

A ( n ) _ _ _ _ _ is a type of mutual fund with a mix of stocks that mimics the components of a financial market index. bond fund index fund managed fund margin fund Assessment question

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...