Homework Help is Here – Start Your Trial Now!
Business
Operations Management
(a) Determine a minimum-cost staffing plan for PharmaPlus. (Let P be the number of full-time equivalent pharmacists. Let 7 be the number of full-time equivalent technicians.) Min s.t. Employees (pharmacists and technicians) required Service quality guideline Pharmacists employed P, 720 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 What will be the impact on the payroll? The payroll cost using the current levels of 85 pharmacists and 175 technicians is $ per hour. The payroll cost using the optimal solution in part (a) is $ per hour. Thus, the payroll cost will go -Select-- by $

(a) Determine a minimum-cost staffing plan for PharmaPlus. (Let P be the number of full-time equivalent pharmacists. Let 7 be the number of full-time equivalent technicians.) Min s.t. Employees (pharmacists and technicians) required Service quality guideline Pharmacists employed P, 720 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 What will be the impact on the payroll? The payroll cost using the current levels of 85 pharmacists and 175 technicians is $ per hour. The payroll cost using the optimal solution in part (a) is $ per hour. Thus, the payroll cost will go -Select-- by $

Practical Management Science
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...
See similar textbooks
icon
Related questions
Question
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 $56 per hour and the average salary for technicians is $14 per hour. (a) Determine a minimum-cost staffing plan for PharmaPlus. (Let P be the number of full-time equivalent pharmacists. Let 7 be the number of full-time equivalent technicians.) Min s.t. Employees (pharmacists and technicians) required. Service quality guideline Pharmacists employed P, 720 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 What will be the impact on the payroll? The payroll cost using the current levels of 85 pharmacists and 175 technicians is $ Need Help? Submit Answer Read It per hour. The payroll cost using the optimal solution in part (a) is $ per hour. Thus, the payroll cost will go ---Select--- by $
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 $56 per hour and the average salary for technicians is $14 per hour. (a) Determine a minimum-cost staffing plan for PharmaPlus. (Let P be the number of full-time equivalent pharmacists. Let 7 be the number of full-time equivalent technicians.) Min s.t. Employees (pharmacists and technicians) required. Service quality guideline Pharmacists employed P, 720 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 What will be the impact on the payroll? The payroll cost using the current levels of 85 pharmacists and 175 technicians is $ Need Help? Submit Answer Read It per hour. The payroll cost using the optimal solution in part (a) is $ per hour. Thus, the payroll cost will go ---Select--- by $
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 13 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,
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.
SEE MORE TEXTBOOKS