Document bBB08ee6y5r9RMNq2Ypn9rJak
From: Sullivan, Nancy E SCC-CBAR Sent: Friday, October 17, 2003 8:28 AM To: Tholstrup, Susan C SCC-HSE; Clegg, Patsy M SCC-CHSE-PC Subject: FW: Progress Report on Benzene Health Research Consortium
Fyi- a reminder when pressure is exerted people can find a way to do it with less money! We still need to stay on top of this, though, to make sure they actually do it within budget!
Nancy Sullivan VP Aromatics/Phenol Shell Chemical LP One Shell Plaza, 910 Louisiana, Houston, TX 77002-4916
Tel: +1 713241 3084 Fax: 8540 Email: nancy.sullivan@shell.com Internet: http://www.shell.com/chemicals
-----Original Message----From: Lorraine Twerdok [mailto:Twerdokl@api.org] Sent: Wednesday, October 15, 2003 4:58 PM To: Sullivan, Nancy E SCC-CBAR Subject: FW: Progress Report on Benzene Health Research Consortium
Ms SullivanThis message from Mr. Cavaney was inadvertently sent to the wrong contact at Shell. Please accept my apologies for the confusion.
Also, please do not hesitate to contact me with any questions you may have on the information provided in the email.
Thank you, Lorraine Twerdok
******************************
Lorraine E. Twerdok, PhD., DABT Manager, Health Sciences American Petroleum Institute 1220 L Street, N.W. Washington, DC 20005
tel: 202-682-8344 fax: 202-682-8031 email: twerdokl@api.org <mailto:twerdokl@api.org>
-----Original Message----From: Red Cavaney Sent: Monday, October 13, 2003 12:45 PM To: 'pillarrj@bp.com'; 'mter@chevrontexaco.com'; 'Iee.r. raymond@exxonmobil.com'; 'jim. w.nokes@conocophillips.com'; 'marathonoil.com' Cc: 'Lynn.Elsenhans@shell.com'; 'jjmulva@conocophillips.com'; 'mbitter@chevrontexaco.com'; Red Cavaney; Charles Sandler; Howard Feldman; Harry Ng; Brenda Hargett; Lorraine Twerdok Subject: Progress Report on Benzene Health Research Consortium
I am pleased to attach a Progress Report from the Benzene Health Research Consortium, in which they state their Oversight Committee "has unanimously agreed that a scientifically rigorous, unique research project to further the current understanding of the human health effects of benzene could be executed at this funding level ($20,884,000+$200,000) without sacrificing the integrity of program results."
SH ELL-MCCLU RG-065964
API staff will follow through with converting this commitment to the new contract documentation and appropriate new billings, as well as continue its contract administration and coordination role. An outcome which provides for the continuation of this important research would have not been achievable without the incredible patience and support you have given, and for that I am hugely grateful. .. many thanks...... red cavaney
SH ELL-MCCLU RG-065965
From: Paula Podhasky [Podhaskyp@api.org] Sent: Thursday, January 16,2003 9:55 AM To: Patsy Clegg (E-mail) Subject: BHRC invoice per your request pp
SH ELL-MCCLU RG-065966
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 24 25 26 Notes by API 27 Notes/Assumptions for Dec. 2001 revised budget: 28 29 30 31 32
B
Total Research Costs Total Panel Costs
Miscellaneous Costs Subtotal API Admin.
C
Original Cost Estimate (Jan.
2001) $1,595,000 $13,665,017 $1,253,428
$165,700 $16,679,145
$450,000 $500,000
$1,000,000
D Approved Revised Cost Estimate (Dec.
2001)
$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
$0
$1,690,855
$1,725,000
$18,820,000
$21,704,095
$941,000
$1,085,205
$19,761,000
$22,789,300
UCHSC interest
EF
Unapproved Changes API not
Approved
approved (June 11 NOV 03 OC
2003)
mtg
$2,283,095 $15,258,000
$1,597,273 $661,000
$19,799,368 $551,736 $192,000 $0
$2,283,095 $14,508,000
$1,413,428 $230,000
$18,434,523 $300,000 $64,000 $0
$743,736 $0
$100,576 $960,600 $100,000
$0 $1,161,176
$364,000 $0
$100,000 $550,000 $100,000 ($100,000) $390,272 $1,040,272
$21,704,280 $1,085,019
$22,789,299
$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.
- QAJQC costs are based on an assumption of $45,000 per year
SH ELL-MCCLU RG-065967
From: Lorraine Twerdok [Twerdokl@api.org] Sent: Wednesday, November 12, 2003 11:30 AM To: Benzene OC listserve (E-mail) Subject: BHRC budget 11-10-03.xls
New, approved budget and explanation of API accounting procedures and definitions for API expense categories - as requested.
SH ELL-MCCLU RG-065968
Benzene Health Research Consortium 4Q03 Financial Report Overview
A BC D E F G H
1
2"" NOTE: budgets forward adjusted based on approved $21,084,000 total, per 11Nov2003 OC meeting.
3
4 RESEARCH PROGRESS:
5
~ AML and NHL Epidemiology Study: as of December, 2003 case accrual rates are within predicted range, with 66 NHL and 42 AML cases, for a total of 108 accepted cases (see Case Accrual ta
7 case referral steadily increasing since 3Q04.
8
9
""""iO Disease Progression & Molecular Epidemiology: 90% concordance between Clinical Lab (JCML) case evaluation & secondary pathology review (50% concordance with hospital case referrals).
11
12 Case Accrual: AML, NHL, AA & MDS above 4Q03 projections. No benzene poisoning cases.
13
~
15 Exposure Assessment: DP & ME Exposure Assessment operational; CC exposure recreation team reorganized and further trained to enhance assessment rate & quality.
16
17 External Review Panels: Dr. Rice is actively recruiting a replacement for Dr. Brody, who resigned as ERP Chair 4Q03.
18
19 EXPENSE DISCUSSION:
20
=21 Fund Balance at API 4Q03
$5,143,568
22 23 NEW! 'exec summ' worksheet for the big picture
24
25
26 Overall Budget: program is under budget, using the current budget estimates. Need to revise SRP/ERP projections (see below), and get revised cost estimates for UCHSC and Irons' Field Expen
4 - UCHSC: Unspent amount - $1,472,277. (-$523,807) reduction in expense adjustment made to correct 3Q03 unintentional error of double counting 2001 expenses. A detail sheet has been added 28 subcontractor expenses. API is working to recoup interest earned on unspent grant funds, however, UCHSC is resistant, and no provisions were in original grant.Amendment #2 to be completed 1
29 Technical Budget WG approval, $48,839 attributed to UCHSC in 3Q03 Report has been reallocated to Contingency: $25,000 pre-consortium grant in 2001; $3,600 for IRB Review in 2002; $20,2~
30 Irons Field EXl2enses: current prepaid funds nearly depleted; $27,216 prepaid funds remaing; disbursement requested in 1Q04. +$114,289 additional expense adjustment made to 4Q03 report te
31 AHS: over budget with negative variance of (-$52,477); Dr. Wong states project will end "on budget". 32 Fudan Universit~:{ under budget with positive variance of $81 ,425
33 SRP/ERP: under budget with positive variance of $198,778.
34 Communications (APCO): 'on budget' after adjustments made to reflect budget reduction
35 Outside Legal Council: 'on budget' after adjustments made to reflect budget reduction
36 QAlQC: under budget, no contract in place
37
3a API Administrative Costs: over budget with negative variance of (-$65,484). Overbudget due to unbudgeted Annual meeting expenses and higher than anticipated staff time required for annual M
39 planning, contract/budget reviews and development of detailed financial report format.
40
41 FORWARD GUIDANCE:
42 Review report to determine payment schedule for consortium agreement amendment (what year?)
43
44 Collect Marathon payment. Collect second half of 2003 invoice payment from ExxonMobil and Shell
45
46 Two budget areas are currently over budget, and will require close monitoring:
47 AHS
48 API administrative costs
Page 1 of41
&[DATE]
SH ELL-MCCLU RG-065969
I
1
2""
3 4 5
~ ). Rate of
7 8 9
""""iO
11 12 13
~
15 16 17 18 19 20
21
22 23 24 25
26 es
4- or UCHSC 28 ;)04. With
29 9 for EMBSI
30 correct 31 32 33 34 35 36 37
3a eting
39
40 41 42 43 44 45 46 47 48
J
Benzene Health Research Consortium 4Q03 Financial Report Overview
Page 2 of41
&[DATE]
SH ELL-MCCLU RG-065970
Benzene Health Research Consortium 4Q03 Financial Report Overview
A IBI C I D I E I F I G I H
49
50
51 It is recommended that SRP/ERP budget projections be adjusted to make the report a more useful tool. Currently carrying a large positive variance, with unrealistically low projected budgets.
52
53 Get Fudan University contract in place.
54 55 Get new contract in place for Irons field expenses.
II
I
IIII
56
57 Need revised budget and budget projections for UCHSC grant, Irons Field Expenses and AHS. Need to reconcile UCHSC statement - they have a $105 error.
58 59 Technical Budget Work Group Acceptance: 4/9/04
II
I
IIII
60 Oversight Committee Acceptance:
61 Posted to website:
62 63 LT 4/13/04 64 BJ 4/12/04
II II II
I I I
IIII IIII IIII
Page 3 of41
&[DATE]
SHELL-MCCLURG-065971
I 49
50
51
52 53 54 55 56 57 58 59 60 61 62 63 64
J
Benzene Health Research Consortium 4Q03 Financial Report Overview
Page4of41
&[DATE]
SH ELL-MCCLU RG-065972
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 24 25 26 Notes by API 27 Notes/Assumptions for Dec. 2001 revised budget: 28 29 30 31 32 LT 4/7/04
Benzene Health Research Consortium Approved Program Budget 4Q03 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 API not
F Approved
approved (June 11 NOV 03 OC
2003)
mtg
$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
$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
- 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 5 of41
&[DATE]
SH ELL-MCCLU RG-065973
Benzene Health Research Consortium Executive Summary
4Q03 Financial Report
A
BC
DE
F
G
H
I J K L M N0
1
2
3
Actuals
Budget (actual + projected income & expens
4 Inception
Cumulative
5
Thru
Actuals
Actuals
6 7 Cost Centers
Project #
December 2002
Jan - Dec 2003
Program to Date
Inception Thru 2003
2004
2005
2006
8
9 Income
$ 10,540,824 $ 4,716,451
$ 15,257,275
$ 15,257,275
$ 1,485,875
$ 100,000
10
11
12 Cost Centers
13 UCHSC* 14 Irons-Field Expense**
X8105 X8106
7,564,598 539,486
(48,839)
-
7,515,759 539,486
7,515,759 539,486
1,748,061 222,032
1,748,060 222,032
1,748,060 222,030
15 Applied Health Sciences
X8107
571,734
432,791
1,004,525
1,004,525
393,361
441,867
449,985
16 Fudan University
X8108
15,470
16,511
31,981
31,981
29,151
29,148
29,148
17 Scientific & Ethics Panels X8109
23,795
59,059
82,854
82,854
20,608
20,592
20,592
18 Communications
X8103
240,738
50,128
290,866
290,866
60,001
60,000
60,000
19 Outside Legal Counsel 20 QAJQC Support
X8104 X8110
13,565
-
19,643
-
33,208
-
33,208
-
16,698 25,000
16,698 25,000
16,698 25,000
21 API Administrative 22 Contingency
X8100
265,745
-
300,444 48,839
566,189 48,839
566,189 48,839
311,000
-
144,500 341,433
144,500
-
23
24
Total Expenses
$ 9,235,131 $ 878,576
$ 10,113,707
$ 10,113,707
$ 2,825,912
$ 3,049,330
$ 2,716,013
25
26
Fund Balance
$ 1,305,694 $ 3,837,875
$ 5,143,568
$ 3,803,531
$ 754,201
($1,861,812)
27
28
29 blue is projected fund balanced to project 30 * amount disbursed by API; $1,472,277
** amount disbursed by API; $27,216
31 unspent and in Irons' Field expense bank 32 33 LT 4/14/04
34
35
36
37
38
Page 6 of 41
&[DATE]
SH ELL-MCCLU RG-065974
P QR
S
1
2
3 s)
4
5
6
Total
Total adj.
7
2007
Program
w/variance
8 9$
- $ 16,843,150 $ 16,843,150
10
11
12
13 1,748,060
14,508,000
14,508,000
14 222,028
1,427,608
1,413,428
15
45,833
2,335,571
2,283,094
16 29,148
148,576
230,001
17 20,576
165,222
364,000
18 79,135
550,002
550,000
19 16,698
100,000
100,000
20 25,000
100,000
100,000
21 144,500
22 -
1,310,689 390,272
1,245,205 390,272
23
24 $ 2,330,978
$ 21,035,940 $ 21,184,000
25
26 ($4,192,790)
27
28
29
30
31 Income Detail 32 sponsors 33 MAP seed 34 MAP contrib. 35 UCHSC in!. 36 API interest 37 38 TOTAL
$16,500,000 $15,000
$200,000 $100,000
$28,148
$16,843,148
Benzene Health Research Consortium Executive Summary
4Q03 Financial Report
Page 7 of 41
&[DATE]
SH ELL-MCCLU RG-065975
Benzene Health Research Consortium Case Accrual 4Q03 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 Projected
"U Actual cases
~ ~
""I LT 4/14/04 ,,~ BJ 4/12/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
35 35 35 35 35 35 35 35 35 35 35 35 35 66
12 13 12 13 12 13 12 13 12 13 12 13 12 17
15 15 15 15 15 15 15 15 15 15 15 15 15 26
32 3 2 32 3 2 32 3 2 3 0
U
TOTALS
455 66 0 0
162 17 0 0
195 26 0 0
33 0 0 0
845 109
Page 8 of 41
&[DATE]
SH ELL-MCCLU RG-065976
Benzene Health Research Consortium Cash Flow Statement 4Q03 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 417104
B
2000 1st-4thQtr.
$60,246 $60,246
$24,600 $24,600
$35,646 $35,646
NOTE:
C
2001 1st-4thQtr.
D
2002 1st-4thQtr.
E
1st&2nd Qtr.
$2,113,132 $2,173,378
$8,367,446 $10,540,824
$448,024 $10,988,848
$1,571,301 $1,595,901
$7,639,230 $9,235,131
$310,235 $9,545,366
$541,831 $577,477
$728,216 $1,305,693
$137,789 $1,443,482
$5,143,568 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
$269,464 $10,383,171
$1,216,411 $6,359,978
I
2nd Qtr.
J
2004 3rd Qtr.
$5,000 $16,748,149
$0 $16,748,149
$1,096,995 $11,480,166
$269,463 $11,749,628
($1,091,995) $5,267,984
($269,463) $4,998,521
K
4thQtr.
$0 $16,748,149
$1,096,994 $12,846,622
($1,096,994) $3,901,527
L
1stQtr.
M
2005 2nd Qtr.
N
3rd Qtr.
0
4thQtr.
P
1stQtr.
$0 $16,748,149
$0 $16,748,149
$0 $16,748,149
$0 $16,748,149
$0 $16,748,149
$238,072 $13,084,694
$1,065,620 $14,150,315
$245,588 $14,395,903
$1,065,620 $15,461,523
$240,118 $15,701,641
($238,072) $3,663,455
($1,065,620) $2,597,835
($245,588) $2,352,246
($1,065,620) $1,286,626
($240,118) $1,046,508
Q
2nd Qtr.
2006
R
3rd Qtr.
$100,000 $16,848,149
$0 $16,848,149
$1,067,641 $16,769,282
$247,617 $17,016,898
($967,641) $78,868
($247,617) ($168,749)
90f41
&[DATE]
SH ELL-MCCLU RG-065977
"I ~
2
~
~
14
S
4thQtr.
$0 $16,848,149
$1,067,659 $18,084,557
($1,067,659) ($1,236,408)
T
1stQtr.
$0 $16,848,149
$178,237 $18,262,794
($178,237) ($1,414,645)
U
2nd Qtr.
2007
V
3rd Qtr.
$0 $16,848,149
$0 $16,848,149
$959,946 $19,222,739
$139,889 $19,362,628
($959,946) ($2,374,590)
($139,889) ($2,514,479)
W
4thQtr.
$0 $16,848,149
$959,931 $20,322,559
($959,931) ($3,474,410)
X
TOTALS
$16,848,149
$20,322,559
Benzene Health Research Consortium Cash Flow Statement 4Q03 Financial Report
10of41
&[DATE]
SH ELL-MCCLU RG-065978
Benzene Health Research Consortium Program Expense Summary 4Q03 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
~
CurrentVariance
"+::;l Cumm Variance
::>U API Administrative and Overhead
~ Budgeted
~
Actual expense
;,:)..J CurrentVariance
;,:)"+ Cumm Variance
2000 1st-4thQtr.
~
TOTALS
~
Budgeted
Actual expense
CurrentVariance ::>~ Cumm Variance
~ CUMULATIVE TOTALS
Budgeted
Expense
0,,) Variance
'UUU 2000
0"+ Blue: future cumulative variance has no meaning until Expense entered. ~ LT4/14/04
Amt. At UCHSC & Irons Field ex
24,600 (24,600) (24,600
24,600 (24,600) (24,600)
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
31,303 31,303
42,751 15,470 27,281 58,584
34,560 18,673 15,887 15,887
138,240 5,122
133,118 149,005
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
45,536 (45,536) 70,136
236,000 195,608
40,392 29,745
'UUl 904,978 727,502 177,476 152,876
2001 904,978 752,102 152,876
5,494,704 4,350,292 1,144,412 1,297,288 2002 6,399,682 5,102,394 1,297,288
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
69,120 9,994
59,126 208,131
125,000 14,564
110,436 169,699
62,500 1,728
60,772 197,207
28,126
28,126 95,626
124,500 136,792 (12,292)
42,037
2,015,947 2,116,981
(101,035) 1,196,254
8,415,629 7,219,375 1,196,254
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
34,560 16,984 17,576 225,707
62,500 7,877
54,623 224,322
31,250
31,250 228,457
14,063
14,063 109,689
62,250 74,997 (12,747) 54784
55,508 169,606 (114,098)
13,035
108,128 142,737 (34,609) (52,477)
7,288 1,168 6,120 81,425
5,152 32,081 (26,929) 198,778
(196,636) 27,688
(224,324) (2)
(210,542) 17,915
(228,457)
(109,689)
(109,689)
390,272 48,839
341,433 341,433
77,955 88,655 (10,700) 65,484
392,618 312,479
80,139 1,276,392 2003 8,808,246 7,531,854 1,276,392
$10,113,707 $8,614,215 $1,499,492
2,166,902 1,082,361 1,084,541 2,360,933
10,975,148 8,614,215 2,360,933
H
1stQtr.
1,813,804
55,508 55,508 68,543 98,340 98,340 45,863
7,288 7,288 88,713 5,152 5,152 203,930 15,001 15,001 14,999 4,175 4,175 4,175 6,250 6,250 6,250
2004 2nd Qtr.
874,031 827,532
827,532 2,631,500
55,508
55,508 124,051
98,340
98,340 144,204
7,288
7,288 96,001
5,152
5,152 209,082
15,000
15,000 29,999
4,175
4,175 8,349
6,250
6,250 12,500
341,433
341,433
77,750
77,750
77,750 12,266
269,464
77,750 90,016
'UU4 1,096,995
269,464
1,096,995
2,630,397
3,727,392 2004
11,244,612
12,341,607
8,614,215
8,614,215
2,630,397
3,727,392
$1,472,277 unspent at UCHSC
$27,216 In Irons' field exp bank acct $1,499,493 Total
J
3rd Qtr.
2,631,500
55,508 55,508 179,559 98,340 98,340 242,544
7,288 7,288 103,289 5,152 5,152 214,234 15,000 15,000 44,999 4,175 4,175 12,524 6,250 6,250 18,750
341,433 77,750 77,750
167,766
269,463 269,463 3,996,855 12,611,069 8,614,215 3,996,855
K
4thQtr.
874,030 827,532
827,532 3,449,196
LI MI NI o
2005
1stQtr.
2nd Qtr.
3rd Qtr.
4thQtr.
874,030 827,532
874,030 827,532
3,449,196
827,532 4,266,892
4,266,892
827,532 5,084,588
55,508
55,508 235,067
98,340
98,340 340,884
7,287
7,287 110,576
5,152
5,152 219,386
15,000
15,000 59,999
4,175
4,175 16,698
6,250
6,250 25,000
55,508
55,508 290,575
110,467
110,467 451,351
7,287
7,287 117,863
5,136
5,136 224,522
15,000
15,000 74,999
4,175
4,175 20,873
6,250
6,250 31,250
55,508
55,508 346,083
110,467
110,467 561,818
7,287
7,287 125,150
5,152
5,152 229,674
15,000
15,000 89,999
4,175
4,175 25,047
6,250
6,250 37,500
55,508
55,508 401,591
110,467
110,467 672,284
7,287
7,287 132,437
5,152
5,152 234,826
15,000
15,000 104,999
4,175
4,175 29,222
6,250
6,250 43,750
55,508
55,508 457,099
110,467
110,467 782,751
7,287
7,287 139,724
5,152
5,152 239,978
15,000
15,000 119,999
4,175
4,175 33,396
6,250
6,250 50,000
341,433
77,750
77 750 245,516
1,096,994
1,096,994 5,093,848
13,708,063 8,614,215 5,093,848
341,433
34,250
34,250 279,766
238,072
238,072 5,331,921
13,946,135 8,614,215 5,331,921
341,433
341,433
34,250
41,750
34,250 314,016
IU'
1,065,620
41,750 355,766
245,588
1,065,620
245,588
6,397,541
6,643,129
2005
15,011,756 15,257,344
8,614,215
8,614,215
6,397,541
6,643,129
341,433
34,250
34,250 390,016
1,065,620
1,065,620 7,708,749
16,322,964 8,614,215 7,708,749
p
1stQtr.
5,084,588
55,508 55,508 512,607 112,496 112,496 895,247
7,287 7,287 147,011 5,152 5,152 245,130 15,000 15,000 134,999 4,175 4,175 37,571 6,250 6,250 56,250
341,433 34,250 34,250
424,266
240,118 240,118 7,948,867 16,563,082 8,614,215 7,948,867
Page 11 of41
&[DATE]
SH ELL-MCCLU RG-065979
Benzene Health Research Consortium Program Expense Summary 4Q03 Financial Report
QI RIs
2006
2nd Qtr.
3rd Qtr.
4thQtr.
TI u
v
2007
1stQtr.
2nd Qtr.
3rd Qtr.
Iw
4thQtr.
X
TOTALS
~ 874,030 827,539
a
827,539
a 874,030 a 827,542 aa a 827,542
a 874,030 a 827,542 aa a 827,542
a 874,030 a 827,542 aa a 827,542
~
5,902,284
5,902,284
6,719,980
6,719,980
7,537,676
7,537,676
8,355,372
14,508,000 14,508,000
6,043,482 827,542
8,464,518
1"1 ~ ~
I~ ~
L. L.. ~ ~ L. L.' ~ ~ L. .)U ~ ~
.).)
,)"1 ~ ~
,,~
~ "I "I,
~ ~ "I;) "It ~ ~ "I"
;)U
2
~ ;).0 ;)"1
~ ~
;)~ ~
0"
0"1 ~
55,508
a
55,508
568,115
55,507
a
55,507
623,622
112,496
a
112,496
1,007,744
112,496
a
112,496
1,120,240
7,287
a
7,287
154,298
7,287
a
7,287
161,585
5,136
a
5,136
250,266
5,152
a
5,152
255,418
15,000
a
15,000
149,999
15,000
a
15,000
164,999
4,175
a
4,175
41,745
4,175
a
4,175
45,920
6,250
a
6,250 62,500
a a a
341,433
6,250
a
6,250 68,750
a a a
341,433
34,250
a
41,750
a
34,250 458,516
41,750 500,266
2006
1,067,641
a
247,617
a
1,067,641
247,617
9,016,508
9,264,125
2006
17,630,723 17,878,339
8,614,215
8,614,215
9,016,508
9,264,125
55,507
a
55,507 679,129
112,496
a
112,496 1,232,736
7,287
a
7,287 168,872
5,152
a
5,152 260,570
15,000
a
15,000 179,999
4,175
a
4,175 50,094
6,250
a
6,250 75,000
a a a
341,433
34,250
a
34,250 534,516
55,507.0
a
55,507 734,636
45,833
a
45,833 1,278,569
7,287
a
7,287 176,159
5,152
a
5,152 265,722
19,783
a
19,783 199,782
4,175
a
4,175 54,269
6,250
a
6,250 81,250
a a a
341,433
34,250
a
34,250 568,766
1,067,659
a
1,067,659
10,331,783
178,237
a
178,237
10,510,020
18,945,998 8,614,215
10,331,783
19,124,235 8,614,215
10,510,020
55,507
a
55,507 790,143
a a a
1,278,569
55,507
a
55,507 845,650
a a a
1,278,569
7,287
a
7,287
183,446
7,287
a
7,287
190,733
5,152
a
5,152
270,874
5,136
a
5,136
276,010
19,783
a
19,783
219,566
19,784
a
19,784
239,350
4,175
a
4,175
58,443
4,175
a
4,175
62,618
6,250
a
6,250 87,500
a a a
341,433
6,250
a
6,250 93,750
a a a
341,433
34,250
a
41,750
a
34,250 603,016
41,750 644,766
2007
959,946
a
139,889
a
959,946
139,889
11,469,966
11,609,854
2007
20,084,180
20,224,069
8,614,215
8,614,215
11,469,966
11,609,854
55,507
a
55,507 901,157
a a a
1,278,569
7,287
a
7,287 198,020
5,136
a
5,136 281,146
19,784
a
19,784 259,134
4,175
a
4,175 66,792
6,250
a
6,250 100,000
a a a
341,433
34,250
a
34,250 679,016
959,931
a
959,931 12,569,785
21,184,000 8,614,215
12,569,785
1,413,428 512,270 679,129 901,157
2,283,095 1,004,526
a
1,278,569
230,000 31,981 7,287
198,020
364,000 82,854 5,136
281,146
550,000 290,866 259,134 259,134
100,000 33,208 66,792 66,792
100,000
a
100,000 100,000
390,272 48,839
a
341,433
1,245,205 541,589 679,016 703,616
21,184,000 8,614,215
12,569,785 12,569,785
21,184,000 8,614,215
12,569,785
Page 12 of41
&[DATE]
SH ELL-MCCLU RG-065980
Benzene Health Research Consortium UCHSC Grant 4Q03 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
"+..J Variance
TOTALS
~ Blue: future cumulative variance has no meaning until Expense entered.
~ LT4/14/04 "+t1 BJ 419104
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 13 of41
&[DATE]
SH ELL-MCCLU RG-065981
Benzene Health Research Consortium UCHSC Grant 4Q03 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 14 of41
&[DATE]
SH ELL-MCCLU RG-065982
Benzene Health Research Consortium UCHSC Grant 4Q03 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 15 of41
&[DATE]
SH ELL-MCCLU RG-065983
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 417103
Benzene Health Research Consortium UCHSC Subcontract 4Q03 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 16 of 41
&[DATE]
SH ELL-MCCLU RG-065984
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 4Q03 Financial Report
Page 17 of 41
&[DATE]
SH ELL-MCCLU RG-065985
Benzene Health Research Consortium Irons Field Expenses 4Q03 Financial Report
A
IRONS Field Expenses
Cost Centers Payments "I Disbursed
2 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
,::I~ CurrentVariance Cumm Variance
L'
-. Budgeted Actual expense L CurrentVariance L"I Cumm Variance ~ CUMULATIVE TOTALS
~ Budgeted L Expense L, Variance
ri& Blue: future cumulative variance has no meaning until Expense entered.
~ ~ ,).0
.0"1 LT 4/14/04 ~
~
~ ~ "I
B
2001 4thQtr.
C
2002 1st-4thQtr.
D
1st&2nd 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
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
"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 $512,270
$27,216
E
3rd Qtr.
2003
F
4thQtr.
$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
$69,179 $54,382 $14,797 $127,133
$469,798 $342,665 $127,133
2003 4Q03 ADJUSTMENT - 200112002 expense underrecorded; +$114,289 adjustment
$0 $22,200 $74,850 ($52,650)
$6,046 $22,205 $81,131 ($58,926) ($28,239) $11,103 $13,625 ($2,522) $76,735
$55,508 $169,606 ($114,098)
$13,035 $525,306 $512,270
$13,035
0
Page 18 of41
&[DATE]
SH ELL-MCCLU RG-065986
Benzene Health Research Consortium Irons Field Expenses 4Q03 Financial Report
"I
2
~
~ ~
~ ~
~,::I
L'
-.
L L"I ~ ~ L L, L
.)U
~ ~ ,).0
,)"1 ~ ~
G
1stQtr.
$0
$22,200 $0
$22,200 $28,246
$22,205 $0
$22,205 ($6,034)
$11,103 $0
$11,103 $87,838
$55,508 $0
$55,508 $68,543
$580,814 $512,270
$68,543
HI
2004
2nd Qtr.
3rd Qtr.
$0 $0
$22,200 $0
$22,200 $50,446
$22,205 $0
$22,205 $16,171
$11,103 $0
$11,103 $98941
$22,200 $0
$22,200 $72,646
$22,205 $0
$22,205 $38,376
$11,103 $0
$11,103 $110,044
$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 $121147
$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 $132250
$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 $143,353
$22,200 $0
$22,200 $161,446
$22,205 $0
$22,205 $127,196
$11,103 $0
$11,103 $154456
$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 $165559
$0
$22,200 $0
$22,200 $205,846
$22,205 $0
$22,205 $171,606
$11,103 $0
$11,103 $176662
$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 $187765
$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 $2: 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 $254,377
$55,507 $0
$55,507 $901,157
$1,413,428 $512,270 $901,157
~ ~
"I
W
TOTALS
$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
Page 19 of41
&[DATE]
SH ELL-MCCLU RG-065987
Benzene Health Research Consortium AHS 4Q03 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
Blue: future cumulative variance has no meanin until Ex ense entered.
B
2001 4thQtr.
C
2002 1st-4thQtr.
D
1st&2nd Qtr.
E
2003 3rd Qtr.
F
4thQtr.
G
1stQtr.
HI
2004
2nd Qtr.
3rd Qtr.
J
4thQtr.
$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 $126,324 ($47,446) ($226,818)
$72,090 $0
$72,090 ($154,728)
$72,090 $0
$72,090 ($82,638)
$72,090 $0
$72,090 ($10,547)
$72,090 $0
$72,090 $61,543
$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
$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
2003 $108,128 $149,389 ($41,261) ($17,868) 2003 $843,921 $861,789 ($17,868)
$750 $0
$750 $6980
$108,128 $142,737 ($34,609) ($52,477)
$952,049 $1,004,526
($52,477)
$750 $0
$750 $7730
$98,340 $0
$98,340 $45,863
$1,050,389 $1,004,526
$45,863
$750 $0
$750 $8480
$750 $0
$750 $9230
DO
$98,340
$98,340
$0 $0
$98,340
$98,340
$144,204
$242,544
2004
$1,148,730 $1,247,070
$1,004,526 $1,004,526
$144,204
$242,544
$750 $0
$750 $9980
$98,340 $0
$98,340 $340,884
$1,345,410 $1,004,526
$340,884
K
1stQtr.
$84,217 $0
$84,217 $145,760
$25,500 $0
$25,500 $294,861
$750 $0
$750 $10730
$110,467 $0
$110,467 $451,351
$1,455,877 $1,004,526
$451,351
LM
2005
2nd Qtr.
3rd Qtr.
$84,217 $0
$84,217 $229,977
$84,217 $0
$84,217 $314,193
$25,500 $0
$25,500 $320,361
$25,500 $0
$25,500 $345,861
$750 $0
$750 $11480
$750 $0
$750 $12230
05
$110,467
$110,467
$0 $0
$110,467
$110,467
$561,818
$672,284
2005
$1,566,344 $1,676,810
$1,004,526 $1,004,526
$561,818
$672,284
N
4thQtr.
$84,217 $0
$84,217 $398,410
$25,500 $0
$25,500 $371,361
$750 $0
$750 $12980
$110,467 $0
$110,467 $782,751
$1,787,277 $1,004,526
$782,751
0
1stQtr.
$76,746 $0
$76,746 $475,156
$35,000 $0
$35,000 $406,361
$750 $0
$750 $13730
$112,496 $0
$112,496 $895,247
$1,899,773 $1,004,526
$895,247
PQ
2006
2nd Qtr.
3rd Qtr.
$76,746 $0
$76,746 $551,903
$76,746 $0
$76,746 $628,649
$35,000 $0
$35,000 $441,361
$35,000 $0
$35,000 $476,361
$750
$750
$0 $750 $14480
$0 $750 $15230
10.
$112,496
$112,496
$0 $0
$112,496
$112,496
$1,007,744 $1,120,240
2006
$2,012,270 $2,124,766
$1,004,526 $1,004,526
$1,007,744 $1,120,240
R
4thQtr.
$76,746 $0
$76,746 $705,395
$35,000 $0
$35,000 $511,361
$750 $0
$750 $15,980
$112,496 $0
$112,496 $1,232,736
$2,237,262 $1,004,526 $1,232,736
Page 20 of41
&[DATE]
SH ELL-MCCLU RG-065988
"I
.2
~
~ ~
~ ~
~
L'
-.
L L"I ~
'<0
S
1stQtr.
$10,033 $0
$10,033 $715,428
$32,000 $0
$32,000 $543,361
$3,800 $0
$3,800 $19,780
$45,833 $0
$45,833 $1,278,569
$2,283,095 $1,004,526 $1,278,569
T
2nd Qtr.
2007
U
3rd Qtr.
$0 $0 $0 $715,428
$0 $0 $0 $715,428
$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,278,569 $1,278,569
2007
$2,283,095
$2,283,095
$1,004,526
$1,004,526
$1,278,569 $1,278,569
V
4thQtr.
$0 $0 $0 $715,428
$0 $0 $0 $543,361
$0 $0 $0 $19,780
$0 $0 $0 $1,278,569
$2,283,095 $1,004,526 $1,278,569
W
TOTALS
$1,631,795 $916,367 $0 $715,428
$630,000 $86,639 $0
$543,361
$21,300 $1,520 $0
$19,780
$2,283,095 $1,004,526
$0 $1,278,569
$2,283,095 $1,004,526 $1,278,569
Benzene Health Research Consortium AHS 4Q03 Financial Report
Page 21 of41
&[DATE]
SH ELL-MCCLU RG-065989
Benzene Health Research Consortium Fudan 4Q03 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 meanin until Ex ense entered.
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 $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: bud et 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 22 of41
&[DATE]
SH ELL-MCCLU RG-065990
"I
2
~
J:L
~ IL ~ ~
~ LI
-.
L"I ~ '<0
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 4Q03 Financial Report
Page 23 of41
&[DATE]
SHELL-MCCLURG-065991
Albertini
~
Budgeted
Actual expense
CurrentVanance
CummVanance
~ Brody (paid from OB5200 X1503)
~ Budgeted
Actual expense
CurrentVanance
I L Cumm Vanance
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
~ Mueller (resigned)
::>"+ Budgeted
::>:: Actual expense
~
CurrentVanance
~
::>C Rice ::>t1
~
Cumm Vanance
Budgeted Actual expense
~ CurrentVanance
CummVanance
0': Rockette
~
Budgeted
~
01:
Actual expense CurrentVanance
CummVanance
A
SRP+ ERP Cost Centers
~
Budgeted
Actual expense
CurrentVanance
, L Cumm Vanance
SRP Vacancy #1
'" Budgeted Actual expense
CurrentVanance
CummVanance
SRP Vacancy #2
Budgeted
Actual expense
CurrentVanance OL. CummVanance
O~ TOTALS
Budgeted
Actual expense
oc CurrentVanance
CummulatlveVanance
CUMULATIVE TOTALS
Budgeted
Expense Vanance
Note SRP & ERP combined $364K budgeted equally per contract ($22,750) and per qtr ($322)
B
2001 4thOtr
c
2002 1st-4thOtr
DIE
2003
1st&2ndOtr
3rdOtr
Benzene Health Research Consortium SRP + ERP 4Q03 Financial Report
F
4thOtr
G
1stOtr
HI
2004
2ndOtr
3rdOtr
IJ
4thOtr
K
1stOtr
LIM I N
2005
2ndOtr
3rdOtr
4thOtr
o
1stOtr
PIQ
2006
2ndOtr
3rdOtr
IR
4thOtr
s
1stOtr
T
2ndOtr
$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
$322 $0
$322 $13,395
$322 $0
$322 $13,717
$322 $0
$322 $14,039
$322 $0
$322 $14,361
$321 $0
$321 $14,682
$322 $0
$322 $15,004
$322 $0
$322 $15,326
$322 $0
$322 $15,648
$322 $0
$322 $15,970
$321 $0
$321 $16,291
$322 $0
$322 $16,61:
$322 $0
$322 $16,935
$322 $0
$322 $17,257
$322 $0
$322 $17,579
$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
$322 $0
$322 $17,924
$322 $0
$322 $18,246
$322 $0
$322 $18,568
$322 $0
$322 $18,890
$321 $0
$321 $19,21
$322 $0
$322 $19,533
$322 $0
$322 $19,855
$322 $0
$322 $20,177
$322 $0
$322 $20,499
$321 $0
$321 $20,820
$322 $0
$322 $21,142
$322 $0
$322 $21,464
$322 $0
$322 $21,786
$322 $0
$322 $22,108
$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) 813,858
$322 $0
$322 $14,180
$322 $0
$322 $14,502
$322 $0
$322 $14,824
$322 $0
$322 $15,146
$322 $0
$322 $15,468
$321 $0
$321 $15,789
$322 $0
$322 $11
$322 $0
$322 $16,433
$322 $0
$322 $16,755
$322 $0
$322 $17,077
$321 $0
$321 $17,398
$322 $0
$322 $17,720
$322 $0
$322 $18,042
$322 $0
$322 $18,364
$322 $0
$322 $18,686
$2,160 $0
$2,160 $2,160
$8,640 $2,122 $651' $8,678
$4,320 $0
$4,320 $12,998
$2,160 $0
$2,160 $15,158
$322 $0
$322 $15,480
$322 $0
$322 $15,802
$322 $0
$322 $16,124
$322 $0
$322 $16,446
$322 $0
$322 $16,768
$321 $0
$321 $17,089
$322 $0
$322 $17,411
$322 $0
$322 $17,733
$322 $0
$322 $18,055
$322 $0
$322 $18,377
$321 $0
$321 $18,698
$322 $0
$322 $19,020
$322 $0
$322 $19,342
$322 $0
$322 $19,664
$322 $0
$322 $19,986
$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
$322 $0
$322 $10,590
$322 $0
$322 $10,912
$322 $0
$322 $11,234
$322 $0
$322 $11,556
$321 $0
$321 $11,877
$322 $0
$322 $12,199
$322 $0
$322 $12,521
$322 $0
$322 $12,843
$322 $0
$322 $13,165
$321 $0
$321 $13,486
$322 $0
$322 $13,808
$322 $0
$322 $14,130
$322 $0
$322 $14,452
$322 $0
$322 $14,774
$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
$322 $0
$322 $11,470
$322 $0
$322 $11,792
$322 $0
$322 $12,114
$322 $0
$322 $12,436
$321 $0
$321 $12,757
$322 $0
$322 $13,079
$322 $0
$322 $13,401
$322 $0
$322 $13,723
$322 $0
$322 $14,045
$321 $0
$321 $14,366
$322 $0
$322 $14,688
$322 $0
$322 $15,010
$322 $0
$322 $15,332
$322 $0
$322 $15,654
$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
$322 $0
$322 $13,400
$322 $0
$322 $13,722
$322 $0
$322 $14,044
$322 $0
$322 $14,366
$321 $0
$321 $14,687
$322 $0
$322 $15,009
$322 $0
$322 5.33
$322 $0
$322 115653
$322 $0
$322 $15,975
$321 $0
$321 $16,296
$322 $0
$322 116.618
$322 $0
$322 $16,940
$322 $0
$322 $17,262
$322 $0
$322 $17,584
$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
$322 $0
$322 $13,161
$322 $0
$322 $13,483
$322 $0
$322 $13,805
$322 $0
$322 $14,127
$321 $0
$321 $14,448
$322 $0
$322 $14,770
$322 $0
$322 $15,092
$322 $0
$322 $15,414
$322 $0
$322 $15,736
$321 $0
$321 $16,057
$322 $0
$322 $16,379
$322 $0
$322 $16,701
$322 $0
$322 $17,023
$322 $0
$322 $17,345
$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)
$322 $0
$322 ($4,966)
$322 $0
$322 ($4,644)
$322 $0
$322 ($4,322)
$322 $0
$322 ($4,000)
$321 $0
$321 ($3,679)
$322 $0
$322 ($3,357)
$322 $0
$322 ($3,035)
$322 $0
$322 ($2,713)
$322 $0
$322 ($2,391)
$321 $0
$321 ($2,070)
$322 $0
$322 ($1,748)
$322 $0
$322 ($1,426)
$322 $0
$322 ($1,104)
$322 $0
$322 ($782)
$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
$322 $0
$322 $16,924
$322 $0
$322 $17,246
$322 $0
$322 $17,568
$322 $0
$322 $17890
$321 $0
$321 $1821
$322 $0
$322 $18533
$322 $0
$322 $18855
$322 $0
$322 $19,177
$322 $0
$322 $19,499
$321 $0
$321 $19,820
$322 $0
$322 $20,142
$322 $0
$322 $20,464
$322
$322 $20,786
$322 $0
$322 $21,108
$2,160 $1,250
$910 $910
$8,640 $0
$8,640 $9,550
$4,320 $0
$4,320 $13,870
$2,160 $0
$2,160 $16,030
$322 $0
$322 $16,352
$322 $0
$322 $16,674
$322 $0
$322 $16,996
$322 $0
$322 $17,318
$322 $0
$322 $17,640
$321 $0
$321 $17,961
$322 $0
$322 $18,283
$322 $0
$322 $18,605
$322 $0
$322 $18,927
$322 $0
$322 $19,249
$321 $0
$321 $19,570
$322 $0
$322 $19,892
$322 $0
$322 $20,214
$322
$322 $20,536
$322 $0
$322 $20,858
$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
$322 $0
$322 $6,232
$322 $0
$322 $6,554
$322 $0
$322 $6,876
$322 $0
$322 $7,198
$321 $0
$321 $7,519
$322 $0
$322 $7,841
$322 $0
$322 $816
$322 $0
$322 $8,485
$322 $0
$322 $8,807
$321 $0
$321 $9,128
$322 $0
$322 $9,450
$322 $0
$322 $9,772
$322 $0
$322 $10,094
$322 $0
$322 $10,416
$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
$322 $0
$322 $15,254
$322 $0
$322 $15,576
$322 $0
$322 $15,898
$322 $0
$322 $16,220
$321 $0
$321 $16,541
$322 $0
$322 $16,863
$322 $0
$322 $17,185
$322 $0
$322 $17,507
$322 $0
$322 $17,829
$321 $0
$321 $18,150
$322 $0
$322 $18,472
$322 $0
$322 $18,794
$322 $0
$322 $19,
$322 $0
$322 $19,438
$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
$322 $0
$322 $7,720
$322 $0
$322 $8,042
$322 $0
$322 $8,364
$322 $0
$322 $8,686
$321 $0
$321 $9,007
$322 $0
$322 $9,329
$322 $0
$322 $9651
$322 $0
$322 $9,973
$322 $0
$322 $10,295
$321 $0
$321 $10,616
$322 $0
$322 $10,938
$322 $0
$322 $11,260
$322 $0
$322 $11,582
$322 $0
$322 $11,904
$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
$322 $0
$322 $17,924
$322 $0
$322 $18,246
$322 $0
$322 $18,568
$322 $0
$322 $18,890
$321 $0
$321 819,
$322 $0
$322 $1!533
$322 $0
$322 $19,855
$322 $0
$322 $20,177
$322 $0
$322 $20,499
$321 $0
$321 $20,820
$322 $0
$322 $21,142
$322 $0
$322 $21,464
$322 $0
$322 $21,786
$322 $0
$322 $22,108
$2,160 $0
$2,160 $2160
2001 $34,560 $18,673 $15,887 $15,887 2001 $34,560 $18,673 $15,887
$8,640 $0
$8,640 $10,800
2002 $138,240
$5,122 $133 $149,005 2002 $172,800
$23,795 $149,005
$4,320 $0
$4,320 $15,120
$69,120 $9,994
$59,126 $208,131
$241,920
$2,160 $0
$2,160 $17,280
2003 $34,560 $16,984 $17,576
$225,707 2003 $276,480
$208,131
$225,707
$322 $0
$322 $17,602
$322 $0
$322 $17,924
$5,152 $32,081 ($26,929) $198,778
$281,632
$198,778
$5,152 $0
$5,152 $203,930
$286,784
$203,930
$322 $0
$322 $18,246
$322 $0
$322 18,568
2004
$5,152
$5,152
$0 $0
$5,152
$5,152
$209,082
$214,234
2004
$291,936
$297,088
$209,082
$214,234
$322 $0
$322 $18,890
$5,152 $0
$5,152 $219,386
$302,240
$219,386
$321 $0
$321 819.
$5,136 $0
$5,136 $224,522
$307,376
$224,522
$322 $0
$322 $" 533
$322 $0
$322 119855
2005 $5,152
$0 $5,152 $229,674
2005 $312,528
$5,152 $0
$5,152 $234,826
$317,680
$229,674
$234,826
$322 $0
$322 $20,177
$5,152 $0
$5,152 $239,978
$322,832
$239,978
$322 $0
$322 $20,499
$5,152 $0
$5,152 $245,130
$327,984
$245,130
$321 $0
$321 $20,820
$322 $0
$322 $21,142
2006
$5136
$5152
$0 $0
$5,136
$5,152
$250,266
$255,418
2006
$333,120
$338,272
$250,266
$255,418
$322 $0
$322 $21,464
$5,152 $0
$5,152 $260,570
$343,424
$260,570
$322 $0
$322 $21,786
$322 $0
$322 $22,108
$5,152 $0
$5,152 $265,722
$5,152 $0
$5,152 $270,874
$348,576
$353,728
$265,722
$270,874
0'" 'Tel
SH ELL-MCCLU RG-065992
UIV
3rdOtr
4thOtr
~
~
-"'-
IL
$321 $0
$321 $17,900
$321 $0
$321 $22,429
$321 $0
$321 $18,221
$321 $0
$321 $22,750
I'! ~
$321 $0
$321 $19,007
$321 $0
$321 $19,328
1::1
...\L
L.
$321 $0
$321 $20,307
$321 $0
$321 $20,628
~
L.
~ ~
.)~
jL ~
,)'1
.)~
~ ~
.)C ,)::1 ~
~'I,
'1~
~ ~
'Ie 'I,
~ ~
,,~
)L ~
"'I
,,~
~ ~
"C ,,::I ~ ~
o~
~ ~
oe
~ ~
'L
$321 $0
$321 $15,095
$321 $0
$321 $15,975
$321 $0
$321 $17,905
$321 $0
$321 $17,666
$321 $0
$321 ($461)
$321 $0
$321 $21,429
$321 $0
$321 $21,179
$321 $0
$321 $10,737
$321 $0
$321 $19,759
$321 $0
$321 $12,225
$321 $0
$321 $15,416
$321 $0
$321 $16,296
$321 $0
$321 $18,226
$321 $0
$321 $17,987
$321 $0
$321 ($140)
$321 $0
$321 $21,750
$321 $0
$321 $21,500
$321 $0
$321 $11,058
$321 $0
$321 $20,080
$321 $0
$321 $12,546
''I $321
$0
~
$321
$22,429
$321 $0
$321 $22,750
,::I
~ ~ OL.
$321 $0
$321 $22,429
o~ 7
~ ~
oe
$5136 $0
$5136
$276,010
~7
~
$358,864
::I~ $82,854
$276,010
$321 $0
$321 $22,750
$5136 $0
$5136 $281,146
$364,000 $82,854
$281,146
W
TOTALS
$22,750 $4,529 $321
$18,221
$22,750 $0
$321 $22,750
$22,750 $3,422 $321
$19,328
$22,750 $2,122 $321
$20,628
$22,750 $7,334 $321
$15,416
$22,750 $6,454 $321
$16,296
$22,750 $4,524 $321
$18,226
$22,750 $4,763 $321
$17,987
$22,750 $22,890
$321 ($140)
$22,750 $1,000 $321
$21,750
$22,750 $1,250 $321
$21,500
$22,750 $11,692
$321 $11,058
$22,750 $2,670 $321
$20,080
$22,750 $10,204
$321 $12,546
$22,750 $0
$321 $22,750
$22,750 $0
$321 $22,750
$364,000 $82,854 $5,136
$281,146
$364,000 $82,854
$281,146
Benzene Health Research Consortium SRP + ERP 4Q03 Financial Report
Page 25 of41
&[DATE]
SH ELL-MCCLU RG-065993
A
Blue fulure cumulallvevanance has no meaning unlll Expense enlered
Benzene Health Research Consortium SRP + ERP 4Q03 Financial Report
Page 26 of41
&[DATE]
SH ELL-MCCLU RG-065994
Benzene Health Research Consortium Communications 4Q03 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
Ist- 4th OtL Ist- 4th OtL 1st & 2nd OtL
E
2003 3rd OtL
F
4th OtL"
G
IstOtL
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
IstOtL
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. "I~ "- Budqet ad'ustment reflects bud et reduction from $1 MM to $550k
$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 27 of41
&[DATE]
SH ELL-MCCLU RG-065995
Benzene Health Research Consortium Communications 4Q03 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,
~
"I~
$0.00 $0.00 $0.00 $0.00
$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 28 of41
&[DATE]
SH ELL-MCCLU RG-065996
Benzene Health Research Consortium Legal 4Q03 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 417104
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.
J
4thQtr.
($210,542) $17,915
($228,457) $0
$4,175 $0
$4,175 $4175
$4,175 $0
$4,175 $8,349
$4,175 $0
$4,175 $12,524
$4,175 $0
$4,175 $16,698
$33,208 $33,208
$0
$37,383 $33,208
$4,175
$41,557 $33,208
$8,349
$45,732 $33,208 $12,524
$49,906 $33,208 $16,698
K
1stQtr.
LM
2005
2nd Qtr.
3rd Qtr.
N
4thQtr.
$4,175 $0
$4,175 $20,873
$4,175 $0
$4,175 $25,047
$4,175 $0
$4,175 $29,222
$4,175 $0
$4,175 $33,396
$54,081 $33,208 $20,873
$58,255 $33,208 $25,047
$62,430 $33,208 $29,222
$66,604 $33,208 $33,396
0
1stQtr.
PQ
2006
2nd Qtr.
3rd Qtr.
R
4thQtr.
$4,175 $0
$4,175 $37571
$4,175 $0
$4,175 $41745
$4,175 $0
$4,175 $45,920
$4,175 $0
$4,175 $50,094
$70,779 $33,208 $37,571
$74,953 $33,208 $41,745
$79,128 $33,208 $45,920
$83,302 $33,208 $50,094
S
1stQtr.
TU
2007
2nd Qtr.
3rd Qtr.
$4,175 $0
$4,175 $54,269
$4,175 $0
$4,175 $58,443
$4,175 $0
$4,175 $62,618
$87,477 $33,208 $54,269
$91,651 $33,208 $58,443
$95,826 $33,208 $62,618
V
4thQtr.
$4,175 $0
$4,175 $66792
$100,000 $33,208 $66,792
Page 29 of41
&[DATE]
SH ELL-MCCLU RG-065997
L 4
;)
ts
12
IT
W
TOTALS
$100,000 $33,208 $66,792 $66,792
$100,000 $33,208 $66,792
14
Benzene Health Research Consortium Legal 4Q03 Financial Report
Page 30 of41
&[DATE]
SH ELL-MCCLU RG-065998
Benzene Health Research Consortium QA-QC 4Q03 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 417/04
Page 31 of41
&[DATE]
SH ELL-MCCLU RG-065999
~ ~ "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 4Q03 Financial Report
Page 32 of41
&[DATE]
SH ELL-MCCLU RG-066000
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 4/14/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 4Q03 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
IstOtL
MN
2005 2nd OtL 3rd OtL
0
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 $0
$27,250 ($12,520)
$27,250 $0
$27,250 $14,730
$27,250 $0
$27,250 $41,980
$27,250 $0
$27,250 $69,230
$15,000 $0
$15,000 $84,230
$15,000 $0
$15,000 $99,230
$15,000 $0
$15,000 $114,230
$15,000 $0
$15,000 $129,230
$15,000 $0
$15,000 $144,230
$0 $774 ($774) ($774)
$0 $2,329 ($2,329) ($3,103)
$10,900 $ $11,209
($309) ($3,412)
5,500 $ 2,750 $ 2,750
$7,162
$4,027
$4,100
($1,662) ($1,277) ($1,350)
($5,074) ($6,351) ($7,701)
$3,250 $0
$3,250 ($4,451)
$3,250 $0
$3,250 ($1,201)
$3,250 $0
$3,250 $2,049
$3,250 $0
$3,250 $5,299
$1,500 $0
$1,500 $6,799
$1,500 $0
$1,500 $8,299
$1,500 $0
$1,500 $9,799
$1,500 $0
$1,500 $11,299
$1,500 $0
$1,500 $12,799
$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 $0
$1,250 $68,909
$1,250 $0
$1,250 $70,159
$1,250 $0
$1,250 $71,409
$1,250 $0
$1,250 $72,659
$1,000 $0
$1,000 $73,659
$1,000 $0
$1,000 $74,659
$5,000 $0
$5,000 $79,659
$1,000 $0
$1,000 $80,659
$1,000 $0
$1,000 $81,659
$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 $0
$6,000 ($3,090)
$6,000 $0
$6,000 $2,910
$6,000 $0
$6,000 $8,910
$6,000 $0
$6,000 $14,910
$1,500 $0
$1,500 $16,410
$1,500 $0
$1,500 $17,910
$5,000 $0
$5,000 $22,910
$1,500 $0
$1,500 $24,410
$1,500 $0
$1,500 $25,910
$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 $ 6,250
$16,043
$9,021
$9,185
($3,543) ($2,771) ($2,935)
($20,592) ($23,363) ($26,298)
$7,500 $0
$7,500 ($18,798)
$7,500 $0
$7,500 ($11,298)
$7,500 $0
$7,500 ($3,798)
$7,500 $0
$7,500 $3,702
$4,000 $0
$4,000 $7,702
$4,000 $0
$4,000 $11,702
$4,000 $0
$4,000 $15,702
$4,000 $0
$4,000 $19,702
$4,000 $0
$4,000 $23,702
$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 $0
$28,000 $5,998
$28,000 $0
$28,000 $33,998
$28,000 $0
$28,000 $61,998
$28,000 $0
$28,000 $89,998
$10,000 $0
$10,000 $99,998
$10,000 $0
$10,000 $109,998
$10,000 $0
$10,000 $119,998
$10,000 $0
$10,000 $129,998
$10,000 $0
$10,000 $139,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
$124,500 $136,792 ($12,292)
$42,037
$360,500 $402,537 ($42,037)
$ 5,750 $8,499 ($2,749)
$16981
2003 $62,250 $74,997 ($12,747) $54,784
2003 $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 $0
$4,500 $1519
$77,750 $0
$77,750 $12,266
$578,455 $566,189
$12,266
$4,500
$4,500
$0 $0
$4,500
$4,500
$6019 $10519
2( J4
$77,750 $77,750
$0 $0
$77,750 $77,750
$90,016 $167,766
2004
$656,205 $733,955
$566,189 $566,189
$90,016 $167,766
$4,500 $0
$4,500 $15019
$77,750 $0
$77,750 $245,516
$811,705 $566,189 $245,516
$1,250 $0
$1,250 $16269
$34,250 $0
$34,250 $279,766
$845,955 $566,189 $279,766
$1,250
$1,250
$0 $0
$1,250
$1,250
$17519 $18769
2('05
$34,250 $41,750
$0 $0
$34,250 $41,750
$314,016 $355,766
2005
$880,205 $921,955
$566,189 $566,189
$314,016 $355,766
$1,250 $0
$1,250 $20019
$34,250 $0
$34,250 $390,016
$956,205 $566,189 $390,016
$1,250 $0
$1,250 $21 269
$34,250 $0
$34,250 $424,266
$990,455 $566,189 $424,266
Page 33 of41
&[DATE]
SHELL-MCCLURG-066001
Benzene Health Research Consortium API Administration 4Q03 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
$159,230 ~ ~ $1,500
$0
$1,500 ~ $14,299 ~ 1"1 $1,000 10 $0 ~ $1,000
$82,659
$15,000 $0
$15,000 $174,230
$1,500 $0
$1,500 $15,799
$5,000 $0
$5,000 $87,659
$15,000 $0
$15,000 $189,230
$1,500 $0
$1,500 $17,299
$1,000 $0
$1,000 $88,659
$15,000 $0
$15,000 $204,230
$1,500 $0
$1,500 $18,799
$1,000 $0
$1,000 $89,659
$15,000 $0
$15,000 $219,230
$1,500 $0
$1,500 $20,299
$1,000 $0
$1,000 $90,659
$15,000 $0
$15,000 $234,230
$1,500 $0
$1,500 $21,799
$5,000 $0
$5,000 $95,659
$15,000 $0
$15,000 $249,230
$1,500 $0
$1,500 $23,299
$1,000 $0
$1,000 $96,659
I~ ~
-.
L.
L ~ ~ L' l. ~ ~
.,)u
;j'
~ ~
,,)"1
;jo
~ .",
;jts
;j~
~ ~ "IL
4;j
~ ~ "It
"I,
~ ~
:>u
$1,500 $0
$1,500 $27,410
$5,000 $0
$5,000 $32,410
$4,000 $0
$4,000 $27,702
$4,000 $0
$4,000 $31,702
$10,000 $0
$10,000 $149,998
$10,000 $0
$10,000 $159,998
$1,250
$1,250
$0 $0
$1,250
$1,250
$22,519
$23,769
2006
$34,250
$41,750
$0 $0
$34,250
$41,750
$458,516 $500,266
2006
$1,024,705 $1,066,455
$566,189 $566,189
$458,516 $500,266
$1,500 $0
$1,500 $33,910
$4,000 $0
$4,000 $35,702
$10,000 $0
$10,000 $169,998
$1,250 $0
$1,250 $25,019
$34,250 $0
$34,250 $534,516
$1,100,705 $566,189 $534,516
$1,500 $0
$1,500 $35,410
$4,000 $0
$4,000 $39,702
$10,000 $0
$10,000 $179,998
$1,250 $0
$1,250 $26,269
$34,250 $0
$34,250 $568,766
$1,134,955 $566,189 $568,766
$1,500 $0
$1,500 $36,910
$5,000 $0
$5,000 $41,910
$4,000 $0
$4,000 $43,702
$4,000 $0
$4,000 $47,702
$10,000 $0
$10,000 $189,998
$10,000 $0
$10,000 $199,998
$1,250
$1,250
$0 $0
$1,250
$1,250
$27,519 $28,769
2007
$34,250 $41,750
$0 $0
$34,250 $41,750
$603,016 $644,766
2007
$1,169,205 $1,210,955
$566,189 $566,189
$603,016 $644,766
$1,500 $0
$1,500 $43,410
$4,000 $0
$4,000 $51,702
$10,000 $0
$10,000 $209,998
$1,250 $0
$1,250 $30,019
$34,250 $0
$34,250 $679,016
$1,245,205 $566,189 $679,016
~
X
TOTALS
$403,700 $230,732 $198,269 $172,968
$52,900 $28,827 $24,073 $24,073
$109,000 $11,999 $97,001 $97,001
$88,505 $43,422 $45,083 $45,083
$121,500 $64,046 $57,454 $57,454
$353,600 $143,602 $209,998 $209,998
$56,000 $18,961 $37,039 $37,039
$1,245,205 $541,589 $703,616 $703,616
$1,245,205 $566,189 $679,016
Page 34 of41
&[DATE]
SH ELL-MCCLU RG-066002
A
~
Continaencv Funds "I
Budgeted
Actual expense CurrentVariance Cumm Variance
Reallocations from UCHSC Budgeted
Actual expense CurrentVariance U Cumm Variance
L<L
~ 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~
~
.2
LT 4/7/04
o;j
04
Benzene Health Research Consortium Contingency Fund 4Q03 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
2003 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 2003 $0.00 $0.00 $0.00 $0.00 2003 $0.00 $0.00 $0.00
G
4th OtL
$390,272 $0
$390,272 $390,272
$0 $48,839 ($48,839) ($48,839)
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$390,272.00 $48,839.00
$341,433.00 $341,433.00
$390,272.00 $48,839.00
$341,433.00
4003 Adjustment
Page 35 of 41
&[DATE]
SH ELL-MCCLU RG-066003
Benzene Health Research Consortium Contingency Fund 4Q03 Financial Report
H
~ 2004 1stOtr.
"I $0 $0 $0
$390,272
$0 $0 $0 U ($48,839)
L<L
~ $0 $0 $0 $0
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,
2004 2004
$0.00 $0.00 $0.00 $341,433.00
$0.00 $0.00 $0.00
"Ie
i
o;j
04
per Technical Committee, transfer $48,839 from UCHSC budget detail to contingency because expenses not part of UCHSC grant budget: 1. June 2001 $25K grant to UCHSC; seed money exhausted (API & sponsor), expense not included in final grant cost estimate 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 $20239 fLOm EMBSI for. final feasibilitv studv wor.k ver.v late bill ina to API
I
2nd Otr.
$0 $0 $0 $390,272
$0 $0 $0 ($48,839)
$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 $341,433.00
$0.00 $0.00 $0.00
J
3r.d Otr.
$0 $0 $0 $390,272
$0 $0 $0 ($48,839)
$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 $341,433.00
$0.00 $0.00 $0.00
K
4th Otr.
$0 $0 $0 $390,272
$0 $0 $0 ($48,839)
$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 $341,433.00
$0.00 $0.00 $0.00
L
1stOtr.
$0 $0 $0 $390,272
$0 $0 $0 ($48,839)
$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 $341,433.00
$0.00 $0.00 $0.00
MN
2005
2nd Otr.
3r.d Otr.
$0 $0 $0 $390,272
$0 $0 $0 $390,272
$0 $0 $0 ($48,839)
$0 $0 $0 ($48,839)
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $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 $341,433.00
2005 $0.00 $0.00 $0.00
$0 $0 $0 $0
$0.00 $0.00 $0.00 $341,433.00
$0.00 $0.00 $0.00
Page 36 of 41
&[DATE]
SH ELL-MCCLU RG-066004
Benzene Health Research Consortium Contingency Fund 4Q03 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
04
0
4lh OIL
$0 $0 $0 $390,272
$0 $0 $0 ($48,839)
$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 $341,433.00
$0.00 $0.00 $0.00
P
1sl0lL
$0 $0 $0 $390,272
$0 $0 $0 ($48,839)
$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 $341,433.00
$0.00 $0.00 $0.00
QR
2006
2nd OIL
3Ld OIL
$0 $0 $0 $390,272
$0 $0 $0 $390,272
$0 $0 $0 ($48,839)
$0 $0 $0 ($48,839)
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $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 $341,433.00
2006 $0.00 $0.00 $0.00
$0 $0 $0 $0
$0.00 $0.00 $0.00 $341,433.00
$0.00 $0.00 $0.00
S
4lh OIL
$0 $0 $0 $390,272
$0 $0 $0 ($48,839)
$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 $341,433.00
$0.00 $0.00 $0.00
T
1sl0lL
$0 $0 $0 $390,272
$0 $0 $0 ($48,839)
$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 $341,433.00
$0.00 $0.00 $0.00
UV
2007
2nd OIL
3Ld OIL
$0 $0 $0 $390,272
$0 $0 $0 $390,272
$0 $0 $0 ($48,839)
$0 $0 $0 ($48,839)
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $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 $341,433.00
2007 $0.00 $0.00 $0.00
$0 $0 $0 $0
$0.00 $0.00 $0.00 $341,433.00
$0.00 $0.00 $0.00
W
4lh OIL
$0 $0 $0 $390,272
$0 $0 $0 ($48,839)
$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 $341,433.00
$0.00 $0.00 $0.00
X
TOTALS
$390,272 $0 $0
$390,272
$0 $48,839
$0 ($48,839)
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$390,272.00 $48,839.00 $0.00
$341,433.00
$0.00 $0.00 $0.00
Page 37 of 41
&[DATE]
SH ELL-MCCLU RG-066005
A
~ ~ INCOME
"I Sponsor Payments Interest Other
TOTALS Reporting Period
~ Cumulative
projected income U 14 LT 417104
Benzene Health Research Consortium Income 4Q03 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,964.50 $5,276
$1,485,875
$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 $1,485,875
$5,000
$0
$0
$0
$0
$0
$0
$0 $100,000
$0
$15,257,275 $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 38 of41
&[DATE]
SH ELL-MCCLU RG-066006
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 4Q03 Financial Report
Page 39 of41
&[DATE]
SH ELL-MCCLU RG-066007
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 4/7/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 Detail 4Q03 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
544956
3-0cl-03
$3,728,476
$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
$7,546,063.50
$15,943,476
Page 40 of41
&[DATE]
SH ELL-MCCLU RG-066008
Benzene Health Research Consortium Sponsor Payment Detail 4Q03 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 44094 Shell Chemical
27 51153 ExxonMobil
28 51869 ConocoPhillips
29 51891 Shell Chemical
30 52332 ChevronTexaco
31 52633 BP p.Lc.
32 42934 American Petroleum Institute
33
34
35
36
37 LT 4/7/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 2/10/2003 10/3/2003 10/27/2003 10/28/2003 11119/2003 12/4/2003 1117/2003
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 $ 448,023.00 $ 771,524.50 $ 514,349.00 $ 514,350.00 $ 1,028,700.00 $ 1,431,041.00 $ 1.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
3Q03 -0-
4Q03 $ 4,259,964.50 $ 15,229,126.59
(note - does not include interst income)
$ 15,229,126.59
Page 41 of41
&[DATE]
SH ELL-MCCLU RG-066009