Question: Please explain the steps in to solve this in excel pharmacists is $40 per hour and the average salary for technicians is $10 per hour.

Please explain the steps in to solve this in excel
pharmacists is $40 per hour and the average salary for technicians is $10 per hour. Min40P+10T s.t. Employees (pharmacists and technicians) required Service quality guideline Pharmacists employed 2PT0P90 P,T0 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 What will be the impact on the payroll? The payroll cost using the current levels of 85 pharmacists and 175 technicians is \$ by $ per hour. The payroll cost using the optimal solution in part (a) is \$ per hour. The payroll cost using the optimal solution in part (a) is \$ per hour. Thus, the payroll cost will go per hour. Thus, the payroll cost will go
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
