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...
-
Investigate a nonprofit organization in your area. What cause is it serving? What is the primary source of its income? What are its main expenses?
-
Force F is applied to the handle of the wrench. Determine the angle θ between the tail of the force and the handle AB. Given: a = 300 mm b = 500 mm F = 80 N θ1 = 30 deg θ2 = 45 deg ...
-
What are some indicators that a digital device has been infected?
-
Brook Exteriors is a firm that provides house-painting services. Richard Brook, the owner, is trying to find new ways to increase revenues. Mr. Brook performs the following actions, not in the order...
-
Activity 1 Response: Measure the temperature of the environment (ambient temperature), the human body (both forehead and under the tongue), and two other objects in the room. Record this information...
-
1. If Bozena participates and the 401(k) earns 10 percent annually, how much will she have accumulated in 45 years (to age 67) even if her salary does not change? 2. If she does not participate and...
-
How does the stem-and-leaf plot show the distribution of these data? O A. The lengths of the rows are similar to the widths of bars in a histogram; longer rows of data correspond to higher frequer O...
-
The internet has become a vital marketing medium, and payper-click (PPC) is one of the many ways for a business to attract traffic. It is risky, and a business can spend a lot of money, get a lot of...
-
Calculate the nominal rate of interest for a new bond that will mature in 10 years assuming the following bond characteristics and market risks: a. Three-month T-bill rate of 4 percent b. Anticipated...
-
After studying the fundamental trends from COX Company's annual report, you have decided to purchase one round lot of the firm's stock on the open market. On Monday morning you call a stockbroker and...
-
If there are 20 multiple choice questions in an exam, and each question has two possible answers, how many different answers are possible?
-
How many different outcomes are possible if a fair die is rolled 6 times and how many if a fair coin is tossed 8 times? Explain the difference between the results of the two.
-
A common practice to evaluate a fund manager is to identify a benchmark asset of similar investment style and compare the fund manager's performance against the benchmark. Good-performing fund...
-
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...
-
Identify the most promising areas of research for future researchers in the area of hedge fund systemic risk.
-
Discuss how hedge funds and the potential for shadow banking may contribute to systemic risk and the prospect for contagion.
-
Explain the relation between hedge fund characteristics and risks.
Study smarter with the SolutionInn App