Document ppkre4DXQQMQ05M8nN50680Y7

Benzene Health Research Consortium 4Q06 Financial Report Overview Fund Balanc e at API 3Q06: Fund Balance in spreadsheet 4Q06: $ 2,532,299 $ 5,030,938 DRAFT Irons Field Expenses: $131,000 disbursed in 4006 UCHSC: $2,298,333 spent in 1st half of 2006 (Actuals per UCHSC official data) AHS: $231,797 spent in 4006 Fudan University: $76,377 paid for 2005 invoice SRP/ERP: $29,771 spent in 4006. Extension of all member's contracts through Dec 2007 completed. Contract committments increased t( Communications: No activity in 4006 Outside Legal Council: $25,448 spent in 4006 (Budget must be raised to at least $156k to cover expected expenses.) QAlQC: $1,202 spent in 4006 (mistake - should go to API Admin - dinner in SF) Contingency: $698,596 remains uncommitted API Administrative Costs: $41,916 spent in 4006 Revenue: $4,972,098 posted in 4006 (J) I m rr- sI : () () Executi cr- ve ;a Summa G) I rv.:.... 0 (J) c..> (J) .....lo. -.....J Page 1 of 64 AUTODATE Benzene Health Research Consortium 4Q06 Financial Report Overview o $473,142 with (J) I m r r sI : () () r C ;a G) oI (J) c..> (J) .....lo. ex> Page 2 of 64 AUTODATE Benzene Health Research Consortium 4Q06 Financial Report Overview Technical Budget Work Group Acceptance: Oversight Committee Acceptance: Posted to Website: LT 8/24/05 BJ 11/29/0 5 ROW 7127106 RT 2/15/07 (J) I m r r sI : () () r C ;a G) oI (J) c..> (J) .....lo. Page 3 of 64 <D 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 C"<t Q) III llJ f- ooe:( f::J e:( <Ii "0 "Q) n'O".J SH ELL-MCCLU RG-063620 Item Benzene Health Research Consortium Approved Program Budget Approved Original Cost Revised Cost 4Q06 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) c..> (J) I'V .....lo. 130,000 -- Page 5 of 64 - -- AUTO DATE Approved Approved Approved 21 Aug 06 OC 20 Sept 06 OC 08 March 07 mtg mtg OCmtg 2,930,841 2,930,841 2,930,841 18,332,769 1,413,428 306,062 22,983,100 18,332,769 18,332,769 1,413,428 1,413,428 379,829 379,829 23,056,867 23,056,867 346,950 346,950 346,950 126,192 126,192 126,192 (J) I m r r s:I - -- () () r C ;a G) oI (J) c..> (J) I'V I'V Benzene Health Research Consortium Approved Program Budget 4Q06 Financial Report Page 6 of 64 AUTODATE Benzene Health Research Consortium Approved Program Budget 4Q06 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) c..> (J) I'V c..> 3 May 05 revised budget notes - $423 added to contingency to round total budget to nearest thousand Page 7 of 64 AUTO DATE 109,000 582,142 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 180,000 300,000 300,000 50,000 - 798,907 1,288,907 24,927,916 1,445,205 50,000 - 814,988 1,344,988 24,983,997 1,445,205 26,373,121 26,429,202 Benzene Health Research Consortium Approved Program Budget 4Q06 Financial Report (J) I m r r sI : () () r C ;a G) oI (J) Page 8 of 64 c..> (J) I'V ..j:::o. AUTODATE Benzene Health Research Consortium Approved Program Budget 4Q06 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 : rdw () 3/12107 () r C ;a G) oI (J) c..> (J) cI'.V.n Page 9 of 64 AUTODATE llJ f- ooe:( f::J e:( <Ii o S' Q) 'O"J D- SH ELL-MCCLU RG-063626 Cost Centers Income Benzene Health Research Consortium Executive Summary 4Q06 Financial Report Project # Inception Thru December 2004 Actuals Actuals Jan - Dec 2005 Actuals Jan - Dec 2006 Actuals Program to Date $ 16,765,693 $ 5,206,657 $ 6,938,163 $ 28,910,513 Cummlative 2006 EOY projection $ 28,910,513 2006 Jan - Dec $ 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 4,000,000 262,000 558,214 76,377 17,761,880 1,312,486 2,497,948 204,474 13,778,460 990,282 17,761,880 1,312,486 2,487,687 222,569 4,000,000 262,000 547,953 94,472 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 95,418 39,154 1,202 160,782 12,324 353,308 294,161 137,390 1,202 1,187,466 12,324 156,391 350,439 296,107 129,479 16,667 1,190,183 40,000 156,391 92,549 1,946 31,244 16,667 163,500 40,000 Total Expenses $ 13,942,525 $ 4,771,033 $ 5,205,472 $ 23,919,030 $ 23,963,888 $ 5,250,331 Fund Balance $ 2,823,169 $ 3,298,247~~p:.m.~~~ (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) c..> (J) I'V -.....J Page 11 of 64 156,391 AUTO DATE Benzene Health Research Consortium Executive Summary 4Q06 Financial Report Budgeted PROJECTED 2006 Jan - Dec 2007 Jan - Dec $ 2,826,039 $ 1,535,748 Projected Program inc/exp Budget Income 30,446,261 I $ 26,429,202 I 4,000,000 262,000 547,953 94,472 570,889 100,942 502,311 80,704 Expenses 18,332,769 1,413,428 3,000,259 285,178 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 450,034 473,142 296,107 300,000 168,632 140,000 17,869 50,000 1,412,916 1,445,205 _ - _81,324 109,000 156,391 ....... 854,988..... $ 25,614,907 I $ 26,429,202 I :::::~t::::::::::li'~lmM:::::::::::::::::::::::::::I!':~lgl: (J) I m r r s:I Income Detail () sponsors 28,399,312 () r C MAP contrib. $215,000 ;a G) oI (J) c..> (J) I'V ex> Page 12 of 64 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 4Q06 Financial Report (J) I m r r sI : () () r C ;a G) oI (J) Page 13 of 64 AUTODATE c..> (J) I'V <D API interest UCHSC interest TOTAL 220,000 76,202 $28,910,513 Benzene Health Research Consortium Executive Summary 4Q06 Financial Report (J) I m r r sI : () () r C ;a G) oI (J) Page 14 of 64 AUTO DATE c..> (J) c..> o Benzene Health Research Consortium Cash Flow Statement 4Q06 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:::::::::':"'" .............. 1 in bank at INOTE: 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 64 AUTODATE c..> (J) c..> ....l:. Benzene Health Research Consortium Cash Flow Statement 4Q06 Financial Report 30,446,261 23,891,335 (J) I m r r sI : () () r C ;a G) oI (J) 16 of 64 AUTODATE c..> (J) c..> I'V Cost Centers Benzene Health Research Consortium Program Expense Summary 4Q06 Financial Report 3rd Olr (J) I m r r sI : () () r C ;a G) oI (J) c..> (J) c..> c..> Benzene Health Research Consortium Program Expense Summary 4Q06 Financial Report r-------------~------~------------~~--------------,~~~~~, Cost Centers (J) I m rr, s: () () r C ;a G,) o (J) c..> (J) c..> Page 18 of 64 AUTODATE ..j:::o. Benzene Health Research Consortium Program Expense Summary 4Q06 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) c..> c.n(J) c..> Page 19 of 64 AUTODATE Benzene Health Research Consortium Program Expense Summary 4Q06 Financial Report r-------------~------~------------~~--------------,~~~~~, 4th Ote. LT 8/3/05 RT 7/19/06 API disbursed by period 2,473,458 100,942 570,889 IT IT 24,287,485 (includes pre-payments for UCHSC & Irons Field) (J) I m rr, s: () () r C ;a G,) o (J) c..> (J) c..> Page 20 of 64 (J) AUTODATE Cost Centers Benzene Health Research Consortium UCHSC Grant 4Q06 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) c..> (J) Page 21 of 64 AUTODATE c..> -.....J Benzene Health Research Consortium UCHSC Grant 4Q06 Financial Report (J) I m r r sI : () () r C ;a G) oI (J) c..> (J) Page 22 of 64 AUTODATE c..> ex> 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) c..> (J) c..> <D Benzene Health Research Consortium UCHSC Grant 4Q06 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 64 AUTODATE Cost Centers Benzene Health Research Consortium UCHSC Grant 4Q06 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) c..> (J) ..j:::o. o Page 24 of 64 AUTODATE Benzene Health Research Consortium UCHSC Subcontract 4Q06 Financial Report (J) I m LT 8/3/2005 r BJ 8/02105 rs:I RT 7/19/06 () () r C ;a G) oI (J) c..> (J) .,j:::o. ....lo. 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 64 AUTODATE Benzene Health Research Consortium Irons Field Expenses 4Q06 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) c..> (J) Page 26 of 64 ..j:::o. I'V AUTODATE Cost Centers 2nd Olr. 3r.d Olr. 4lh Olr. Benzene Health Research Consortium Irons Field Expenses 4Q06 Financial Report (J) I m r r sI : () () r C ;a G) oI (J) c..> (J) Page 27 of 64 AUTODATE ..j:::o. c..> 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 4Q06 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) c..> (J) Page 28 of 64 AUTODATE ..j:::o. ..j:::o. 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 4Q06 Financial Report (J) I m r r sI : () () r C ;a G) oI (J) c..> (J) Page 29 of 64 AUTODATE ..j:::o. c..n Benzene Health Research Consortium AHS 4Q06 Financial Report LT 8/3/05 BJ 4/05/05 (J) RT2I15/07 I m r r sI : () () r C ;a G) oI (J) c..> (J) ..j:::o. (J) DRAFT Adjustment: expense reduced by $52,634; transferred to contingency since these were preconsortia expenses 535,167 Page 30 of 64 547,953 AUTODATE Cost Centers 2nd Ole. 3rd Ole. 4lh Ole. Benzene Health Research Consortium AHS 4Q06 Financial Report LT 8/3/05 BJ 4/05/05 (J) RT2I15/07 I m r r sI : () () r C ;a G) oI (J) c..> (J) ..j:::o. -.....J 502,311 Page 31 of 64 AUTODATE Benzene Health Research Consortium Fudan 4Q06 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) c..> (J) ..j:::o. ex> DRAFT 2Q05 - variance zeroed outonly current cqtr variance shown 2Q05 - ezpense projections revi sed based on 3 May 05 approved budget Page 32 of 64 AUTODATE Benzene Health Research Consortium Fudan 4Q06 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) c..> (J) ..j:::o. <D Page 33 of 64 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 } I } F }5,4641 5,4641 5,464 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) c..> (J) c..n o 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 LT 8/3/05 BJ 4/05/05 rdw 10/19/06 RT 2115/07 (J) I m r r sI : () () r C ;a G) oI (J) c..> (J) c..n .....lo. 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 64 AUTODATE Benzene Health Research Consortium Communications 4Q06 Financial Report ~1l;A IIUN::> Cost Centers 2001 1st - 4th Otr. I RlJnnp.tp.n 57,600 Actual expense CurrentVariance 57,600 Cumm Variance 57,600 I BUdgetedi,~66 Actual expense CurrentVariance 1,800 Cumm Variance 1,800 2002 1st - 4th Otr. 1st & 2nd Otr. 230,400 232,229 (1,829) 55,771 120,000 14,483 105,517 161,288 7,200 7,091 109 1,909 3,750 3,750 5,659 2003 3rd Otr. 60,000 7,351 52,649 213,937 1,875 526 1,349 7,008 I 4th Otr. 2 1st Otr. (187,396) 26,541 (213,937) (0) 14,401 14,401 14,401 (5,876) 1,132 (7,008) 0 450 450 450 2004 2nd Otr. 3rd Otr. 4th Otr*. 14,400 790 13,610 28,011 450 14,400 (39,906) 1,235 1,270 13,165 (41,176) 41,176 (0) 450(~,~M) 450 450 (1,350) 900 1,350 0 1st Otr. 2005 2nd Otr. 3rd Otr. 4th Otr. 1 1st Otr. ~I ~I ~I ~I ~ 01 01 01 01 0 RlJnnp.tp.n Actual expense CurrentVariance Cumm Variance Actual expense CurrentVariance Cumm Variance 600 600 000 $0.00 $0.00 $0.00 $0.00 2,400 1,417 983 1,tl83 $0.00 $0.00 $0.00 $0.00 1,250 80 1,170 ',!tl3 $0.00 $0.00 $0.00 $0.00 625 625 3,3/8 $0.00 $0.00 $0.00 $0.00 (3,364) 15 (3,379) (') $0.00 $0.00 $0.00 $0.00 150 150 148 $0.00 $0.00 $0.00 $0.00 150 150 '88 $0.00 $0.00 $0.00 $0.00 150 150 448 $0.00 $0.00 $0.00 $0.00 (448) (448) $0.00 $0.00 $0.00 $0.00 1,946 1,946 1 1 1,84/1 1,841 ~oo ~OO ~OO ~OO ~OO ~OO ~OO ~OO 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 ~oo ~OO ~OO ~OO ~OO ~OO ~OO ~OO 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 ~oo ~OO ~OO ~OO ~OO ~OO ~OO ~OO 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 .......2001....... .........2002..... ..................................... ......2003.... .......................................................................... .................2004...................................... }6(),()6()};4(),()6()i;g,66()}}62,5()g}N~ci,~~~)lg,66iig,M()m,66()} (li,704) ~OO ~OO ~OO ~OO ~OO ~OO ~OO ~OO ~OO ~oo ~OO ~OO ~OO 1,946 ~OO ~OO ~OO ~OO Actual expense 240,738 14,564 7,877 27,688 790 1,235 1,270 CurrentVariance 60,000 (738) 110,436 54,623 (224,324) 15,001 14,210 13,765 (42,974) 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 I I I'16()'02(0),0(0)0(0)~~~tl08:,~'~0~'1~~r1~0~28r,r08~8~0r~~~,I0,4,3'' 2~~~:~2~ci(~')0~~:~10~4r,8r8~8~3~:~~2'r8,r~'0~8r0~~~4lQ',8/4~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 c..> (J) c..n I'V *budget adjustment to lower program budget from $550K to Page 36 of 64 AUTODATE Cost Centers Actual expense CurrentVariance Cumm Variance Actual expense CurrentVariance Cumm Variance Actual expense CurrentVariance Cumm Variance Benzene Health Research Consortium Communications 4Q06 Financial Report o 1,841 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 c..> (J) c.n c..> Page 37 of 64 AUTODATE Cost Centers DRAFT Benzene Health Research Consortium Communications 4Q06 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) c..> (J) Page 38 of 64 AUTODATE c..n ..j:::o. Cost Centers DRAFT Benzene Health Research Consortium Communications 4Q06 Financial Report 1sl Olr. 2nd Olr. 3rd Olr. 4lh Olr. (J) I m r r sI : () () r C ;a G) oI (J) c..> (J) Page 39 of 64 AUTODATE c..n c..n Benzene Health Research Consortium Legal 4Q06 Financial Report * budget adjustment to lower program budget from $500K to $1 OOK, as approved by OC on 11 III 103 LT 8/3/05 RT2I15/07 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) c..> (J) Page 40 of 64 c.n (J) AUTODATE Benzene Health Research Consortium Legal 4Q06 Financial Report * budget adjustment to lower program budget from $500K to $1 OOK, as approved by OC on 11 III 103 LT 8/3/05 RT2I15/07 (J) I m r r sI : () () r C ;a G) oI (J) c..> (J) c.n -.....J Page 41 of 64 AUTODATE Actual expense CurrentVariance Cumm Variance Actual expense CurrentVariance Benzene Health Research Consortium QA-QC 4Q06 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 c..> (J) c..n ex> DRAFT Page 42 of 64 AUTODATE Actual expense CurrentVariance Cumm Variance Actual expense CurrentVariance Benzene Health Research Consortium QA-QC 4Q06 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 c..> (J) c..n <D Page 43 of 64 AUTODATE RT 2115/07 Benzene Health Research Consortium QA-QC 4Q06 Financial Report 1sl Olr. 2nd Olr. 3rd Olr. 1sl Olr. 2nd Olr. 3rd Olr. 4lh Olr. I 1sl Olr. 2nd Olr. 3rd Olr. 1sl Olr. 2nd Olr. (J) I m r r sI : () () r C ;a G) oI (J) c..> (J) Page 44 of 64 AUTODATE (J) o I rQC7 co:enters 3rd Olr. RT 2115/07 II TOTALS 4lh Olr. Benzene Health Research Consortium QA-QC 4Q06 Financial Report (J) I m r r sI : () () r C ;a G) oI (J) c..> (J) Page 45 of 64 AUTODATE (J) .....lo. 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) c..> (J) (J) I'V DRAFT Benzene Health Research Consortium API Administration 4Q06 Financial Report Page 46 of 64 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) c..> (J) (J) c..> Benzene Health Research Consortium API Administration 4Q06 Financial Report Page 47 of 64 AUTODATE API Cost Centers RT 2115/07 Miii.&'M@~f:iiii.#ims.@!.i.'%MffuW~I~i:iir Benzene Health Research Consortium API Administration 4Q06 Financial Report 2003 1st & 2nd Otr. 3rd Otr. 4th Otr. 1st Otr. 2004 2nd Otr. 3rd Otr. 4th Otr. 2005 1st Otr. 2nd Otr. budgeted expenses revised to reflect 3 May 05 revised total program budget 3rd Otr. 4th Otr. 1st Otr. 201 2nd Otr. (J) I m r r sI : () () r C ;a G) oI (J) c..> (J) Page 48 of 64 AUTODATE (J) ..j:::o. Cost Centers RT 2115/07 Miii.&'M@~f:iiii.#ims.@!.i.'%MffuW~I~i:iir Benzene Health Research Consortium API Administration 4Q06 Financial Report (J) I m r r sI : () () r C ;a G) oI (J) c..> (J) Page 49 of 64 AUTODATE (J) c..n Benzene Health Research Consortium Exposure Assess 4Q06 Financial Report rdw 10/19/06 RT 2/15/07 (J) I m r r sI : () () r C ;a G) oI (J) c..> (J) (J) (J) 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 156,391 156,391 156,391 897,440 897,440 897,440 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) c..> (J) (J) -.....J DRAFT 4003 Adjustment - per Technical Committee, transfer $48,839 from UCHSC expense detail to contingency because expenses not part of UCHSC grant budget: Page 51 of 64 854,988 AUTODATE Benzene Health Research Consortium Contingency Fund 3006 Financial Report (J) I m r r sI : () () r C ;a G) oI (J) Page 52 of 64 AUTODATE c..> (J) (J) ex> 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 53 of 64 c..> (J) (J) <D 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:( "<t (0 '0 "<t L() 0) Ol CO D.... SH ELL-MCCLU RG-063670 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 55 of 64 AUTODATE c..> (J) -.....J --lo. Benzene Health Research Consortium Income 3006 Financial Reoort I:::INCOME}:':':,',',',, . Sponsor Payments API Interest UCHSC Interest I::TOTALS:::::':'''',',,,, Reporting Period Cumulative 60,246 2,173,378 1 10,540,824 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 rdw 10/1 9/06 RT 2115/07 DRAFT (J) I m r r sI : () () r C ;a G) oI (J) Page 56 of 64 AUTODATE c..> (J) -.....J I'V 23,698,294 (J) I m r r sI : () () r C ;a G) oI (J) V> (J) -....J V> Page 57 of 64 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 Inv, # Date Paid $1,344,069 535033 11-0ct-02 $112,008 2-0ct-02 2003 23-Sep-03 Inv,# $1,431,041.00 544951 l,;nevron ~l ::>,UUUI ::><'<'8<';:11 (-I\JOV-UU ~::><'<',b<'{ ::><'8;:1U<'1 8-UCI-Ul ~::>0f,b<'{ ::>;:1<'<'441 <,<,-reD-u<'1 ~tl8b,U4bl ::>;:I::>U;:I41 ::>-I\JOV-U<'I ~l ,U<'tl,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 535037 $448,023 $448,023 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 ~t"' inv date Inv, # ~U.UU Projected Invoicing Amendment No, 3 2007 Date Paid inv date Inv, # ~U.UU Date Paid Projected TOTALS ;j;/.u\)!!,~qtl l,;hevron ~lJll ,lJ::>8 ::>/::>U44 lU-UCI-Vb $4;:1::>,UI1 ::>15110<' $4,712,364 (J) ConocoPhillips $308,182 575045 19-Jun-06 $0.00 $2,356,18:1 I m ExxonMobii r r s:I () Shell () r C ;a Marathon $1,093,939 575042 31-May-06 $652,606 581763 28-Feb-0/ $7,068,541l $400,000 571301 $511,959 575043 3-Mar-06 2-Jun-06 $0 $435,071 $0 31-Jan-07 $4,712,364 $215,000 G) oI (J) c..> Page 58 of 64 (J) -.....J ..j:::o. AUTODATE Benzene Health Research Consortium 26133 25859 (J) 274 I m r r sI : () () r C ;a G) oI (J) c..> Page 59 of 64 AUTODATE (J) c-......n.J IT_'A' LT 8/18/05 RT 7/19/06 _xl....."..,''i'l'S"iv!',v.... DRAFT Benzene Health Research Consortium Sponsor Invoice Detail 3Q06 Financial Report . .1;1,E5W22" ,.7,A4D8! ! ! "Wi!' .."" RXJ (J) I m r r s: () () r C ;a G) o (J) c..> Page 60 of 64 AUTODATE (J) -.....J (J) Benzene Health Research Consortium Sponsor Payment Detail 3006 Financial Report (J) I m r r sI : () () r C ;a G) oI (J) c..> (J) Page 61 of 64 AUTODATE -.....J -.....J Benzene Health Research Consortium Sponsor Payment Detail 3006 Financial Report LT 8/3/05 RT 7/19/06 DRAFT (note - does not include interest income) $24,610,253.09 (J) I m r r sI : () () r C ;a G) oI (J) c..> (J) Page 62 of 64 AUTODATE -.....J ex> BHRC Sponsor Payments r. ."". d by Sponsor Company Company Date Paid Amount American Petroleum Institute 1/17/2003 $ (I am trying to get this $1.09 1.09 I emoved from the books) BP International Limited 11/8/2000 $ 15,000.00 BP International Ltd 6/19/2001 $ 22,500.00 BP p.Lc. 10/4/2001 $ 768,941.00 BP p.Lc. 2/22/2002 $ 806,441.00 BP p.Lc. BP p.Lc. 10/2/2002 $ 112,008.00 10/11/2002 $ 1,344,069.00 BP p.Lc. BP p.Lc. 12/4/2003 $ 1,431,041.00 7/11/2005 $ 2,568,545.00 $ BP Total 7,068,545.00 Chev ronTexaco Chev ronTexaco Chev ronTexaco Chev ronTexaco Chev ronTexaco 11/7/2000 $ 10/9/2001 $ 2/22/2002 $ 11/5/2002 $ 11/19/2003 $ 15,000.00 522,627.00 537,627.00 896,046.00 1,028,700.00 Chev ronTexaco Chevron 7/19/2005 $ 365,334.00 ChevronTexaco Total 10/10/2006 $ 911,959.00 $ 4,277,293.00 ConocoPhillips 10/31/2000 $ 15,000.00 ConocoPhillips 7/31/2001 $ 7,500.00 ConocoPhillips 9/17/2001 $ 246,314.00 ConocoPhillips 1/16/2002 $ 268,814.00 ConocoPhillips 9/26/2002 $ 448,023.00 ConocoPhillips 10/27/2003 $ 514,349.00 ConocoPhillips Total ConocoPhillips ConocoPhillips 3/18/2005 $ 548,000.00 6/19/2006 $ 308,182.00 $ 2,356,182.00 ExxonMobil Research and Engineering 1/23/2002 $ 806,441.00 ExxonMobil Research and Engineering ExxonMobil 2/11/2002 $ 806,441.00 9/13/2002 $ 1,344,069.00 ExxonMobil 10/3/2003 $ 771,524.50 (J) I ExxonMobil 3/22/2004 $ 771,524.50 ExxonMobil Total m ExxonMobil 2/17/2005 $ 548,000.00 r r ExxonMobil 12/27/2005 $ 274,000.00 s:I ExxonMobil 5/31/2006 $ 1,093,939.00 $ 6,415,939.00 () Marathon Ashland Petroleum, LLC. 8/14/2001 $ 15,000.00 () Marathon Ashland Petroleum, LLC. 1/20/2004 $ 150,000.00 Marathon Ashland Total r C Marathon Oil Company 2/3/2004 $ 50,000.00 $ 215,000.00 ;a G) oI (J) Page 63 of 64 c..> (J) -.....J <D AUTO DATE Shell Chem ical Shell Chem ical Shell Chem ical Shell Chem ical Shell Chem ical Shell Chem ical Shell Chem ical Shell Chem ical Shell Chem ical Shell Chem ical Shell Chem ical LT 8/3/05 RT 7/19/06 10/24/2000 $ BHRC Sponsor Payments r. d by Sponsor Company 15,uuo.uu 5/15/2001 $ 15,000.00 9/25/2001 $ 507,627.00 2/7/2002 $ 537,627.00 9/25/2002 $ 448,023.00 2/10/2003 $ 448,023.00 10/28/2003 $ 514,350.00 1/13/2004 $ 514,350.00 Shell Chem ical Total 4/28/2005 $ 365,334.00 3/3/2006 $ 400,000.00 6/2/2006 $ 511,959.00 $ 4,277,293.00 $ 24,610,253.09 DRAFT (J) I m r r sI : () () r C ;a G) oI (J) Page 64 of 64 AUTODATE c..> (J) oex>