Homework Help is Here – Start Your Trial Now!
Business
Operations Management
PharmaPlus operates a chain of 30 pharmacies. The pharmacies are staffed by licensed pharmacists and pharmacy technicians. The company currently employs 85 full-time- equivalent pharmacists (combination of full time and part time) and 175 full-time-equivalent technicians. Each spring management reviews current staffing levels and makes hiring plans for the year. A recent forecast of the prescription load for the next year shows that at least 250 full-time-equivalent employees (pharmacists and technicians) will be required to staff the pharmacies. The personnel department expects 10 pharmacists and 30 technicians to leave over the next year. To accommodate the expected attrition and prepare for future growth, management states that at least 15 new pharmacists must be hired. In addition, PharmaPlus's new service quality guidelines specify no more than two technicians per licensed pharmacist. The average salary for licensed pharmacists is $40 per hour and the average salary for technicians is $10 per hour. Let P = number of full-time equivalent pharmacists T = number of full-time equivalent technicians 40 P+ 10 7 Min s.t. 1 A+ 2A- 1 A 172 1 7 250 Full-time-equivalent employees D 90 P P.TO Quality guideline Number of pharmacists

PharmaPlus operates a chain of 30 pharmacies. The pharmacies are staffed by licensed pharmacists and pharmacy technicians. The company currently employs 85 full-time- equivalent pharmacists (combination of full time and part time) and 175 full-time-equivalent technicians. Each spring management reviews current staffing levels and makes hiring plans for the year. A recent forecast of the prescription load for the next year shows that at least 250 full-time-equivalent employees (pharmacists and technicians) will be required to staff the pharmacies. The personnel department expects 10 pharmacists and 30 technicians to leave over the next year. To accommodate the expected attrition and prepare for future growth, management states that at least 15 new pharmacists must be hired. In addition, PharmaPlus's new service quality guidelines specify no more than two technicians per licensed pharmacist. The average salary for licensed pharmacists is $40 per hour and the average salary for technicians is $10 per hour. Let P = number of full-time equivalent pharmacists T = number of full-time equivalent technicians 40 P+ 10 7 Min s.t. 1 A+ 2A- 1 A 172 1 7 250 Full-time-equivalent employees D 90 P P.TO Quality guideline Number of pharmacists

Practical Management Science
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter12: Queueing Models
Section: Chapter Questions
Problem 59P
See similar textbooks
icon
Related questions
Question
100%

User Interface (be sure to set Object Properties as appropriate)

I am able to solve the Spread Sheet Model with Solver Set-up, but not sure how to do this part

PharmaPlus operates a chain of 30 pharmacies. The pharmacies are staffed by licensed pharmacists and pharmacy technicians. The company currently employs 85 full-time- equivalent pharmacists (combination of full time and part time) and 175 full-time-equivalent technicians. Each spring management reviews current staffing levels and makes hiring plans for the year. A recent forecast of the prescription load for the next year shows that at least 250 full-time-equivalent employees (pharmacists and technicians) will be required to staff the pharmacies. The personnel department expects 10 pharmacists and 30 technicians to leave over the next year. To accommodate the expected attrition and prepare for future growth, management states that at least 15 new pharmacists must be hired. In addition, PharmaPlus's new service quality guidelines specify no more than two technicians per licensed pharmacist. The average salary for licensed pharmacists is $40 per hour and the average salary for technicians is $10 per hour. Let P = number of full-time equivalent pharmacists T = number of full-time equivalent technicians Min s.t. 40 P+ 10 7 1 A+ 2 P- 1 A 1 72 250 Full-time-equivalent employees 17 10 P P.T 90 10 Quality guideline Number of pharmacists
Transcribed Image Text:PharmaPlus operates a chain of 30 pharmacies. The pharmacies are staffed by licensed pharmacists and pharmacy technicians. The company currently employs 85 full-time- equivalent pharmacists (combination of full time and part time) and 175 full-time-equivalent technicians. Each spring management reviews current staffing levels and makes hiring plans for the year. A recent forecast of the prescription load for the next year shows that at least 250 full-time-equivalent employees (pharmacists and technicians) will be required to staff the pharmacies. The personnel department expects 10 pharmacists and 30 technicians to leave over the next year. To accommodate the expected attrition and prepare for future growth, management states that at least 15 new pharmacists must be hired. In addition, PharmaPlus's new service quality guidelines specify no more than two technicians per licensed pharmacist. The average salary for licensed pharmacists is $40 per hour and the average salary for technicians is $10 per hour. Let P = number of full-time equivalent pharmacists T = number of full-time equivalent technicians Min s.t. 40 P+ 10 7 1 A+ 2 P- 1 A 1 72 250 Full-time-equivalent employees 17 10 P P.T 90 10 Quality guideline Number of pharmacists
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS