solve it in excel

G H B Question 3-(30 marks): A Drive throught Pharmacy is a small family-owned drug compounding business in BC that is trying to perfect its customer service operations. Susan the owner wants to maximize the productivity of his staff as well as serve customers well. One area of concern is the drivethru operation during the 7:30-8:30 morning rush hour. The process of fulfilling an order is as follows: a) Draw a precedence diagram.(S marks) b) If all the steps are handled by one employee, how many patients could be served per hour? (5 marks) c) How many stations are required using the longest work element decision rule? (10 marks) d) Using the solution developed in partc, which station is the bottleneck and how large is its capacity cushion? (10 maria) Work Element A-Greet patient and take prescription B-Check patient information on system C-Gather compounding materials D-Perform compounding E-Package and label F-Instruct patient on use G-Collect payment Time (Second) Immediate Predecessor(s) 40 N/A 45 A 55 A 50 65 D 40 B 25 B 320 A-XX G H B Question 3-(30 marks): A Drive throught Pharmacy is a small family-owned drug compounding business in BC that is trying to perfect its customer service operations. Susan the owner wants to maximize the productivity of his staff as well as serve customers well. One area of concern is the drivethru operation during the 7:30-8:30 morning rush hour. The process of fulfilling an order is as follows: a) Draw a precedence diagram.(S marks) b) If all the steps are handled by one employee, how many patients could be served per hour? (5 marks) c) How many stations are required using the longest work element decision rule? (10 marks) d) Using the solution developed in partc, which station is the bottleneck and how large is its capacity cushion? (10 maria) Work Element A-Greet patient and take prescription B-Check patient information on system C-Gather compounding materials D-Perform compounding E-Package and label F-Instruct patient on use G-Collect payment Time (Second) Immediate Predecessor(s) 40 N/A 45 A 55 A 50 65 D 40 B 25 B 320 A-XX