The Transportation Security Administration (TSA) at a large airport has 175 agents hired and trained for the

Question:

The Transportation Security Administration (TSA) at a large airport has 175 agents hired and trained for the month of January. Agents earn an average of $3,300 per month and work 160 hours per month. The projection is that 26,400 agent-hours will be required in February, 29,040 agent hours will be required in March, and 31,994 agent hours will be required in each of the months of April and May. Attrition during the month of January is anticipated to be 5%, so only 95% of the agents trained and working in January will be available for work in February. Efforts are being made to improve attrition: The TSA expects to lose only 4% of agents during February, 3% in March, and 2% in May. To ensure that enough agents will be available to meet the demand, new agents must be hired and trained. During the one-month training period, trainees are paid $2,600. Existing agents, who normally work 160 hours per month, are able to work only 80 hours during the months they are training new people. How many agents should be hired during the months of January to May?
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Managerial Decision Modeling With Spreadsheets

ISBN: 9780136115830

3rd Edition

Authors: Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair

Question Posted: