Excel solver is a powerful and simple tool to solve linear programming problem. Here we use it to solve a problem that have five variables and six constraints!! Such problems are impossible to solve manually. The problem deals with right staffing customer service agents. This problem is typical of many organizations involved in customer relations.
Problem Formulation: 2:00
Solving in Excel: 4:06
