Q2 Data

Answer question 1 considering your Assignment 1. 1. OPER Health Center is rightfully worried about the need for additional physicians to cope with the increased patient flow. To see what the implications of increased flows would be, let us first investigate whether physicians are assigned efficiently in the current setting. Consider a typical day. The average numbers of patient arrivals to the health center during different times are shown in the following table. Coefficient of variation for the patient interarrival times is 1.4 and coefficient of variation for the activity times is 2. a) Compute the average waiting time to see a doctor for each time slot. (Remember that only 80% of patients visit the physicians). b) Suppose that the objective of BCG is to ensure that the average waiting time of a patient to see a physician is less than 25 minutes throughout the day (i.e., in each time slot) Develop a physician schedule that satisfies this goal. How many physician hours per day could BGC potentially save if it adopted your plan? (Assume you can change physician assignments at increments of 0.5 , and that a medical examination room or area will always be available for the physicians). c) Considering the same staffing objective in Q1-b, develop a new physician schedule for the projected scenario. Assume that each time slot faces a uniform 25% increase in patient arrivals. Again, assume the same coefficient of variation values and that physician assignments can be altered at increments of 0.5 , and that a medical examination room or area will always be available for the physicians. Does BGC have to add more physician hours to cope with the additional demand? If so, how many physician hours per day? 2. Assume that you are the manager of a travel agency that sells vacation packages to its customers. The agency is open from 8:00 AM to 5:00 PM. Two sales representatives are working in the travel agency to serve incoming customers. The sales representatives are highly skilled and are able to serve any customer with the same efficiency level. At any given time, each representative only serves one customer at a time. As a manager you are concerned about the high waiting times and decide to conduct an analysis to understand the extent of the problem. On a typical day, you logged the arrival times of customers as well as how long it took for the sales representative to serve the customers. Please see the customer arrival time and service time data in the Excel file named "Q2_data.xlsx. You can assume that this data is representative for other operating days as well and the distribution of customer arrivals and service times do not change. Use the data to answer the following questions. a) Compute the average of interarrival times and service times as well as their standard deviation. b) What is the utilization level of the travel agency? c) How long do customers wait before talking to a sales representative on average? d) How many customers are waiting in the queue on average? 3. OPERLaw is a new legal consultancy firm that allows customers and consultants to meet virtually. Potential customers first need to send emails to the firm and answer a survey before a formal relation is formed. Consultants are versatile in their skills and any consultant can handle any customer request. The firm is open from 7 am to 5pm and receives on average ten requests every hour. At any given time, one consultant is responsible for handling customer requests. This takes on average five minutes with a standard deviation of four minutes. The coefficient of variation of the time between two consecutive customer requests is 1. a) What is the utilization of the consultant on duty? b) Compute the average time a customer has to wait to receive a response from a consultant? (i.e., time between sending e-mail and receiving response). c) How many customers on average are waiting for a response at any given time? d) When idle (i.e., not responding to emails), the active consultant is encouraged to do research on a certain topic. On average, how much time can a consultant dedicate to this activity over a working day (Assume 10 work hours in a day). Please upload one pdf file per group per submission (Please do not upload any Excel file). Please make sure that group member names are indicated on the cover page. Please be clear in your analysis. Explain step by step how you arrived at your results and the formulas you have used. For instance the first customer arrived at 08:01 AM. The second customer arrived at 08:08AM. The third customer arrived at 08:15 AM