Question: Use the exponential smoothing method to forecast for the 9 th period for the time series data below. (Use the smoothing constant of .1 to

Use the exponential smoothing method to forecast for the 9^th period for the time series data below. (Use the smoothing constant of .1 to solve.)

Period	Actual
1	180
2	168
3	159
4	175
5	190
6	205
7	180
8	182

b. Develop a tracking signal to identify at which period the forecast is out of control. Use + 2 MAD as the control limit. Also, show a chart of tracking signal.

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!

Show in Excel Please. Thank You. Using smoothing constant alpha of 0.1 5. Use the exponential smoothing method to forecast for the 9th period for the time series data below Period 1 2 3 4 Actual 180...

%209%20Homework.pdf HRTM 310 Ch. 9 Demand Forecasting Method: Homework CHAPTER 9 HOMEWORK: DEMAND FORECASTING METHODS Due at 11:59 pm, Sunday November I 2020 1. Your sister owns a restaurant-Serveo...

HRTM 310 Ch. 9 Demand Forecasting Method: Homework 2. You are a manager of Harris Grill with 110 seats. You have tracked the total number of meals served on a weekly basis for the past 20 weeks and...

just question e please! HRTM 310 Ch. 9 Demand Forecasting Method: Homework 2. You are a manager of Harris Grill with 110 seats. You have tracked the total number of meals served on a weekly basis for...

5. Use the exponential smoothing method to forecast for the 9th period for the time series data below Period Actual 1 180 2 168 3 159 4 175 5 190 6 205 7 180 8 182 b. Develop a tracking signal to...

2. You are a manager of Harris Grill with 110 seats. You have tracked the total number of meals served on a weekly basis for the past 20 weeks and the number of meals is as shown in the table below....

I only need part F. Please show your work, because I have no idea how to do these without being given the actual demand for those years. A community college is planning to use the exponential...

* SOLVE IN EXCEL * A Simple forecasting method for weekly sales of DVD drives used by a local computer dealer is to form the average of the two most recent sales Figures. Suppose sales for the drives...

A Simple forecasting method for weekly sales of DVD drives used by a local computer dealer is to form the average of the two most recent sales Figures. Suppose sales for the drives for the past 6...

Here are eamings per share for two companies by quarter from the first quarter of three years ago through the second quarter of this year Forecast earnings per share for the rest of this year and...

As in Exercises 3.2, 10.2, 11.2, and 12.3, at a certain local restaurant, students are known to prefer Japanese pan noodles 40% of the time (it is a very popular and tasty dish!). a. Let X be an...

Bad Debt Expense: Aging Method Glencoe Supply had the following accounts receivable aging schedule at the end of a recent year. Accounts Receivable Age Current 1-30 days past due 31-45 days past due...

The Activity - based Costing method ( ABC ) is not an alternative approach for allocating factory overhead when True False

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