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