Draw a network flow model to represent the problem

Assignment Help Other Subject
Reference no: EM13333834

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: EM13333834

Questions Cloud

Explain the flow of cost in a manufacturing company : In comparing the income statements of merchandising and a manufacturing company, explain how the cost of goods sections are different. Explain the flow of cost in a manufacturing company from raw materials to cost of goods sold. Explain the differenc..
Why is it important to identify and control business risks : Discuss the importance of ethics in business, as we understand it today. Why is a business code of Ethics important to a business? Why is it important to identify and control business risks? Discuss the differences between financial and managerial ac..
What in your thinking justifies a country going to war : What in your thinking justifies a country going to war? What in your thinking justifies that killing of another people in the context of war?
Declared the array of integers within the main function : Write a program that returns the min, max and mean value of an array of integers named data ar.  Your program should call a single function that returns that mean, max and mean value of the array.
Draw a network flow model to represent the problem : 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..
Explain effect of relationships among television-movies : Explain the effect of relationships among television, movies, and electronic games with culture. Include the following: How culture is reflected in movies and television?
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.
Initial enzyme concentration : An enzyme ATPase has a molecular weight of 5 x 104 daltons, a KM value of 10-4M, and a k2 value of k2 = 104 molecules ATP/min molecule enzyme at 37°e.
Argument is based on a false dilemma : Specifically, is Rand correct in saying that selfishness is a virtue and that altruism (helping others) is not a moral good that we should pursue? What about Pojman's criticism of Rand's view? Is he correct in saying that her argument is based on a f..

Reviews

Write a Review

Other Subject Questions & Answers

  Events in chronological order

Arrange the following events in chronological order

  Ethical standards-decision-making approach

Describe how a company’s ethical standards are aligned with its decision-making approach(es) and how you would be certain that ethical decisions were being made. From the perspective of the executive suite, prioritize three of the responsibilities of..

  Study the wbs and gantt charts

Study the wbs and gantt charts provided in figures 3-2 and 3-3. Enter the wbs into project 2007, indenting tasks as shown to create the wbs hierarchy. do not enter durations or dependencies

  Current inequities in us health care system

Critically discuss the current inequities within the U.S. health care system? Using concepts or examples from this week's reading to support your points

  Define authentic leadership

Define authentic leadership and explain why effective leaders exemplify ethics and trust.

  Fortune is not the goal of every ambitious person

Fortune is not the goal of every ambitious person. Only philosophers enjoy logic. Almost all of the patients in the hospital will be home within 48 hours.

  Democracy as a theory of government is centered on

Democracy as a theory of government is centered on

  What is the purpose of government

What is the purpose of government? Why do we need government? Should the government have any concern for the moral character of the citizens? If not, then what should the government be concerned with?

  Describes the process of starch digestion

Which of the following describes the process of starch digestion?

  Research methods is best at explaining behavior

Which of the following research methods is best at explaining behavior (as opposed to simply describing it)?

  Professional context must create negative messages

Sometimes, people writing in a professional context must create negative messages, such as a letter of termination, a press release regarding a company error, a denial of a claim, or a poor performance review. When you write such a negative message, ..

  Hypothetical problem of the missing dollar helps

The hypothetical problem of the missing dollar helps us

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