What is the optimal solution

Assignment Help Other Subject
Reference no: EM13332366

A cotton grower in south Georgia produces cotton on farms in Statesboro and Brooklet, ships it to cotton gins in Claxton and Millen, where it is processed, and then sends it to distribution centers in Savannah, Perry, and Valdosta, where it is sold to customers for $60 per ton. Any surplus cotton is sold to a government warehouse in Hinesville for $25 per ton. The cost of growing and harvesting a ton of cotton at the farms in Statesboro and Brooklet is $20 and $22, respectively. There are

presently 700 and 500 tons of cotton available in Statesboro and Brooklet, respectively. The cost of transporting the cotton from the farms to the gins and the government warehouse is shown in the following table:

Claxton Millen Hinesville

Statesboro $4.00 $3.00 $4.50

Brooklet $3.50 $3.00 $3.50

The gin in Claxton has the capacity to process 700 tons of cotton at a cost of $10 per ton. The gin in Millen can process 600 tons at a cost of $11 per ton. Each gin must use at least one half of its available capacity. The cost of shipping a ton of cotton from each gin to each distribution center is summarized in the following table:

Savannah Perry Valdosta

Claxton $10 $16 $15

Millen $12 $18 $17

Assume that the demand for cotton in Savannah, Perry, and Valdosta is 400, 300, and 450 tons, respectively.

a. Draw a network flow model to represent the problem.

b. Implement your model in Excel and solve it.

c. What is the optimal solution?

Reference no: EM13332366

Questions Cloud

Define nitric oxides no and no_2 contribute to air pollution : Nitric oxides, NO and NO_2, contribute to air pollution, acid rain, and the depletion of the ozone layer. After NO forms in the combustion chamber of an automobile engine, it reacts further with oxygen to form NO_2. The reaction is given by 2NO (g..
Max and mean value of an array of integers : Write a program that returns the min, max and mean value of an array of integers named data ar.
What is the total work done by the spring on the cart : You have a 6kg cart that has a spring attached to the front. You hold the cart so the spring is compressed against the wall. What is the total work done by the spring on the cart
Progressive social change is about defending : Progressive social change is about defending the weak from the strong
What is the optimal solution : A cotton grower in south Georgia produces cotton on farms in Statesboro and Brooklet, ships it to cotton gins in Claxton and Millen, where it is processed, and then sends it to distribution centers in Savannah, Perry, and Valdosta, where it is sold t..
What is the final speed of the struck ball : A ball of mass m = 2.6 kg moving with a speed of v0 = 14.8 m/s strikes an identical ball which was initially at rest. What is the final speed of the struck ball
The information flow and any elements controlling proper : A diagram of the information flow and any elements controlling proper access to the information it uses
Depict the lewis structures for the compounds : Draw the Lewis structures for the following compounds to assist you in answering this question. 1) CBr2H2 2) BH3 3) XeCl4 4) SF4 5) HCl Which compound has no lone pairs
What exactly is 3rd grade state citizenship : what exactly is 3rd Grade state citizenship--i mean i have an idea- but what else can i use to write a lesson plan. so far, i have come with , how to be a good citizen, voting, what it means to be a citizen as opposed to being a non citizen, etc....a..

Reviews

Write a Review

Other Subject Questions & Answers

  What are the core assumptions of biopsychological approach

What are some examples of modern careers that have resulted from studying biological psychology Include an overview of the careers. How is biological psychology viewed by other professionals in psychology today

  Bod progression follows first-order kinetics

A biodegradable industrial wastewater (paper production) has a BOD(subscript 5) of 600 mg/L. If the BOD progression follows first-order kinetics with a rate constant = 0.10 per day, determine the BOD(subscript u).

  Neurological theory-genetic theory-psychodynamic theory

why some adolescents are motivated to commit crimes while others in similar circumstances are not. Neurological theory-Genetic theory-Psychodynamic theory

  What type of reactor is the ice rink

A Zamboni used to clear an ice skating rink is operated for 15 minutes and emits 200 g/min of CO. The skating rink has a volume of 30,000 m3, and a ventilation rate of 350 m3/min. Assume that the CO concentration in outdoor air is negligible and that..

  Concise explanation of plato theory

Please help me with a complete and concise explanation of Plato's Theory of the forms and the myths relating to the Forms, including discussions of the Sun, the Line and the Cave.

  Evaluate why environmental concerns and fire codes

Evaluate why environmental concerns and fire codes must work together. Give at least two practical examples where our environment and citizens equally benefit from the cooperative interaction.

  Kinship-marriage relationships in nonindustrial societies

Which of the following techniques was developed specifically because of the importance of kinship and marriage relationships in nonindustrial societies?

  Description of crisis action planning

What are the strengths and limitations of organizations and how do these strengths and limitations affect crisis planning and management? How can appropriate leadership add to crisis management and planning?

  Role does the media play regarding who is deemed a terrorist

What role does the media play regarding who is deemed a terrorist?

  Cooper and shepard’s results

In the Cooper & Shepard experiment (1973), participants were asked to decide whether a stimulus (a letter) was normal (simply rotated in the picture plane) or backwards (flipped to its mirror image before the rotation).

  Energy system-licensed to primenergy to use-to sublicense

PRM Energy Systems, Inc. (PRM), owned technology patents that it licensed to Primenergy to use and to sublicense in the United States. The agreement stated that all disputes would be settled by arbitration. Kobe Steel of Japan was interested in using..

  Analyze the composition of the calculi

Discuss possible factors that may have been responsible for the development of the stone and use this case to show how the patient's diet and water intake can help analyze the composition of the calculi

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