Suppose the airport management has to decide on allocating a pool of multi-skilled employees to the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Suppose the airport management has to decide on allocating a pool of multi-skilled employees to the following four stations of quarantine procedures for arriving inbound travellers. The procedures carried out at each station are listed below with the estimated time taken per traveller given in square brackets: Station 1: Check (1) passport / Hong Kong identity card (2) health declaration QR code generated in the online declaration form completed before departure (3) vaccination record (4) negative result of polymerase chain reaction (PCR) test taken before departure. [3 minutes] Station 2 (Temporary specimen collection centre): Perform nuclei acid test and rapid antigen test (RAT). Issue a QR code indicating traveller's identity and initial health status. [5 minutes] Station 3: Check identity documents and enter updated health status into the system based on result available from the RAT test (Station 2). If the RAT test result is negative, issue provisional vaccine pass and permission to proceed to baggage collection. [7 minutes] Station 4: Check quarantine hotel booking confirmation letter, notify transport service and assign traveller to corresponding waiting line of transport to hotel by coach/minibus or self- paid designated taxi. [2 minutes] As the number of inbound travelers found at the airport with positive RAT test result (Station 3) is relatively low, it can be assumed that all inbound travellers have to pass through the four stations. The current staff supply mainly comes from the Airport Authority, Department of Health and other government units (including temporary contract staff from other industries). They can be classified into different groups according to their skills trained/qualified for performing the procedures in some of the above stations. The following table summarizes the skill set by group and station with the staff size of each group: Skills trained/qualified Staff group Al Station 1 Station 2 Station 3 Station 4 Staff size 10 8 A2 v 10 H 9 01 7 02 The objective is to maximize the (hourly) throughput rate of the system of stations by finding the smallest throughput rate among all stations (Theory of Constraints), subject to the staff availability in each group. Q1. Determine the optimal allocation plan for employees in the five groups to the four stations. Formulate the problem by an integer program in a mathematical model. (Hint: a mixed integer program is a type of integer program allowing integer and continuous decision variables to be formulated.) [18 marks] Q2. Develop an Excel spreadsheet model and use Solver to compute the optimal allocation plan and the maximum hourly system throughput rate. [20 marks] Q3. Some travellers experience long waiting time through the entire system and the airport management also desires to increase the system throughput rate. Which staff group(s) should recruit more employees and what is the minimum number required in order to increase the present throughput rate (result in Q2) by p percent? (a) Modify the formulation in Q1 in terms of p. [12 marks] (b) Modify the Excel spreadsheet model in Q2 for p = 10% and run Solver for the new solution. Repeat for p = 20% and 30%, respectively. [28 marks] Q4. Suppose Station 4 procedures could be merged into Station 1 (by information technology and additional training of staff group A1). This would enable the sum of time taken to be saved by 30 seconds, i.e., 4.5 minutes per traveller and result in only 3 stations (Merged Station 1 with 4, Station 2 and Station 3) with only 4 relevant staff groups (A1, A2, H and O1). Would this option be better than the current layout in terms of system throughput rate, total number of (current and new) employees utilized and new recruits? (a) Explore with Excel for the current layout and improvement percentage of p = 10%, 20% and 30%. (b) Furthermore, list two qualitative factors that should be considered. (You do not have to make the final decision.) -End- [24 marks] [4 marks] Suppose the airport management has to decide on allocating a pool of multi-skilled employees to the following four stations of quarantine procedures for arriving inbound travellers. The procedures carried out at each station are listed below with the estimated time taken per traveller given in square brackets: Station 1: Check (1) passport / Hong Kong identity card (2) health declaration QR code generated in the online declaration form completed before departure (3) vaccination record (4) negative result of polymerase chain reaction (PCR) test taken before departure. [3 minutes] Station 2 (Temporary specimen collection centre): Perform nuclei acid test and rapid antigen test (RAT). Issue a QR code indicating traveller's identity and initial health status. [5 minutes] Station 3: Check identity documents and enter updated health status into the system based on result available from the RAT test (Station 2). If the RAT test result is negative, issue provisional vaccine pass and permission to proceed to baggage collection. [7 minutes] Station 4: Check quarantine hotel booking confirmation letter, notify transport service and assign traveller to corresponding waiting line of transport to hotel by coach/minibus or self- paid designated taxi. [2 minutes] As the number of inbound travelers found at the airport with positive RAT test result (Station 3) is relatively low, it can be assumed that all inbound travellers have to pass through the four stations. The current staff supply mainly comes from the Airport Authority, Department of Health and other government units (including temporary contract staff from other industries). They can be classified into different groups according to their skills trained/qualified for performing the procedures in some of the above stations. The following table summarizes the skill set by group and station with the staff size of each group: Skills trained/qualified Staff group Al Station 1 Station 2 Station 3 Station 4 Staff size 10 8 A2 v 10 H 9 01 7 02 The objective is to maximize the (hourly) throughput rate of the system of stations by finding the smallest throughput rate among all stations (Theory of Constraints), subject to the staff availability in each group. Q1. Determine the optimal allocation plan for employees in the five groups to the four stations. Formulate the problem by an integer program in a mathematical model. (Hint: a mixed integer program is a type of integer program allowing integer and continuous decision variables to be formulated.) [18 marks] Q2. Develop an Excel spreadsheet model and use Solver to compute the optimal allocation plan and the maximum hourly system throughput rate. [20 marks] Q3. Some travellers experience long waiting time through the entire system and the airport management also desires to increase the system throughput rate. Which staff group(s) should recruit more employees and what is the minimum number required in order to increase the present throughput rate (result in Q2) by p percent? (a) Modify the formulation in Q1 in terms of p. [12 marks] (b) Modify the Excel spreadsheet model in Q2 for p = 10% and run Solver for the new solution. Repeat for p = 20% and 30%, respectively. [28 marks] Q4. Suppose Station 4 procedures could be merged into Station 1 (by information technology and additional training of staff group A1). This would enable the sum of time taken to be saved by 30 seconds, i.e., 4.5 minutes per traveller and result in only 3 stations (Merged Station 1 with 4, Station 2 and Station 3) with only 4 relevant staff groups (A1, A2, H and O1). Would this option be better than the current layout in terms of system throughput rate, total number of (current and new) employees utilized and new recruits? (a) Explore with Excel for the current layout and improvement percentage of p = 10%, 20% and 30%. (b) Furthermore, list two qualitative factors that should be considered. (You do not have to make the final decision.) -End- [24 marks] [4 marks]
Expert Answer:
Answer rating: 100% (QA)
Q1 Mathematical Model Formulation Let Xij Number of employees from staff group i assigned to station j Objective function Maximize the hourly throughp... View the full answer
Related Book For
Posted Date:
Students also viewed these economics questions
-
A coupon-bearing bond purchased when issued at par value was held until maturity during which time interest rates rose. The ex-post realized return of the bond investment most likely was: a) above...
-
For a science experiment, you would like to use the Doppler effect to double the perceived frequency of a harmonica, from the 261.7-Hz tone (middle C) that it emits, to 523.3 Hz (C5 note). (a) Which...
-
Vision would like to use many of its advertising brochures and jingles in several foreign countries (all of which adhere to both the Berne Convention and the WIPO treaties). These materials have...
-
You are appraising a three-year-old, single-tamily residence. The total square footage of the livable area is 2,500. The garage is 500 sq. ft. According to figures obtained from a cost-estimating...
-
1. Why arent POS terminals wiped more often? 2. What actions can retailers take to reduce credit card fraud? 3. Consider the following statement: Retail outlets should be required by law to put up...
-
Using loop ACFDEA from Figure 14.10, and the data from Table 14.6, what is the (a) Misclosure in the X component? (b) Misclosure in the Y component? (c) Misclosure in the Z component? (d) Length of...
-
What was the role of anthropology in colonialism?
-
Westin Watercrafts predetermined overhead rate for year 2011 is 200% of direct labor. Information on the companys production activities during May 2011 follows. a. Purchased raw materials on credit,...
-
What are the aims and tools of promotion, and explain why promotion is important for companies. Please explain with definition the promotional tools and briefly describe what are the elements that...
-
Opsco Corp. provides the following information about its post-retirement health-care benefit plan for the year 2023: Instructions a. Assuming Opsco follows IFRS, calculate the post-retirement benefit...
-
48) When Scrum Team members meet and collaborate with each other to find the best way to build and deliver the software to the customer, which of the following Agile Values is being practiced?...
-
Gravity-powered roller coasters have a motorized chain assembly that hauls the cars up to the top of the first hill. No additional source energy is supplied for the rest of the trip. What is the...
-
Two cars collide inelastically on a city street. For the two-car system, which of the following are the same in any inertial reference frame: \((a)\) the kinetic energy, (b) the momentum, (c) the...
-
A red \(10-\mathrm{kg}\) cart is connected to a \(20-\mathrm{kg}\) cart by a relaxed spring of spring constant \(60 \mathrm{~N} / \mathrm{m}\). The \(20-\mathrm{kg}\) cart is resting against another...
-
A train engine is pulling four boxcars, each of inertia \(m\). The engine can exert a force of magnitude \(F\) on what it is pulling. Assuming that friction can be ignored, what is the tension in...
-
You release a block from the top of a long, slippery inclined plane of length \(\ell\) that makes an angle \(\theta\) with the horizontal. The magnitude of the block's acceleration is \(g \sin...
-
what ways do disturbances, such as natural disasters or anthropogenic activities, perturb the equilibrium of ecosystems, and what are the long-term implications for ecosystem structure and function?
-
Define cultural intelligence. Cite the books or journal articles you found in Capella's library. Explain why cultural intelligence is important for HR practitioners and other organizational managers.
-
At the measured frequency, what is the ratio of the capacitive reactance of a typical clavus sample to that of verruca? A. 0.21 B. 4.9 C. 16 D. 110
-
Skylab, the largest spacecraft ever to fall back to the Earth, met its fiery end on July 11, 1979, after flying directly over Everett, WA, on its last orbit. On the CBS Evening News the night before...
-
Charged particles pass through a velocity selector with electric and magnetic fields at right angles to each other, as shown in FIGURE 22-42. If the electric field has a magnitude of 450 N/C and the...
-
How do you use functional requirements for this chapter?
-
How do you apply nonfunctional requirements for this chapter?
-
Identify the EBT for the word deployment.
Study smarter with the SolutionInn App