Three electric power plants with capacities of 25, 40, and 30 million KWh supply electricity to three cities. The maximum demands at the three cities are estimated at 30, 35 and 25 million KWh. The price per million KWh at the three cities is given in the table below.

[pic]

During the month of August, there is a 20% increase in demand at each of the three cities, which can be met by purchasing electricity from another network at a premium rate of $1000 per million kwh. The network is not linked to city 3, however. The utility company wishes to determine the most economical plan for the distribution and purchase of additional energy.

(a) Formulate the problem
(b) Solve the problem using Excel Solver and determine an optimal distribution plan for the company.

Three refineries with capacities of 6, 5 and 8 million gallons respectively, supply three distribution areas with daily demands of 4, 8 and 7 million gallons respectively. Gasoline is transported to the three distribution areas through a network of pipelines. The transportation cost is 10 cents per 1000 gallons per pipeline mile. The table below gives the mileage between the refineries and the distribution areas. Refinery 1 is not connected to distribution center 3. | |Distribution center | |Refinery |1 |2 |3 | |1 |120 |180 | | |2 |300...

...The development of linearprogramming has been ranked among the most important scientific advances of the mid 20th century. Its impact since the 1950’s has been extraordinary. Today it is a standard tool used by some companies (around 56%) of even moderate size. Linearprogramming uses a mathematical model to describe the problem of concern. Linearprogramming involves the planning of activities to obtain an...

...RESEARCH PAPER ON
LINEARPROGRAMMING
Vikas Vasam
ID: 100-11-5919
Faculty: Prof. Dr Goran Trajkovski
CMP 561: Algorithm Analysis
VIRGINIA INTERNATIONAL UNIVERSITY
Introduction:
One of the section of mathematical programming is linearprogramming.
Methods and linearprogramming models are widely used in the...

... LINEARPROGRAMMING
DATE;
5 JUNE, 14
UNIVERSITY OF CENTRAL PUNJAB
INTRODUCTION TO LINEARPROGRAMMINGLinearprogramming (LP; also called linear optimization) is a method to achieve the best outcome (such as maximum profit or lowest cost) in a mathematical model whose requirements are represented by...

...LinearProgramming Concept Paper
There are two types of linearprogramming:
1. LinearProgramming- involves no more than 2 variables, linearprogramming problems can be structured to minimize costs as well as maximize profits. Due to the increasing complexity of business organizations, the role of the management executive as a decision maker is becoming more and more difficult....

...1. Discuss why and how you would use a liner programming model for a project of your choice, either from your own work or as a hypothetical situation. Be sure that you stae your situation first, before you develpp the LP model
Linearprogramming is a modeling technique that is used to help managers make logical and informed decisions. All date and input factors are known with certainty. Linear program models are developed in...

...optimal investment strategy that would allow J. D. Williams, Inc. to maximize the annual yield of an investment of $800,000 in a diversified portfolio of funds.
To find the investment that would result in the greatest annual yield we have formulated a linear program that takes into account the requirements for the client of J. D. Williams, Inc. The requirements for the investment portfolio can be found on the section titled “Problem Description”
The greatest annual yield...

...outsourcing to keep up. Currently, we outsource only coarse and medium-sized yarn, but we believe that it would be more efficient to look at outsourcing all types. There are so many potential suppliers and constraints to consider that we constructed a linearprogramming model to identify our best option and check our solution's sensitivity to changes in our situation.
We've analyzed our potential suppliers for each gauge, taking into account their capacity, cost...

...LinearProgramming Using Excel
Subject: LinearProgramming using Excel Application: Microsoft Excel 2007 Task: Solving a Linear Program Using Excel Tutorial Date: 25th February, 2010 by Nathan Smith
Install the Solver Add-In
1. In the Microsoft Office button, go to excel options to click Add-ins 2. In the Add-Ins box, select Solver Add-In and click Go...
LinearProgramming Using Excel -...

449 Words |
3 Pages

Share this Document

Let your classmates know about this document and more at StudyMode.com

## Share this Document

Let your classmates know about this document and more at StudyMode.com