Question: 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

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 constant as 0.7

Initially to start use Naive 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

For the above Data, forecast using Exponential

Period Period 1 Actual Demand 770 789 2 3 794 4 780 5 768 6 772 7 760 8 775 9 786 10 790

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)...

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...

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...

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...

the following data show the percentage of U.S. adults who were users Quantitative Methods The following data show the percentage of U.S adults who were users of tobacco for a recent 11-year period...

Use the following data below Month Sales ____________________________________________ Jan 17 Feb 18 Mar 22 Apr 19 May 23 June Using a two month moving average, what is the forecast for June? Using a...

Over the years, the Malaysia grocery distribution and sales industry has grown. Today, the total industry sales are in the tens millions of dollars. Major retailer such as DIY and Eco, added food to...

QUESTION 1 Based on the following data determine the sixth forecast using Exponential Smoothing with alpha of 15% Period Actual Sales 612 92 own- Based on the following data determine the sixth...

Canton Supplies, Inc. is a service firm that employs approximately 100 people. Because of the necessity of meeting monthly cash obligations, the chief financial officer wants to develop a forecast of...

Am A 2 AT1291 OPH H LAKE, FIRST NAME: Fabricace Manfacturing has the following data for their sales The the wing data to answer the Question 2015 Actual JAN 183 FER Jele MARC 2345 APRIL Hee MAY 2701...

8.) For each pair of triangles, decide whether they are congruent, not congruent, or there is not enough information to determine their congruence. Justify your argument with a flowchart or...

A Chinese exporter sells $400,000 of toys to a French importer. The Chinese exporter requires the French importer to obtain a letter of credit. When the bank accepts the draft the exporter discounts...

How to prepare income statements using net sales as the base: vertical analysis?

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...