Purchase Solution

Pharmadex sells four drugs

Not what you're looking for?

Ask Custom Question

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?

Table Revenue Functions For Pharmadex Example

Revenue

Drug 1 200S10.5
Drug 2 150S20.75
Drug 3 180S¬¬30.6
Drug 4 300S40.3

a. Develop an appropriate nonlinear optimization model and solve it using Solver.
b. Discuss how the company might have obtained the revenue functions given in the table

See attached file for full problem description.

Purchase this Solution

Solution Summary

The solution provides step-by-step instructions and calculations required in Word and Excel files. It also include Solver code in Excel.

Solution Preview

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 that ...

Purchase this Solution


Free BrainMass Quizzes
Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.