Explore BrainMass
Share

### Explore BrainMass

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

Pharmadex sells four drugs. It costs Pharmadex \$50,000 per year per salesperson. The annual revenue generated from each drug is a function of the number of salespeople assigned to the drug. This dependence is shown in the table below, where Si is the number of salespeople assigned to drug i , and revenue is expressed in thousands of dollars. If Pharmadex wants to maximize profit (revenue from sales minus salesperson costs), how many salespeople should it assign to each drug?

See full problem in attached file

#### Solution Preview

a. Let Si be the number of salespeople for drug i.
Let Ci be the cost for drug i.
Let Ri be the revenue for drug i. Ri can be calculated using Table 1.
Let Pi be the profit for drug i.
We need to maximize the following function:

I have done so in Excel using the Solver tool. Note ...

#### Solution Summary

The solution provides very detailed instructions in Word and Excel documents for the optimization problem of Pharmadex.

\$2.19