Question: _(formulate the problem and find optimal solution) using modeling techniques and using EXCEL SOLVER or LINGO please. A local power company is considering increasing its

_(formulate the problem and find optimal

_(formulate the problem and find optimal solution) using modeling techniques and using EXCEL SOLVER or LINGO please. A local power company is considering increasing its generating capacity to meet expected demand over the next 5 years. Currently, the company has a generating capacity of 600 MW. As per the demand forecast, the minimum generating capacities required over the next 5 years are as follows: Year 1 2 3 4 5 Minimum capacity (MW) 670 760 890 1020 1180 The company can increase its transmission capacity by purchasing five different types of generators: 20, 50, 80, 100, and 120 MW. The costs of acquiring, installing, and operating each of the five types of generators are summarized below: Acquiring and Installation Cost/Unit Generator Type (MW) Operating Cost/Unit/Year 20 50 80 100 120 5.0 10.0 13.0 17.0 22.0 2.0 4.0 6.0 8.0 10.0 In million dollars. Any number of generators (of any type) can be added in any year. However, once a generator is added, it must be operated in the future years as required. Formulate a mathematical programming model to determine the least cost expansion plan, for 5 years, while fulfilling all yearly demand

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!