Assume that the reactor pressure decreases in pressure to 50% of the original value. Calculate the change in flow and motor horsepower for each 5% of pressure decrease.

Develop a computer model using an appropriate software program (e.g. Excel, Access, Numbers, etc.) to model the pump affinity laws for the system you were assigned in Module 2. Use attached documents. The model only needs to model the pump.

Based on the model, calculate the impact of the following changes in the system.

Assume that the reactor pressure decreases in pressure to 50% of the original value. Calculate the change in flow and motor horsepower for each 5% of pressure decrease. (Hint: The classic centrifugal pumps laws do not work. An electrically driven pump with an induction motor will run at constant speed and its flow and power requirement will both increase as back pressure the pump decreases. Pump speed remains constant.)
Assume that the pump has a variable speed drive. Calculate a flow and horsepower for increases in pump speed in 2% increments up to an 10% increase. Reactor pressure remains constant.
Assume that a discharge valve is slowly closed. Calculate flow and horsepower for flow decreases of 5% to a total reduction of 25%.
Provide a report that includes the following

raw data and graphs of each of the data sets above.
An assessment of the impact to the system of the changes evaluated.
An assessment of the strength and weakness of the developed model in addressing the actual impact of the changes of the fluid system as a whole.
A discussion of why the computer program used was appropriate for the application.