Document vV7a9nBEJnQz6wk9Ynqy8MQa6

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