Problem 7-49 (Algorithmic)

PharmaPlus operates a chain of 30 pharmacies. The pharmacies are staffed by licensed pharmacists and pharmacy technicians. The company currently employs 90 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 300 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 $50 per hour and the average salary for technicians is $20 per hour.

a. Determine a minimum-cost staffing plan for PharmaPlus. How many pharmacists and technicians are needed? Let P = number of full-time equivalent pharmacists T = number of full-time equivalent technicians Min 50 VP+ 20 VT S.t. 90 X P+ 175 X T 2 - V 300 V Full-time-equivalent employees Numeric field 2 VP 30 XTS X X Quality guideline X P X X Number of pharmacists The optimal solution requires 50 X full-time equivalent pharmacists and 20 X full-time equivalent technicians. The total cost is $ 20 X per hour. 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)? New Hires Required Pharmacists 50 X Technicians 30 X What will be the impact on the payroll? The payroll cost will go up V by $ 20 X per hour