CT-Power has three electric power plants that supply the needs of four cities in connecticut. Each plant can supply some number of killowatt-hours (kwh) as in table. The peak power demands and the costs of sending 1 million kwh of electricity from a plant to a city are also given in the table. CT-Power wants to minimize the cost of meeting each city's peak power demand. From To City 1 City 2 City 3 City 4 Supply (Million kwh) Plant 1 $8 $6 $10 $9 35 Plant 2 $9 $12 $13 $7 50 Plant 3 $14 $9 $16 $5 40 Demand 45 20 30 30 (Million kwh) (a) Formulate this problem as a transportation problem. (b) Find a feasible solution for this problem using Northwest method (c) Use Stepping Stone method to check optimality of your feasible solution and improve your solution if it is not optimum. (d) Solve the problem using Excel solver or CPLEX.

CT-Power has three electric power plants that supply the needs of four cities in connecticut. Each plant can supply some number of killowatt-hours (kwh) as in table. The peak power demands and the costs of sending 1 million kwh of electricity from a plant to a city are also given in the table. CT-Power wants to minimize the cost of meeting each city's peak power demand. From To City 1 City 2 City 3 City 4 Supply (Million kwh) Plant 1 $8 $6 $10 $9 35 Plant 2 $9 $12 $13 $7 50 Plant 3 $14 $9 $16 $5 40 Demand 45 20 30 30 (Million kwh) (a) Formulate this problem as a transportation problem. (b) Find a feasible solution for this problem using Northwest method (c) Use Stepping Stone method to check optimality of your feasible solution and improve your solution if it is not optimum. (d) Solve the problem using Excel solver or CPLEX.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Zucchero Sugar, Inc. has six processing departments for refining sugar—Affination, Carbonation, Decolorization, Boiling, Recovery, and Packaging. Conversion costs are added evenly throughout each process. Data from the month of August for the Recovery Department are as follows: Metric Tons Beginning Work−in−Process Inventory 0 Transferred in 22,000 Ending Work−in−Process Inventory 6,000 Costs Beginning Work−in−Process Inventory $0 Costs added during August : Direct materials 530,000 Direct labor 250,000 Manufacturing overhead 105,000 Total costs added during August $885,000 The ending Work−in−Process Inventory is 100% and 95% complete with respect to direct materials and conversion costs, respectively. The weighted−average method is used. How many metric tons of sugar were refined and transferred to the Packaging Department in August? A. 6,000 metric tons B.…
A fruit juice manufacturer has recently begun negotiations with brokers in the areas where it intends to distribute its products. Before finalizing the agreements, however, the manager wants to determine shipping routes and costs. The firm has three plants with the capacities as shown below: Estimate demands in each of the warehouse localities are: PLANT CAPACITY (PIECES PER WEEK) WAREHOUSE 1 2 3 400 800 600 A B C D DEMAND (PIECES PER WEEK) 900 200 400 300 The estimated ship cost per box for the various routes are: ΤΟ FROM A B C D 1 5 7 9 12 2 10 7 2 3 3 8 9 6 4 Row/Column Opportunity Cost Demand Row/Column Cell Total Cost Opportunity Cost Cost of the above Test of unallocated Cells allocation Supply Amount char
like this fill the boxes
A retail has 8 stores supplied from 4 suppliers, where each supplier supplies different goods. Delivery from the Supplier is in trucks with a capacity of 40,000 units at a cost of $1100 per load plus $100 per delivery to the store. Inventory costs are $0.2 per unit per year. The Supply Chain Manager is considering whether to use direct shipping or Milk Run delivery for 4 stores for each truck in one shipment a) if annual sales in each store are 1000,000 units, which shipping method provides the lower cost b) if the annual sales in each store are 200,000 units, which shipping method provides the lower cost
B & C
The manager of a company wishes to assign three jobs to four machines on one-on-one basis. The cost of each job on each machine if given on the following table. Solve it through Branch and Bound on Assignment Problem.
Friendly Waste Co. runs three different factories and is required by law to safely dispose of chemicals. Waste from three different factories can be processed to reduce the amount of two different types of pollutants. State law requires that the total reduction in the amount of pollutant A is at least 30 tons and pollutant B is at least 40 tons. Using the information in the following table: Factory Proc Cost Per Ton Reduction Plant A Reduction Plant B 1 15 0.1 0.45 2 10 0.2 0.25 3 20 0.4 0.3 •Algebraically formulate a linear programming model to represent this problem.