Determine the distribution to minimize the total cost, Financial Management

Assignment Help:

A pharmaceutical company, named "XYZ", plans to deliver trials to three different clinics (C1, C2, and C3). The trials are used for the emergency treatments so XYZ must fulfill all trial requirements. XYZ has 3 deliver trucks. Each truck can ship 200 trials per trip. Depending on the distance between XYZ 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, XYZ can produce as many trials as we want in any week. Currently, XYZ just ship when the clinics don't have any inventory. However, it costs higher and sometimes the trials in the clinics may be out of stocks. XYZ asks our help and provide the following data. Please use the optimization skills learned in OR 541 and help XYZ 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 trip.

Shipping cost per trip($)

C1

C2

C3

XYZ manufacturing facility

150

200

250

The space in the clinics is shown in the following table.

Inventory Limitation

C1

C2

C3

 

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.

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 XYZ, 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?


Related Discussions:- Determine the distribution to minimize the total cost

Calculate expected gain or loss from the forward hedging, 1. A company sold...

1. A company sold a super computer to an Institute in Germany on credit and invoiced DM 10 million payable in six months. Presently, the six-month forward exchange rate is $1.50/DM

Financial ratios, Financial Ratios: Another method of measuring and mon...

Financial Ratios: Another method of measuring and monitoring performance is through the use of financial ratios and other comparative tools. Financial ratios use information

Return on investment , Return on Investment (ROI) In accounting it is a...

Return on Investment (ROI) In accounting it is a measure of the earning power of an industries asset. A high return on investments is desirable. ROI is widely described as net

Material uses and purchases budget, XYZ company produces three products X,Y...

XYZ company produces three products X,Y and Z. for the coming accounting period budgets are to be prepared based on following information. Budgeted Sales Product X       2,00

Explain the term present value of the firm''s operations, Explain the term ...

Explain the term "present value of the firm's operations" (also known as Enterprise Value ).  What does this number represent? The present value of the company's free cash flo

Project, AThe project is expected to have an initial outlay of $200million ...

AThe project is expected to have an initial outlay of $200million and generate cash inflows of $64million for the next 12 yearssk question #Minimum 100 words accepted#

Beta, what is the value of beta for this fund ? If the benchmark index for ...

what is the value of beta for this fund ? If the benchmark index for this mutual fund increased by 11.00% during the period covered by beta measure, what was the rate of return for

European community, European Community (EC) An economic alliance, evalu...

European Community (EC) An economic alliance, evaluated in 1957, designed to encourage trade and economic cooperation between its members.  The EC is also called the European

Sally Thomson, Ask questionSally Thomson #Minimum 100 words accepted#

Ask questionSally Thomson #Minimum 100 words accepted#

Explain the principles of taxation and double taxation, Question 1 ) A Glob...

Question 1 ) A Globalization is a procedure of international integration that arises due to increasing human connectivity as well as the interchange of products, ideas and other ph

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd