Question: 2) For the above Data, forecast using Exponential smoothing with a) Exponential smoothing constant as 0.3 b) Exponential smoothing constant as 0.5 c) Exponential smoothing

2) For the above Data, forecast using Exponential smoothing with a) Exponential smoothing constant as 0.3 b) Exponential smoothing constant as 0.5 c) Exponential smoothing constant as 0.7 Initially to start use Nave method for period 2 and compute using exponential smoothing. Validate the answer for first two periods and last period manually Take screen shot for all the three and paste. Observe what happens to the graph, MAD, MSE. Your observations 2) For the above Data, forecast using Exponential smoothing with a) Exponential smoothing constant as 0.3 b) Exponential smoothing constant as 0.5 c) Exponential smoothing constant as 0.7 Initially to start use Nave method for period 2 and compute using exponential smoothing. Validate the answer for first two periods and last period manually Take screen shot for all the three and paste. Observe what happens to the graph, MAD, MSE. Your observations

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!

Solve the Problem and verify your answers using the Excel Software A) The sales data of company for 10 years is given the following table Forecast for the company using a) 3 period moving average b)...

Period Actual Period Demand 1 770 2 789 3 794 4 780 5 768 6 772 7 760 8 775 9 786 10 790 2) For the above Data, forecast using Exponential smoothing with Exponential smoothing constant as 0.3...

For the above Data, forecast using Exponential smoothing with ( please solve by Excel) a) Exponential smoothing constant as 0.3 b) Exponential smoothing constant as 0.5 c) Exponential smoothing...

sales: 4 4 1 0 , 4 5 4 0 , 4 5 2 0 , 4 4 8 0 , 4 3 9 0 , 4 5 3 0 Calculate the forecast for the 4 th , 5 th , 6 th and 7 th months using 3 - month simple moving average, and 3 - month weighted moving...

please explain answers solve the equation, using rhe graph provided with the questions below the chart PROBLEM 1: In an assembly line, there are 7 workstations, as shown below. In row 1, you are...

Calculate forecast using exponential smoothing and weighted moving average methods of the following time wees indicated as Calculate Mean Squared Error (MSE) for both the forecasted values. (Marks...

With = 0 . 3 and the initial forecast for January of $ 1 . 9 0 , using exponential smoothing, the forecast is: ( Round your responses to two decimal places. ) With = 0 . 5 and the initial forecast...

b. Compute all possible forecasts using exponential smoothing with a smoothing coefficient jo of 0.3. (Negative amounts should be indicated by a minus sign. Round your answers to ] decimal places.)...

The actual demand for the patients at National Liaquat Emergency Hospital for the first 6 weeks of this year follows: Weeks Actual No of Patients 1 70 2 56 3 85 4 45 5 96 6 52 Clinic Administrator...

On December 31, 2012, PT Hutama Jaya borrowed $1,800,000 at an interest rate of 12% per annum to finance the construction of its building. In 2013 the company made expenditures related to the...

Aspire food group: marketing a cricket protein brandcase study 1-You have been hired as a marketing consultant for Aspire tohelp change attitudes and persuade people to purchase cricket-basedfoods....

2 The compensation associated with restricted stock under a stock award plan is: 0 t . 2 0 5 5 Multiple ChoiceSavedThe book value of an unrestricted share of the same stock times the number of...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...