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+ 2 A- A 1 17 1 72 Þ P.T 250 Full-time-equivalent employees D 90 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+ 2 A- A 1 17 1 72 Þ P.T 250 Full-time-equivalent employees D 90 Quality guideline Number of pharmacists
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
Any help would be greatly appreciated. I am not sure how to solve this problem.
Transcribed Image Text:1. Spreadsheet Model with Solver setup 2%
2. User Interface (be sure to set Object Properties as appropriate) 2%
3. VBA Code to link Model and Interface 2%
4. VBA Code for Formatting 2%
5. VBA Code for Error Trapping 2%
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
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
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.