Question: Using the data in the following table, a) compute an exponentially smoothed forecast with alpha = .30 through July, assuming the forecast for January is

Using the data in the following table, a) compute an exponentially smoothed forecast with alpha = .30 through July, assuming the forecast for January is 80. b) compute the MAD for the forecast. Month Demand January 80 February 113 March 70 April 91 May 105 June 100 Using the data in problem 1, a) Compute 3-month moving average forecasts for all the months. b) Compute MAD for the forecast. c) Is 3-month moving average better than the exponentially smoothed forecast for this data? Explain and provide support for your decision

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!

Using the data in the following table, a) compute an exponentially smoothed forecast with alpha - 30 through July, assuming the forecast for January is 80. b) compute the MAD for the forecast. Demand...

(15 Points) Using the data in the following table, a) compute an exponentially smoothed forecast with alpha = 20 through May. b) compute the forecast for the next month (June). c) compute the MAD for...

using the data in the following table a. compute an exponentially smoothes forecast with alpha=.30 through July, assuming the forecast for January is 80 b. compute the MAD for the forecast months....

please answer, thanks. Using the following data, provide exponentially smoothed forecast where alpha = .30 Oct 80 Nov 72 Dec 63 Jan 50 Feb 64 Mar 69 Apr 73 May 81 Jun 70 Jul 98 Aug Using the...

The Peterson Perpetual Profit Mutual Fund has recorded the fund's average prices over the past 12 months; these data may be found in the table on the following page. Given recent market volatility,...

MONTH FUND PRICE 1 65.55 2 68.15 3 63.25 4 64.50 5 68.65 6 70.35 7 72.75 8 74.15 9 71.75 10 75.50 11 76.75 12 74.25 The Peterson Perpetual Profit Mutual Fund has recorded the fund's average prices...

Forecasting Homework Practice The manager of the Excom Service Station wants to forecast the demand for unleaded gasoline next month so that the proper number of gallons can be ordered from the...

Using the data in the following table, a) Compute 3-month moving average forecasts for all the months. b) Compute MAD for the forecast. c) Is 3-month moving average better than the exponentially...

The Peterson Perpetual Prot Mutual Fund has recorded the funds average prices over the past 12 months; these data may be found in the table on the following page. Given recent market volatility,...

Hello, Can you please help me for this I need it now Thank you Using the following numbers, provide the next period forecast using MA3, MAS, weighted 3 period moving average (.50, 33, 17). Show an...

A certain type of mint has a label weight of 20.4 grams. Suppose that the probability is 0.90 that a mint weighs more than 20.7 grams. Let X equal the number of mints that weigh more than 20.7 grams...

The velocity of a vehicle is measured at two distinct points in time as shown in Fig. The velocity satisfies the relationship v(t) = vo+at, where vo is the initial velocity in m/s and a is the...

Life insurance is generally least needed on the lives of Group of answer choices singles with dependents. primary breadwinners. children. secondary breadwinners.

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...