tes An electrical utility needs to generate 6,300 megawatts of electricity today. It has five generators...

Transcribed Image Text:

tes An electrical utility needs to generate 6,300 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. A B Fixed start-up cost $3,000 $2,000 Cost per megawatt/day C $2,500 D E $1,500 $1,000 generated $5 $4 * $6 $6 $7 Maximum capacity (MW/day 2,100 1,800 2,500 1,500 3,000 Click here for the Excel Data File 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 "O" wherever required. Startup generator? (Enter 1 if "Yes", 0 if "No") Megawatt/day b. Determine the total cost. Total cost tes An electrical utility needs to generate 6,300 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. A B Fixed start-up cost $3,000 $2,000 Cost per megawatt/day C $2,500 D E $1,500 $1,000 generated $5 $4 * $6 $6 $7 Maximum capacity (MW/day 2,100 1,800 2,500 1,500 3,000 Click here for the Excel Data File 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 "O" wherever required. Startup generator? (Enter 1 if "Yes", 0 if "No") Megawatt/day b. Determine the total cost. Total cost