Reference no: EM131319740
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. Presently, 700 and 500 tons of cotton are available in Statesboro and Brooklet, respectively. The cost of transporting the cotton from the farms to the gins is shown in the following table:
|
Claxton
|
Millen
|
|
|
Statesboro
|
$4.00
|
$3.00
|
|
Brooklet
|
$3.5
|
$3.00
|
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
|
The demand for cotton in Savannah, Perry, and Valdosta is 400, 300, and 450 tons, respectively. The trucks used to ship the cotton can hold a maximum of 400 tons. The cotton grower would like to meet the demand with the minimal shipping cost.
a. Draw a network flow model to represent this problem. Make sure that you note all the numerical information about each node and each arc appropriately on the graph using network modeling convention (if you prefer, you can take a picture of your drawing and paste it to your file).
b. Implement your model in Excel and solve it.
c. What is the optimal solution? You can summarize your solution in a table or in a graph.
|
Difference in the chromium level in the stream
: Could it be stated, at the 95% confidence level, that after and before the spill there was no difference in the chromium level in the stream?
|
|
What is the residual value of the firm
: Baseline (last year) sales: $250 million Sales growth rates: Base year = 15% with a fade rate of 1% a year for years 1-10: (increasing sales due to sustained competitive advantage and a differentiated product)[source: Strategic Plan]. Fade rate is th..
|
|
Discuss how you will apply this learning to your role
: Planning and Executing Projects. During this course, we covered a lot of information in a relatively short time. The overall objective of the course was to provide you with practical hands-on experience focusing on planning, executing, monitori..
|
|
Create a spreadsheet model
: What are the entry level steps to use Analytical Solver on excel to create a spreadsheet model and solve it by using solver?
|
|
What is the optimal solution
: a. Draw a network flow model to represent this problem. Make sure that you note all the numerical information about each node and each arc appropriately on the graph using network modeling convention (if you prefer, you can take a picture of you..
|
|
The portfolio both gamma neutral and delta neutral
: A financial institution has the following portfolio of over-the-counter options on sterling: What position in the traded option and in sterling would make the portfolio both gamma neutral and delta neutral?
|
|
Examine five issues that the it department is likely to face
: CIS336: Create an architectural diagram that shows how the virtual teams would collaborate and access common repositories for documents, software, development, and testing facilities. Use Visio or an equivalent such as Dia. Note: The graphically ..
|
|
Write pitch to either a movie or television producer
: Write a 350- to 700-word pitch to either a movie or television producer. Your pitch will explain your idea for a new TV or movie program that is based on current market trends
|
|
Estimate a standard deviation for the pressure gage
: What conclusions do you draw from these readings? Can you estimate a standard deviation for the pressure gage?
|