Use EXCEL and show all Equations and formulas used.

Construct IPR of a vertical well in a saturated oil reservoir using Vogel's equation. The following data are given: Porosity, =0.2 Effective horizontal permeability, k=80md Pay zone thickness, h=55ft Reservoir pressure, p=4,500 psia Bubble point pressure, pb=4,500psia Fluid formation volume factor, Bo=1.1 Fluid viscosity, o=1.8cp Total compressibility, ct=0.000013psi1 Drainage area, A=640 acres (re=2,980ft) Wellbore radius, rw=0.328ft Skin factor, S=2