Question: Need to use solver to solve the question: The question is: ANP Lighting needs to hire 100 employees. They are going to hire these employees

Need to use solver to solve the question:
The question is:
ANP Lighting needs to hire 100 employees. They are going to hire these employees within the Org Level 3 positions. Each of the Org Level 3 titles has a minimum number of employees required listed in Column F. The company owners have requested that you limit number of hires per Org Level 3 title to be no less than 5% and not exceed 12% of the total number of employees hired. Use the worksheet and Solver to minimize the Total Salary by identifying the number of employees to hire in each Org Level 3 title.
ANP Lighting needs to hire 100 employees. They are going to hire these employees within the Org Level 3 positions. Each of the Org Level 3 titles has a minimum number of employees required listed in Column F. The company owners have requested that you limit number of hires per Org Level 3 title to be no less than 5% and not exceed 12% of the total number of employees hired. Use the worksheet and Solver to minimize the Total Salary by identifying the number of employees to hire in each Org Level 3 title
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
