Assume the variables for the previous problem are:

$M,B,N,$ and $D,$ the number of units to be distributed through Marine, Business, National Retail, and Direct channels, respectively.

And the model is:

Max $90M+84B+70N+60D$

Subject to:

Advertising Budget $,10M+8B+9N+15D5000$

Sales force Time Available $2M+3B+3N+OD1800$

Total Production Level

$M+B+N+D=600$

Contract

$N150$

Non$-$negativity

$M,B,N,D0$

Enter the information into Excel's Solver.

How many units of the new product should be distributed through channels $M,B,N,$ and $D$ in order to maximize total profit?