Use Excel please.

2) A problem faced by an electrical utility each day is that of deciding which generators to start up. The utility in question has three generators with the following characteristics: Cost per Generator Fixed cost Fixed start per period up cost of operation period per megawatt used Maximum capacity in megawatts each period A 30000 5 2100 700 800 B 20000 4 1800 50000 900 3 3000 There are 2 periods in a day and the number of megawatts needed in the first period is 2900. The second period requires 3900 megawatts. A generator started in the first period may be used in the second period without incurring an additional startup cost. All major generators, e.g., A, B, and C above are turned off at the end of each day. a) First assume that fixed costs are zero, and thus can be disregarded. What are the decision variables? b) Give the LP formulation for the problem where fixed costs are zero, and provide the total cost of the solution, c) Now take into account the fixed costs, what are the additional (binary) variables to define? d) What additional terms should be added to the objective function? What additional constraints should be added? e) Solve your formulation of d) above to determine what generators should be used for the 2 periods, and their corresponding total cost