Document zz7OQwQKgzZovBzvdmjwjw0k3
Benzene Health Research Consortium Executive Summary
1a07 Financial Report
Cost Centers
Project #
Actuals Inception
Thru
December 2004
Actuals
Jan - Dec 2005
ACTUALS
Actuals
Jan - Dec 2006
Actuals
Jan - March 2007
Actuals
Program to Date
Income
$ 16,765,693 $ 5,206,657 $ 6,938,163 $
$ 28,910,513
Cost Centers
UCHSC* Irons-Field Expense* Applied Health Sciences Fudan University
X8105 X8106 X8107 X8108
10,137,850 788,486
1,391,014 124,090
3,624,030 262,000 548,720 4,007
4,000,000 262,000 558,214 76,377
570,889 112,560
18,332,769 1,312,486 2,610,508 204,474
13,778,460 990,282
Scientific & Ethics Panels Communications Outside Legal Counsel QAlQC Support API Administrative Exposure Assessment Contingency**
X8109 X8103 X8104 X8110 X8100 x8111
181,713 294,161
64,529
856,208
104,473
76,176 33,706 170,475 51,918
95,418
39,154 1,202
160,782 12,324
3,975
13,891 56
30,741 4,583
357,283 294,161 151,280
1,258 1,218,207
16,907 156,391
Total Expenses
$ 13,942,525 $ 4,771,033 $ 5,205,472 $ 736,695 $ 24,655,725
Fund Balance
$ 2,823,169 $ 3,298,247 $ 5,030,938 $ 3,859,172 $ 4,294,243
PROJECTED 2007
Jan - March
$
570,889 100,942 159,952
4,500
17,811 4,167
47,000 30,000
$ 935,261
(J)
I
::w:!:y.:::I.$.::p.rgj@9!~:::fy.D.~:::~?I.~ij.]9.:::::::::::::::r::
m * amount disbursed by API
r r
** $300K added to contingency;
s:I $250K from Communicaitons & $50K
() from QAlQC
()
r
C
;a
G)
oI c..n
<D
.....lo.
c..n
..j:::o.
Page 9 of 62
AUTO DATE
Benzene Health Research Consortium Executive Summary
1a07 Financial Report
PROJECTED
PROJECTED 2007
Jan - Dec
$ 7,000
570,889 100,942 502,311
80,704
96,726 1,946
71,242 16,667 225,450 69,000
$ 1,735,877
IBUDGET
PROJECTED Incomel r--"P:r"o"gr'a"m----,
Expense
Budget
Income
28,917,513 1$ 26,429,202 I
Expenses
18,332,769 1,312,486 2,952,867 285,178
18,332,769 1,413,428 2,930,841 379,829
449,509
473,142
296,107
300,000
204,711
180,000
13,758
50,000
_-_1,396,657 1,445,205
55,907
109,000
156,391 ...... 814,98...8....
$ 25,456,341 I $ 26,429,202 I
$ 979,861
(J)
I
m
r r
Income Detail
s:I
sponsors
28,399,312
()
MAP contrib.
$215,000
()
r
C
;a
G)
oI c..n
<D
.....lo.
c..n c..n
Page 10 of 62
AUTODATE
*** ConocoPhillips pay remaining commitment in
2005
LT 8/3/05 RW 2/20106 RT 7/19/06 rdw 10/19/06
DRAFT
Benzene Health Research Consortium Executive Summary
1a07 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
c..n
Page 11 of 62
AUTODATE
<D
.....lo.
c..n
(J)
API interest UCHSC interest
TOTAL
220,000 76,202
$28,910,513
Benzene Health Research Consortium Executive Summary
1a07 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
c..n
Page 12 of 62
AUTO DATE
<D
.....lo.
c..n
-.....J
Benzene Health Research Consortium Cash Flow Statement 1007 Financial Report
15t - 4th Otr.
15t - 4th Otr. I 15t - 4th Otr. I 15t & 2nd Otr.
2003 3rd Otr.
4th Otr.
15tOtr.
2004
2nd Otr.
3rd Otr.
4th Otr.
15tOtr.
2005
2nd Otr.
3rd Otr.
4th Otr.
15tOtr.
20' 2nd Otr.
Income for Reporting Period Income, Cumulative
60,246 60,246
2,113,1321 8,367,446 2,173,378 10,540,824
448,0241
3,1861 4,265, 241 1 1,485, 875 1
6, 746 1
6, 506 1
9, 292 1 1,096,01
372, 143 1 3,009, 787 1 728, 727 1
-I 1,934,291
10,988,848 10,992,034 15,257,275 16,743,149 16,749,895 16,756,401 16,765,693 17,861,693 18,233,836 21,243,623 21,972,350 21,972,350 23,906,641
:~!~M!~~~~!m:Bii@i!\~W::::::::':""
}~~!J:!j!!::~:~!!!!)~~r:::::::::':"'"
.............. 1 in bank at INOTE: 2,548,996 API
This number does not agree with the executive
summary because it is based on actuals, not
LT 8/23/05
DRAFT
RT 7/19/06
$372,143
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
ocI.n
13 of 62
AUTODATE
<D
....l:.
c.n
ex>
Benzene Health Research Consortium Cash Flow Statement 1007 Financial Report
28,917,513 24,057,141
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
c..n
14 of 62
AUTODATE
<D
.....lo.
c..n
<D
Cost Centers
Benzene Health Research Consortium Program Expense Summary 1Q07 Financial Report
3rd Olr
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI c..n
<D
.....lo.
(J)
o
Benzene Health Research Consortium Program Expense Summary 1Q07 Financial Report
r-------------~------~------------~~--------------~,--~~~~,
Cost Centers
(J)
I
m
rr, s:
()
()
r
C
;a
G,)
o c..n
<D
.....lo.
(J)
Page 16 of 62
AUTODATE
.....lo.
Benzene Health Research Consortium Program Expense Summary 1Q07 Financial Report
RT 7/19/06
Amt.At UCHSC & Irons Field exp. Bank acct
21,314,021 ($235,610)
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
244,006
2,160,301
327,707
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
ocI.n
<D
....lo.
(J)
Page 17 of 62
AUTODATE
I'V
Benzene Health Research Consortium Program Expense Summary 1Q07 Financial Report
r-------------~------~------------~~--------------~,--~~~~,
4th Ote.
LT 8/3/05
RT 7/19/06
API disbursed by period (includes pre-payments
for UCHSC & Irons Field)
2,473,458
736,695
55,000
45,942
IT 24,422,549
(J)
I
m
rr, s:
()
()
r
C
;a
G,)
oc.n
<D
....lo.
(J) Page 18 of 62
c..>
AUTODATE
Cost Centers
Benzene Health Research Consortium UCHSC Grant 1Q07 Financial Report
15t - 4th Ote. I 15t - 4th Ote. 11 5t & 2nd Otr
3rd Otr
4th Otr
15tOtr
2nd Otr
3rd Otr
4th Otr
15tOtr
2nd Otr
3rd Otr
4th Otr
954 954
123,629
123,629
76,940 77,894
1,795,030 1,025,372
769,658
39,523 117,417
549,014
108,346 225,763
988,733 565,870 422,863
225,763
(J)
I
m
r UCHSC r statement
s:I error for travel, off by +$105
() (4003)
()
r
C
;a
G)
oI c..n
<D
.....lo.
Page 19 of 62
AUTODATE
(J)
..j:::o.
Benzene Health Research Consortium UCHSC Grant 1Q07 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI c..n
<D
.....lo.
Page 20 of 62
AUTODATE
(J)
c..n
UCHSC (x81 05) Cost Centers
LT 8/02105
BJ 8/02105 RT 7/19/06
DRAFT (J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI c..n
<D
.....lo.
(J) (J)
Benzene Health Research Consortium UCHSC Grant 1Q07 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 21 of 62
AUTODATE
Cost Centers
Benzene Health Research Consortium UCHSC Grant 1Q07 Financial Report
15tOtr.
2nd Otr.
3rd Otr.
4th Otr.
3rd Otr.
4th Otr.
LT 8/02105
BJ 8/02105 RT 7/19/06
DRAFT (J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI c..n
<D
.....lo.
(J)
-.....J
Page 22 of 62
AUTODATE
Benzene Health Research Consortium UCHSC Subcontract 1007 Financial Report
(J)
I
m LT 8/3/2005
r BJ 8/02105
rs:I RT 7/19/06
()
()
r
C
;a
G)
I
0c..n
<D
.....lo.
(J)
ex>
DRAFT
"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 23 of 62
AUTODATE
Benzene Health Research Consortium Irons Field Expenses 1Q07 Financial Report
4th Otr
15tOtr
43 63,511
48,782
(114,098) 11,563
43
63,554
112,336
13,035 24,598
(C)1}}~lljjl!} :::::::::::::::::::::::::::::::::::: .................... :::::::::::::::::::::::::::::::::
3,200 262,260 400:6i91469,7981 525,306 .''.''.5'.'.8'.'.0'.',.'8.'.'1.'.'4.'.''.1'.'.'6.'.'3.'.'.6'.'.,'.3'.'.2,.,.2,1
3,157 198,706 288,283
342,665
512,270 556,215 651,624
43
03,004
11<',330
1<'1,133
13,U30
<'4,0~~
(10,3U3)
55,508 41,404
747,3381 761 ,442 (14,1U4)
802,846 761 ,442
41,4U4
12,020
55,507
(8,891)
33,709
..................................
i,024,878 1 1,080,38611,135,893
1,033,769
(~,~~1)
1,102,184 1,102,184
(<'1 ,f~~)
33,fU~
4Q03 ADJUSTME NT2001/2002 expense underrecord ed; <$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 c..n
<D
.....lo. Page 24 of 62
(J)
<D
AUTODATE
Cost Centers
2nd Olr.
3r.d Olr.
4lh Olr.
Benzene Health Research Consortium Irons Field Expenses 1Q07 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI c..n
<D
.....lo.
Page 25 of 62
AUTODATE
o-.....J
Cost Centers
LT 8/24/05 BJ 8/24/05
RT 7/19/06
DRAFT
Amt Irons has spent:
Amt. In Irons bank acct:
RT: See comments in cells M22 and M23
Benzene Health Research Consortium Irons Field Expenses 1Q07 Financial Report
Otr. 3rd Otr. note -1005 &2005 expenses recprded in
$872,369 2005
4th Otr.
1st Otr. 2nd Otr. 3rd Otr. 4th Otr. 1st Otr. 2nd Otr. 3rd Otr. 4th Otr.
IstOtr.
2nd Otr.
3rd Otr.
4th Otr.
$47,117
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI c..n
<D
.....lo.
Page 26 of 62
AUTODATE
-.....J
.....lo.
IRONS T&E (X81 06) Cost Centers
2007
2nd OIL
3rd OIL
4lh OIL
LT 8/24/05 BJ 8/24/05
RT 7/19/06
DRAFT
Benzene Health Research Consortium Irons Field Expenses 1Q07 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI c..n
<D
.....lo.
Page 27 of 62
AUTODATE
-.....J
I'V
Benzene Health Research Consortium AHS 1Q07 Financial Report
LT 8/3/05
BJ 4/05/05
(J) RT2I15/07
I
m
r r
sI :
() ()
r
C
;a
G)
oI c..n
<D
.....lo.
-.....J c..>
DRAFT
Adjustment: expense reduced by $52,634; transferred to contingency since these were preconsortia expenses
535,167 Page 28 of 62
547,953
AUTODATE
Cost Centers
2nd Ole.
3rd Ole.
4lh Ole.
Benzene Health Research Consortium AHS 1Q07 Financial Report
LT 8/3/05
BJ 4/05/05
(J) RT2I15/07
I
m
r r
sI :
() ()
r
C
;a
G)
oI c..n
<D
.....lo.
-.....J
..j:::o.
502,311
Page 29 of 62
AUTODATE
Benzene Health Research Consortium Fudan 1Q07 Financial Report
LET 8/3/05 BJ 8/01/05
rdw 10/19/06
RT 10/26/06
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
ocI.n
<D
....lo.
c-.....n.J
DRAFT
~~,f13
o~,<'40
fO,034
1~,4of
1~,4of
4U,<'~<'
4U,<'~<'
fO,oof
fO,oof I 1<'3,f~3
in 2001 $.
4f,410
2Q05 - variance zeroed outonly current cqtr variance shown
2Q05 - ezpense projections revi sed based on 3 May 05 approved budget
Page 30 of 62
AUTODATE
Benzene Health Research Consortium Fudan 1Q07 Financial Report
LET 8/3/05 BJ 8/01/05
rdw 10/19/06
RT 10/26/06
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI c..n
<D
.....lo.
-.....J
(J)
Page 31 of 62
AUTODATE
Benzene Health Research Consortium
Actual expense CurrentVariance Cumm Variance
H.m;;I<:':':':'",, .
Budgeted Actual expense CurrentVariance
2,160 2,160
2,160 2,000
160
8,640 10,800
4,320 15,120
2,160 17,280
7,334 (7,012) 10,268
8,640 4,320 8,640 4,320
2,160 2,160
322 4,454 (4,132)
(10,268)
(11,148) (11,148)
3,338 250 4,662 250 4,912
250 3,000 415
250 2,585
4,912
4,912
250 5,162
250
250
7,698 302
5,464
3,000
3,000
5,464
5,464
7,894 588
6,052
3,900
3,900
(J)
I
m
rr II
s:()
r I()
Actual expense CurrentVariance Cumm Variance
Budgeted Actual expense
C
;a
CurrentVariance Cumm Variance
G)
I
0c.n
<D
....lo.
-.....J -.....J
1,250 910 910
2,160
2,160 I
I I8,640 4,320
2,160
9,550 13,870 16,030
8,640 4,320
8,640
322 16,352
2003
Benzene Health Research Consortium 2005
2nd Qtr
2006
LT 8/3/05
BJ 4/05/05
rdw 10/19/06 RT 2115/07
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI c..n
<D
.....lo.
-.....J ex>
DRAFT
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 62
AUTODATE
Benzene Health Research Consortium Communications 1a07 Financial Report
.",,,,,,"u ...,,,ATIONS (X81 03) Cost Centers
2001
2002 1st - 4th 11st & 2nd
1st - 4th Otr.1 Otr.
Otr.
2003 3rd Otr.
4th Otr. 2 I 1st Otr.
2004 2nd Otr. 3rd Otr.
4th Otr*. I 1st Otr.
2005 2nd Otr. 3rd Otr.
4th Otr. I 1st Otr.
I Budgeted Actual expense CurrentVariance Cumm Variance
57,600 230,400 120,000 60,000 (187,396) 14,401 14,400 14,400 (39,906)
232,229 14,483
7,351
26,541
790 1,235 1,270
57,600 (1,829) 105,517 52,649 (213,937) 14,401 13,610 13,165 (41,176)
57,600 55,771 161,288 213,937
(0) 14,401 28,011 41,176 (0) (0) (0) (0) (0) (0)
I Budgeted Actual expense CurrentVariance Cumm Variance
1,800
7,200
3,750
1,875
(5,876)
450
450
450 (1,350)
7,091
526 1,132
1,800
109 3,750 1,349 (7,008)
450
450
450 (1,350)
1,800
1,909
5,659
7,008
0 450 900 1,350
0
ooooo
I Budgeted Actual expense CurrentVariance Cumm Variance
IRlldgeted ual expense
CurrentVariance Cumm Variance
600
600 000
$0.00 $0.00 $0.00 $0.00
2,400 1,417
983 1,tl83
$0.00 $0.00 $0.00 $0.00
1,250 80
1,170 ',/tl3
$0.00 $0.00 $0.00 $0.00
625
625 3,3/8
$0.00 $0.00 $0.00 $0.00
(3,364) 15
(3,379) (')
$0.00 $0.00 $0.00 $0.00
150
150 148
$0.00 $0.00 $0.00 $0.00
150
150 '88
$0.00 $0.00 $0.00 $0.00
150
150 448
$0.00 $0.00 $0.00 $0.00
(448)
(448)
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
1,946
1,946 1,841
$0.00 $0.00 $0.00 $0.00
1,841
$0.00 $0.00 $0.00 $0.00
IRlldgeted ual expense
CurrentVariance Cumm Variance
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
IRlldgeted ual expense
CurrentVariance Cumm Variance
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
IRlldgeted
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
ual expense
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
CurrentVariance
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Cumm Variance
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
':':':':':':'2001 :':':':':': ':':':':':200-2 :':':': ':':':':':':':':':':':':':':':':':':':':':':':':':':2003:':''''''
6(),()QClT24Cl,O()() 125,()()() 62,500 (196, (36) 15,001 15,000 15,000 (41,704)
1,946
Actual expense
240,738 14,564
7,877
27,688
790 1,235 1,270
CurrentVariance
(738) 110,436 54,623 (224,324) 15,001 14,210 13,765 (42,974)
1,946
(J) Cumm Variance
I
mr
r
Expense Variance
59,262 169,699 224,322
(2)
~~~:~~fl ~~r~~~=u~}~~~:~~ci:':':':':' :':':':':'2002:':''''''' ,.,..............................................----........
6Q,()O()_1
00,000
tl8,'0' 108,088
(')
14,999
305,8651 290,866
14,888
29,209
320,8651 291,656
'8,'08
42,974
335,8651 292,891
4',8/4
o o o o 1,946 1,946
I I I I294,161 294,161 294,161 294,161 296, 107 1 296,107
294,161
294,161
294,161
294,161
294,161 294,161
1,840
1,840
s:I - I elecommunlcallons, consulting :services, 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 adjustment retlects budget reduction
;a from $1 MM to $550k
G)
c.noI LT 8/3/05 RT 1/21/05
<D
....lo.
-.....J <D
*budget adjustment to lower program budget from $550K to
Page 34 of 62
AUTODATE
Actual expense CurrentVariance Cumm Variance
Actual expense CurrentVariance Cumm Variance
Actual expense CurrentVariance Cumm Variance
Benzene Health Research Consortium Communications 1a07 Financial Report
oo
1,841
1,841
Actual expense
CurrentVariance
(J) Cumm Variance
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 adjustment retlects budget reduction
;a from $1 MM to $550k
G)
c.noI LT 8/3/05 RT 1/21/05
<D
....lo.
oex>
Page 35 of 62
AUTODATE
DRAFT
Benzene Health Research Consortium Communications 1a07 Financial Report
1s1 & 2nd
2003
Olr. 3rd Olr.
4lh OIr. 2 I 1s101r.
2004 2nd Olr. 3rd Olr.
4lh Olr*. I 1s101r.
2005 2nd Olr. 3rd Olr.
4lh Olr. I 1s101r.
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI c..n
<D
.....lo.
Page 36 of 62
AUTODATE
ex>
.....lo.
DRAFT
Benzene Health Research Consortium Communications 1a07 Financial Report
4th Otr. 2
3rd Otr. 4th Otr.
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI c..n
<D
.....lo.
Page 37 of 62
AUTODATE
ex>
I'V
Benzene Health Research Consortium Legal 1007 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 RT2I15/07
DRAFT
$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
$01 $12, 1101 $98,2351
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
ocI.n
<D
....lo. Page 38 of 62
ex> c..>
AUTODATE
Benzene Health Research Consortium Legal 1007 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 RT2I15/07
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
ocI.n
<D
....lo.
ex>
.,j:::o.
Page 39 of 62
AUTODATE
Actual expense CurrentVariance Cumm Variance
Actual expense CurrentVariance
Benzene Health Research Consortium QA-QC 1Q07 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 c..n
LT 8/3/05
<D
.....lo.
ecx..>n
DRAFT
Page 40 of 62
AUTODATE
Actual expense CurrentVariance Cumm Variance
Actual expense CurrentVariance
Benzene Health Research Consortium QA-QC 1Q07 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 c..n
LT 8/3/05
<D
.....lo.
ex>
(J)
Page 41 of 62
AUTODATE
RT 2115/07
Benzene Health Research Consortium QA-QC 1Q07 Financial Report
1sl Olr. 2nd Olr. 3rd Olr.
1sl Olr. 2nd Olr. 3rd Olr. 4lh Olr. I 1sl Olr. 2nd Olr. 3rd Olr. 4lh Olr.
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI c..n
<D
.....lo.
Page 42 of 62
AUTODATE
ex>
-.....J
QC7
I TOTALS
co:enters
r3rd Olr. 4lh Olr.
RT 2115/07
Benzene Health Research Consortium QA-QC 1Q07 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI c..n
<D
.....lo.
Page 43 of 62
AUTODATE
ex>
ex>
Cost Centers
Actual expense CurrentVariance Cumm Variance
Actual expense CurrentVariance Cumm Variance
Actual expense CurrentVariance
Cumm Variance
Actual expense CurrentVariance Cumm Variance
Actual expense CurrentVariance Cumm Variance
Actual expense CurrentVariance
(J)
I
m
r r
sI :
() ()
r
C
;a LT 8/1/05
G)
oI c..n
<D
.....lo.
ex>
<D
DRAFT
Benzene Health Research Consortium API Administration 1Q07 Financial Report
Page 44 of 62
variance reflects 2Q05 variance, only
AUTODATE
Cost Centers
Actual expense CurrentVariance Cumm Variance
Actual expense CurrentVariance Cumm Variance
Actual expense CurrentVariance
Cumm Variance
Actual expense CurrentVariance Cumm Variance
Actual expense CurrentVariance Cumm Variance
Actual expense CurrentVariance
(J)
I
m
r r
sI :
() ()
r
C
;a LT 8/1/05
G)
oI c..n
<D
.....lo.
<D
o
Benzene Health Research Consortium API Administration 1Q07 Financial Report
Page 45 of 62
AUTODATE
Benzene Health Research Consortium API Administration 1Q07 Financial Report
API Cost Centers
2003
2004
2005
I 1s1 & 2nd
Olr. Olr.
Olr.
Olr. 3rd Olr. 41h Olr. 1sl Olr. 2nd Olr. 3rd Olr. 41h Olr. 1sl Olr. 2nd Olr. 3rd Olr. 41h Olr.
1sl Olr.
budgeled
expenses
revised 10
reflecl3
May 05
revised
lolal
program
RT 2115/07
budgel
Miii.&'M@~f:iiii.#ims.@!.i.'%MffuW~I~i:iir
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI c..n
<D
.....lo.
Page 46 of 62
AUTODATE
<D
.....lo.
Cost Centers
RT 2115/07 Miii.&'M@~f:iiii.#ims.@!.i.'%MffuW~I~i:iir
Benzene Health Research Consortium API Administration 1Q07 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI c..n
<D
.....lo.
Page 47 of 62
AUTODATE
<D
I'V
Benzene Health Research Consortium Exposure Assess 1007 Financial Report
rdw 10/19/06 RT 2/15/07
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI c..n
<D
.....lo.
<D c..>
Benzene Health Research Consortium Contingency Fund 1007 Financial Report
101,473 101,473 101,473 188,799 188,799 188,799
155,191 155,191 435,081 850,695
156,391 156,391 156,391 850,695 850,695 840,900
Current quarter expense Remaining funds
** to be reprogrammed as API expense in 3005
LT 8/3/05
RT 7/19/06
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI c..n
<D
--lo.
<D
..j:::o.
DRAFT
4003 Adjustment - per Technical Committee, transfer $48,839 from UCHSC expense detail to contingency because expenses not part of UCHSC grant budget:
Page 49 of 62
Total program budget as of 1007
814,988 AUTODATE
Benzene Health Research Consortium Contingency Fund 1007 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
c..n
Page 50 of 62
AUTODATE
<D
.....lo.
<D
c..n
Benzene Health Research Consortium Contingency Fund 1007 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
(J) feasibility
I
m
r
study work (very late
r billing to
s:I API)
()
()
r
C
;a
G)
I
0
c..n Page 51 of 62
<D
.....l.
<D
(J)
AUTODATE
E
t:
0
.:_::J C0)l..
t:a:
0_
o(CJ) .(C-.O)
o ffi
..c .~
2LL
COr--0)0
~a
a:"-
._.c"Oc
- :::J
ffiLL
I
0)
g>-
C 0)
0) Ol
CN .C-
o0
al
)-
llJ f-
ooe:(
f::J
e:(
C\I <D
'0
C\I
L()
0) Ol CO
D....
SHELL-MCCLURG-059197
AHSexpense transfer of $52,634 from AHS expense detail to contingency because expenses not part of AHS full study budget
Benzene Health Research Consortium Contingency Fund 1007 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
c..n
Page 53 of 62
AUTODATE
<D
--lo.
<D
ex>
Benzene Health Research Consortium Income 1007 Financial Reoort
I:::INCOME}:':':,',',',, .
Sponsor Payments API Interest UCHSC Interest
I::TOTALS:::::':'''',',,,,
Reporting Period Cumulative
60,246 2,173,378 1 10,540,824 10,988,8481 10,992,0341 15,257,2751 16,743,1491 16,749,8951 16,756,401 16,765,6931 17,861,693 1 18,233,836 1 21,243,623 1 21,972,350
projected income
LT 8/23/05 rdw 10/1 9/06 RT 2115/07
DRAFT
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
c..n
Page 54 of 62
AUTODATE
<D
.....lo.
<D <D
21.972.350 23.698.294
Benzene Health Research Consortium
... __ _
, - r -,r t~_ "w ._._
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
c..n
Page 55 of 62
AUTODATE
<D
oI'V
o
Company Name BP
(Seed Money)
Inv.# Date Paid
$15,000 522922 8-Nov-00 $22,500 528453 19-Jun-01
Benzene Health Research Consortium
Sponsor Invoice Detail 1a07 Financial Report
2001
2002 (1 st - 2nd Otr.)
2002 (3rd - 4th Otr.)
22-Aug-01 Inv.# Date Paid $768,941 529301 4-0et-01
9-Jan-02 $806,441
Inv.# Date Paid 532263 22-Feb-02
27-Aug-02 Inv.# Date Paid
$1,344,069 535033 11-0et-02
$112,008
2-0et-02
2003
23-Sep-03
Inv.#
$1,431,041.00 544951
I~nevron
"I ::>,uuul ::>LL~L.:\I {-I\lOV-UU
,,::>LL,DL{ ::>L~.:\ULI
~-uel-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-0et-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 532246 $806,441 $806,441
23-Jan-02 11-Feb-02
$1,344,069 535036 13-Sep-02
$1,543,049.00 $771 ,524.50 $771 ,524.50
544956
Shell
$15,000 523054 24-0et-00 $15,000 528333 15-May-01
$507,627 529305 25-Sep-01
$537,627 532247 7-Feb-02
$896,046 535037 $448,023 $448,023
25-Sep-02 10-Feb-03
$1,028,700.00 $514,350 $514,350
544958
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 $50,000
$8,317,588.00
548582 548581
I Projected Invoicing Amendment No.3
I 2006
2007
Company Name Itst'
inv date Inv.# Date Paid
$lJ.UU
invdate
Inv.# Date Paid
$V.UU
Projected
TOTALS
~7,O68,545
It,;nevron
,,~ll ,~::>~ ::>f::>U44 lu-vel-Vb
,,40::>,UI1 ::>tH {bZ
:R, fl :l,;Sti4
(J)
ConocoPhillips
$308,182 575045 19-Jun-06
$0.00
$2,356,182
I
m ExxonMobii
$1,093,939 575042 31-May-06
$652,606 581763 28-Feb-07 $7,068,545
r r
s:I Shell
() ()
$400,000 571301 $511,959 575043
3-Mar-06 2-Jun-06
$435,071
31-Jan-07
$4,712,364
r
C Marathon
;a
$0
$0 $215,000
G)
oI c..n
<D Page 56 of 62
oI'V
.....lo.
AUTODATE
Benzene Health Research Consortium
snnn~nr Invoice Detail 1a07 Financial R",nnrt
2005
2006
4-Apr-06
PAID TOTALS
26133
25859
(J) 274
I
m
r r
sI :
()
()
r
C
;a
G)
oI
c..n
<D
Page 57 of 62
AUTODATE
oI'V
I'V
If. .II biVILCII
LT 8/18/05 RT 7/19/06
.. nn!.-o'sI>JV",iiu!,u~u'l
DRAFT
Benzene Health Research Consortium
Sponsor Invoice Detail 1a07 Financial Report
"$11,5e-x2"2,'774A68!1
!
! $"W26i!,11"33,n00n'J1
(J)
I
m
r r
si :
()
()
r
C
;a
G)
oi
c..n
<D
Page 58 of 62
AUTODATE
oI'V
c..>
Benzene Health Research Consortium Sponsor Payment Detail 1007 Financial Report
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI c..n
<D I'V
Page 59 of 62
AUTODATE
o
..j:::o.
Benzene Health Research Consortium Sponsor Payment Detail 1007 Financial Report
LT 8/3/05 RT 7/19/06
DRAFT
(note - does not include interest income)
$24,610,253.09
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI c..n
<D I'V
Page 60 of 62
AUTODATE
o
c..n
BHRC Sponsor Payments
."". Sponsor Company - 1Q07
Company American Petroleum Institute
Date Paid Amount 1/17/2003 $
( am trying to get this $1.09
1.09 removed 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.
10/2/2002 $ 112,008.00
BP p.Lc.
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 Chevron
11/7/2000 $ 10/9/2001 $ 2/22/2002 $ 11/5/2002 $ 11/19/2003 $ 7/19/2005 $ 10/10/2006 $
15,000.00 522,627.00 537,627.00 896,046.00 1,028,700.00 365,334.00 911,959.00
ChevronTexaco Total $ 4,277,293.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
10/27/2003 $ 514,349.00
ConocoPhillips Total
ConocoPhillips ConocoPhillips
3/18/2005 $ 6/19/2006 $
548,000.00 308,182.00 $
2,356,182.00
ExxonMobil Research and Engineering 1/23/2002 $ 806,441.00
ExxonMobil Research and Engineering 2/11/2002 $ 806,441.00
ExxonMobil
9/13/2002 $ 1,344,069.00
ExxonMobil
10/3/2003 $ 771,524.50
(J)
I
ExxonMobil
3/22/2004 $ 771,524.50
ExxonMobil Total
m ExxonMobil
2/17/2005 $ 548,000.00
r r
ExxonMobil
12/27/2005 $ 274,000.00
s:I ExxonMobil
5/31/2006 $ 1,093,939.00 $
6,415,939.00
() Marathon Ashland Petroleum, LLC. 8/14/2001 $ 15,000.00
() Marathon Ashland Petroleum, LLC. 1/20/2004 $ 150,000.00 Marathon Ashland Total
r
C
Marathon Oil Company
2/3/2004 $ 50,000.00 $
215,000.00
;a
G)
oI c..n Page 61 of 62
<D
oI'V
(J)
AUTO DATE
Shell Chem ical Shell Chem ical Shell Chem ical Shell Chem ical Shell Chem ical Shell Chem ical Shell Chem ical Shell Chem ical Shell Chem ical Shell Chem ical Shell Chem ical Shell Chem ical
LT 8/3/05 RT 7/19/06
BHRC Sponsor Payments
10/24/2000 $
Sponsor Company - 1Q07 l5';UUU.UU
5/15/2001 $ 15,000.00
9/25/2001 $ 507,627.00
2/7/2002 $ 537,627.00
9/25/2002 $ 448,023.00
2/10/2003 $ 448,023.00
10/28/2003 $ 514,350.00
1/13/2004 $ 514,350.00
Shell Chem ical Total
4/28/2005 $ 365,334.00
3/3/2006 $ 400,000.00
6/2/2006 $ 1/31/2007 $
511,959.00 435,071.00 $
4,712,364.00
$ 25,045,324.09
DRAFT
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
c..n
Page 62 of 62
AUTODATE
<D
oI'V
-.....J