A concert promoter is forecasting this year's attendance for one of his concerts based on the following historical data: Year Attendance 4 years ago 10,000 3 years ago 12,000 2 years ago 18,000 Last year 20,000 What is this year's forecast using exponential smoothing with alpha = 2, if last year's smoothed forecast was 15,000? A. 20,000 B. 19,000 C.17,500 D.16,000 E.15,000

A concert promoter is forecasting this year's attendance for one of his concerts based on the following historical data: Year Attendance 4 years ago 10,000 3 years ago 12,000 2 years ago 18,000 Last year 20,000 What is this year's forecast using exponential smoothing with alpha = 2, if last year's smoothed forecast was 15,000? A. 20,000 B. 19,000 C.17,500 D.16,000 E.15,000

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be related to the number of television appearances by the popular group Maroon 5 during the previous month. Gershon has collected the data shown in the following table: Maroon 5 TV Appearances 3 3 8 5 8 6 Demand for Guitars 2 5 6 4 11 6 This exercise contains only parts b, c, and d. b) Using the least-squares regression method, the equation for forecasting is (round your responses to four decimal places): Y = + c) The estimate for guitar sales if Maroon 5 performed on TV 11times = sales (round your response to two decimal places). d) The correlation coefficient (r)for this model = (round your response to four decimal places). The coefficient of determination (r2) for this model = (round your response to…
Give typed explanation Part 2: Using exponential smoothing, the forecasted demand for period 5 using the smoothing constant determined in image= ?
I would I do a problem like this? A time-series trend equation is 20.6 + 15.7x. What is your forecast for period 13?
The Dean of a faculty wants to forecast student enrolments for this academic year based on the following historical data: (5 years ago enrolment was 11770 ), (4 years ago enrolment was 15251), (3 years ago enrolment was 15785 ), (2 years ago enrolment was 16076 ) and in the last year enrolment was 19001 . What is the forecast for this year using exponential smoothing with alpha=0.58999997 , if the forecast for two years ago was :17623 a. 16710.27 b. 18061.801 c. 17801.75 d. 17386.035
In a retail store, the actual sales of a particular product (in thousands of units) over the past few months are as follows: Month Sales 1 16 2 22 3 18 4 20 5 23 Using exponential smoothing method with α (smoothing constant) of 0.75 and the given forecast for month 1 equal to 10, what is the forecast for month 6?
14 Community General Hospital finds itself treating many bicycle accident victims. Data from the last seven 24-hour periods is shown below: Day Bicycle Victims 1 8 2 14 3 8 4 14 5 18 6 15 With an alpha value of 0.31 and a starting forecast in day 3 equal to the 21 , what is the exponentially smoothed forecast for day 4? (Round to two decimal places) 15 What is the exponentially smoothed forecast for day 5? (Round to two decimal places) 16
If a 2-year moving average is used to make the forecast, the Mean Absolute Deviation based on this how many miles?
Y9
The actual number of patients at Providence Emergency Medical Clinic for the first six weeks of this year follows: Week Actual No. of Patients 1 65 68 77 59 66 75 23456 2 5 6 Clinic administrator Dana Schniederjans wants you to forecast patient numbers at the clinic for week 7 by using this data. You decide to use a weighted moving average method to find this forecast. Your method uses four actual demand levels, with weights of 0.500 on the present period, 0.250 one period ago, 0.125 two periods ago, and 0.125 three periods ago. a) What is the value of your forecast? The value of the forecast is patients (round your response to two decimal places). b) If instead the weights were 40, 20, 10, and 10, respectively, how would the forecast change? OA. The value of the forecast will decrease. B. The value of the forecast will remain the same. C. The value of the forecast will increase. c) What if the weights were 0.40, 0.30, 0.20, and 0.10, respectively? Now what is the forecast for week 7?…
The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The miles driven during the past 5 years are as follows: Year Mileage miles (round your response to the nearest whole number). a) Using a 2-year moving average, the forecast for year 6 = 1 3,050 2 4,000 3 3,450 4 3,750 5 3,750
Practice examples. Please show solution. Thank you.