Document x7YEQERXLeQ76NpXrw2wLQdQ

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