Excel Data is:

	A	B	C	D	E
Fixed Startup Cost	$3,000	$2,000	$2,500	$1,500	$1,000
Cost per Megawatt-hour	$5	$4	$6	$6	$7
Maximum Capacity (MW-hr)	2100	1800	2500	1500	3000

An electrical utility needs to generate 6,500 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 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 "0" wherever required. b. Determine the total cost. An electrical utility needs to generate 6,500 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 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 "0" wherever required. b. Determine the total cost