Use EXCEL and show all Equations and formulas used.

Construct IPR of a well in a vertical well in an unsaturated oil reservoir using generalized Vogel's equation. The following data are given: Reservoir pressure, p=5,000 psia Bubble pressure pb=3,000 psia Porosity, =25% Effective horizontal permeability, k=0.1 Darcy Pay zone thickness, h=50ft Fluid formation volume factor, Bo=1.24 Fluid viscosity, o=2.9cp Total compressibility, ct=0.000013psi1 Drainage area, A=600 acres Wellbore rw=10 in Skin factor, S=5.0