SOLVE THIS USING EXCEL AND DO THE CALCULATIONS. I WILL UPVOTE IF YOU FOLLOW DIRECTIONS!!! 5

Vary the isentropic efficiency of the turbine to 0.7, 0.8, 0.9 from 1, keeping the isentropic efficiency of the pump as 1. Superheated vapor enters the turbine at 10 MPa, 480C, and the condenser pressure is 6 kPa. Put the information in the same excel table with the steam generator pressure, condenser pressure, turbine inlet temperature, isentropic efficiency of pump, isentropic efficiency of turbine and calculated (a)-(h) as columns. The cooling water used in the power plant entered the condenser at 20C and exited at 35C.

perform the following calculations:

• Work done by the turbine per kg of water
• Work consumed by the pump per kg of water
• Heat input in the steam generator per kg of water
• Heat rejected at the condenser per kg of water
• The efficiency of the power plant
• The mass flow rate of water in the cycle and the mass flow rate of cooling water assuming a 4000 MW power plant, i.e. similar to the Palo Verde Nuclear Power Plant in Arizona
• How much is the mass flow rate of cooling water compared to the residential water use of a person in US (100 gallons of water per day = 0.0044 kg/s of water use per person)?
• How much is the power produced by a 4000 MW power plant compared to the residential electricity use of a person in US (4437 kWh annually per person?