Calculate the root-mean-squared error for forecast period

Assignment Help Operation Management
Reference no: EM13725624

1. In a time-series decomposition of sales (in millions of units), the following trend has been estimated:

CMAT = 4.7 * 0.37(T)

The seasonal indices have been found to be:

Quarter

Seasonal Index

1

1.24

2

1.01

3

0.76

4

0.99

For the coming year the time index and cycle factors are:

Quarter

T

CF

1

21

1.01

2

22

1.04

3

23

1.06

4

24

1.04

a. From this information prepare a forecast for each quarter of the coming year.

b. Actual sales for the year you forecast in part (a) were 17.2, 13.2, 10.8, and 14.2 for quarters 1, 2, 3, and 4, respectively. Use these actual sales ?gures along with your forecasts to calculate the root-mean-squared error for the forecast period.

2. A tanning parlor located in a major shopping center near a large New England city has the following history of customers over the last four years (data are in hundreds of customers):

Mid-Month of Quarter

Year

Feb

May

Aug

Nov

Yearly Totals

2004

3.5

2.9

2.0

3.2

11.6

2005

4.1

3.4

2.9

3.6

14.0

2006

5.2

4.5

3.1

4.5

17.3

2007

6.1

5.0

4.4

6.0

21.5

a. Construct a table in which you show the actual data (given in the table), the centered moving average, the centered moving-average trend, the seasonal factors, and the cycle factors for every quarter for which they can be calculated in years 1 through 4.

b. Determine the seasonal index for each quarter.

c. Do the best you can to project the cycle factor through 2008.

d. Make a forecast for each quarter of 2008.

e. The actual numbers of customers served per quarter in 2008 were 6.8, 5.1, 4.7, and 6.5 for quarters 1 through 4, respectively (numbers are in hundreds). Calculate the RMSE for 2008.

f. Prepare a time-series plot of the actual data, the centered moving averages, the long-term trend, and the values predicted by your model for 2004 through 2008 (where data are available).

3. Kim Brite and Larry Short have developed a series of exclusive mobile-home parks in which each unit occupies a site at least 100 ? 150 feet. Each site is well landscaped to provide privacy and a pleasant living environment. Kim and Larry are considering opening more such facilities, but to help manage their cash ?ow they need better forecasts of mobile-home shipments (MHS), since MHS appears to in?uence their vacancy rates and the rate at which they can ?ll newly opened parks. They have 16 years of data on mobile-home shipments, beginning with 1988Q1 and ending with 2003Q4, as shown:

Mobile Home Shipments (MHS) (000s)

 

Year

Q1

Q2

Q3

Q4

1988

56.6

49.1

58.5

57.5

1989

54.9

70.1

65.8

50.2

1990

53.3

67.9

63.1

55.3

1991

63.3

81.5

81.7

69.2

1992

67.8

82.7

79.0

66.2

1993

62.3

79.3

76.5

65.5

1994

58.1

66.8

63.4

56.1

1995

51.9

62.8

64.7

53.5

1996

47.0

60.5

59.2

51.6

1997

48.1

55.1

50.3

44.5

1998

43.3

51.7

50.5

42.6

1999

35.4

47.4

47.2

40.9

2000

43.0

52.8

57.0

57.6

2001

56.4

64.3

67.1

66.4

2002

69.1

78.7

78.7

77.5

2003

79.2

86.8

87.6

86.4

Assuming that Kim Brite and Larry Short have hired you as a forecasting consultant:

a. Provide a time-series plot of the actual MHS data along with the deseasonalizeddata. Write a brief memo in which you report the nature and extent of the seasonality in the data. Include seasonal indices in your report.

b. Develop a long-term linear trend for the data, based on the centered moving averages. Let time equal 1 for 1988Q1 in your trend equation. On the basis of this trend, does the future look promising for Brite and Short?

c. One of the things Ms. Brite and Mr. Short are concerned about is the degree towhich MHS is subject to cyclical ?uctuations. Calculate cycle factors and plot themin a time-series graph, including projections of the cycle factor through 2004. In evaluating the cycle factor, see whether interest rates appear to have any effect on the cyclical pattern. The rate for 1988Q1 through 2003Q4 is provided in the following table, should you wish to use this measure of interest rates.

Interest Rate

 

 

 

 

Year

Q1

Q2

Q3

Q4

1988

16.4

16.3

11.6

16.7

1989

19.2

18.9

20.3

17.0

1990

16.3

16.5

14.7

12.0

1991

10.9

10.5

10.8

11.0

1992

11.1

12.3

13.0

11.8

1993

10.5

10.2

9.5

9.5

1994

9.4

8.6

7.9

7.5

1995

7.5

8.0

8.4

8.9

1996

8.6

8.8

9.7

10.2

1997

11.0

11.4

10.7

10.5

1998

10.0

10.0

10.0

10.0

1999

9.2

8.7

8.4

7.6

2000

6.5

6.5

6.0

6.0

2001

6.0

6.0

6.0

6.0

2002

6.0

6.9

7.5

8.1

2003

8.8

9.0

8.8

8.7

d. Demonstrate for Ms. Brite and Mr. Short how well your time-series decomposition model follows the historical pattern in the data by plotting the actual values of MHS and those estimated by the model in a single time-series plot.

e. Prepare a forecast for 2004 and calculate the root-mean-squared error (RMSE), given the actual values of MHS for 2004 shown:

MHS

Period           Forecast

Actual          Squared Error

2004Q1

35.4

2004Q2

47.3

2004Q3

47.2

2004Q4

40.9

 

 

 

 

Sum of squared errors =
Mean-squared error =
Root-mean-squared error =

4. a. Use the following data on millions of dollars of jewelry sales (JS) to prepare a time-series decomposition forecast of JS for the four quarters of 2005:

Date

Jewelry Sales
($ Millions)

Date

Jewelry Sales
($ Millions)

Date

Jewelry Sales
($ Millions)

Jan-94

904

May-94

1,367

Sep-94

1,246

Feb-94

1,191

Jun-94

1,257

Oct-94

1,323

Mar-94

1,058

Jul-94

1,224

Nov-94

1,731

Apr-94

1,171

Aug-94

1,320

Dec-94

4,204

Jan-95

914

Sep-98

1,372

May-02

2,120

Feb-95

1,223

Oct-98

1,506

Jun-02

1,667

Mar-95

1,138

Nov-98

1,923

Jul-02

1,554

Apr-95

1,204

Dec-98

5,233

Aug-02

1,746

May-95

1,603

Jan-99

1,163

Sep-02

1,503

Jun-95

1,388

Feb-99

1,662

Oct-02

1,662

Jul-95

1,259

Mar-99

1,402

Nov-02

2,208

Aug-95

1,393

Apr-99

1,468

Dec-02

5,810

Sep-95

1,325

May-99

1,877

Jan-03

1,361

Oct-95

1,371

Jun-99

1,635

Feb-03

2,019

Nov-95

1,867

Jul-99

1,596

Mar-03

1,477

Dec-95

4,467

Aug-99

1,617

Apr-03

1,616

Jan-96

1,043

Sep-99

1,530

May-03

2,071

Feb-96

1,439

Oct-99

1,653

Jun-03

1,711

Mar-96

1,316

Nov-99

2,179

Jul-03

1,677

Apr-96

1,359

Dec-99

6,075

Aug-03

1,761

May-96

1,768

Jan-00

1,253

Sep-03

1,629

Jun-96

1,408

Feb-00

1,991

Oct-03

1,759

Jul-96

1,375

Mar-00

1,510

Nov-03

2,291

Aug-96

1,477

Apr-00

1,570

Dec-03

6,171

Sep-96

1,332

May-00

2,139

Jan-04

1,461

Oct-96

1,462

Jun-00

1,783

Feb-04

2,344

Nov-96

1,843

Jul-00

1,643

Mar-04

1,764

Dec-96

4,495

Aug-00

1,770

Apr-04

1,826

Jan-97

1,041

Sep-DO

1,705

May-04

2,226

Feb-97

1,411

Oct-00

1,681

Jun-04

1,882

Mar-97

1,183

Nov-00

2,174

Jul-04

1,787

Apr-97

1,267

Dec-00

5,769

Aug-04

1,794

May-97

1,597

Jan-01

1,331

Sep-04

1,726

Jun-97

1,341

Feb-01

1,973

Oct-04

1,845

Jul-97

1,322

Mar-01

1,580

Nov-04

2,399

Aug-97

1,359

Apr-01

1,545

Dec-04

6,489

Sep-97

1,344

May-01

1,992

Jan-05

?

Oct-97

1,406

Jun-01

1,629

Feb-05

?

Nov-97

1,813

Jul-01

1,530

Mar-05

?

Dec-97

4,694

Aug-01

1,679

Apr-05

?

Jan-98

1,119

Sep-01

1,394

May-05

?

Feb-98

1,513

Oct-01

1 586

Jun-05

?

Mar-98

1,238

Nov-01

2,152

Jul-05

?

Apr-98

1,362

Dec-01

5,337

Aug-05

 

May-98

1,756

Jan-02

1,304

Sep-05

7

Jun-98

1,527

Feb-02

2,004

Oct-05

 

Jul-98

1,415

Mar-02

1,612

Nov-05

 

Aug-98

1,466

Apr-02

1,626

Dec-05

 

The actual data for 2005 are:

Date

Jewelry Sales (S Millions)

Jan-OS

1,458

Feb-OS

2,394

Mar-OS

1,773

Apr-OS

1,909

May-05

2,243

Jun-05

1,953

Jul-05

1,754

Aug-05

1,940

Sep-OS

1,743

Oct-05

1,878

Nov-OS

2,454

Dec-OS

6,717

b. Evaluate your model in terms of ?t and accuracy using RMSE.

c. Plot your forecast values of JS along with the actual values.

d. Look at the seasonal indices, and explain why you think they do or do not make sense.

e. Compare the results from your time-series decomposition model with those obtained using a Winters' exponential smoothing model in terms of both ?t and accuracy.

5. Estimating the volume of loans that will be made at a credit union is crucial to effective cash management in those institutions. In the table that follows are quarterly data for a real credit union located in a midwestern city. Credit unions are ?nancial institutions similar to banks, but credit unions are not-for-pro?t ?rms whose members are the actual owners (remember their slogan, "It's where you belong"). The members may be both depositors in and borrowers from the credit union.

Quarter

Loan Volume

Assets

Members

Prime Rate

Mar-98

2,583,780

4,036,810

3,522

6.25

Jun-98

2,801,100

4,164,720

3,589

6.75

Sep-98

2,998,240

4,362,680

3,632

7.13

Dec-98

3,032,720

4,482,990

3,676

7.75

Mar-99

3,094,580

4,611,300

3,668

8

Jun-99

3,372,680

4,696,720

3,689

8.63

Sep-99

3,499,350

4,844,960

3,705

9.41

Dec-99

3,553,710

4,893,450

3,722

11.55

Mar-00

3,651,870

5,089,840

3,732

11.75

Jun-00

3,832,440

5,185,360

3,770

11.65

Sep-00

4,013,310

5,381,140

3,845

12.9

Dec-00

3,950,100

5,413,720

3,881

15.3

Mar-01

3,925,100

5,574,160

3,923

18.31

Jun-01

3,717,4,80

5,838,990

3,941

12.63

Sep-01

3,712,300

6,150,350

3,955

12.23

Dec-01

3,677,940

6,133,030

3,943

20.35

Mar-02

3,724,770

6,119,030

3,960

18.05

Jun-02

3,787,760

6,221,090

3,971

20.03

Sep-02

3,981,620

6,229,000

3,993

20.08

Dec-02

3,848,660

6,412,230

4,011

15.75

Mar-03

3,619,830

6,795,830

4,040

16.5

Jun-03

3,623,590

7,538,210

4,103

16.5

Sep-03

3,632,120

8,496,080

4,133

13.5

Dec-03

3,482,000

9,979,390

4,173

11.5

Mar-04

3,378,500

11,475,300

4,218

10.5

Jun-04

3,433,470

12,116,900

4,266

10.5

Sep-04

3,615,430

12,686,500

4,305

11

Dec-04

3,865,780

13,457,600

4,657

11

Mar-OS

3,955,270

14,118,300

4,741

11.21

Jun-05

4,394,140

14,448,600

4,826

12.6

Sep-OS

4,803,630

14,687,200

4,943

12.97

Dec-05

4,952,740

14,885,800

4,945

11.06

Mar-06

5,249,760

16,106,300

5,007

10.5

Jun-06

5,943,390

17,079,400

5,112

9.78

Sep-06

6,387,000

17,846,800

5,164

9.5

Dec-06

6,435,750

19,435,600

5,210

9.5

Mar-07

6,482,780

19,714,100

5,255

9.1

Jun-07

6,683,800

21,185,800

5,289

8.5

Sep-07

7,094,210

22,716,700

5,391

7.5

Dec-07

7,329,770

23,790,500

5,461

7.5

a. Estimate a multiple-regression model to estimate loan demand and calculate its root mean squared error.

b. Estimate a time-series decomposition model to estimate loan demand with the same data and calculate its root-mean-squared error.

c. Combine the models in parts (a) and (b) and determine whether the combined model performs better than either or both of the original models. Try to explain why you obtained the results you did.

6. HeathCo Industries, a producer of a line of skiwear, has been the subject of exercises in several earlier chapters of the text. The data for its sales and two potential causal variables, income (INCOME) and the northern-region unemployment rate (NRUR), are repeated in the following table:

Date

Sales

Income

NRUR

 

Jan-98

72,962

218

8.4

 

Apr-98

81,921

237

8.2

 

Jul-98

97,729

263

8.4

 

Oct-98

142,161

293

8.4

 

Jan-99

145,592

318

8.1

 

Apr-99

117,129

359

7.7

 

Jul-99

114,159

404

7.5

 

Oct-99

151,402

436

7.2

 

Jan-00

153,907

475

6.9

 

Apr-00

100,144

534

6.5

 

Jul-00

123,242

574

6.5

 

Oct-00

128,497

622

6.4

 

Jan-01

176,076

667

6.3

 

Apr-01

180,440

702

6.2

 

Jul-01

162,665

753

6.3

 

Oct-01

220,818

796

6.5

 

Jan-02

202,415

858

6.8

 

Apr-02

211,780

870

7.9

 

Jul-02

163,710

934

8.3

 

Oct-02

200,135

1,010

8

 

Jan-03

174,200

1,066

8

 

Apr-03

182,556

1,096

8

 

Jul-03

198,990

1,162

8

 

Oct-03

243,700

1,178

8.9

 

Jan-04

253,142

1,207

9.6

 

Apr-04

218,755

1,242

10.2

 

Jul-04

225,422

1,279

10.7

 

 

 

 

 

 

Date

Sales

Income

NRUR

Oct-04

253,653

1,318

11.5

 

Jan-05

257,156

1,346

11.2

 

Apr-OS

202,568

1,395

11

 

Jul-05

224,482

1,443

10.1

 

Oct-05

229,879

1,528

9.2

 

Jan-06

289,321

1,613

8.5

 

Apr-06

266,095

1,646

8

 

Jul-06

262,938

1,694

8

 

Oct-06

322,052

1,730

7.9

 

Jan-07

313,769

1,755

7.9

 

Apr-07

315,011

1,842

7.9

 

Jul-07

264,939

1,832

7.8

 

Oct-07

301,479

1,882

7.6

 

Jan-08

334,271

1,928

7.6

 

Apr-08

328,982

1,972

7.7

4- Holdout

Jul-08

317,921

2,017

7.5

 

Oct-08

350,118

2,062

7.4

 










a. Develop a multiple-regression model of SALES as a function of both INCOME and NRUR: SALES = a + b1(INCOME) + b2(NRUR)

Use this model to forecast sales for 2008Q1-2008Q4 (call your regression forecast series SFR), given that INCOME and NRUR for 2004 have been forecast to be:

Quarter

INCOME

NRUR

2008Q1

1,928

7.6

2008Q2

1,972

7.7

2008Q3

2,017

7.5

2008Q4

2,062

7.4

b. Calculate the RMSE for your regression model for both the historical period (1998Q1-2007Q4) and the forecast horizon (2008Q1-2008Q4).

Period

RMSE

Historical

 

Forecast

 

c. Now prepare a forecast through the historical period and the forecast horizon (2008Q1-2008Q4) using Winters' exponential smoothing. Call this forecast series SFW, and ?ll in the RMSEs for SFW:

Period

RMSE

Historical

 

Forecast

 

d. Solely on the basis of the historical data, which model appears to be the best? Why?

e. Now prepare a combined forecast (SCF) using the regression technique described in this chapter. In the standard regression:

SALES = a + h1(SFR) + /22(SFW)

Is the intercept essentially zero? Why? If it is, do the following regression as a basis for developing SCF:

SALES = b1(SFR) + h2(SFW)

f. Calculate the RMSEs for SCF:

Period

RMSE

Historical

 

Forecast

 

Did combining models reduce the RMSE in the historical period? What about the actual forecast?

7. Your company produces a favorite summertime food product, and you have been placed in charge of forecasting shipments of this product. The historical data below represent your company's past experience with the product.

a. Since the data appear to have both seasonality and trend, you should estimate a Winters' model and calculate its root-mean-squared error.

b. You also have access to a survey of the potential purchasers of your product. This information has been collected for some time, and it has proved to be quite accurate for predicting shipments in the past. Calculate the root-mean-squared error of the purchasers' survey data.

c. After checking for bias, combine the forecasts in parts (a) and (b) and determine if a combined model may forecast better than either single model.

Date

Shipments ($000)

Purchasers'
Survey ($000)

Date

Shipments ($000)

Purchasers'
Survey ($000)

Apr-2002

13,838.00

13,920.32

Jun-2003

21,056.00

24,644.20

May-2002

15,137.00

15,052.82

Jul-2003

13,509.00

14,224.17

Jun-2002

23,713.00

26,207.69

Aug-2003

9,729.00

9,194.77

Jul-2002

17,141.00

17,237.59

Sep-2003

13,454.00

12,141.25

Aug-2002

7,107.00

7,687.23

Oct-2003

13,426.00

11,971.93

Sep-2002

9,225.00

9,788.06

Nov-2003

17,792.00

17,654.14

Oct-2002

10,950.00

7,889.46

Dec-2003

19,026.00

15,580.19

Nov-2002

14,752.00

14,679.10

Jan-2004

9,432.00

9,961.98

Dec-2002

18,871.00

17,644.48

Feb-2004

6,356.00

7,368.55

Jan-2003

11,329.00

10,436.45

Mar-2004

12,893.00

11,286.25

Feb-2003

6,555.00

6,304.89

Apr-2004

19,379.00

18,915.33

Mar-2003

9,335.00

9,354.44

May-2004

14,542.00

14,056.06

Apr-2003

10,845.00

11,759.15

Jun-2004

18,043.00

20,699.38

May-2003

15,185.00

14,971.57

Jul-2004

10,803.00

12,892.97

Reference no: EM13725624

Questions Cloud

Identify a global trend that has the potential impact : For this Assignment, research and identify a global trend that has the potential to impact an organization and its Human Resources Department/Division and its practices, requiring both to demonstrate their ability to be agile and adaptive.
Protection of network administrator : what you have done as the network administrator to protect the network against such attacks, as well as additional measures to secure the network against worms, viruses, DoS attacks, spyware, and other such network intrusions that can disrupt the ..
What is the promotion goal for your current target market : What is the promotion goal for your current target market and what is the promotion goal for your potential target market
Forms of internal and external threats to an organization : Describe various forms of internal and external threats to an organization. Describe methods to detect internal and external threats to the organization.
Calculate the root-mean-squared error for forecast period : Actual sales for the year you forecast in part (a) were 17.2, 13.2, 10.8, and 14.2 for quarters 1, 2, 3, and 4, respectively. Use these actual sales ?gures along with your forecasts to calculate the root-mean-squared error for the forecast period.
Equal employment opportunity and employee rights : Refer to the Equal Employment Opportunity and Employee Rights Review, for List A and List B.  Choose 3 laws form List A and B (see below):
What is diminishing marginal utility : Describe as way someone could use the concept of opportunity costs - What is diminishing marginal utility and how does it relate in someone personal life.
International hr plan : Change requires planning, including input from HR. Retention goals and future plans impact the way in which change is managed. Planning enables the organization to focus on immediate and future goals.
Prepare a case study on tom coffee cup : Prepare a case study on Tom's Coffee Cup

Reviews

Write a Review

Operation Management Questions & Answers

  Which of these two customers is more valuable with respect

His contribution margin is about 19% and he figures he loses about 20% of his customers. Which of these two customers is more valuable with respect to the value of loyal customer calculation?

  Explain how a quality-assurance program might affect

Explain how a quality-assurance program might affect different organizational functions for a fast-food business such as McDonald's or domino's pizza.

  Shunt resistors are commonly used to measure current

Shunt resistors are commonly used to measure current in power circuits, by producing a small voltage drop in direct proportion to the circuit current.

  How much do you get charged per day

what if you return the book late? how much do you get charged per day?

  What is the arrival rate for the line

What is the minimum number of cashiers the store must schedule to ensure that lines are not infinitely long? What is the arrival rate for the line?

  What is the first goal of national unions

What is the first goal of national unions?

  Explain what seemed to improve the business operations

about jcpenny and Highlight the business strategy used and explain if the strategy worked. Explain what seemed to improve the business operations/bottom line or what failed.

  Compare and contrast qualitative and quantitative forecast

Compare and contrast qualitative and quantitative forecasting and give one example of a method that is used for each type.

  Handling employees

Here's an interesting perspective with regard to handling employees who resist change - Select a section that you most agree with and explain your reasoning.

  Define process design and supply chains

This is part one of a two part assignment starting with an introductory look at process design and supply chains. Identify a company with which you are familiar. This could be your place of employment, a car wash, a yard service company, and so fo..

  Different models of organizational change

There are many different models of organizational change. Each has advantages and disadvantages. It is up to the organizational development specialist to match the specific model to the current needs of the organization.

  What should the coordinates of the new factory be

The expected annual volumes expected to be shipped through the three warehouses is forecast to be 20 million units through A, 100 million through B and 50 million through C. Using the centroid method, approximately what should the coordinates of ..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd