Answered step by step
Verified Expert Solution
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
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+x2375Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started