Using the latest period or naive method, compute the forecast for nurse staffing hours in 2012.

Refer to the following data set for nurse staffing hours in Hospital XYZ.

1992

34,081

1997

41,008

2002

47,000

70,456

1993

37,051

1993

41,817

2003

51,206

87,865

1994

36,845

1999

46,815

2004

78,456

75,084

1995

37,815

2000

45,845

2005

62,559

77,615

1996

39,908

2001

46,036

2006

68,048

81,084

a. Using the latest period or naive method, compute the forecast for nurse staffing hours in 2012.

b. Model the time series using Excel’s TREND function.

"Looking for a Similar Assignment? Order now and Get a Discount!