2. The state of NJ has three major power companies (A, B, and C). During the months of peak demand, NJ Power Authority authorizes these companies to pool their excess supply and to distribute it to smaller independent power companies that do not have generators large enough to handle the demand. Excess supply is distributed on the basis of cost per kilowatt hour transmitted. The following table shows the demand and excess supply in million of kilowatt hours and the cost per kilowatt hour of transmitting electric power to four small companies, W, X, Y, and Z: To From W X Y Z Excess Supply A $0.12 $0.03 $0.08 $0.05 55 B $0.02 $0.05 $0.05 $0.07 60 C $0.08 $0.11 $0.03 $0.06 35 Demand 35 40 25 50 a) Develop a network representation of this problem. b) Formulate a linear programming model for this problem. (Write the complete model for the problem. Make sure to give clear definitions of your decision variables). c) Solve the problem by using Excel Solver (Hand-in the one-page value and one-page formulas printouts for the problem).
Network Representation:
LPP Formulation:
Let,
Ci = cost per kilowatt hour transmitted from plant i to small companies j
Decision Variable:
Xij be the kilowatt hour to be transmitted from power plants i to small Companiesy j,
Where,
i = a, b, and c for A, B, and C respectively
j = 1,2,3,4 for W, X, Y, and Z respectively
Objective Function:
Objective is to minimize the total production and transportation cost:
Min. Z = (Cij x Xij)
Min. Z = $0.12Xaw + $0.03Xax + $0.08Xay + $0.05Xaz + $0.02Xbw + $0.05Xbx + $0.05Xby + $0.07Xbz
+ $0.08Xcw + $0.11Xcx + $0.03Xcy + $0.06Xcz
Subject to:
Supply Constraint:
Power Plant A: Xaw + Xax + Xay + Xaz <= 55
Power Plant B: Xbw + Xbx + Xby + Xbz <= 60
Power Plant C: Xcw + Xcx + Xcy + Xcz <= 35
Demand constraint:
Small Company W: Xaw + Xbw + Xcw = 35
Small Company X: Xax + Xbx + Xcx = 40
Small Company Y: Xay + Xby + Xcy = 25
Small Company Z: Xaz + Xbz + Xcz = 50
Nonnegative Constraint: Xij>= 0
Excel Formulation:
Get Answers For Free
Most questions answered within 1 hours.