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 260 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 stated 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 $52 per hour and the average salary for technicians is $13 per hour. (a) Determine a minimum-cost staffing plan for PharmaPlus. (Let P be the number of full-time equivalent pharmacists. Let T be the number of full-time equivalent technicians.) Min s.t. Employees (pharmacists and technicians) required Service quality guideline Pharmacists employed P, T20 How many pharmacists and technicians are needed? What is the Optimal Objective Value? ] at (P, 7) = ( [ $ (b) Given current staffing levels and expected attrition, how many new hires (if any) must be made to reach the level recommended in part (a)? Additional Pharmacists to hire Additional Technicians to hire Enter an exact number. What will be the impact on the payroll? The payroll cost using the current levels of 85 pharmacists and 175 technicians is $ ---Select---✓ by $ per hour. The payroll cost using the optimal solution in part (a) is $ per hour. Thus, the payroll cost will go

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...
icon
Related questions
Question

Please teach me how to do this!

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 260 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 stated 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 $52 per hour and the average salary for technicians is $13 per hour.
(a) Determine a minimum-cost staffing plan for PharmaPlus. (Let P be the number of full-time equivalent pharmacists. Let T be the number of full-time equivalent technicians.)
Min
s.t.
Employees (pharmacists and technicians) required
Service quality guideline
Pharmacists employed
P, T≥ 0
120
How many pharmacists and technicians are needed? What is the Optimal Objective Value?
at (P, T) =
(b) Given current staffing levels and expected attrition, how many new hires (if any) must be made to reach the level recommended in part (a)?
Additional Pharmacists to hire
Additional Technicians to hire
Enter an exact number.
What will be the impact on the payroll?
The payroll cost using the current levels of 85 pharmacists and 175 technicians is $
---Select--- by $
per hour. The payroll cost using the optimal solution in part (a) is $
per hour. Thus, the payroll cost will go
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 260 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 stated 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 $52 per hour and the average salary for technicians is $13 per hour. (a) Determine a minimum-cost staffing plan for PharmaPlus. (Let P be the number of full-time equivalent pharmacists. Let T be the number of full-time equivalent technicians.) Min s.t. Employees (pharmacists and technicians) required Service quality guideline Pharmacists employed P, T≥ 0 120 How many pharmacists and technicians are needed? What is the Optimal Objective Value? at (P, T) = (b) Given current staffing levels and expected attrition, how many new hires (if any) must be made to reach the level recommended in part (a)? Additional Pharmacists to hire Additional Technicians to hire Enter an exact number. What will be the impact on the payroll? The payroll cost using the current levels of 85 pharmacists and 175 technicians is $ ---Select--- by $ per hour. The payroll cost using the optimal solution in part (a) is $ per hour. Thus, the payroll cost will go
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
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
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.