MGMT 3332 - SPRING 2016 Online- CASE 1 - Clinton Urgent Care service Clinton Urgent Care service opened in early 2012 to provide health care service to patients who needed to see a physician urgently, but did not have a condition that called for an emergency. Since the number of patients that came every day varied, Martha Jones, the manager of Clinton, found it difficult to schedule staff. The service opened from 8 a.m. to 8 p.m. every day. Often staff had to stay longer due large number of patients waiting for service. She approached Gary Adams, a recent graduate of UHD who had received an \"A\" in MGT 3332, to help her out to do a better job of forecasting. Gary shuffled over his old notes and thought he could use what he had learned in MGT 3332. He recalled that in such cases Time Series data could be useful. So, he asked Martha to provide him the recent patient data. Martha went back to her office and compiled the past data as shown in Table below. Date 8/1/2014 8/2/2014 8/3/2014 8/4/2014 8/5/2014 8/6/2014 8/7/2014 8/8/2014 8/9/2014 8/10/2014 8/11/2014 8/12/2014 8/13/2014 8/14/2014 8/15/2014 No. of Patients 63 70 65 72 72 70 71 81 70 75 65 94 78 80 82 Date 8/16/2014 8/17/2014 8/18/2014 8/19/2014 8/20/2014 8/21/2014 8/22/2014 8/23/2014 8/24/2014 8/25/2014 8/26/2014 8/27/2014 8/28/2014 8/29/2014 8/30/2014 8/31/2014 No. of Patients 80 79 88 86 85 90 72 93 88 98 95 90 89 95 98 96 A. Plot a scatter diagram of the above data. Do you think time series models will be useful for forecasting in such a situation? B. Determine a linear trend line for forecasting. Use your trend equation to forecast for the date of your birthday in month of September. (If your birthday is 5th November, forecast for 5th September. If your birthday is 25th February, forecast for 25th September). C. Assume the forecast on 8/26/2014 was same as the actual, forecast for September 1, using exponential smoothing method. Use alpha=0.4 if your birth date is an odd number; use alpha = 0.7, it is an even number. Use Excel for this exercise. You need to submit this case analysis by midnight 2/23/2016. Your report must show all the work that you needed to arrive at the final answers. All of your work must be original done by you alone. No late submission will be accepted under any circumstances