Question: The purchasing agent for a hospital has collected data over the last five years on average monthly unit prices for a commonly used surgical item.

The purchasing agent for a hospital has collected data over the last five years on average monthly unit prices for a commonly used surgical item.
The purchasing agent for a hospital has collected data over

She believes that an accurate forecast of price would help improve the timing of her buying. Using the oldest four years of data as the base data and saving the most recent data (last year) for checking the forecast accuracy, do the following:
a. Plot the data on a graph. What important observations can you make about the data that would be useful to forecasting?
b. Construct a classic time series decomposition forecasting model based on two full years of data (years 2 and 3) and compute the error of the forecast (SF) for the last full year.
c. Construct an exponential smoothing model (α = 0.14, β = 0.01, and γ = 0.7) with level, trend, and seasonal components, and compute SF for the last year.
d. Create a weighted average model that combines both model types.

A-1 5 5 3 0 rs 20 20 2 2 2 2 2 23 22 18 18 18 64 36395795 197 196 195 24 200 28 IST 013 220 198 195 91-600 899462 11122 201 210 // // 250202 zzi 210-2. 2 2 2 2 2 201 250 2 22 200 014 750 3176 e-0 3 4 4 4 6 7 7 2 188-4 t-2 2 2 2 2 22222117

Step by Step Solution

3.39 Rating (165 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a See the plot in Figure 81 given below It shows that there is a seasonal component with a very slight trend to the data as well as some random or unexplained variation FIGURE 81 Plot of time series d... View full answer

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

Document Format (1 attachment)

Word file Icon

928-B-M-L-S-C-M (4661).docx

120 KBs Word File

Students Have Also Explored These Related Management Leadership Questions!