Question: 2. Data collected on the yearly registration for a Six Sigma seminar at the Quality College ate shown in the following table: a) Develop a

2. Data collected on the yearly registration for a Six Sigma seminar at the Quality College ate shown in the following table: a) Develop a 4 year moving average to forecast iegistrations from year 5 to ycar 12 . (7 pts) b) Estimate demand again for years 5 to 12 within a 4 -year weighted moving average in which registrations in the most recent year are given a weight of 3 and 2 , and registrations in the other 2 years are each given a weight of 1 . ( 8pts) c) Compute the forecasts for each year using exponential smoothing, with an initial forecast for year 5 of 8. Use =0.3. ( 8 pts) d) Using MAD, which of the three forecasting methods is best? ( 8 pts) e) Using MAPE, which of the three forecasting methods is best? (8 pts) f) Forecast registrations for year 15 , using trend projection. ( 8pts )

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!

Please kindly answer the questions in alphabetical order. Thanks! 2. Data collected on the yearly registration for a Six Sigma seminar at the Quality College ate shown in the following table: a)...

Please kindly help on this question. Thanks 2. Data collected on the yearly registration for a Six Sigma seminar at the Quality College are shown in the following table: a) Develop a 4 year moving...

I have been posting this question over three times now. it's says the question has been answered but when l click on it there is no answer. It been doing this to all the three post. Thanks 2. Data...

Data collected on the yearly registration for a six Sigma seminar at the quality college are shown in the following table. 5. Develop a three-year moving average to forecast years for 4-12 6. develop...

Data collected on the yearly registration for a Six Sigma seminar at the Quality College are shown in the following table: Year Registrations (000) 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9 12 10 14 11 15...

Show your work to receive credit for the question. Handwritten submissions will not be accepted. Complete the assignment using Word or Excel. With Word type out the equations and with Excel the using...

Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the followingtable: Year 1 2 3 4 5 6 7 8 9 10 11 Registrations (000) 5.00 6.00 4.00 4.00 11.00...

If a firm uses program budgeting for its projects, is an activity budget not needed? If it is, then of what value is the program budget?

Question 4 The Bearing Division operates in the energy sector and consists of a number of business units, nearly all of which are involved in the processing and sale of fossil fuels. The division has...

My earnings today did not appear to my paypal account. I already widraw it

Create a C# application named SalesTransactionDemo that declares several SalesTransaction objects and displays their values and their sum. The SalesTransaction class contains the following fields:...