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.60I tried in many different ways but I am not able to find the correct way to get those results In our case, we have290Deseasonalized demand in t= 258.64%3D1.12These 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 greaterdemand 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 12percent 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 EffectsWeekDay of WeekER VisitsSeasonality Index (SI)Deasonalized (ER Visits/SI)1Monday2651.12236.35Tuesday2601.04251.14Wednesday2550.95268.60Thursday2610.98265.90Friday2641.10240.64Saturday2200.88250.52Sunday2550.94272.072Monday2901.12258.64Tuesday2501.04241.48Wednesday2220.95233.84Thursday2300.98234.32Friday2821.10257.05Saturday2110.88240.27Sunday2150.94229.393Monday2801.12249.72Tuesday2611.04252.10Wednesday2300.95242.27Thursday2400.98244.50

Method: For calculating the Deseasonilzed value, the below steps need to be…

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.

Chapter10: Introduction To Simulation Modeling

Section: Chapter Questions

Problem 41P: At the beginning of each week, a machine is in one of four conditions: 1 = excellent; 2 = good; 3 =...

See similar textbooks

Similar questions

At the beginning of each week, a machine is in one of four conditions: 1 = excellent; 2 = good; 3 = average; 4 = bad. The weekly revenue earned by a machine in state 1, 2, 3, or 4 is 100, 90, 50, or 10, respectively. After observing the condition of the machine at the beginning of the week, the company has the option, for a cost of 200, of instantaneously replacing the machine with an excellent machine. The quality of the machine deteriorates over time, as shown in the file P10 41.xlsx. Four maintenance policies are under consideration: Policy 1: Never replace a machine. Policy 2: Immediately replace a bad machine. Policy 3: Immediately replace a bad or average machine. Policy 4: Immediately replace a bad, average, or good machine. Simulate each of these policies for 50 weeks (using at least 250 iterations each) to determine the policy that maximizes expected weekly profit. Assume that the machine at the beginning of week 1 is excellent.
Figure shows summer air visibility measurements for Denver, Colorado. The acceptable visibility standard is 100, with readings above 100 indicating clean air and good visibility, and readings below 100 indicating temperature inversions caused by forest fires, volcanic eruptions, or collisions with comets.a. Is a trend evident in the data? Which time-series techniques might be appropriate for estimating the average of these data?b. A medical center for asthma and respiratory diseases located in Denver has great demand for its services when air quality is poor. If you were in charge of developing a short-term (say, 3-day) forecast of visibility, which causal factor(s) would you analyze? In other words, which external factors hold the potential to significantly affect visibility in the short term?c. Tourism, an important factor in Denver’s economy, is affected by the city’s image. Air quality, as measured by visibility, affects the city’s image. If you were responsible for development of…
The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Week Of Pints Used August 31 360 September 7 389 September 14 412 September 21 383 September 28 366 October 5 374 a) The forecasted demand for the week of October 12 using a 3-week moving average LOADING... = 374.33374.33 pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.15, 0.35, and 0.50, using 0.50 for the most recent week, the forecasted demand for the week of October 12 = 372.55372.55 pints (round your response to two decimal places and remember to use the weights in appropriate order — the largest weight applies to most recent period and smallest weight applies to oldest period.) c) If the forecasted demand for the week of August 31 is 360 and α = 0.20, using exponential smoothing,…
The Vision Hospital is considering the purchase of a new Advance Scan machine. The decision will rest partly on the anticipate patients in the coming months. The numbers of patents during the past years are as follows: Year Number of patents(Actual) 2016 1600 2017 2200 2018 2600 2019 2800 2020 3100 Compute the forecast for the year 2021 using exponential smoothing with a forecast for the year 2016 of 1500 and α = .3
The Grand Bakery produces 60 special sourdough rolls every day. Any rolls that are not sold each day are given to the employees. They have collected sales data from the past week: Day Rolls sold 1 50 2 50 3 48 4 60 5 53 6 60 What is the value of F6 if they use a 3-day weighted moving average with W1 = 0.6, W2 = 0.2, and W3 = 0.2? Using the data from above, calculate the forecast for period 7 using a four-period moving average:
The monthly demand for units manufactured by the Acme Rocket Company has been as follows:Month Units Month UnitsMay 100 September 105June 80 October 110July 110 November 125August 115 December 120a. Use the exponential smoothing method to forecast the number of units for June to January. Theinitial forecast for May was 105 units; a = 0.2.b. Calculate the absolute percentage error for each month from June through December and theMAD and MAPE of forecast error as of the end of December.c. Calculate the tracking signal as of the end of December. What can you say about the performanceof your forecasting method?
The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Week Of August 31 September 7 September 14 September 21 September 28 October 5 Pints Used 350 370 412 378 371 378 a) The forecasted demand for the week of October 12 using a 3-week moving average: response to two decimal places). 106 pints (round your
The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Week of Pints Used August 31 360 September 7 370 September 14 412 September 21 383 September 28 371 October 5 371 a) The forecasted demand for the week of October 12 using a 3-week moving average= {__] Pints (round your response to two decimal places).
The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Week Of Pints Used August 31 September 7 September 14 September 21 September 28 345 370 410 378 368 October 5 371 a) The forecasted demand for the week of October 12 using a 3-week moving average = 372.33 pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.15, 0.30, and 0.55, using 0.55 for the most recent week, the forecasted demand for the week of October 12 = pints (round your response to two decimal places and remember to use the weights in appropriate order – the largest weight applies to most recent period and smallest weight applies to oldest period.)
The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Week Of August 31 September 7 September 14 September 21 September 28 October 5 Pints Used 350 370 410 383 368 374 a) The forecasted demand for the week of October 12 using a 3-week moving average=pints (round your response to two decimal places).
In exponential smoothing, if ɑ = 0.3, then the damping factor for use in forecasting should be: * o .70 o .60 o .40 o .50 o .30
Suppose that a new grocery store chain would want to know more about its inventories. Specifically, store management would like to determine which inventory items sell more than others, which inventory items require more floor space to place and display, and inventory arrival times from suppliers. What are some statistical measures that the company could use in their analysis? Be sure to provide at least 3 statistical measures that could be used, such as stem-and-leaf plots, histograms, standard deviation, mean, etc. Are there any other inventory concerns that the company may want to consider? Remember that this is a generic grocery store (and a new one at that), so there may be some things they have not yet considered.