Question 2: (10 points) Consider a pharmacy where customers come to have prescriptions filled. Customers can either have their doctor fax their prescriptions ahead of time and come at a later time to pick up their prescriptions or they can walk in with the prescriptions and wait for them to be filled. Fax-in prescriptions are handled directly by a pharmacist who fills the prescriptions and leaves the filled prescriptions in a bin behind the counter for cashier. Historical records show that approximately 59% of customers have faxed their prescriptions ahead of time and the times for a pharmacist to fill a prescription are triangularly distributed with parameters (2,5,8) minutes. If an arriving customer has faxed his/her prescription in already, a cashier retrieves the filled prescription from the bin and processes the customer's payment. Historical records also indicate that the time required for the cashier to process the transaction are triangularly distributed with parameters (2,4,6) minutes. If an arriving customer has not faxed the prescription ahead of time, the cashier processes payment and sends the customer with the prescription to a pharmacist, who fills the prescription. The distributions of the pharmacist's time and cashier's time are the same as for the fax-in customers [triangular (2,5,8) and triangular (2,4,6) respectively). Fax-in and customer arrival rates vary during the day as do the pharmacy staffing levels. Table 2 (below) gives the arrival and staffing data where C is the number of cashiers, P is the number of Pharmacists available during that time period, al is the arrival rate for fax-in prescriptions and 12 is the arrival rate for customers coming in. Develop a Simio model of this pharmacy, use Connectors not Path for links. Performance metrics of interest include the average time fax-in prescriptions take to be filled, the average time customers spend in the system, and the scheduled utilizations of the cashiers and pharmacists. Assume that the pharmacy opens at 8:00 a.m. and closes at 10:00 p.m. and you can ignore faxes and customers that are still in the system at closing time. Use 500 replications for your analysis of performance metrics of interest to discuss. Table 2: Arrival and staffing data Time Period P A 8:00 a.m. - 11:00 a.m. 11:00 a.m. - 3:00 p.m. 3:00 p.m. - 7:00 p.m. 7:00 p.m. - 10:00 p.m. 1 2 2 1 2 3 2 1 10 10 10 5 12 20 15 12 Note: use green color for 14 arrivals entity and use red color for 12 arrivals entity. a. Submit a screen shot of the 2D facility view at the end of one run (before pressing stop). b. Submit a screen shot of the pivot table for 500 replications after adjusted so the key metrics are prominent and highlighted (e.g., include very little other than the primary metrics of interest as stated above). Attach the Simio model. C. Question 2: (10 points) Consider a pharmacy where customers come to have prescriptions filled. Customers can either have their doctor fax their prescriptions ahead of time and come at a later time to pick up their prescriptions or they can walk in with the prescriptions and wait for them to be filled. Fax-in prescriptions are handled directly by a pharmacist who fills the prescriptions and leaves the filled prescriptions in a bin behind the counter for cashier. Historical records show that approximately 59% of customers have faxed their prescriptions ahead of time and the times for a pharmacist to fill a prescription are triangularly distributed with parameters (2,5,8) minutes. If an arriving customer has faxed his/her prescription in already, a cashier retrieves the filled prescription from the bin and processes the customer's payment. Historical records also indicate that the time required for the cashier to process the transaction are triangularly distributed with parameters (2,4,6) minutes. If an arriving customer has not faxed the prescription ahead of time, the cashier processes payment and sends the customer with the prescription to a pharmacist, who fills the prescription. The distributions of the pharmacist's time and cashier's time are the same as for the fax-in customers [triangular (2,5,8) and triangular (2,4,6) respectively). Fax-in and customer arrival rates vary during the day as do the pharmacy staffing levels. Table 2 (below) gives the arrival and staffing data where C is the number of cashiers, P is the number of Pharmacists available during that time period, al is the arrival rate for fax-in prescriptions and 12 is the arrival rate for customers coming in. Develop a Simio model of this pharmacy, use Connectors not Path for links. Performance metrics of interest include the average time fax-in prescriptions take to be filled, the average time customers spend in the system, and the scheduled utilizations of the cashiers and pharmacists. Assume that the pharmacy opens at 8:00 a.m. and closes at 10:00 p.m. and you can ignore faxes and customers that are still in the system at closing time. Use 500 replications for your analysis of performance metrics of interest to discuss. Table 2: Arrival and staffing data Time Period P A 8:00 a.m. - 11:00 a.m. 11:00 a.m. - 3:00 p.m. 3:00 p.m. - 7:00 p.m. 7:00 p.m. - 10:00 p.m. 1 2 2 1 2 3 2 1 10 10 10 5 12 20 15 12 Note: use green color for 14 arrivals entity and use red color for 12 arrivals entity. a. Submit a screen shot of the 2D facility view at the end of one run (before pressing stop). b. Submit a screen shot of the pivot table for 500 replications after adjusted so the key metrics are prominent and highlighted (e.g., include very little other than the primary metrics of interest as stated above). Attach the Simio model. C
