Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I started the problem, just need help with the additional negotiations part to solve for a and b 3. Bulldog Energy has been awarded $500M

I started the problem, just need help with the additional negotiations part to solve for a and b

image text in transcribed 3. Bulldog Energy has been awarded $500M to supply solar and wind energy to three regions of the country. Any remaining funds will be donated to General Determination. The following basic information is known: Pegion 3 - Each solar farm costs $3m, requires 1 acre of land, and produces 1MW,2MW, and 4MW in regions 1, 2, 3 respectively. resion 123 - Each wind turbine costs $2m, requires 2 acre of land, and produces 2MW,5MW, and 3 MW in regions 1,2, 3 respectively. - Region 1 requires 150MW and has 150 available acres. - Region 2 requires 100MW and has 500 available acres. - Region 3 requires 300MW and has 100 available acres. - Current workforce can install 125 solar farms and 75 wind turbines. Additional negotiations have led to a few additional considerations. - If a solar farm and wind turbine are installed on the same site, the cost is reduced to $4.5M and the land usage is reduced to $2.5 acres. - A special one-time usage permit is required: $5M for a solar farm and $10M for a wind farm. If both are installed, the fee is reduced to $13.5M. - Solar farms are linked together and there is an efficiency loss of 0.25% for each additional solar farm. For example, the 1 st farm produces 100%, the 2 nd farm produces 99.75%, and so on. In order to make General Determination as happy as possible: a. (10 points) Write the mathematical formulation, clearly identifying decision variables, the objective function, and all constraints. Note: All If-Then constraints must be resolved! b. Bonus: Solve the problem using Excel Solver. xij=#ofinstallsi@regionji=1,2j=1,2,3Mincost=3(x11+x12+x13)+2(2min)(x21+x22+x23)Acres2150x11+x12+x1312522500x21+x22+x237523100 Power requirments x11+2x21150 2x12+5x22100 4x13+3x23300 Available Acres x11+2x21150 x12+2x22500 x13+2x23100 x11+x12+x13125 x21+x22+x2375

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cases In Communications Law

Authors: Michael T Simpson, John Zelezny

6th Edition

1111791910, 9781111791919

More Books

Students also viewed these General Management questions

Question

Which of the following is the highest peak of South America?

Answered: 1 week ago

Question

Highest active volcano of the south america ?

Answered: 1 week ago

Question

Where would you see the nodes of ranvier ?

Answered: 1 week ago

Question

Damage to the hippocampus is the most likely to impair ?

Answered: 1 week ago

Question

The terminal buttons of a neuron are located at the end of its ?

Answered: 1 week ago