Question

The monthly ambulatory visit shown in the Table below occurred in an outpatient clinic.

month	visits
July	2160
august	2186
September	2246
october	2251
november	2243
december	2162

1. Prepare a forecast for January visits, using the simple exponential smoothing method with α = 0.3.
2. If α = 0.5, what is the predicted value for January visits?
3. If α = 0.0, what is the predicted value for January visits
4. If α = 1.0, what is the predicted value for January visits
5. Which alpha produces the best forecast?

Answer 1

Solve using Excel:

Part a: α = 0.3.

	α	0.3
Month	Actual (A)	Foercast (F)	A-F	(A-F)2
July	2160	2160.00	0.00	0.00
August	2186	2160.00	26.00	676.00
September	2246	2167.80	78.20	6115.24
October	2251	2191.26	59.74	3568.87
November	2243	2209.18	33.82	1143.66
December	2162	2219.33	-57.33	3286.43
January		2202.13
			MSE	2465.03
Month	Actual (A)	Foercast (F)	A-F	(A-F)2
July	2160	=B3	=B3-C3	=D3^2
August	2186	=C3+$C$1*D3	=B4-C4	=D4^2
September	2246	=C4+$C$1*D4	=B5-C5	=D5^2
October	2251	=C5+$C$1*D5	=B6-C6	=D6^2
November	2243	=C6+$C$1*D6	=B7-C7	=D7^2
December	2162	=C7+$C$1*D7	=B8-C8	=D8^2
January		=C8+$C$1*D8
			MSE	=AVERAGE(E3:E8)

January = 2202.13

Part b: α = 0.5

	α	0.5
Month	Actual (A)	Foercast (F)	A-F	(A-F)2
July	2160	2160.00	0.00	0.00
August	2186	2160.00	26.00	676.00
September	2246	2173.00	73.00	5329.00
October	2251	2209.50	41.50	1722.25
November	2243	2230.25	12.75	162.56
December	2162	2236.63	-74.63	5568.89
January		2199.31
			MSE	2243.12
Month	Actual (A)	Foercast (F)	A-F	(A-F)2
July	2160	=H3	=H3-I3	=J3^2
August	2186	=I3+$I$1*J3	=H4-I4	=J4^2
September	2246	=I4+$I$1*J4	=H5-I5	=J5^2
October	2251	=I5+$I$1*J5	=H6-I6	=J6^2
November	2243	=I6+$I$1*J6	=H7-I7	=J7^2
December	2162	=I7+$I$1*J7	=H8-I8	=J8^2
January		=I8+$I$1*J8
			MSE	=AVERAGE(K3:K8)

January = 2199.31

Part c: α = 0.0

	α	0
Month	Actual (A)	Foercast (F)	A-F	(A-F)2
July	2160	2160.00	0.00	0.00
August	2186	2160.00	26.00	676.00
September	2246	2160.00	86.00	7396.00
October	2251	2160.00	91.00	8281.00
November	2243	2160.00	83.00	6889.00
December	2162	2160.00	2.00	4.00
January		2160.00
			MSE	3874.33
Month	Actual (A)	Foercast (F)	A-F	(A-F)2
July	2160	=N3	=N3-O3	=P3^2
August	2186	=O3+$O$1*P3	=N4-O4	=P4^2
September	2246	=O4+$O$1*P4	=N5-O5	=P5^2
October	2251	=O5+$O$1*P5	=N6-O6	=P6^2
November	2243	=O6+$O$1*P6	=N7-O7	=P7^2
December	2162	=O7+$O$1*P7	=N8-O8	=P8^2
January		=O8+$O$1*P8
	orchestra Next > < Previous Related Solutions The nurse manager of an ambulatory care clinic has noted an increased number of visits by... The nurse manager of an ambulatory care clinic has noted an increased number of visits by patients from different countries and cultures, including patients from Mexico and other Latin American countries. Concerned about meeting the needs of this culturally diverse population, the nurse manager convenes a staff meeting to discuss this change in patient demographics, and to query the staff about any learning needs they have related to the care of these patients. (Learning Objective 3) What strategy to avoid... The nurse manager of an ambulatory care clinic has noted an increased number of visits by... The nurse manager of an ambulatory care clinic has noted an increased number of visits by patients from different countries and cultures, including patients from Mexico and other Latin American countries. Concerned about meeting the needs of this culturally diverse population, the nurse manager convenes a staff meeting to discuss this change in patient demographics, and to query the staff about any learning needs they have related to the care of these patients. ( Learning objective 3). a. What strategy... An auto dealer's sales numbers are shown in the table below. Find for each month the... An auto dealer's sales numbers are shown in the table below. Find for each month the mean, median, and mode prices of the cars she sold. Round your answers to the nearest dollar. Number sold Price May June July $25,000 22 25 24 $15,000 49 24 24 $13,500 25 49 49 June mean     $ median     $ mode     $ July mean     $ median     $ mode     $ An auto dealer's sales numbers are shown in the table below. Find for each month the... An auto dealer's sales numbers are shown in the table below. Find for each month the mean, median, and mode prices of the cars she sold. Round your answers to the nearest dollar. Number sold Price May June July $25,000 22 25 24 $15,000 49 24 24 $13,500 25 49 49 May mean     $ median     $ mode     $ June mean     $ median     $ mode     $ July mean     $ median     $ mode     v Consider the monthly time series shown in the table. Month t Y January 1 185... v Consider the monthly time series shown in the table. Month t Y January 1 185 February 2 192 March 3 189 April 4 201 May 5 195 June 6 199 July 7 206 August 8 203 September 9 208 October 10 209 November 11 218 December 12 216 Use the method of least squares to fit the model E(Yt) = β0 + β1t to the data. Write the prediction equation. Use the prediction equation to obtain forecasts for the... Consider the monthly time series shown in the table. Month t Y January 1 185 February... Consider the monthly time series shown in the table. Month t Y January 1 185 February 2 192 March 3 189 April 4 201 May 5 195 June 6 199 July 7 206 August 8 203 September 9 208 October 10 209 November 11 218 December 12 216 Use the method of least squares to fit the model E(Yt) = β0 + β1t to the data. Write the prediction equation. Use the prediction equation to obtain forecasts for the next... Five years of a well-established brand’s monthly sales volume data are shown in the table below.... Five years of a well-established brand’s monthly sales volume data are shown in the table below. As may be noted, there is substantial seasonality in this brand's sales. Forecaster Simulation: Problem #3 Data Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 January 5550 4782 5283 4760 4314 February 5398 4897 4544 4930 4476 March 4236 4693 4370 4930 4476 April 2977 3747 2419 3065 3350 May 2345 2235 2463 2546 2274 June 1198 1156 1887 1602... The table below shows monthly beer sales at Gordon’s Liquor Store in 2017. Month Sales Jan... The table below shows monthly beer sales at Gordon’s Liquor Store in 2017. Month Sales Jan 900 Feb 725 Mar 1000 Apr 800 May 750 Jun 1200 Jul 1000 Aug 1100 Sep 1250 Oct 1050 Nov 1400 Dec 1600 Jan Forecast beer sales needed for January 2018 using an exponential smoothing method α = 0.2, α = 0.4 and α = 0.9 Plot the data and identify the method to forecast the beer sales 2. Table below shows monthly beer sales at Gordon’s Liquor Store in 2017. Month Sales Jan... 2. Table below shows monthly beer sales at Gordon’s Liquor Store in 2017. Month Sales Jan 900 Feb 725 Mar 1000 Apr 800 May 750 Jun 1200 Jul 1000 Aug 1100 Sep 1250 Oct 1050 Nov 1400 Dec 1600 Jan a) Forecast beer sales needed for January 2018 using an exponential smoothing method α = 0.2, α = 0.4 and α = 0.9 b) Compute an adjusted exponential smoothing for the data using: α = 0.3 and β = 0.5,... Consider monthly demand for the ABC Corporation as shown below. Forecast the monthly demand for Year... Consider monthly demand for the ABC Corporation as shown below. Forecast the monthly demand for Year 6 using the 3-period moving average and 4-period moving average. Evaluate the bias, TS, MAD, MAPE and MSE. Evaluate the quality of the forecast Sales Year 1 Year 2 Year 3 Year 4 Year 5 JAN 2000 3000 2000 5000 5000 FEB 3000 4000 5000 4000 2000 MAR 3000 3000 5000 4000 3000 APR 3000 5000 3000 2000 2000 MAY 4000 5000 4000 5000... ADVERTISEMENT Subjects Accounting Advanced Math Anatomy and Physiology Biology Chemistry Civil Engineering Computer Science Economics Electrical Engineering Finance History Math Mechanical Engineering Operations Management Physics Psychology Statistics and Probability Nursing Other ADVERTISEMENT Latest Questions Describe System Development Life Cycle (SDLC) and how it is used. What symbolism do you find in the play,Oedipus? • Using the Scanner class to obtain input from the user. • Using printf to output... In each of the following situations, develop a tentative plan for the client. List the various... MARGI sells different types of wine. Customers place orders to the most popular “Summer Wine” at... Java. If possible please put explanations for each line of code. Write a test program that... . Use the following information to calculate your company's expected return State Probability Return Boom 20%... ADVERTISEMENT About @ 2020 WizEdu