Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1) BC hydro supplies electricity to households in Vancouver, Coquitlam and Burnaby. The company buys electricity from two dams, the Capilano dam and the Coquitlam
1) BC hydro supplies electricity to households in Vancouver, Coquitlam and Burnaby. The company buys electricity from two dams, the Capilano dam and the Coquitlam dam. Their demand forecasts for the winter 2022 are as follows: Surrey 750 units, Burnaby 470 units and Vancouver 880 units. BC Hydro has contracts with the two dams to provide the necessary units as well. Capilano is to provide 950 units and Coquitlam is to provide 1300 units. Distribution costs (in thousand dollars) are as follows: To From Surrey Burnaby Vancouver Capilano 15 12 10 Coquitlam 8 8 15 a) Develop a network representation of the problem (diagram). (2 marks) b) Determine the objective function and the constraints. (4 marks) c) Find the optimal solution to this problem. (7 marks) Note that you need to submit your excel document to get credit for this part. d) Recent increases in the population of Surrey might cause an increase in demand of their electricity in the winter by 200 units (950 units needed instead of 750). Considering the extra demand, how many units should be sent to each city from each of the dams? (7 marks) Note that you need to submit your excel document to get credit for this part
Step 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