Document vV7a9nBEJnQz6wk9Ynqy8MQa6
From: Sent: To: Subject: Attach:
Bruce Jarnot <jarnotb@api.org> Wednesday, March 30, 20055:15 PM (GMT) benzconsort-tc@listserve.api.org BHRC-TC Finance Committee... Draft SHS 4Q04 Financial Report BHRC Program Expenses 4Q04 rpt DRAFT.xls
BHRC-TC Finance Committee-
DRAFT 4004 FINANCIAL REPORT is attached, for review on Weds 3/30 conference call (ref appended email) ...
-----Original Message----From: Bruce Jarnot Sent: Tuesday, March 29, 2005 4:00 PM To: 'benzconsort-tc@listserve.apLorg' Subject: BHRC-TC... FYI: Conf Call Weds 3/30, 1:30pm EST
Benzene Health Research Consortium Technical Committee (BHRC-TC) -
FYI... Stuart and I (and those of you available and inclined to join) will meet by conference call tomorrow (Weds 3/30) at 1:30pm Eastern to do the quarterly TC Financial Committee "detailed pre-review" of the 4004 Financial Report, in advance of Thursday's TC conference call. ..
Agenda:
Pre-review of the 4004 SHS Financial Report
Conference Call Information:
Date: Weds, March 30, 2005
Start time: 1:30pm Eastern (12:30pm Houston, 10:30am California)
Dial-in: 763/315-6900 (or toll free 866/448-6756)
PIN code: 6828319#
Best Regards - Bruce.
***** Bruce M. Jarnot, PhD., DABT American Petroleum Institute Regulatory and Scientific Affairs 1220 L Street, NW (Suite 900) Washington, DC 20005-4070 phone: (202) 682-8473 fax: -8031 email: jarnotb@api.org
SH ELL-MCCLU RG-OS2484
Benzene Health Research Consortium 4Q04 Financial Report Overview
A BC D E FG
1
2 RESEARCH PROGRESS:
~ Case Diagnosis: JCML clinical lab continues to increase diagnostic throughput, operating above 100% capacity, and processing 30% more cases than anticipated with 99+% concordance between
4 secondary pathology review.
5 Case Accrual: Cases are being accrued at optimal rate from all participating hospitals, with 500+ AML and 400+ NHL anticipated by end of study. As of 4Q04, 687 confirmed cases were entered int
6 External Review Panels: The SRP reviewed 2 (of 3) SHS presentations from the Munich Benzene Symposium, but did not receive manuscripts prior to presentation.
7
8 EXPENSE DISCUSSION:
9 10 Fund Balance at API 4Q04:
I :P2,823,1691
11
12 Irons Field EXl2enses: New T&E contract executed in 4Q04. Total T&E expenses remain slightly ($14K) over budget and need to be closely tracked.
13 UCHSC: Contract amendment executed with UCHSC; $874,030 additional was disbursed 4Q04, for a total $2.62MM disbursed in 2004. Increased spending rate & total expenditures reflect marked i
14 Subcontracts: 4Q04 subcontractor expenses include Fudan Univ ($880K) and Children's Hosp ($68K); no additional '04 EMBSI charges, front-loaded for the year.
15 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. [Jan/Feb expenses annualize to $19K (5%) under b
16 Fudan Universit~:{ Additional case load, and transfer of CDC & IPHS activities has increased rate of expenditure; sufficient funds were not budgeted for travel to annual meetings (-10K/yr).
17 SRP/ERP: Total expenses remain under budget as of year end 2004. Consortium should consider unanticipated additional expenses in out-years, if expert panels are to be retained post-study for ma
18 Communications (APCO): program budget reduced to $300K ($250K to contingency)
19
20 Outside Legal Council: cummulative variance of 20% over budget
21
22 QAlQC: program budget reduced to $50K ($50K to contgency)
23
24 Contingenc~: increased by $300K ($250K from communicaitons; $50K from QA/QC).
25
26 API Administrative Costs: essentially on budget.
27
28 FORWARD GUIDANCE:
29
30 SRP/ERP projected expenses need to be re-analyzed to reflect new meeting venue and possibly reduced number of meetings (3 to 2).
31
32 UCHSC grant requires close monitoring due to large 2004 expenses and new case-based cost structure
33
34 Irons Field EXl2enses: new T&E contract in place.
35
36 Fudan Universit~: new contract should be executed in 1Q04.
37
38 API administrative expenses requires close monitoring to contain costs. Projected expenses for 2005 will require a substantial decrease in API staff time. Budget projections were based on the assum
39
40 Need to reconcile UCHSC statement - they have a $105 error (from 4Q03 rpt).
41
42 Technical Budget Work Group Acceptance: March 31,2005
43 Oversight Committee Acceptance:
44 Posted to Website:
45
46
47 LT 2/14/05
48 BJ 3/30/05
Page 1 of41
&[DATE]
SH ELL-MCCLU RG-052485
HI 1 2
~ rimary diagnosis &
4 5 the database, including 6 7 8 9 10
11 12 13 crease in JCML case 14 15 dget for 2005.] 16 17 nuscript review and other 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 tion that API staffing 39 40 41 42 43 44 45 46 47 48
Benzene Health Research Consortium 4Q04 Financial Report Overview
Page 2 of41
&[DATE]
SH ELL-MCCLU RG-OS2486
A 1
2 Item 3 AHSciences Case-Control Study 4 DP & ME Studies (UCHSC) 5 Irons(T & E) 6 Fudan University 7 8 Scientific Review Panel 9 Ethics Review Panel 10 External Pathology & Cytogenetics Workgroups(Cost in UC cost) 11 12 API Seed Monies 13 Outside Counsel 14 Public Affairs 15 QAJQC Activities 16 UCHSC Interest 17 contingency 18 19 20 21 GRAND TOTAL 22 23 Notes by API 24 Notes/Assumptions for Dec. 2001 revised budget: 25 26 27 28 29 LT 1128/05
Benzene Health Research Consortium Approved Program Budget 4Q04 Financial Report
B
Total Research Costs Total Panel Costs
Miscellaneous Costs Subtotal API Admin.
C Original Cost
D
Approved Revised Cost
Estimate (Jan. Estimate (Dec.
2001)
2001)
$1,595,000 $13,665,017
$1,253,428 $165,700
$16,679,145
$450,000 $500,000
$1,000,000
$2,283,095 $15,258,017
$1,253,428 $190,555
$18,985,095 $648,000 $216,000 $130,000 $994,000 $0 $500,000
$1,000,000 $225,000
$190,855 $1,690,855 $18,820,000
$941,000 $19,761,000
$0 $1,725,000 $21,704,095 $1,085,205 $22,789,300
E Unapproved Changes not approved (June
2003)
$2,283,095 $15,258,000
$1,597,273 $661,000
$19,799,368 $551,736 $192,000 $0 $743,736 $0 $100,576 $960,600 $100,000
$0 $1,161,176 $21,704,280 $1,085,019 $22,789,299
F Approved
11 NOV 03 OC mtg
$2,283,095 $14,508,000
$1,413,428 $230,000
$18,434,523 $300,000 $64,000 $0 $364,000 $0 $100,000 $550,000 $100,000
($100,000) $390,272
$1,040,272 $19,838,795
$1,245,205 $21,084,000
G Approved
21 APR 04 OC mtg
$2,283,095 $14,508,000
$1,413,428 $230,000
$18,434,523 $300,000 $64,000 $0 $364,000 $0 $100,000 $550,000 $100,000 $0 $290,272
$1,040,272 $19,838,795
$1,245,205 $21,084,000
H Approved
16 Dec 04 OC mtg
$2,283,095 $14,508,000
$1,413,428 $230,000
$18,434,523 $300,000 $64,000 $0 $364,000 $0 $100,000 $300,000 $50,000 $0 $590,272
$1,040,272 $19,838,795
$1,245,205 $21,084,000
- The total research costs have changed as a result of the - Panel costs assume that there will be only one face-to-face
meeting for each panel each year.
Page 3 of41
&[DATE]
SH ELL-MCCLU RG-OS2487
Benzene Health Research Consortium Executive Summary
4Q04 Financial Report
A
BC
DE
F
G
H
1
2
3 Actuals
4
Inception
Cumulative
5
Thru
Actuals
Actuals
6 7 Cost Centers
Project #
December 2003
Jan - Dec 2004
Program to Date
Inception Thru 4Q04
8
9 Income
$ 15,257,275 $ 1,508,419
$ 16,765,693
$ 16,765,693
10
11
12 Cost Centers
13 UCHSC* 14 Irons-Field Expense*
X8105 X8106
7,515,759 539,486
2,622,091 249,000
10,137,850 788,486
10,137,850 788,486
15 Applied Health Sciences
X8107
951,892
439,122
1,391,014
1,391,014
16 Fudan University
X8108
31,981
92,109
124,090
124,090
17 Scientific & Ethics Panels
X8109
82,854
83,917
166,772
166,772
18 Communications
X8103
290,866
3,295
294,161
294,161
19 Outside Legal Counsel 20 QAJQC Support
X8104 X8110
33,208
-
31,322
-
64,529
-
64,529
-
21 API Administrative 22 Contingency**
X8100
594,670 101,473
276,480 3,000
871,150 104,473
871,150 104,473
23
24
Total Expenses
$ 10,142,189 $ 3,800,336
$ 13,942,525
$ 13,942,525
25
26
Fund Balance
$ 5,115,086 $ (2,291,917)
$ 2,823,169
27
28
29 blue is projected fund balanced to project when current funds will run out 30 * amount disbursed by API
31
32 ** $300K added to contingency; $250K from Communicaitons & $50K
33 from QAJQC
34 *** ConocoPhillips pay remaining commitment in 2005
35 LT 2/14/05
36
37 38
I J K LM Budget (actual + projected incom
2005
$ 1,826,667 ***
2006 $ 1,278,667
1,748,060 262,000 441,867 29,148 76,000 1,946 16,698 16,667 123,330 162,933
$ 2,878,649
$ 1,771,187
1,748,060 262,000 449,985 29,148 71,000 1,946 16,698 16,667 123,200 162,933
$ 2,881,637
$168,217
Page 4 of 41
&[DATE]
SH ELL-MCCLU RG-OS2488
N0
1
2
3 & expenses)
4 5
6 7 2007
8
9$
1,278,667
10
11
12
13 874,030
14 104,714
15 45,833
16 29,148
17 44,000
18 1,946
19 16,698
20 16,667
21 123,200 22 159,933
23
24 $
1,416,169
25 26 $30,715
27
28
29 30
31 Income Detail
32 sponsors
33 2001 seed
34 MAP contrib.
35 API interest
36 UCHSC interest
37 38 TOTAL
P
Projected Expenses $ 21,149,694
14,508,000 1,417,200 2,328,699 211,534 357,772 300,000 114,623 50,000 1,240,880 590,272
$ 21,118,980
$16,500,000 $15,000
$200,000 $50,692 $0
$16,765,692
Q
Program Budget
$ 21,084,000
14,508,000 1,413,428 2,283,095 230,000 364,000 300,000 100,000 50,000 1,245,205 590,272
$ 21,084,000
Benzene Health Research Consortium Executive Summary
4Q04 Financial Report
Page 5 of 41
&[DATE]
SH ELL-MCCLU RG-OS2489
Benzene Health Research Consortium Case Accrual 4Q04
A
Case Accrual (Case Predictions)
~ ReDorted Cumulativelv ~ AML (120/yr.; 450 total)
"I Cases Predicted
Cases Accrued
Variance
NHL (120/yr.; 450 total)
Cases Predicted
~ Cases Accrued
Variance
AA (50/yr.; 188 total)'
Cases Predicted
U Cases Accrued
L<L Variance
~ MDS (60/yr.; 225 total)' Cases Predicted
Cases Accrued
Variance
G:L Benzene Poisoning (10/yr.; 38 total)'
Cases Predicted
"[ Cases Accrued
~
Variance
~
(+) Variance: above predicte rate of accrual,
24 (-) Variance: below predicted rate of accrual.
L~
"Case predictions based on historical estimates;
these are not target numbers of cases required for
26 study completion.
~ LT 8/30/04
L~ BJ 3/30/05
BC
2003 1st & 2nd Otr. 3r.d Otr.
00 00 00
00 00 00
00 00 00
00 00 00
00 00 00
D
4th Otr.
35 42
7
35 66 31
12 17
5
15 26 11
3 0 -3
E
1stOtr.
FG
2004 2nd Otr. 3r.d Otr.
120 150
30
120 139
19
50 50
0
60 97 37
10 12
2
HI
4th Otr. 1stOtr.
180 437 257
180 155 -25
75 55 -20
90 ? ?
15 ? ?
JK
2005 2nd Otr. 3r.d Otr.
240
240
100
120
20
LM
4th Otr. 1stOtr. 300
300
125
150
25
N0
2006 2nd Otr. 3r.d Otr.
360
360
150
180
30
PQ
4th Otr. 1stOtr. 420
420
175
210
35
RS
2007 2nd Otr. 3r.d Otr.
T
4th Otr.
&[DATE]
SH ELL-MCCLU RG-OS2490
uV
ESTIMATED
STUDY
~ TOTAL PREDICTION
~ "I 420 450
~
U
L<L
~
G:L
"[ ~ ~
24
L~
26
~ L~
420 175 210 35
450 188 225 38
Benzene Health Research Consortium Case Accrual 4Q04
&[DATE]
SHELL-MCCLURG-052491
Benzene Health Research Consortium Cash Flow Statement 4Q04 Financial Report
A
INCOME "I Income for Reporting Period
Income, Cumulative ~ EXPENSE
Actual API Expenses Expense, Cumulative
2 INCOME LESS EXPENSE
~ Reporting Period Cumulative
~ blue designates projected income or
14 expense
LT10/18/04
B
2000 1st-4thQtr.
C
2001 1st-4thQtr.
D
2002 1st-4thQtr.
E
1st&2nd Qtr.
$60,246 $60,246
$2,113,132 $2,173,378
$8,367,446 $10,540,824
$448,024 $10,988,848
24,600 $24,600
1,577,811 $1,602,411
7,652,678 $9,255,088
318,759 $9,573,847
$35,646 $35,646
$535,321 $570,967
$714,768 $1,285,736
$129,265 $1,415,001
NOTE: $4,152,436 in bank at API
F
2003 3rd Qtr.
G
4thQtr.
$3,186 $10,992,034
$4,265,241 $15,257,275
258,097
310,244
$9,831,945 $10,142,189
($254,911) $1,160,089
$3,954,997 $5,115,086
H
1stQtr.
$1,485,875 $16,743,149
66,019 $10,208,207
$1,419,856 $6,534,942
I
2nd Qtr.
2004
J
3rd Qtr.
$6,746 $16,749,895
$6,506 $16,756,401
1,348,626 $11,556,834
1,047,131 $12,603,965
($1,341,880) $5,193,061
($1,040,625) $4,152,436
K
4thQtr. $9,292
$16,765,693
$12,603,965 $9,292
$4,161,728
L
1stQtr. $0
$16,765,693
$12,603,965 $0
$4,161,728
M
2nd Qtr.
2005
N
3rd Qtr.
$0 $16,765,693
$0 $16,765,693
$12,603,965
$0 $4,161,728
$12,603,965
$0 $4,161,728
0
4thQtr. $0
$16,765,693
$12,603,965 $0
$4,161,728
P
1stQtr. $0
$16,765,693
$12,603,965 $0
$4,161,728
Q
2nd Qtr.
2006
R
3rd Qtr.
$0 $16,765,693
$0 $16,765,693
$12,603,965
$0 $4,161,728
$12,603,965
$0 $4,161,728
8of41
&[DATE]
SH ELL-MCCLU RG-OS2492
"I ~
2
~
~
14
S
4thQtr. $0
$16,765,693
$12,603,965 $0
$4,161,728
T
1stQtr. $0
$16,765,693
$12,603,965 $0
$4,161,728
U
2nd Qtr.
2007
V
3rd Qtr.
$0 $16,765,693
$0 $16,765,693
$12,603,965
$0 $4,161,728
$12,603,965
$0 $4,161,728
W
4thQtr. $0
$16,765,693
$12,603,965 $0
$4,161,728
X
TOTALS
$16,765,693
$12,603,965
Benzene Health Research Consortium Cash Flow Statement 4Q04 Financial Report
90f41
&[DATE]
SH ELL-MCCLU RG-OS2493
Benzene Health Research Consortium Program Expense Summary 4Q04 Financial Report
AB
Cost Centers
UCHSC
~ Disbursed
Budgeted
Actual expense
CurrentVariance
~ Cumm Variance
Irons - Field Expenses
Disbursed
Budgeted
Actual expense
CurrentVariance
I "+ Cumm Variance
~ Applied Health Sciences
~ Budgeted
Actual expense
CurrentVariance
I ~ Cumm Variance
~ Fudan University - Case/Control Study
L. Budgeted
L.. Actual expense
~
CurrentVariance
~ Cumm Variance
L.: Scientific & Ethics Panels/cyto wkshop
L.I Budgeted
...:. Actual expense
~ CurrentVariance
L.: Cumm Variance
')U Communications - APCO
~ Budgeted
~
Actual expense
.,)..J CurrentVariance
.)"+ Cumm Variance
~ Outside Legal Counsel
~
Budgeted
Actual expense
CurrentVariance .j~ Cumm Variance
~ QAlQC Support
"+ Budgeted "+. Actual expense
~
CurrentVariance
~
Cumm Variance
"+;:J Contingency Funds
"+t: Budgeted
~ Actual expense
~
"+::;l
CurrentVariance Cumm Variance
2000 1st-4thQtr.
::>U ~ ~
;,:)..J
;,:)"+
API Administrative and Overhead Budgeted Actual expense CurrentVariance Cumm Variance
24,600 (24,600) (24,600
~
TOTALS
~
Budgeted
Actual expense
CurrentVariance ::>~ Cumm Variance
~ CUMULATIVE TOTALS
Budgeted
Expense
0,,) Variance
'UUU 2000
24,600 (24,600) (24,600)
24,600 (24,600)
0"+ Blue: future cumulative variance has no meaning until Expense entered.
~ LT10/18/04
~
Amt. At UCHSC & Irons Field expo Bank acct
c
2001 1st-4thQtr.
D
2002 1st-4thQtr.
1,225,000 648,390 523,807 124,583 124,583
6,339,598 3,969,140 3,248,834
720,306 844,889
145,763 3,200 3,157 43 43
393,723 259,060 195,549
63,511 63,554
84,025 136,329 (52,304) (52,304)
435,513 435,406
107 (52,197)
31,303
31,303 31,303
42,751 15,470 27,281 58,584
30,240 18,673 11,567 11,567
120,960 5,122
115,838 127,405
60,000
60,000 60,000
240,000 240,738
(738) 59,262
30,000
30,000 30,000
120,000 13,565
106,435 136,435
13,500
54,000
13,500 13,500
54,000 67,500
65,113 52,046 13,067 11,533
260,448 209,056
51,392 39,859
'UUl 965,771 734,012 231,759 207,159
2001 965,771 758,612 207,159
5,501,872 4,363,739 1,138,133 1,345,292 2002 6,467,643 5,122,351 1,345,292
API disbursed Amt Expensed
E
1st&2nd Qtr.
1,230,711 1,717,169
(486,458) 332,137
138,359 89,577 48,782
112,336
216,256 140,665
75,591 23,394
21,376 6,492
14,883 73,467
60,480 9,994
50,486 177,891
125,000 14,564
110,436 169,699
62,500 1,728
60,772 197,207
28,126
28,126 95,626
135,654 145,316
(9,662) 30,197
2,018,461 2,125,505
(107,044) 1,238,248
8,486,104 7,247,856 1,238,248
F
2003 3rd Qtr.
IG
4thQtr.
332,137
(48,839) 2,039,466
553,672 1,485,794 1,813,804
69,179 54,382 14,797 127,133
108,128 149,389 (41,261) (17,868)
10,688 8,851 1,837
75,305
30,240 16,984 13,256 191,147
62,500 7,877
54,623 224,322
31,250
31,250 228,457
14,063
14,063 109,689
67,826 74,997 (7,171) 23,026
55,508 169,606 (114,098)
13,035
108,128 90,103 18,025 157
7,288 1,168 6,120 81,425
4,508 32,081 (27,573) 163,574
(196,636) 27,688
(224,324) (2)
(210,542) 17,915
(228,457)
(109,689)
(109,689)
290,272 101,473 188,799 188,799
75,934 88,655 (12,721) 10,305
393,874 312,479
81,394 1,319,642 2003 8,879,977 7,560,335 1,319,642
$12,603,965 $11,400,949 $1,203,016
2,064,237 1,082,361
981,876 2,301,518
10,944,214 8,642,696 2,301,518
H
1stQtr.
2004 2nd Qtr.
IJ IK
3rd Qtr.
4thQtr.
1,813,804
874,031 827,532 2,045,114 (1,217,582) 586,386
874,030 586,386
874,030 827,532 948,696 (121,164) 455,386
55,508 43,945 11,563 24,598
189,320 55,508 95,409 (39,901) (15,303)
55,508 49,390
6,118 (9,185)
59,680 55,508 60,427 (4,919) (14,104)
98,340
98,340 98,497
98,340 168,623 (70,283)
28,215
98,340 105,508
(7,168) 21,047
98,340 164,991 (66,651) (45,604)
7,288
7,288 88,713
7,288 27,755 (20,467) 68,246
7,288
7,288 75,534
7,287 64,354 (57,067) 18,467
(163,074) 500
(163,574)
3,000 12,029 (9,029) (9,029)
4,500 2,500 2,000 (7,029)
69,000 68,889
111 (6,917)
15,001
15,001 14,999
15,000 790
14,210 29,209
15,000 1,235
13,765 42,974
(41,704) 1,270
(42,974)
4,175 365
3,810 3,810
4,175 2,995 1,180 4,990
4,175 1,870 2,305 7,294
4,175 26,092 (21,918) (14,623)
6,250
6,250
6,250
(18,750)
6,250 6,250
6,250 12,500
6,250 18,750
(18,750)
188,799
188,799
188,799
300,000 3,000
297,000 485,799
66,700 65,154
1,546 11,851
66,700 73,084 (6,384)
5,467
90,188 109,964 (19,776) 2,281,742
11,034,402 8,752,660 2,281,742
'UU4 2004
1,083,793 2,425,798 (1,342,006)
939,736
12,118,195 11,178,458
939,736
$1,175,224 unspent at UCHSC as of 6130/04 (no expense reporting for 3004) $27,044 In Irons' field exp bank acct as of 6130/04 (3004 exp report outstandinq)
$1,202,268 Total as of 6130/04
72,700 61,988 10,712 16,179
263,761 222,491
41,270 981,006
12,381,955 11,400,949
981,006
64,400 76,254 (11,854)
4,325
1,065,788 1,413,973
(348,185) 632,821
13,447,743 12,814,922
632,821
LI M
1stQtr.
2nd Qtr.
874,030 827,532
455,386
827,532 1,273,082
131,000 55,508
55,508
55,508 41,404
55,508 96,912
110,467
110,467
110,467 64,863
110,467 175,329
7,287
7,287
7,287 25,754
7,287 33,041
1,500
1,000
1,500 (5,417)
1,000 (4,417)
4,175
4,175 (10,449)
4,167
4,167 4,167
4,175
4,175 (6,274)
4,167
4,167 8,333
485,799
29,350
29,350 33,675
485,799
26,680
26,680 60,355
212,453
212,453 845,274
13,660,196 12,814,922
845,274
1,036,815
1,036,815 1,882,089
14,697,011 12,814,922
1,882,089
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
131,000
874,030
Page 10 of41
&[DATE]
SH ELL-MCCLU RG-OS2494
N
05 3rd Qtr.
~0 0
0
0
~ 1,273,082
131,000
55,508
0
55,508
1"1 152,420
~ ~ 110,467
0
110,467 I~ 285,796
~ L. 7,287
L..
~ ~ L.
0 7,287 40,328
L.'
~ ~ L.
4,500 0
4,500 83
.)U
~ ~ ,).0
,)"1
0 0 0 0
~ ~
4,175 0
4,175 .)~ (2,100)
~ "I
"I,
~ ~ "I;)
4,167 0
4,167 12,500
"It
~ ~
"I"
:>u
0 0 0 485,799
2
~ ;;).0
;;)"1
~ '.,
~
40,650 0
40,650 101,005
226,753 0
226,753 :>~ 2,108,842
~ 05
14,923,764
12,814,922
0,) 2,108,842
0"1
~ ~
0
4thQtr.
874,030 827,532
0 827,532 2,090,778
0 55,508
0 55,508 207,928
110,467 0
110,467 396,263
7,287 0
7,287 47,615
69,000 0
69,000 69,083
1,946 0
1,946 1,946
4,175 0
4,175 2,075
4,167 0
4,167 16,667
0 0 0 485,799
26,650 0
26,650 1 655
1,106,731 0
1,106,731 3,215,573
16,030,495 12,814,922
3,215,573
p IQI RIs
2006
1stQtr.
2nd Qtr.
3rd Qtr.
4thQtr.
0 0 0 0 2,090,778
874,030 827,539
0 827,539 2,908,474
0 0 0 0 2,908,474
874,030 827,542
0 827,542 3,726,170
131,000 55,508 0 55,508
263,436
0 55,508
0 55,508 318,944
131,000 55,507 0 55,507
374,451
0 55,507
0 55,507 429,958
112,496 0
112,496 508,759
112,496 0
112,496 621,255
112,496 0
112,496 733,752
112,496 0
112,496 846,248
7,287 0
7,287 54,902
7,287 0
7,287 62,189
7,287 0
7,287 69,476
7,287 0
7,287 76,763
1,000 0
1,000 70,083
1,000 0
1,000 71,083
4,000 0
4,000 75,083
65,000 0
65,000 140,083
0 0 0 1,946
0 0 0 1,946
0 0 0 1,946
1,946 0
1,946 3,893
4,175 0
4,175 6,249
4,175 0
4,175 10,424
4,175 0
4,175 14,598
4,175 0
4,175 18,773
4,167 0
4,167 20,833
4,167 0
4,167 25,000
4,167 0
4,167 29,167
4,167 0
4,167 33,333
0 0 0 485,799
0 0 0 485,799
0 0 0 485,799
0 0 0 485,799
29,250 0
29,250 156,905
213,882 0
213,882 3,429,455
16,244,377 12,814,922
3,429,455
26,650 0
26,650
,..0183,555
40,650 0
40,650 224205
1,038,821
228,281
00
1,038,821
228,281
4,468,277
4,696,558
2006
17,283,199 17,511,480
12,814,922 12,814,922
4,468,277
4,696,558
26,650 0
26,650 250,855
1,104,770 0
1,104,770 5,801,328
18,616,250 12,814,922
5,801,328
Benzene Health Research Consortium Program Expense Summary 4Q04 Financial Report
T I uI V Iw
2007
1stQtr.
2nd Qtr.
3rd Qtr.
4thQtr.
0 0 0 0 3,726,170
874,030 827,542
0 827,542 4,543,866
0 0 0 0 4,543,866
0 827,542
0 827,542 5,361,562
104,714 55,507.0
0 55,507 485,465
0 55,507
0 55,507 540,972
0 55,507
0 55,507 596,479
0 55,507
0 55,507 651,986
45,833 0
45,833 892,081
0 0 0 892,081
0 0 0 892,081
0 0 0 892,081
7,287 0
7,287 84,050
7,287 0
7,287 91,337
7,287 0
7,287 98,624
7,287 0
7,287 105,911
1,000 0
1,000 141,083
1,000 0
1,000 142,083
4,000 0
4,000 146,083
38,000 0
38,000 184,083
0 0 0 3,893
0 0 0 3,893
0 0 0 3,893
1,946 0
1,946 5,839
4,175 0
4,175 22,947
4,175 0
4,175 27,122
4,175 0
4,175 31,296
4,175 0
4,175 35,471
4,167 0
4,167 37,500
4,167 0
4,167 41,667
4,167 0
4,167 45,833
4,167 0
4,167 50,000
0 0 0 485,799
0 0 0 485,799
0 0 0 485,799
0 0 0 485,799
29,250 0
29,250 280,105
26,650 0
26,650 306,755
40,650 0
40,650 347,405
26,650 0
26,650 374,055
X
TOTALS
14,508,000 14,508,000
9,037,292 827,542
5,470,708
1,417,200 1,413,428
761,442 429,958 651,986
2,283,095 1,391,014
0 892,081
230,000 124,090
7,287 105,911
350,854 166,772
38,000 184,083
300,000 294,161
3,893 5,839
100,000 64,529 35,471 35,471
50,000 0
50,000 50,000
590,272 104,473
0 485,799
1,245,205 846,550 398,655 398,655
147,218 0
147,218 5,948,546
18,763,468 12,814,922
5,948,546
926,327
115,785
00
926,327
115,785
6,874,873
6,990,658
2007
19,689,795 19,805,581
12,814,922 12,814,922
6,874,873
6,990,658
965,274 0
965,274 7,955,932
20,770,854 12,814,922
7,955,932
20,770,854 12,790,322
7,955,932 7,980,532
21,070,854 12,814,922
8,255,932
O~
131,000
874,030
131,000
874,030
131,000
874,030
104,714
874,030
0
0 18,916,789
Page 11 of41
&[DATE]
SH ELL-MCCLU RG-052495
Benzene Health Research Consortium UCHSC Grant 4Q04 Financial Report
A
Grant Payments .q Disbursed ~ Personnel ~ Budgeted
Actual expense
CurrentVariance ~ Cumm Variance ~ Operating Expenses
Budgeted
Actual expense ~ CurrentVariance ~ Cumm Variance
Subcontracts
Budgeted
Actual expense
~ CurrentVariance Cumm Variance
L' Travel
-. Budgeted Actual expense L CurrentVariance L"I Cumm Variance ~ Equipment
~ Budgeted
L. Actual expense L" CurrentVariance ::::~ Cumm Variance ~ Indirect
Budgeted
Actual expense
CurrentVariance Cumm Variance
UCHSC (x81 05) Cost Centers
Budgeted
~ Actual expense
~
CurrentVariance
..)::;1 Cumm Variance
qU CUMULATIVE TOTALS
~ Budgeted
~
Expense
"f..J Variance
TOTALS
~ Blue: future cumulative variance has no meaning until Expense entered.
~ LT10/18/04 ~ BJ1/03/05
"I"
B
2001 1st-4thQtr.
C
2002 1st-4thQtr.
D
1st&2nd Qtr.
1,225,000
6,339,598
172,140 172,140
573,160 714,688 -141,528 -141,528
331,316 314,703
16,613 -124,915
13,131 12,177
954 954
378,462 301,522
76,940 77,894
198,373 158,850
39,523 117,417
123,629
123,629 123,629
1,795,030 1,025,372
769,658 893,287
549,014 845,860 -296,846 596,441
23,947 8,647
15,300 15,300
11,340 346
10,994 26,294
$291,568 $291,568
$0 $0
$918,645 $899,642
$19,003 $19,003
$0 $274,508 ($274,508) ($255,505)
2001 2001
$47,922 $47,922
($0) ($0)
$648,390 $523,807 $124,583 $124,583
$648,390 $523,807 $124,583
$279,896 $298,963 ($19,067) ($19,067)
2002 $3,969,140 $3,248,834
$720,306 $844,889 2002 $4,617,530 $3,772,641 $844,889
$140,668 $122,902
$17,766 ($1,301)
$1,230,711 $1,717,169
($486,458) $332,137
$5,848,241 $5,489,810
$358,431
Note: Actual expenses from Progress Report or UC Grants & Contracts Financials.
Amt. paid UCHSC to date: Amt. expensed to date: Amt. In UCHSC bank acct:
$9,263,820 $8,088,596 $1,175,224
Page 12 of41
&[DATE]
SH ELL-MCCLU RG-OS2496
Benzene Health Research Consortium UCHSC Grant 4Q04 Financial Report
"I
2
~
~ ~
~ ~
E
2003 3rd Qtr.
~
L'
-.
L L"I ~ ~ L L,
~~ ~
.."~
,,;;) 2003
~
~,,"
"IU 2003 ~
.~"
~ "I;;) "It
~ (Adjusted 4003: $48,839 attributed to UCHSC in 3003 Report has been reallocated to Contingency: $25,000 pre-consortium grant in 2001; $3,600 for IRB Review in 2002; $20,239 for EMBSI "feasibility study" in 2002) ~ (Adjusted 4003: 2001 costs had been double expensed in 2002 column; (-$523,807) adjusment made in 4003) "I"
0
0 0 0 -124,915
0 0 0 117,417
0 0 0 596,441
0 0 0 26,294
$0 $0 $0 ($255,505)
$0 $0 $0 ($1,301)
$0 $0 $0 $332,137
$5,848,241 $5,489,810
$358,431
F
4thQtr.
-48,839
293,007 58,188
234,819 109,904
259,003 150,657 108,346 225,763
988,733 565,870 422,863 1,019,304
4,127 0
4,127 30,421
$350,000 ($274,568) $624,568 $369,063
$144,596 $53,525 $91,071 $89,770
$2,039,466 $553,672
$1,485,794 $1,813,804
$7,887,707 $6,043,482 $1,844,225
G
1stQtr.
H
2004 2nd Qtr.
0 874,031
0 0 0 109,904
195,778 211,016 -15,238
94,666
0 0 0 225,763
195,773 364,542 -168,769
56,994
0 0 0 1,019,304
286,990 1,128,507 -841,517
177,787
0 0 0 30,421
9,836 0
9,836 40,257
$0 $0 $0 $369,063
$48,050 $192,340 ($144,290) $224,773
$0 $0 $0 $89,770
$0 $0 $0 $1,813,804
$7,887,707 $6,043,482 $1,844,225
2004 2004
$91,105 $148,709 ($57,604)
$32,166
$827,532 $2,045,114 ($1,217,582)
$586,386
$8,715,239 $8,088,596
$626,643
UCHSC statement error for travel, off by +$1 05 (4003)
I
3rd Qtr.
874,030
0 0 0 94,666
0 0 0 56,994
0 0 0 177,787
0 0 0 40,257
$0 $0 $0 $224,773
$0 $0 $0 $32,166
$0 $0 $0 $586,386
$8,715,239 $8,088,596
$626,643
Page 13 of41
&[DATE]
SH ELL-MCCLU RG-OS2497
Benzene Health Research Consortium UCHSC Grant 4Q04 Financial Report
"I
2
~
~ ~
~ ~
~
L'
-.
L L"I ~ ~ L L,
~~ ~
~,,'"t ,,;;)
~
~,,"
"IU ~ ~
'"t"
~ "I;;) "It
~ ~ "I"
J
4thQtr.
874,030
195,778 0
195,778 290,444
195,773 0
195,773 252,767
286,990 948,696 -661,706 -483,919
9,836 0
9,836 50,093
$48,050 $0
$48,050 $272,823
$91,105 $0
$91,105 $123,271
$827,532 $948,696 ($121,164) $455,386
$9,542,771 $9,037,292
$505,479
K
1stQtr.
L
2nd Qtr.
2005
M
3rd Qtr.
N
4thQtr.
0
1stQtr.
P
2nd Qtr.
2006
Q
3rd Qtr.
R
4thQtr.
S
1stQtr.
T
2nd Qtr.
2007
U
3rd Qtr.
V
4thQtr.
0 874,030
0 874,030
0 874,030
0 874,030
0 874,030
0
0 0 0 290,444
195,778 0
195,778 486,222
0 0 0 486,222
195,778 0
195,778 682,000
0 0 0 682,000
195,778 0
195,778 877,778
0 0 0 877,778
195,778 0
195,778 1,073,556
0 0 0 1,073,556
195,778 0
195,778 1,269,334
0 0 0 1,269,334
195,778 0
195,778 1,465,112
0 0 0 252,767
195,773 0
195,773 448,540
0 0 0 448,540
195,773 0
195,773 644,313
0 0 0 644,313
195,773 0
195,773 840,086
0 0 0 840,086
195,773 0
195,773 1,035,859
0 0 0 1,035,859
195,773 0
195,773 1,231,632
0 0 0 1,231,632
195,773 0
195,773 1,427,405
0 0 0 -483,919
286,990 0
286,990 -196,929
0 0 0 -196,929
286,990 0
286,990 90,061
0 0 0 90,061
286,990 0
286,990 377,051
0 0 0 377,051
286,990 0
286,990 664,041
0 0 0 664,041
286,990 0
286,990 951,031
0 0 0 951,031
286,990 0
286,990 1,238,021
0 0 0 50,093
9,836 0
9,836 59,929
0 0 0 59,929
9,836 0
9,836 69,765
0 0 0 69,765
9,843 0
9,843 79,608
0 0 0 79,608
9,846 0
9,846 89,454
0 0 0 89,454
9,846 0
9,846 99,300
0 0 0 99,300
9,846 0
9,846 109,146
$0 $0 $0 $272,823
$48,050 $0
$48,050 $320,873
$0 $0 $0 $320,873
$48,050 $0
$48,050 $368,923
$0 $0 $0 $368,923
$48,050 $0
$48,050 $416,973
$0 $0 $0 $416,973
$48,050 $0
$48,050 $465,023
$0 $0 $0 $465,023
$48,050 $0
$48,050 $513,073
$0 $0 $0 $513,073
$48,050 $0
$48,050 $561,123
$0 $0 $0 $123,271
$0 $0 $0 $455,386
$9,542,771 $9,037,292
$505,479
$91,105 $0
$91,105 $214,376
$0 $0 $0 $214,376
2005
$827,532
$0
$0 $0
$827,532
$0
$1,273,082
$1,273,082
2005
$10,370,303 $10,370,303
$9,037,292
$9,037,292
$1,333,011
$1,333,011
$91,105 $0
$91,105 $305,481
$827,532 $0
$827,532 $2,090,778
$11,197,835 $9,037,292 $2,160,543
$0 $0 $0 $305,481
$0 $0 $0 $2,090,778
$11,197,835 $9,037,292 $2,160,543
$91,105 $0
$91,105 $396,586
$0 $0 $0 $396,586
2006
$827,539
$0
$0 $0
$827,539
$0
$2,908,474
$2,908,474
2006
$12,025,374 $12,025,374
$9,037,292
$9,037,292
$2,988,082
$2,988,082
$91,105 $0
$91,105 $487,691
$827,542 $0
$827,542 $3,726,170
$12,852,916 $9,037,292 $3,815,624
$0 $0 $0 $487,691
$0 $0 $0 $3,726,170
$12,852,916 $9,037,292 $3,815,624
$91,105 $0
$91,105 $578,796
$0 $0 $0 $578,796
2007
$827,542
$0
$0 $0
$827,542
$0
$4,543,866
$4,543,866
2007
$13,680,458 $13,680,458
$9,037,292
$9,037,292
$4,643,166
$4,643,166
$91,105 $0
$91,105 $669,901
$827,542 $0
$827,542 $5,361,562
$14,508,000 $9,037,292 $5,470,708
W
TOTALS
14,508,000
2,935,847 1,470,735
195,778 1,465,112
2,415,153 987,748 195,773
1,427,405
5,752,326 4,514,305
286,990 1,238,021
118,139 8,993 9,846
109,146
$1,944,613 $1,383,490
$48,050 $561,123
$1,341,922 $672,021 $91,105 $669,901
$14,508,000 $9,037,292 $827,542 $5,470,708
$14,508,000 $9,037,292 $5,470,708
Page 14 of41
&[DATE]
SH ELL-MCCLU RG-OS2498
A
UCHSC Subcontracts Fudan University
" Actual expense IPHSC Actual expense SMCDCP Actual expense
-"'- EMBSI Actual expense Children's Hospital Cincinnati
!. Actual expense
TOTALS 1'1 Actual expense
~
LT 8/6/04 1::1 BJ 1/03/05
Benzene Health Research Consortium UCHSC Subcontract 4Q04 Financial Report B
2001 1st-4thQtr.
2001 "Total subcontractor expenses" from study report (preliminary figure); "actual expenses" from UC Office of Grants & Contracts spreadsheet (final figures).
C
2002 1st-4thQtr.
D
1st&2nd Qtr.
EI
2003
F
3rd & 4th Qtr.
GI H III J
2004
1st&2nd Qtr.
3rd & 4th Qtr.
KI L 1M
2005
1st&2nd Qtr.
0
0 411,935
468,341
1,088,352
880,342
0
0 0 8,339
27,496
7,683
0
0
0 0 45,563
24,766
2,500
0
0
0 0 372,725
00
00
00 2002
$0 $1,025,372
7,298 2003
$845,860
45,267 $565,870
29,972 2004
$1,128,507 $1,128,507
68,354 $948,696
0 2005 $0
Page 15 of 41
&[DATE]
SH ELL-MCCLU RG-OS2499
N
3rd & 4th Qtr.
01 P IQI R
2006
1st&2nd Qtr.
3rd & 4th Qtr.
sl T IU
2007
1st&2nd Qtr.
v
3rd & 4th Qtr.
40 0 0 0 0
00
00
0
00
00
0
-"'-
00
00
0
!. 0
14 $0
0 2006 $0
0 $0
0 2007 $0
0 $0
~
W
TOTALS
2,848,970 43,518 72,829
372,725 150,891 $3,488,933
1::1
Benzene Health Research Consortium UCHSC Subcontract 4Q04 Financial Report
Page 16 of 41
&[DATE]
SH ELL-MCCLU RG-OS2S00
Benzene Health Research Consortium Irons Field Expenses 4Q04 Financial Report
A
IRONS T&E (X81 06) Cost Centers
Payments .q Disbursed ~ Airfare & related expenses ~ Budgeted
Actual expense CurrentVariance ~ Cumm Variance ~ Apartment I hotel & related expenses Budgeted Actual expense ~ CurrentVariance ~ Cumm Variance Other expenses e.g. taxi, limo, misc. Budgeted Actual expense ~ CurrentVariance I ::1 Cumm Variance
L'
~ Budgeted Actual expense
L.. CurrentVariance L."+ Cumm Variance ~ CUMULATIVE TOTALS ~ Budgeted L. Expense L., Variance
riO- Blue: future cumulative variance has no meaning until Expense entered.
,,"+ LT 2/14/05
~ BJ1125/05
B
2001 4thQtr.
C
2002 1st-4thQtr.
D
1st&2nd Qtr.
E
3rd Qtr.
$145,763
$1,280 $1,606
($326) ($326)
$1,280 $1,024
$256 $256
$640 $528 $112 $112
$393,723
$103,624 $75,179 $28,445 $28,119
$103,624 $89,717 $13,907 $14,163
$51,812 $30,653 $21,159 R,272
$0
$55,343 $27,359 $27,984 $56,103
$55,343 $45,291 $10,052 $24,216
$27,672 $16,926 $10,746 $32017
$0
$27,672 $25,079
$2,593 $58,696
$27,672 $21,200
$6,472 $30,687
$13,836 $8,103
$47,240 $79,257
2001
$3,200 $3,157
$43 $43
$3,200 $3,157
$43
$259,060 $195,549
$63,511 $63,554 2002 $262,260 $198,706 $63,554
$138,359 $89,577 $48,782
$112,336
$400,619 $288,283 $112,336
$69,179 $54,382 $14,797 $127,133
$469,798 $342,665 $127,133
"Actual expense" is from quarterly expense reports, and does not reflect contract prepayments
Amt paid to Irons to date: Amt Irons has spent: Amt. In Irons bank acct:
$788,486 numbers as of 12131/04 $761,442
$27,044
Page 17 of41
&[DATE]
SHELL-MCCLURG-052501
"I
2
~
~ ~
~ ~
2003
F
4thQtr.
~,::I
L'
-.
L
L"I
~ ~ L L,
2003
L 4Q03 ADJUSTMENT - 200112002 expense underrecorded; +$114,289 adjustment
.)U
~ ~
.).)
,)"1
~ ~
~ ~
"I
Benzene Health Research Consortium Irons Field Expenses 4Q04 Financial Report
G
1stQtr.
HI
2004
2nd Qtr.
3rd Qtr.
J
4thQtr.
$0 $0 $189,320 $0 $59,680
$22,200 $74,850 ($52,650)
$6,046
$22,205 $81,131 ($58,926) ($28,239)
$11,103 $13,625 ($2,522) $76735
$22,200 $18,124
$4,076 $10,122
$22,205 $20,041
$2,164 ($26,075)
$11,103 $5,780 $5,323
$82058
$22,200 $32,651 ($10,451)
($329)
$22,205 $55,100 ($32,895) ($58,970)
$11,103 $7,658 $3,445
$85,503
$22,200 $14,144
$8,056 $7,728
$22,205 $26,225 ($4,020) ($62,990)
$11,103 $9,021 $2,082
$87585
$22,200 $29,290 ($7,090)
$637
$22,205 $15,200
$7,005 ($55,985)
$11,103 $15,937 ($4,834) $82,751
$55,508 $169,606 ($114,098)
$13,035
$55,508 $43,945 $11,563 $24,598
$525,306 $512,270
$13,035
$580,814 $556,215
$24,598
$55,508
$55,508
$95,409
$49,390
($39,901)
$6,118
($15,303)
($9,185)
2004
$636,322 $691,830
$651,624 $701,014
($15,303)
($9,185)
$55,508 $60,427 ($4,919) ($14,104)
$747,338 $761,442 ($14,104)
K
1stQtr.
LM
2005
2nd Qtr.
3rd Qtr.
$131,000
$0 $131,000
$22,200 $0
$22,200 $22,837
$22,205 $0
$22,205 ($33,780)
$11,103 $0
$11,103 $93,854
$22,200 $0
$22,200 $45,037
$22,205 $0
$22,205 ($11,575)
$11,103 $0
$11,103 $104957
$22,200 $0
$22,200 $67,237
$22,205 $0
$22,205 $10,630
$11,103 $0
$11,103 $116,060
$55,508 $0
$55,508 $41,404
$802,846 $761,442
$41,404
$55,508
$55,508
$0 $0
$55,508
$55,508
$96,912 $152,420
2005
$858,354 $913,862
$761,442 $761,442
$96,912 $152,420
N
4thQtr.
$0
$22,200 $0
$22,200 $89,437
$22,205 $0
$22,205 $32,835
$11,103 $0
$11,103 $127,163
$55,508 $0
$55,508 $207,928
$969,370 $761,442 $207,928
0
1stQtr.
$131,000
$22,200 $0
$22,200 $111,637
$22,205 $0
$22,205 $55,040
$11,103 $0
$11,103 $138,266
$55,508 $0
$55,508 $263,436
$1,024,878 $761,442 $263,436
P
2006 2nd Qtr.
Q
3rd Qtr.
R
4thQtr.
$0 $131,000
$0
$22,200 $0
$22,200 $133,837
$22,205 $0
$22,205 $77,245
$11,103 $0
$11,103 $149369
$22,200 $0
$22,200 $156,037
$22,205 $0
$22,205 $99,450
$11,102 $0
$11,102 $160471
$22,200 $0
$22,200 $178,237
$22,205 $0
$22,205 $121,655
$11,102 $0
$11,102 $171,573
$55,508
$55,507
$0 $0
$55,508
$55,507
$318,944
$374,451
2006
$1,080,386 $1,135,893
$761,442
$761,442
$318,944
$374,451
$55,507 $0
$55,507 $429,958
$1,191,400 $761,442 $429,958
S
1stQtr.
TU
2007
2nd Qtr.
3rd Qtr.
V
4thQtr.
$104,714
$0 $0
$0
$22,200 $0
$22,200 $200,437
$22,205 $0
$22,205 $143,860
$11,102 $0
$11,102 $182,675
$22,200 $0
$22,200 $222,637
$22,205 $0
$22,205 $166,065
$11,102 $0
$11,102 $193,
$22,200 $0
$22,200 $244,837
$22,205 $0
$22,205 $188,270
$11,102 $0
$11,102 $204,879
$22,200 $0
$22,200 $267,037
$22,205 $0
$22,205 $210,475
$11,102 $0
$11,102 $215,981
$55,507 $0
$55,507 $485,465
$1,246,907 $761,442 $485,465
$55,507
$55,507
$0 $0
$55,507
$55,507
$540,972 $596,479
2007
$1,302,414 $1,357,921
$761,442 $761,442
$540,972 $596,479
$55,507 $0
$55,507 $651,986
$1,413,428 $761,442 $651,986
7
Page 18 of41
&[DATE]
SH ELL-MCCLU RG-052502
W
TOTALS
"I
2
~
~ ~
~ ~
~,::I
L'
-.
L L"I ~ ~ L L' L .)U ~ ~ .).) ,)"1 ~ ~
$1,417,200
$565,319 $298,282 $178,237 $267,037
$565,404 $354,929 $121,655 $210,475
$282,705 $108,231 $171,573 $174,474
$1,413,428 $761,442 $429,958 $651,986
$1,413,428 $761,442 $651,986
~ ~
"I
Benzene Health Research Consortium Irons Field Expenses 4Q04 Financial Report
Page 19 of41
&[DATE]
SH ELL-MCCLU RG-052503
Benzene Health Research Consortium AHS 4Q04 Financial Report
A
"I
.2
~
~ ~
~ ~
~
L'
-.
L L"I ~
'<0
Labor Budgeted Actual expense Current Variance Cumm Variance
Travel & expenses Budgeted Actual expense Current Variance Cumm Variance
Other direct expenses Budgeted Actual expense Current Variance Cumm Variance
Budgeted Actual expense Current Variance Cumm Variance
Budgeted Expense Variance
AHS (X81 07) Cost Centers
TOTALS CUMULATIVE TOTALS
~ ~ L
.)U
Blue: future cumulative variance has no meaning until Expense entered.
LT10/18/04 BJ 1125/05
B
2001 4thQtr.
C
2002 1st-4thQtr.
D
1st&2nd Qtr.
E
3rd Qtr.
2003
F
4thQtr.
G
1stQtr.
HI
2004
2nd Qtr.
3rd Qtr.
J
4thQtr.
K
1stQtr.
$84,025 $134,134 ($50,109) ($50,109)
$290,013 $394,505 ($104,492) ($154,601)
$157,756 $124,124
$33,632 ($120,970)
$78,878 $137,280 ($58,402) ($179,372)
$78,878 $73,690
$5,188 ($174,184)
$72,090 $0
$72,090 ($102,094)
$72,090 $149,980 ($77,890) ($179,984)
$72,090 $92,201 ($20,111) ($200,094)
$72,090 $162,216 ($90,126) ($290,220)
$84,217 $0
$84,217 ($206,003)
$0 $2,118 ($2,118) ($2,118)
$140,000 $39,458
$100,542 $98,424
$57,000 $16,541 $40,459 $138,883
$28,500 $12,109 $16,391 $155,274
$28,500 $16,413 $12,087 $167,361
$25,500 $0
$25,500 $192,861
$25,500 $18,534
$6,966 $199,827
$25,500 $12,522 $12,978 $212,805
$25,500 $2,564
$22,936 $235,741
$25,500 $0
$25,500 $261,241
$0 $77 ($77) $77
2001 $84,025 $136,329 ($52,304) ($52,304) 2001 $84,025 $136,329 ($52,304)
$5,500 $1,443 $4,057 $3980
200; $435,513 $435,406
$107 ($52,197) 2002 $519,538 $571,735 ($52,197)
$1,500 $0
$1,500 $5480
$216,256 $140,665
$75,591 $23,394
$735,794 $712,400
$23,394
$750 $0
$750 $6230
$108,128 $149,389 ($41,261) ($17,868)
$843,921 $861,789 ($17,868)
2003 2003
4Q03 Adjustment: expense reduced by $52,634; transferred to contingency since these were pre-consortia expenses
$750 $0
$750 $6980
$108,128 $90,103 $18,025 $157
$952,049 $951,892
$157
$750 $0
$750 $7730
$98,340 $0
$98,340 $98,497
$1,050,389 $951,892 $98,497
$750 $109 $641 $8371
$750 $785 ($35) $8,336
'0'
$98,340
$98,340
$168,623
$105,508
($70,283)
($7,168)
$28,215
$21,047
2004
$1,148,730
$1,247,070
$1,120,515
$1,226,023
$28,215
$21,047
$750 $211 $539 $8,875
$98,340 $164,991 ($66,651) ($45,604)
$1,345,410 $1,391,014
($45,604)
$750 $0
$750 $9,625
$110,467 $0
$110,467 $64,863
$1,455,877 $1,391,014
$64,863
Page 20 of41
&[DATE]
SH ELL-MCCLU RG-052504
Benzene Health Research Consortium AHS 4Q04 Financial Report
"I
.2
~
~ ~
~ ~
~
L'
-.
L L"I ~
'<0 ~
~ L .)U
L
2005 2nd Qtr.
M
3rd Qtr.
N
4thQtr.
$84,217 $0
$84,217 ($121,787)
$84,217 $0
$84,217 ($37,570)
$84,217 $0
$84,217 $46,647
$25,500 $0
$25,500 $286,741
$25,500 $0
$25,500 $312,241
$25,500 $0
$25,500 $337,741
$750
$750
$0 $750 $10,375
$0 $750 $11,125
2005
$110,467
$110,467
$0 $0
$110,467
$110,467
$175,329
$285,796
2005
$1,566,344 $1,676,810
$1,391,014 $1,391,014
$175,329
$285,796
$750 $0
$750 $11,875
$110,467 $0
$110,467 $396,263
$1,787,277 $1,391,014
$396,263
0
1stQtr.
$76,746 $0
$76,746 $123,393
$35,000 $0
$35,000 $372,741
$750 $0
$750 $12,625
$112,496 $0
$112,496 $508,759
$1,899,773 $1,391,014
$508,759
PQ
2006
2nd Qtr.
3rd Qtr.
$76,746 $0
$76,746 $200,140
$76,746 $0
$76,746 $276,886
$35,000 $0
$35,000 $407,741
$35,000 $0
$35,000 $442,741
$750
$750
$0 $750 $13,375
$0 $750 $14,125
2006
$112,496
$112,496
$0 $0
$112,496
$112,496
$621,255
$733,752
2006
$2,012,270 $2,124,766
$1,391,014 $1,391,014
$621,255
$733,752
R
4thQtr.
$76,746 $0
$76,746 $353,632
$35,000 $0
$35,000 $477,741
$750 $0
$750 $14,875
$112,496 $0
$112,496 $846,248
$2,237,262 $1,391,014
$846,248
S
1stQtr.
$10,033 $0
$10,033 $363,665
$32,000 $0
$32,000 $509,741
$3,800 $0
$3,800 $18,675
$45,833 $0
$45,833 $892,081
$2,283,095 $1,391,014
$892,081
T
2nd Qtr.
2007
U
3rd Qtr.
$0 $0 $0 $363,665
$0 $0 $0 $363,665
$0 $0 $0 $509,741
$0 $0 $0 $509,741
$0 $0
$0 $0
$0 $18,675
$0 $18,675
2007
$0 $0
$0 $0
$0 $0
$892,081
$892,081
2007
$2,283,095 $2,283,095
$1,391,014 $1,391,014
$892,081
$892,081
V
4thQtr.
$0 $0 $0 $363,665
$0 $0 $0 $509,741
$0 $0 $0 $18,675
$0 $0 $0 $892,081
$2,283,095 $1,391,014
$892,081
W
TOTALS
$1,631,795 $1,268,130
$0 $363,665
$630,000 $120,259
$0 $509,741
$21,300 $2,625 $0
$18,675
$2,283,095 $1,391,014
$0 $892,081
$2,283,095 $1,391,014
$892,081
Page 21 of41
&[DATE]
SH ELL-MCCLU RG-052505
Benzene Health Research Consortium Fudan 4Q04 Financial Report
A
FUDAN (X81 08)
Cost Centers
Labor (salary + benefits)
"I Budgeted
2 Actual expense
~ Current Variance Cumm Variance
Expenses
J:L
~
Budgeted Actual expense Current Variance
IL Cumm Variance
~ Overhead (15%) ~ Budgeted
Actual expense
Current Variance
Cumm Variance
~ LI
Budgeted Actual expense
TOTALS
-. Current Variance
Cumm Variance
CUMULATIVE TOTALS
L"I
~
'<0
Budgeted Expense Variance
~ Blue: future cumulative variance has no meaning until Expense entered. ~ LT 10120104
"L BJ 1125/05
B
2001
$9,620 $0
$9,620 $9,620
$17,600 $0
$17,600 $17,600
$4,083 $0
$4083 $4083 2001 $31,303
$0 $31,303 $31,303 2001 $31,303
$0 $31,303
C
2002
D
1Q12Q03
E
2003 3003
F
4Q03
$8,775 $8,774
$1 $9,621
$4,388 $6,492 ($2,105) $7,516
$2,194 $0
$2,194 $9,709
$1,548 $0
$1,548 $11,257
$28,400 $4,870
$23,530 $41,130
$14,200 $0
$14,200 $55,330
$7,100 $8,851 ($1,751) $53,579
$4,645 $1,168 $3,477 $57,056
$5,576 $1,825 $3,751 $7834
200; $42,751 $15,470 $27,281 $58,584 2002 $74,054 $15,470 $58,584
$2,788 $0
$2,788 $10622
$21,376 $6,492
$14,883 $73,467
$95,430 $21,962 $73,467
$1,394 $0
$1,394 $12016
2003 $10,688
$8,851 $1,837 $75,305 2003 $106,117 $30,813 $75,305
$1,095 $0
$1,095 $13111
$7,288 $1,168 $6,120 $81,425
$113,405 $31,981 $81,425
G
1Q04
$1,548 $0
$1,548 $12,805
$4,645 $0
$4,645 $61,701
$1,095 $0
$1,095 $14,206
$7,288 $0
$7,288 $88,713
$120,693 $31,981 $88,713
HI
2004
2Q04
3Q04
$1,548 $14,385 ($12,837)
($32)
$1,548 $0
$1,548 $1,516
$4,645 $9,750 ($5,105) $56,596
$4,645 $0
$4,645 $61,241
$1,095 $3,620 ($2525) $11681
$1,095 $0
$1,095 $12776
DO
$7,288
$7,288
$27,755
$0
($20,467)
$7,288
$68,246
$75,534
2004
$127,981 $135,269
$59,736
$59,736
$68,246
$75,534
J
4Q04
$1,548 $46,409 ($44,861) ($43,345)
$4,645 $10,983 ($6,338) $54,903
$1,094 $6,961 ($5,867) $6,909
$7,287 $64,354 ($57,067) $18,467
$142,556 $124,090
$18,467
K
1Q05
$1,548 $0
$1,548 ($41,797)
$4,645 $0
$4,645 $59,548
$1,094 $0
$1,094 $8003
$7,287 $0
$7,287 $25,754
$149,843 $124,090
$25,754
LM
2005
2Q05
3005
$1,548 $0
$1,548 ($40,249)
$1,548 $0
$1,548 ($38,701)
$4,645 $0
$4,645 $64,193
$4,645 $0
$4,645 $68,838
$1,094 $0
$1,094 $9,097
$1,094 $0
$1,094 $10191
'05
$7,287
$7,287
$0 $0
$7,287
$7,287
$33,041
$40,328
2005
$157,130 $164,417
$124,090 $124,090
$33,041
$40,328
N0
4Q05
$1,548 $0
$1,548 ($37,153)
$4,645 $0
$4,645 $73,483
$1,094 $0
$1,094 $11,285
1Q06
$1,548 $0
$1,548 ($35,605)
$4,645 $0
$4,645 $78,128
$1,094 $0
$1,094 $12,379
$7,287 $0
$7,287 $47,615
$7,287 $0
$7,287 $54,902
$171,704 $124,090
$47,615
$178,991 $124,090
$54,902
Note: budget is in 2001 $.
P
2006 2Q06
$1,548 $0
$1,548 ($34,057)
$4,645 $0
$4,645 $82,773
$1,094 $0
$1,094 $13473 200.
$7,287 $0
$7,287 $62,189 2006 $186,278 $124,090 $62,189
Q
3006
$1,548 $0
$1,548 ($32,509)
$4,645 $0
$4,645 $87,418
$1,094 $0
$1,094 $14567
$7,287 $0
$7,287 $69,476
$193,565 $124,090
$69,476
R
4Q06
$1,548 $0
$1,548 ($30,961)
$4,645 $0
$4,645 $92,063
$1,094 $0
$1,094 $15,661
$7,287 $0
$7,287 $76,763
$200,852 $124,090
$76,763
S
1Q07
$1,548 $0
$1,548 ($29,413)
$4,645 $0
$4,645 $96,708
$1,094 $0
$1,094 $16755
$7,287 $0
$7,287 $84,050
$208,139 $124,090
$84,050
Page 22 of41
&[DATE]
SH ELL-MCCLU RG-052506
"I
2
~
J:L
~
IL ~ ~
~ LI
-.
L"I ~ '<0 ~
~
"L
TU
2007
2Q07
3007
$1,548 $0
$1,548 ($27,865)
$1,548 $0
$1,548 ($26,317)
$4,645 $0
$4,645 $101,353
$4,645 $0
$4,645 $105,998
$1,094 $0
$1,094 $17,849
$1,094 $0
$1,094 $18,943
2007
$7,287
$7,287
$0 $0
$7,287
$7,287
$91,337
$98,624
2007
$215,426 $222,713
$124,090 $124,090
$91,337
$98,624
V
4Q07
$1,548 $0
$1,548 ($24,769)
$4,645 $0
$4,645 $110,643
$1,094 $0
$1,094 $20,037
$7,287 $0
$7,287 $105,911
$230,000 $124,090 $105,911
W
TOTALS
$51,292 $76,061
$1,548 ($24,769)
$146,265 $35,622 $4,645
$110,643
$32,443 $12,406
$1,094 $20,037
$230,000 $124,090
$7,287 $105,911
$230,000 $124,090 $105,911
Benzene Health Research Consortium Fudan 4Q04 Financial Report
Page 23 of41
&[DATE]
SH ELL-MCCLU RG-052507
A
SRP + ERP (X8109)
Cost Centers
Albertini
Budgeted Actual expense CurrentVanance
~ ~
CummVanance Brody (DB5200X1503, resigned 4003)
Budgeted
Actual expense
CurrentVanance
I L Cumm Vanance
Checkoway
'" Budgeted Actual expense
1::1 L.
CurrentVanance CummVanance Cherrie/lOM Budgeted Actual expense CurrentVanance CummVanance Greim Budgeted
Actual expense
L. CurrentVanance
CummVanance
~Herrick
~
")l.
Budgeted Actual expense
)L
~
..)"+
CurrentVanance Cumm Vanance Idanpaan-Heikkila Budgeted
..):: Actual expense
~
CurrentVanance
~ Cumm Vanance
")C Larson
..)t1 Budgeted
~
Actual expense
~ CurrentVanance
"+. CummVanance
"+.: Li
~
Budgeted
~
Actual expense
"+1: CurrentVanance
,,+, CummVanance
~Minden/OntarioCancerlnstitute
~
::>l.
Budgeted Actual expense
CurrentVanance
)L Cumm Vanance
~ Mueller (resigned 2003)
::>"+ Budgeted
::>::
~
Actual expense CurrentVanance
~ Cumm Vanance
::>C Rice ::>t1
~
Budgeted Actual expense
~ CurrentVanance
CummVanance
0': Rockette
~
Budgeted
~
01:
Actual expense CurrentVanance
CummVanance
~
Budgeted
Actual expense
CurrentVanance
, L Cumm Vanance
Clayton (joined 2004)
'" Budgeted Actual expense
CurrentVanance
CummVanance
Lombardo (joined 2004)
Budgeted
Actual expense
CurrentVanance OL. CummVanance
O~ TOTALS
Budgeted
Actual expense
OC CurrentVanance
CummulatlveVanance
CUMULATIVE TOTALS
Budgeted
Expense
Vanance
B
2001 4thOtr
c
2002 1st-4thOtr
DIE I F
2003
1st&2ndOtr
3rdOtr
4thOtr
Benzene Health Research Consortium SRP + ERP 4Q04 Financial Report
G
1stOtr
IHI I J
2004
2ndOtr
3rdOtr
4thOtr
K
1stOtr
I LIM
2005
2ndOtr
3rdOtr
IN
4thOtr
o
1stOtr
IP
Q
2006
2ndOtr
3rdOtr
IR
4thOtr
SIT I U I V
2007
1stOtr
2ndOtr
3rdOtr
4thOtr
w
TOTALS
$2,160 $2,000
$160 $160
$8,640 $0
$8,640 $8,800
$4,320 $0
$4,320 $13,120
$2,160 $0
$2,160 $15,280
$322 $2,529 ($2,207) $13,073
($13,073) $0
($13,073) $0
$0
$250
$3,000
$0
$0
$250
$3,000
$0
$0
$250
$3,000
$0
$0
$250
$3,000
$0 $0 $3,401 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $250
($401)
$0
$0
$250
$3,000
$0
$0
$250
$3,000
$0
$0
$250
$3,000
$0 $250
($151)
($151)
($151)
$99 $3,099 $3,099 $3,099 $3,349 $6,349 $6,349 $6,349 $6,599 $9,599
$17,529 $7,930 $3,000 $9,599
$2,160 $0
$2,160 $2,160
$8,640 $0
$8,640 $10,800
$4,320 $0
$4,320 $15,120
$2,160 $0
$2,160 $17,280
$322 $0
$322 $17,602
($17,602) $0
($17,602) $0
$0 $1,500 ($1,500) ($1,500)
$0 $0 $0 ($1,500)
$0 $0 $0 ($1,500)
$0 $0 $0 ($1,500)
$0 $0 $0 ($1,500)
$0 $0 $0 ($1,500)
$0 $0 $0 ($1,500)
$0 $0 $0 ($1,500)
$0 $0 $0 ($1,500)
$0 $0 $0 ($1,500)
$0 $0 $0 ($1,500)
$0 $0 $0 ($1,500)
$0 $0 $0 ($1,500)
$0 $0 $0 ($1,500)
$0 $0 $0 ($1,500)
$0 $1,500
$0 $0
$2,160 $1,000 $1,160 $1,160
$8,640 $0
$8,640 $9,800
$4,320 $0
$4,320 $14,120
$2,160 $2,422 ($262)
1.858
$322 $0
$322 $14,180
($14,180) $0
($14,180) $0
$0
$250
$3,000
$0 $0 $3,036
$0 $250
($36)
$0 $250
$214
$0 $0 $0 $214
$0 $0 $0 $214
$250 $0
$250 $464
$3,000 $0
$3,000 $3,464
$0 $0 $0 $3,464
$0 $0 $0 $3,464
$250 $0
$250 $3,714
$3,000 $0
$3,000 $6,714
$0 $0 $0 $6,714
$0 $0 $0 $6,714
$250 $0
$250 $6,964
$3,000 $0
$3,000 $9,964
$16,422 $6,458 $3,000 $9,964
$2,160 $0
$2,160 $2,160
$8,640 $2,122 $6511 $8,678
$4,320 $0
$4,320 $12,998
$2,160 $0
$2,160 115.158
$322 $0
$322 $15,480
($15,480) $0
($15,480) ($0)
$0 $7,029 ($7,029) ($7,029)
$250 $0
$250 ($6,779)
$8,000 $10,229 ($2,229) ($9,008)
$0 $0 $0 ($9,008)
$0 $0 $0 ($9,008)
$250 $0
$250 ($8,758)
$8,000 $0
$8,000 ($758)
$0 $0 $0 ($758)
$0 $0 $0 ($758)
$250 $0
$250 ($508)
$6,000 $0
$6,000 $5,492
$0 $0 $0 $5,492
$0 $0 $0 $5,492
$250 $0
$250 $5,742
$2,000 $0
$2,000 $7,742
$27,122 $19,380
$2,000 $7,742
$2,160 $0
$2,160 $2,160
$8,640 $0
$8,640 $10,800
$4,320 $0
$4,320 $15,120
$2,160 $0
$2,160 $17,280
$322 $7,334 ($7,012) $10,268
($10,268) $0
($10,268) $0
$0
$250
$8,000
$0
$0
$250
$8,000
$0
$0
$250
$6,000
$0
$0
$250
$2,000
$0 $0 $3338 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0
$250
$4,662
$0
$0
$250
$8,000
$0
$0
$250
$6,000
$0
$0
$250
$2,000
$0
$250
$4,912
$4,912
$4,912
$5162
$13162
$1
$13162
$13,412
$19,412
$19,412
$19,412
$19,662
$21,662
$32,334 $10,672
$2,000 $21,662
$2,160 $2,000
$160 $160
$8,640 $0
$8,640 $8,800
$4,320 $0
$4,320 $13,120
$2,160 $0
$2,160 $15,280
$322 $4,454 ($4,132) $11,148
($11,148) $0
($11,148) $0
$0
$250
$3,000
$0
$0
$250
$3,000
$0
$0
$250
$3,000
$0
$0
$250
$2,000
$0 $0 $415 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0
$250
$2,585
$0
$0
$250
$3,000
$0
$0
$250
$3,000
$0
$0
$250
$2,000
$0
$250
$2,835
$2,835
$2,835
$3,085
$6,085
$6,085
$6,085
$6335
$9335
$9335
$9335
$9,585
$11,585
$18,454 $6,869 $2,000
$11,585
$2,160 $0
$2,160 $2,160
$8,640 $0
$8,640 $10,800
$4,320 $4,344
($24) $10,776
$2,160 $180
$1,980 $12,756
$322 $0
$322 $13,078
($13,078) $0
($13,078) $0
$0
$250
$8,000
$0 $0 $7,620
$0 $250
$380
$0 $250
$630
$0 $0 $0 $630
$0 $0 $0 $630
$250 $0
$250 $880
$8,000 $0
$8,000 $8,880
$0 $0 $0 $8,880
$0 $0 $0 $8,880
$250 $0
$250 $9,130
$8,000 $0
$8,000 $17,130
$0 $0 $0 $17,130
$0 $0 $0 $17,130
$250 $0
$250 $17,380
$8,000 $0
$8,000 $25,380
$37,524 $12,144
$8,000 $25,380
$2,160 $2,127
$3 $3
$8,640 $0
$8,640 $8,673
$4,320 $0
$4,320 $12,993
$2,160 $2,636 ($476) $12,517
$322 $0
$322 $12,839
($12,839) $0
($12,839) $0
$0
$250
$3,000
$0 $0 $2,850
$0 $250
$150
$0 $250
$400
$0 $0 $0 $400
$0 $0 $0 $400
$250 $0
$250 $650
$3,000 $0
$3,000 $3,650
$0 $0 $0 $3,650
$0 $0 $0 $3,650
$250 $0
$250 $3,900
$3,000 $0
$3,000 $6,900
$0 $0 $0 $6,900
$0 $0 $0 $6,900
$250 $0
$250 $7,150
$2,000 $0
$2,000 $9,150
$16,763 $7,613 $2,000 $9,150
$2,160 $6,796 ($4,636) ($4,636)
$8,640 $3,000 $5,640 $1,004
$4,320 $0
$4,320 $5,324
$2,160 $0
$2,160 $7,484
$322 $13,094 ($12,772) ($5,288)
$5,288 $0
$5,288 $0
$0
$250
$10,000
$0
$0
$250
$10,000
$0
$0
$250
$10,000
$0
$0
$250
$4,000
$0 $0 $6,477 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0
$250
$3523
$0
$0
$250
$10,000
$0
$0
$250
$10,000
$0
$0
$250
$4,000
$0
$250
$3,773
$3,773
$3,773
$4,023
$14,023
$14,023
$14,023
$14,273
$24,273
$24,273
$24,273
$24,523
$28,523
$57,890 $29,367
$4,000 $28,523
$2,160 $1,000 $1,160 $1,160
$8,640 $0
$8,640 $9,800
$4,320 $0
$4,320 $14,120
$2,160 $0
$2,160 $16,280
$322 $0
$322 $16,602
($16,602) $0
($16,602) $0
$0
$250
$3,000
$0
$0
$250
$3,000
$0
$0
$250
$3,000
$0
$0
$250
$2,000
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0
$0
$250
$3,000
$0
$0
$250
$3,000
$0
$0
$250
$3,000
$0
$0
$250
$2,000
$0
$250
$3,250
$3,250
$3,250
$3,500
$6,500
$6,500
$6,500
$6,750
$9,750
$9,750
$9,750
$10,000
$12,000
$13,000 $1,000 $2,000
$12,000
$2,160
$8,640
$4,320
$2,160
$322
($16,352)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$1,250
$1,250
$0
$0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,250
$910
$8,640
$4,320
$2,160
$322
($16,352)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$910
$9,550
$13,870
$16,030
$16,352
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0
$2,160 $0
$2,160 $2,160
$8,640 $0
$8,640 $10,800
$4,320 $4,000
$320 $11,120
$2,160 $5,692 ($3,532) $7,588
$322 $2,000 ($1,678) $5,910
($5,410) $500
($5,910) ($0)
$3,000 $3,500 ($500) ($500)
$1,500 $2,500 ($1,000) ($1,500)
$4,000 $6,31 ($2,311) ($3,811)
$1,500 $0
$1,500 ($2,311)
$1,000 $0
$1,000 ($1,311)
$1,500 $0
$1,500 $189
$4,000 $0
$4,000 $4,189
$1,000 $0
$1,000 $5189
$1,000 $0
$1,000 $6,189
$1,000 $0
$1,000 $7,189
$4,000 $0
$4,000 $1,189
$1,000 $0
$1,000 $12,189
$1,000 $0
$1,000 .189
$1,000 $0
$1,000 $14,189
$3,000 $0
$3,000 $17,189
$41,692 $24,503
$3,000 $17,189
$2,160 $0
$2,160 $2,160
$8,640 $0
$8,640 $10,800
$4,320 $0
$4,320 $15,120
$2,160 $0
$2,160 $17,280
$322 $2,670 ($2,348) $14,932
($14,932) $0
($14,932) $0
$0
$250
$3,000
$0 $0 $2,775
$0 $250
$225
$0 $250
$475
$0 $0 $0 $475
$0 $0 $0 $475
$250 $0
$250 $725
$3,000 $0
$3,000 $3,725
$0 $0 $0 $3,725
$0 $0 $0 $3,725
$250 $0
$250 $3,975
$3,000 $0
$3,000 $6,975
$0 $0 $0 $6,975
$0 $0 $0 $6,975
$250 $0
$250 $7,225
$2,000 $0
$2,000 $9,225
$14,670 $5,445 $2,000 $9,225
$2,160 $2,500 ($340) ($340)
$8,640 $0
$8,640 $8,300
$4,320 $1,650 $2,670 $10,970
$2,160 $6,054 ($3,894) $7,076
$322 $0
$322 $7,398
($7,398) $0
($7,398) $0
$0
$250
$10,000
$0
$0
$250
$10,000
$0
$0
$250
$10,000
$0
$0
$250
$2,000
$0 $0 $10,575 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $250
($575)
$0
$0
$250
$10,000
$0
$0
$250
$10,000
$0
$0
$250
$2,000
$0 $250
($325)
($325)
($325)
($75)
$9,925
$9,925
$9,925
$10,175
$20,175
$20,175
$20,175
$20,425
$22,425
$43,204 $20,779
$2,000 $22,425
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0
$0
$250
$3,000
$0
$0
$250
$3,000
$0
$0
$250
$3,000
$0
$0
$250
$3,000
$13,000
$0 $0 $0 $6,009 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,009
$0
$0
$250
($3,009)
$0
$0
$250
$3,000
$0
$0
$250
$3,000
$0
$0
$250
$3,000
$3,000
$0
$0
$250
($2,759)
($2,759)
($2,759)
($2,509)
$491
$491
$491
$741 $3,741 $3,741 $3,741 $3991 $6,991
$6,991
$0 $0 $0 $0
2001 $30,240 $18,673 $11,567 $11,567 2001 $30,240 $18,673 $11,567
$0 $0 $0 $0
2002 $120,960
$5,122 $115838 $127,405 2002 $151,200
$23,795 $127,405
$0 $0 $0 $0
$60,480 $9,994
$50,486 $177,891
$211,680 $33,789
$177,891
$0 $0 $0 $0
2003 $30,240 $16,984 $13,256
$191,147 2003 $241,920
$50,773 $191,147
$0 $0 $0 $0
$4,508 $32,081 ($27,573) $163,574
$246,428 $82,854
$163,574
$0 $0 $0 $0
($163,074) $500
($163,574) $0
$83,354 $83,354
($0)
$0 $250 $0 $0 $0 $250 $0 $250
2004 $3,000 $12,029 ($9,029) ($9,029)
2004 $86,354 $95,38: ($9,029)
$4,500 $2,500 $2,000 ($7,029)
$90,854 $97,883 ($7,029)
$3,000 $5,853 ($2,853) ($2,603)
$69,000 $68,889
($6,917)
$159,854 $166,772
($6,918)
$0 $0 $0 ($:,603)
$1,500 $0
$1,500 ($5,417)
$161,354 $166,772
($5,418)
$0 $0 $0 ($203)
$250 $0
$250 ($2,353
2005
$1,000
$4,500
$0 $0
$1,000
$4,500
($4,417)
$83
2005
$162,354
$166,854
$166,772
$166,772
($4,418)
$82
$3,000 $0
$3,000 $647
$69,000 $0
$69,000 $69,083
$235,854 $166,772
$69,082
$0 $0 $0 $647
$1,000 $0
$1,000 $70,083
$236,854 $166,772
$70,082
$0 $0 $0 $647
$250 $0
$250 $897
2006
$1,000
$4,000
$0 $0
$1,000
$4,000
$71,083
$75,083
2006
$237,854
$241,854
$166,772
$166,772
$71,082
$75,082
$3,000 $0
$3,000 $3,897
$65,000 $0
$65,000 $140,083
$306,854 $166,772 $140,082
$0 $0 $0 $3,897
$1,000 $0
$1,000 $141,083
$307,854 $166,772 $141,082
$0 $0 $0 $3,897
$250 $0
$250 $4,147
2007
$1,000
$4,000
$0 $0
$1,000
$4,000
$142,083
$146,083
2007
$308,854
$312,854
$166,772
$166,772
$142,082
$146,082
$3,146 $0
$3,146 $7,293
$38,000 $0
$38,000 $184,083
$350,854 $166,772 $184,082
$13,146 $5,853 $3,146 $7,293
$350,854 $166,772
$38,000 $184,083
$350,854 $166,772 $184,082
.,,",'TI
SH ELL-MCCLU RG-052508
A IBI c I D I E
-"'"
""::I~
::It
Blue fulure cumulallvevanance has no meaning unlll Expense enlered
LT10/20/04 BJ2/04/05
Benzene Health Research Consortium SRP + ERP 4Q04 Financial Report
F G IHI I I J I K L M N 0
1Q04 budget ajustments 10 zero ourvanancelo develop more usefuI
1:~2d,i:~lmeetmq
C c" ChangeapprovedbyOCal
PQ RS TUV
W
Page 25 of41
&[DATE]
SH ELL-MCCLU RG-052509
Benzene Health Research Consortium Communications 4Q04 Financial Report
~ ~ APCO
"I Budgeted Actual expense CurrentVariance Cumm Variance
Travel ~ Budgeted
Actual expense CurrentVariance Cumm Variance
Other
L<L Budgeted
~ Actual expense CurrentVariance Cumm Variance
A
COMMUNICATIONS Cost Centers
B
2001 lst- 4th OtL
CD
2002 lst- 4th OtL 1st & 2nd OtL
E
2003 3rd OtL
$57,600 $0
$57,600 $57,600
$230,400 $232,229
($1,829) $55,771
$120,000 $14,483
$105,517 $161,288
$60,000 $7,351
$52,649 $213,937
$1,800 $0
$1,800 $1,800
$7,200 $7,091
$109 $1,909
$3,750 $0
$3,750 $5,659
$1,875 $526
$1,349 $7,008
$600 $0
$600 $600
$2,400 $1,417
$983 $1,583
$1,250 $80
$1,170 $2,753
$625 $0
$625 $3,378
G:L
'[ ~ ~
~"I L~
~
Budgeted Actual expense CurrentVariance Cumm Variance
Budgeted Actual expense CurrentVariance Cumm Variance
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
L~ Budgeted
$0.00
~ Actual expense ~ CurrentVariance
Cumm Variance
$0.00 $0.00 $0.00
.)~
~ ~
.)t
Budgeted Actual expense CurrentVariance
$0.00 $0.00 $0.00
;j, Cumm Variance
$0.00
~ ~
"I~
4'
Budgeted Actual expense CurrentVariance
TOTALS
2001
$60,000 $0
$60,000
~
Cumm Variance
~ CUMULATIVE TOTALS
"1"1 Budgeted
2001
$60,000 $60,000
4~ Expense
$0
"10 Variance
$60,000
"I, - Telecommunications, Consulting Services, Duplicating/Copies Internal, Postage, Couriers, Telephone, Meals, Lexis Nexis Searches
~ Blue: future cumulative variance has no meaning until Expense entered. ~ "- Budget adjustment reflects budget reduction from $1 MM to $550k
:)~
o LT 1/28/05 )L RT 1/21/05
'budget adjustment to lower program budget from $550K to $300K, as approved by OC on
$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 2002 $240,000 $240,738 ($738) $59,262 2002 $300,000 $240,738 $59,262
$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
$125,000 $14,564
$110,436 $169,699
$425,000 $255,301 $169,699
$0.00 $0.00 $0.00 $0.00 2003 $62,500 $7,877 $54,623 $224,322 2003 $487,500 $263,178 $224,322
Page 26 of41
&[DATE]
SHELL-MCCLURG-052510
Benzene Health Research Consortium Communications 4Q04 Financial Report
F
~ 4lh OIL" ~ "I ($187,396)
$26,541 ($213,937)
($0)
~ ($5,876) $1,132 ($7,008) $0
L<L ($3,364)
~ $15 ($3,379) ($2
G
1sl0lL
$14,401 $0
$14,401 $14,401
$450 $0
$450 $450
$150 $0
$150 $148
HI
2004 2nd OIL 3rd OIL
J
4lh Olr'
K
1sl0lL
LM
2005 2nd OIL 3rd OIL
N
4lh OIL
0
1sl0lL
PQ
2006 2nd OIL 3rd OIL
R
4lh OIL"
$14,400 $14,400 ($39,906)
$790
$1,235 $1,270
$0
$0
$0
$0
$0
$0
$0
$0
$13,610 $13,165 ($41,176)
$0
$0
$0
$0
$0
$0
$0
$0
$28,011 $41,176
($0) ($0) ($0) ($0) ($0) ($0) ($0) ($0)
($0)
$450
$450 ($1,350)
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$450
$450 ($1,350)
$0
$0
$0
$0
$0
$0
$0
$900
$1,350
$0 $0 $0 $0
$0
$0
$0
$0
$0 $0 $0
$150
$150
($448)
$1,946
$1,946
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$150
$150
($448)
$0
$0
$0 $1,946
$0
$0
$0 $1,946
$298
$448
$0
$0
$0
$0 $1947 $1,947 $1,947 $1,947
$3,893
S
1sl0lL
TU
2007 2nd OIL 3rd OIL
V
4lh OIL
$0 $0 $0 $0 $0 $0 $0 $0 ($0) ($0) ($0) ($0)
$0 $0 $0
$0 $0 $3,893
$0 $0 $0
$0 $0 $3,893
$0 $0 $0
$0 $0 $3,893
$0 $0 $0
$1,946 $0
$1,946 $5,839
W
TOTALS
$283,899 $283,899
($0) ($0)
$8,749 $8,749
$0 $0
$7,352 $1,513 $5,839 $5839
G:L
'[ ~ ~
~"I L~
~
$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
L~ ~ ~
.)~
~ ~
.)t
;j,
~ ~
"I~
4'
~ ~ "1"1 4~
"10
"I,
~ ~
:)~
o )L
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
($196,636) $27,688
($224,324) ($2)
$290,864 $290,866
($2)
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$15,001 $0
$15,001 $14,999
$305,865 $290,866
$14,999
$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
$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
$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
2004
$15,000 $15,000
$790
$1,235
$14,210 $13,765
$29,209 $42,974
2004
$320,865 $335,865
$291,656 $292,891
$29,209 $42,974
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
($41,704) $1,270
($42,974) $0
$0 $0 $0 $0
$294,161 $294,161 $294,161 $294,161
$0 $0
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
2005
$0 $0
$0 $0
$0 $0
$0 $0
2005
$294,161 $294,161
$294,161 $294,161
$0 $0
$0.00 $0.00 $0.00 $0.00
$1,946 $0
$1,946 $1,946
$296,107 $294,161
$1,946
$0.00 $0.00 $0.00 $0.00
$0 $0 $0 $1,946
$296,107 $294,161
$1,946
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
2006
$0 $0
$0 $0
$0 $0
$1,946 $1,946
2006
$296,107 $296,107
$294,161 $294,161
$1,946 $1,946
$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 $0
$1,946 $3,893
$298,054 $294,161
$3,893
$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 $0 $0 $3,893
$298,054 $294,161
$3,893
$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
2007
$0 $0
$0 $0
$0 $0
$3,893
$3,893
2007
$298,054 $298,054
$294,161 $294,161
$3,893
$3,893
$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 $0
$1,946 $5,839
$300,000 $294,161
$5,839
$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
$300,000 $294,161
$3,893 $5,839
$300,000 $294,161
$5,839
Page 27 of41
&[DATE]
SHELL-MCCLURG-052511
Benzene Health Research Consortium Legal 4Q04 Financial Report
A
LEGAL
Cost Centers Steptoe &Johnson "I Budgeted
.2 Actual expense
~ CurrentVariance Cumm Variance
B
2001 1st-4thQtr.
C
2002 1st-4thQtr.
D
1st&2nd Qtr.
$30,000 $0
$30,000 $30,000
$120,000 $13,565
$106,435 $136,435
$62,500 $1,728
$60,772 $197,207
~ ~
Budgeted Expense Variance
Blue: future cumulative variance has no
12 meaning until Expense entered.
$30,000 $0
$30,000
$150,000 $13,565
$136,435
$212,500 $15,293
$197,207
* budget adjustment to lower program
budget from $500K to $1 OOK, as approved
14 by DC on 11/11/03 12
~ LT7/19/04 RT 1121/05
E
2003 3rd Qtr.
$31,250 $0
$31,250 $228,457
$243,750 $15,293
$228,457
F
4th Qtr.*
G
1stQtr.
HI
2004
2nd Qtr.
3rd Qtr.
($210,542) $17,915
($228,457) $0
$4,175 $365
$3,810 $3,810
$4,175 $2,995 $1,180 $4990
$4,175 $1,870 $2,305 $7,294
$33,208 $33,208
$0
$37,383 $33,572
$3,810
$41,557 $36,567
$4,990
$45,732 $38,437
$7,294
J
4thQtr.
K
1stQtr.
LM
2005
2nd Qtr.
3rd Qtr.
N
4thQtr.
$4,175 $26,092 ($21,918) ($14,623)
$4,175 $0
$4,175 ($10449
$4,175 $0
$4,175 ($6,274
$4,175 $0
$4,175 ($2100
$4,175 $0
$4,175 $2,075
$49,906 $64,529 ($14,623)
$54,081 $64,529 ($10,449)
$58,255 $64,529 ($6,274)
$62,430 $64,529 ($2,100)
$66,604 $64,529
$2,075
0
1stQtr.
PQ
2006
2nd Qtr.
3rd Qtr.
R
4thQtr.
$4,175 $0
$4,175 $6,249
$4,175 $0
$4,175 $10,424
$4,175 $0
$4,175 $14,598
$4,175 $0
$4,175 $18, 73
$70,779 $64,529
$6,249
$74,953 $64,529 $10,424
$79,128 $64,529 $14,598
$83,302 $64,529 $18,773
S
1stQtr.
TU
2007
2nd Qtr.
3rd Qtr.
$4,175 $0
$4,175 $22,9"
$4,175 $0
$4,175 $27122
$4,175 $0
$4,175 $31,296
$87,477 $64,529 $22,947
$91,651 $64,529 $27,122
$95,826 $64,529 $31,296
V
4thQtr.
$4,175 $0
$4,175 $35,471
$100,000 $64,529 $35,471
Page 28 of41
&[DATE]
SHELL-MCCLURG-052512
W
TOTALS L.
--zt $100,000 0 $64,529
$35,471 $35,471
--g- $100,000 IU $64,529
$35,471
12
14
f5"
10
Benzene Health Research Consortium Legal 4Q04 Financial Report
Page 29 of41
&[DATE]
SHELL-MCCLURG-052513
Benzene Health Research Consortium QA-QC 4Q04 Financial Report
A
QA-QC ~ Cost Centers ~ Contractor "I Budgeted 0 Actual expense ~ CurrentVariance
Cumm Variance
Travel ~ Budgeted
LlL Actual expense
CurrentVariance
Cumm Variance Budgeted
L<l Actual expense 12 CurrentVariance
Cumm Variance
BC
D
2001
2002
1st- 4th OtL 1st- 4th OtL 1st & 2nd OtL
E
2003 3rd OtL
F
4th OtL
G
1stOtL
HI
2004 2nd OtL 3rd OtL
J
4th Otr"
KLM
2005 1stOtL 2nd OtL 3rd OtL
N
4th OtL
0
1stOtL
PQ
2006 2nd OtL 3rd OtL
R
4th OtL
S
1stOtL
TU
2007 2nd OtL 3rd OtL
V
4th OtL
$13,500 $0
$13,500 $13,500
$54,000 $0
$54,000 $67,500
$28,126 $0
$28,126 $95,626
$14,063 $0
$14,063 $109,689
($109,689) $0
($109,689) $0
$6,250 $0
$6,250 $6,250
$6,250 $0
$6,250 $12,500
$6,250 $0
$6,250 $18,750
($18,750) $0
($18,750) $0
$4,167 $0
$4,167 $4,167
$4,167 $0
$4,167 $8,333
$4,167 $0
$4,167 $12,500
$4,167 $0
$4,167 $16,667
$4,167 $0
$4,167 $20,833
$4,167 $0
$4,167 $25,000
$4,167 $0
$4,167 $29,167
$4,167 $0
$4,167 $33,333
$4,167 $0
$4,167 $37,500
$4,167 $0
$4,167 $41,667
$4,167 $0
$4,167 $45,833
$4,167 $0
$4,167 $50,000
$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 $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
$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
$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
$0
$0 $0
$0
$0 $0
$0
$0
~ ~ L'
l.
~ ~ L"I
l.o
~ ., L,
l.~
~
Budgeted Actual expense CurrentVariance Cumm Variance
Budgeted Actual expense CurrentVariance Cumm Variance
Budgeted Actual expense CurrentVariance Cumm Variance
$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
$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
$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
$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
$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
$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 $0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
;j;j Budgeted
~ ~
,)0
Actual expense CurrentVariance Cumm Variance
;j, TOTALS
~
Budgeted
~
Actual expense
"IU CurrentVariance
4' Cumm Variance
~ CUMULATIVE TOTALS
~
Budgeted
"1"1 Expense
40 Variance
Dlue: u ure cumu a Ive
variance has no meaning
46 until Expense entered. 4,
$0 $0 $0 $0
2001 $13,500
$0 $13,500 $13,500 2001 $13,500
$0 $13,500
$0 $0 $0 $0
2002 $54,000
$0 $54,000 $67,500 2002 $67,500
$0 $67,500
$0 $0 $0 $0
$28,126 $0
$28,126 $95,626
$95,626 $0
$95,626
* budget adjustment to lower program ** budget adjustment to lower program
budget from $225K to $1 OOK, as
budget from $100K to $50K, as approved
48 approved by DC on 11/11/03
by OC on 12/16/04
4~
OL LT 1128105
$0 $0 $0 $0
2003 $14,063
$0 $14,063 $109,689 2003 $109,689
$0 $109,689
$0 $0 $0 $0
($109,689) $0
($109,689) $0
$0 $0 $0
$0 $0 $0 $0
$6,250 $0
$6,250 $6,250
$6,250 $0
$6,250
$0 $0 $0 $0 $0 $0 $0 $0
2004 $6,250 $6,250
$0 $0 $6,250 $6,250 $12,500 $18,750
2004 $12,500 $18,750
$0 $0 $12,500 $18,750
$0 $0 $0 $0 $0 $0 $0 $0
($18,750) $0
($18,750) $0
$4,167 $0
$4,167 $4,167
$0 $4,167 $0 $0 $0 $4,167
$0 $0 $0 $0 $0 $0 $0 $0
2005 $4,167 $4,167
$0 $0 $4,167 $4,167 $8,333 $12,500
2005 $8,333 $12,500
$0 $0 $8,333 $12,500
$0 $0 $0 $0
$4,167 $0
$4,167 $16,667
$16,667 $0
$16,667
$0 $0 $0 $0
$4,167 $0
$4,167 $20,833
$20,833 $0
$20,833
$0 $0 $0 $0 $0 $0 $0 $0
2006 $4,167 $4,167
$0 $0 $4,167 $4,167 $25,000 $29,167
2006 $25,000 $29,167
$0 $0 $25,000 $29,167
$0 $0 $0 $0
$4,167 $0
$4,167 $33,333
$33,333 $0
$33,333
$0 $0 $0 $0
$4,167 $0
$4,167 $37,500
$37,500 $0
$37,500
$0 $0 $0 $0 $0 $0 $0 $0
2007 $4,167 $4,167
$0 $0 $4,167 $4,167 $41,667 $45,833
2007 $41,667 $45,833
$0 $0 $41,667 $45,833
$0 $0 $0 $0
$4,167 $0
$4,167 $50,000
$50,000 $0
$50,000
Page 30 of41
&[DATE]
SHELL-MCCLURG-052514
W
TOTALS
~ ~ "I $50,000 0 $0
~ $50,000 $50,000
~ $0
LlL $0
$0 $0 $0
L<l $0 12 $0
$0
~ ~ L'
l.
~ ~ L"I
l.o
~ ., L,
l.~
~
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
;j;j
~ ~
,)0
;j,
~ ~ "IU 4'
~ ~ "1"1 40
$0 $0 $0 $0
$50,000 $0
$50,000 $50,000
$50,000 $0
$50,000
46
4,
48
4~
OL
Benzene Health Research Consortium QA-QC 4Q04 Financial Report
Page 31 of41
&[DATE]
SHELL-MCCLURG-052515
A
API
Cost Centers
Salaries
~ Budgeted
.2 Actual expense
CurrentVariance
Cumm Variance
~ Employee Benefits ~ Budgeted
Actual expense
CurrentVariance
~ Cumm Variance
~ Travel 1"1 Budgeted
10 Actual expense
~ CurrentVariance
Cumm Variance
Other Operating Expenses (& mtgs)
I~ Budgeted
~
Actual expense
-. CurrentVariance
L. Cumm Variance
L API Recovered Overhead
~
Budgeted
~ L'
Actual expense CurrentVariance
l. Cumm Variance
~ API Allocated Costs
~
Budgeted
,)u Actual expense
;j' CurrentVariance
~
Cumm Variance
~ Supported Expense ,)"1 Budgeted
;jo Actual expense
~ .",
CurrentVariance Cumm Variance
;jts rALS
;j~ Budgeted
~ ~ ~
Actual expense CurrentVariance Cumm Variance
4;j CUMULATIVE TOTALS
~ ~
"It
Budgeted Expense Variance
"I,
~ LT 7/19/04 ~ RT 1/21/05 :>u
Assumptions:
~ Year 5, 6,7 Less than 1 FTE al/ocated, based al/ocated cost on 112 FTE ~ T&E and Other $15K for Annual Meeting (3rd Quarter) :>"1 Sup,:,orted Ex. ense dro off Jeft some funds for consultant
Benzene Health Research Consortium API Administration 4Q04 Financial Report
B C D E IF
2000
2001
2002
2003
Ist- 4th OtL Ist- 4th OtL Ist- 4th OtL 1st & 2nd OtL 3rd OtL
G
4th OtL
H
IstOtL
IJ
2004 2nd OtL 3rd OtL
K 4th OtL
L
IstOtL
MI NI 0
2005
2nd OtL 3rd OtL 4th OtL
P
IstOtL
$0 $9,039 ($9,039) ($9,039)
$26,045 $18,749
$6,552 ($2,487)
$104,180 $89,669 $14,511 $12,024
$54,260 $57,297 ($3,037)
$8,987
$27,130 $32,217 ($5,087)
$3,900
$22,250 $32,800 ($10,550) ($6,650)
$22,000 $26,745 ($4,745) ($11,395)
$22,000 $25,357 ($3,357) ($14,752)
$22,000 $21,839
$161 ($14,591)
$20,000 $21,813 ($1,813) ($16,404)
$12,000 $0
$12,000 ($4,404)
$10,000 $0
$10,000 $5,596
$14,000 $0
$14,000 $19,596
$10,000 $0
$10,000 $29,596
$12,000 $0
$12,000 $41,596
$0 $774 ($774) ($774)
$3,256 $2,329
$927 $153
$13,022 $11,209
$1,813 $1,966
$
6,783 $ 3,391
$7,163 $4,027
($380) $ (636)
$1,586
$950
$2,750 $ 3,000 $ 3,000 $ 3,000
$4,100
$3,343
$3,169
$2,730
($1,350)
($343) $ (169)
$270
($400)
($743)
($912)
($642)
$2,900 $2,727
$173 ($469)
$1,100 $0
$1,100 $631
$1,000 $0
$1,000 $1,631
$1,400 $0
$1,400 $3,031
$1,000 $0
$1,000 $4,031
$1,100 $0
$1,100 $5,131
$0 $342 ($342) ($342)
$3,256 $1,487 $1,769 $1,427
$13,022 $8,004 $5,018 $6,445
6,783 $308 $6,475 $12,920
$3,391 $1,683 $1,708 $14,628
$7,500 $7,313
$187 $14,815
1,000 $0
$1,000 $15,815
$1,000 $1,152 ($152) $15,663
$3,000 $2,027
$973 $16,636
$1,000 $1,710 ($710) $15,926
$1,000 $0
$1,000 $16,926
$1,000 $0
$1,000 $17,926
$5,000 $0
$5,000 $22,926
$1,000 $0
$1,000 $23,926
$1,000 $0
$1,000 $24,926
$0 $1,673 ($1,673) ($1,673)
$651 $9,196 ($8,545) ($10,218)
$2,604 $16,270 ($13,666) ($23,884)
$1,359 $13,292 ($11,933) ($35,817)
$679 $72
$607 ($35,210)
$16,184 $26,276 ($10,092) ($45,302)
$2,000 $3,600 ($1,600) ($46,902)
$2,000 $3,808 ($1,808) ($48,710)
$6,000 ($3,223)
$9,223 ($39,487)
$2,000 $11,398 ($9,398) ($48,885)
$500 $0
$500 ($48,385)
$430 $0
$430 ($47,955)
$5,000 $0
$5,000 ($42,955)
$400 $0
$400 ($42,555)
$400 $0
$400 ($42,155)
$0 $5,752 ($5,752) ($5,752)
$8,465 $4,687 $3,778 ($1,974)
$33,858 $25,110
$8,748 $6,774
$
17,635 $16,043
$1,592 $8,366
$ 8,817 $9,021 ($204)
$8,162
$6,250 $ 6,200 $ 6,200 $ 6,200 $ 6,000
$9,185
$7,489
$7,099
$6,115
$6,107
($2,935) ($1,289)
($899)
$85 ($107)
$5,227
$3,938
$3,039
$3,124
$3,017
$3,500 $0
$3,500 $6,517
$3,000 $0
$3,000 $9,517
$4,000 $0
$4,000 $13,517
$3,000 $0
$3,000 $16,517
$3,500 $0
$3,500 $20,017
$0 $16,929 $67,717
$0 $13,886 $58,794
$0 $3,043 $8,923
$0
$3,043
$11,966
$35,269 $34,213
$1,056 $13,022
$17,635 $19,478 ($1,843) $11,179
$15,250 $17,231 ($1,981)
$9,198
$28,000 $28,000
$0 $9,198
$28,000 $27,999
$1 $9,199
$28,000 $28,000
$0 $9,199
$28,000 $27,999
$1 $9,200
$10,000 $0
$10,000 $19,200
$10,000 $0
$10,000 $29,200
$10,000 $0
$10,000 $39,200
$10,000 $0
$10,000 $49,200
$10,000 $0
$10,000 $59,200
$0 $7,020 ($7,020) $7020
2000 $0
$24,600 ($24,600) ($24,600)
2000 $0
$24,600 ($24,600)
$6,511 $1,712 $4,799 $2,221
2001 $65,113 $52,046 $13,067 $11,533
2001 $65,113 $76,646 ($11,533)
$26,045 $0
$26,045 $23824
200 $260,448 $209,056
$51,392 $39,859
2002 $325,561 $285,702
$39,859
$ 13,565 $ 6,783 $17,000 $8,499 ($3,435) ($1,716) $LO 389 $18673
2003 $135,654 $145,316
($9,662) $30,197
$67,826 $74,997 ($7,171) $23,026
2003 $461,215 $431,018
$30,197
$529,041 $506,015
$23,026
$5,750 ($8,250) $14,000 $32673
$75,934 $88,655 ($12,721) $10,305
$604,975 $594,670
$10,305
$ 4,500 ($4,023) $8,523 $41 196
2004 $66,700 $65,154
$1,546 $11,851
2004 $671,675 $659,824
$11,851
$ 4,500 $4,500 $0
$41 196
$66,700 $73,084 ($6,384)
$5,467
$738,375 $732,908
$5,467
$4,500 $4,500
$0 $41 196
$72,700 $61,988 $10,712 $16,179
$811,075 $794,896
$16,179
$4,500 $4,500
$0 $41 196
$64,400 $76,254 ($11,854)
$4,325
$875,475 $871,150
$4,325
$1,250 $0
$1,250 $42446
$29,350 $0
$29,350 $33,675
$904,825 $871,150
$33,675
$1,250 $0
$1,250 $43,696
$1,250 $0
$1,250 $44,946
2(05
$26,680 $40,650 $0 $0
$26,680 $40,650 $60,355 $101,005
2005
$931,505 $972,155 $871,150 $871,150
$60,355 $101,005
$1,250 $0
$1,250 $46,196
$1,250 $0
$1,250 $47,446
$26,650 $0
$26,650 $127,655
$29,250 $0
$29,250 $156,905
$998,805 $1,028,055 $871,150 $871,150 $127,655 $156,905
Page 32 of41
&[DATE]
SHELL-MCCLURG-052516
Benzene Health Research Consortium API Administration 4Q04 Financial Report
QI RIs
2006
2nd OIL
3rd OIL
4lh OIL
TIuIv
2007
1sl0lL 2nd OIL 3rd OIL
w
4lh OIL
~ $10,000
.2 $0
$10,000
$51,596 ~ ~ $1,000
$0
$1,000 ~ $6,131 ~ 1"1 $1,000 10 $0 ~ $1,000
$25,926
$14,000 $0
$14,000 $65,596
$1,400 $0
$1,400 $7,531
$5,000 $0
$5,000 $30,926
$10,000 $0
$10,000 $75,596
$1,000 $0
$1,000 $8,531
$1,000 $0
$1,000 $31,926
$12,000 $0
$12,000 $87,596
$1,100 $0
$1,100 $9,631
$1,000 $0
$1,000 $32,926
$10,000 $0
$10,000 $97,596
$1,000 $0
$1,000 $10,631
$1,000 $0
$1,000 $33,926
$14,000 $0
$14,000 $111,596
$1,400 $0
$1,400 $12,031
$5,000 $0
$5,000 $38,926
$10,000 $0
$10,000 $121,596
$1,000 $0
$1,000 $13,031
$1,000 $0
$1,000 $39,926
I~ ~
-.
L.
L ~ ~ L' l. ~ ~
.,)u ;j'
~ ~
,,)"1
;jo
~ .",
;jts
;j~
~ ~ "IL
4;j
~ ~ "It
"I,
~ ~
:>u
$400 $0
$400 ($41,755)
$5,000 $0
$5,000 ($36,755)
$400 $0
$400 ($36,355)
$400 $0
$400 ($35,955)
$400 $0
$400 ($35,555)
$5,000 $0
$5,000 ($30,555)
$3,000 $0
$3,000 $23,017
$4,000 $0
$4,000 $27,017
$3,000 $0
$3,000 $30,017
$3,500 $0
$3,500 $33,517
$3,000 $0
$3,000 $36,517
$4,000 $0
$4,000 $40,517
$10,000 $0
$10,000 $69,200
$10,000 $0
$10,000 $79,200
$10,000 $0
$10,000 $89,200
$10,000 $0
$10,000 $99,200
$10,000 $0
$10,000 $109,200
$10,000 $0
$10,000 $119,200
$1,250
$1,250
$0 $0
$1,250
$1,250
$48,696
$49,946
2006
$26,650
$40,650
$0 $0
$26,650
$40,650
$183,555 $224,205
2006
$1,054,705 $1,095,355
$871,150 $871,150
$183,555 $224,205
$1,250 $0
$1,250 $51,196
$1,250 $0
$1,250 $52,446
$26,650 $0
$26,650 $250,855
$29,250 $0
$29,250 $280,105
$1,122,005 $1,151,255 $871,150 $871,150 $250,855 $280,105
$1,250
$1,250
$0 $0
$1,250
$1,250
$53,696 $54,946
2007
$26,650 $40,650
$0 $0
$26,650 $40,650
$306,755 $347,405
2007
$1,177,905 $1,218,555
$871,150 $871,150
$306,755 $347,405
$400 $0
$400 ($30,155)
$3,000 $0
$3,000 $43,517
$10,000 $0
$10,000 $129,200
$1,250 $0
$1,250 $56,196
$26,650 $0
$26,650 $374,055
$1,245,205 $871,150 $374,055
~ ~
:>"1
X
TOTALS
$411,865 $326,486
$84,635 $85,379
$54,602 $40,797 $13,805 $13,805
$63,952 $23,684 $40,268 $40,268
$52,207 $80,689 ($28,482) ($28,482)
$140,125 $90,856 $49,269 $49,269
$384,800 $255,600 $129,200 $129,200
$91,654 $28,438 $63,216 $63,216
$1,245,205 $846,550 $398,655 $398,655
$1,245,205 $871,150 $374,055
Page 33 of41
&[DATE]
SHELL-MCCLURG-052517
A
~
Continaencv Funds
"I
Budgeted
Actual expense
CurrentVariance
Cumm Variance
Reallocations from UCHSC
Budgeted
Actual expense
IL CurrentVariance
l;j Cumm Variance
i<L Reallocations from AHS
~ Budgeted Actual expense
CurrentVariance
Cumm Variance
G:L Histopath Review - J. Bennett
Budgeted
"[ Actual expense
~ L,
CurrentVariance Cumm Variance
~"I
L~ Budgeted
~ Actual expense
... CurrentVariance
Cumm Variance
~ ~
':'L ;j;j
~ ~
,:,t
;jf
':'0
Budgeted Actual expense CurrentVariance Cumm Variance
Budgeted Actual expense CurrentVariance Cumm Variance
~ "IL
4'
TOTALS Budgeted Actual expense
~ "I;
CurrentVariance Cumm Variance
"1"1 CUMULATIVE TOTALS 4~ Budgeted ~ Expense "If Variance
"Ie
4~
~
2
OL
LT 2/4/05
o;j
~
Benzene Health Research Consortium Contingency Fund 4Q04 Financial Report
B C D EF
2000 1st- 4th OtL
$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 2000 $0.00 $0.00 $0.00 $0.00 2000 $0.00 $0.00 $0.00
2001 1st- 4th OtL
$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 2001 $0.00 $0.00 $0.00 $0.00 2001 $0.00 $0.00 $0.00
2002 1st- 4th OtL
$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 2002 $0.00 $0.00 $0.00 $0.00 2002 $0.00 $0.00 $0.00
1st & 2nd OtL
$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.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00
3rd OtL
$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.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00
2003
G
4th OtL
2003 2003
$290,272 $0
$290,272 $290,272
$0 $48,839 ($48,839) ($48,839)
$0 $52,634 ($52,634) ($52,634)
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$290,272.00 $101,473.00 $188,799.00 $188,799.00
$290,272.00 $101,473.00 $188,799.00
4Q03 Adjustment - per Technical Committee, transfer $48,839 from UCHSC expense detail to contingency because expenses not part of UCHSC g
AHS - expense transfer of $52 634 from AHS ex ense detail to continqenc because ex enses not part of AHS full study bud et
Page 34 of 41
&[DATE]
SHELL-MCCLURG-052518
Benzene Health Research Consortium Contingency Fund 4Q04 Financial Report
H
~ 2004 1stOtr.
"I $0 $0 $0
$290,272
IL l;j
i<L
~
G:L
"[ ~
L,
~"I L~
~
...
~ ~
':'L
;j;j
~ ~
,:,t
;jf
':'0
~ "IL
4'
2004
~ "I;
"1"1 4~
~ "If
2004
"Ie
i nt budget: OL 1. June 2001 $25K grant to UCHSC; seed money exhausted (API & sponsor), expense not included in final grant cost estimate o;j 2. $3600 IRS fees to U of CO (this will be a yearly fee, since IRS must review at least once per year) ~ 3. 2002 invoice ($20,239) from EMBSI for final feasibility study work (very late billing to API)
$0 $0 $0 ($48,839)
$0 $0 $0 ($52,634)
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0.00 $0.00 $0.00 $188,799.00
$0.00 $101,473.00 $188,799.00
I
2nd Otr.
$0 $0 $0 $290,272
$0 $0 $0 ($48,839)
$0 $0 $0 ($52,634)
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0.00 $0.00 $0.00 $188,799.00
$0.00 $101,473.00 $188,799.00
J
3r.d Otr.
$0 $0 $0 $290,272
$0 $0 $0 ($48,839)
$0 $0 $0 ($52,634)
$0
$0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0.00 $0.00 $0.00 $188,799.00
$0.00 $101,473.00 $188,799.00
K
4th Otr.
$300,000 $0
$300,000 $590,272
$0 $0 $0 ($48,839)
$0 $0 $0 ($52,634)
$0 $3,000 ($3,000) ($3,000)
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$300,000.00 $3,000.00
$297,000.00 $485,799.00
$300,000.00 $104,473.00 $485,799.00
L
1stOtr.
$0 $0 $0 $590,272
$0 $0 $0 ($48,839)
$0 $0 $0 ($52,634)
$0 $0 $0 ($3,000)
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0.00 $0.00 $0.00 $485,799.00
$0.00 $0.00 $0.00
MN
2005
2nd Otr.
3r.d Otr.
$0 $0 $0 $590,272
$0 $0 $0 $590,272
$0 $0 $0 ($48,839)
$0 $0 $0 ($48,839)
$0 $0 $0 ($52,634)
$0 $0 $0 ($52,634)
$0 $0 $0 ($3,000)
$0 $0 $0 ($3,000)
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0
2005 $0.00 $0.00 $0.00 $485,799.00
2005 $0.00 $0.00 $0.00
$0 $0 $0 $0
$0.00 $0.00 $0.00 $485,799.00
$0.00 $0.00 $0.00
0
4th Otr.
$0 $0 $590,272
$0 $0 $0 ($48,839)
$0 $0 $0 ($52,634)
$0 $0 $0 ($3,000)
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0.00 $0.00 $0.00 $485,799.00
$0.00 $0.00 $0.00
Page 35 of 41
&[DATE]
SHELL-MCCLURG-052519
Benzene Health Research Consortium Contingency Fund 4Q04 Financial Report
~
"I
IL l;j
i<L
~
G:L
"[ ~
L.
~"I L~
~
...
~ ~
':'L ;j;j ~ ~ ,:,t ;jf ':'0 ~ "IL 4' ~ "I; "1"1 4~ ~ "If "Ie 4~ ~
2
OL o;j ~
P
1sl0lL
$0 $0 $0 $590,272
$0 $0 $0 ($48,839)
$0 $0 $0 ($52,634)
$0 $0 $0 ($3,000)
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0.00 $0.00 $0.00 $485,799.00
$0.00 $0.00 $0.00
QR
2006
2nd OIL
3Ld OIL
$0 $0 $0 $590,272
$0 $0 $0 $590,272
$0 $0 $0 ($48,839)
$0 $0 $0 ($48,839)
$0 $0 $0 ($52,634)
$0 $0 $0 ($52,634)
$0 $0 $0 ($3,000)
$0 $0 $0 ($3,000)
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0
2006 $0.00 $0.00 $0.00 $485,799.00
2006 $0.00 $0.00 $0.00
$0 $0 $0 $0
$0.00 $0.00 $0.00 $485,799.00
$0.00 $0.00 $0.00
S
4lh OIL
$0 $0 $0 $590,272
$0 $0 $0 ($48,839)
$0 $0 $0 ($52,634)
$0 $0 $0 ($3,000)
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0.00 $0.00 $0.00 $485,799.00
$0.00 $0.00 $0.00
T
1sl0lL
$0 $0 $0 $590,272
$0 $0 $0 ($48,839)
$0 $0 $0 ($52,634)
$0 $0 $0 ($3,000)
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0.00 $0.00 $0.00 $485,799.00
$0.00 $0.00 $0.00
UV
2007
2nd OIL
3Ld OIL
$0 $0 $0 $590,272
$0 $0 $0 $590,272
$0 $0 $0 ($48,839)
$0 $0 $0 ($48,839)
$0 $0 $0 ($52,634)
$0 $0 $0 ($52,634)
$0 $0 $0 ($3,000)
$0 $0 $0 ($3,000)
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0
2007 $0.00 $0.00 $0.00 $485,799.00
2007 $0.00 $0.00 $0.00
$0 $0 $0 $0
$0.00 $0.00 $0.00 $485,799.00
$0.00 $0.00 $0.00
W
4lh OIL
$0 $0 $0 $590,272
$0 $0 $0 ($48,839)
$0 $0 $0 ($52,634)
$0 $0 $0 ($3,000)
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0.00 $0.00 $0.00 $485,799.00
$0.00 $0.00 $0.00
X
TOTALS
$590,272 $0 $0
$590,272
$0 $48,839
$0 ($48,839)
$0 $52,634
$0 ($52,634)
$0 $3,000
$0 ($3,000)
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$590,272.00 $104,473.00
$0.00 $485,799.00
$0.00 $0.00 $0.00
Page 36 of 41
&[DATE]
SH ELL-MCCLU RG-052520
A
~ ~ INCOME
"I Sponsor Payments API Interest UCHSC Interest
TOTALS Reporting Period
~ Cumulative
projected income U
L<L LT 7/19/04
RT 1121/05
Benzene Health Research Consortium Income 4Q04 Financial Report
B
2000 1st - 4th Qtr.
C
2001 1st - 4th Qtr.
D
2002 1st - 4th Qtr.
E
1st & 2nd Qtr.
F
2003 3rd Qtr.
G
4th Qtr.
H
1stQtr.
IJ
2004
2nd Qtr.
3rd Qtr.
K
4th Qtr.
L
1stQtr.
MN
2005
2nd Qtr.
3rd Qtr.
0
4th Qtr.
P
1stQtr.
QR
2006
2nd Qtr.
3rd Qtr.
$60,000 $246 $0
$2,105,509 $7,623 $0
$8,355,629 $11,817 $0
$448,024 $0 $0
$0 $ $3,186
$0
4,259,965 $5,276 $0
$1,485,875 $ $0 $0
$6,746
$6,506
$9,292
$60,246 $60,246
$2,113,132 $2,173,378
$8,367,446 $10,540,824
$448,024 $10,988,848
$3,186 $10,992,034
$4,265,241 $1,485,875 $15,257,275 $16,743,149
$6,746
$6,506
$16,749,895 $16,756,401
$9,292 $16,765,693
$0 $16,765,693
$0 $16,765,693
$0 $16,765,693
$0 $16,765,693
$0 $16,765,693
$0 $16,765,693
$0 $16,765,693
Page 37 of41
&[DATE]
SHELL-MCCLURG-052521
S
~ 4th Qtr. ~
"I
T
1stQtr.
UV
2007
2nd Qtr.
3rd Qtr.
W
4th Qtr.
X
TOTALS
$16,715,001 $50,692 $0
$0 $0 $0 $0 $0 $16,765,693 ~ $16,765,693 $16,765,693 $16,765,693 $16,765,693 $16,765,693
U
L<L
Benzene Health Research Consortium Income 4Q04 Financial Report
Page 38 of41
&[DATE]
SH ELL-MCCLU RG-OS2S22
A T
2 Company Name 3 BP 4 5 ChevronTexaco 6 ConocoPhillips 7 8 ExxonMobii 9 10 11 Shell 12 13
14 Marathon 15 16 Total 17 18 LT 7/19/04
B
(Seed Money)
$15,000 $22,500 $15,000 $15,000
$7,500 $0
$15,000 $15,000
$15,000
$120,000
CD
Inv. # 522922 528453 522923 522924 528574 523540
Date Paid
8-Nov-00 19-Jun-01 7-Nov-00 31-0cl-00 31-Jul-01
523054 24-0cl-00 528333 15-May-01
528541 14-Aug-01
Benzene Health Research Consortium Sponsor Invoice Detail 4Q04 Financial Report
EF
2001
G
H IJ
2002 (1 st - 2nd Otr.)
K LM
2002 (3rd - 4th Otr.)
22-Aug-01 $768,941
$522,627 $246,314
Inv. # Date Paid
529301
4-0cl-01
529302 529309
9-0cl-01 17-Sep-01
9-Jan-02 $806,441
$537,627 $268,814
Inv. # 532263
532244 532245
Date Paid 22-Feb-02
22-Feb-02 16-Jan-02
27-Aug-02 $1,344,069
$112,008 $896,046 $448,023
Inv. # 535033
535034 535035
Date Paid
11-0cl-02 2-0cl-02 5-Nov-02
26-Sep-02
$507,627 529305 $2,045,509
25-Sep-01
$1,612,882 $806,441 $806,441 $537,627
532246 532247
$5,376,273
23-Jan-02 11-Feb-02
7-Feb-02
$1,344,069 535036 13-Sep-02
$896,046 $448,023 $448,023
535037
25-Sep-02 10-Feb-03
Maralhon Ashland
Maralhon Oil
$5,936,307
N0
2003
P
23-Sep-03 $1,431,041.00
Inv. # Date Paid
544951
4-Dec-03
$1,028,700.00 $514,349.00
544953 544954
19-Nov-03 27-0cl-03
$1,543,049.00 $771,524.50 $771,524.50
$1,028,700.00 $514,350 $514,350
$150,000 $50,000
$8,317,588.00
544956
544958
548582 548581
3-0cl-03 22-Mar-04
28 Ocl 03 14 Jan 04 20-Jan-04 3-Feb-04
Q
TOTAL $4,500,000 $3,000,000 $1,500,000 $4,500,000
$3,000,000 $215,000
$16,715,000
Page 39 of41
&[DATE]
SH ELL-MCCLU RG-052523
AB
1 ID
CompanyName
2 19982 Shell Chemical
3 20086 ConocoPhillips
4 20972 ChevronTexaco
5 20239 BP International Limited
6 28285 Shell Chemical
7 28929 BP International Ltd
8 29861 ConocoPhillips
9 30179 Marathon Ashland Petroleum, LLC.
10 30853 ConocoPhillips
11 31000 Shell Chemical
12 31141 BP p.Lc.
13 31179 ChevronTexaco
14 33206 ConocoPhillips
15 34334 ExxonMobil Research and Engineering
16 34823 Shell Chemical
17 34889 ExxonMobil Research and Engineering
18 35200 ChevronTexaco
19 35207 BP p.Lc.
20 38625 ExxonMobil
21 38748 Shell Chemical
22 38779 ConocoPhillips
23 39101 BP p.Lc.
24 39214 BP p.Lc.
25 39493 ChevronTexaco
26 42934 American Petroleum Institute
27 44094 Shell Chemical
28 51153 ExxonMobil
29 51869 ConocoPhillips
30 51891 Shell Chemical
31 52332 ChevronTexaco
32 52633 BP p.Lc.
33 54618 Marathon Ashland Petroleum, LLC.
34 54472 Shell Chemical
35 55187 Marathon Oil Company
36 57362 ExxonMobil
37
38 RT 5/5/04
39 LT7/19/04
Benzene Health Research Consortium Sponsor Payment Detail 4Q04 Financial Report
PaymentDate
C
10/24/2000 10/3112000
1117/2000 1118/2000 5/15/2001 6/19/2001 7/3112001 8/14/2001 9/17/2001 9/25/2001 10/4/2001 10/9/2001 1116/2002 1/23/2002
2/7/2002 2/1112002 2/22/2002 2/22/2002 9/13/2002 9/25/2002 9/26/2002 10/2/2002 10/1112002 1115/2002 1117/2003 2/10/2003 10/3/2003 10/27/2003 10/28/2003 11119/2003 12/4/2003 1/20/2004 1113/2004
2/3/2004 3/22/2004
(note - does not include interst income)
D
PaymentAmount $ 15,000.00 $ 15,000.00 $ 15,000.00 $ 15,000.00
$ 15,000.00 $ 22,500.00 $ 7,500.00 $ 15,000.00 $ 246,314.00 $ 507,627.00 $ 768,941.00 $ 522,627.00
$ 268,814.00 $ 806,441.00 $ 537,627.00 $ 806,441.00 $ 537,627.00 $ 806,441.00 $ 1,344,069.00 $ 448,023.00 $ 448,023.00 $ 112,008.00 $ 1,344,069.00 $ 896,046.00
$ 1.09 $ 448,023.00
$ 771,524.50 $ 514,349.00 $ 514,350.00 $ 1,028,700.00 $ 1,431,041.00
$ 150,000.00 $ 514,350.00 $ 50,000.00 $ 771,524.50
$ 16,715,001.09
E TOTALS
yr 2000 $ 60,000.00
yr 2001 $ 2,105,509.00
yr 2002 $ 8,355,629.00
1+2Q03 $ 448,024.09
4Q03 $ 4,259,964.50
1Q04 $ 1,485,874.50 $ 16,715,001.09
F
3Q03 $-
Page 40 of41
&[DATE]
SH ELL-MCCLU RG-OS2S24
A 1 Company 2 American Petroleum Institute
3 BP International Limited 4 BP International Ltd 5 BP p.Lc. 6 BP p.Lc. 7 BP p.Lc. 8 BP p.Lc. 9 BP p.Lc.
10 ChevronTexaco 11 ChevronTexaco 12 ChevronTexaco 13 ChevronTexaco 14 ChevronTexaco
15 ConocoPhillips 16 ConocoPhillips 17 ConocoPhillips 18 ConocoPhillips 19 ConocoPhillips 20 ConocoPhillips
21 ExxonMobil Research and Engineering 22 ExxonMobil Research and Engineering 23 ExxonMobil 24 ExxonMobil 25 ExxonMobil
26 Marathon Ashland Petroleum, LLC. 27 Marathon Ashland Petroleum, LLC. 28 Marathon Oil Company
29 Shell Chemical 30 Shell Chemical 31 Shell Chemical 32 Shell Chemical 33 Shell Chemical 34 Shell Chemical 35 Shell Chemical 36 Shell Chemical
37 38 LT7/19/04
BC
D
Date Paid Amount
1117/2003 $
1.09 (I am trying to get this $1.09 removed from the books)
1118/2000 $
15,000.00
6/19/2001 $
22,500.00
10/4/2001 $ 768,941.00
2/22/2002 $ 806,441.00
10/2/2002 $
112,008.00
10/1112002 $ 1,344,069.00
BP Total
12/4/2003 $ 1,431,041.00 $
4,500,000.00
1117/2000 $
15,000.00
10/9/2001 $ 522,627.00
2/22/2002 $ 537,627.00
1115/2002 $ 896,046.00
ChevronTexaco Total
11119/2003 $ 1,028,700.00 $
3,000,000.00
10/3112000 $
15,000.00
7/3112001 $
7,500.00
9/17/2001 $ 246,314.00
1116/2002 $ 268,814.00
9/26/2002 $
448,023.00
ConocoPhillips Total
10/27/2003 $ 514,349.00 $
1,500,000.00
1/23/2002 $ 806,441.00
2/1112002 $ 806,441.00
9/13/2002 $ 1,344,069.00
10/3/2003 $ 771,524.50
ExxonMobil Total
3/22/2004 $ 771,524.50 $
4,500,000.00
8/14/2001 $
15,000.00
1/20/2004 $
150,000.00
Marathon Ashland Total
2/3/2004 $
50,000.00 $
215,000.00
10/24/2000 $
15,000.00
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 $ 1113/2004 $
514,350.00 514,350.00 $
Shell Chemical Total 3,000,000.00
$ 16,715,001.09
SH ELL-MCCLU RG-052525