Document rBM99Xj8V98B7YvrGX4a5Bvee
Benzene Health Research Consortium 1005 Financial Report Overview
Case Diagnosis: JCML clinical lab continues to increase diagnostic throughput, operating well above 100% capacity, processing 30% more case
Case Accrual: Cases are being accrued at optimal rate from all participating hospitals, with 500+ AML and 400+ NHL anticipated by end of stud~ External Review Panels: Panels reviewing progress reports, manuscripts and presentations as these documents become available.
Fund Balance at API 4Q04:
$3,672, 1331
Irons Field Expenses: New T&E contract executed in 4004; $131 K disbursed in 1005.
UCHSC: Contract amendment executed with UCHSC; $874,030 additional was disbursed 4004, for a total $2.62MM disbursed in 2004. Increase
Subcontracts: 4004 subcontractor expenses include Fudan Univ ($880K) and Children's Hosp ($68K); no additional '04 EMBSI charges, front-I(
AHS: Travel expenses have stayed under budget, but high labor costs due to time spent in Shanghai have now put AHS $46K (3%) over budget.
Fudan University: Additional case load, and transfer of CDC & IPHS activities has increased rate of expenditure; sufficient funds were not budg
SRP/ERP: Total expenses remain under budget as of year end 2004. Consortium should consider unanticipated additional expenses in out-year
Communications (APCO): program budget reduced to $300K ($250K to contingency)
Outside Legal Council: cummulative variance of 28% over budget
QAlQC: program budget reduced to $50K ($50K to contgency)
Contingency: increased by $300K ($250K from communicaitons; $50K from OA/OC).
API Administrative Costs: 0.5 % over budget
(J)
I
m
SRP/ERP projected expenses need to be re-analyzed to reflect new meeting venue and possibly reduced number of meetings (3 to 2).
r
s:r I
UCHSC grant requires close monitoring due to large 2004 expenses and new case-based cost structure
() Fudan University: contract at Fudan for signature
()
r
C
;a
API administrative expenses requires close monitoring to contain costs. Projected expenses for 2005 will require a substantial decrease in API st.
G)
oI
(J)
Page 1 of 60
AUTO DATE
I'V
cI'.V.n
I'V
~s than anticipated with 99+% concordance {. As of 4Q04, 687 confirmed cases were
Benzene Health Research Consortium 1Q05 Financial Report Overview
~d spending rate & total expenditures reflect oaded for the year. . [Jan/Feb expenses annualize to $19K (5%) Jeted for travel to annual meetings (-1 OK/yr). S, if expert panels are to be
(J)
I
m
r r
sI :
() ()
r C aft time. Budget projections were based on
;a
G)
oI
(J)
I'V I'V
c..n
c..>
Page 2 of 60
AUTO DATE
Benzene Health Research Consortium 1005 Financial Report Overview
Need to reconcile UCHSC statement - they have a $105 error (from 4003 rpt).
Technical Budget Work Group Acceptance: 4/29/05 Oversight Committee Acceptance: Posted to Website:
LT 4/24/05 BJ 4/05/05
~~'?::1:'~"~
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
Page 3 of 60
AUTODATE
I'V
cI'.V.n
..j:::o.
E
.~
s:
to:
(J)
.Q2-:)
oC Q>)
0
o2coC
t: 0
Cl..
Q) Q)
~a:
-a: "(0
oC .-co (cC.o)
Q) C
I L-L
C oQ)L() ~a
c..-
Q)
III
llJ f-
ooe:(
f::J
e:(
o
"'"0 "Q)
n'O".J
SH ELL-MCCLU RG-062255
Item AHScienc es CaseControl Study DP&ME Studies (UCHSC) Irons(T & E) Fudan University
Total Research Costs Scientific Review Panel Ethics Review Panel
Benzene Health Research Consortium
Approved Program Budget
Approved Original Cost Revised Cost
1005 Financial R- .........
Unapproved
Approved
Changes not
Approved
Approved
Estimate
Estimate approved (June 11 NOV 03 OC 21 APR 04 OC 16 Dec 04 OC
(Jan. 2001) (Dec. 2001)
2003)
mtg
mtg mtg
$1,595,000 $2,283,095
$2,283,095
$2,283,095
$2,283,095 $2,283,095
$13,665,017 $15,258,017
$1,253,428 $1,253,428
$165,700
$190,555
$16,679,145 $18,985,095
$15,258,000
$1,597,273
$661,000 $19,799,368
$14,508,000
$1,413,428
$230,000 $18,434,523
$14,508,000 $14,508,000
$1,413,428 $1,413,428
$230,000
$230,000
$18,434,523 $18,434,523
$648,000
$551,736
$300,000
$300,000
$300,000
$216,000
$192,000
$64,000
$64,000
$64,000
External
Pathology
&
Cytogenet
ics
Workgrou
(J) ps(Cost in
I UC cost)
m
r
Total Panel Costs
r API Seed
s:I Monies
() Outside
()
r
Counsel
C
;a
G)
oI
(J)
I'V
cI'.V.n
(J)
$450,000 $500,000
$130,000 $994,000
$0
$500,000
$0 $743,736
$0
$100,576
$0 $364,000
$0
$100,000
$0 $364,000
$0
$100,000
$0 $364,000
$0
$100,000
Page 5 of 60
AUTO DATE
Public Affairs QAlQC Activities UCHSC Interest contingency
Miscellaneous Costs Subtotal API Admin. GRAND TOTAL
Benzene Health Research Consortium Approved Program Budget 1Q05 Financial Report
$1,000,000 $1,000,000
$960,600
$550,000
$550,000
$300,000
$225,000
$190,855 $1,690,855 $18,820,000
$941,000
$0 $1,725,000 $21,704,095 $1,085,205
$100,000
$0 $1,161,176 $21,704,280 $1,085,019
$100,000 ($100,000)
$390,272 $1,040,272 $19,838,795 $1,245,205
$100,000 $0
$290,272 $1,040,272 $19,838,795 $1,245,205
$50,000 $0
$590,272 $1,040,272 $19,838,795 $1,245,205
$19,761,000 $22,789,300
$22,789,299 $21,084,000 $21,084,000 $21,084,000
Notes by API
Notes/As sumption s for Dec. 2001 revised budget:
- The total research costs have changed as a result of - Panel costs assume that there will be only one face-to-
face meeting for each panel each year.
LT 4/24/05
:;;:~~:$'~::'~
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J) Page 6 of 60
I'V
cI'.V.n
-.....J
AUTO DATE
Benzene Health Research Consortium Executive Summary 1Q05 Financial Report
Cost Centers Income
Project #
Inception Thru
December 2004
Actuals
Actuals Jan - Mar
2005
$ 16,765,693 $ 1,096,000
$ 17,861,693
Cost Centers
UCHSC* Irons-Field Expense* Applied Health Sciences Fudan University
X8105 X8106 X8107 X8108
Scientific & Ethics Panels Communications Outside Legal Counsel QAlQC Support API Administrative Contingency**
X8109 X8103 X8104 X8110 X8100
Total Expenses
Fund Balance
10,137,850 788,486
1,391,014 124,090
166,772 294,161
64,529
131,000 70,316
4,827
871,150 104,473
37,396 3,496
$ 13,942,525 $ 247,035
$ 2,823,169 $ 848,965
10,137,850 919,486
1,461,330 124,090
166,772 294,161
69,356
908,546 107,969
$ 14,189,560
$~'B?g~12~m
Cumulative Actuals
Inception Thru 1Q05
Budget (actual + projected income
2005
2006
$ 17,861,693
$ 1,826,667 ***
$1,278,667
10,137,850 919,486
1,461,330 124,090
166,772 294,161
69,356
908,546 107,969
$ 14,189,560
1,748,060 131,000 331,400 21,861
1,748,060 262,000 449,985 29,148
74,500 1,946
12,524 12,500 93,980 162,933
71,000 1,946 16,698 16,667 123,200 162,933
$ 2,590,704 $ 2,881,637
:::::$:::::~mml;mm::::::: :::::::::r::r::~n:~.ng::::::::::::::
(J)
I
::~!:9@:::!!::~MqJ.~~:::~:9Q~:::!I!~QGI!:::~g::::::::::::iii::::::
m * amount disbursed by API
r
r
s:I ** $300K added to contingency;
() $250K from Communicaitons & $50K
() from QAlQC r
C
;a
G)
oI
(J)
I'V
cI'.V.n ex>
Page 7 of 60
AUTO DATE
& expenses)
2007 $1,278,667
Projected Expenses
Program Budget
I I$ 22,245,694 $ 21,084,000
Benzene Health Research Consortium Executive Summary
1005 Financial Report
874,030 104,714
45,833 29,148
14,508,000 1,417,200 2,288,549 204,247
14,508,000 1,413,428 2,283,095 230,000
44,000 1,946 16,698 16,667 123,200 159,933
$1,416,169
356,272 300,000 115,276 45,833 1,248,926 593,768
364,000 300,000 100,000 50,000 1,245,205 590,272
I I$ 21,078,070 $ 21,084,000
::::::::::::",n:IZ;I.II:
(J)
I
m
r r
Income
s:I Detail
()
sponsors
$17,596,000
()
2001 seed
$15,000
r
C
;a
G)
oI
(J)
I'V
cI'.V.n
<D
Page 8 of 60
AUTODATE
*** ConocoPhillips pay remaining commitment in 2005
LT 4/24/05
Benzene Health Research Consortium Executive Summary
1005 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
Page 9 of 60
AUTODATE
I'V I'V
(J)
o
MAP contrib. API interest UCHSC interest
TOTAL
$200,000 $50,692
$0
$17,861,692
Benzene Health Research Consortium Executive Summary
1005 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
Page 10 of 60
AUTO DATE
I'V I'V
(J)
.....lo.
Benzene Health Research Consortium Case Accrual 1005
(+) Variance: above predicte rate of accrual, (-) Variance: below predicted rate of accrual. Gase predictions based on historical estimates; these are not target numbers of cases required for study completion.
LT 8/30104 BJ 4/05/05
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V I'V
(J)
I'V
AUTODATE
E
:::J
1o::
c(J) oL() 00
.2.c..O-
ffiro
(J) :::J Q) .....
a: 8
..c
~co
Q)
Q)
(cJo)
IO
Q)
c
Q) N
C
Q)
III
o
1w~--Io--' tnl-
W
llJ
oof-
f-
::J
SH ELL-MCCLU RG-062263
Benzene Health Research Consortium Cash Flow Statement 1005 Financial Report
:f!gM,e~r~!iM!WM~~:rrrr
}r.@!c!j'.::%!'!'W'<l.l.~!,!::::::::::::::::::'
LT 10/18/04 RT 04/13/05
NOTE,! $$,OQ$,7$41;n bank at API ~~~~.~~
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
13 of 60
AUTODATE
I'V
I'V
(J)
..j:::o.
Benzene Health Research Consortium Cash Flow Statement 1005 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
14 of 60
AUTODATE
I'V
I'V
(J)
c..n
Cost Centers
Benzene Health Research Consortium Program Expense Summary 1Q05 Financial Report
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V I'V
(J) (J)
Benzene Health Research Consortium Program Expense Summary 1Q05 Financial Report
r-------------~------~------------~~------------~,--~~~~,
Cost Centers
(J)
I
m
rr,
s:
()
()
r
C
;a
G,)
o
(J)
I'V
I'V
(J)
Page 16 of 60
AUTODATE
-.....J
Benzene Health Research Consortium Program Expense Summary 1Q05 Financial Report
LT 4/24/05 RT 04/13/05
-
Amt.At UCHSC & Irons Field exp. Bank acct
$12,603,965 $11,400,949
expense reporting for $1,175,224 3004)
$27,044 In Irons' field exp bank acct as of 6/30104 (3004 exp report outstanding)
$1,203,016
Total as of $1 ,202,268 6/30104
API disbursed by period (includes pre-payments
for UCHSC & Irons Field)
24,600
1,577,811 7,652,678
318,759
258,097
310,244
66,019 1,348,626 1,047,131 1,338,560
378,035
874,030
131,000
874,030
131,000
874,030
131,000
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
I'V
(J)
Page 17 of 60
AUTODATE
ex>
Benzene Health Research Consortium Program Expense Summary 1Q05 Financial Report
r-------------~------~------------~~------------~,--~~~~,
Cost Centers
LT 4/24/05
RT 04/13/05
API disbursed by period
874,030
104,714
874,030
IT
IT 19,032,824
(includes pre-payments
for UCHSC & Irons Field)
(J)
I
m
rr, s:
()
()
r
C
;a
G,)
o
(J)
I'V
I'V
(J)
Page 18 of 60
<D
AUTODATE
Benzene Health Research Consortium UCHSC Grant 1Q05 Financial Report
(J)
I
m
r UCHSC r statement
s:I error for travel, off by +$105
() (4Q03)
()
r
C
;a
G)
oI
(J)
I'V I'V
Page 19 of 60
AUTODATE
-.....J
o
Benzene Health Research Consortium UCHSC Grant 1Q05 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V I'V
Page 20 of 60
AUTODATE
-.....J
.....lo.
Cost Centers
LT 3/11/05
BJ 4/05/05
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V I'V -.....J I'V
Am!. paid UCHSCto date:
Am!. expensed to date: Am!. In UCHSC bank acct:
Benzene Health Research Consortium UCHSC Grant 1Q05 Financial Report
3rd Otr.
4th Otr.
lstOtr.
2nd Otr.
3rd Otr.
4th Otr.
(Adjusted 4003: $48,839 attributed to UCHSC in 3003 Report has been reallocated to Contingency: $25,000 preconsortium gran tin 2001; $3,600 for IRB Review in 2002; $20,239 for EMBSI "feasibility $9,263,820 study" in 2002)
(Adjusted 4003: 2001 costs had been double expensed in 2002 column; ($523,807) adjusment $8,088,596 made in 4003)
$1,175,224
Page 21 of 60
3rd Otr.
4th Otr.
AUTODATE
UCHSC (x81 05) Cost Centers
Benzene Health Research Consortium UCHSC Grant 1Q05 Financial Report
2006
2nd Olr.
3r.d Olr.
4lh Olr.
2007
2nd Olr.
3r.d Olr.
4lh Olr.
LT 3/11/05
BJ 4/05/05
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V I'V -.....J c..>
Page 22 of 60
AUTODATE
Benzene Health Research Consortium UCHSC Subcontract 1005 Financial Report
LT4/24/05 BJ 4/05/05
"Total subcontracto r expenses" from study report (preliminary figure); "actual expenses" from UC Office of Grants & Contracts spreadsheet (final figures).
~~;: -':: ~'~
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V I'V -.....J
..j:::o.
Page 23 of 60
AUTODATE
Cost Centers
1st & 2nd
Benzene Health Research Consortium Irons Field Expenses 1Q05 Financial Report
4Q03 ADJUSTME NT2001/2002 expense underrecord ed; -0$114,289 adjustment
(J)
I
m
r r
sI :
()
()
r Amt paid to
C Irons to
numbers as
;a date
$788,486 of 12131/04
Amt Irons
G) has spent
$761,442
oI
(J)
I'V I'V Page 24 of 60
c-......n.J
AUTODATE
Cost Centers
2nd Olr.
3r.d Olr.
4lh Olr.
Benzene Health Research Consortium Irons Field Expenses 1Q05 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V I'V
Page 25 of 60
AUTODATE
-.....J
(J)
LT 2114/05 BJ 4/05/05
Amt. In Irons bank acct:
$27,044
Benzene Health Research Consortium Irons Field Expenses 1Q05 Financial Report
15tOtr. 2nd Otr.
3rd Otr.
4th Otr.
3rd Otr.
4th Otr.
15tOtr.
2nd Otr.
3rd Otr.
4th Otr.
15tOtr.
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V I'V
Page 26 of 60
AUTODATE
-.....J
-.....J
IRONS T&E (X81 06) Cost Centers
LT 2114/05 BJ 4/05/05
2007
2nd OIL
3rd OIL
4lh OIL
Benzene Health Research Consortium Irons Field Expenses 1Q05 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V I'V
Page 27 of 60
AUTODATE
-.....J
ex>
Cost Centers
1st & 2nd
Benzene Health Research Consortium AHS 1Q05 Financial Report
LT 4/24/05 BJ 4/05/05
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V I'V -.....J <D
~~~:;:'\1'''
Adjustment: expense reduced by $52,634; transferred to contingency since these were preconsortia expenses
Page 28 of 60
AUTODATE
Cost Centers
2nd Ole.
3rd Ole.
4lh Ole.
Benzene Health Research Consortium AHS 1Q05 Financial Report
LT 4/24/05 BJ 4/05/05
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V I'V
ex> o
Page 29 of 60
AUTODATE
Benzene Health Research Consortium Fudan 1Q05 Financial Report
LET 4/24/05 BJ 4/05/05
t&:~~:;:,~..
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V I'V
ex>
.....lo.
Page 30 of 60
AUTODATE
Benzene Health Research Consortium Fudan 1Q05 Financial Report
LET 4/24/05 BJ 4/05/05
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V I'V
ex>
I'V
Page 31 of 60
AUTODATE
Benzene Health Research Consortium
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V I'V
ex> c..>
Benzene Health Research Consortium SRP + ERP 1005 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
I'V
ex>
Page 33 of 60
AUTODATE
..j:::o.
2003
Benzene Health Research Consortium
2004
2005
2006
2007
LT 4/24/05
BJ 4/05/05
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V I'V
ex> c..n
1Q04 budget ajustments to variance to develop more useful budget projections for remainder of program Change approved by OC at 4/21/04 meeting
Page 34 of 60
AUTODATE
Benzene Health Research Consortium SRP + ERP 1005 Financial Report
LT 4/24/05
BJ 4/05/05
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V I'V
ex>
(J)
Page 35 of 60
AUTODATE
Cost Centers
Benzene Health Research Consortium
Communications 1aos Financial Report
(J)
I
m
r r
s:I Duplicating/Copies Internal, Postage, Couriers,
( ) Telephone, Meals, Lexis Nexis Searches
. . . . .( ) J'llm!lm~Wt:~mW1llWAA~~W9'l:mm:mrmmmr!ii.:::r::::::::::::::::::::::::.:.:
r .mrW:!il~:~m%ff.t:::::::::::::::::::::::::.:.: .............................
C ~ - I::ludget adJustrnent retlects budget reduction
;a frorn $1 MM to $550k
G)
oI LT 4/25/05
(J) RT 1/21/05
I'V I'V
ex> -.....J
*budget adjustrnent to lower prograrn budget frorn $550K to
Page 36 of 60
AUTODATE
Cost Centers
Benzene Health Research Consortium
Communications 1aos Financial Report
(J)
I
m
r r
s:I Duplicating/Copies Internal, Postage, Couriers,
( ) Telephone, Meals, Lexis Nexis Searches () J'lm~FWWt:~mW1llWAA~~W9fmm:mnmWmr!ii.::)
r .mrW:!il~:~m%ff.t:::::::::::::::::::::::::.:.: .............................
C ~ - I::ludget adJustrnent retlects budget reduction
;a frorn $1 MM to $550k
G)
oI LT 4/25/05
(J) RT 1/21/05
I'V I'V
ex> ex>
Page 37 of 60
AUTODATE
Benzene Health Research Consortium
Communications 1aos Financial Report
1sl Olr. 2nd Olr. 3rd Olr. 4lh Olr*.
4lh Olr. 1s101r.
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V I'V
Page 38 of 60
AUTODATE
ex>
<D
Benzene Health Research Consortium
Communications 1aos Financial Report
4lh Olr. 2 I 1sl Olr. 2nd Olr. 3rd Olr. 4lh Olr.
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V I'V
Page 39 of 60
AUTODATE
<D
o
Benzene Health Research Consortium Legal 1005 Financial Report
* budget adjustment to lower program budget from $500K to $1 OOK, as approved by OC on 11 III 103
LT 4/25/05 RT 04/13/05
~~~~\~~
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V I'V
Page 40 of 60
AUTODATE
<D
....lo.
* budget adjustment to lower program budget from $500K to $1 OOK, as approved by OC on 11 III 103
LT 4/25/05 RT 04/13/05
Benzene Health Research Consortium Legal 1005 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V I'V
Page 41 of 60
AUTODATE
<D
I'V
Benzene Health Research Consortium QA-QC 1QOS Financial Report
(J)
I
m
r r
sI :
() ()
r budget adjustment to lower
C program budget from $225K to
; a $100K, as approved by OC on
G) 11/11/03
oI
(J)
I'V I'V <D c..>
Page 42 of 60
AUTODATE
Benzene Health Research Consortium QA-QC 1QOS Financial Report
(J)
I
m
r r
sI :
() ()
r budget adjustment to lower
C program budget from $225K to
; a $100K, as approved by OC on
G) 11/11/03
oI
(J)
I'V I'V <D
..j:::o.
Page 43 of 60
AUTODATE
Benzene Health Research Consortium QA-QC 1QOS Financial Report
1sl Olr. 2nd Olr. 3rd Olr. 4lh Olr** .
4lh Olr. I 1sl Olr. 2nd Olr. 3rd Olr. 4lh Olr. I 1sl Olr.
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V I'V
Page 44 of 60
AUTODATE
<D
c..n
LT 4/25/05
2007 2nd Olr. 3rd Olr. 4lh Olr.
Benzene Health Research Consortium QA-QC 1QOS Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V I'V
Page 45 of 60
AUTODATE
<D
(J)
Cost Centers
Benzene Health Research Consortium API Administration 1Q05 Financial Report
(J)
I
m
r r
sI :
()
( ) LT 4/24/05
r
C
RT 04/13/05
;a
G) Assumptions:
oI Year 5, 6,7 Less than 1 FTE allocated,
(J) based allocated cost on 112 FTE
I'V I'V <D -.....J
Page 46 of 60
AUTODATE
Cost Centers
Benzene Health Research Consortium API Administration 1Q05 Financial Report
(J)
I
m
r r
sI :
()
( ) LT 4/24/05
r
C
RT 04/13/05
;a
G) Assumptions:
oI Year 5, 6,7 Less than 1 FTE allocated,
(J) based allocated cost on 112 FTE
I'V I'V <D
ex>
Page 47 of 60
AUTODATE
ana orner (3rd Quarter) Supported Expense, drop off left some
funds for consultant
Benzene Health Research Consortium API Administration 1Q05 Financial Report
1s1 & 2nd Olr.
2003 3rd Olr.
4lh Olr.
1s101r.
2004 2nd Olr. 3rd Olr.
4lh Olr.
1s101r.
2005 2nd Olr. 3rd Olr.
4lh Olr.
1s101r.
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V I'V
Page 48 of 60
AUTODATE
<D
<D
ana orner (3rd Quarter) Supported Expense, drop off left some
funds for consultant
2006
2nd Olr.
3rd Olr.
Benzene Health Research Consortium API Administration 1Q05 Financial Report
4lh Olr.
1s101r.
2007
2nd Olr.
3rd Olr.
4lh Olr.
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V c..>
Page 49 of 60
AUTODATE
o
o
Benzene Health Research Consortium Contingency Fund 1005 Financial Report
Continaencv Funds
IRllrlm'tArl
Act~Val expense
CurrentVariance Cumm Variance
~~iill~ii~lAAij~i:iffiil:lI:t9} .
Budgeted Actual expense CurrentVariance Cumm Variance ~~iill~ii~I@~~r:C:At:I} Budgeted Actual expense CurrentVariance Cumm Variance ~t:f:i~piM~~W~";I:Ifji'i~~} Budgeted Actual expense CurrentVariance Cumm Variance
2000 1st - 4th Otr.
2001 1st - 4th Otr.
2002 1st - 4th Otr.
1st & 2nd Otr.
2003 3rd Otr.
~~ ~~ ~~
$0 $0 $0 $0 $0 $0
~~ ~~
$0 $0 $0 $0
~~ ~~ ~~
$0 $0 $0 $0 $0 $0
~~ ~~
$0 $0 $0 $0
~~ ~~ ~~
$0 $0 $0 $0 $0 $0
~~ ~~
$0 $0 $0 $0
~~ ~~ ~~
$0 $0 $0 $0 $0 $0
~~ ~~
$0 $0 $0 $0
4th Otr.
$290,2;~
$290,272 $290,272
$0 $48,839 ($48,839) ($48,839)
$0 $52,634 ($52,634) ($52,634)
~~
$0 $0
1stOtr.
2004
I 2nd Otr.
3rd Otr.
~~
$0 $290,272
~~
$0 $290,272
~~
$0 $290,272
~~
$0 ($48,839)
~~
$0 ($48,839)
~~
$0 ($48,839)
~~
$0 ($52,634)
~~
$0 ($52,634)
~~
$0 ($52,634)
~~ ~~ $0
$0 $0 $0 $0 $0 $0
IRllrlnAtArl
Act~Val expense
CurrentVariance Cumm Variance
~~ ~~ ~~
$0 $0 $0 $0 $0 $0
~~ ~~
$0 $0 $0 $0
~~
$0 $0
~~ ~~ ~~
$0 $0 $0 $0 $0 $0
IRllrlnAtArl
Act~Val expense
CurrentVariance Cumm Variance
~~ ~~ ~~
$0 $0 $0 $0 $0 $0
~~ ~~
$0 $0 $0 $0
~~
$0 $0
~~ ~~ ~~
$0 $0 $0 $0 $0 $0
IRllrlnAtArl
Act~Val expense
CurrentVariance Cumm Variance
~~ ~~ ~~
$0 $0 $0
~o ~o ~o
~~ ~~
$0 $0
~o ~o
~~
$0
~o
~~ ~~ ~~
$0 $0 $0
~o ~o ~o
IRlJrlnAtArl Actual expense
~~:~~$0.00
$0.00
c
0
CurrentVariance
$0.00
$0.00
0
I(J)
Cumm Variance
$0.00
$0.00
CUMULATIVETOTAlS......................................................................................................................................................... ....................2....0....0....0...................... :~:~:~:~:~:~:~:~:~2::..0:...G.....:1:..~:~:~:~:~:~:~:~:~:~
0
4;9g~}
m Budgeted
$0.00
$0.00
0
r r
Expense Variance
$0.00
~o.oo
$0.00
~o.oo
0 0
sI :
()
()
r
LT 4110105
C
;a
G)
oI
(J)
I'V c..>
o
.....lo.
00 00 00 00
00 00 00
290,272 101,473 188,799 188,799
290,272 101,473 H18,1S1S1
0 0 0 188,799
0 101,473 H18,1S1S1
0 0 0 188,799
0 101,473 H18,1S1S1
0 0 0 188,799
0 101,473 H18,1S1S1
4003 Adjustment - per Technical Committee, transfer $48,839 from UCHSC expense detail to contingency because expenses not part of UCHSC grant budget:
Page 50 of 60
AUTODATE
Benzene Health Research Consortium Contingency Fund 1005 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
Page 51 of 60
AUTODATE
I'V c..>
o
I'V
Benzene Health Research Consortium Contingency Fund 1005 Financial Report
J-\n0 - t:Xpt:II:::;t;:: lIdll:::;It:1 VI
$52,634 from AHS expense detail to contingency because expenses not part of AHS full study budget
I . ..JUlIt: c..uu I ..j)LJr\. YId.lll LV
UCHSC; seed money exhausted (API & sponsor), expense not included in final grant cost estimate L. ".50UU ltil:) Tees IO U or lJU (this will be a yearly fee, since IRB must review at least once per year) j. LUUL inVOice (~LU,Lj8) trom EMBSI for final feasibility study work (very late billing to API)
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
Page 52 of 60
AUTODATE
I'V c..>
o
c..>
LT 4/24/05 RT 04/05/05
::?~~~'::~:1
$50,692
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J) Page 53 of 60
I'V
oV>
.,j:::o.
AUTODATE
Benzene Health Research Consortium Income 1005 Financial Reoort
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
Page 54 of 60
AUTODATE
I'V
c..>
o
c..n
Company Name BP Gnevron I exaco ConocoPhillips ExxonMobii
Shell
Marathon lotal
(Seed Money)
Inv, # Date Paid
$15,000 $22,500
~l:',UUU
522922 528453
:'1181::1
8-Nov-00 19-Jun-01
(-NOV-UU
$15,000 522924 31-0ct-00 $7,500 528574 31-Jul-01
$0 523540
$15,000 523054 24-0ct-00 $15,000 528333 15-May-01
$15,000 528541 14-Aug-01
:;120,000
Benzene Health Research Consortium
Sponsor Invoice Detail 1aos Financial Report
2001
2002 (1 st - 2nd Qtr,)
2002 (3rd - 4th Qtr,)
22-Aug-01 Inv, # Date Paid $768,941 529301 4-0ct-01
~:'LL,(jL{ :'L8::1UL 8-Uct-Ul $246,314 529309 17-Sep-01
9-Jan-02 Inv,# Date Paid 27-Aug-02 Inv, # Date Paid
$806,441
~:'::I{,(jL{
532263 :'::11144
22-Feb-02 LL-t-eb-UL
$1,344,069 $112,008
~tl8(j,U4(j
535033 :,::I:,U::I4
11-0ct-02 2-0ct-02
:,-NOV-UL
$268,814 532245 16-Jan-02 $448,023 535035 26-Sep-02
$507,627 529305
25-Sep-01
$1,612,882 532246 $806,441 $806,441
$537,627 532247
23-Jan-02 11-Feb-02
7-Feb-02
$1,344,069
$896,046 $448,023 $448,023
535036 535037
13-Sep-02
25-Sep-02 10-Feb-03
:;2,045,509
:;5,376,273
Marathon Ashland Marathon Oil :;5,936,307
2003
23-Sep-03
Inv,# Date Paid
$1,431,041.00 544951 4-0ec-03
~1 ,ULtl,lUU.UU :'448:'::1 18-NOV-U::I $514,349.00 544954 27-0ct-03
$1,543,049.00 544956 $771 ,524.50 $771 ,524.50
$1,028,700.00 544958 $514,350 $514,350
$150,000 548582 $50,000 548581
:;8,317,588,00
3-0ct-03 22-Mar-04
28 Oct 03 14 Jan 04 20-Jan-04 3-Feb-04
LT 4/24/05 RT 4/27/2005
~~~~.~ . :
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
Page 55 of 60
AUTODATE
oc..>
(J)
Benzene Health Research Consortium
Sponsor Invoice Detail 1aos Financial Report
I 2005
27-Jan-05
Inv.# Date Paid
TOTAL
~0ti:',004.UU :,tiuu:,ti $548,000.00 560057 18-Mar-05
$4,500,000
:;3,000,000
$2,048,000
$548,000.00 560058 17-Feb-0
$5,048,000
$365,334.00 560059 :;1,826,668.00
$3,000,000 $215,000
:$17,811,000
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
Page 56 of 60
AUTODATE
oc..>
-.....J
Benzene Health Research Consortium Sponsor Payment Detail 1005 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G) LI
oI
4/24/05
~:;:. ,-:"~
(J)
I'V c..>
o ex>
3003 $-
(note - does not include interest income)
Page 57 of 60
AUTODATE
RT 4/13/05
Benzene Health Research Consortium Sponsor Payment Detail 1005 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V c..>
Page 58 of 60
AUTODATE
o
<D
Company
Date Paid Amount
American Petroleum Institute
1/17/2003 $
(I am trying to get this $1.09
1.09 I emoved from the books)
BP International Limited BP International Ltd BP p.Lc. BP p.Lc. BP p.Lc. BP p.Lc. BP p.Lc.
11/8/2000 $ 6/19/2001 $ 10/4/2001 $ 2/22/2002 $ 10/2/2002 $ 10/11/2002 $ 12/4/2003 $
15,000.00 22,500.00 768,941.00 806,441.00 112,008.00 1,344,069.00 1,431,041.00
$
BP Total 4,500,000.00
Chev ronTexaco Chev ronTexaco Chev ronTexaco Chev ronTexaco Chev ronTexaco
11/7/2000 $ 10/9/2001 $ 2/22/2002 $ 11/5/2002 $ 11/19/2003 $
15,000.00 522,627.00 537,627.00 896,046.00 1,028,700.00
ChevronTexaco Total $ 3,000,000.00
ConocoPhillips ConocoPhillips ConocoPhillips ConocoPhillips ConocoPhillips ConocoPhillips ConocoPhillips
10/31/2000 $ 7/31/2001 $ 9/17/2001 $ 1/16/2002 $ 9/26/2002 $
10/27/2003 $ 3/18/2005 $
15,000.00 7,500.00
246,314.00 268,814.00 448,023.00 514,349.00 548,000.00
ConocoPhillips Total $ 2,048,000.00
ExxonMobil Research and Engineering ExxonMobil Research and Engineering ExxonMobil
1/23/2002 $ 806,441.00 2/11/2002 $ 806,441.00 9/13/2002 $ 1,344,069.00
ExxonMobil ExxonMobil ExxonMobil
10/3/2003 $
3/22/2004 $ 2/17/2005 $
771,524.50 771,524.50 548,000.00
$
ExxonMobil Total 5,048,000.00
Marathon Ashland Petroleum, LLC.
8/14/2001 $ 15,000.00
Marathon Ashland Petroleum, LLC.
1/20/2004 $ 150,000.00 Marathon Ashland Total
(J)
I
Marathon Oil Company
2/3/2004 $ 50,000.00 $
215,000.00
m Shell Chem ical
10/24/2000 $ 15,000.00
r r
Shell Chem ical
5/15/2001 $ 15,000.00
s:I Shell Chem ical
9/25/2001 $ 507,627.00
() Shell Chem ical
2/7/2002 $ 537,627.00
() Shell Chem ical
r
C
Shell Chem ical
;a
9/25/2002 $ 448,023.00 2/10/2003 $ 448,023.00
G)
oI
(J)
I'V c..>
.....lo.
o
Shell Chem ical Shell Chem ical
LT 4/24/05 RT 4/13/05
10/28/2003 $ 1/13/2004 $
I514,350.00
Shell Chemical Total
514,350.00 $
3,000,000.00
$ 17,811,001.09
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V c..>
.....lo.
.....lo.