case, 290 Deseasonalized demand in 1 = 258.64 1.12 These calculations are shown in O Table 15.15. Note the effect of deasonalizing the data by comparing the Sunday of week 1 (255 patients) with the Monday of week 2 (290 patients). Looking at the demand data alone, one might think of the 290 patients being a much greater demand rate. However, if one adjusts for the effect that Sundays tend to be 6 percent less busy (SIsunday = 0.94) and Mondays tend to be 12 percent more busy (SlMonday = 1.12), we actually find that the Sunday of week 1 was the bigger surprise to the ED. TABLE 15.15 Number of Patients Showing Up in the Emergency Department Adjusted for Seasonality Effects Week Day of Week ER Visits Seasonality Index (SI) Deasonalized (ER VIisits/SI) 1 Monday 265 1.12 236.35 Tuesday 260 1.04 251.14 Wednesday 255 0.95 268.60 Thursday 261 0.98 265.90 Friday 264 1.10 240.64 Saturday 220 0.88 250.52 Sunday 255 0.94 272.07 2 Monday 290 1.12 258.64 Tuesday 250 1.04 241.48 Wednesday 222 0.95 233.84 Thursday 230 0.98 234.32 Friday 282 1.10 257.05 Saturday 211 0.88 240.27 Sunday 215 0.94 229.39 Monday 280 1.12 249.72 Tuesday 261 1.04 252.10 Wednesday 230 0.95 242.27 Thursday 240 0.98 244.50
case, 290 Deseasonalized demand in 1 = 258.64 1.12 These calculations are shown in O Table 15.15. Note the effect of deasonalizing the data by comparing the Sunday of week 1 (255 patients) with the Monday of week 2 (290 patients). Looking at the demand data alone, one might think of the 290 patients being a much greater demand rate. However, if one adjusts for the effect that Sundays tend to be 6 percent less busy (SIsunday = 0.94) and Mondays tend to be 12 percent more busy (SlMonday = 1.12), we actually find that the Sunday of week 1 was the bigger surprise to the ED. TABLE 15.15 Number of Patients Showing Up in the Emergency Department Adjusted for Seasonality Effects Week Day of Week ER Visits Seasonality Index (SI) Deasonalized (ER VIisits/SI) 1 Monday 265 1.12 236.35 Tuesday 260 1.04 251.14 Wednesday 255 0.95 268.60 Thursday 261 0.98 265.90 Friday 264 1.10 240.64 Saturday 220 0.88 250.52 Sunday 255 0.94 272.07 2 Monday 290 1.12 258.64 Tuesday 250 1.04 241.48 Wednesday 222 0.95 233.84 Thursday 230 0.98 234.32 Friday 282 1.10 257.05 Saturday 211 0.88 240.27 Sunday 215 0.94 229.39 Monday 280 1.12 249.72 Tuesday 261 1.04 252.10 Wednesday 230 0.95 242.27 Thursday 240 0.98 244.50
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...
Related questions
Question
I need to undesrtand step by step how to calculate the Deasonalized (ER visit /SI)...the results from the last column.... 236.35, 251.14, 268.60
I tried in many different ways but I am not able to find the correct way to get those results
Transcribed Image Text:In our case, we have
290
Deseasonalized demand in t
= 258.64
%3D
1.12
These calculations are shown in L Table 15.15. Note the effect of deasonalizing the data by comparing the Sunday of week 1 (255 patients)
with the Monday of week 2 (290 patients). Looking at the demand data alone, one might think of the 290 patients being a much greater
demand rate. However, if one adjusts for the effect that Sundays tend to be 6 percent less busy (SISunday = 0.94) and Mondays tend to be 12
percent more busy (SIMonday = 1.12), we actually find that the Sunday of week 1 was the bigger surprise to the ED.
TABLE 15.15 Number of Patients Showing Up in the Emergency Department Adjusted for Seasonality Effects
Week
Day of Week
ER Visits
Seasonality Index (SI)
Deasonalized (ER Visits/SI)
1
Monday
265
1.12
236.35
Tuesday
260
1.04
251.14
Wednesday
255
0.95
268.60
Thursday
261
0.98
265.90
Friday
264
1.10
240.64
Saturday
220
0.88
250.52
Sunday
255
0.94
272.07
2
Monday
290
1.12
258.64
Tuesday
250
1.04
241.48
Wednesday
222
0.95
233.84
Thursday
230
0.98
234.32
Friday
282
1.10
257.05
Saturday
211
0.88
240.27
Sunday
215
0.94
229.39
3
Monday
280
1.12
249.72
Tuesday
261
1.04
252.10
Wednesday
230
0.95
242.27
Thursday
240
0.98
244.50
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.