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

  Critical thinking and language essay

What role does language and language diversity play in the critical thinking process? How does language empower or limit the expression of our thoughts? What is the role of critical thinking in persuasion?

  What includes all activites involved in selling-renting

What includes all activites involved in selling, renting, and providing goods and services to ultimate consumers for personal, family, or household use?

  Arrest for serious crime

Research suggests that, with regard to social class, arrest for serious crime.

  View of interpersonal communication

In the transactional view of interpersonal communication, the elements of interpersonal communication are seen as interdependent. Why is it important for us to know that a change in one element produces a change in another?

  Business collect using a questionnaire

What sort of information might a business collect using a questionnaire? How might they use the information they have collected for decision making? When a business is using a questionnaire to collect data, why is it important to think about the samp..

  What was the incidence rate of lyme disease

Chittenden County Health Department reported 17 new cases of lyme disease in the first half of 1994 and 18 additional cases during the second half of the year. The population of the county was 204,500 at the beginning of the year and 215,000 at the e..

  History and social sciences

Have you heard of william reese, newport ri school/college teacher art history, history and social sciences?

  Major challenges you believe public policy analysts face

Discuss at least two major challenges you believe public policy analysts face in today’s political environment and propose at least one way to deal with each challenge.

  Elements of the emergency preparedness cycle mean

Explained what the key elements of the emergency preparedness cycle mean. Identified and described who should spearhead preparedness in an organization or community.

  Attribute samplint plans

Consider the following two attribute samplint plans

  Balance the rights of crime victims with those of suspects

Do you believe that a victims' rights amendment to the U.S. Constitution is needed to balance the rights of crime victims with those of suspects?  Why or why not?  In the new crimes that involve sexting ,is there more than one victim in this scenario..

  Comparing spearmans and gardners models of intelligence

Provide several comparisons and several contrasts. Which of the two models do you feel is more in line with psychology today?

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