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© BrainMass Inc. brainmass.com October 9, 2019, 6:50 pm ad1c9bdddf
Please see attached files
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 ...
The solution provides very detailed instructions in Word and Excel documents for the optimization problem of Pharmadex.