Question: A company has a total of 12 salespersons it wants to assign to three regions - the South, the East, and the Midwest.

Profit earned per salesperson per month:

South earns $600

East earns $540

Midwest earns $375

The southern region can have a maximum assignment of 5 salespersons. Each region must have at least 1 salesperson. The company has a total of $750 per day available for expenses for all 12 salespersons.

Average daily expenses are:

South $80/day

East $70/day

Midwest $50/day

Determine the number of salespeople to assign to each region to maximize profit.

* Formulate an integer programming model for this problem.

*Use Solver in Excel

*So you understand what is going on in solver, you must cut and paste your excel dialog box with all calculation s showing, as well as showing all formulas in cells