An electrical utility needs to generate $6,700$ megawatts of electricity today. It has five generators $($A$,$ B$,$ C$,$ D$,$ and E$).$ 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 following

table.

Click here for the Excel Data Flle

Formulate and solve this model on a spreadsheet.

a$.$ Determine the minimum cost plan that meets the electrical needs for today.

Note: Leave no cells blank. Enter $"0"$ wherever requlred.

b$.$ Determine the total cost.

Total cost