Reference no: EM131329377
MPL Project- Pharmaceutical Clinical Trial Distribution
A pharmaceutical company, named "LongerLife", plans to deliver clinical trials to three different clinics (C1, C2, and C3). The trials are used for the emergency treatments so LongerLife must fulfill all requirements. LongerLife has 3 deliver trucks. Each truck can ship 200 trials per trip. Depending on the distance between LongerLife and its clinics, the shipping cost may be different. Usually, it takes a week to deliver, i.e., if we decide to deliver in Week 1, the clinic will receive the trials in Week 2 and the truck will be available in Week 2. Each clinic has a dedicated space for holding the left-over trials. The holding cost per trial is around ten cents per week. To simplify the question, LongerLife can produce as many trials as we want in any week. Currently, LongerLife just delivers the trails when the clinics don't have any inventory on hand. Due to the high shipping cost and the frequent out of stocks, LongerLife requests our help. The company has provided the following data. Please use the optimization skills learned in OR/MATH 441 and help LongerLife improve the distribution plan.
The demand data is as follows.
|
Weeks
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
|
C1
|
0
|
0
|
220
|
70
|
60
|
150
|
30
|
130
|
60
|
70
|
|
C2
|
0
|
150
|
30
|
50
|
50
|
10
|
450
|
100
|
50
|
80
|
|
C3
|
0
|
50
|
160
|
40
|
200
|
170
|
0
|
30
|
30
|
120
|
The shipping cost may depend on the distance. The following data is the shipping cost per round trip.
|
|
C1
|
C2
|
C3
|
|
Shipping cost per round trip($)
|
150
|
200
|
250
|
The space in the clinics is shown in the following table.
|
|
C1
|
C2
|
C3
|
|
Inventory Limitation
|
225
|
150
|
100
|
Please provide a report to manager that answers the following:
I. Formulate the problem to determine the distribution in order to minimize the total cost. Please provide a mathematical description of the model.
II. Follow the formulation in Part I and solve this problem using MPL as a Mixed Integer optimization problem. Please provide the .mpl file and any accompanying data files on blackboard. I need machine-readable code so that I can run the problem.
III. If we fix the truck deliver plan (not including the amount of trials in each trip), the problem will become a linear optimization problem. Please comment on the sensitivity of the solution you obtained in part II. to changes in cost coefficients.
IV. Please comment on the sensitivity of the solution you obtained in Part III, i.e., to changes in the constraint data, e.g., to increase the inventory limitation.
V. Given this analysis, what is your recommendation to the company?
VI. (Open question) The actual demand data may not be known when we optimize. In LongerLife, the actual demand may have +10% or -10% variation. The manager would like to also consider this factor in the optimization model. Do you have any suggestion? How do we do?
|
Create list of five ideas for a new venture
: Create a list of 5 ideas for a new venture; include a brief description of each. Then select your top two ideas and write a brief paragraph about the potential of each, explaining why you think it’s a good idea. Research a franchise you might like to..
|
|
The total dollar amount return
: Microsystems Common Stock is selling for $80 per share and pays a cash dividend of $2.40 per share. Calculate the current yield. If the stock is expected to rise to $86.40 in the next year, what would be. The total dollar amount return?
|
|
What is the cost of the origination fee in dollar terms
: Let’s assume that you have just taken out a mortgage loan for $200,000 with an origination fee of 2 points due upfront. The mortgage term is 30 years and the mortgage rate is fixed at 4%. What is the cost of the origination fee in dollar terms?? How ..
|
|
What would be weight used for equity in the computation
: OMG Inc. has 5 million shares of common stock outstanding, 4 million shares of preferred stock outstanding, and 6,000 bonds. Suppose the common shares are selling for $15 per share, the preferred shares are selling for $24 per share, and the bonds ar..
|
|
Determine the distribution in order to minimize total cost
: MPL Project- Pharmaceutical Clinical Trial Distribution. Formulate the problem to determine the distribution in order to minimize the total cost. Please provide a mathematical description of the model
|
|
Review state legal and ethical guidelines for psychologists
: To prepare: Review your state's legal and ethical guidelines for psychologists. Compare these guidelines to the codes of ethics set forth by the APA and the AP-LS
|
|
Summarizing the current psychological research on the topic
: Choose one of the following topics and write a 1,000-1,500 word paper summarizing the current psychological research on the topic. (Many of these topics are broad and you may choose to focus your research on a more specific area of the topic, such..
|
|
Why does descartes embark on the project of radical doubt
: Why does Descartes embark on the project of radical doubt? Explain the steps of his argument in Meditation 1. How does Descartes prove that he exists? What does he determine that he is and why? Explain the steps of his argument in the first half of..
|
|
Significant percentage of our salaries
: We have no moral obligation to take drastic steps to prevent suffering in all cases, and therefore we do not have a moral obligation to donate a significant percentage of our salaries to aid organizations overseas
|