Explore BrainMass

Linear Programming

Case 2-3: 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.


Solution Summary

The solution does a great job of answering the question. The solution is 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. It can be easily understood by anyone with a basic understanding of the topic. Overall, an excellent solution.

The attachment contains the completely solved solution to the problem.