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
Boysen produces enamel and acrylic paint from two particular raw materials M1 and M2. The following data provides the data regarding the production restrictions.
The warehouse manager wants to gain an understanding of his total costs for the next year. Currently, he expects to have 30 employees earning an average of $18.2 per hour (assume each employee works 1900 hours per year). Her other costs include overhead costs (25.8% of the labor costs) and security (fixed at $35000). Given the current wage pressure, she anticipates having to increase pay by 4.8% next year, but the fixed costs could drop by $750. What is the total cost for the best-case scenario? (Enter whole dollars) Your Answer: The warehouse manager wants to gain an understanding of his total costs for the next year. Currently, he expects to have 28 employees earning an average of $17.9 per hour (assume each employee works 2050 hours per year). Her other costs include overhead costs (23.4% of the labor costs) and security (fixed at $39500). What is the total cost for the base-case? (Enter whole dollars) Your Answer:
like this fill the boxes
Cutey Barber SalonCutey Barber Salon is a trendy barber salon that is located in a densely populated city called Maple. Demand for the services offered by the salon is fairly high. It offers services such as haircuts, hair styling, scalp massaging and conditioning treatment, straight razor and wet shave, beard sculpting, facials and hair colouring. In addition to these services provided, the salon sells premium hair products to customers. The salon has the ability to produce a maximum of 20,000 haircuts and hairstyling per year. Demand for haircuts and hairstyling over the last five years can be seen in the following table:-Year Demand for haircuts and hairstyling2017 11,5002018 12,2002019 13,4002020 14,0002021 14,500Although the business does not have a written vision and mission statement, it is clear in the minds of management what they want to achieve and what they would like to be in the future.Currently, customers can walk in at anytime to be served. At times, customers have to…
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.