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?
-
La-Z-Boy Inc. is one of the worlds largest manufacturers of furniture and is best known for its reclining chairs. The following data (in thousands) were adapted from its 2010 annual report: Accounts...
-
A news station reported about a potentially fatal epidemic disease occurring in a small Laotian village. An epidemiologist from the CDC was interviewed to discuss the disease and was very distressed...
-
Assume that a manufacturing company is determining the optimal minimum level of cash to maintain in a financial institution to cover short-term needs. Separately consider each of the following...
-
According to results from the Spine Patient Outcomes Research Trial, or SPORT, surgery for a painful, common back condition resulted in significantly reduced back pain and better physical function...
-
Cullumber Inc. has a customer loyalty program that rewards a customer with 1 customer loyalty point for every $10 of purchases. Each point is redeemable for a $3 discount on any future purchases. On...
-
Singularity in density of states (a) From the dispersion relation derived for a monatomic linear lattice of N atoms with nearest-neighbor interactions, show the density of modes is D(w) = 2N/ 1 /(w 2...
-
Critical Reflections 4 American yawp ch.24 module 7 War World 11 objectives and proposes by efficiently writing: 1) you need a clear topic sentence or main idea, 2) you need to provide evidence and...
-
Evaluate the definite integral 2+xdx.
-
The Allwardt Trust is a simple trust that correctly uses the calendar year for tax purposes. Its income beneficiaries (Lucy and Ethel) are entitled to the trust's annual accounting income in shares...
-
Arrange this into a speech: It gives me great pleasure to have this opportunity to speak with you today on theimpactof accounting on Caribbean society. Accounting is an essential component of...
-
A company receives a 5-year 8% accrued interest $100,000 principal loan. Principal (and accrued interest) is only paid at the end of 5 years. The company must pay the lender 4% fees up front and has...
-
(a) Why is designing truly secure systems difficult? State TWO reasons. (4 marks) (b) In the context of network security, what are Dictionary and Reply attacks? (4 marks) (c) Explain how do Intrusion...
-
Based on the principles in the Job Characteristics Model, give an example and make five recommendations that could help the Hotel Front Office Leadership Team improve motivation levels and employee...
-
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?
-
The three general phases of analysis, design, and implementation are part of a ( _________________ ). (a) system development study (b) systems approach (c) expert system (d) decision support system
-
( ____________ ) is the first step in the systems approach. (a) systems design (b) stating objectives (c) systems analysis (d) systems evaluation
-
Characterize the organizational structure of the information system function.
Study smarter with the SolutionInn App