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 $90$M $+84$B $+70$N $+60$D

Subject to:

Advertising Budget $10$M $+8$B $+9$N $+15$D $<=5000$

Sales force Time Available $2$M $+3$B $+3$N $+0$D $<=1800$

Total Production Level M $+$ B $+$ N $+$ D $=600$

Contract N $>=150$

Non$-$negativity M$,$ B$,$ N$,$ D $>=0$

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?

Question $8$ options:

M$=75$ B$=475$ N$=50$ D$=20.$ Total Profit $=$ $$51,350$

M$=25$ B$=425$ N$=150$ D$=0.$ Total Profit $=$ $$48,450$

M$=50$ B$=420$ N$=20$ D$=50.$ Total Profit $=$ $$44,180$

M$=80$ B$=360$ N$=50$ D$=0.$ Total Profit $=$ $$40,940$