Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I would like to use Excel Solver (step by step including which cells to type in) to minimize the cost and find out how many
I would like to use Excel Solver (step by step including which cells to type in) to minimize the cost and find out how many more staff I need to hire. If there are 25 staff that currently can review 204,000 requests in year 2023. I want to know how many more staff I need to hire if requests increase to 324,247 requests in 2024, 327,294 requests in Year 2025, and Y 330342 requests in Year 2026. Wage per staff: $55 per hour Number of hours worked per staff per day: 7.5 hours Number of days worked per week: 5 days. Make sure to take into account that currently 25 pharmacists can review 204,000 in 2023. Please provide number of pharmacists in answer and screenshot of Excel solver
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started