Reference no: EM13711469
I've been trying to explain this Managerial Decision Making problem.
Problem- 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
Part 1- Formulate a mathematical programming model to determine the least costly way of expanding the companies generating assets to the minimum required levels.
Part 2- Implement your model in a spreadsheet and solve it.
Part 3- What is the optimal solution?
You need to explain Managerial Decision Making problem.
|
Determine the heat transfer for both cases
: Liquid propanol at 250C is burned with air at the same temperature in an atmospheric pressure combustor operating at steady conditions. Products of combustion are cooled to a temperature of 250C. Enthalpy of formation of liquid propanol = -301,000 kJ..
|
|
Explain about research study: primary & secondary research
: When conducting a Research Study, what are the advantages and disadvantages when using Face-to-Face interview as Primary Research method.
|
|
Explain the usefulness of lp
: The production manager of a large Cincinnati manufacturing firm once made the statement, "I would like to use LP, but it's a technique that operates under conditions of certainty.
|
|
The stock brokerage firm
: The stock brokerage firm of Blank, Leibowitz, and Weinberger has analyzed and recommended two stocks to an investors' club of college professors.
|
|
Explain this managerial decision making problem
: Formulate a mathematical programming model to determine the least costly way of expanding the companies generating assets to the minimum required levels.
|
|
Explain the usefulness of lp
: The production manager of a large Cincinnati manufacturing firm once made the statement, "I would like to use LP, but it's a technique that operates under conditions of certainty.
|
|
Difference between objective function and constraints
: Under what circumstances is the objective function more important than the constraints in a linear programming model.
|
|
Describe the linear programming concepts
: What does the shadow price reflect in a maximization problem? Explain. How do the graphical and computer-based methods of solving LP problems differ.
|
|
Explanation about quantitative analysis
: What is the relationship between decision variables and the objective function. What is the difference between an objective function and a constraint.
|