Question: 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

I started the problem, just need help with the additional negotiations part

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

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!