Explore the Linear Programming
Problem- Staffing a call center
I am having trouble setting up the problem; i.e. identifying the changing and output cells, the constraints, and the target cell. With all the info/data listed in the attached problem/case I have gotten lost. I am looking for a demonstration of how to set up the info in Excel so that the case questions can then be addressed.
I need help to explain in brief and concise and very easy to follow along. All the steps are clearly shown and Excel formulas are provided so that the student can answer similar questions in the future.