Case Study 2 Ecotricity: An Optimal Investment Decision for Electric Highway Expansion

You are required to formulate Ecotricitys highway network expansion problem as an integer

programming model and find the optimal solution within a budget of 600,000.

a) Compete the formulas for the table that is used to calculate the parameters for the IP

model.

b) Prepare the IP model and find the optimal solution. Make sure you design a good

spreadsheet model (layout, color coding and all the other spreadsheet design principles

we have been using in the course).

According to this question and the picture I send to you can you solve step by step with excel formulas and determine each step clear.