Document x7YEQERXLeQ76NpXrw2wLQdQ
From: Sent: To: Cc: Subject: Attach:
Bruce Jarnot <jarnotb@api.org> Friday, May 7, 2004 5:26 PM (GMT) benzconsort-tc@listserve.api.org Lorraine Twerdok <Twerdokl@api.org> BHRC-TC... final draft 1Q04 Financial Report BHRC Program Expenses 1Q04 rpt.xls
BHRC Technical Committee (TC) -
Attached is the final draft 1Q04 Financial Report for the Shanghai Health Study, finalized after yesterday's (May 6) conference call review by the TC Financial Subcommittee (note: all TC members are welcomed to participate in Financial Subcommittee quarterly review sessions).
Here is a summary of the requested changes made following Financial Subcommittee review:
1. Text Summary -- expanded general comments on budget -- inserted text to explaining increase in API variance. [an earlier version of the API detail sheet was used in the 4003 report, rather than the final 3003 version, which under-reported API variance by a net of $16K. This is the $21 K that Lorraine was looking for, earlier thought to be related to a 2002 pre-consortium payment to EMBSI.] -- inserted comment on 'income detail worksheet' to reflect the added a UCHSC interest line item, as requested.
2. Exec Summary -- corrected income line that double reported 1004 income -- added more descriptive names to last two columns -- updated 'income' explanation by deleting UCHSC $1 OOK projected interest and replacing it by $0, since we have not received an interest payment from UCHSC to date -- added a box under the fund balance at API to indicate how much of the fund balance is currently committed on contracts.
3. SRP/ERP -- budgets (variance) adjusted to provide useful budget projections going forward
-
4. API admin -- corrected detail sheet
5. Income detail -- line item added for 'UCHSC interest income'
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
SHELL-MCCLURG-052201
Benzene Health Research Consortium 1Q04 Financial Report Overview
A IBIC D E F G H
1 II
2 RESEARCH PROGRESS:
II
~ AML and NHL Epidemiology Study: as of March, 2004 case accrual rates are within (or slightly above) study projections, with 60+ NHL (non-classified lymphomas pending) and 90-100 AML ca
4 recorded, for a total of 150+ accepted cases (see Case Accrual tab).
5 II
~
7 Disease Progression & Molecular Epidemiology: 90% concordance between Clinical Lab (JCML) case evaluation & secondary pathology review (50% concordance with hospital case referrals).
8I 9 Case Accrual: AML, NHL, AA & MDS above 1Q04 projections. No benzene poisoning cases to date.
I
10 I I
--U12 Exposure Assessment: DP & ME Exposure Assessment operational; CC exposure recreation team reorganized and further trained to enhance assessment rate & quality.
13 I I 14 External Review Panels: Drs. Ellen Clayton (Vanderbilt) & Paul Lombardo (UVA) have been recruited and have agreed to join the ERP; standard consultant contracting in progress. New contrac
15
16 EXPENSE DISCUSSION: 17
=18 Fund Balance at API 1Q04
II II
:P6,534,942
19 I I 20 General: 1Q04 was a low spending quarter for Communications, legal and SRP/ERP. AHS and Iron's Field Expenses contracts in process of renewal, so 1Q04 payments went out in 2Q04 (April).
21 I I 22 Irons Field EXl2enses: under budget; new contract under development for 2004-07, pending resolution of few remaining accounting and budgetary issues.
23 AHS: 'on budget'; new contract with AHS under development for 2004-07
24 Fudan Universit~:{ operating under budget with positive variance of $81 ,425; new contract under development for 2004-07. Budget adjustment going forward once new contract in place
25 SRP/ERP: budget adjustment made going forward to eliminate large postitive variance ($198.788 out of a 364K total program budget)
26 Communications (APCO): no expenses during 1Q04
27 Outside Legal Council: 'on budget' after adjustments made to reflect budget reduction
28 QAlQC: proposal requested from Judy Baldwin, per Technical Committee recommendation.
29 API Administrative Costs: 1Q04 expenses were $5K under budget; however, $20,958 adjustment to correct 200112002 travel and meeting expenses that were brought forward incorrectly from 3C
30 Income detail worksheet: per Technical Committee request,Jine item added for UCHSC interest
31 32 FORWARD GUIDANCE: 33 API administrative budget requires close monitoring to contain costs, and come in on budget 34
I I I
I I I
35 Get Fudan University contract in place (in progress).
36 37 Resolve total budget estimates for new contract or Irons field expenses (in progress).
II
38
39 Need to reconcile UCHSC statement - they have a $105 error.
40 41 Technical Budget Work Group Acceptance: 5/6/04
II
42 Oversight Committee Acceptance:
43 Posted to website:
44 45 BMJ 5/05/04 46 LT 5/7104
II II II
Page 1 of41
&[DATE]
SH ELL-MCCLU RG-052202
I 1 2
~ es
4 5
~
7 8 9 10
...g. 12 13 14 also being 15 16 17 18
19 20 No UCHSC 21 22 23 24 25 26 27 28 29 03 report, 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
J
Benzene Health Research Consortium 1Q04 Financial Report Overview
Page 2 of41
&[DATE]
SH ELL-MCCLU RG-052203
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 5/6/04
Benzene Health Research Consortium Approved Program Budget 1Q04 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
- 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-052204
Benzene Health Research Consortium Executive Summary
1Q04 Financial Report
AB
1
2
3
4 5
6 7 Cost Centers
Project #
8
9 Income
10
11
12 Cost Centers
13 UCHSC* 14 Irons-Field Expense*
X8105 X8106
15 Applied Health Sciences
X8107
16 Fudan University
X8108
17 Scientific & Ethics Panels X8109
18 Communications
X8103
19 Outside Legal Counsel
X8104
20 QAJQC Support
X8110
21 API Administrative 22 Contingency
X8100
23
24 Total Expenses
25 26 Fund Balance
27
28
29 blue is projected fund balanced to project 30 * amount disbursed by API
31
32
33 LT 5/7/04
34
35
36
37 38
CD
Inception Thru
December 2003
Actuals
Actuals Jan - Mar
2004
$ 15,257,275 $ 1,485,875
7,515,759 539,486 951,892 31,981 82,854 290,866 33,208
-
566,189 101,473
-
500
-
365
-
93,635
-
$ 10,113,707 $ 94,500
$ 5,143,567 $ 1,391,375
E FG H
Program to Date
$ 16,743,149
Cumulative Actuals Inception
Thru 1Q04
$ 16,743,149
7,515,759 539,486 951,892 31,981 83,354 290,866 33,572
-
659,824 101,473
7,515,759 539,486 951,892 31,981 83,354 290,866 33,572
-
659,824 101,473
$ 10,208,207
$ 10,208,207
$ 6,534,942 **
**$323,905 of fund balance committed
I J K L M N0 Budget (actual + projected income & expen
2004
2005
$
2006
-
1,748,061 222,032 295,021 21,863 79,750 45,000 12,524 18,750 233,250
-
$ 2,676,250
$ 3,858,692
1,748,060 222,032 441,867 29,148 79,250 60,000 16,698 25,000 144,500 188,799
$ 2,955,354
$ 903,338
1,748,060 222,030 449,985 29,148 74,250 60,000 16,698 25,000 144,500
-
$ 2,769,671
($1,866,333)
Page 4 of 41
&[DATE]
SH ELL-MCCLU RG-052205
PQ
1
2
3 ses)
4 5
6
7 2007
8 9$
-
10
11
12
13 1,748,060
14 222,028
15 45,833
16 29,148
17 47,396
18 79,135
19 16,698
20 25,000
21 144,500
22 -
23
24 $
2,357,798
25
26 ($4,224,131 )
27
28
29
30
31 Income Detail
32 sponsors
33 MAP seed
34 MAP contrib.
35 API interest
36 UCHSC interest
37 38 TOTAL
R
Projected Expenses $ 16,743,149
14,508,000 1,427,608 2,184,598 141,288 364,000 535,001 96,190 93,750 1,326,574 290,272
$ 20,967,280
$16,500,000 $15,000
$200,000 $28,149 $0
$16,743,149
S
Program Budget
$ 16,743,149
14,508,000 1,413,428 2,283,095 230,000 364,000 550,000 100,000 100,000 1,245,205 290,272
$ 21,084,000
Benzene Health Research Consortium Executive Summary
1Q04 Financial Report
Page 5 of 41
&[DATE]
SH ELL-MCCLU RG-052206
Benzene Health Research Consortium Case Accrual 1Q04 Financial Report
A
Case Accrual (Study Goal)
~ ~ AML (450 total)
"I Cases Projected
Actual cases
CurrentVariance
Cumm Variance NHL (120/yr)
~ Cases Projected Actual cases
CurrentVariance
Cumm Variance AA (50/yr)
L<L Cases Projected
~ Actual cases CurrentVariance
Cumm Variance MDS (60/yr)
G:L Cases Projected
Actual cases
"[ CurrentVariance
~
Cumm Variance
~ Benzene Poisoning (10/yr)
~"I Cases Projected
L~ Actual cases
~ CurrentVariance Cumm Variance
TOTALS L~ Cases Projecled (AML + NHL)
"U Aclual Cases (AML + NHL)
~ ~
""I LT 5/6/04 ,,~ BJ 5/05/04
B C DE F G H I J K LMN0 PQ R S T
2003
2004
2005
2006
2007
1s1 & 2nd Olr 3rd Olr 4lh Olr 1sl0lr 2nd Olr 3rd Olr 4lh Olr 1sl0lr 2nd Olr 3rd Olr 4lh Olr 1sl0lr 2nd Olr 3rd Olr 4lh Olr 1sl0lr 2nd Olr 3rd Olr 4lh Olr
35 35 35 35 35 35 35 35 35 35 35 35 35 42 48-58
35 35 35 35 35 35 35 35 35 35 35 35 35 66 0
12 13 17 0
12 13 12 13
12 13 12 13
12 13 12
15 15 26 0
15 15 15 15
15 15 15 15
15 15 15
32 3 2 32 3 2 32 3 2 3 00
70 140 108 150-60
U
TOTALS
455 42 0 0
455 66 0 0
162 17 0 0
195 26 0 0
33 0 0 0
1300 151
Page 6 of 41
&[DATE]
SH ELL-MCCLU RG-052207
Benzene Health Research Consortium Cash Flow Statement 1Q04 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
LT 5/6/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,571,301 $1,595,901
$7,639,230 $9,235,131
$310,235 $9,545,366
$35,646 $35,646
$541,831 $577,477
$728,216 $1,305,693
$137,789 $1,443,482
NOTE: $6,534,942 in bank at API
F
2003 3rd Qtr.
G
4thQtr.
$3,186 $4,265,241 $10,992,034 $15,257,275
$258,097
$310,244
$9,803,463 $10,113,707
($254,911) $1,188,571
$3,954,997 $5,143,568
H
1stQtr.
$1,485,875 $16,743,149
$94,500 $10,208,207
$1,391,375 $6,534,942
I
2004 2nd Qtr.
J
3rd Qtr.
K
4thQtr.
$5,000 $16,748,149
$0 $16,748,149
$0 $16,748,149
$1,094,843 $11,303,049
$269,061 $11,572,110
$1,163,842 $12,735,952
($1,089,843) $5,445,100
($269,061) $5,176,039
($1,163,842) $4,012,197
L
1stQtr.
M
2005 2nd Qtr.
N
3rd Qtr.
0
4thQtr.
P
1stQtr.
Q
2nd Qtr.
R
2006 3rd Qtr.
$0 $16,748,149
$0 $16,748,149
$0 $16,748,149
$0 $16,748,149
$0 $16,748,149
$100,000 $16,848,149
$0 $16,848,149
$234,436 $12,970,388
$1,061,468 $14,031,856
$245,186 $14,277,043
$1,132,468 $15,409,511
$235,966 $15,645,477
$1,063,505 $16,708,981
$246,715 $16,955,696
($234,436) $3,777,761
($1,061,468) $2,716,293
($245,186) $2,471,106
($1,132,468) $1,338,638
($235,966) $1,102,672
($963,505) $139,168
($246,715) ($107,547)
S
4thQtr.
$0 $16,848,149
$1,130,507 $18,086,203
($1,130,507) ($1,238,054)
7of41
&[DATE]
SH ELL-MCCLU RG-052208
"I ~
2
~
~
14
T
1stQtr.
U
2007 2nd Qtr.
V
3rd Qtr.
W
4thQtr.
X
TOTALS
$0 $16,848,149
$0 $16,848,149
$0 $16,848,149
$0 $16,848,149
$16,848,149
$174,085 $18,260,288
$955,794 $19,216,081
$139,003 $19,355,084
$995,941 $20,351,025
$20,351,025
($174,085) ($1,412,139)
($955,794) ($2,367,932)
($139,003) ($2,506,935)
($995,941) ($3,502,876)
Benzene Health Research Consortium Cash Flow Statement 1Q04 Financial Report
8of41
&[DATE]
SH ELL-MCCLU RG-052209
Benzene Health Research Consortium Program Expense Summary 1Q04 Financial Report
AB
Cost Centers
UCHSC
~ Disbursed Budgeted
Actual expense
CurrentVariance
~ Cumm Variance Irons - Field Expenses
Disbursed
Budgeted
Actual expense
CurrentVariance
1"1 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.' Budgeted
~ Actual expense
~ CurrentVariance
L. Cumm Variance
.)U Communications - APCO
~ Budgeted
~
Actual expense
,).0 CurrentVariance
,)"1 Cumm Variance
~ Outside Legal Counsel
~
Budgeted
Actual expense
CurrentVariance .)~ Cumm Variance
~ QAlQC Support
"I Budgeted
"I, Actual expense
~
CurrentVariance
~
Cumm Variance
"I;) Contingency Funds
"It Budgeted
~ Actual expense
~
CurrentVariance
"I" Cumm Variance
:>U API Administrative and Overhead
2 Budgeted
~
Actual expense
;;).0 CurrentVariance
;;)"1 Cumm Variance
2000 1st-4thQtr.
~ ~
TOTALS Budgeted Actual expense
CurrentVariance
:>~ Cumm Variance
~ CUMULATIVE TOTALS Budgeted
Expense
0,) Variance
'000 2000
0"1 Blue: future cumulative variance has no meaning until Expense entered.
~ LT 4/14/04 Amt. At UCHSC & Irons Field ex
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 24,600 (24,600) (24,600
0 24,600 (24,600) (24,600)
0 24,600 (24,600)
Bankacct
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 0
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 0
60,000 60,000
240,000 240,738
(738) 59,262
30,000 0
30,000 30,000
120,000 13,565
106,435 136,435
13,500 0
13,500 13,500
54,000 0
54,000 67,500
00 00 00 00
0 45,536 (45,536) 70,136
236,000 195,608
40,392 29,745
'001 900,658
'00' 5,477,424
727,502
4,350,292
173,156
1,127,132
148,556
1,275,688
2001
2002
900,658
6,378,082
752,102
5,102,394
148,556
1,275,688
API disbursed
Amt Expensed
E
1st&2nd Qtr.
0 1,230,711 1,717,169
(486,458) 332,137
0 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 0
28,126 95,626
0 0 0 0
124,500 136,792 (12,292)
42,037
2,007,307 2,116,981
(109,675) 1,166,014
8,385,389 7,219,375 1,166,014
F
2003 3rd Qtr.
IG
4thQtr.
0 0 0 0 332,137
(48,839) 2,039,466
553,672 1,485,794 1,813,804
0 69,179 54,382 14,797 127,133
0 55,508 169,606 (114,098) 13,035
108,128 149,389 (41,261) (17,868)
108,128 90,103 18,025 157
10,688 8,851 1,837
75,305
7,288 1,168 6,120 81,425
30,240 16,984 13,256 191,147
4,508 32,081 (27,573) 163,574
62,500 7,877
54,623 224,322
(196,636) 27,688
(224,324) (2)
31,250 0
31,250 228,457
(210,542) 17,915
(228,457) 0
14,063 0
14,063 109,689
(109,689) 0
(109,689) 0
0 290,272 0 101,473 0 188,799 0 188,799
62,250 74,997 (12,747) 54,784
'00' 388,298 312,479 75,819
1,241,832 2003 8,773,686 7,531,854 1,241,832
$10,208,207 $8,614,215 $1,593,992
77,955 88,655 1 700) (65,484)
2,066,258 1,082,361
983,897 2,225,729
10,839,944 8,614,215 2,225,729
HI
1stQtr.
I
2004 2nd Qtr.
0 0 0 0 1,813,804
874,031 827,532
0 827,532 2,631,500
0 55,508
0 55,508 68,543
0 55,508
0 55,508 124,051
98,340 0
98,340 98,497
98,340 0
98,340 196,838
7,288 0
7,288 88,713
7,288 0
7,288 96,001
(163,074) 500
(163,574) 0
3,000 0
3,000 3,000
15,001 0
15,001 14,999
15,000 0
15,000 29,999
4,175 365
3,810 3,810
4,175 0
4,175 7,985
6,250 0
6,250 6,250
6,250 0
6,250 12,500
0 0 0 188,799
0 0 0 188,799
77,750 93,635 (15,885) (81,369
77,750 0
77,750 3,619
101,238
'000 1,094,843
94,500
0
6,738
1,094,843
2,232,467
3,327,310
2004
10,941,182
12,036,025
8,708,714
8,708,714
2,232,467
3,327,310
$1,472,277 unspent at UCHSC as of 12131/03
$27,216 In Irons' field exp bank acct as of 12131/03 $1,499,493 Total as of 12131/03
J
3rd Qtr.
0 0 0 0 2,631,500
0 55,508
0 55,508 179,559
98,340 0
98,340 295,178
7,288 0
7,288 103,289
4,750 0
4,750 7,750
15,000 0
15,000 44,999
4,175 0
4,175 12,159
6,250 0
6,250 18,750
0 0 0 188,799
77,750 0
77,750 74,131
269,061 0
269,061 3,596,371
12,305,085 8,708,714 3,596,371
K
4thQtr.
874,030 827,532
0 827,532 3,449,196
0 55,508
0 55,508 235,067
98,340 0
98,340 393,518
7,287 0
7,287 110,576
72,000 0
72,000 79,750
15,000 0
15,000 59,999
4,175 0
4,175 16,334
6,250 0
6,250 25,000
0 0 0 188,799
77,750 0
77,750 151881
1,163,842 0
1,163,842 4,760,213
13,468,927 8,708,714 4,760,213
L IMINI0
2005
1stQtr.
2nd Qtr.
3rd Qtr.
4thQtr.
0 0 0 0 3,449,196
874,030 827,532
0 827,532 4,266,892
0 0 0 0 4,266,892
874,030 827,532
0 827,532 5,084,588
0 55,508
0 55,508 290,575
0 55,508
0 55,508 346,083
0 55,508
0 55,508 401,591
0 55,508
0 55,508 457,099
110,467 0
110,467 503,985
110,467 0
110,467 614,452
110,467 0
110,467 724,918
110,467 0
110,467 835,385
7,287 0
7,287 117,863
7,287 0
7,287 125,150
7,287 0
7,287 132,437
7,287 0
7,287 139,724
1,500 0
1,500 81,250
1,000 0
1,000 82,250
4,750 0
4,750 87,000
72,000 0
72,000 159,000
15,000 0
15,000 74,999
15,000 0
15,000 89,999
15,000 0
15,000 104,999
15,000 0
15,000 119,999
4,175 0
4,175 20,508
4,175 0
4,175 24,683
4,175 0
4,175 28,857
4,175 0
4,175 33,032
6,250 0
6,250 31,250
6,250 0
6,250 37,500
6,250 0
6,250 43,750
6,250 0
6,250 50,000
0 0 0 188,799
0 0 0 188,799
0 0 0 188,799
0 0 0 188,799
34,250 0
34,250 186,131
234,436 0
234,436 4,994,649
13,703,363 8,708,714 4,994,649
34,250 0
34,250 220,381
41,750 0
41,750 262131
"1,061,468
245,186
00
1,061,468
245,186
6,056,117
6,301,303
2005
14,764,832 15,010,018
8,708,714
8,708,714
6,056,117
6,301,303
34,250 0
34,250 296,381
1,132,468 0
1,132,468 7,433,772
16,142,486 8,708,714 7,433,772
Page 9 of41
&[DATE]
SHELL-MCCLURG-OS2210
~
~
1"1 ~ ~
I~ ~
L. L.. ~ ~ L. L.' ~ ~ L. .)U ~ ~ ,).0 ,)"1 ~ ~
.)~ ~
"I "I, ~ ~ "I;) "It ~ ~ "I" ;)U
2
~ ;;).0 ;;)"1
~ ~
;)~ ~
0,) 0"1
~
p IQI RIs
2006
1stQtr.
2nd Qtr.
3rd Qtr.
4thQtr.
a a a a
5,084,588
874,030
827,539
a
827,539
5,902,284
a a a a
5,902,284
874,030
827,542
a
827,542
6,719,980
a
55,508
a
55,508
512,607
a
55,508
a
55,508
568,115
a
55,507
a
55,507
623,622
a
55,507
a
55,507
679,129
112,496
a
112,496
947,881
112,496
a
112,496
1,060,378
112,496
a
112,496
1,172,874
112,496
a
112,496
1,285,370
7,287
a
7,287
147,011
7,287
a
7,287
154,298
7,287
a
7,287
161,585
7,287
a
7,287
168,872
1,000
a
1,000
160,000
1,000
a
1,000
161,000
4,250
a
4,250
165,250
68,000
a
68,000
233,250
15,000
a
15,000
134,999
15,000
a
15,000
149,999
15,000
a
15,000
164,999
15,000
a
15,000
179,999
4,175
a
4,175
37,206
4,175
a
4,175
41,381
4,175
a
4,175
45,555
4,175
a
4,175
49,730
6,250
a
6,250 56,250
a a a
188,799
6,250
a
6,250 62,500
a a a
188,799
6,250
a
6,250 68,750
a a a
188,799
6,250
a
6,250 75,000
a a a
188,799
34,250
a
34,250 330,631
235,966
a
235,966 7,669,737
16,378,452 8,708,714 7,669,737
34,250
a
34,250
364,881
41,750
a
41,750
406,631
"1,063,505 a
246,715
a
1,063,505
246,715
8,733,242
8,979,957
2006
17,441,957 17,688,671
8,708,714
8,708,714
8,733,242
8,979,957
34,250
a
34,250 440,881
1,130,507
a
1,130,507 10,110,464
18,819,178 8,708,714
10,110,464
T
1stQtr.
I uI V
2007
2nd Qtr.
3rd Qtr.
I
a a a a
6,719,980
874,030
827,542
a
827,542
7,537,676
a a a a
7,537,676
a
55,507.0
a
55,507
734,636
a
55,507
a
55,507
790,143
a
55,507
a
55,507
845,650
45,833
a
45,833
1,331,203
a a a
1,331,203
a a a
1,331,203
w
4thQtr.
874,030 827,542
a
827,542 8,355,372
a
55,507
a
55,507 901,157
a a a
1,331,203
7,287
a
7,287
176,159
7,287
a
7,287
183,446
7,287
a
7,287
190,733
7,287
a
7,287
198,020
1,000
a
1,000
234,250
1,000
a
1,000
235,250
4,250
a
4,250
239,500
41,146
a
41,146
280,646
19,783
a
19,783
199,782
19,783
a
19,783
219,566
19,784
a
19,784
239,350
19,784
a
19,784
259,134
4,175
a
4,175
53,904
4,175
a
4,175
58,079
4,175
a
4,175
62,253
4,175
a
4,175
66,428
6,250
a
6,250 81,250
a a a
188,799
6,250
a
6,250 87,500
a a a
188,799
6,250
a
6,250 93,750
a a a
188,799
6,250
a
6,250 100,000
a a a
188,799
34,250
a
34,250 475,
174,085
a
174,085 10,284,548
18,993,263 8,708,714
10,284,548
34,250
a
34,250
509,381
41,750
a
41,750
551,131
'Uf
955,794
a
139,003
a
955,794
139,003
11,240,342
11,379,345
2007
19,949,056
20,088,059
8,708,714
8,708,714
11,240,342
11,379,345
34,250
a
34,250 585,381
995,941
a
995,941 12,375,285
21,084,000 8,708,714
12,375,285
Benzene Health Research Consortium Program Expense Summary 1Q04 Financial Report
X
TOTALS
14,508,000 14,508,000
6,043,482 827,542
8,464,518
a
1,413,428 512,270 679,129 901,157
2,283,095 951,892
a
1,331,203
230,000 31,981 7,287
198,020
364,000 83,354 41,146
280,646
550,000 290,866 179,999 259,134
100,000 33,572 66,428 66,428
100,000
a
100,000 100,000
290,272 101,473
a
188,799
1,245,205 635,224
~
21,084,000 8,708,714
12,375,285 12,375,285
21,084,000 8,708,714
12,375,285
Page 10 of41
&[DATE]
SHELL-MCCLURG-OS2211
Benzene Health Research Consortium UCHSC Grant 1Q04 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 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.
~ LT5/6/04 ~ BMJ4126/04
"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 are taken from UC Office of Grants & Contracts report.
Amt. paid UCHSC to date: Amt. expensed to date: Amt. In UCHSC bank acct:
$7,515,759 $6,043,482 $1,472,277
Page 11 of41
&[DATE]
SHELL-MCCLURG-OS2212
Benzene Health Research Consortium UCHSC Grant 1Q04 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 0
195,778 305,682
0 0 0 225,763
195,773 0
195,773 421,536
0 0 0 1,019,304
286,990 0
286,990 1,306,294
0 0 0 30,421
9,836 0
9,836 40,257
$0 $0 $0 $369,063
$48,050 $0
$48,050 $417,113
$0 $0 $0 $89,770
$0 $0 $0 $1,813,804
$7,887,707 $6,043,482 $1,844,225
2004 2004
$91,105 $0
$91,105 $180,875
$827,532 $0
$827,532 $2,631,500
$8,715,239 $6,043,482 $2,671,757
UCHSC statement error for travel, off by +$1 05
I
3rd Qtr.
0
0 0 0 305,682
0 0 0 421,536
0 0 0 1,306,294
0 0 0 40,257
$0 $0 $0 $417,113
$0 $0 $0 $180,875
$0 $0 $0 $2,631,500
$8,715,239 $6,043,482 $2,671,757
Page 12 of41
&[DATE]
SHELL-MCCLURG-052213
Benzene Health Research Consortium UCHSC Grant 1Q04 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 501,460
195,773 0
195,773 617,309
286,990 0
286,990 1,593,284
9,836 0
9,836 50,093
$48,050 $0
$48,050 $465,163
$91,105 $0
$91,105 $271,980
$827,532 $0
$827,532 $3,449,196
$9,542,771 $6,043,482 $3,499,289
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 874,030
0 0 0 501,460
195,778 0
195,778 697,238
0 0 0 697,238
195,778 0
195,778 893,016
0 0 0 893,016
195,778 0
195,778 1,088,794
0 0 0 1,088,794
195,778 0
195,778 1,284,572
0 0 0 1,284,572
195,778 0
195,778 1,480,350
0 0 0 1,480,350
195,778 0
195,778 1,676,128
0 0 0 617,309
195,773 0
195,773 813,082
0 0 0 813,082
195,773 0
195,773 1,008,855
0 0 0 1,008,855
195,773 0
195,773 1,204,628
0 0 0 1,204,628
195,773 0
195,773 1,400,401
0 0 0 1,400,401
195,773 0
195,773 1,596,174
0 0 0 1,596,174
195,773 0
195,773 1,791,947
0 0 0 1,593,284
286,990 0
286,990 1,880,274
0 0 0 1,880,274
286,990 0
286,990 2,167,264
0 0 0 2,167,264
286,990 0
286,990 2,454,254
0 0 0 2,454,254
286,990 0
286,990 2,741,244
0 0 0 2,741,244
286,990 0
286,990 3,028,234
0 0 0 3,028,234
286,990 0
286,990 3,315,224
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 $465,163
$48,050 $0
$48,050 $513,213
$0 $0 $0 $513,213
$48,050 $0
$48,050 $561,263
$0 $0 $0 $561,263
$48,050 $0
$48,050 $609,313
$0 $0 $0 $609,313
$48,050 $0
$48,050 $657,363
$0 $0 $0 $657,363
$48,050 $0
$48,050 $705,413
$0 $0 $0 $705,413
$48,050 $0
$48,050 $753,463
$0 $0 $0 $271,980
$0 $0 $0 $3,449,196
$9,542,771 $6,043,482 $3,499,289
$91,105 $0
$91,105 $363,085
$0 $0 $0 $363,085
2005
$827,532
$0
$0 $0
$827,532
$0
$4,266,892
$4,266,892
2005
$10,370,303 $10,370,303
$6,043,482
$6,043,482
$4,326,821
$4,326,821
$91,105 $0
$91,105 $454,190
$827,532 $0
$827,532 $5,084,588
$11,197,835 $6,043,482 $5,154,353
$0 $0 $0 $454,190
$0 $0 $0 $5,084,588
$11,197,835 $6,043,482 $5,154,353
$91,105 $0
$91,105 $545,295
$0 $0 $0 $545,295
2006
$827,539
$0
$0 $0
$827,539
$0
$5,902,284
$5,902,284
2006
$12,025,374 $12,025,374
$6,043,482
$6,043,482
$5,981,892
$5,981,892
$91,105 $0
$91,105 $636,400
$827,542 $0
$827,542 $6,719,980
$12,852,916 $6,043,482 $6,809,434
$0 $0 $0 $636,400
$0 $0 $0 $6,719,980
$12,852,916 $6,043,482 $6,809,434
$91,105 $0
$91,105 $727,505
$0 $0 $0 $727,505
2007
$827,542
$0
$0 $0
$827,542
$0
$7,537,676
$7,537,676
2007
$13,680,458 $13,680,458
$6,043,482
$6,043,482
$7,636,976
$7,636,976
$91,105 $0
$91,105 $818,610
$827,542 $0
$827,542 $8,355,372
$14,508,000 $6,043,482 $8,464,518
W
TOTALS
14,508,000
2,935,847 1,259,719
195,778 1,676,128
2,415,153 623,206 195,773
1,791,947
5,752,326 2,437,102
286,990 3,315,224
118,139 8,993 9,846
109,146
$1,944,613 $1,191,150
$48,050 $753,463
$1,341,922 $523,312 $91,105 $818,610
$14,508,000 $6,043,482 $827,542 $8,464,518
$14,508,000 $6,043,482 $8,464,518
Page 13 of41
&[DATE]
SHELL-MCCLURG-OS2214
A
UCHSC Subcontracts Fudan University
" Actual expense IPHSC Actual expense SMCDCP Actual expense
-"'- EMBSI Actual expense Children's Hospital Cincinnati
!. Actual expense
TOTALS
''I Actual expense
~ LT 5/6/04 BMJ 4126/04
Benzene Health Research Consortium UCHSC Subcontract 1Q04 Financial Report
B
2001 1st-4thQtr.
2001 "Actual expenses" from UC Office of Grants & Contracts report.
C
2002 1st-4thQtr.
D IE F G H III J
2003
2004
1st&2nd Qtr.
3rd & 4th Qtr.
1st&2nd Qtr.
3rd & 4th Qtr.
KI L MI N
2005
1st&2nd Qtr.
3rd & 4th Qtr.
01 P IQI R
2006
1st&2nd Qtr.
3rd & 4th Qtr.
SI T IU
2007
1st&2nd Qtr.
0
0 411,935
468,341
0
00
0
0
00
0 0 8,339
27,496
0
0
0
0
0
0
0
0 0 45,563
24,766
0
0
0
0
0
0
0
0 0 372,725
00
00
00
00
00 2002
$0 $1,025,372
7,298 2003
$845,860
45,267 $565,870
0 2004 $0
0 $0
0 2005 $0
0 $0
0 2006 $0
0 $0
0 2007 $0
Page 14 of 41
&[DATE]
SHELL-MCCLURG-052215
v
3rd & 4th Qtr.
"0 0
0
-"'0
!. 0
''I $0
~
W
TOTALS
880,276 35,835 70,329
372,725 52,565
$1,411,730
Benzene Health Research Consortium UCHSC Subcontract 1Q04 Financial Report
Page 15 of 41
&[DATE]
SHELL-MCCLURG-052216
Benzene Health Research Consortium Irons Field Expenses 1Q04 Financial Report
A
IRONS Field Expenses
Payments .q Disbursed ~ Airfare & related expenses ~ Budgeted
Cost Centers
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."I- Cumm Variance ~ CUMULATIVE TOTALS ~ Budgeted L. Expense L., Variance
riO- Blue: future cumulative variance has no meaning until Expense entered.
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:
$539,486 numbers as of 12131/03 $512,270
$27,216
Page 16 of41
&[DATE]
SHELL-MCCLURG-OS2217
"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 1Q04 Financial Report
G
1stQtr.
HI
2004
2nd Qtr.
3rd Qtr.
$0 $0
$0 $0
$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 $0
$22,200 $28,246
$22,205 $0
$22,205 ($6,034)
$11,103 $0
$11,103 $87838
$22,200 $0
$22,200 $50,446
$22,205 $0
$22,205 $16,171
$11,103 $0
$11,103 $98,941
$22,200 $0
$22,200 $72,646
$22,205 $0
$22,205 $38,376
$11,103 $0
$11,103 $110044
$55,508 $169,606 ($114,098)
$13,035
$55,508 $0
$55,508 $68,543
$525,306 $512,270
$13,035
$580,814 $512,270
$68,543
$55,508
$55,508
$0 $0
$55,508
$55,508
$124,051 $179,559
2004
$636,322 $691,830
$512,270 $512,270
$124,051 $179,559
J
4thQtr.
$0
$22,200 $0
$22,200 $94,846
$22,205 $0
$22,205 $60,581
$11,103 $0
$11,103 $121,147
$55,508 $0
$55,508 $235,067
$747,338 $512,270 $235,067
K
1stQtr.
$0
$22,200 $0
$22,200 $117,046
$22,205 $0
$22,205 $82,786
$11,103 $0
$11,103 $132,250
$55,508 $0
$55,508 $290,575
$802,846 $512,270 $290,575
LM
2005
2nd Qtr.
3rd Qtr.
$0 $0
$22,200 $0
$22,200 $139,246
$22,205 $0
$22,205 $104,991
$11,103 $0
$11,103 $143353
$22,200 $0
$22,200 $161,446
$22,205 $0
$22,205 $127,196
$11,103 $0
$11,103 $154,456
$55,508
$55,508
$0 $0
$55,508
$55,508
$346,083 $401,591
2005
$858,354 $913,862
$512,270 $512,270
$346,083 $401,591
N0
4thQtr.
1stQtr.
$0
$22,200 $0
$22,200 $183,646
$22,205 $0
$22,205 $149,401
$11,103 $0
$11,103 $165,559
$0
$22,200 $0
$22,200 $205,846
$22,205 $0
$22,205 $171,606
$11,103 $0
$11,103 $176,662
$55,508 $0
$55,508 $457,099
$969,370 $512,270 $457,099
$55,508 $0
$55,508 $512,607
$1,024,878 $512,270 $512,607
P
2006 2nd Qtr.
Q
3rd Qtr.
R
4thQtr.
$0 $0 $0
$22,200 $0
$22,200 $228,046
$22,205 $0
$22,205 $193,811
$11,103 $0
$11,103 $187,765
$22,200 $0
$22,200 $250,246
$22,205 $0
$22,205 $216,016
$11,102 $0
$11,102 $198,867
$22,200 $0
$22,200 $272,446
$22,205 $0
$22,205 $238,221
$11,102 $0
$11,102 $209,969
$55,508
$55,507
$0 $0
$55,508
$55,507
$568,115
$623,622
2006
$1,080,386 $1,135,893
$512,270
$512,270
$568,115
$623,622
$55,507 $0
$55,507 $679,129
$1,191,400 $512,270 $679,129
S
1stQtr.
$0
$22,200 $0
$22,200 $294,646
$22,205 $0
$22,205 $260,426
$11,102 $0
$11,102 $221,071
$55,507 $0
$55,507 $734,636
$1,246,907 $512,270 $734,636
TU
2007
2nd Qtr.
3rd Qtr.
$0 $0
$22,200 $0
$22,200 $316,846
$22,205 $0
$22,205 $282,631
$11,102 $0
$11,102 $232,173
$22,200 $0
$22,200 $339,046
$22,205 $0
$22,205 $304,836
$11,102 $0
$11,102 $243,275
$55,507
$55,507
$0 $0
$55,507
$55,507
$790,143 $845,650
2007
$1,302,414 $1,357,921
$512,270 $512,270
$790,143 $845,650
V
4thQtr.
$0
$22,200 $0
$22,200 $361,246
$22,205 $0
$22,205 $327,041
$11,102 $0
$11,102 $254377
$55,507 $0
$55,507 $901,157
$1,413,428 $512,270 $901,157
0
Page 17 of41
&[DATE]
SHELL-MCCLURG-052218
W
TOTALS
"I
2
~
~ ~
~ ~
~,::I
L'
-.
L L"I ~ ~ L L' L .)U ~ ~ .).) ,)"1 ~ ~
~ ~ "I
$565,319 $204,073 $272,446 $361,246
$565,404 $238,363 $238,221 $327,041
$282,705 $69,835
$209,969 $212,870
$1,413,428 $512,270 $679,129 $901,157
$1,413,428 $512,270 $901,157
Benzene Health Research Consortium Irons Field Expenses 1Q04 Financial Report
Page 18 of41
&[DATE]
SHELL-MCCLURG-052219
Benzene Health Research Consortium AHS 1Q04 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 (Otto Wong) Cost Centers
TOTALS CUMULATIVE TOTALS
~ ~ L
.)U
Blue: future cumulative variance has no meaning until Expense entered. LT 5/6/04
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 $0
$72,090 ($30,004)
$72,090 $0
$72,090 $42,087
$72,090 $0
$72,090 $114,177
$84,217 $0
$84,217 $198,394
$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 $0
$25,500 $218,361
$25,500 $0
$25,500 $243,861
$25,500 $0
$25,500 $269,361
$25,500 $0
$25,500 $294,861
$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
$750
$0 $0
$750
$750
$8480
O.
$9,230
$98,340
$98,340
$0 $0
$98,340
$98,340
$196,838
$295,178
2004
$1,148,730 $1,247,070
$951,892
$951,892
$196,838
$295,178
$750 $0
$750 $9,980
$98,340 $0
$98,340 $393,518
$1,345,410 $951,892 $393,518
$750 $0
$750 $10,730
$110,467 $0
$110,467 $503,985
$1,455,877 $951,892 $503,985
Page 19 of41
&[DATE]
SH ELL-MCCLU RG-OS2220
Benzene Health Research Consortium AHS 1Q04 Financial Report
"I
.2
~
~ ~
~ ~
~
L'
-.
L L"I ~
'<0 ~
~ L .)U
LM
2005
2nd Qtr.
3rd Qtr.
N
4thQtr.
$84,217 $0
$84,217 $282,611
$84,217 $0
$84,217 $366,827
$84,217 $0
$84,217 $451,044
$25,500 $0
$25,500 $320,361
$25,500 $0
$25,500 $345,861
$25,500 $0
$25,500 $371,361
$750
$750
$0 $750 $11,480
$0 $750 $12,230
2005
$110,467
$110,467
$0 $0
$110,467
$110,467
$614,452
$724,918
2005
$1,566,344 $1,676,810
$951,892
$951,892
$614,452
$724,918
$750 $0
$750 $12,980
$110,467 $0
$110,467 $835,385
$1,787,277 $951,892 $835,385
0
1stQtr.
$76,746 $0
$76,746 $527,790
$35,000 $0
$35,000 $406,361
$750 $0
$750 $13,730
$112,496 $0
$112,496 $947,881
$1,899,773 $951,892 $947,881
PQ
2006
2nd Qtr.
3rd Qtr.
$76,746 $0
$76,746 $604,537
$76,746 $0
$76,746 $681,283
$35,000 $0
$35,000 $441,361
$35,000 $0
$35,000 $476,361
$750
$750
$0 $750 $14,480
$0 $750 $15,230
2006
$112,496
$112,496
$0 $0
$112,496
$112,496
$1,060,378 $1,172,874
2006
$2,012,270 $2,124,766
$951,892
$951,892
$1,060,378 $1,172,874
R
4thQtr.
$76,746 $0
$76,746 $758,029
$35,000 $0
$35,000 $511,361
$750 $0
$750 $15,980
$112,496 $0
$112,496 $1,285,370
$2,237,262 $951,892
$1,285,370
S
1stQtr.
$10,033 $0
$10,033 $768,062
$32,000 $0
$32,000 $543,361
$3,800 $0
$3,800 $19,780
$45,833 $0
$45,833 $1,331,203
$2,283,095 $951,892
$1,331,203
T
2nd Qtr.
2007
U
3rd Qtr.
$0 $0 $0 $768,062
$0 $0 $0 $768,062
$0 $0 $0 $543,361
$0 $0 $0 $543,361
$0 $0
$0 $0
$0 $19,780
$0 $19,780
2007
$0 $0
$0 $0
$0 $0
$1,331,203 $1,331,203
2007
$2,283,095 $2,283,095
$951,892
$951,892
$1,331,203 $1,331,203
V
4thQtr.
$0 $0 $0 $768,062
$0 $0 $0 $543,361
$0 $0 $0 $19,780
$0 $0 $0 $1,331,203
$2,283,095 $951,892
$1,331,203
W
TOTALS
$1,631,795 $863,733 $0 $768,062
$630,000 $86,639 $0
$543,361
$21,300 $1,520 $0
$19,780
$2,283,095 $951,892 $0
$1,331,203
$2,283,095 $951,892
$1,331,203
Page 20 of41
&[DATE]
SHELL-MCCLURG-OS2221
Benzene Health Research Consortium Fudan 1Q04 Financial Report
A
FUDAN
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. ~
"L
B
2001
$9,620 $0
$9,620 $9,620
$17,600 $0
$17,600 $17,600
$4,083 $0
$4083 $4083 200' $31,303
$0 $31,303 $31,303 2001 $31,303
$0 $31,303
LT 5/6/04 BMJ 4126/04
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 $0
$1,548 $14,353
$1,548 $0
$1,548 $15,901
$4,645 $0
$4,645 $66,346
$4,645 $0
$4,645 $70,991
$1,095 $0
$1,095 $15,301
$1,095 $0
$1,095 $16,396
'00
$7,288
$7,288
$0 $0
$7,288
$7,288
$96,001
$103,289
2004
$127,981
$135,269
$31,981
$31,981
$96,001
$103,289
J
4Q04
$1,548 $0
$1,548 $17,449
$4,645 $0
$4,645 $75,636
$1,094 $0
$1,094 $17490
$7,287 $0
$7,287 $110,576
$142,556 $31,981
$110,576
K
1Q05
LM
2005
2Q05
3005
$1,548 $0
$1,548 $18,997
$1,548 $0
$1,548 $20,545
$1,548 $0
$1,548 $22,093
$4,645 $0
$4,645 $80,281
$4,645 $0
$4,645 $84,926
$4,645 $0
$4,645 $89,571
$1,094 $0
$1,094 $18,584
$7,287 $0
$7,287 $117,863
$149,843 $31,981
$117,863
$1,094 $0
$1094 $19678
$1,094 $0
$1,094 $20772
05
$7,287
$7,287
$0 $0
$7,287
$7,287
$125,150 $132,437
2005
$157,130 $164,417
$31,981
$31,981
$125,150 $132,437
N0
4Q05
$1,548 $0
$1,548 $23,641
$4,645 $0
$4,645 $94,216
$1,094 $0
$1,094 $21,866
1Q06
$1,548 $0
$1,548 $25,189
$4,645 $0
$4,645 $98,861
$1,094 $0
$1,094 $22,960
$7,287 $0
$7,287 $139,724
$7,287 $0
$7,287 $147,011
$171,704 $31,981
$139,724
$178,991 $31,981
$147,011
Note: budget is in 2001 $.
P
2006 2Q06
$1,548 $0
$1,548 $26,737
$4,645 $0
$4,645 $103,506
$1,094 $0
$1,094 $24,054 200.
$7,287 $0
$7,287 $154,298 2006 $186,278
$31,981 $154,298
Q
3006
$1,548 $0
$1,548 $28,285
$4,645 $0
$4,645 $108,151
$1,094 $0
$1,094 $25,148
$7,287 $0
$7,287 $161,585
$193,565 $31,981
$161,585
R
4Q06
$1,548 $0
$1,548 $29,833
$4,645 $0
$4,645 $112,796
$1,094 $0
$1,094 $26,242
$7,287 $0
$7,287 $168,872
$200,852 $31,981
$168,872
S
1Q07
$1,548 $0
$1,548 $31,381
$4,645 $0
$4,645 $117,441
$1,094 $0
$1,094 $2 336
$7,287 $0
$7,287 $176,159
$208,139 $31,981
$176,159
Page 21 of41
&[DATE]
SH ELL-MCCLU RG-OS2222
"I
2
~
J:L
~
IL ~ ~
~ LI
-.
L"I ~ '<0 ~
~
"L
TU
2007
2Q07
3007
$1,548 $0
$1,548 $32,929
$1,548 $0
$1,548 $34,477
$4,645 $0
$4,645 $122,086
$1,094 $0
$1,094 $28430
$4,645 $0
$4,645 $126,731
$1,094 $0
$1,094 $29,524
$7,287
$7,287
$0 $0
$7,287
$7,287
$183,446 $190,733
2007
$215,426 $222,713
$31,981
$31,981
$183,446 $190,733
V
4Q07
$1,548 $0
$1,548 $36,025
$4,645 $0
$4,645 $131,376
$1,094 $0
$1,094 $30,618
$7,287 $0
$7,287 $198,020
$230,000 $31,981
$198,020
W
TOTALS
$51,292 $15,267
$1,548 $36,025
$146,265 $14,889 $4,645
$131,376
$32,443 $1,825 $1,09'
$30,618
$230,000 $31,981 $7,287
$198,020
$230,000 $31,981
$198,020
Benzene Health Research Consortium Fudan 1Q04 Financial Report
Page 22 of41
&[DATE]
SH ELL-MCCLU RG-OS2223
A
SRP+ ERP
Cost Centers
Albertini
Budgeted
Actual expense
CurrentVanance
CummVanance
~ Brody (pd from DB5200X1503; resigned 4Q03)
~ Budgeted
Actual expense
CurrentVanance
IL CummVanance
Checkoway
'" Budgeted Actual expense
CurrentVanance
CummVanance
Cherrie I University of Aberdeen 1::1 Budgeted
Actual expense
CurrentVanance
L. CummVanance
Greim
Budgeted
Actual expense
L. CurrentVanance
CummVanance
~Herrick
~
")l.
Budgeted Actual expense
CurrentVanance )L Cumm Vanance
~ Idanpaan-Heikkila
..)"+ Budgeted
..):: ~
Actual expense CurrentVanance
~ Cumm Vanance
")C Larson
..)t1 Budgeted
~
Actual expense
~
"+. "+.: Li
~
CurrentVanance CummVanance
Budgeted
~
"+1: ,,+,
Actual expense CurrentVanance CummVanance
~Minden/OntarioCancerlnstitute
~
::>l.
Budgeted Actual expense
CurrentVanance
)L Cumm Vanance
~ Muelier (resigned 2Q03)
::>"+ Budgeted
::>:: Actual expense
~
CurrentVanance
~
::>C Rice ::>t1
~
Cumm Vanance
Budgeted Actual expense
~ CurrentVanance
CummVanance
0': Rockette
~
Budgeted
~
01:
Actual expense CurrentVanance
CummVanance
~
Budgeted
Actual expense
CurrentVanance
, L Cumm Vanance
Claytonijoined2Q04)
'" Budgeted Actual expense
CurrentVanance
CummVanance
Lombardo ijoined2Q04)
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
D
1st&2ndOtr
ElF
2003
3rdOtr
4thOtr
G
1stOtr
Benzene Health Research Consortium SRP + ERP 1004 Financial Report
HI I J
2004
2ndOtr
3rdOtr
4thOtr
K I LIM I N
2005
1stOtr
2ndOtr
3rdOtr
4thOtr
$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
$0
$0
$0
$0
$0
$0
$250
$3,000
$0
$0
$250
$3,000
$0
$250
$3,250
$3,250
$3,250
$3,500
$6,500
$2,160
$8,640
$4,320
$2,160
$322
($17,602)
$0
$0
$0
$0
$0
$0
$0
$0 $0
$0 $0 $0
$0 $0 $0
$0
$0
$0
$0
$0
$2,160
$8,640
$4,320
$2,160
$322
($17,602)
$0
$0
$0
$0
$0
$0
$0
$2,160
$10,800
$15,120
$17,280
$17,602
$0 $0 $0
$0
$0
$0
$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) 13.858
$322 $0
$322 $14,180
($14,180) $0
($14,180) $0
$0
$250
$3,000
$0
$0
$250
$3,000
$0 $0
$0
$0
$0
$0
$0
$0
$250
$3,000
$0
$0
$250
$3,000
$0
$250
$3,250
$3,250
$3,250
$3,500
$6,500
$2,160 $0
$2,160 $2,160
$8,640 $2,122 $6518 $8,678
$4,320 $0
$4,320 $12,998
$2,160 $0
$2,160 115158
$322 $0
$322 $15,480
($15,480) $0
($15,480) ($0)
$0
$250
$8,000
$0
$0
$250
$8,000
$0 $0
$0
$0
$0
$0
$0
$0
$250
$8,000
$0
$0
$250
$8,000
($0)
$250
$8,250
$8,250
$8,250
$8,500
$16,500
$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
$0
$0
$0
$0
$0
$0
$250
$8,000
$0
$0
$250
$8,000
$0
$250
$8,250
$8,250
$8,250
$8,500
$16,500
$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
$0
$0
$0
$0
$0
$0
$250
$3,000
$0
$0
$250
$3,000
$0
$250
$3,250
$3,250
$3,250
$3,500
$6,500
$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
$250
$8,000
$0 $0
$0
$0
$0
$0
$0
$0
$250
$8,000
$0
$0
$250
$8,000
$0
$250
$8,250
$8,250
$8,250
$8,500
$16,500
$2,160 $2,127
$33 $33
$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
$250
$3,000
$0 $0
$0
$0
$0
$0
$0
$0
$250
$3,000
$0
$0
$250
$3,000
$0
$250
$3,250
$3,250
$3,250
$3,500
$6,500
$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
$0
$0
$0
$0
$0
$0
$250
$10,000
$0
$0
$250
$10,000
$0
$250
$10,250
$10,250
$10,250
$10,500
$20,500
$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
$0
$0
$0
$0
$0
$0
$250
$3,000
$0
$0
$250
$3,000
$0
$250
$3,250
$3,250
$3,250
$3,500
$6,500
$2,160
$8,640
$4,320
$2,160
$322
($16,352)
$0
$0
$0
$0
$0
$0
$0
$1,250
$0
$0 $0 $0
$0 $0 $0
$0
$0
$0
$0
$0
$910
$8,640
$4,320
$2,160
$322
($16,352)
$0
$0
$0
$0
$0
$0
$0
$910
$9,550
$13,870
$16,030
$16,352
$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 $0
$3,000 $3,000
$1,500 $0
$1,500 $4,500
$4,000 $0
$4,000 $8,500
$1,500 $0
$1,500 $10,000
$1,000 $0
$1,000 $11,000
$1,500 $0
$1,500 $12,500
$4,000 $0
$4,000 $16,500
$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
$250
$3,000
$0 $0
$0
$0
$0
$0
$0
$0
$250
$3,000
$0
$0
$250
$3,000
$0
$250
$3,250
$3,250
$3,250
$3,500
$6,500
$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
$0
$0
$0
$0
$0
$0
$250
$10,000
$0
$0
$250
$10,000
$0
$250
$10,250
$10,250
$10,250
$10,500
$20,500
$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 $0
$0
$0
$0
$0
$0
$0
$0
$250
$3,000
$0
$0
$250
$3,000
$0
$0
$250
$3,250
$3,250
$3,250
$3,500
$6,500
$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 338
$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
$0 $3,000 $3,000
2004 $86,354 $83,354
$3,000
$4,750 $0
$4,750 $7,750
$91,104 $83,354
$7,750
$3,000 $0
$3,000 $3,250
$72,000 $0
$72,000 $79,750
$163,104 $83,354 $79,750
$0 $0 $0 $3,250
$1,500 $0
$1,500 $81,250
$164,604 $83,354 $81,250
$0 $0 $0 $3,250
$250 $0
$250 $3,500
2005
$1,000
$4,750
$0 $0
$1,000
$4,750
$82,250
$87,000
2005
$165,604
$170,354
$83,354
$83,354
$82,250
$87,000
$3,000 $0
$3,000 $6,500
$72,000 $0
$72,000 $159,000
$242,354 $83,354
$159,000
o
1stOtr
IP
Q
2006
2ndOtr
3rdOtr
IR
4thOtr
$0 $0 $0 $6,500
$0 $0 $0 $6,500
$250 $0
$250 $6,750
$3,000 $0
$3,000 $9,750
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $6,500
$0 $0 $0 $6,500
$250 $0
$250 $6,750
$3,000 $0
$3,000 $9,750
$0 $0 $0 $16,500
$0 $0 $0 $16,500
$250 $0
$250 $16,750
$6,000 $0
$6,000 $22,750
$0 $0 $0 $16,500
$0 $0 $0 $16,500
$250 $0
$250 $16,750
$6,000 $0
$6,000 $22,750
$0 $0 $0 $6,500
$0 $0 $0 $6,500
$250 $0
$250 $6,750
$3,000 $0
$3,000 $9,750
$0 $0 $0 $16,500
$0 $0 $0 $16,500
$250 $0
$250 $16,750
$8,000 $0
$8,000 $24,750
$0 $0 $0 $6,500
$0 $0 $0 $6,500
$250 $0
$250 $6,750
$3,000 $0
$3,000 $9,750
$0 $0 $0 $20,500
$0 $0 $0 $20,500
$250 $0
$250 $20,750
$10,000 $0
$10,000 $30,750
$0 $0 $0 $6,500
$0 $0 $0 $6,500
$250 $0
$250 $6,750
$3,000 $0
$3,000 $9,750
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$1,000 $0
$1,000 $17,500
$1,000 $0
$1,000 $18,500
$1,000 $0
$1,000 $19,500
$4,000 $0
$4,000 $23,500
$0 $0 $0 $6,500
$0 $0 $0 $6,500
$250 $0
$250 $6,750
$3,000 $0
$3,000 $9,750
$0 $0 $0 $20,500
$0 $0 $0 $20,500
$250 $0
$250 $20,750
$10,000 $0
$10,000 $30,750
$0 $0 $0 $6,500
$0 $0 $0 $6,500
$250 $0
$250 $6,750
$3,000 $0
$3,000 $9,750
$0 $0 $0 $6,500
$1,000 $0
$1,000 $160,000
$243,354 $83,354
$160,000
$0 $0 $0 $6,500
$250 $0
$250 $6,750
2006
$1,000
$4,250
$0 $0
$1,000
$4,250
$161,000
$165,250
2006
$244,354
$248,604
$83,354
$83,354
$161,000
$165,250
$3,000 $0
$3,000 $9,750
$68,000 $0
$68,000 $233,250
$316,604 $83,354
$233,250
SIT
U
2007
1stOtr
2ndOtr
3rdOtr
IV
4thOtr
w
TOTALS
$0 $0 $0 $9,750
$0 $0 $0 $9,750
$250 $0
$250 $10,000
$3,000 $0
$3,000 $13,000
$17,529 $4,529 $3,000
$13,000
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $9,750
$0 $0 $0 $9,750
$250 $0
$250 $10,000
$3,000 $0
$3,000 $13,000
$16,422 $3,422 $3,000
$13,000
$0 $0 $0 $22,750
$0 $0 $0 $22,750
$250 $0
$250 $23,000
$2,000 $0
$2,000 $25,000
$27,122 $2,122 $2,000
$25,000
$0 $0 $0 $22,750
$0 $0 $0 $22,750
$250 $0
$250 $23,000
$2,000 $0
$2,000 $25,000
$32,334 $7,334 $2,000
$25,000
$0 $0 $0 $9,750
$0 $0 $0 $9,750
$250 $0
$250 $10,000
$2,000 $0
$2,000 $12,000
$18,454 $6,454 $2,000
$12,000
$0 $0 $0 $24,750
$0 $0 $0 $24,750
$250 $0
$250 $25,000
$8,000 $0
$8,000 $33,000
$37,524 $4,524 $8,000
$33,000
$0 $0 $0 $9,750
$0 $0 $0 $9,750
$250 $0
$250 $10,000
$2,000 $0
$2,000 $12,000
$16,763 $4,763 $2,000
$12,000
$0 $0 $0 $30,750
$0 $0 $0 $30,750
$250 $0
$250 $31,000
$4,000 $0
$4,000 $35,000
$57,890 $22,890
$4,000 $35,000
$0
$0 $9,750
$0 $0 $0 $9,750
$250 $0
$250 $10,000
$2,000 $0
$2,000 $12,000
$13,000 $1,000 $2,000
$12,000
$0 $0 $0 $0 $1,250
$0 $0 $0 $0 $1,250
$0 $0 $0 $0
$0
$0 $0 $0 $0
$0
$1,000 $0
$1,000 $24,500
$1,000 $0
$1,000 $25,500
$1,000 $0
$1,000 $26,500
$3,000 $0
$3,000 $29,500
$41,692 $12,192
$3,000 $29,500
$0 $0 $0 $9,750
$0 $0 $0 $9,750
$250 $0
$250 $10,000
$2,000 $0
$2,000 $12,000
$14,670 $2,670 $2,000
$12,000
$0 $0 $0 $30,750
$0 $0 $0 $30,750
$250 $0
$250 $31,000
$2,000 $0
$2,000 $33,000
$43,204 $10,204
$2,000 $33,000
$0 $0 $0 $9,750
$0 $0 $0 $9,750
$250 $0
$250 $10,000
$3,000 $0
$3,000 $13,000
$13,000 $0
$3,000 $13,000
$0 $0 $0 $9,750
$1,000 $0
$1,000 $234,250
$317,604 $83,354
$234,250
$0 $0 $0 $9,750
$250 $0
$250 $10,000
2007
$1,000
$4,250
$0 $0
$1,000
$4,250
$235,250
$239,500
2007
$318,604
$322,854
$83,354
$83,354
$235,250
$239,500
$3,146 $0
$3,146 $13146
$41,146 $0
$41,146 $280,646
$364,000 $83,354
$280,646 .,,",'TCl
$13,146 $0
$3,146 $13,146
$364,000 $83,354 $41,146
$280,646
$364,000 $83,354
$280,646
SH ELL-MCCLU RG-OS2224
A IBI c I D I E
-"'"
""::I~
Blue fulure cumulallvevanance has no meaning unlll Expense enlered LT5/7/04
::It BJ5/7/04
Benzene Health Research Consortium SRP + ERP 1004 Financial Report
F G IHI I I J I K
1Q04 budget ajustments 10 zero ourvanancelo develop more usefuI
1:~2d,i:~lmeetmq
ChangeapprovedbyOCal
L
M
N0
PQ RS T UV
W
Page 24 of41
&[DATE]
SH ELL-MCCLU RG-OS222S
Benzene Health Research Consortium Communications 1Q04 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
BC
D
2001
2002
lst- 4th OtL lst- 4th OtL 1st & 2nd OtL
E
2003 3rd OtL
F
4th OtL"
G
lstOtL
HI
2004 2nd OtL 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
($187,396) $26,541
($213,937) ($0)
$14,401 $0
$14,401 $14,401
$14,400 $0
$14,400 $28,801
$14,400 $0
$14,400 $43,201
$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
($5,876) $1,132 ($7,008)
$0
$450 $0
$450 $450
$450 $0
$450 $900
$450 $0
$450 $1,350
$600 $0
$600 $600
$2,400 $1,417
$983 $1,583
$1,250 $80
$1,170 $2753
$625 $0
$625 $3378
($3,364) $15
($3,379) $2
$150 $0
$150 $148
$150 $0
$150 $298
$150 $0
$150 $448
J
4th OtL
$14,400 $0
$14,400 $57,601
$450 $0
$450 $1,800
$150 $0
$150 $598
K
lstOtL
L
2 2nd OtL
$14,400 $0
$14,400 $72,001
$14,400 $0
$14,400 $86,401
$450 $0
$450 $2,250
$450 $0
$450 $2,700
$150 $0
$150 $748
$150 $0
$150 $898
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
~ Actual expense ~ CurrentVariance
Cumm Variance
.)~
~ ~
.)t
Budgeted Actual expense CurrentVariance
;j, Cumm Variance
~ ~
"I~
4'
Budgeted Actual expense CurrentVariance
TOTALS
~
Cumm Variance
~ CUMULATIVE TOTALS
"1"1 Budgeted
4~ Expense
"10 Variance
"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 5/6/04
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 2001 $60,000
$0 $60,000 $60,000 2001 $60,000
$0 $60,000
$0.00 $0.00 $0.00 $0.00
$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
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$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
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
($196,636) $27,688
($224,324) ($2)
$15,001 $0
$15,001 $14,999
$290,864 $290,866
($2)
$305,865 $290,866
$14,999
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
2004
$15,000 $15,000
$0 $0
$15,000 $15,000
$29,999 $44,999
2004
$320,865 $335,865
$290,866 $290,866
$29,999 $44,999
$0.00 $0.00 $0.00 $0.00
$15,000 $0
$15,000 $59,999
$350,865 $290,866
$59,999
$0.00 $0.00 $0.00 $0.00
$15,000 $0
$15,000 $74,999
$365,865 $290,866
$74,999
$0.00 $0.00 $0.00 $0.00
2 $15,000
$0 $15,000 $89,999
2 $380,865 $290,866
$89,999
Page 25 of41
&[DATE]
SH ELL-MCCLU RG-OS2226
Benzene Health Research Consortium Communications 1Q04 Financial Report
M
05 ~ 3rd Olr ~ "I $14,400
$0 $14,400 $100,801
N
4lh Olr
$14,400 $0
$14,400 $115,201
0
1sl0lr
$14,400 $0
$14,400 $129,601
PQ
2006 2nd Olr 3rd Olr
$14,400 $0
$14,400 $144,001
$14,400 $0
$14,400 $158,401
R
4lh Olr"
$14,400 $0
$14,400 $172,801
S
1sl0lr
$18,865 $0
$18,865 $191,666
TU
2007 2nd Olr 3rd Olr
$18,865 $0
$18,865 $210,531
$18,866 $0
$18,866 $229,397
V
4lh Olr
$18,866 $0
$18,866 $248,263
~
$450
$450
$450
$450
$450
$450
$689
$689
$689
$689
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$450
$450
$450
$450
$450
$450
$689
$689
$689
$689
$3,150
$3,600
$4,050
$4,500
$4,950
$5,400
$6,089
$6,778
$7,466
$8,155
L<L $150
~ $0 $150
$1,048
$150 $0
$150 $1,198
$150 $0
$150 $1,348
$150 $0
$150 $1,498
$150 $0
$150 $1,648
$150 $0
$150 $1,798
$230 $0
$230 $2,028
$230 $0
$230 $2,257
$230 $0
$230 $2,487
$230 $0
$230 $2,717
G:L
'[ ~ ~
~"I L~
~
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
L~ $0.00
~ $0.00 ~ $0.00
$0.00
.)~
~ ~
.)t
$0.00 $0.00 $0.00
;j, $0.00
~ 05
~
"I~
4'
$15,000 $0
$15,000
~ $104,999
~05
"1"1 $395,865 4~ $290,866 "10 $104,999
"I,
~ ~
:)~
o
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$15,000 $0
$15,000 $119,999
$410,865 $290,866 $119,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
$15,000 $0
$15,000 $134,999
$425,865 $290,866 $134,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
2006
$15,000 $15,000
$0 $0
$15,000 $15,000
$149,999 $164,999
2006
$440,865 $455,865
$290,866 $290,866
$149,999 $164,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
$15,000 $0
$15,000 $179,999
$470,865 $290,866 $179,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
$19,783 $0
$19,783 $199,782
$490,648 $290,866 $199,782
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$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
$19,783 $19,784
$0 $0
$19,783 $19,784
$219,566 $239,350
2007
$510,431 $530,216
$290,866 $290,866
$219,566 $239,350
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$19,784 $0
$19,784 $259,134
$550,000 $290,866 $259,134
W
TOTALS
$528,867 $280,604 $248,263 $248,263
$16,904 $8,749 $8,155 $8,155
$4,229 $1,513 $2,717 $2,717
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$550,000 $290,866 $179,999 $259,134
$550,000 $290,866 $259,134
Page 26 of41
&[DATE]
SH ELL-MCCLU RG-OS2227
Benzene Health Research Consortium Legal 1Q04 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
LT 515/04
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 $0
$4,175 $7,985
$4,175 $0
$4,175 $12159
J
4thQtr.
$4,175 $0
$4,175 $16,334
$33,208 $33,208
$0
$37,383 $33,572
$3,810
$41,557 $33,572
$7,985
$45,732 $33,572 $12,159
$49,906 $33,572 $16,334
K
1stQtr.
LM
2005
2nd Qtr.
3rd Qtr.
$4,175 $0
$4,175 $20,508
$4,175 $0
$4,175 $24,683
$4,175 $0
$4,175 $28,857
$54,081 $33,572 $20,508
$58,255 $33,572 $24,683
$62,430 $33,572 $28,857
N
4thQtr.
$4,175 $0
$4,175 $33,032
$66,604 $33,572 $33,032
0
1stQtr.
PQ
2006
2nd Qtr.
3rd Qtr.
$4,175 $0
$4,175 $37206
$4,175 $0
$4,175 $41381
$4,175 $0
$4,175 $45,555
$70,779 $33,572 $37,206
$74,953 $33,572 $41,381
$79,128 $33,572 $45,555
R
4thQtr.
$4,175 $0
$4,175 $49730
$83,302 $33,572 $49,730
S
1stQtr.
TU
2007
2nd Qtr.
3rd Qtr.
$4,175 $0
$4,175 $53904
$4,175 $0
$4,175 $58,079
$4,175 $0
$4,175 $62,253
$87,477 $33,572 $53,904
$91,651 $33,572 $58,079
$95,826 $33,572 $62,253
V
4thQtr.
$4,175 $0
$4,175 $66,428
$100,000 $33,572 $66,428
Page 27 of41
&[DATE]
SH ELL-MCCLU RG-OS2228
W
TOTALS L.
--zt $100,000 0 $33,572
$66,428 $66,428
--g- $100,000 IU $33,572
$66,428
12
14
f5"
Benzene Health Research Consortium Legal 1Q04 Financial Report
Page 28 of41
&[DATE]
SH ELL-MCCLU RG-OS2229
Benzene Health Research Consortium QA-QC 1Q04 Financial Report
A
QA-QC ~ Cost Centers ~ Contractor "I Budgeted 0 Actual expense ~ CurrentVariance
Cumm Variance
Travel ~ Budgeted
LlL Actual expense
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 OtL
K
1stOtL
LM
2005 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
$6,250 $0
$6,250 $25,000
$6,250 $0
$6,250 $31,250
$6,250 $0
$6,250 $37,500
$6,250 $0
$6,250 $43,750
$6,250 $0
$6,250 $50,000
$6,250 $0
$6,250 $56,250
$6,250 $0
$6,250 $62,500
$6,250 $0
$6,250 $68,750
$6,250 $0
$6,250 $75,000
$6,250 $0
$6,250 $81,250
$6,250 $0
$6,250 $87,500
$6,250 $0
$6,250 $93,750
$6,250 $0
$6,250 $100,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
L<l Budgeted 12 Actual expense
CurrentVariance
Cumm Variance
~ ~ L'
l.
~ ~ L"I
Budgeted Actual expense CurrentVariance Cumm Variance
Budgeted
l.o ~
L,
Actual expense CurrentVariance Cumm Variance
l.~ Budgeted
~ ~
Actual expense CurrentVariance Cumm Variance
,).0
~ ~
Budgeted Actual expense CurrentVariance
;j, Cumm Variance
~ ~ "IU
4'
IAL
Budgeted Actual expense CurrentVariance
~
Cumm Variance
~ CUMULATIVE TOTALS "1"1 Budgeted
40 Expense
"10 Variance
Dlue: u ure cumu a Ive
variance has no meaning
47 until Expense entered.
~
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
'UU'
$13,500 $0
$13,500 $13,500 2001 $13,500
$0 $13,500
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
'UU,
$54,000 $0
$54,000 $67,500 2002 $67,500
$0 $67,500
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$28,126 $0
$28,126 $95,626
$95,626 $0
$95,626
$0 $0 $0 $0
'UUO
$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
IU4
$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
$6,250 $0
$6,250 $25,000
$6,250 $0
$6,250 $31,250
$25,000 $31,250 $0 $0
$25,000 $31,250
$0 $0 $0 $0 $0 $0 $0 $0
" UO
$6,250 $6,250 $0 $0
$6,250 $6,250 $37,500 $43,750
2005 $37,500 $43,750
$0 $0 $37,500 $43,750
$0 $0 $0 $0
$6,250 $0
$6,250 $50,000
$50,000 $0
$50,000
$0 $0 $0 $0
$6,250 $0
$6,250 $56,250
$56,250 $0
$56,250
$0 $0 $0 $0 $0 $0 $0 $0
UO
$6,250 $6,250 $0 $0
$6,250 $6,250 $62,500 $68,750
2006 $62,500 $68,750
$0 $0 $62,500 $68,750
$0 $0 $0 $0
$6,250 $0
$6,250 $75,000
$75,000 $0
$75,000
$0 $0 $0 $0
$6,250 $0
$6,250 $81,250
$81,250 $0
$81,250
$0 $0 $0 $0 $0 $0 $0 $0
IUf
$6,250 $6,250 $0 $0
$6,250 $6,250 $87,500 $93,750
2007 $87,500 $93,750
$0 $0 $87,500 $93,750
$0 $0 $0 $0
$6,250 $0
$6,250 $100,000
$100,000 $0
$100,000
* budget adjustment to lower program
budget from $225K to $1 OOK, as
49 approved by DC on 11/11/03
~ LT 515/04
Page 29 of41
&[DATE]
SH ELL-MCCLU RG-OS2230
~ ~ "I 0 ~
~
LlL
L<l 12
~ ~ L' l. ~ ~ L"I l.o ~
L, l.~ ~ ~
,).0 ~ ~
;j,
~ ~ "IU 4' ~ ~ "1"1 40 "10
W
TOTALS
$100,000 $0
$100,000 $100,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
$100,000 $0
$100,000 $100,000
$100,000 $0
$100,000
47
~
49
~
Benzene Health Research Consortium QA-QC 1Q04 Financial Report
Page 30 of41
&[DATE]
SH ELL-MCCLU RG-OS2231
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
~
Budgeted
~ "It
Expense Variance
"I,
~ LT 5/7/04
~
:>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) Supported Expense dro off Jeft some funds for consultant
Benzene Health Research Consortium API Administration 1Q04 Financial Report
B C D E I FIG
2000
2001
2002
2003
Ist- 4th OtL Ist- 4th OtL Ist- 4th OtL 1st & 2nd OtL 3rd OtL 4th OtL
HI I I J IK
2004
IstOtL 2nd OtL 3rd OtL 4th OtL
L IMI NI0
2005
IstOtL 2nd OtL 3rd OtL 4th OtL
P
IstOtL
$0 $9,039 ($9,039) ($9,039)
$0 $18,749
$6,552 ($2,487)
$85,700 $89,669 ($3,969) ($6,456)
$44,500 $57,297 ($12,797) ($19,253)
$22,250 $32,217 ($9,967) ($29,220)
$22,250 $32,800 ($10,550) ($39,770)
$27,250 $26,745
$505 ($39,265)
$27,250 $0
$27,250 ($12,015)
$27,250 $0
$27,250 $15,235
$27,250 $0
$27,250 $42,485
$15,000 $0
$15,000 $57,485
$15,000 $0
$15,000 $72,485
$15,000 $0
$15,000 $87,485
$15,000 $0
$15,000 $102,485
$15,000 $0
$15,000 $117,485
$0 $774 ($774) ($774)
$0 $2,329 ($2,329) ($3,103)
$10,900 $ $11,209
($309) ($3,412)
5,500 $ 2,750
$7,162
$4,027
($1,662) ($1,277)
($5,074) ($6,351)
$2,750 $ 3,250
$4,100
$3,343
($1,350)
($93)
($7,701) ($7,794)
$3,250 $0
$3,250 ($4,544)
$3,250 $0
$3,250 ($1,294)
$3,250 $0
$3,250 $1,956
$1,500 $0
$1,500 $3,456
$1,500 $0
$1,500 $4,956
$1,500 $0
$1,500 $6,456
$1,500 $0
$1,500 $7,956
$1,500 $0
$1,500 $9,456
$0 $342 ($342) ($342)
$0 $0 $0 ($342)
$50,000 $4,686
$45,314 $44,972
15,000 $0
$15,000 $59,972
$7,500 $0
$7,500 $67,472
$7,500 $7,313
$187 $67,659
$1,250 $4,805 ($3,555) $64,104
$1,250 $0
$1,250 $65,354
$1,250 $0
$1,250 $66,604
$1,250 $0
$1,250 $67,854
$1,000 $0
$1,000 $68,854
$1,000 $0
$1,000 $69,854
$5,000 $0
$5,000 $74,854
$1,000 $0
$1,000 $75,854
$1,000 $0
$1,000 $76,854
$0 $1,673 ($1,673) ($1,673)
$0 $4,173 ($4,173) ($5,846)
$10,300 $6,140 $4,160 ($1,687)
$5,000 $5,077
($77) ($1,764)
$2,500 $1,755
$745 ($1,019)
$18,205 $26,276 ($8,071) ($9,090)
$6,000 $18,753 ($12,753) ($21,843)
$6,000 $0
$6,000 ($15,843)
$6,000 $0
$6,000 ($9,843)
$6,000 $0
$6,000 ($3,843)
$1,500 $0
$1,500 ($2,343)
$1,500 $0
$1,500 ($843)
$5,000 $0
$5,000 $4,157
$1,500 $0
$1,500 $5,657
$1,500 $0
$1,500 $7,157
$0 $5,752 ($5,752) ($5,752)
$0 $4,687 ($4,687) ($10,439)
$18,500 $ $25,110 ($6,610) ($17,049)
12,500 $ 6,250
$16,043
$9,021
($3,543) ($2,771)
($20,592) ($23,363)
$6,250 $ 7,500
$9,185
$7,489
($2,935)
$11
($26,298) ($26,287)
$7,500 $0
$7,500 ($18,787)
$7,500 $0
$7,500 ($11,287)
$7,500 $0
$7,500 ($3,787)
$4,000 $0
$4,000 $213
$4,000 $0
$4,000 $4,213
$4,000 $0
$4,000 $8,213
$4,000 $0
$4,000 $12,213
$4,000 $0
$4,000 $16,213
$0 $0 $60,600
$0 $13,886 $58,794
$0 ($13,886)
$1,806
$0 ($13,886) ($12,080)
$30,500 $34,213 ($3,713) ($15,793)
$15,250 $19,478 ($4,228) ($20,021)
$15,250 $17,231 ($1,981) ($22,002)
$28,000 $28,000
$0 ($22,002)
$28,000 $0
$28,000 $5,998
$28,000 $0
$28,000 $33,998
$28,000 $0
$28,000 $61,998
$10,000 $0
$10,000 $71,998
$10,000 $0
$10,000 $81,998
$10,000 $0
$10,000 $91,998
$10,000 $0
$10,000 $101,998
$10,000 $0
$10,000 $111,998
$0 $7,020 ($7,020) $7020
2000 $0
$24,600 ($24,600) ($24,600)
2000 $0
$24,600 ($24,600)
$0 $1,712 ($1,712) $8,732
2001 $0
$45,536 ($45,536) $70,136
2001 $0
$70,136 ($70,136)
$0 $0 $0 $8732
200 $236,000 $195,608
$40,392 $29,745
2002 $236,000 $265,745 ($29,745)
$
11,500 $17,000 ($5,500) $14,232
2003 $124,500 $136,792 ($12,292)
$42,037
2003 $360,500 $402,537 ($42,037)
$ 5,750 $8,499 ($2,749)
$16981
$62,250 $74,997 ($12,747) $54,784
$422,750 $477,534 ($54,784)
$5,750 ($8,250) $14,000 $2981
$77,955 $88,655 ($10,700) $65,484
$500,705 $566,189 ($65,484)
$4,500 $4,500
$0 $2981
2004 $77,750 $93,635 ($15,885) $81,369
2004 $578,455 $659,824 ($81,369)
$4,500 $0
$4,500 $1519
$77,750 $0
$77,750 $3,619
$656,205 $659,824
($3,619)
$4,500 $0
$4,500 $6019
$77,750 $0
$77,750 $74,131
$733,955 $659,824
$74,131
$4,500 $0
$4,500 $10519
$77,750 $0
$77,750 $151,881
$811,705 $659,824 $151,881
$1,250 $0
$1,250 $11769
$34,250 $0
$34,250 $186,131
$845,955 $659,824 $186,131
$1,250
$1,250
$0 $0
$1,250
$1,250
$13019 $14269
2( 05
$34,250 $41,750
$0 $0
$34,250 $41,750
$220,381 $262,131
2005
$880,205 $921,955
$659,824 $659,824
$220,381 $262,131
$1,250 $0
$1,250 $15519
$34,250 $0
$34,250 $296,381
$956,205 $659,824 $296,381
$1,250 $0
$1,250 $16769
$34,250 $0
$34,250 $330,631
$990,455 $659,824 $330,631
Page 31 of41
&[DATE]
SH ELL-MCCLU RG-OS2232
Benzene Health Research Consortium API Administration 1Q04 Financial Report
QI RIs
2006
2nd OIL
3rd OIL
4lh OIL
TI uIvIw
2007
1sl0lL 2nd OIL 3rd OIL
4lh OIL
~ $15,000
.2 $0
$15,000
$132,485 ~ ~ $1,500
$0
$1,500 ~ $10,956 ~ 1"1 $1,000 10 $0 ~ $1,000
$77,854
$15,000 $0
$15,000 $147,485
$1,500 $0
$1,500 $12,456
$5,000 $0
$5,000 $82,854
$15,000 $0
$15,000 $162,485
$1,500 $0
$1,500 $13,956
$1,000 $0
$1,000 $83,854
$15,000 $0
$15,000 $177,485
$1,500 $0
$1,500 $15,456
$1,000 $0
$1,000 $84,854
$15,000 $0
$15,000 $192,485
$1,500 $0
$1,500 $16,956
$1,000 $0
$1,000 $85,854
$15,000 $0
$15,000 $207,485
$1,500 $0
$1,500 $18,456
$5,000 $0
$5,000 $90,854
$15,000 $0
$15,000 $222,485
$1,500 $0
$1,500 $19,956
$1,000 $0
$1,000 $91,854
I~ ~
-.
L.
L ~ ~ L' l. ~ ~
.,)u
;j'
~ ~
,,)"1
;jo
~ .",
;jts
;j~
~ ~ "IL
4;j
~ ~ "It
"I,
~ ~
:>u
$1,500 $0
$1,500 $8,657
$5,000 $0
$5,000 $13,657
$4,000 $0
$4,000 $20,213
$4,000 $0
$4,000 $24,213
$10,000 $0
$10,000 $121,998
$10,000 $0
$10,000 $131,998
$1,250
$1,250
$0 $0
$1,250
$1,250
$18,019
$19,269
2006
$34,250
$41,750
$0 $0
$34,250
$41,750
$364,881 $406,631
2006
$1,024,705 $1,066,455
$659,824 $659,824
$364,881 $406,631
$1,500 $0
$1,500 $15,157
$4,000 $0
$4,000 $28,213
$10,000 $0
$10,000 $141,998
$1,250 $0
$1,250 $20,519
$34,250 $0
$34,250 $440,881
$1,100,705 $659,824 $440,881
$1,500 $0
$1,500 $16,657
$4,000 $0
$4,000 $32,213
$10,000 $0
$10,000 $151,998
$1,250 $0
$1,250 $21,769
$34,250 $0
$34,250 $475,131
$1,134,955 $659,824 $475,131
$1,500 $0
$1,500 $18,157
$5,000 $0
$5,000 $23,157
$4,000 $0
$4,000 $36,213
$4,000 $0
$4,000 $40,213
$10,000 $0
$10,000 $161,998
$10,000 $0
$10,000 $171,998
$1,250
$1,250
$0 $0
$1,250
$1,250
$23,019 $24,269
2007
$34,250 $41,750
$0 $0
$34,250 $41,750
$509,381 $551,131
2007
$1,169,205 $1,210,955
$659,824 $659,824
$509,381 $551,131
$1,500 $0
$1,500 $24,657
$4,000 $0
$4,000 $44,213
$10,000 $0
$10,000 $181,998
$1,250 $0
$1,250 $25,519
$34,250 $0
$34,250 $585,381
$1,245,205 $659,824 $585,381
~
X
TOTALS
$403,700 $257,477 $171,524 $146,223
$52,900 $32,170 $20,730 $20,730
$109,000 $16,804 $92,196 $92,196
$88,505 $62,175 $26,330 $26,330
$121,500 $71,535 $49,965 $49,965
$353,600 $171,602 $181,998 $181,998
$56,000 $23,461 $32,539 $32,539
$1,245,205 $635,224 $609,981 $609,981
$1,245,205 $659,824 $585,381
Page 32 of41
&[DATE]
SH ELL-MCCLU RG-OS2233
A
~
Continaencv Funds "I
Budgeted
Actual expense CurrentVariance Cumm Variance
Reallocations from UCHSC Budgeted
Actual expense CurrentVariance U Cumm Variance
L<L Reallocations from AHS
~ Budgeted Actual expense CurrentVariance Cumm Variance
G:L
Budgeted
"[ ~
Actual expense CurrentVariance Cumm Variance
~"I
L~ Budgeted
~ Actual expense ~ CurrentVariance
Cumm Variance
L. ~ ~
;j;j
~ ~
.)t ;j
,)0
Budgeted Actual expense CurrentVariance Cumm Variance
Budgeted Actual expense CurrentVariance Cumm Variance
~
"I~
4'
~ "I.
TOTALS Budgeted Actual expense CurrentVariance Cumm Variance
"1"1 CUMULATIVE TOTALS 4~ Budgeted ~ Expense "I. Variance
"Ie
4~
~ LT 5/5/04
.2
o;j ~
Benzene Health Research Consortium Contingency Fund 1Q04 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
Page 33 of 41
&[DATE]
SH ELL-MCCLU RG-OS2234
Benzene Health Research Consortium Contingency Fund 1Q04 Financial Report
G
~ 2003 4lh OIL
"I
$290,272 $0
$290,272 $290,272
$0 $48,839 ($48,839) U ($48,839)
L<L
~ $0 $52,634 ($52,634) ($52,634)
G:L
"[ ~
$0 $0 $0 $0
~"I
L~
~ ~
$0 $0 $0 $0
L. ~ ~
;j;j
~ ~
.)t ;j
,)0
$0 $0 $0 $0
$0 $0 $0 $0
~
"I~
4'
~ "I.
"1"1 4~
~ "I.
2003 2003
$290,272.00 $101,473.00 $188,799.00 $188,799.00
$290,272.00 $101,473.00 $188,799.00
"Ie
i 4Q03 Adjustment - per Technical Committee, transfer $48,839 from UCHSC expense detail to contingency because expenses not part of UCHSC 9
o;j ~
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]
SH ELL-MCCLU RG-052235
Benzene Health Research Consortium Contingency Fund 1Q04 Financial Report
H
~ 2004 1stOtr.
"I $0 $0 $0
$290,272
U
L<L
~
G:L
"[ ~
~"I
L~
~ ~
L.
~ ~
;j;j
~ ~
.)t
;j
,)0
~
"I~
4'
2004
~ "I.
"1"1 4~
~ "I,
2004
"Ie
i nt budget: 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) fLOm EMBSI for. final feasibility study wor.k (ver.y 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 $0.00 $0.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 $0.00 $0.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
$0.00 $0.00 $0.00 $188,799.00
$0.00 $0.00 $0.00
K
4th 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 $0.00 $0.00
L
1stOtr.
$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 $0.00 $0.00
MN
2005
2nd Otr.
3r.d Otr.
$0 $0 $0 $290,272
$0 $0 $0 $290,272
$0 $0 $0 ($48,839)
$0 $0 $0 ($48,839)
$0 $0 $0 ($52,634)
$0 $0 $0 ($52,634)
$0 $0 $0 $0 $0 $0 $0 $0
$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 $188,799.00
2005 $0.00 $0.00 $0.00
$0 $0 $0 $0
$0.00 $0.00 $0.00 $188,799.00
$0.00 $0.00 $0.00
Page 35 of 41
&[DATE]
SH ELL-MCCLU RG-OS2236
Benzene Health Research Consortium Contingency Fund 1Q04 Financial Report
~
"I
U
L<L
~
G:L
"[ ~
~"I L~
~ ~
L. ~ ~
;j;j ~ ~
.)t ;j ,)0 ~
"I~
4' ~ "I.
"1"1 4~ ~ "I. "Ie 4~ ~
.2
o;j ~
0
4lh OIL
$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 $0.00 $0.00
P
1sl0lL
$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 $0.00 $0.00
QR
2006
2nd OIL
3Ld OIL
$0 $0 $0 $290,272
$0 $0 $0 $290,272
$0 $0 $0 ($48,839)
$0 $0 $0 ($48,839)
$0 $0 $0 ($52,634)
$0 $0 $0 ($52,634)
$0 $0 $0 $0 $0 $0 $0 $0
$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 $188,799.00
2006 $0.00 $0.00 $0.00
$0 $0 $0 $0
$0.00 $0.00 $0.00 $188,799.00
$0.00 $0.00 $0.00
S
4lh OIL
$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 $0.00 $0.00
T
1sl0lL
$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 $0.00 $0.00
UV
2007
2nd OIL
3Ld OIL
$0 $0 $0 $290,272
$0 $0 $0 $290,272
$0 $0 $0 ($48,839)
$0 $0 $0 ($48,839)
$0 $0 $0 ($52,634)
$0 $0 $0 ($52,634)
$0 $0 $0 $0 $0 $0 $0 $0
$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 $188,799.00
2007 $0.00 $0.00 $0.00
$0 $0 $0 $0
$0.00 $0.00 $0.00 $188,799.00
$0.00 $0.00 $0.00
W
4lh OIL
$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 $0.00 $0.00
X
TOTALS
$290,272 $0 $0
$290,272
$0 $48,839
$0 ($48,839)
$0 $52,634
$0 ($52,634)
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$290,272.00 $101,473.00
$0.00 $188,799.00
$0.00 $0.00 $0.00
Page 36 of 41
&[DATE]
SH ELL-MCCLU RG-OS2237
A
~ ~ INCOME
"I Sponsor Payments API Interest UCHSC Interest
TOTALS Reporting Period
~ Cumulative
projected income U 14 LT 5/6/04
Benzene Health Research Consortium Income 1Q04 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.
I
2004 2nd Qtr.
J
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 $ 4,259,964.50 $ 1,485,874.50
$3,186
$5,276
$0 $0 $0
$5,000
$100,000
$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 $15,257,275
$1,485,875
$5,000
$0
$0
$0
$0
$0
$0
$0 $100,000
$0
$16,743,149 $16,748,149 $16,748,149 $16,748,149 $16,748,149 $16,748,149 $16,748,149 $16,748,149 $16,748,149 $16,848,149 $16,848,149
Page 37 of41
&[DATE]
SH ELL-MCCLU RG-OS2238
S
~ 4th Qtr. ~
"I
T
1stQtr.
UV
2007
2nd Qtr.
3rd Qtr.
W
4th Qtr.
X
TOTALS
$0 $0 $0 $0 $0 ~ $16,848,149 $16,848,149 $16,848,149 $16,848,149 $16,848,149
U 14
Benzene Health Research Consortium Income 1Q04 Financial Report
Page 38 of41
&[DATE]
SH ELL-MCCLU RG-OS2239
A T
2 Company Name 3 BP 4 5 6 ChevronTexaco 7 8 ConocoPhillips 9 10 11 ExxonMobii 12 13 14 15 Shell 16 17
18 Marathon
19 20
21 Total 22 23 LT 5/5/04
BC
D
(Seed Money)
$15,000 $22,500
Inv. # 522922 528453
Date Paid 8-Nov-00 19-Jun-01
Benzene Health Research Consortium Sponsor Invoice Detail1Q04 Financial Report
EF
2001
G
HI
2002
J
K LM
3rd -4th Otr.
N0
2003
P
22-Aug-01 $768,941
Inv. # Date Paid
529301
4-0cl-01
9-Jan-02 $806,441
Inv. # 532263
Date Paid 22-Feb-02
27-Aug-02 $1,344,069
$112,008
Inv. # 535033
Date Paid 11-0cl-02 2-0cl-02
23-Sep-03 $1,431,041.00
Inv. # Date Paid
544951
4-Dec-03
Q
TOTAL $4,500,000
$15,000 522923 7-Nov-00
$522,627 529302
9-0cl-01
$537,627 532244 22-Feb-02
$896,046 535034
5-Nov-02 $1,028,700.00 544953 19-Nov-03
$3,000,000
$15,000 $7,500
522924 31-0cl-00 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 27-0cl-03
$1,500,000
$0 523540
$1,612,882 $806,441 $806,441
532246
23-Jan-02 11-Feb-02
$1,344,069
535036
13-Sep-02
$1,543,049.00 $771,524.50 $771,524.50
544956
3-0cl-03 22-Mar-04
$4,500,000
$15,000 $15,000
523054 24-0cl-00 528333 15-May-01
$15,000 528541 14-Aug-01
$507,627 529305 25-Sep-01
$537,627 532247
7-Feb-02
$896,046 $448,023 $448,023
535037
25-Sep-02 10-Feb-03
Maralhon Ashland
Maralhon Oil
$1,028,700.00 $514,350 $514,350 $150,000 $50,000
544958
548582 548581
28 Ocl 03 14 Jan 04 20-Jan-04 3-Feb-04
$3,000,000 $215,000
$120,000
$2,045,509
$5,376,273
$5,936,307
$8,317,588.00
$16,715,000
Page 39 of41
&[DATE]
SH ELL-MCCLU RG-OS2240
Benzene Health Research Consortium Sponsor Payment Detail 1Q04 Financial Report
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 LT 5/6/04
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-OS2241
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 LT 5/5/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-OS2242