Document 3JdBx8D07OQmrpm96E9jXyYMy

To: From: Cc: Bcc: Received Date: Subject: BenzConsort-TC@listserve.api.org <BenzConsort-TC@listserve.api.org> Russell White <whiter@api.org> BenzConsort-OC@listserve.api.org <BenzConsort-OC@listserve.api.org> 2006-10-3012:39:53 GMT Shanghai Health Study - 3Q draft budget Steve and Stuart, Do you have any time on Wednesday afternoon to go over the 3Q budget? > Attachments: BHRC Program Expenses 3Q06 rpt - DRAFT.xls Picture (Metafile) SH ELL-MCCLU RG-062642 Benzene Health Research Consortium 3006 Financial Report Overview Fund Balanc e at API 3Q06: Fund Balance in spreadsheet 3Q06: $ 2,532,299 $ 2,532,298 DRAFT Irons Field Expenses: $0 disbursed in 3006 UCHSC: $2,298,333 spent in 1st half of 2006 (Actuals per UCHSC official data) AHS: $141,140 spent in 3006 Fudan University: $0 in 1st half of 2006 (2005 Invoice for $76k is being reviewed with Dr. Fu.) SRP/ERP: $58,047 spent in 3006. Extension of all member's contracts through Dec 2007 completed. Contract committments increased t( Communications: No activity in 3006 Outside Legal Council: $1,846 spent in 3006 (Budget must be raised to at least $156k to cover expected expenses.) QAlQC: No activity in 3006 Contingency: $642,515 remains uncommitted API Administrative Costs: $49,608 spent in 3006 (J) I m r r Executi sI : ve () () Summa r C rv.:.... ;a G) oI (J) I'V (J) ..j:::o. c..> Page 1 of 62 AUTODATE Benzene Health Research Consortium 3006 Financial Report Overview o $473,142 with (J) I m r r sI : () () r C ;a G) oI (J) I'V (J) ..j:::o. ..j:::o. Page 2 of 62 AUTODATE Technical Budget Work Group Acceptance: Oversight Committee Acceptance: Posted to Website: Benzene Health Research Consortium 3006 Financial Report Overview LT 8/24/05 BJ 11/29/0 5 ROW 7/27/06 RT 10/26/0 6 (J) I m r r sI : () () r C ;a G) oI (J) I'V (J) ..j:::o. Page 3 of 62 c..n AUTODATE E .~ s: to: (J) .Q2-:) oC Q) > 0 o2coC t: 0 Cl.. Q) Q) ~a: -a: "(0 oC .-co (cC.o) Q) C I L-L CQ)<oD ~a CCt) Q) III llJ f- ooe:( f::J e:( fi! "0 "Q) n'O".J SH ELL-MCCLU RG-062646 Item Benzene Health Research Consortium Approved Program Budget Approved Original Cost Revised Cost 3006 Financial R- ......... Unapproved Approved Changes not Approved Approved Approved Estimate Estimate approved (June 11 NOV 03 OC 21 APR 04 OC 16 Dec 04 OC 3 May 05 OC (Jan. 2001) (Dec. 2001) 2003) mtg mtg mtg mtg AHScienc es CaseControl Study 1,595,000 2,283,095 2,283,095 2,283,095 2,283,095 2,283,095 2,930,841 DP&ME Studies (UCHSC) Irons(T & E) Fudan University 13,665,017 1,253,428 165,700 15,258,017 1,253,428 190,555 15,258,000 1,597,273 661,000 14,508,000 1,413,428 230,000 14,508,000 1,413,428 230,000 14,508,000 18,332,769 1,413,428 1,413,428 230,000 306,062 Scientific Review Panel Ethics Review Panel Total Research Costs 16,679,145 18,985,095 648,000 216,000 19,799,368 18,434,523 18,434,523 18,434,523 22,983,100 551,736 300,000 300,000 300,000 300,000 192,000 64,000 64,000 64,000 64,000 External Pathology & (J) Cytogenet I ics m r Workgrou r ps(Cost in s:I UC cost) () () r C ;a G) oI (J) I'V (J) ..j:::o. -.....J 130,000 -- Page 5 of 62 - -- AUTO DATE Approved Approved 21 Aug 06 OC 20 Sept 06 OC mtg mtg 2,930,841 2,930,841 18,332,769 1,413,428 306,062 22,983,100 18,332,769 1,413,428 379,829 23,056,867 346,950 346,950 126,192 126,192 (J) I m r r s:I -- () () r C ;a G) oI (J) I'V (J) ..j:::o. ex> Benzene Health Research Consortium Approved Program Budget 3006 Financial Report Page 6 of 62 AUTODATE Benzene Health Research Consortium Approved Program Budget 3Q06 Financial Report Exposure Assessme nt Total Panel Costs 450,000 994,000 743,736 364,000 364,000 364,000 364,000 API Seed Monies Outside Counsel Public Affairs QAlQC Activities UCHSC Interest contingency Miscellaneous Costs Subtotal API Admin. GRAND TOTAL 500,000 1,000,000 190,855 1,690,855 18,820,000 941,000 19,761,000 - 500,000 1,000,000 225,000 - 1,725,000 21,704,095 1,085,205 22,789,300 - 100,576 960,600 100,000 - 1,161,176 21,704,280 1,085,019 22,789,299 - 100,000 550,000 100,000 (100,000) 390,272 1,040,272 19,838,795 1,245,205 21,084,000 - 100,000 550,000 100,000 - 290,272 1,040,272 19,838,795 1,245,205 21,084,000 -- 100,000 140,000 300,000 300,000 50,000 - 590,272 1,040,272 19,838,795 1,245,205 50,000 - 850,695 1,340,695 24,687,795 1,445,205 21,084,000 26,133,000 Notes by API Notes/As sumption s for Dec. 2001 (J) revised I budget: m r - The total research costs have changed as a result of r the protocol review process and changes in the s:I protocols as recommended by the SRP and ERP. () Case-Control Study was also adjusted for inflation () r (5%/year) in an interim iteration. C ;a G) oI (J) I'V (J) ..j:::o. <D 3 May 05 revised budget notes - $423 added to contingency to round total budget to nearest thousand Page 7 of 62 AUTO DATE 109,000 582,142 109,000 582,142 - 140,000 300,000 50,000 - 840,900 1,330,900 24,896,142 1,445,205 26,341,347 - 140,000 300,000 50,000 - 798,907 1,288,907 24,927,916 1,445,205 26,373,121 (J) I m r r sI : () () r C ;a G) oI (J) I'V (J) c..n o Benzene Health Research Consortium Approved Program Budget 3006 Financial Report Page 8 of 62 AUTODATE Benzene Health Research Consortium Approved Program Budget 3006 Financial Report - Panel costs assume that there will be only one face-to- face meeting for each panel each year. - increased API adm inistrative costs for one extra year (2007) DRAFT BP CVX COP* XOM* Shell $0 $911,959 $308,182 $1,093,939 $911,959 2005 pmt schedule unchanged from current schedule except for BP * 2005 commitment paid as of 3/31/05 LT 7/24/05 RDW (J) I 7/27/06 m rdw r r 10/19/06 sI : () () r C ;a G) oI (J) I'V (J) c..n .....lo. Page 9 of 62 AUTODATE llJ f- ooe:( f::J e:( fi! o S' Q) 'O"J D- SH ELL-MCCLU RG-0626S2 Cost Centers Income Benzene Health Research Consortium Executive Summary 3Q06 Financial Report Project # Inception Thru December 2004 Actuals Actuals Jan - Dec 2005 Actuals Jan - Sept 2006 Actuals Program to Date $ 16,765,693 $ 5,206,657 $ 1,966,065 $ 23,938,415 Cummlative 2006 EOY projection $ 24,865,374 2006 Jan - Sept $ Cost Centers UCHSC* Irons-Field Expense* Applied Health Sciences Fudan University X8105 X8106 X8107 X8108 10,137,850 788,486 1,391,014 124,090 3,624,030 262,000 548,720 4,007 2,000,000 131,000 326,417 76,377 15,761,880 1,181,486 2,266,152 204,474 13,778,460 990,282 17,761,880 1,312,486 2,487,687 222,569 2,000,000 131,000 410,965 47,236 Scientific & Ethics Panels Communications Outside Legal Counsel QAlQC Support API Administrative Exposure Assessment Contingency** X8109 X8103 X8104 X8110 X8100 x8111 181,713 294,161 64,529 856,208 104,473 76,176 33,706 170,475 51,918 65,647 13,706 118,867 323,537 294,161 111,941 1,145,550 156,391 350,439 296,107 129,479 16,667 1,190,183 40,000 156,391 88,049 23,433 12,500 121,500 Total Expenses $ 13,942,525 $ 4,771,033 $ 2,732,014 $ 21,445,572 $ 23,963,888 $ 2,834,683 Fund Balance $ 2,823,169 $ 3,298,247~g~p~g~g~~ (J) I m ::~!:9.;:::!::prgj!m,m:::~9.n~:::~:!iQ..:::~g::::::::::::::::::::: r r * amount disbursed by API sI : () ** $300K added to contingency; () $250K from Communicaitons & $50K r C from QAlQC ;a G) oI (J) I'V (J) c..n c..> Page 11 of 62 156,391 AUTO DATE Benzene Health Research Consortium Executive Summary 3Q06 Financial Report Budgeted PROJECTED 2006 Jan - Dec 2007 Jan - Dec $ 2,826,039 $ 1,535,748 Projected Program inc/exp Budget Income 26,401,122 1$ 26,373,121 1 4,000,000 262,000 547,953 94,472 570,889 100,942 502,311 80,704 Expenses 18,332,769 1,413,428 2,905,451 332,414 18,332,769 1,413,428 2,930,841 379,829 92,549 1,946 31,244 16,667 163,500 40,000 $ 5,250,331 96,726 1,946 31,242 16,667 225,450 69,000 $ 1,695,877 424,763 473,142 298,053 300,000 150,994 140,000 20,833 50,000 1,413,000 1,445,205 _ - _109,000 109,000 156,391 ....... 798,907..... $ 25,557,0971 $ 26,373,121 1 :::::~t::::::::::li'~lmM:::::::::::::::::::::::::::I!':~lgl: (J) I m r r s:I Income Detail () sponsors 23,483,294 () r C MAP contrib. $215,000 ;a G) oI (J) I'V (J) c..n ..j:::o. Page 12 of 62 AUTODATE *** ConocoPhillips pay remaining commitment in 2005 LT 8/3/05 RW 2/20106 RT 7/19/06 rdw 10/19/06 DRAFT Benzene Health Research Consortium Executive Summary 3Q06 Financial Report (J) I m r r sI : () () r C ;a G) oI (J) Page 13 of 62 AUTODATE I'V (J) c..n c..n API interest UCHSC interest TOTAL 163,920 76,202 $23,938,415 Benzene Health Research Consortium Executive Summary 3Q06 Financial Report (J) I m r r sI : () () r C ;a G) oI (J) Page 14 of 62 AUTO DATE I'V (J) c..n (J) Benzene Health Research Consortium Cash Flow Statement 3006 Financial Report 15t - 4th Otr. 15t - 4th Otr. I 15t - 4th Otr. I 15t & 2nd Otr. 2003 3rd Otr. 4th Otr. 15tOtr. 2004 2nd Otr. 3rd Otr. 4th Otr. 15tOtr. 2005 2nd Otr. 3rd Otr. 4th Otr. 15tOtr. 20 2nd Otr. Income for Reporting Period Income, Cumulative 60,246 60,246 2,113,1321 8,367,446 2,173,378 10,540,824 448,0241 3,1861 4,265, 241 1 1,485, 875 1 6, 746 1 6, 506 1 9, 292 1 1,096,01 372, 143 1 3,009, 787 1 728, 727 1 -I 1,934,291 10,988,848 10,992,034 15,257,275 16,743,149 16,749,895 16,756,401 16,765,693 17,861,693 18,233,836 21,243,623 21,972,350 21,972,350 23,906,641 :~!~M!~~~~!m:Bii@i!\~W::::::::':"" }~~!J:!j!!::~:~!!!!)~~r:::::::::':"'" I . . . . . . .NOTE: 1 in bank at 2,548,996 API This number does not agree with the executive summary because it is based on actuals, not LT 8/23/05 DRAFT RT 7/19/06 $372,143 (J) I m r r sI : () () r C ;a G) oI (J) 15 of 62 AUTODATE I'V (J) c.n -.....J 106 3rd Otr 4th Otr 1st Otr 2007 2nd Otr 3rd Otr Benzene Health Research Consortium Cash Flow Statement 3006 Financial Report 4th Otr 26,401,122 21,685,352 (J) I m r r sI : () () r C ;a G) oI (J) 16 of 62 AUTODATE I'V (J) c.n ex> Cost Centers Benzene Health Research Consortium Program Expense Summary 3006 Financial Report (J) I m r r sI : () () r C ;a G) oI (J) I'V (J) c..n <D Benzene Health Research Consortium Program Expense Summary 3006 Financial Report r-------------~------~------------~~--------------,~~~~~, Cost Centers (J) I m rr, s: () () r C ;a G,) o (J) I'V (J) (J) Page 18 of 62 AUTODATE o Benzene Health Research Consortium Program Expense Summary 3006 Financial Report RT 7/19/06 Amt.At UCHSC & Irons Field exp. Bank acct 21,314,021 ($235,610) 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 247,035 1,063,761 318,580 3,102,202 244,006 2,160,301 327,707 (J) I m r r sI : () () r C ;a G) oI (J) I'V (J) (J) Page 19 of 62 AUTODATE ....lo. Benzene Health Research Consortium Program Expense Summary 3006 Financial Report r-------------~------~------------~~--------------,~~~~~, Cost Centers LT 8/3/05 RT 7/19/06 API disbursed by period 1,631,000 100,942 570,889 IT IT 23,486,942 (includes pre-payments for UCHSC & Irons Field) (J) I m rr, s: () () r C ;a G,) o (J) I'V (J) (J) Page 20 of 62 I'V AUTODATE Cost Centers Benzene Health Research Consortium UCHSC Grant 3006 Financial Report 15t - 4th Ote. I 15t - 4th Ote. 11 5t & 2nd Otr 3rd Otr 4th Otr 15tOtr 2nd Otr 3rd Otr 4th Otr 15tOtr 2nd Otr 3rd Otr 4th Otr 954 954 123,629 123,629 76,940 77,894 1,795,030 1,025,372 769,658 39,523 117,417 549,014 108,346 225,763 988,733 565,870 422,863 225,763 (J) I m r UCHSC r statement s:I error for travel, off by +$105 () (4003) () r C ;a G) oI (J) I'V (J) Page 21 of 62 AUTODATE (J) c..> Benzene Health Research Consortium UCHSC Grant 3006 Financial Report (J) I m r r sI : () () r C ;a G) oI (J) I'V (J) Page 22 of 62 AUTODATE (J) ..j:::o. UCHSC (x81 05) Cost Centers LT 8/02105 BJ 8/02105 RT 7/19/06 DRAFT (J) I m r r sI : () () r C ;a G) oI (J) I'V (J) (J) c..n Benzene Health Research Consortium UCHSC Grant 3006 Financial Report 1st & 2nd Otr. 2003 3r.d Otr. 4th Otr. IstOtr. 2004 2nd Otr. 3rd Otr. 4th Otr. IstOtr. 2005 2nd Otr. 3rd Otr. 4th Otr. Am!. paid UCHSCto date: Am!. expensed to date: Am!. In UCHSC bank acct: (Adjusted 4003: $48,839 attr.ibuted to UCHSC in 3003 Report has been reallocated to Contingency: $25,000 preconsortium gran tin 2001; $3,600 for IRB Review in 2002; $20,239 for EMBSI "feasibility $13,761,880 study" in 2002) (Adjusted 4003: 2001 costs had been double expensed in 2002 column; ($523,807) adjusment $13,778,460 made in 4003) ($16,580) 2QOSvariance adjusted to reflect only current qtr variance bedgeted expense projections revised per 3 May 05 revised program budget Page 23 of 62 AUTODATE Cost Centers Benzene Health Research Consortium UCHSC Grant 3006 Financial Report 15tOtr. 2nd Otr. 3rd Otr. 4th Otr. LT 8/02105 BJ 8/02105 RT 7/19/06 DRAFT (J) I m r r sI : () () r C ;a G) oI (J) I'V (J) (J) (J) Page 24 of 62 AUTODATE Benzene Health Research Consortium UCHSC Subcontract 3006 Financial Report (J) I m LT 8/3/2005 r BJ 8/02105 rI RT 12102105 s: RT 7/19/06 () () r C ;a G) oI (J) I'V (J) (J) -.....J DRAFT "Total subcontracto r expenses" from study report (preliminary figure); "actual expenses" from UC Office of Grants & Contracts spreadsheet (final figures). "2002 subcontractor costs not broken out by UCHSC, so this must be added back into the sum of row totals for total subcontractor costs to balance $1,128,507 1331839 1351912 304797.5 Page 25 of 62 AUTODATE Benzene Health Research Consortium Irons Field Expenses 3006 Financial Report 4th Otr 15tOtr 43 63,511 48,782 (114,098) 11,563 43 63,554 112,336 13,035 24,598 (C)1}}~lljjl!} :::::::::::::::::::::::::::::::::::: .................... ::::::::::::::::::::::::::::::::: 3,200 262,260 400:6i91469,7981 525,306 .''.''.5'.'.8'.'.0'.',.'8.'.'1.'.'4.'.''.1'.'.'6.'.'3.'.'.6'.'.,'.3'.'.2,.,.2,1 3,157 198,706 288,283 342,665 512,270 556,215 651,624 43 03,004 11<',330 1<'1,133 13,U30 <'4,0~~ (10,3U3) 55,508 41,404 747,3381 761 ,442 (14,1U4) 802,846 761 ,442 41,4U4 12,020 (8,891) 1,024,878 1,033,769 (~,~~1) 4Q03 ADJUSTME NT2001/2002 expense underrecord ed; <$114,289 adjustment (J) I m r r sI : () () r Amt paid to C Irons to numbers as ;a date $919,486 of 6/30/05 G) oI (J) I'V (J) Page 26 of 62 (J) ex> AUTODATE Cost Centers 2nd Olr. 3r.d Olr. 4lh Olr. Benzene Health Research Consortium Irons Field Expenses 3006 Financial Report (J) I m r r sI : () () r C ;a G) oI (J) I'V (J) Page 27 of 62 AUTODATE (J) <D Cost Centers LT 8/24/05 BJ 8/24/05 RT 7/19/06 DRAFT Amt Irons has spent: Amt. In Irons bank acct: RT: See comments in cell5 M22 and M23 Benzene Health Research Consortium Irons Field Expenses 3006 Financial Report Otr. 3rd Otr. note -1005 &2005 expenses recprded in $872,369 2005 4th Otr. 15t Otr. 2nd Otr. 3rd Otr. 4th Otr. 15t Otr. 2nd Otr. 3rd Otr. 4th Otr. 15tOtr. 2nd Otr. $47,117 15tOtr. (J) I m r r sI : () () r C ;a G) oI (J) I'V (J) Page 28 of 62 AUTODATE o-.....J IRONS T&E (X81 06) Cost Centers 2007 2nd OIL 3rd OIL 4lh OIL LT 8/24/05 BJ 8/24/05 RT 7/19/06 DRAFT Benzene Health Research Consortium Irons Field Expenses 3006 Financial Report (J) I m r r sI : () () r C ;a G) oI (J) I'V (J) Page 29 of 62 AUTODATE -.....J .....lo. Benzene Health Research Consortium AHS 3006 Financial Report LT 8/3/05 BJ 4/05/05 (J) RT 10/26/06 I m r r sI : () () r C ;a G) oI (J) I'V (J) -.....J I'V DRAFT Adjustment: expense reduced by $52,634; transferred to contingency since these were preconsortia expenses 535,167 Page 30 of 62 547,953 AUTODATE Cost Centers 2nd Ole. 3rd Ole. 4lh Ole. Benzene Health Research Consortium AHS 3006 Financial Report LT 8/3/05 BJ 4/05/05 (J) RT 10/26/06 I m r r sI : () () r C ;a G) oI (J) I'V (J) -.....J c..> 502,311 Page 31 of 62 AUTODATE Benzene Health Research Consortium Fudan 3006 Financial Report LET 8/3/05 BJ 8/01/05 rdw 10/19/06 RT 10/26/06 (J) I m r r sI : () () r C ;a G) oI (J) I'V (J) -.....J ..j:::o. DRAFT 2Q05 - variance zeroed outonly current cqtr variance shown 2Q05 - ezpense projections revi sed based on 3 May 05 approved budget Page 32 of 62 AUTODATE Benzene Health Research Consortium Fudan 3006 Financial Report LET 8/3/05 BJ 8/01/05 rdw 10/19/06 RT 10/26/06 (J) I m r r sI : () () r C ;a G) oI (J) I'V (J) c-......n.J Page 33 of 62 AUTODATE Benzene Health Research Consortium Actual expense CurrentVariance Cumm Variance H.m;;I<:':':':'",, . Budgeted Actual expense CurrentVariance 2,160 2,160 2,160 2,000 160 8,640 10,800 4,320 15,120 2,160 17,280 7,334 (7,012) 10,268 8,640 4,320 8,640 4,320 2,160 2,160 322 4,454 (4,132) (10,268) (11,148) (11,148) 3,338 250 4,662 250 4,912 250 3,000 415 250 2,585 4,912 4,912 250 5,162 250 250 7,698 302 5,4641 5,464 I} 3,000 3,000 (J) I m r r s:I Actual expense CurrentVariance () Cumm Variance () r C ;a Budgeted Actual expense CurrentVariance Cumm Variance G) oI (J) I'V (J) -.....J (J) 1,250 910 910 2,160 2,160 I I8,640 4,320 2,160 9,550 13,870 16,030 8,640 I 4,320 I 2,160 8,640 322 16,352 2003 Benzene Health Research Consortium 2005 2nd Qtr 2006 2007 LT 8/3/05 BJ 4/05/05 rdw 10/19/06 RT 10/26/06 (J) I m r r sI : () () r C ;a G) oI (J) I'V (J) -.....J -.....J DRAFT 1Q04 budget ajustments to variance to develop more useful budget projections for remainder of program Change approved by OC at 4/21/04 meeting Page 35 of 62 AUTODATE Benzene Health Research Consortium Communications 3Q06 Financial Report ~1l,;AIIUN:S Cost Centers 2001 2002 1st - 4th 11st & 2nd 1st - 4th Otr.1 Otr. Otr. 2003 3rd Otr. 4th Otr. 2 I 1st Otr. 2004 2nd Otr. 3rd Otr. 4th Otr*. I 1st Otr. 2005 2nd Otr. 3rd Otr. 4th Otr. I 1st Otr. I Budgeted Actual expense CurrentVariance Cumm Variance 57,600 230,400 120,000 60,000 (187,396) 14,401 14,400 14,400 (39,906) 232,229 14,483 7,351 26,541 790 1,235 1,270 57,600 (1,829) 105,517 52,649 (213,937) 14,401 13,610 13,165 (41,176) 57,600 55,771 161,288 213,937 (0) 14,401 28,011 41,176 (0) (0) (0) (0) (0) (0) I Budgeted Actual expense CurrentVariance Cumm Variance 1,800 7,200 3,750 1,875 (5,876) 450 450 450 (1,350) 7,091 526 1,132 1,800 109 3,750 1,349 (7,008) 450 450 450 (1,350) 1,800 1,909 5,659 7,008 0 450 900 1,350 0 o o o o o I Budgeted Actual expense CurrentVariance Cumm Variance IBudgeted Actual expense CurrentVariance Cumm Variance 600 2,400 1,250 625 (3,364) 150 150 150 (448) 1,946 1,417 80 15 600 983 1,170 625 (3,379) 150 150 150 (448) 1,946 000 1,tl83 ',/tl3 3,3/8 (') 148 '88 448 1 1 1,841 1,841 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 IBudgeted Actual expense CurrentVariance Cumm Variance $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 IBudgeted Actual expense CurrentVariance Cumm Variance $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 IBudgeted $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ~oo ~OO Actual expense $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ~OO ~OO ~OO ~OO ~OO CurrentVariance $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ~OO ~OO ~OO ~OO ~OO Cumm Variance $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ~OO ~OO ~OO ~OO ~OO ':':':':':':'2001 :':':':':': ':':':':':200-2 :':':': ':':':':':':':':':':':':':':':':':':':':':':':':':':2003:':'''''' Actual expense CurrentVariance I6(),()6()T~:~:~~~1~~:~~~ ......6r~~~1 (i~~:~~~) 60,000 (738) 110,436 54,623 (224,324) 15,001 15,001 15,~gg 14,210 1~:g~~ (4~ :~~6) 13,765 (42,974) 1,946 1,946 (J) Cumm Variance I mr r Expense Variance 60,000 59,262 169,699 224,322 (2) 14,999 29,209 42,974 0 66,()6() nn.2001 :2;0(0)2(),......6........6.......6.......}.......1.. ~,Mg~M,~~1I)).t@ }}_n)E{{C~g'!m.m m )))1 240,738 255,301 00,000 tl8,'0' 108,088 290,866 290,866 291,656 292,891 294,161 (') 14,888 '8,'08 4',8/4 o o o 1,946 1,946 I I I294,161 294,161 294,161 296, 107 1 296,107 294,161 294,161 294,161 294,161 294,161 1,840 1,840 s:I - I elecommunlcallons, consulting :services, Duplicating/Copies Internal, Postage, Couriers, ( ) Telephone, Meals, Lexis Nexis Searches . . . . .( ) J'llm!lm~Wt:~mW1llWAA~~W9'l:mm:mrmmmr!ii.:::r:::::::::::}:':'"",.,., r .mrW:!il~:~m%ff.t:::::::::::::::::::::::::.:.: ............................. C ~ - I::ludget adjustment retlects budget reduction ;a from $1 MM to $550k G) oI LT 8/3/05 (J) RT 1/21/05 *budget adjustment to lower program budget from $550K to I'V (J) Page 36 of 62 AUTODATE -.....J ex> Cost Centers Actual expense CurrentVariance Cumm Variance Actual expense CurrentVariance Cumm Variance Actual expense CurrentVariance Cumm Variance Benzene Health Research Consortium Communications 3Q06 Financial Report Actual expense CurrentVariance (J) Cumm Variance I m r r s:I Duplicating/Copies Internal, Postage, Couriers, ( ) Telephone, Meals, Lexis Nexis Searches () J'lm~FWWt:~mW1llWAA~~W9fmm:mnmWmr!ii.::) r .mrW:!il~:~m%ff.t:::::::::::::::::::::::::.:.: ............................. C ~ - I::ludget adjustment retlects budget reduction ;a from $1 MM to $550k G) oI LT 8/3/05 (J) RT 1/21/05 I'V (J) -.....J <D Page 37 of 62 AUTODATE Cost Centers DRAFT Benzene Health Research Consortium Communications 3Q06 Financial Report 1s1 & 2nd 2003 Olr. 3rd Olr. 4lh OIr. 2 I 1s101r. 2004 2nd Olr. 3rd Olr. 4lh Olr*. I 1s101r. 2005 2nd Olr. 3rd Olr. 4lh Olr. I 1s101r. (J) I m r r sI : () () r C ;a G) oI (J) I'V (J) Page 38 of 62 AUTODATE ex> o Cost Centers DRAFT Benzene Health Research Consortium Communications 3Q06 Financial Report 4lh Olr. 2 I 1sl Olr. 2nd Olr. 3rd Olr. 4lh Olr. (J) I m r r sI : () () r C ;a G) oI (J) I'V (J) Page 39 of 62 AUTODATE ex> .....lo. Benzene Health Research Consortium Legal 3006 Financial Report * budget adjustment to lower program budget from $500K to $1 OOK, as approved by OC on 11/11/03 LT 8/3/05 RT 10/26/06 DRAFT $54,081 $85,920 $7,810.86 variance adjusted to reflect only 2005 variance 2005 Budget revised from $100K to $140K per revised program budget approved 3 May 05 $01 $13,5651 $1, 7281 $01 $17, 9151 $3651 $2,9951 $1,8701 $26,0921 $4,8271 $16, 7691 $01 $12, 1101 $98,2351 (J) I m r r sI : () () r C ;a G) oI (J) I'V (J) Page 40 of 62 ex> I'V AUTODATE Benzene Health Research Consortium Legal 3006 Financial Report * budget adjustment to lower program budget from $500K to $1 OOK, as approved by OC on 11/11/03 LT 8/3/05 RT 10/26/06 (J) I m r r sI : () () r C ;a G) oI (J) I'V (J) ex> c..> Page 41 of 62 AUTODATE Actual expense CurrentVariance Cumm Variance Actual expense CurrentVariance Benzene Health Research Consortium QA-QC 3Q06 Financial Report (J) I m r r sI : () () r budget adjustment to lower C program budget from $225K to ; a $100K, as approved by OC on G) 11/11/03 oI (J) LT 8/3/05 DRAFT I'V (J) ex> ..j:::o. Page 42 of 62 AUTODATE Actual expense CurrentVariance Cumm Variance Actual expense CurrentVariance Benzene Health Research Consortium QA-QC 3Q06 Financial Report (J) I m r r sI : () () r budget adjustment to lower C program budget from $225K to ; a $100K, as approved by OC on G) 11/11/03 oI (J) LT 8/3/05 I'V (J) ecx..>n Page 43 of 62 AUTODATE Cost Centers Actual expense CurrentVariance Cumm Variance Actual expense CurrentVariance Cumm Variance Actual expense CurrentVariance Cumm Variance Actual expense CurrentVariance Cumm Variance Actual expense CurrentVariance Cumm Variance Actual expense CurrentVariance (J) I m r r sI : () () r C ;a LT 8/1/05 G) oI (J) I'V (J) ex> (J) DRAFT Benzene Health Research Consortium API Administration 3006 Financial Report Page 44 of 62 variance reflects 2Q05 variance, only AUTODATE Cost Centers Actual expense CurrentVariance Cumm Variance Actual expense CurrentVariance Cumm Variance Actual expense CurrentVariance Cumm Variance Actual expense CurrentVariance Cumm Variance Actual expense CurrentVariance Cumm Variance Actual expense CurrentVariance (J) I m r r sI : () () r C ;a LT 8/1/05 G) oI (J) I'V (J) ex> -.....J Benzene Health Research Consortium API Administration 3006 Financial Report Page 45 of 62 AUTODATE Benzene Health Research Consortium API Administration 3006 Financial Report API Cost Centers 2003 2004 2005 201 I1s1 & 2nd Olr. Olr. Olr. Olr. 3rd Olr. 41h Olr. 1sl Olr. 2nd Olr. 3rd Olr. 41h Olr. 1sl Olr. 2nd Olr. 3rd Olr. 41h Olr. 1sl Olr. 2nd Olr. budgeled expenses revised 10 reflecl3 May 05 revised lolal program RT 10/26/06 budgel Miii.&'M@~f:iiii.#ims.@!.i.'%MffuW~I~i:iir (J) I m r r sI : () () r C ;a G) oI (J) I'V (J) Page 46 of 62 AUTODATE ex> ex> Cost Centers RT 10/26/06 Miii.&'M@~f:iiii.#ims.@!.i.'%MffuW~I~i:iir Benzene Health Research Consortium API Administration 3006 Financial Report (J) I m r r sI : () () r C ;a G) oI (J) I'V (J) Page 47 of 62 AUTODATE ex> <D rdw 10/19/06 (J) I m r r sI : () () r C ;a G) oI (J) I'V (J) <D o Benzene Health Research Consortium Contingency Fund 3006 Financial Report 101,473 101,473 101,473 188,799 188,799 188,799 155,191 155,191 435,081 695,504 Current quarter expense Remaining funds ** to be reprogrammed as API expense in 3005 LT 8/3/05 RT 7/19/06 (J) I m r r sI : () () r C ;a G) oI (J) I'V (J) <D --lo. DRAFT 4003 Adjustment - per Technical Committee, transfer $48,839 from UCHSC expense detail to contingency because expenses not part of UCHSC grant budget: Page 49 of 62 798,907 AUTODATE Benzene Health Research Consortium Contingency Fund 3006 Financial Report (J) I m r r sI : () () r C ;a G) oI (J) Page 50 of 62 AUTODATE I'V (J) <D I'V Benzene Health Research Consortium Contingency Fund 3006 Financial Report 1. June 2001 $25K grant to UCHSC; seed money exhausted (API & sponsor), expense not included in final grant cost estimate 2. $3600 IRB fees to U of CO (this will be a yearly fee, since IRB must review at least once per year) 3. 2002 invoice ($20,239) from EMBSI for final (J) feasibility I m r study work (very late r billing to s:I API) () () r C ;a G) I 0 (J) Page 51 of 62 I'V (J) <D c..> AUTODATE E t: 0 .:_::J C0)l.. t:a: 0_ o(Cfl .(C-.O) o ffi ..c .~ 2LL CO (0 0)0 &C')(flO ._.c"Oc - :::J ffiLL I 0) g>- C 0) 0) Ol CN .C- o0 al )- llJ f- ooe:( f::J e:( C\I (0 '0 C\I L() 0) Ol CO D.... SH ELL-MCCLU RG-062694 AHSexpense transfer of $52,634 from AHS expense detail to contingency because expenses not part of AHS full study budget Benzene Health Research Consortium Contingency Fund 3006 Financial Report (J) I m r r sI : () () r C ;a G) oI (J) Page 53 of 62 AUTODATE I'V (J) <D c..n Benzene Health Research Consortium Income 3006 Financial Reoort I:::INCOME}:':':,',',',, . Sponsor Payments API Interest UCHSC Interest I::TOTALS:::::':'''',',,,, Reporting Period Cumulative 60,2461 2,173,3781 10,540,8241 10,988,8481 10,992,0341 15,257,2751 16,743,1491 16,749,8951 16,756,401 16,765,6931 17,861,693 1 18,233,836 1 21,243,623 1 21,972,350 projected income LT 8/23/05 RT 7/19/06 rdw 10/1 9/06 DRAFT (J) I m r r sI : () () r C ;a G) oI (J) Page 54 of 62 AUTODATE I'V (J) <D (J) 23,698,294 (J) I m r r sI : () () r C ;a G) oI (J) I'V (J) <D -....J Page 55 of 62 AUTODATE Company Name BP (Seed Money) $15,000 $22,500 Inv, # 522922 528453 Date Paid 8-Nov-00 19-Jun-01 Benzene Health Research Consortium Sponsor Invoice Detail 3Q06 Financial Report 2001 2002 (1 st - 2nd Qtr,) 2002 (3rd - 4th Qtr,) 22-Aug-01 Inv, # Date Paid $768,941 529301 4-0ct-01 9-Jan-02 $806,441 Inv,# Date Paid 532263 22-Feb-02 27-Aug-02 $1,344,069 $112,008 Inv, # 535033 Date Paid 11-0ct-02 2-0ct-02 2003 23-Sep-03 Inv,# $1,431,041.00 544951 l,;nevron ~l ::>,uuul ::>LL8L;:I1 (-I\JOV-UU ~::>LL,bL{ ::>L8;:1ULI 8-UCI-Ul ~::>0f,bL{ ::>;:ILL44 1 LL-reD-uLI ~tl8b,U4bl ::>;:I::>U;:I41 ::>-,\Jov-ULI ~l ,ULtl,fUU.UUI ::>448::>;:1 ConocoPhillips $15,000 522924 31-0ct-00 $7,500 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 ExxonMobii $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 544956 $771 ,524.50 $771 ,524.50 Shell $15,000 523054 24-0ct-00 $15,000 528333 15-May-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 $1,028,700.00 544958 $514,350 $514,350 Marathon Total $15,000 528541 14-Aug-01 $120,000 $2,045,509 $5,376,273 Marathon Ashland Marathon Oil $5,936,307 $150,000 548582 $50,000 548581 $8,317,588,00 I I 2006 Company Name Dt' invdate Inv,# ~U.UU Projected Invoicing 2007 Date Paid inv date Inv, # ~u.uu Date Paid Projected TOTALS ~I ,U~,1)'Rl l,;hevron ~8l1,8tM ::>1::>U44 lu-vcr-Vb !Ii4;:1::>,Ufl $4.712,364 (J) ConocoPhillips $308,182 575045 19-Jun-06 $0.00 I m ExxonMobii r r s:I () Shell () r C ;a Marathon $1,093,939 575042 31-May-06 $652,606 $400,000 571301 $511,959 575043 3-Mar-06 2-Jun-06 $0 $435,071 $0 G) oI (J) I'V (J) <D ex> $2,356,182 $7,068,545 $4,712,364 $215,000 Page 56 of 62 AUTODATE Benzene Health Research Consortium 26133 25859 (J) 274 I m r r sI : () () r C ;a G) oI (J) I'V Page 57 of 62 AUTODATE (J) <D <D IT _0_ i LT 8/18/05 RT 7/19/06 iVSX!.".".., .'vI!,a,"V,~~ DRAFT Benzene Health Research Consortium Sponsor Invoice Detail 3Q06 Financial Report .$..1., 6!5e2'v2,,."77A48 ! ! "Wi!' 1OS" KXJ (J) I m r r si : () () r C ;a G) oi (J) I'V Page 58 of 62 AUTODATE -.....J o o Benzene Health Research Consortium Sponsor Payment Detail 3006 Financial Report (J) I m r r sI : () () r C ;a G) oI (J) I'V -.....J Page 59 of 62 AUTODATE o .....lo. LT 8/3/05 RT 7/19/06 DRAFT Benzene Health Research Consortium Sponsor Payment Detail 3006 Financial Report (note - does not include interest income) $23,698,294.09 (J) I m r r sI : () () r C ;a G) oI (J) I'V -.....J Page 60 of 62 AUTODATE o I'V BHRC Sponsor Payments r-----------------------------~------~------~O'r~a~8~R~iz~e,dbySponsor Company erican Petroleum Institute International Limited International Ltd p.Lc. p.Lc. p.Lc. p.Lc. p.Lc. p.Lc. Amount 1.09 15,000.00 22,500.00 768,941.00 806,441.00 112,008.00 1,344,069.00 1,431,041.00 2,568,545.00 am trying to get this $1.09 m"Hori from the books) BP Total $ 7,068,545.00 Mobil Research and Engineering Mobil Research and Engineering Mobil (J) I m r r sI : () () r C ;a G) oI (J) I'V -.....J o c..> 522,627.00 537,627.00 896,046.00 I ChevronTexaco Total I1,028,700.00 365,334.00 $ 3,365,334.00 00.00 7,500.00 246,314.00 268,814.00 I448,023.00 514,349.00 ConocoPhillips Total 548,000.00 $ 2,356,182.00 806,441.00 806,441.00 1,344,069.00 771,524.50 771,524.50 I ExxonMobil Total 548,000.00 274,000.00 $ 6,415,939.00 Marathon Ashland Total $ 215,000.00 Page 61 of 62 AUTO DATE LT 8/3/05 RT 7/19/06 DRAFT BHRC Sponsor Payments 15Jro81lliZfld by Sponsor Company 507,627.00 537,627.00 448,023.00 448,023.00 514,350.00 514,350.00 365,334.00 400,000.00 Shell Chem ical Total $ 4,277,293.00 (J) I m r r sI : () () r C ;a G) oI (J) Page 62 of 62 AUTODATE I'V -.....J o ..j:::o.