Question: please answer the question some instructions are provided Question 2: Mathematical programming and spreadsheet model (25 marks) An electrical utility needs to generate at least
please answer the question some instructions are provided

Question 2: Mathematical programming and spreadsheet model (25 marks) An electrical utility needs to generate at least 5000 megawatts of electricity today using five generators. If any electricity is generated by a given generator, that generator must be started up and a fixed start-up cost is incurred. There is an additional cost for each megawatt generated by a generator. These costs, as well as the maximum capacity of each generator, are shown in the table below. The electricity generated by Generator 3 must be at least 1000 megawatts greater that of Generator 2. The objective is to determine the minimum cost plan that meets the constraints. j; Generator 1 2 3 4 5 Fixed start-up cost $1000 $2000 $2500 $3000 $1500 Cost per megawatt/day generated $3 $4 $6 $5 $3 Maximum capacity (MW/day) 2500 3000 2000 1500 1600 |_ 3. Write the mathematical model. (15 marks) b. Solve it using Excel solver. (10 marks) ins truction: To write a mathematical model, you need to do the followings: Define the decision variables and parameters (if they are shown by math symbols). %20 Write the objective function and constraints. The objective function and constraints in the mathematical model should be numbered. 9660 Explain each line of the mathematical model after the model by referring to its number. %20 To Solve a mathematical model using Excel solver, the following parts should be done: Report each formula you have used in a cell of your spreadsheet model together with its address. For example, G8=SUMPRODUCT!C8:F8,C11:F11). 9620 - Report a screenshot of your spreadsheet model that has been solved and the optimal solution can be seen in it. Use meaningful labels in your spreadsheet model. %60 - Report the screenshot ofthe solver window that has been filled out completely. %20
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
