Document BR5VwOL8XwdLMj5N5R1yMBqdX
To: Benzene OC listserve (E-mail) <BenzConsort-OC@listserve.api.org>
From:
Lorraine Twerdok <Twerdokl@api.org>
Cc: Benzene consort comm (E-mail) <benzconsort-cc@listserve.api.org>; Benzene
consort tech (E-mail) <benzconsort-tc@listserve.api.org>
Bcc:
Received Date:
2005-08-2420:09:24 GMT
Subject:
BHRC - Final 2Q05 financial report
To All BHRC Committee Members -
Attached is the final 2Q05 financial report. It is also posted on the SHS website. > The following changes were made following the 8/18/05 meeting:
* "slightly" and APCO" have been deleted from Text Summary * API Interest income has been projected through 2007; interest is not allocated to any cost center
* Note - UCHSC interest income has not been projected, since Iron's expense projects need to be revised based on the July progress report. Interest projections will be made to the extent possible in the 3Q05 report
* Sponsor invoicing and income has been projected through 2007. Income is projected for the 2nd quarter of each year based on the assumption that invoices will go out during the first quarter of each year. (A decision on timing of invoicing has not yet been made) * Executive summary has been revised to clarify Actual vs Projected income by adding month reference to projected income. * Dr. Iron's T&E expenses for the 1Q05 have been added to 2Q05 report - this is a new correction, on final review this omission was picked up.
Regards, Lorraine
*****************************************
Lorraine E. Twerdok, Ph.D., DABT Manager, Health Sciences Regulatory Analysis and Scientific Affairs American Petroleum Institute 1220 L Street, NW. Washington, DC 20005
tel: 202-682-8344 email: twerdokl@api.org fax: 202-682-8031
Attachments: BHRC Program Expenses 2Q05 rpt FINAL.xls
SH ELL-MCCLU RG-062397
Benzene Health Research Consortium 2Q05 Financial Report Overview
Fund Balance at API 2Q05:
$2,980,5151
IBudgeted Expense Projections for 2Q05 thru 4Q07 have been revised per May 3,2005 revised program budget. The
Irons Field Expenses: no new disbursements in 2005 UCHSC: $874,030 disbursed in 2005 per grant payment schedule. Jan. - June, 2005 actual expenses will be reported in AHS: $123,114 disbursed in 2005 Fudan University: no 2005 disbursements SRP/ERP: $2,500 disbursed in 2005 Communications: no spending 2005
Outside Legal Council: 6% over budget; $16769 disbursed in 2005.
QAlQC: no activity
API Administrative Costs: $39,868 in 2005 costs
(J)
I
m
r r
sI :
()
() Need to reconcile UCHSC statement - they have a $105 error (from 4003 rpt).
r
C
;a
G)
oI
(J) Page 1 of 58
I'V c..> <D
ex>
AUTODATE
~ budgets were revised for the 3005 financial report
Benzene Health Research Consortium 2Q05 Financial Report Overview
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
Page 2 of 58
AUTODATE
I'V
c..>
<D
<D
Benzene Health Research Consortium 2Q05 Financial Report Overview
Technical Budget Work Group Acceptance: 8/2/05 Oversight Committee Acceptance: 8/18/05 Posted to Website: 8/24/05
LT 8/24/05 BJ 4/05/05
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
Page 3 of 58
AUTODATE
I'V
..j:::o.
o
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
CQ~)Lao()
CC\I Q)
III
llJ f-
ooe:(
f::J
e:(
ro
""0' "Q)
n'O".J
SHELL-MCCLURG-062401
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
2Q05 Financial R- .........
Unapproved
Approved
Changes not
Approved
Approved Approved
Estimate
Estimate approved (June 11 NOV 03 OC 21 APR 04 OC 16 Dec 04 OC 3 May 05 OC
(Jan. 2001) (Dec. 2001)
2003)
mtg
mtg mtg mtg
$1,595,000 $2,283,095
$2,283,095
$2,283,095 $2,283,095 $2,283,095 $2,930,841
$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 $14,508,000 $14,508,000 $18,332,769
$1,413,428 $1,413,428 $1,413,428 $1,413,428
$230,000
$230,000
$230,000
$306,062
$18,434,523 $18,434,523 $18,434,523 $22,983,100
$648,000
$551,736
$300,000
$300,000
$300,000
$300,000
$216,000
$192,000
$64,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
..j:::o.
o
I'V
$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
$0 $364,000
$0
$140,000
Page 5 of 58
AUTO DATE
Public Affairs QAlQC Activities UCHSC Interest contingency
Miscellaneous Costs Subtotal API Admin. GRAND TOTAL
Benzene Health Research Consortium Approved Program Budget 2Q05 Financial Report
$1,000,000 $1,000,000
$960,600
$550,000
$550,000
$300,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
$50,000 $0
$850,695 $1,340,695 $24,687,795 $1,445,205
$19,761,000 $22,789,300
$22,789,299
$21,084,000 $21,084,000 $21,084,000 $26,133,000
Notes by API
Notes/As sumption s for Dec. 2001 revised budget:
- The total research costs have changed as a result of the protocol review process and changes in the protocols as recommended by the SRP and ERP. Case-Control Study was also adjusted for inflation (5%/year) in an interim iteration.
- Panel costs assume that there will be only one face-toface meeting for each panel each year.
(J)
I
m
r r
sI :
() LT
()
r
7/24/05
C
;a
G)
oI
(J)
I'V
..j:::o.
o
c..>
~1~ r,~:x
3 May 05 revised budget notes - $423 added to contingency to round total budget to nearest thousand - increased API adm inistrative costs for one extra year (2007)
Page 6 of 58
AUTO DATE
Benzene Health Research Consortium Approved Program Budget
$2,568,545 $365,333 $548,000 $822,000 $365,333
$0 $911,959 $308,182 $1,093,939 $911,959
pmt schedule nchanged from current
ule except for BP 2005 commitment
as of 3/31/05
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J) Page 7 of 58
I'V
..j:::o.
o
..j:::o.
AUTODATE
Benzene Health Research Consortium Executive Summary
2Q05 Financial Report
Cost Centers Income
Project #
Inception Thru
December 2004
Actuals
Actuals Jan - June
2005
$ 16,765,693 $ 1,468,143
$ 18,233,836
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
874,030 131,000 193,430
11,011,880 919,486
1,584,444 124,090
166,772 294,161
64,529
2,500 21,596
169,272 294,161
86,125
871,150 104,473
77,264 50,718
948,414 155,191
$ 13,942,525 $ 1,350,539 $ 15,293,063
$ 2,823,169 $ 117,604 JI":Mmp~19
Cumulative ACTUALS
Inception Thru 2Q05
Budget (actual + projected income
2005 July - Dec
PROJECTED
2006 Jan - Dec
$ 18,233,836
$ 3,201,068 ***
$ 3,226,039
11,011,880 919,486
1,584,444 124,090
169,272 294,161
86,125
948,414 155,191
$" 15,293,063
2,750,000 131,000 267,584 80,563
74,250 1,946
15,622 16,667 103,000
4,000,000 262,000 547,953 55,491
76,073 1,946
31,244 16,667 163,500
$ 3,440,632
$ 5,154,874
:::::$::q~~1119;il :::::::::::::::::r:::::::::::::::::::111:g~:11:::::::rr
(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
..j:::o.
o c..n
Page 8 of 58
155,191
AUTO DATE
& expenses)
Benzene Health Research Consortium Executive Summary
2Q05 Financial Report
2007 Jan - Dec
$1,522,750
Projected
Program
inc/exp
Budget
Income
$ 26,183,693 1$ 26,133,000 1
570,889 100,942 502,311
45,918
Expenses
18,332,769 1,413,428 2,902,292 306,062
18,332,769 1,413,428 2,930,841 306,062
48,073 1,946 31,242 16,667 225,450
367,668 300,000 164,233
50,000 1,440,364
155,191
364,000 300,000 140,000 50,000 1,445,205 850,695
$1,543,438 $ 25,432,0071 $ 26,133,000 1
::::::::::::::::::::I1~n:;l.gl:
(J)
I
m
r r
Income Detail
s:I
sponsors
$17,961,335
() MAP
() contrib.
r
$215,000
C
;a
G)
oI
(J)
I'V
..j:::o.
o
(J)
Page 9 of 58
AUTODATE
*** ConocoPhillips pay remaining commitment in 2005
LT 8/3/05
Benzene Health Research Consortium Executive Summary
2Q05 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
Page 10 of 58
AUTODATE
I'V
..j:::o.
o
-.....J
API interest UCHSC interest
TOTAL
$57,501 $0
$18,233,836
Benzene Health Research Consortium Executive Summary
2Q05 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
Page 11 of 58
AUTO DATE
I'V
..j:::o.
o ex>
Benzene Health Research Consortium Cash Flow Statement 2Q05 Financial Report
:~iM#'@iil.iiiMMi@.~M~.ii@iiN$.@~M({::::
LT 8/23/05 RT 04/13/05
NOTE,! $2,980,5151;n bank at API ~""$~~;~~
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
12 of 58
AUTODATE
I'V
..j:::o.
o
<D
15tOtr.
2006
2nd Otr.
3rd Otr.
4th Otr.
15tOtr.
Benzene Health Research Consortium Cash Flow Statement 2Q05 Financial Report
2007
2nd Otr.
3rd Otr.
4th Otr.
TOTALS
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
13 of 58
AUTODATE
I'V
..j:::o.
.....lo.
o
Cost Centers
Benzene Health Research Consortium Program Expense Summary 2Q05 Financial Report
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
.....lo.
.....lo.
Benzene Health Research Consortium Program Expense Summary 2Q05 Financial Report
r-------------~------~------------~~------------~,--~~~~,
Cost Centers
(J)
I
m
rr, s:
()
()
r
C
;a
G,)
o
(J)
I'V
..j:::o.
.....lo.
Page 15 of 58
AUTODATE
I'V
Benzene Health Research Consortium Program Expense Summary 2Q05 Financial Report
RT 04/13/05
Amt.At UCHSC & Irons Field exp. Bank acct
$13,818,541 $1,434,779
69,235
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
247,035 1,063,761
131,000 2,750,000
131,000 2,500,000
131,000
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
.,j:::o.
Page 16 of 58
AUTODATE
....lo.
c..>
Benzene Health Research Consortium Program Expense Summary 2Q05 Financial Report
r-------------~------~------------~~------------~,--~~~~,
Cost Centers
RT 04/13/05
API disbursed by period (includes pre-payments
for UCHSC & Irons Field)
1,500,000
100,942
570,889
IT IT 23,043,570
(J)
I
m
rr, s:
() ()
r
C
;a
G,)
o
(J)
I'V
.,j:::o.
Page 17 of 58
....lo.
.,j:::o.
AUTODATE
Benzene Health Research Consortium UCHSC Grant 2Q05 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
..j:::o.
Page 18 of 58
AUTODATE
.....lo.
c..n
Benzene Health Research Consortium UCHSC Grant 2Q05 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
Page 19 of 58
AUTODATE
.....lo.
(J)
UCHSC (x81 05) Cost Centers
LT 8/02105
BJ 8/02105
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
.....lo.
-.....J
Benzene Health Research Consortium UCHSC Grant 2Q05 Financial Report
1st & 2nd Otr.
2003 3r.d Otr.
4th Otr.
IstOtr.
2004
2nd Otr.
3rd Otr.
4th Otr.
IstOtr.
2005
2nd Otr.
3rd Otr.
4th Otr.
Am!. paid UCHSCto date:
Am!. expensed to date: Am!. In UCHSC bank acct:
(Adjusted 4003: $48,839 attr.ibuted 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 $11,011,880 study" in 2002)
(Adjusted 4003: 2001 costs had been double expensed in 2002 column; ($523,807) adjusment $9,624,218 made in 4003)
$1,387,662
2QOSvariance adjusted to reflect only current qtr variance
bedgeted expense projections revised per 3 May 05 revised program budget
Page 20 of 58
AUTODATE
UCHSC (x81 05) Cost Centers
Benzene Health Research Consortium UCHSC Grant 2Q05 Financial Report
2006
2nd Olr.
3r.d Olr.
4lh Olr.
2007
2nd Olr.
3r.d Olr.
4lh Olr.
LT 8/02105
BJ 8/02105
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
.....lo.
ex>
Page 21 of 58
AUTODATE
Benzene Health Research Consortium UCHSC Subcontract 2Q05 Financial Report
(J)
I LT 8/3/2005
m BJ 8/02105
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V
.,j:::o.
....lo.
<D
"Total subcontracto r expenses" from study report (preliminary figure); "actual expenses" from UC Office of Grants & Contracts spreadsheet (final figures).
"2002 subcontractor costs not broken out by UCHSC, so this must be added back into the sum of row totals for total subcontractor costs to balance
Page 22 of 58
AUTODATE
Cost Centers
Benzene Health Research Consortium Irons Field Expenses 2Q05 Financial Report
4th Otr
15t & 2nd
5t -4th Otr
Otr
3rd Otr
4th Otr
15tOtr
2nd Otr
3rd Otr
4th Otr
15tOtr
2nd Otr
3rd Otr
4th Otr
15tOtr
2nd Otr
3rd Otr
4th Otr
15tOtr
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
$919,486 of 6/30/05
G)
oI
(J)
I'V
..j:::o. Page 23 of 58
oI'V
AUTODATE
Cost Centers
2nd Olr.
3r.d Olr.
4lh Olr.
Benzene Health Research Consortium Irons Field Expenses 2Q05 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
Page 24 of 58
AUTODATE
I'V
.....lo.
IRONS T&E (X81 06) Cost Centers
LT 8/24/05 BJ 8/24/05
Amt Irons has spent:
Amt. In Irons bank acct:
Benzene Health Research Consortium Irons Field Expenses 2Q05 Financial Report
2003 15t & 2nd
Otr. 3rd Otr.
note -1005 &2005 expenses recprded in $872,369 2005
4th Otr.
15tOtr.
2004
2nd Otr.
3rd Otr.
4th Otr.
15tOtr.
2005
2nd Otr.
3rd Otr.
4th Otr.
15tOtr.
2006
2nd Otr.
3rd Otr.
4th Otr.
15tOtr.
$47,117
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
Page 25 of 58
AUTODATE
I'V
I'V
IRONS T&E (X81 06) Cost Centers
2007
2nd OIL
3rd OIL
4lh OIL
LT 8/24/05 BJ 8/24/05
Benzene Health Research Consortium Irons Field Expenses 2Q05 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
Page 26 of 58
AUTODATE
I'V
c..>
Cost Centers
Benzene Health Research Consortium AHS 2Q05 Financial Report
LT 8/3/05
BJ 4/05/05
RT 7/15/05
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
I'V
..j:::o.
..H~~:\~
Adjustment: expense reduced by $52,634; transferred to contingency since these were preconsortia expenses
$394,467 Page 27 of 58
AUTODATE
Cost Centers
15tOtr.
2nd Otr.
3rd Otr.
4th Otr.
Benzene Health Research Consortium AHS 2Q05 Financial Report
LT 8/3/05
BJ 4/05/05
RT 7/15/05
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
cI'.V.n
Page 28 of 58
AUTODATE
Benzene Health Research Consortium Fudan 2Q05 Financial Report
LET 8/3/05 BJ 8/01/05
'Js-- ~ . ~~
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
I'V
(J)
2Q05 - variance zeroed outonly current cqtr variance shown 2Q05 - ezpense projections revi sed based on 3 May 05 approved budget
Page 29 of 58
AUTODATE
Benzene Health Research Consortium Fudan 2Q05 Financial Report
LET 8/3/05 BJ 8/01/05
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
I'V -.....J
Page 30 of 58
AUTODATE
Benzene Health Research Consortium
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
I'V
ex>
Benzene Health Research Consortium SRP + ERP 2Q05 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
I'V
Page 32 of 58
AUTODATE
<D
Benzene Health Research Consortium
2006
2007
LT 8/3/05
BJ 4/05/05 RT 7/15/05
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
c..>
o
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 33 of 58
AUTODATE
Benzene Health Research Consortium SRP + ERP 2Q05 Financial Report
LT 8/3/05
BJ 4/05/05
RT 7/15/05
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
c..>
.....lo.
Page 34 of 58
AUTODATE
Cost Centers
Benzene Health Research Consortium Communications 2Q05 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 8/3/05
(J) RT 1/21/05
I'V
..j:::o.
c..> I'V
*budget adjustrnent to lower prograrn budget frorn $550K to
Page 35 of 58
AUTODATE
Cost Centers
Benzene Health Research Consortium Communications 2Q05 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 8/3/05
(J) RT 1/21/05
I'V
..j:::o.
c..> c..>
Page 36 of 58
AUTODATE
Benzene Health Research Consortium Communications 2Q05 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
..j:::o.
Page 37 of 58
AUTODATE
c..>
..j:::o.
Benzene Health Research Consortium Communications 2Q05 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
..j:::o.
Page 38 of 58
AUTODATE
c..>
c..n
Cost Centers
Benzene Health Research Consortium Legal 2Q05 Financial Report
* budget adjustment to lower program budget from $500K to $1 OOK, as approved by OC on 11/11/03
LT 8/3/05 RT 07/15/05
'1~~~"~~
$54,081
$85,920 $7,810.86
variance adjusted to reflect only 2005 variance
2005 Budget revised from $100K to $140K per revised program budget approved 3 May 05
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
.,j:::o. Page 39 of 58
c..>
(J)
AUTODATE
Benzene Health Research Consortium Legal 2Q05 Financial Report
* budget adjustment to lower program budget from $500K to $1 OOK, as approved by OC on 11/11/03 LT 8/3/05 RT 07/15/05
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V
.,j:::o.
c..> -.....J
Page 40 of 58
AUTODATE
Benzene Health Research Consortium QA-QC 2Q05 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 LT 8/3/05
(J)
I'V
..j:::o.
c..> ex>
Page 41 of 58
AUTODATE
Benzene Health Research Consortium QA-QC 2Q05 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 LT 8/3/05
(J)
I'V
..j:::o.
c..> <D
Page 42 of 58
AUTODATE
Cost Centers
Benzene Health Research Consortium API Administration 2Q05 Financial Report
(J)
I
m
r r
sI :
() ()
r
C
;a LT 8/1/05
G)
oI
(J)
I'V
..j:::o. ..j:::o.
o
Page 43 of 58
variance reflects 2Q05 variance, only
AUTODATE
Cost Centers
Benzene Health Research Consortium API Administration 2Q05 Financial Report
(J)
I
m
r r
sI :
() ()
r
C
;a LT 8/1/05
G)
oI
(J)
I'V
..j:::o. ..j:::o.
.....lo.
Page 44 of 58
AUTODATE
Cost Centers
RT 7/15/05 Miii.&'M@~f:iiii.#ims.@!.i.'%MffuW~I~i:iir
Benzene Health Research Consortium API Administration 2Q05 Financial Report
3rd Otr. 4th
expenses revised to reflect 3 May 05 revised total program budget
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
Page 45 of 58
AUTODATE
..j:::o.
I'V
API Cost Centers
2006
2nd Olr.
3rd Olr.
4lh Olr.
Benzene Health Research Consortium API Administration 2Q05 Financial Report
1s101r.
2007
2nd Olr.
3rd Olr.
4lh Olr.
RT 7/15/05 Miii.&'M@~f:iiii.#ims.@!.i.'%MffuW~I~i:iir
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
Page 46 of 58
AUTODATE
..j:::o.
c..>
Benzene Health Research Consortium Contingency Fund 2Q05 Financial Report
** to be reprogrammed as API expense in 3005
LT 8/3/05
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V
..j:::o. ..j:::o. ..j:::o.
4003 Adjustment - per Technical Committee, transfer $48,839 from UCHSC expense detail to contingency because expenses not part of UCHSC grant budget:
Page 47 of 58
AUTODATE
Benzene Health Research Consortium Contingency Fund 2Q05 Financial Report
850,695
$155,191
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V
..j:::o. ..j:::o.
c..n
Page 48 of 58
AUTODATE
Benzene Health Research Consortium Contingency Fund 2Q05 Financial Report
1. June 2001 $25K grant to UCHSC; seed money exhausted (API & sponsor), expense not included in final grant cost estimate
2. $3600 IRB fees to U of CO (this will be a yearly fee, since IRB must review at least once per year)
3. 2002 invoice ($20,239) from EMBSI for final feasibility study work (very late billing to API)
AHS - expense transfer of $52,634 from AHS expense detail to contingency because expenses not (J) part of AHS full I study budget
m
r r
sI :
() ()
r
C
;a
G)
oI
(J) Page 49 of 58 I'V
..j:::o. ..j:::o. (J)
AUTODATE
LT 8/23/05 RT 07/15/05
";:s;:: ~:.~ ~
$57,501
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J) Page 50 of 58
I'V
.,j:::o. .,j:::o.
-....J
AUTODATE
2nd 01r.
3rd 01r.
Benzene Health Research Consortium Income 2Q05 Financial Reoort
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
Page 51 of 58
AUTODATE
I'V
..j:::o.
..j:::o.
ex>
Company Name BP
I~nevron
(Seed Money)
Inv.# Date Paid
$15,000 522922 8-Nov-00 $22,500 528453 19-Jun-01
~l:',UUU :'1181::1 (-NOV-UU
Benzene Health Research Consortium
Sponsor Invoice Detail 2Q05 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
9-Jan-02 $806,441
~:'::I{,(jL{
Inv.# Date Paid 27-Aug-02
532263 22-Feb-02 $1,344,069 $112,008
:'::11144 LL-t-eb-U'
~tl8(j,U4(j
Inv.# Date Paid
535033 11-0ct-02 2-0ct-02
:,::I:,U::I4 :,-NOV-U'
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
ConocoPhillips ExxonMobii
Shell
Marathon ITotal
$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,0001
$246,314 529309 17-Sep-01 $507,627 529305 25-Sep-01 $2,045,509 1
$268,814 532245 16-Jan-02 $448,023 535035 26-Sep-02
$514,349.00 544954 27-0ct-03
$1,612,882 532246 $806,441 $806,441
$537,627 532247
23-Jan-02 11-Feb-02
7-Feb-02
$1,344,069 535036
$896,046 535037 $448,023 $448,023
13-Sep-02
25-Sep-02 10-Feb-03
$5,376,273 1
Marathon Ashland Marathon Oil $5,936,307 1
$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.001
3-0ct-03 22-Mar-04
28 Oct 03 14 Jan 04 20-Jan-04 3-Feb-04
I Projected Invoicing
I 2006
2005
Company Name It)t'
invdate Inv.I
;jjU.UU
Date Paid
invdate Inv.# Date Paid
:tiU.UU
Projected
TOTALS
:jif,Ulns,:><t::l
Chevron
$911,959
$435,071
$4,712,364
ConocoPhillips
$308,182
ExxonMobii
$1,093,939
(J)
I
m
Shell
r
r
s:I Marathon
()
() Ilotal
r
C
;a
G)
oI
(J)
I'V
..j:::o.
..j:::o.
<D
$911,959
:ji3,22ti,U3l:1
$0.00 $652,606 $435,071
~1,::l22,f4B
$2,356,182 $7,068,545
$4,712,364 $215,000
~2ti, 133,UUU
Page 52 of 58
AUTODATE
Benzene Health Research Consortium
Sponsor Invoice Detail 2Q05 Financial Report
I 2005
PAID
27-Jan-05
Inv.# Date Paid
$2,568,545.00 563928 11-Jul-05
~0ti:',004.UU :,tiuu:,ti 18-JUI-Ut
TOTALS
$7,068,545 :;3,365,33"1
$548,000.00 560057 18-Mar-05
$548,000.00 560058 17-Feb-05 $274,000.00 564774
$365,334.00 560059 28-Apr-05
$2,048,000 $5,048,000
$3,365,334
:;4,669,213.001
$215,000
II ~21,110,213
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
Page 53 of 58
AUTODATE
..j:::o.
c..n o
LT 8/18/05 RT 07/15/05
";:s;:: ~:.~ ~
Benzene Health Research Consortium Sponsor Invoice Detail 2Q05 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
Page 54 of 58
AUTODATE
..j:::o.
c..n
.....lo.
Benzene Health Research Consortium Sponsor Payment Detail 2Q05 Financial Report
(J)
I
m
r r Total thru 6/30/05
s:I $ 18,176,335.09
() (includes
() Marathon)
r
C
;a
G)
oI
(J)
I'V
..j:::o.
Page 55 of 58
AUTODATE
c..n
I'V
LT 8/3/05 RT 7/15/05
DRAFT
Benzene Health Research Consortium Sponsor Payment Detail 2Q05 Financial Report
(note - does not include interest income)
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
Page 56 of 58
AUTODATE
c..n
c..>
BHRC Sponsor Payments
r. ."". d by Sponsor Company
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
11/8/2000 $ 15,000.00
BP International Ltd
6/19/2001 $ 22,500.00
BP p.Lc.
10/4/2001 $ 768,941.00
BP p.Lc.
2/22/2002 $ 806,441.00
BP p.Lc. BP p.Lc.
10/2/2002 $ 112,008.00 10/11/2002 $ 1,344,069.00
BP p.Lc. BP p.Lc.
12/4/2003 $ 1,431,041.00 7/11/2005 $ 2,568,545.00 $
BP Total 7,068,545.00
Chev ronTexaco 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 $ 7/19/2005 $
15,000.00 522,627.00 537,627.00 896,046.00 1,028,700.00 365,334.00
ChevronTexaco Total $ 3,365,334.00
ConocoPhillips
10/31/2000 $ 15,000.00
ConocoPhillips
7/31/2001 $
7,500.00
ConocoPhillips
9/17/2001 $ 246,314.00
ConocoPhillips
1/16/2002 $ 268,814.00
ConocoPhillips
9/26/2002 $ 448,023.00
ConocoPhillips ConocoPhillips
10/27/2003 $ 514,349.00
ConocoPhillips Total
3/18/2005 $ 548,000.00 $
2,048,000.00
ExxonMobil Research and Engineering 1/23/2002 $ 806,441.00
ExxonMobil Research and Engineering ExxonMobil
2/11/2002 $ 806,441.00 9/13/2002 $ 1,344,069.00
ExxonMobil
10/3/2003 $ 771,524.50
ExxonMobil
3/22/2004 $ 771,524.50
ExxonMobil Total
ExxonMobil
2/17/2005 $ 548,000.00 $
5,048,000.00
(J)
I
Marathon Ashland Petroleum, LLC.
8/14/2001 $ 15,000.00
m Marathon Ashland Petroleum, LLC.
1/20/2004 $ 150,000.00 Marathon Ashland Total
r r
Marathon Oil Company
2/3/2004 $ 50,000.00 $
215,000.00
s:I Shell Chem ical
10/24/2000 $ 15,000.00
() Shell Chem ical
5/15/2001 $ 15,000.00
() Shell Chem ical
r
C
Shell Chem ical
;a
9/25/2001 $ 507,627.00 2/7/2002 $ 537,627.00
G)
oI
(J) Page 57 of 58 I'V
..j:::o.
c..n
..j:::o.
AUTO DATE
Shell Chem ical Shell Chem ical Shell Chem ical Shell Chem ical Shell Chem ical
LT 8/3/05 RT 07115/05
9/25/2002 $
BHRC Sponsor Payments
448J?2Q~Zfld by Sponsor Company
2/10/2003 $ 10/28/2003 $
1/13/2004 $ 4/28/2005 $
448,023.00
I514,350.00
514,350.00
Shell Chemical Total
365,334.00 $
3,365,334.00
$ 21,110,214.09
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
Page 58 of 58
AUTODATE
I'V
..j:::o.
c..n c..n
To: BenzConsort-OC@listserve.api.org <BenzConsort-OC@listserve.api.org>;
BenzConsort-TC@listserve.api.org <BenzConsort-TC@listserve.api.org>
From:
Russell White <whiter@api.org>
Cc:
Bcc:
Received Date:
2006-03-31 21 :02: 10 GMT
Subject:
SHS Financial Data - Final 4Q 2005
All,
Here is the financial report for the SHS through year-end 2005. Stuart Cagen will discuss it on our scheduled conference call next Tuesday (4PM EDT). Patsy and I are still working on the agenda but I wanted you to have the opportunity to study the report over the weekend.
> Russell White
American Petroleum Institute
1220 L Street NW
Washington, DC 20005-4070
Tel: 202-682-8344
Attachments: BHRC Program Expenses 4Q05 rpt - FINAL.xls
SH ELL-MCCLU RG-0624S6
Benzene Health Research Consortium 4Q05 Financial Report Overview
Fund Balance at API4Q05: Fund Balance in spreadsheet 4Q05:
$ 3,298,248 $ 3,298,247
IBudgeted Expense Projections for 2Q05 thru 4Q07 have been revised per May 3,2005 revised program budget. The bud!
Irons Field Expenses: $131,000 disbursed in 3005 UCHSC: "Report of Expenditures" entered in 4005 actuals. $2,750,000 disbursed in 4005. USHSC did return $61,000 in inten AHS: $222,365 disbursed in 4005 Fudan University: $4,007 in expenses invoiced in 4005 SRP/ERP: $59,661 disbursed in 4005. Extension of all member contracts through Dec 2007, will likely increase total contract Communications: no 4005 expenses
Outside Legal Council: $12,110 expensed in 4005
QAlQC: no 4005 expenses
(J)
I
API Administrative Costs: $52,572 in 4005 costs
m
r
r
sI :
()
()
r
C
;a
G)
oI
(J) Page 1 of 58
I'V
..j:::o.
c..n
-.....J
AUTODATE
Benzene Health Research Consortium 4Q05 Financial Report Overview
gets were revised for UCHSC grantl
est to the Consortium.
t committments to $414,252
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
c..n ex>
Page 2 of 58
AUTODATE
Executive Summary:
Benzene Health Research Consortium 4Q05 Financial Report Overview
Technical Budget Work Group Acceptance: Oversight Committee Acceptance: Posted to Website:
LT 8/24/05
BJ 11/29/05 RT 2117106
RW 2/16/06
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J) Page 3 of 58
I'V
..j:::o.
c..n
<D
AUTODATE
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
CQ~)Lao()
C"<t
Q)
III
llJ f-
ooe:(
f::J
e:(
ro
""0' "Q)
n'O".J
SH ELL-MCCLU RG-062460
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
4Q05 Financial R- .........
Unapproved
Approved
Changes not
Approved
Approved Approved
Estimate
Estimate approved (June 11 NOV 03 OC 21 APR 04 OC 16 Dec 04 OC 3 May 05 OC
(Jan. 2001) (Dec. 2001)
2003)
mtg
mtg mtg mtg
$1,595,000 $2,283,095
$2,283,095
$2,283,095 $2,283,095 $2,283,095 $2,930,841
$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 $14,508,000 $14,508,000 $18,332,769
$1,413,428 $1,413,428 $1,413,428 $1,413,428
$230,000
$230,000
$230,000
$306,062
$18,434,523 $18,434,523 $18,434,523 $22,983,100
$648,000
$551,736
$300,000
$300,000
$300,000
$300,000
$216,000
$192,000
$64,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
..j:::o.
(J)
.....lo.
$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
$0 $364,000
$0
$140,000
Page 5 of 58
AUTO DATE
Public Affairs QAlQC Activities UCHSC Interest contingency
Miscellaneous Costs Subtotal API Admin. GRAND TOTAL
Benzene Health Research Consortium Approved Program Budget 4Q05 Financial Report
$1,000,000 $1,000,000
$960,600
$550,000
$550,000
$300,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
$50,000 $0
$850,695 $1,340,695 $24,687,795 $1,445,205
$19,761,000 $22,789,300
$22,789,299
$21,084,000 $21,084,000 $21,084,000 $26,133,000
Notes by API
Notes/As sumption s for Dec. 2001 revised budget:
- The total research costs have changed as a result of the protocol review process and changes in the protocols as recommended by the SRP and ERP. Case-Control Study was also adjusted for inflation (5%/year) in an interim iteration.
- Panel costs assume that there will be only one face-toface meeting for each panel each year.
(J)
I
m
r r
sI :
() LT
()
r
7/24/05
C
;a
G)
oI
(J)
I'V
..j:::o.
(J)
I'V
3 May 05 revised budget notes - $423 added to contingency to round total budget to nearest thousand - increased API adm inistrative costs for one extra year (2007)
Page 6 of 58
AUTO DATE
Benzene Health Research Consortium Approved Program Budget
$2,568,545 $365,333 $548,000 $822,000 $365,333
$0 $911,959 $308,182 $1,093,939 $911,959
pmt schedule nchanged from current
ule except for BP 2005 commitment
as of 3/31/05
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J) Page 7 of 58
I'V
..j:::o. (J)
c..>
AUTODATE
Cost Centers Income
Benzene Health Research Consortium Executive Summary
4Q05 Financial Report
Project #
Inception Thru
December 2004
Actuals
Actuals
Jan - Dec 2005
Actuals
Jan - Mar 2006
Program to Date
$ 16,765,693 $ 5,206,657
$ 21,972,350
Cumulative ACTUALS
Inception Thru 4Q05
Budget (actual + p
2006 Jan - Mar
$ 21,972,350
$
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
3,624,030 262,000 548,720 4,007
13,761,880 1,050,486 1,939,734 128,097
13,778,460 990,282
13,761,880 1,050,486 1,939,734 128,097
166,772 294,161
64,529
76,176 33,706
242,948 294,161
98,235
242,948 294,161
98,235
871,150 104,473
170,475 51,918
1,041,625 156,391
1,041,625 156,391
$ 13,942,525 $ 4,771,033
$ 18,713,557
$ 18,713,557
$ 2,823,169 $ 3,258,793~~~~~g4t
131,000 136,988
3,823 7,811 4,167 40,500
$ 324,289 :::::I:::iiHg~.:r:::rr:r:
(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
..j:::o.
(J)
..j:::o.
Page 8 of 58
156,391 AUTO DATE
Benzene Health Research Consortium Executive Summary
4Q05 Financial Report
,rojected income & expenses)
PROJECTED
2006 Jan - Dec
2007 Jan - Dec
$ 2,826,039 $ 1,522,750
Projected inc/exp
Program Budget
Income
I I$ 26,321,139 $ 26,133,000
4,000,000 262,000 547,953 55,491
570,889 100,942 502,311
45,918
Expenses
18,332,769 1,413,428 2,989,998 229,506
18,332,769 1,413,428 2,930,841 306,062
76,073 1,946 31,244 16,667 163,500
$ 5,154,874
48,073 1,946
31,242 16,667 225,450
$ 1,543,438
367,094
364,000
298,053
300,000
160,721
140,000
33,333
50,000
_ - _1,430,575 1,445,205 156,391 ....... 850,69..5.....
I I$ 25,411,869 $ 26,133,000
:::1 :r:::II~mng:r: :::::::r::r::r:::::::::::liRllll:
(J)
I
m
r r
Income Detail
s:I
sponsors
$21,569,214
()
()
MAP contrib.
$215,000
r
C
;a
G)
oI (J) Page 9 of 58
I'V
..j:::o.
(J)
c..n
AUTODATE
*** ConocoPhillips pay remaining commitment in 2005
LT 8/3/05 RT 11/10/05 RW 2/20106
Benzene Health Research Consortium Executive Summary
4Q05 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
Page 10 of 58
AUTODATE
I'V
..j:::o.
(J)
(J)
API interest UCHSC interest
TOTAL
$127,127 $61,009
$21,972,350
Benzene Health Research Consortium Executive Summary
4Q05 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
Page 11 of 58
AUTO DATE
I'V
..j:::o.
(J)
-.....J
Benzene Health Research Consortium Cash Flow Statement 4Q05 Financial Report
:@M!i#:W~gili#'W:MM&Mif~m'~Kri(::
LT 8/23/05 RT 04/13/05
NOTE,! $3,298,2471;n bank at API
$372,143
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
12 of 58
AUTODATE
I'V
..j:::o.
(J)
ex>
15tOtr.
2006
2nd Otr.
3rd Otr.
4th Otr.
15tOtr.
Benzene Health Research Consortium Cash Flow Statement 4Q05 Financial Report
2007
2nd Otr.
3rd Otr.
4th Otr.
TOTALS
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
13 of 58
AUTODATE
I'V
..j:::o.
(J)
<D
Cost Centers
Benzene Health Research Consortium Program Expense Summary 4Q05 Financial Report
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
o-.....J
Benzene Health Research Consortium Program Expense Summary 4Q05 Financial Report
r-------------~------~------------~~------------~,--~~~~,
Cost Centers
(J)
I
m
rr, s:
()
()
r
C
;a
G,)
o
(J)
I'V
..j:::o.
-.....J
Page 15 of 58
AUTODATE
.....lo.
Benzene Health Research Consortium Program Expense Summary 4Q05 Financial Report
RT 03/08/06
Amt.At UCHSC & Irons Field exp. Bank acct
$15,605,870 ($352,550)
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
247,035 1,063,761
318,580 3,102,202
131,000 2,500,000
131,000
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
.,j:::o.
-.....J
Page 16 of 58
AUTODATE
I'V
Benzene Health Research Consortium Program Expense Summary 4Q05 Financial Report
r-------------~------~------------~~------------~,--~~~~,
Cost Centers
LT 8/3/05
RT 03/08/06
API disbursed by period (includes pre-payments
for UCHSC & Irons Field)
1,500,000
100,942
570,889
IT IT 23,489,853
(J)
I
m
rr, s:
() ()
r
C
;a
G,)
o
(J)
I'V
.,j:::o.
-.....J Page 17 of 58 c..>
AUTODATE
Benzene Health Research Consortium UCHSC Grant 4Q05 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
..j:::o.
Page 18 of 58
AUTODATE
-.....J
..j:::o.
Benzene Health Research Consortium UCHSC Grant 4Q05 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
Page 19 of 58
AUTODATE
c-......n.J
UCHSC (x81 05) Cost Centers
LT 8/02105
BJ 8/02105 RT 02127/06
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
-.....J
(J)
Benzene Health Research Consortium UCHSC Grant 4Q05 Financial Report
1st & 2nd Otr.
2003 3r.d Otr.
4th Otr.
IstOtr.
2004
2nd Otr.
3rd Otr.
4th Otr.
IstOtr.
2005
2nd Otr.
3rd Otr.
4th Otr.
Am!. paid UCHSCto date:
Am!. expensed to date: Am!. In UCHSC bank acct:
(Adjusted 4003: $48,839 attr.ibuted 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 $13,761,880 study" in 2002)
(Adjusted 4003: 2001 costs had been double expensed in 2002 column; ($523,807) adjusment $13,778,460 made in 4003)
($16,580)
2QOSvariance adjusted to reflect only current qtr variance
bedgeted expense projections revised per 3 May 05 revised program budget
Page 20 of 58
AUTODATE
UCHSC (x81 05) Cost Centers
Benzene Health Research Consortium UCHSC Grant 4Q05 Financial Report
2006
2nd Olr.
3r.d Olr.
4lh Olr.
2007
2nd Olr.
3r.d Olr.
4lh Olr.
LT 8/02105
BJ 8/02105 RT 02127/06
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
-.....J -.....J
Page 21 of 58
AUTODATE
Benzene Health Research Consortium UCHSC Subcontract 4Q05 Financial Report
(J)
I
m LT 8/3/2005
r BJ 8/02105
rs:I RT 12102105
() ()
r
C
;a
G)
oI
(J)
I'V
.,j:::o.
-.....J ex>
"Total subcontracto r expenses" from study report (preliminary figure); "actual expenses" from UC Office of Grants & Contracts spreadsheet (final figures).
"2002 subcontractor costs not broken out by UCHSC, so this must be added back into the sum of row totals for total subcontractor costs to balance
$1,128,507
1331839
1351912
304797.5
Page 22 of 58
AUTODATE
Cost Centers
1st & 2nd
Benzene Health Research Consortium Irons Field Expenses 4Q05 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
$919,486 of 6/30105
G)
oI
(J)
I'V
..j:::o. Page 23 of 58
-.....J <D
AUTODATE
Cost Centers
2nd Olr.
3r.d Olr.
4lh Olr.
Benzene Health Research Consortium Irons Field Expenses 4Q05 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
Page 24 of 58
AUTODATE
ex>
o
IRONS T&E (X81 06) Cost Centers
LT 8/24/05 BJ 8/24/05 RT2I16/06
Amt Irons has spent:
Amt. In Irons bank acct:
Benzene Health Research Consortium Irons Field Expenses 4Q05 Financial Report
2003 15t & 2nd
Otr. 3rd Otr.
note -1005 &2005 expenses recprded in $872,369 2005
4th Otr.
15tOtr.
2004
2nd Otr.
3rd Otr.
4th Otr.
15tOtr.
2005
2nd Otr.
3rd Otr.
4th Otr.
15tOtr.
2006
2nd Otr.
3rd Otr.
4th Otr.
15tOtr.
$47,117
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
Page 25 of 58
AUTODATE
ex>
.....lo.
IRONS T&E (X81 06) Cost Centers
2007
2nd OIL
3rd OIL
4lh OIL
LT 8/24/05 BJ 8/24/05 RT2I16/06
Benzene Health Research Consortium Irons Field Expenses 4Q05 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
Page 26 of 58
AUTODATE
ex>
I'V
Cost Centers
1st & 2nd
Benzene Health Research Consortium AHS 4Q05 Financial Report
LT 8/3/05
BJ 4/05/05
(J) RT2I16/06
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
ex> c..>
Adjustment: expense reduced by $52,634; transferred to contingency since these were preconsortia expenses
$394,467
Page 27 of 58
AUTODATE
Cost Centers
15tOtr.
2nd Otr.
3rd Otr.
4th Otr.
Benzene Health Research Consortium AHS 4Q05 Financial Report
LT 8/3/05
BJ 4/05/05
(J) RT2I16/06
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
ex>
..j:::o.
Page 28 of 58
AUTODATE
Benzene Health Research Consortium Fudan 4Q05 Financial Report
LET 8/3/05 BJ 8/01/05
RT2I16/06
..
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
ecx..>n
2Q05 - variance zeroed outonly current cqtr variance shown 2Q05 - ezpense projections revi sed based on 3 May 05 approved budget
Page 29 of 58
AUTODATE
Benzene Health Research Consortium Fudan 4Q05 Financial Report
LET 8/3/05 BJ 8/01/05
RT2I16/06
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
ex>
(J)
Page 30 of 58
AUTODATE
Benzene Health Research Consortium
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
ex> -.....J
Benzene Health Research Consortium SRP + ERP 4Q05 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
ex>
Page 32 of 58
AUTODATE
ex>
2003
Benzene Health Research Consortium
2005
2006
2007
LT 8/3/05
BJ 4/05/05 RT 2116/06
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
ex>
<D
-
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 33 of 58
AUTODATE
Benzene Health Research Consortium SRP + ERP 4Q05 Financial Report
LT 8/3/05
BJ 4/05/05 RT 2116/06
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
<D
o
Page 34 of 58
AUTODATE
Cost Centers
Benzene Health Research Consortium Communications 4Q05 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~@j*!@m%%.!it::::::::::::::::::::::::.:.:..............................
C ~ - I::ludget adJustrnent retlects budget reduction
;a frorn $1 MM to $550k
G)
oI LT 8/3/05
(J) RT 1/21/05
I'V
..j:::o.
*budget adjustrnent to lower prograrn budget frorn $550K to
<D
.....lo.
Page 35 of 58
AUTODATE
Cost Centers
Benzene Health Research Consortium Communications 4Q05 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 8/3/05
(J) RT 1/21/05
I'V
..j:::o.
<D I'V
Page 36 of 58
AUTODATE
Benzene Health Research Consortium Communications 4Q05 Financial Report
1sl Olr. 2nd Olr. 3rd Olr. 4lh Olr*. I 1sl Olr.
1s101r.
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
Page 37 of 58
AUTODATE
<D
c..>
Benzene Health Research Consortium Communications 4Q05 Financial Report
2006 2nd Olr. 3rd Olr.
4lh Olr. 2 I 1sl Olr.
2007 2nd Olr. 3rd Olr.
4lh Olr.
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
..j:::o.
Page 38 of 58
AUTODATE
<D
..j:::o.
Cost Centers
Benzene Health Research Consortium Legal 4Q05 Financial Report
* budget adjustment to lower program budget from $500K to $1 OOK, as approved by OC on 11 III 103
LT 8/3/05 RT2I14/06
$54,081
$85,920 $7,810.86
variance adjusted to reflect only 2005 variance
2005 Budget revised from $100K to $140K per revised program budget approved 3 May 05
$01 $13,5651 $1, 7281
$01 $17, 9151
$3651 $2,9951 $1,8701 $26,0921 $4,8271
$16, 7691
$OF~1i?,11()1 $98,2351
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
.,j:::o. Page 39 of 58
c<.Dn
AUTODATE
Benzene Health Research Consortium Legal 4Q05 Financial Report
* budget adjustment to lower program budget from $500K to $1 OOK, as approved by OC on 11 III 103
LT 8/3/05 RT2I14/06
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V
.,j:::o.
<D
(J)
Page 40 of 58
AUTODATE
Benzene Health Research Consortium QA-QC 4Q05 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)
LT 8/3/05
I'V
..j:::o.
<D -.....J
Page 41 of 58
AUTODATE
Benzene Health Research Consortium QA-QC 4Q05 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)
LT 8/3/05
I'V
..j:::o.
<D
ex>
Page 42 of 58
AUTODATE
Cost Centers
Benzene Health Research Consortium API Administration 4Q05 Financial Report
(J)
I
m
r r
sI :
() ()
r
C
;a LT 8/1/05
G)
oI
(J)
I'V
..j:::o.
<D <D
Page 43 of 58
variance reflects 2Q05 variance, only
AUTODATE
Cost Centers
Benzene Health Research Consortium API Administration 4Q05 Financial Report
(J)
I
m
r r
sI :
() ()
r
C
;a LT 8/1/05
G)
oI
(J)
I'V
c..n o o
Page 44 of 58
AUTODATE
Cost Centers
RT 2114/06 Miii.&'M@~f:iiii.#ims.@!.i.'%MffuW~I~i:iir
Benzene Health Research Consortium API Administration 4Q05 Financial Report
3rd Otr. 4th
expenses revised to reflect 3 May 05 revised total program budget
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
c..n
Page 45 of 58
AUTODATE
o
.....lo.
API Cost Centers
2006
2nd Olr.
3rd Olr.
4lh Olr.
Benzene Health Research Consortium API Administration 4Q05 Financial Report
1s101r.
2007
2nd Olr.
3rd Olr.
4lh Olr.
RT 2114/06 Miii.&'M@~f:iiii.#ims.@!.i.'%MffuW~I~i:iir
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
c..n
Page 46 of 58
AUTODATE
o
I'V
Benzene Health Research Consortium Contingency Fund 4Q05 Financial Report
** to be reprogrammed as API expense in 3005
LT 8/3/05
RT 2/27/06
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V
c..n o
c..>
4003 Adjustment - per Technical Committee, transfer $48,839 from UCHSC expense detail to contingency because expenses not part of UCHSC grant budget:
Page 47 of 58
AUTODATE
Benzene Health Research Consortium Contingency Fund 4Q05 Financial Report
850,695
$156,391
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
I'V
c..n o
..j:::o.
Page 48 of 58
AUTODATE
Benzene Health Research Consortium Contingency Fund 4Q05 Financial Report
1. June 2001 $25K grant to UCHSC; seed money exhausted (API & sponsor), expense not included in final grant cost estimate
2. $3600 IRB fees to U of CO (this will be a yearly fee, since IRB must review at least once per year)
3. 2002 invoice ($20,239) from EMBSI for final feasibility study work (very late billing to API)
AHS - expense
transfer of
$52,634 from
AHS expense
detail to
contingency
because
expenses not
(J) part of AHS full I study budget
m
r r
sI :
() ()
r
C
;a
3496 46800 50296
7058 422
7480
G)
oI
(J)
Page 49 of 58
AUTODATE
I'V
c..n o c..n
LT 8/23/05 RT 2114/06
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI
(J)
cI'.Vn
o
(J)
$57,501
Page 50 of 58
AUTODATE
Benzene Health Research Consortium Income 4Q05 Financial Reoort
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
Page 51 of 58
AUTODATE
I'V
c..n
o
-.....J
Company Name BP
(Seed Money)
$15,000 $22,500
Inv.#
522922 528453
Date Paid
8-Nov-00 19-Jun-01
Benzene Health Research Consortium
Sponsor Invoice Detail 4Q05 Financial Report
2001
2002 (1 st - 2nd Otr.)
2002 (3rd - 4th Otr.)
22-Aug-01 Inv.# Date Paid $768,941 529301 4-0ct-01
9-Jan-02 $806,441
Inv.# Date Paid 532263 22-Feb-02
27-Aug-02
$1,344,069 $112,008
Inv.# Date Paid
535033 11-0ct-02 2-0ct-02
2003
23-Sep-03
Inv.#
$1,431,041.00 544951
~nevron
"I ::>,uuul ::>LL~L.:\I (-I\lOV-UU
,,::>LL,DL{ ::>L~.:\uLI
~-UCI-UI
,,::>.:\{ ,DL{ ::>.:\LL44 I LL-~ eD-uLI
,,/j~D,U4DI ::>.:\::>u.:\41 ::>-I\lOV-ULI
,,1,UL/j,{Uu.uul ::>44~::>':\
ConocoPhillips
$15,000 522924 31-0ct-00 $7,500 528574 31-Jul-01
$246,314 529309 17-Sep-01
$268,814 532245 16-Jan-02
$448,023 535035 26-Sep-02
$514,349.00 544954
ExxonMobii
$0 523540
$1,612,882 $806,441 $806,441
532246
23-Jan-02 11-Feb-02
$1,344,069 535036 13-Sep-02
$1,543,049.00 544956 $771 ,524.50 $771 ,524.50
Shell
$15,000 523054 24-0ct-00 $15,000 528333 15-May-01
$507,627 529305 25-Sep-01
$537,627 532247 7-Feb-02
$896,046 $448,023 $448,023
535037
25-Sep-02 10-Feb-03
$1,028,700.00 544958 $514,350 $514,350
Marathon
Total
$15,000 528541 14-Aug-01
$120,000
$2,045,509
$5,376,273
Marathon Ashland Marathon Oil
$5,936,307
$150,000 548582 $50,000 548581
$8,317,588.00
I I 2006
Company Name
tW
invdate Inv.#
:pu.uu
Projected Invoicing 2007
Date Paid
inv date
Inv.#
:pu.uu
Date Paid
Projected
TOTALS $7,O68,5411
Chevron
$911,959
(J)
ConocoPhillips
$308,182
I
m ExxonMobii
r r
s:I Shell
()
$1,093,939 $911,959
()
r
C Marathon
;a
G)
oI
(J)
I'V
c..n o ex>
$435,071 $0.00
$652,606
$435,071
$4,712,364 $2,356,182 $7,068,545
$4,712,364 $215,00(J
Page 52 of 58
AUTODATE
Benzene Health Research Consortium
Sponsor Invoice Detail 4Q05 Financial Report
2005
PAID
Date Paid 4-0ec-03
27-Jan-05
Inv.# Date Paid
$2,568,545.00 563928 11-Jul-0!::
TOTALS $7,068,545
1~-I\lOV-U.:I1
".:ID!:>,.:I.:I4.uul !:>DUU!:>DI '~-JU'-U91
;p~,~\):>,~~q
27-0ct-03
3-0ct-03 22-Mar-04
$548,000.00 560057 18-Mar-!::l1
II
$548,000.00 560058 17-Feb-0 $274,000.00 564774 27-0ec-0!::
$2,048,000 $5,048,000
28 Oct 03 14 Jan 04
$365,334.00 560059 28-Apr-0!::
$3,365,334
20-Jan-04 3-Feb-04
$4,669,213.00
II $215,000
II II $21,110,213
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
Page 53 of 58
AUTODATE
c..n
o
<D
IT _0_ i
LT 8/18/05 RT 07/15/05
iVSX!.".".., .'vI!,a,"V,~~
Benzene Health Research Consortium
Sponsor Invoice Detail 4Q05 Financial Report
.$..1., 6!5e2'v2,,."77A48
!
! "Wi!' 1OS" KXJ
(J)
I
m
r r
si :
()
()
r
C
;a
G)
oi
(J)
I'V
Page 54 of 58
AUTODATE
c..n
.....lo.
o
Benzene Health Research Consortium Sponsor Payment Detail 4Q05 Financial Report
(J)
I
m
r
s:r I
$ 2,933,879.00
()
()
r
C $21,384,214.09
;a
G)
oI
(J)
I'V
c..n
Page 55 of 58
AUTODATE
.....lo.
.....lo.
Benzene Health Research Consortium Sponsor Payment Detail 4Q05 Financial Report
(note - does not include interest
LT 8/3/0511111m1m1l1l11l1lllllllllmllllllincome)
RT ~ 2114/06
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
I'V
c..n
Page 56 of 58
AUTODATE
.....lo.
I'V
BHRC Sponsor Payments
r. ."". d by Sponsor Company
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. BP p.Lc.
11/8/2000 $ 6/19/2001 $ 10/4/2001 $ 2/22/2002 $ 10/2/2002 $ 10/11/2002 $ 12/4/2003 $ 7/11/2005 $
15,000.00 22,500.00 768,941.00 806,441.00 112,008.00 1,344,069.00 1,431,041.00 2,568,545.00
$
BP Total 7,068,545.00
Chev ronTexaco 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 $ 7/19/2005 $
15,000.00 522,627.00 537,627.00 896,046.00 1,028,700.00 365,334.00
ChevronTexaco Total $ 3,365,334.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
10/3/2003 $ 771,524.50
ExxonMobil
3/22/2004 $ 771,524.50
ExxonMobil Total
ExxonMobil
2/17/2005 $ 548,000.00
(J)
I
ExxonMobil
12/27/2005 $ 274,000.00 $
5,322,000.00
m Marathon Ashland Petroleum, LLC. 8/14/2001 $ 15,000.00
r r
Marathon Ashland Petroleum, LLC.
1/20/2004 $ 150,000.00 Marathon Ashland Total
s:I Marathon Oil Company
2/3/2004 $ 50,000.00 $
215,000.00
() Shell Chem ical
10/24/2000 $ 15,000.00
() Shell Chem ical
r
C
Shell Chem ical
;a
5/15/2001 $ 15,000.00 9/25/2001 $ 507,627.00
G)
oI
(J) Page 57 of 58 I'V
c..n
.....lo.
c..>
AUTO DATE
Shell Chem ical Shell Chem ical Shell Chem ical Shell Chem ical Shell Chem ical Shell Chem ical
LT 8/3/05 RT 2/14/06
2/712002 $
BHRC Sponsor Payments
537,~29~Zfld by Sponsor Company
9/25/2002 $ 2/10/2003 $ 10/28/2003 $ 1/13/2004 $ 4/28/2005 $
448,023.00
448,023.00
I514,350.00
514,350.00
Shell Chemical Total
365,334.00 $
3,365,334.00
$ 21,384,214.09
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J)
Page 58 of 58
AUTODATE
I'V
c..n
.....lo.
..j:::o.