FY03
<br />
<br />CAP PCS
<br />
<br />IHA pay periods Amount billed Amount projected Amount billed Amount projected
<br />IHA hours 07/26/01 $182,967.96 $6,211.80
<br />IHA hours 07/31/02 $93,197.88 $3,873.24
<br />IHA hours 08/31/02 $238,731.48 $8,007.48
<br />IHA hours 09/30/02 $219,017.28 $6,451.92
<br />IHA hours 10/31/02 $229,957.001 $5,548.00
<br />IHA hours 11/30/02 $229,957.00 $5,548.00
<br />IHA hours 12/31/02 $229,957.00 $5,548.00
<br />IHA hours 01/31/03 $229,957.00 $5,548.00
<br />IHA hours 02/28/03 $229,957.00 $5,548.00
<br />HA hours 03/31/03 $229,957.00 $5,548.00
<br />IHA hours 04/30/03 $229,957.00 $5,548.00
<br />IHA hours 05/31/02 $229,957.00 $5,548.00
<br />IHA hours 06/30/03 $229,957.00 $5,548.00
<br />Total billed $733,914.60 $2,069,613.00 $24,544.44 $49,932.00
<br />
<br />Average $229,957.00 $5,548.00
<br />
<br />Case Mana,( ement
<br />July $35,742.48
<br />August $36,452.64
<br />September $33,335.12
<br />October $35,176.75
<br />November $35,176.75
<br />December $35,176.75
<br />January $35,176.75
<br />February $35,176.75
<br />March $35,176.75
<br />April $35,176.75
<br />.. May $35,176.75
<br />': June $35,176.75
<br /> Total $105,530.24 $316,590.72
<br />
<br />Average $35,176,75
<br />
<br />Medical Supplies
<br />July $21,481.57
<br />August $20,079.61
<br />September $20,780.59
<br />October $20,780.59
<br />November $20,780.59
<br />December $20,780.59
<br />January $20,780.59
<br />February $20,780.59
<br />March $20,780.59
<br />April $20,780.59
<br />May $20,780.59
<br />Total $41,561.18 $187,025.31
<br />
<br />Average $20,780.59
<br />
<br />Client Deductibles
<br />July $180.96
<br />August $832.68
<br />September $381.12
<br />October $464.92
<br />November $464.92
<br />December $464.92
<br />January $464.92
<br />February $464.92
<br />March $464.92
<br />April $464.92
<br />May $464.92
<br />June $464.92
<br />Total $1,394.76 $4,184.28
<br />
<br />Average $464.92
<br />
<br /> Projected revenue
<br />CAP IHA hours 2,803,527.60
<br />PCS IHA hours 74,476.44
<br />Case Mgmt 422,120.96
<br />Supplies 228,586.491
<br />Client paymt 5,579.04
<br />HCCBG revenue 103,300.00~
<br />Total 3,637,590.53
<br />
<br />
<br />
|