Integer Linear Programming

written by - Comments off

I’ve been trying to figure out this Managerial Decision Making problem. Please help me out. Thank you!

A power company is considering how to increase its generating capacity to meet expected demand in its growing service area. Currently, the company has 750 megawatts (MW) of generating capacity but projects it will need the following minimum generating capacities in each of the next five years:

Year
_________________________________
1 2 3 4 5
______________________________________________________
Minimum Capacity 780 860 950 1,060 1,180
In Megawatts (MW)

The company can increase its generating capacity by purchasing four different types of generators: 10 MW, 25 MW, 50 MW, and/or 100 MW. The cost of acquiring and installing each of the four types of generators in each of the next five years is summarized in the following table:

Cost of Generators (in $1,000s) in Year
_____________________________________________

Generator Size 1 2 3 4 5 _______________________________________________________________

10 MW $300 $250 $200 $170 $145

25 MW $460 $375 $350 $280 $235

50 MW $670 $558 $465 $380 $320

100 MW $950 $790 $670 $550 $460

a. Formulate a mathematical programming model to determine the least costly way of expanding the companyâ??s generating assets to the minimum required levels.
b. Implement your model in a spreadsheet and solve it.
c. What is the optimal solution?

 

Note: Currently, Regular Priority times are 3-5 days. Log in to upload files with your questions. Tutorials you buy shall be emailed to your PAYPAL email. Talking about quality references: finding and referencing an (n+1)th article for your tutorial requires substantially more time than the (n)th article referenced, therefore you will see the price increasing with the number of references you require in some questions. Wanted to contact us over something related to this question? Email us: support AT oxenmine.com.

© 2010 oxenMINE.com: Customized Homework help. - Powered by OM