Answered step by step
Verified Expert Solution
Question
1 Approved Answer
(4.25 (trend line is given as y=5+20x, 4.28, 4.1, and 4.42) 4.25 The following gives the number of accidents that occurred on Florida State
(4.25 (trend line is given as y=5+20x, 4.28, 4.1, and 4.42) 4.25 The following gives the number of accidents that occurred on Florida State Highway 101 during the last 4 months: Month January February March Number of Accidents 30 40 60 90 April Forecast the number of accidents that will occur in May, using least- squares regression to derive a trend equation. P sabin in Problems 147 4.28 Attendance at Los Angeles's newest Disneylike attrac- tion, Vacation World, has been as follows: Guests Guests Quarter (in thousands) Quarter (in thousands) Winter '05 73 Summer '06 124 Spring '05 104 Fall '06 52 Summer '05 168 Winter '07 89 Fall '05 74 Spring '07 146 Winter '06 65 Summer '07 205 Spring '06 82 Fall '07 98 Compute seasonal indices using all of the data. Px Problems* 4.1 The following gives the number of pints of type A blood used at Woodlawn Hospital in the past 6 weeks: Week Of August 31 September 7 September 14 September 21 Pints Used 360 389 410 381 368 374 a) September 28 October 5 Forecast the demand for the week of October 12 using a 3-week moving average. b) Use a 3-week weighted moving average, with weights of .1, .3, and .6, using .6 for the most recent week. Forecast demand for the week of October 12. c) Compute the forecast for the week of October 12 using expo- nential smoothing with a forecast for August 31 of 360 and a=.2. PX 4.2 Year 1 2 3 4 5 6 7 8 9 10 11 Demand 7 9 5 9 13 8 12 13 9 11 7 a) Plot the above data on a graph. Do you observe any trend, cycles, or random variations? b) Starting in year 4 and going to year 12, forecast demand using a 3-year moving average. Plot your forecast on the same graph as the original data. c) Starting in year 4 and going to year 12, forecast demand using a 3-year moving average with weights of .1, .3, and .6, using .6 for the most recent year. Plot this forecast on the same graph. d) As you compare forecasts with the original data, which seems to give the better results? PX *Note: PX means the problem may be solved with POM for Windows and/or Excel OM.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started