Question: Modified Demand and Supply/Production Costs - Using the EXCEL solver example what is the optimal solution if the demand and costs are changed as follows:

Modified Demand and Supply/Production Costs - Using the EXCEL solver example what is the optimal solution if the demand and costs are changed as follows: Supply cost from P1 to W1=$2.25 and W1 to C3=$3.00, Production cost at P1=$4 and P2=$6, and the demand for C2 changes to 87000. All other data is same as in Slide 30 Lecture- 2 . 1735000 1869000 1957800 1910200 1886700 NETWORK FLOW OPTIMIZATION - EXAMPLE - Distribution network for a single product - Two production plants P1 and P2 - Plant P1 has unlimited supply capacity, - Plant P2 has a supply capacity of 60,000 units/year - Production cost is the same at both plants. - Two warehouses W1 and W2 with identical warehouse handling costs and both having unlimited capacity. - Three market areas C1, C2 and C3 with demand of 50000,100000 and 50000 units/year. - Unit transportation costs

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Modified Supply Costs - Using the EXCEL solver example what is the optimal solution if the supply costs are changed as follows: P1 to W1 = $1.00 and P1 to W2 = $3.00 Modified Supply Costs - Using the...

final answer please Modified Demand and Supply/Production Costs - Using the EXCEL solver example what is the optimal solution if the demand and costs are changed as follows: Supply cost from P1 to W1...

Q 2.1. - Modified Supply Costs - Using the EXCEL solver example what is the optimal solution if the supply costs are changed as follows: P1 to W1 = $3.00 and W2 to C1 = $1.25. Q 2.1. - Modified...

final answer Modified Supply Costs - Using the EXCEL solver example what is the optimal solution if the supply costs are changed as follows: P1 to W1 =$3.75 and W2 to C2=$0.85. All other data is the...

Question 22ptsModified Demand and SupplyProduction Costs - Using the EXCEL solver example what is theoptimal solution if the demand and costs are changed as follows: Supply cost from P1toW1=$1.80 and...

Using the EXCEL solver example what is the optimal solution if the supply costs are changed as follows: P1 to W1 = $2.00 and W1 to C2 = $6.00. All other data is the same as in Slide 30 Lecture-2

Using the EXCEL solver example what is the optimal solution if the supply costs are changed as follows: P1 to W1 = $2.00 and W1 to C2 = $6.00

Using the EXCEL solver example what is the optimal solution if the demand and costs are changed as follows: Supply cost from P1 to W1 = $1.80 and W1 to C3 = $3.50, Production cost at P1=$6.5 and...

Using the excel solver example what is the optimal solution if the demand and costs are changed as follows. supply cost from P1 to W1= $1.80 and W1 to C3=$3.50, Production cost at P1=$6.5 and...

Journalize the following transactions for Blanches Benches: a. Incurred and paid Web site expenses, $2,800. b. Incurred manufacturing wages of $10,000, 70% of which was direct labor and 30% of which...

Researchers at the University of South Florida investigated the effects of diet on the physiology and behavior of rats (USF News, Oct. 17, 2009). One group of rats was fed a typical American diet...

You are a self - employed commercial lobsterman in Maine. You observe that the exchange rate changes from 0 . 7 5 euros per dollar to 0 . 9 1 euros per dollar, indicating _ _ _ _ _ of the U . S ....

The Risky Company had suffered a huge storm and the inventory in its warehouse was destroyed by floodwaters the day before year-end. The accounting records show that the cost of merchandise on the...