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...
-
Using the data file for Exercise 17.55: a. Apply stepwise regression with the rating by board member 9 as the dependent variable and the ratings by the other 8 members as the set of independent...
-
Name some factors that can cause a shift in the supply curve in markets for goods and services.
-
Find the Internet site of Zysman Forensic Accounting, Inc. Where is the company located?
-
Shown below and on the next page are comparative balance sheets for Schmitt Company. Additional information: 1. Net income for 2014 was $93,000. 2. Depreciation expense was $34,000. 3. Cash dividends...
-
urgent In the preparation of the sales budget for the next three-month period, the Rouse Company determined that 41,000 finished units would be needed to fulfill sales obligations. The company has an...
-
You are discussing your 401(k) with Dan Ervin when he mentions that Sarah Brown, a representative from Bledsoe Financial Services, is visiting East Coast Yachts today. You decide that you should meet...
-
Quality is strategic' - please discuss your extent of agreement or disagreement with this statement. Explain and illustrate your arguments with examples from your own contexts
-
If f(x) = (x+4x+7), then f'(x) = 8(x+4x+7)(x+2) f'(1) = 3,932,160 Question Help: Video X L O
-
An organization cannot effectively design or implement strategic initiatives without an excellent understanding of its financial health. This understanding can only be determined by properly...
-
As the first task in your finance internship, you have been asked to find the cost of capital (WACC) for a company. The company has two main sources of capital available. The marginal tax rate for...
-
After attending an informational session on your company's health-care plan offerings, you are still unsure about the right plan to select. Your company offers employees the choice to participate in...
-
2018: average annual energy consumption in the US (private homes) is 867 kWh per month - How many Joules is that? How many calories (cal)? Given that eating an Outback Steakhouse Bloomin' onion is...
-
1. How many times will Python-interpreter execute the third loop's body (i.e. statement on Line 7 )? Blank#1 ) 2. How many times will Python-interpreter execute the first loop's body (i.e. statemen...
-
During 2012, Cheng Book Store paid $483,000 for land and built a store in Georgetown. Prior to construction, the city of Georgetown charged Cheng $1,300 for a building permit, which Cheng paid. Cheng...
-
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...
-
You have agreed to text your friend every 3 hours while driving across the country. You began your trip at 8 AM. What time will it be when you text your friend the 15 th time?
-
If it is \(7: 00\) now, what time was it 34 hours ago?
-
What is the product of 4 and 19 modulo 12 ?
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App