UNION AIRWAYS is adding more flights to and from its hub airport, and so it needs...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
UNION AIRWAYS is adding more flights to and from its hub airport, and so it needs to hire additional customer service agents. However, it is not clear just how many more should be hired. Management recognizes the need for cost control while also consistently providing a satisfactory level of service to customers. Therefore, an OR team is studying how to schedule the agents to provide satisfactory service with the smallest personnel cost. Based on the new schedule of flights, an analysis has been made of the minimum number of customer service agents that need to be on duty at different times of the day to provide satisfactory level of service. The rightmost column of the table below shows the number of agents needed for the time periods given in the first column. The other entries in this table reflect one of the provisions in the company's current contract with the union that represents the customer service agents. The provision is that each agent works an 8-hour shift 5 days per week, and the authorized shifts are Shift 1: 6am-2pm Shift 2: 8am-4pm Shift 3: Noon to 8 pm Shift 4: 4pm to midnight Shift 5: 10 pm to 6 am. Marks in the main body of the table show the hours covered by the respective shifts. Because some shifts are less desirable than others, the wages specified in the contract differ by shift. For each shift, the daily compensation (including benefits) for each agent is shown in the bottom row of the table. The problem is to determine how many agents should be assigned to the respective shifts each day to minimize the total personnel cost for agents, based on this bottom row, while meeting (or surpassing) the service requirements given in the rightmost column. Time period 1 2 3 4 5 Min.number of agents needed 8ат 48 8 – 10am 79 10 - noon 65 — 2рт 2 — 4рт 4 — брт 6 — 8рт 8— 10рт 10 – midnight midnight – 6am daily cost per agent 170 noon - 87 64 73 82 43 52 15 160 175 180 195 Formulate an LP model for this problem. 8 8 8 8 UNION AIRWAYS is adding more flights to and from its hub airport, and so it needs to hire additional customer service agents. However, it is not clear just how many more should be hired. Management recognizes the need for cost control while also consistently providing a satisfactory level of service to customers. Therefore, an OR team is studying how to schedule the agents to provide satisfactory service with the smallest personnel cost. Based on the new schedule of flights, an analysis has been made of the minimum number of customer service agents that need to be on duty at different times of the day to provide satisfactory level of service. The rightmost column of the table below shows the number of agents needed for the time periods given in the first column. The other entries in this table reflect one of the provisions in the company's current contract with the union that represents the customer service agents. The provision is that each agent works an 8-hour shift 5 days per week, and the authorized shifts are Shift 1: 6am-2pm Shift 2: 8am-4pm Shift 3: Noon to 8 pm Shift 4: 4pm to midnight Shift 5: 10 pm to 6 am. Marks in the main body of the table show the hours covered by the respective shifts. Because some shifts are less desirable than others, the wages specified in the contract differ by shift. For each shift, the daily compensation (including benefits) for each agent is shown in the bottom row of the table. The problem is to determine how many agents should be assigned to the respective shifts each day to minimize the total personnel cost for agents, based on this bottom row, while meeting (or surpassing) the service requirements given in the rightmost column. Time period 1 2 3 4 5 Min.number of agents needed 8ат 48 8 – 10am 79 10 - noon 65 — 2рт 2 — 4рт 4 — брт 6 — 8рт 8— 10рт 10 – midnight midnight – 6am daily cost per agent 170 noon - 87 64 73 82 43 52 15 160 175 180 195 Formulate an LP model for this problem. 8 8 8 8
Expert Answer:
Answer rating: 100% (QA)
Now Spread sheet farmulation model is done Solution AS faom the above data foamulation ... View the full answer
Related Book For
Marketing Research An Applied Orientation
ISBN: 978-0136085430
6th edition
Authors: Naresh K Malhotra
Posted Date:
Students also viewed these accounting questions
-
Based upon Table 10-2, how many observations should be taken on an operation whose annual activity is 750 pieces and whose cycle time is estimated at 15 minutes?
-
For Exercise 19.29, how many cod should be purchased if leftover fish can be sold to a fertilizer company for 20 cents each?
-
How many factors should be extracted in problem I? Explain your reasoning.
-
What problems may be encountered in making a comparative study of remuneration reports?
-
1. What are the ethics of punitive damages awards? 2. Is it ethical to try and bankrupt a company using a lawsuit? 3. Should courts be able to reduce punitive damage awards? 4. Is $5 billon excessive...
-
An air-gap parallel plate capacitor of capacitance Co = 20 nF is connected to a battery with voltage V = 12 V. While the capacitor remains connected to the battery, we insert a dielectric (K = 2.6)...
-
A dishwashing machine weighing \(75 \mathrm{~kg}\) operates at \(300 \mathrm{rpm}\). Find the minimum static deflection of an isolator that provides 60 percent isolation. Assume that the damping in...
-
Natalie had a very busy December. At the end of the month, after journalizing and posting the December transactions and adjusting entries, Natalie prepared the following adjusted trial balance....
-
What potential solutions can organizations try to help support the adoption of a CDSS? In other words, what are some ways an organization can address the factors of implementation obstruction that...
-
The strength of an item is known to be normally distributed with an unknown mean and unknown variance \({ }^{2}\). A random sample of ten items is taken and their strength measured. The strengths...
-
On January 1, 2011, Air New Jersey Inc. issued $5000 in principal of 3-year bonds with a 9% stated interest rate and semi-annual payments (non-amortizing debt). Air New Jersey incurred $533 in issue...
-
As one of the pioneers in the low cost airline market, easyJet bases its business on a number of principles: Minimize distribution costs by using the internet to take bookings. About 90 per cent of...
-
What is the internal energy, pressure energy, kinetic energy, and enthalpy of a system?
-
What is the stagnation point parameter? Why does the total enthalpy remain unchanged and the total pressure decreases in the steady adiabatic friction pipeline flow?
-
What is supersonic flow around airfoil?
-
Estimate the annual phantom load for a TV with a set-top box if the TV is operated 5 h/day. Determine the annual cost of the phantom load energy if the electricity cost is 0.12/kWh.
-
Q.10. The nodal displacements of rectangular element having nodal coordinates (0, 0), (4, 0), (4, 2) and (0,2) are: -u=0 mm, V-0 mm, u2=0.1 mm, V2=0.05, U3-0.05mm, V3--0.05mm, U4=0 mm and V4= 0 m...
-
A copper rod of length L =18.0 in is to be twisted by torques T (see figure) until the angle of rotation between the ends of the rod is 3.08. (a) If the allowable shear strain in the copper is 0.0006...
-
"Given that the U.S. Bureau of the Census uses sampling to check on the accuracy of various censuses, a constitutional amendment should be passed replacing the decennial census with a sample."...
-
List the major components of a research design.
-
What type of syndicate data will be useful to Marriott?
-
Estimate the depression in the freezing point if \(58.5 \mathrm{~g}\) of \(\mathrm{NaCl}\) is added to \(1 \mathrm{~L}\) of water at atmospheric pressure.
-
Calculate the molal boiling point elevation constant of benzene if its heat of vaporization at \(80.1^{\circ} \mathrm{C}\) is \(30.67 \mathrm{~kJ} / \mathrm{mol}\).
-
A hydrocarbon \(\mathrm{H}_{2}\left(\mathrm{CH}_{2} ight)_{n}\) is dissolved in a solvent \(S\) which freezes at \(9.0^{\circ} \mathrm{C}\). A solution which contains \(0.90 \mathrm{~g}\) of...
Study smarter with the SolutionInn App