Transportation network for cliftons distribution problem

Assignment Help Other Subject
Reference no: EM1383765

Q.1. Clifton Distributing has three plants and four distribution centers. The plants, their supply, the distribution centers, their demands, and the distance between each location is summarized in the following table:

Distance

Center 1

Center 2

Center 3

Center 4

Supply

Plant A

45

60

53

75

500

Plant B

81

27

49

62

700

Plant C

55

40

35

60

650

Demand

350

325

400

375

 

 Draw the transportation network for Clifton's distribution problem. Formulate the LP model for Clifton assuming they wish to minimize the total product-miles incurred. Implement a spreadsheet model and use Excel Solver to obtain an optimal solution to the problem.

Q.2. A small town wants to build some new recreational facilities. The proposed facilities include a swimming pool, recreation center, basketball court and baseball field. The town council wants to provide the facilities which will be used by the most people, but faces budget and land limitations. The town has $400,000 and 14 acres of land. The pool requires locker facilities which would be in the recreation center, so if the swimming pool is built the recreation center must also be built. Also the council has only enough flat land to build the basketball court or the baseball field. The daily usage and cost of the facilities (in $1,000) are shown below.

Variable

Facility

Usage

Cost ($1,000)

Land

X1

Swimming pool

400

100

2

X2

Recreation center

500

200

3

X3

Basketball court

300

150

4

X4

Baseball field

200

100

5

 Formulate the ILP to maximize the daily usage of the recreational facilities. Implement a spreadsheet model and use Excel Solver to obtain a solution to the problem.

Q.3. ABC, Inc. produces two high-priced metal baseball bats, the Slugger and the Launcher, that are made from special aluminum and steel alloys. The cost to produce a Slugger bat is $100, and the cost to produce a Launcher bat is $120. We can not assume that ABC will sell all the bats it can produce. As the selling price of each bat model -- Slugger and Launcher -- increases, the quantity demanded for each model goes down.

Assume that the demand, S, for Slugger bats is given by S = 640 - 4PSand the demand, L, for Launcher bats is given by L = 450 - 3PLwhere PS is the price of a Slugger bat and PL is the price of a Launcher bat. The profit contributions are PS S- 100S for Slugger bats and PL L- 120L for Launcher bats. Develop the total profit contribution function for this problem.Implement a spreadsheet model and use Excel Solver to obtain a solution to the unconstrained problem.

Q.4. An office supply company is attempting to determine the order quantity for laser printer toner cartridges which are sold to local businesses. Annual demand is 20,000 units and each cartridge costs the store $25. It costs $30 to place an order and the inventory carrying cost rate is 25% of the value of the item. What is the optimal ordering quantity?

Q.5. The drying rate in an industrial process is dependent on many factors and varies according to the following distribution.

Minutes

Relative Frequency

3

0.14

4

0.3

5

0.27

6

0.18

7

0.11

Use Excel to simulate 100 trials. What is the mean drying time from the 100 trials? Give summary statistics of the results.

  Q.6. An investor is considering 4 investments, A, B, C, D. The payoff from each investment is a function of the economic climate over the next 2 years. The economy can be weak or strong. The investor has estimated the probability of a declining economy at 30% and an expanding economy at 70%.

a. Draw the decision tree for this problem and determine the correct decision for this investor based on the expected monetary value criteria.

b. What decision should be made by the optimistic decision maker?

c. What decision should be made by the conservative decision maker?

d. What decision should be made under minimax regret?

 

Payoff Matrix

 

Economy

Investment

Weak

Strong

A

-30

120

B

20

60

C

30

35

D

15

30

ANS: 

 Q.7. Fold back the decision tree and state what strategy should be followed. Show your work and explain the strategy.

593_Draw transportation network for Cliftons distribution problem.png

Reference no: EM1383765

Questions Cloud

Law of segragation and law of independent assortment : Discuss the difference between the Law of Segragation and the Law of Independent Assortment? During which phases of meiosis do these occur?
Write application to compute and show parking charges : Write down the application which computes and shows parking charges for each customer who parked in garage yesterday. You must enter hours parked for each customer.
Would you want to engage in international trade : would you want to engage in international trade? Why? Why not? What impact would your endeavors in international trade have on your business?
The assignment is a one-page paper detailing : The assignment is a one-page paper detailing your observations of marketing aspects at a retail store
Transportation network for cliftons distribution problem : Draw the transportation network for Clifton's distribution problem. Formulate the LP model for Clifton assuming they wish to minimize the total product-miles incurred
Cystic fibrosis with the autosomal recessive allele : Cystic fibrosis is inherited with autosomal recessive allele individuals with autosomal dominant allele do not have the disease.
What are the differences between an executive agency : What are the differences between an Executive Agency and an Independent Agency? Also give an example of both.
Describe your findings as frequencies for the unit : Describe your findings as frequencies for the unit of analysis selected. Respond to at least two of your fellow students' postings.
Starch and cellulose in sugar type, glycosidic linkage type : Discuss similarities and differences between starch and cellulose in sugar type, glycosidic linkage type, three dimensional structure, solubility and function.

Reviews

Write a Review

 

Other Subject Questions & Answers

  Article on schizophrenia

Select an article on schizophrenia and review on the following:

  Incorporateing sentencing goals of retribution

You are a judge and an individual appears before you having been convicted of stealing others' identities for monetary gain.

  Elaborate on tourism planning and its importance

Elaborate on Tourism Planning and its importance What are the major Strengths, Weaknesses, Opportunities and Threats [SWOT] of Mauritius as a tourism destination

  Continuum of managed care models

Explain how the continuum of managed care models helps to understand the level of control for access, quality, and costs for each type.

  Social change and modernization

Illustrate out social change. What are the key features of social change? Give four examples of social movements, current or past, and describe the key features of each movement.

  Violating the 5th amendment

Identify and explain the protections afforded to the accused under the 5th amendment. Explain when, if ever, a person can be compelled to testify against him/herself.

  Policing and public perception

How does the use of police discretion influence community perceptions? What may police agencies do to improve the image of policing?

  Beginning a self-improvement effort

If you were beginning a self-improvement effort at this time, where would you start? Physical health, social love, values, occupational satisfaction. What actions should you take?

  Explaining the business strategy

how can one determine if there is a business necessity?

  Relationship between behavior and culture

Illustrate the role of research in cross-cultural psychology?

  Discussing the case of breach of duty

The employee was caught; however, he has subsequently spent the money and it cannot be recovered. Has this director breached any of his director's duty as a result?

  Discussing the us social security system

There're many aspects of program which can be adjusted. Do you believe that you should be capable to choose if you want to contribute and therefore collect Social Security?

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