Document N2j2dqdq8r2vjQRvyQpV7RKYw

From: Sent: To: Cc: Subject: Attach: Russell White <whiter@api.org> Tuesday, August 14, 2007 6:43 PM (GMT) BenzConsort-OC@listserve.api.org BenzConsort-TC@listserve.api.org; BHRC Communications Committee <benzconsortcc@listserve.api.org> Shanghai Health Study - 2Q budget BHRC Program Expenses 2Q07 rpt - DRAFT.xls Oversight Committee, Attached is the Shanghai Health Study budget through the second quarter of 2007. It reflects the new contracts with BHRC member companies, Cinpathogen, and the University of Colorado. The budget subteam looked it over last week. If you have comments or questions please contact me. I can make any corrections necessary before the next scheduled OC call on September 13. BHRC Program Expenses 2Q07 rpt - DRAFT.xls Russell White Regulatory and Scientific Affairs American Petroleum Institute 1220 L Street NW Washington, DC 20005-4070 Tel: 202-682-8344 Fax: 202-682-8270 SH ELL-MCCLU RG-053855 Benzene Health Research Consortium 2Q07 Financial Report Overview A IB CI D I E I F IGIH I J K LM 1 2 3 EXPENSE DISCUSSION: 4 Fund Balance at API 2Q07: 5 Fund Balance in spreadsheet 2Q07: $ 5,040,459 $ 5,040,458 DRAFT 6 7 8 9 Irons Field Expenses: No funds disbursed in 2Q07 because of high balance unspent. 10 UCHSC: $0 disbursed in 2Q07 11 AHS: $173,693 spent in 2Q07 12 Fudan University: No activity 13 SRP/ERP: $7,875 spent in 2Q07. 14 Communications: No activity in 2Q07 15 Outside Legal Council: $24,224 spent in 2Q07 (Budget increased $40,000 from contingency.) 16 QAlQC: $5,190 spent in 2Q07 17 Contingency: $1,414,201 remains uncommitted 18 API Administrative Costs: $37,472 spent in 2Q07 19 Revenue: $3,166,408 in 2Q07 ($3,119,412 Sponsor payments; $46,996 Interest income) 20 21 22 FORWARD GUIDANCE: 23 Executive Summarll: 24 25 26 27 Technical Budget Work Group Acceptance: 28 Oversight Committee Acceptance: 29 Posted to Website: 30 31 32 LT 8/24/05 33 BJ 11/29/05 34 ROW 611/07 35 RT 8/1/2007 Page 1 of45 &[DATE] SH ELL-MCCLU RG-053856 A 1 2 Item 3 AHSciences Case-Control Study 4 DP & ME Studies (UCHSC) 5 Irons(T & E) 6 Fudan University 7 Cinpathogen 8 9 Scientific Review Panel 10 Ethics Review Panel 11 External Pathology & Cytogenetics Workgroups(Cost in UC cost) 12 Exposure Assessment 13 14 API Seed Monies 15 Outside Counsel 16 Communications 17 QAJQC Activities 18 UCHSC Interest 19 Committed funds 20 Contingency 21 22 23 24 GRAND TOTAL 25 Cummulative Interest Earned 26 27 Notes by API 28 Notes/Assumptions for Dec. 2001 revised budget: 29 30 31 32 33 34 LT 7/24/05 35 RDW 7/27/06 36 rdw 10/19/06 37 rdw 3/12/07 Benzene Health Research Consortium Approved Program Budget 2Q07 Financial Report B Total Research Costs CD Approved Original Cost Revised Cost Estimate (Jan. Estimate (Dec. 2001) 2001) 1,595,000 2,283,095 13,665,017 15,258,017 1,253,428 165,700 - 1,253,428 190,555 - 16,679,145 18,985,095 648,000 216,000 130,000 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 - Total Panel Costs 450,000 500,000 1,000,000 994,000 - 500,000 1,000,000 225,000 743,736 - 100,576 960,600 100,000 Miscellaneous Costs Subtotal API Admin. 190,855 - 1,690,855 1,725,000 18,820,000 21,704,095 941,000 1,085,205 $ 19,761,000 $ 22,789,300 $ - 1,161,176 21,704,280 1,085,019 22,789,299 - 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 2 of45 &[DATE] SH ELL-MCCLU RG-053857 Benzene Health Research Consortium Approved Program Budget 2Q07 Financial Report F 1 Approved G Approved H Approved I Approved J Approved K Approved L Approved M Approved 2 11 NOV 03 OC mtg 3 2,283,095 4 14,508,000 5 1,413,428 6 230,000 7- 8 18,434,523 9 300,000 10 64,000 11 - 12 13 364,000 14 - 15 100,000 16 550,000 17 100,000 18 (100,000) 19 20 390,272 21 1,040,272 22 19,838,795 23 1,245,205 24 $ 21,084,000 25 26 27 28 3 May 05 revised budget notes 29 - $423 added to contingency to round total budget to nearest thousand 30 - increased API administrative costs for one extra year (2007) 31 32 33 34 35 36 37 21 APR 04 OC mtg 2,283,095 14,508,000 1,413,428 230,000 - 18,434,523 300,000 64,000 - 364,000 - 100,000 550,000 100,000 - 290,272 1,040,272 19,838,795 1,245,205 $ 21,084,000 16 Dec 04 OC mtg 2,283,095 14,508,000 1,413,428 230,000 - 18,434,523 300,000 64,000 - 364,000 - 100,000 300,000 50,000 - 590,272 1,040,272 19,838,795 1,245,205 $ 21,084,000 3 May 05 OC mtg 2,930,841 18,332,769 1,413,428 306,062 - 22,983,100 300,000 64,000 - 364,000 - 140,000 300,000 50,000 - 156,391 694,304 1,340,695 24,687,795 1,445,205 $ 26,133,000 21 Aug 06 OC mtg 2,930,841 18,332,769 1,413,428 306,062 - 22,983,100 346,950 126,192 - 109,000 582,142 - 140,000 300,000 50,000 - 156,391 476,162 1,122,553 24,687,795 1,445,205 $ 26,133,000 208,347 20 Sept 06 OC mtg 2,930,841 18,332,769 1,413,428 379,829 - 23,056,867 346,950 126,192 - 109,000 582,142 - 140,000 300,000 50,000 - 156,391 402,395 1,048,786 24,687,795 1,445,205 $ 26,133,000 240,121 08 March 07 OC mtg 2,930,841 18,332,769 1,413,428 379,829 - 23,056,867 346,950 126,192 - 109,000 582,142 - 180,000 300,000 50,000 - 156,391 362,395 1,048,786 24,687,795 1,445,205 $ 26,133,000 296,202 21-Jun-07 3,819,119 20,045,469 1,413,428 444,829 4,847,740 30,570,585 446,950 166,192 - 109,000 722,142 - 245,000 500,000 200,000 - 156,391 1,227,395 2,328,786 33,621,513 1,609,629 $ 35,231,142 343,198 Page 3 of45 &[DATE] SH ELL-MCCLU RG-053858 Benzene Health Research Consortium Executive Summary 2Q07 Financial Report AB 1 2 3 4 5 6 7 Cost Centers Project # 8 9 Income 10 11 Cost Centers 12 UCHSC* 13 Irons-Field Expense* X8105 X8106 14 Applied Health Sciences X8107 15 Fudan University X8108 16 Scientific & Ethics Panels X8109 17 Communications X8103 18 Outside Legal Counsel X8104 19 QAJQC Support X8110 20 API Administrative X8100 21 Exposure Assessment x8111 22 Cinpathogen x8112 23 Committed Contingency 24 Uncommitted Contingency 25 Total Expenses 26 27 Fund Balance 28 29 30 blue is projected fund balanced to project 31 * amount disbursed by API ~ ~ 34 35 36 37 LT 8/3/05 38 RW 2/20/06 DRAFT 39 RT 7/19/06 40 rdw 10/19/06 41 42 43 C DEF G Actuals Inception Thru December 2004 Actuals Jan - Dec 2005 Actuals Jan - Dec 2006 ACTUALS ACTUALS Jan - June 2007 ACTUALS Program to Date $ 16,765,693 $ 5,206,657 $ 6,938,163 $ 3,166,408 $ 32,076,921 10,137,850 788,486 1,391,014 124,090 181,713 294,161 64,529 - 856,208 - 104,473 $ 13,942,525 3,624,030 262,000 548,720 4,007 76,176 - 33,706 - 170,475 - 51,918 $ 4,771,033 4,000,000 262,000 558,214 76,377 95,418 - 39,154 1,202 160,782 12,324 - $ 5,205,472 570,889 55,000 286,252 - 11,850 - 38,115 5,246 68,214 21,322 2,100,000 - $ 3,156,888 18,332,769 1,367,486 2,784,201 204,474 365,158 294,161 175,505 6,448 1,255,679 33,646 2,100,000 156,391 - $ 27,075,918 $ 2,823,169 $ 3,298,247 $ 5,030,938 $ 9,520 $ 5,040,458 H I J KL M N PROJECTED 2007 Jan - June $- PROJECTED PROJECTED 2007 Jan - Dec $ 4,226,212 13,778,460 990,282 570,889 100,942 320,584 - 9,000 - 35,622 54,292 94,000 60,000 2,100,000 - $ 3,345,329 1,570,889 100,942 641,168 99,995 96,726 1,946 71,242 100,000 225,450 69,000 3,375,000 - $ 6,352,358 sponsors MAP contrib. API interest UCHSC interest TOTAL I Uncom contin & interest spent as of 2Q07 Remaining Page 4 of 45 &[DATE] SH ELL-MCCLU RG-053859 0 PQ R 1 2 3 BUDGET 4 5 PROJECTED PROJECTED 6 2008 End of Program 7 Jan - Dec Project Budget 8 Income 9 $ 2,457,615 35,609,340 $ 35,231,142 10 11 Ex[!enses 12 712,700 13 - 20,045,469 1,367,486 20,045,469 1,413,428 14 703,504 3,808,289 3,819,119 15 45,441 349,910 444,829 16 140,000 592,884 613,142 17 200,000 496,107 500,000 18 33,875 245,000 245,000 19 100,000 152,156 200,000 20 164,424 21 - 1,551,553 42,646 1,609,629 109,000 22 1,472,740 23 24 - 4,847,740 156,391 1,414,201 4,847,740 156,391 1,227,395 25 $ 3,572,684 $ 35,069,832 $ 35,231,142 26 27 $ 539,507 28 29 30 31 32 come Detail 33 31,518,724 34 $215,000 35 266,996 36 76,202 37 38 $32,076,921 39 40 nitted Contingency 41 1,570,593 42 156,391 43 1,414,201 Benzene Health Research Consortium Executive Summary 2Q07 Financial Report Page 5 of 45 &[DATE] SH ELL-MCCLU RG-053860 Benzene Health Research Consortium Cash Flow Statement 2Q07 Financial Report A INCOME "I Income for Reporting Period Income, Cumulative ~ EXPENSE Actual Expenses Expense, Cumulative 2 INCOME LESS EXPENSE ~ Reporting Period Cumulative ~ 14 blue designates projected income or expense 16 LT 8123/05 17 RT 7/19/06 B 2000 1st-4thQtr. C 2001 1st-4thQtr. D 2002 1st-4thQtr. E 1st&2nd Qtr. F 2003 3rd Qtr. G 4thQtr. 60,246 60,246 2,113,132 2,173,378 8,367,446 10,540,824 448,024 10,988,848 3,186 10,992,034 4,265,241 15,257,275 24,600 24,600 1,577,811 1,602,411 7,652,678 9,255,088 318,759 9,573,847 258,097 9,831,945 310,244 10,142,189 35,646 35,646 535,321 570,967 714,768 1,285,736 129,265 1,415,001 (254,911) 1,160,089 3,954,997 5,115,086 NOTE: 2,548,996 in bank at API This number does not agree with the executive summary because it is based on actuals, not disbursed funds. DRAFT 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 1,338,560 13,942,525 (1,329,268) 2,823,169 L 1stQtr. 1,096,000 17,861,693 247,035 14,189,560 848,965 3,672,133 $372,143 M 2nd Qtr. 2005 N 3rd Qtr. 372,143 18,233,836 3,009,787 21,243,623 1,063,761 15,253,321 318,580 15,571,901 (691,618) 2,980,515 2,691,207 5,671,722 0 4thQtr. 728,727 21,972,350 3,102,202 18,674,103 (2,373,475) 3,298,247 P 1stQtr. 21,972,350 156,494 18,830,597 (156,494) 3,141,753 Q 2nd Qtr. 2006 R 3rd Qtr. 1,934,291 23,906,641 31,774 23,938,415 2,527,048 21,357,645 327,707 21,685,352 (592,757) 2,548,996 (295,933) 2,253,064 6of45 &[DATE] SHELL-MCCLURG-053861 "I ~ 2 ~ ~ 14 16 17 S 4thQtr. 4,972,098 28,910,513 2,205,983 23,891,335 2,766,115 5,019,179 T 1stQtr. 28,910,513 165,806 24,057,141 (165,806) 4,853,373 U 2nd Qtr. 2007 V 3rd Qtr. 3,166,408 32,076,921 1,039,804 33,116,725 2,365,193 26,422,334 26,422,334 801,215 5,654,588 1,039,804 6,694,392 W 4thQtr. 20,000 33,136,725 26,422,334 20,000 6,714,392 X TOTALS 33,136,725 26,422,334 Benzene Health Research Consortium Cash Flow Statement 2Q07 Financial Report 7of45 &[DATE] SH ELL-MCCLU RG-053862 Benzene Health Research Consortium Program Expense Summary 2Q07 Financial Report AB ~ ~ Iq ~ ~ I~ ~ L. L.. ~ ~ L.: L.I ...:. ~ L.: ')U ~ ~ .,)..J .)q ~ ~ .j~ ~ q q. ~ ~ q;:J qt: ~ ~ q::;l ::>U ~ ~ ;,:)..J ::>q ~ ~ ::>~ ~ Cost Centers UCHSC Disbursed Budgeted Actual expense CurrentVariance Cumm Variance Irons - Field Expenses Disbursed Budgeted Actual expense CurrentVariance Cumm Variance Applied Health Sciences Budgeted Actual expense CurrentVariance Cumm Variance Fudan University - Case/Control Study Budgeted Actual expense CurrentVariance Cumm Variance Scientific & Ethics Panels/cyto wkshop Budgeted Actual expense CurrentVariance Cumm Variance Communications - APCO Budgeted Actual expense CurrentVariance Cumm Variance Outside Legal Counsel Budgeted Actual expense CurrentVariance Cumm Variance QAlQC Support Budgeted Actual expense CurrentVariance Cumm Variance Exposure Assessment Budgeted Actual expense CurrentVariance Cumm Variance Cinpathogen Budgeted Actual expense CurrentVariance Cumm Variance Contingency Funds Budgeted Actual expense exp/committ uncommitted API Administrative and Overhead Budgeted Actual expense CurrentVariance Cumm Variance 2000 1st-4thQtr. 24,600 (24,600) (24,600) TOTALS Budgeted Actual expense CurrentVariance Cumm Variance CUMULATIVE TOTALS Budgeted Expense r,:J Variance 2000 2000 24,600 (24,600) (24,600) 24,600 (24,600) ~ Blue: future cumulative variance has no meaning until Expense entered. 75 LT 813/05 DRAFT ~ RT 7/19/06 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 2001 965,771 734,012 231,759 207,159 2001 965,771 758,612 207,159 2002 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 77 F 2003 3rd Qtr. 332,137 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 2003 393,874 312,479 81,394 1,319,642 2003 8,879,977 7,560,335 1,319,642 $21,078,410 21,314,021 ($235,610) G 4thQtr. (48,839) 2,039,466 553,672 1,485,794 1,813,804 H 1stQtr. 1,813,804 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) 55,508 43,945 11,563 24,598 98,340 98,340 98,497 7,288 7,288 88,713 (163,074) 500 (163,574) 15,001 15,001 14,999 4,175 365 3,810 3,810 6,250 6,250 6,250 101,473 101,473 75,934 88,655 (12,721) 10,305 66,700 65,154 1,546 11,851 1,773,965 1,082,361 691,604 2,011,246 10,653,942 8,642,696 2,011,246 90,188 109,964 (19,776) 1,991,470 10,744,130 8,752,660 1,991,470 2nd Qtr. 874,031 827,532 2,045,114 (1,217,582) 586,386 189,320 55,508 95,409 (39,901) (15,303) 98,340 168,623 (70,283) 28,215 7,288 27,755 (20,467) 68,246 3,000 12,029 (9,029) (9,029) 15,000 790 14,210 29,209 4,175 2,995 1,180 4,990 6,250 6,250 12,500 66,700 73,084 (6,384) 5,467 1,083,793 2,425,798 (1,342,006) 649,464 11,827,923 11,178,458 649,464 ''''~ 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 J 2004 3rd Qtr. 874,030 586,386 55,508 49,390 6,118 (9,185) 98,340 105,508 (7,168) 21,047 7,288 7,288 75,534 4,750 2,500 2,250 (6,779) 15,000 1,235 13,765 42,974 4,175 1,870 2,305 7,294 6,250 6,250 18,750 K 4thQtr. 874,030 827,532 1,535,622 (708,090) (131,540) 59,680 55,508 60,427 (4,919) (14,104) 98,340 164,991 (66,651) (45,604) 7,287 64,354 (57,067) 18,467 72,000 83,830 (11,830) (18,609) (41,704) 1,270 (42,974) L 1stQtr. (131,540) 131,000 55,508 55,508 41,404 110,467 70,316 40,151 (5,454) 18,467 1,500 1,500 (17,109) 4,175 26,092 (21,918) (14,623) (18,750) (18,750) 4,175 4,827 (653) (15,276) 4,167 4,167 4,167 72,700 61,988 10,712 16,179 2004 264,011 222,491 41,520 690,984 2004 12,091,933 11,400,949 690,984 3,000 3,000 3,496 50,296 64,400 61,312 (11,854) 4,325 29,280 37,396 (8,116) (3,791) 1,068,788 2,000,899 (932,111) (241,127) 13,160,721 13,401,848 (241,127) 205,096 116,035 89,061 (152,066) 13,365,817 13,517,883 (152,066) USHSC NOT updated for 2Q05 1,047,131 1,338,560 247,035 M 2nd Qtr. IN 2005 3rd Qtr. 874,030 1,940,413 1,787,329 153,084 140,914 140,914 55,508 110,927 (55,419) (14,015) 131,000 55,508 56,038 (530) (14,545) 203,034 123,114 79,920 79,920 133,792 132,925 867 80,787 40,281 40,281 40,281 40,281 1,000 2,500 (1,500) (18,609) 4,250 14,016 (9,766) (28,375) 7,811 16,769 (8,958) (8,958) 4,167 4,167 8,333 7,811 7,811 (1,147) 4,167 4,167 12,500 7,480 7,480 48,500 39,868 8,632 8,632 39,500 40,639 (1,139) 7,493 2005 2,300,714 245,027 2,087,987 243,618 212,727 1,409 60,660 62,070 2005 15,666,531 15,911,558 15,605,870 15,849,488 60,660 62,070 69,235 1,063,761 318,580 Page 8 of45 &[DATE] SH ELL-MCCLU RG-053863 I~ L. L.. ~ L. L.' ~ 75 o 4thQtr. 2,750,000 1,940,413 2,366,913 (426,500) (297,756) 55,508 61,875 (6,367) (20,912) 133,792 222,365 (88,573) (7,787) 40,282 4,007 36,275 76,556 70,000 59,660 10,340 (18,035) 1,946 1,946 1,946 7,811 12,110 (4,299) (5,446) 4,167 4,167 16,667 1,200 288 63,500 52,572 10,928 18,421 2,317,419 2,780,990 (463,571) (401,502) 18,228,977 18,630,479 (401,502) p IQI RIs 2006 1stQtr. 2nd Qtr. 3rd Qtr. 4thQtr. (297,756) 2,000,000 1,906,001 2,298,332 (392,331) (701,049) (701,049) 2,000,000 1,906,001 1,863,525 42,476 (669,655) 131,000 55,508 43,488 12,020 (8,891) 55,508 68,415 (12,907) (21,798) 55,507 55,507 33,709 131,000 55,507 55,507 89,216 136,988 73,855 63,133 55,347 136,988 111,422 25,566 80,913 136,988 141,140 (4,152) 76,761 136,988 231,797 (94,809) (18,048) 76,556 47,236 47,236 123,792 76,377 (76,377) 47,415 47,236 47,236 94,651 3,823 2,800 1,023 (17,012) 1,000 4,800 (3,800) (20,812) 83,226 58,047 25,179 4,367 4,500 29,771 (25,271) (20,905) 1,946 1,946 1,946 1,946 1,946 3,893 7,811 5,776 2,035 (3,411) 7,811 6,084 1,727 (1,684) 7,811 1,846 5,965 4,281 7,811 25,448 (17,637) (13,356) 4,167 4,167 20,833 4,167 4,167 25,000 4,167 4,167 29,167 4,167 1,202 2,964 32,131 40,000 12,324 27,676 27,676 40,500 30,576 9,924 28,345 248,797 156,494 92,303 (309,199) 18,477,774 18,786,972 (309,199) 35,000 37,995 (2,995) 25,351 46,000 50,296 (4,296) 21,054 2006 2,193,711 333,699 2,527,048 327,707 (333,337) 5,992 (642,536) (636,544) 2006 20,671,485 21,005,184 21,314,021 21,641,727 (642,536) (636,544) 42,000 41,916 84 21,139 2,246,156 2,205,983 40,173 (596,371) 23,251,340 23,847,710 (596,371) Benzene Health Research Consortium Program Expense Summary 2Q07 Financial Report T I uI v Iw 2007 1stQtr. 2nd Qtr. 3rd Qtr. 4thQtr. 570,889 570,889 1,000,000 (669,655) 507,861 (165,855) (165,855) 507,862 337,946 55,507 55,000 55,507 55,507 55,507 55,507 144,723 55,507 200,230 55,507 255,737 55,507 311,244 160,292 112,560 47,732 29,684 160,292 173,692 (13,400) 16,284 160,292 160,292 176,576 160,292 160,292 336,868 50,000 50,000 94,651 50,000 144,651 144,651 50,000 194,651 4,500 3,975 525 (20,380) 4,500 7,875 (3,375) (23,755) 83,226 83,226 59,471 4,500 4,500 63,971 1,946 3,893 3,893 3,893 1,946 5,839 17,811 13,891 3,920 (9,436) 17,811 24,224 (6,413) (15,849) 17,810 17,810 1,961 17,810 17,810 19,771 4,167 56 4,111 36,242 4,167 5,190 (1,023) 35,219 4,167 4,167 39,385 4,167 4,167 43,552 30,000 4,583 25,417 53,093 30,000 16,739 13,261 66,354 9,000 9,000 75,354 75,354 2,100,000 2,100,000 1,275,000 1,275,000 1,275,000 x 1stQtr. 175,876 y 2008 2nd Qtr. 712,000 175,876 z 3rd Qtr. 175,876 AA 4thQtr. 175,876 47,000 30,741 16,259 37,397 890,166 165,806 724,360 127,989 24,141,505 24,013,516 127,989 47,000 37,472 9,528 46,925 72,000 72,000 118,925 2007 2,469,277 2,365,193 104,084 232,073 2007 26,610,782 26,378,710 232,073 1,402,002 1,402,002 1,634,074 28,012,784 26,378,710 1,634,074 59,450 59,450 178,375 1,628,672 1,628,672 3,262,746 29,641,456 26,378,710 3,262,746 AS TOTALS 18,332,769 19,518,488 17,940,317 507,862 392,452 1,367,486 1,413,428 1,102,184 89,216 311,244 3,819,119 2,784,201 160,292 1,034,919 439,126 204,474 50,000 234,651 473,143 365,158 4,500 63,971 300,000 294,161 3,893 5,839 180,000 175,505 4,495 4,495 50,000 6,448 43,552 43,552 109,000 33,646 75,354 75,354 3,375,000 2,100,000 1,275,000 1,275,000 850,695 116,649 162,537 688,158 1,445,205 923,832 450,028 178,375 28,489,203 23,946,574 3,262,746 4,542,629 28,489,203 26,378,710 2,110,494 77 '''' 3,102,202 244,006 2,160,301 327,707 2,473,458 736,695 2,420,193 24,604,328 Page 9 of45 &[DATE] SH ELL-MCCLU RG-053864 Benzene Health Research Consortium UCHSC Grant 2Q07 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 ..J"t Cumm Variance UCHSC (x81 05) Cost Centers Budgeted ~ Actual expense ~ CurrentVariance ..)::;1 Cumm Variance "+U CUMULATIVE TOTALS ~ Budgeted ~ "+..) Expense Variance TOTALS ~ Blue: future cumulative variance has no meaning until Expense entered. ~ LT8/02/05 ~ BJ8/02/05 "+::;1 RT7/19/06 50 51 DRAFT 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 918,645 899,642 19,003 19,003 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: $13,761,880 $13,778,460 ($16,580) Page 10 of45 &[DATE] SH ELL-MCCLU RG-053865 Benzene Health Research Consortium UCHSC Grant 2Q07 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" 50 51 (124,915) 117,417 596,441 26,294 (255,505) (1,301) 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 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. 874,031 109,904 195,778 211,016 (15,238) 94,666 225,763 195,773 364,542 (168,769) 56,994 1,019,304 286,990 1,128,507 (841,517) 177,787 9,836 30,421 9,836 40,257 369,063 48,050 192,340 (144,290) 224,773 89,770 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) 3rd Qtr. 874,030 94,666 56,994 177,787 40,257 224,773 32,166 586,386 8,715,239 8,088,596 626,643 Page 11 of45 &[DATE] SH ELL-MCCLU RG-053866 "I 2 ~ ~ ~ ~ ~ ~ L' -. L L"I ~ ~ L L, ~~ ~ ..~",,;;) ~ ~,," "IU ~ .~" ~ "I;;) "It ~ ~ "I" 50 51 J 4thQtr. 874,030 195,778 229,260 (33,482) 61,184 195,773 237,258 (41,485) 15,509 286,990 948,696 (661,706) (483,919) 9,836 9,836 50,093 48,050 48,050 272,823 91,105 120,408 (29,303) 2,863 827,532 1,535,622 (708,090) (131,540) 9,542,771 9,624,218 (81,447) K 1stQtr. 61,184 15,509 (483,919) 50,093 272,823 2,863 (131,540) 9,542,771 9,624,218 (81,447) L 2005 2nd Qtr. 2005 2005 2Q05 - variance adjusted to reflect only current qtr variance 2Q05 - bedgeted expense projections revised per 3 May 05 revised program budget Benzene Health Research Consortium UCHSC Grant 2Q07 Financial Report M 874,030 219,087 235,437 (16,350) (16,350) 219,087 104,457 114,630 114,630 1,331,839 1,359,314 (27,475) (27,475) 12,170 12,170 12,170 54,772 54,772 54,772 103,458 88,121 15,337 15,337 3rd Qtr. (16,350) 114,630 (27,475) 12,170 54,772 15,337 1,940,413 1,787,329 153,084 140,914 11,483,184 11,411,547 71,637 140,914 11,483,184 11,411,547 71,637 N 4thQtr. 2,750,000 219,087 243,816 (24,729) (41,079) 219,087 227,940 (8,853) 105,777 1,331,839 1,773,364 (441,525) (469,000) 12,170 12,170 24,340 54,772 54,772 109,544 103,458 121,793 (18,335) (2,998) 1,940,413 2,366,913 (426,500) (297,756) 13,423,597 13,778,460 (354,863) 0 1stQtr. (41,079) 105,777 (469,000) 24,340 109,544 (2,998) (297,756) 13,423,597 13,778,460 (354,863) P 2nd Qtr. 2006 Q 3rd Qtr. 2,000,000 199,472 227,105 (27,633) (68,712) (68,712) 199,472 267,828 (68,356) 37,421 37,421 1,351,912 1,675,638 (323,726) (792,726) (792,726) 11,082 120 10,962 35,302 35,302 49,868 49,868 159,412 159,412 94,195 127,641 (33,446) (36,444) (36,444) 2006 1,906,001 2,298,332 (392,331) (701,049) 2006 15,329,598 16,076,792 (747,194) (701,049) 15,329,598 16,076,792 (747,194) R 4thQtr. 2,000,000 199,472 231,096 (31,624) (100,336) 199,472 245,256 (45,784) (8,363) 1,351,912 1,263,321 88,591 (704,135) 11,082 11,082 46,384 49,868 49,868 209,280 94,195 123,852 (29,657) (66,101) 1,906,001 1,863,525 42,476 (669,655) 17,235,599 17,940,317 (704,718) S 1stQtr. 570,889 (100,336) (8,363) (704,135) 46,384 209,280 (66,101) (669,655) 17,235,599 17,940,317 (704,718) T 2007 2nd Qtr. U 3rd Qtr. 1,000,000 73,107 73,107 (27,229) (27,229) 73,101 73,101 64,738 64,738 304,797 304,797 (399,338) (399,338) 4,061 4,061 50,445 50,445 18,275 18,275 227,555 227,555 34,520 34,520 (31,581) 2007 507,861 (31,581) 507,861 (165,855) 2007 17,743,460 17,940,317 (196,857) (165,855) 17,743,460 17,940,317 (196,857) V 4thQtr. W 1stQtr. 73,107 73,107 45,878 73,101 73,101 137,839 304,798 304,798 (94,540) 4,061 4,061 54,506 18,275 18,275 245,830 34,520 34,520 2,939 507,862 507,862 337,946 21,107,402 17,940,317 3,167,085 X 2008 2nd Qtr. Y 3rd Qtr. 712,700 Page 12 of45 &[DATE] SH ELL-MCCLU RG-053867 Z 4thQtr. "I 2 ~ ~ ~ ~ ~ ~ L' -. L L"I ~ ~ L L, ~~ ~ ~ ",,;';") ~ ~,," "IU ~ ~ "''' ~ "I;;) "It ~ ~ "I" 50 51 AA TOTALS AS 20,045,469 2,683,327 2,637,449 73,107 45,878 2,208,326 2,070,487 73,101 137,839 10,491,402 10,585,942 304,798 (94,540) 63,619 9,113 4,061 54,506 1,629,320 1,383,490 18,275 245,830 1,256,775 1,253,836 34,520 2,939 18,332,769 17,940,317 507,862 392,452 18,332,769 17,940,317 392,452 Benzene Health Research Consortium UCHSC Grant 2Q07 Financial Report Page 13 of45 &[DATE] SH ELL-MCCLU RG-053868 A 4 ~ !.. I "+ UCHSC Subcontracts Fudan University Actual expense IPHSC Actual expense SMCDCP Actual expense EMBSI Actual expense Children's Hospital Cincinnati Actual expense TOTALS Actual expense 15 16 LT 813/2005 I t1 BJ 8/02/05 RT 7/19/06 Benzene Health Research Consortium UCHSC Subcontract 2Q07 Financial Report B 2001 1st-4thQtr. 2001 DRAFT "Total subcontractor 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 C 2002 1st-4thQtr. D IE 2003 1st&2nd Qtr. F 3rd & 4th Qtr. G H III J 2004 1st&2nd Qtr. 3rd & 4th Qtr. KI L 1st&2nd Qtr. 411,935 468,341 1,088,352 880,342 760,876 8,339 27,496 7,683 45,563 24,766 2,500 372,725 547,863 2002 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 50,575 1,359,314 Page 14 of 45 &[DATE] SH ELL-MCCLU RG-053869 Benzene Health Research Consortium UCHSC Subcontract 2Q07 Financial Report M1N 2005 bdgted '05 3rd & 4th Qtr. 01 P 1st&2nd Qtr. Q1R 2006 bdgted '06 3rd & 4th Qtr. SI T 1 U 2007 1st & 2nd Qtr. bdgted '07 V 3rd & 4th Qtr. 4 1,676,855 540,271 971,463 1,651,285 754,319 159,600 12,000 124,059 2,500 -"'862,823 80,175 952,967 642,199 3,000 931,939 457,834 3,000 407,700 !. 112,000 2005 I .. 2,663,678 15 1331839 16 75,892 1,773,364 59,476 1,675,638 117,600 2006 2,703,824 1351912 51,168 1,263,321 39,295 2007 609,595 304797.5 1::1 W TOTALS** 9,363,639 182,077 159,004 5,176,050 656,897 16,563,039 Page 15 of 45 &[DATE] SH ELL-MCCLU RG-053870 Benzene Health Research Consortium Irons Field Expenses 2Q07 Financial Report A .q ~ ~ ~ ~ ~ ~ ~ I ::1 IRONS T&E (X81 06) Cost Centers Payments Disbursed Airfare & related expenses Budgeted Actual expense CurrentVariance Cumm Variance Apartment 1hotel & related expenses Budgeted Actual expense CurrentVariance Cumm Variance Other expenses e.g. taxi, limo, misc. Budgeted Actual expense CurrentVariance Cumm Variance L' ~ Budgeted Actual expense L.. CurrentVariance L.,q Cumm Variance ~ CUMULATIVE TOTALS ~ Budgeted L. Expense L.' Variance riO- Blue: future cumulative variance has no meaning until Expense entered. ",q LT 8124/05 ~ BJ8124/05 ~ RT8/112007 37 DRAFT B 2001 4thQtr. 2001 "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: RT: See comments in cells M22 and M23 C 2002 1st-4thQtr. D 1st&2nd Qtr. 145,763 393,723 1,280 1,606 (326) (326) 103,624 75,179 28,445 28,119 55,343 27,359 27,984 56,103 1,280 1,024 256 256 103,624 89,717 13,907 14,163 55,343 45,291 10,052 24,216 640 51,812 528 30,653 112 21,159 112 21,272 27,672 16,926 10,746 32017 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 E 3rd Qtr. 27,672 25,079 2,593 58,696 27,672 21,200 6,472 30,687 13,836 8,103 47,240 79,257 69,179 54,382 14,797 127,133 469,798 342,665 127,133 $919,486 numbers as of 6130105 $872,369 note - 1005 & 2005 expenses recprded in 2005 $47,117 Page 16 of45 &[DATE] SHELL-MCCLURG-053871 "I 2 ~ ~ ~ ~ ~ 2003 F 4thQtr. ~,::I L' -. L L"I ~ ~ L L, 2003 L 4Q03 ADJUSTMENT - 200112002 expense underrecorded; +$114,289 adjustment .)U ~ ~ .).) ,)"1 ~ ~ 37 Benzene Health Research Consortium Irons Field Expenses 2Q07 Financial Report G 1stQtr. HI 2004 2nd Qtr. 3rd Qtr. J 4thQtr. K 1stQtr. LM 2005 2nd Qtr. 3rd Qtr. N 4thQtr. 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 82,058 189,320 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 59,680 22,200 29,290 (7,090) 637 22,205 15,200 7,005 (55,985) 11,103 15,937 (4,834) 82751 131,000 22,200 22,200 22,837 22,205 22,205 (33,780) 11,103 11,103 93,854 22,200 52,969 (30,769) (7,932) 22,205 45,600 (23,395) (57,175) 11,103 12,358 (1,255) 92,599 131,000 22,200 22,913 (713) (8,645) 22,205 26,225 (4,020) (61,195) 11,103 6,900 4,203 96,802 22,200 21,130 1,070 (7,575) 22,205 22,800 (595) (61,790) 11,103 17,945 (6,842) 89,961 55,508 169,606 (114,098) 13,035 525,306 512,270 13,035 55,508 43,945 11,563 24,598 580,814 556,215 24,598 55,508 95,409 (39,901) (15,303) 2004 636,322 651,624 (15,303) 55,508 49,390 6,118 (9,185) 691,830 701,014 (9,185) 55,508 60,427 (4,919) (14,104) 747,338 761,442 (14,104) 55,508 55,508 41,404 802,846 761,442 41,404 55,508 110,927 (55,419) (14,015) 2005 858,354 872,369 (14,015) 55,508 56,038 (530) (14,545) 913,862 928,407 (14,545) 55,508 61,875 (6,367) (20,912) 969,370 990,282 (20,912) 0 1stQtr. 131,000 22,200 16,819 5,381 (2,194) 22,205 22,800 (595) (62,385) 11,103 3,869 7,234 97,195 55,508 43,488 12,020 (8,891) 1,024,878 1,033,769 (8,891) PQ 2006 2nd Qtr. 3rd Qtr. R 4thQtr. 22,200 22,200 20,006 22,205 22,205 (40,180) 11,103 11,103 108,298 22,200 22,200 42,206 22,205 22,205 (17,975) 11,102 11,102 119,400 131,000 22,200 22,200 64,406 22,205 22,205 4,230 11,102 11,102 130,502 55,508 68,415 (12,907) (21,798) 2006 1,080,386 1,102,184 (21,798) 55,507 55,507 33,709 1,135,893 1,102,184 33,709 55,507 55,507 89,216 1,191,400 1,102,184 89,216 S 1stQtr. 22,200 22,200 86,606 22,205 22,205 26,435 11,102 11,102 141604 55,507 55,507 144,723 1,246,907 1,102,184 144,723 TU 2007 2nd Qtr. 3rd Qtr. 55,000 22,200 22,200 22,200 108,806 22,200 131,006 22,205 22,205 22,205 48,640 22,205 70,845 11,102 11,102 11,102 152706 11,102 163,808 55,507 55,507 55,507 55,507 200,230 255,737 2007 1,302,414 1,357,921 1,102,184 1,102,184 200,230 255,737 V 4thQtr. 22,200 22,200 153,206 22,205 22,205 93,050 11,102 11,102 174,910 55,507 55,507 311,244 1,413,428 1,102,184 311,244 Page 17 of45 &[DATE] SH ELL-MCCLU RG-053872 W TOTALS "I 2 ~ ~ ~ ~ ~ ~,::I L' -. L L"I ~ ~ L L' L .)U ~ ~ .).) ,)"1 ~ ~ 37 1,367,486 565,319 412,113 64,406 153,206 565,404 472,354 4,230 93,050 282,705 149,302 130,502 133,403 1,413,428 1,102,184 89,216 311,244 1,413,428 1,102,184 311,244 Benzene Health Research Consortium Irons Field Expenses 2Q07 Financial Report Page 18 of45 &[DATE] SH ELL-MCCLU RG-053873 Benzene Health Research Consortium AHS 2Q07 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 AHS (X81 07) Cost Centers Budgeted Actual expense Current Variance Cumm Variance Budgeted Expense Variance TOTALS CUMULATIVE TOTALS ~ Blue: future cumulative variance has no meaning until Expense entered. ~ L 30 LT 813105 31 BJ 4105/05 RT 8/112007 B 2001 4thQtr. C 2002 1st-4thQtr. D 1st&2nd Qtr. E 3rd Qtr. 2003 F 4thQtr. 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) 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 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 3,980 2002 435,513 435,406 107 (52,197) 2002 519,538 571,735 (52,197) 1,500 1,500 5480 216,256 140,665 75,591 23,394 735,794 712,400 23,394 750 750 6,230 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 78,878 73,690 5,188 (174,184) 28,500 16,413 12,087 167,361 750 750 6,980 108,128 90,103 18,025 157 952,049 951,892 157 G 1stQtr. HI 2004 2nd Qtr. 3rd Qtr. 72,090 72,090 (102,094) 72,090 149,980 (77,890) (179,984) 72,090 92,201 (20,111) (200,094) 25,500 25,500 192,861 25,500 18,534 6,966 199,827 25,500 12,522 12,978 212,805 750 750 7730 98,340 98,340 98,497 1,050,389 951,892 98,497 750 109 641 8,371 750 785 (35) 8,336 10. 98,340 168,623 (70,283) 28,215 2004 1,148,730 1,120,515 28,215 98,340 105,508 (7,168) 21,047 1,247,070 1,226,023 21,047 J 4thQtr. 72,090 162,216 (90,126) (290,220) 25,500 2,564 22,936 235,741 750 211 539 8,875 98,340 164,991 (66,651) (45,604) 1,345,410 1,391,014 (45,604) K 1stQtr. 84,217 70,316 13,901 (276,319) 25,500 25,500 261,241 750 750 9,625 110,467 70,316 40,151 (5,454) 1,455,877 1,461,330 (5,454) DRAFT Page 19 of45 &[DATE] SH ELL-MCCLU RG-053874 Benzene Health Research Consortium AHS 2Q07 Financial Report "I .2 ~ ~ ~ ~ ~ ~ L' -. L L"I ~ '<0 ~ ~ L 30 31 LM 2005 2nd Qtr. 3rd Qtr. 158,934 120,880 38,054 38,054 98,617 115,825 (17,208) 20,846 43,350 1,899 41,451 41,451 34,425 16,622 17,803 59,254 750 750 335 478 415 272 415 687 20 203,034 133,792 123,114 132,925 79,920 867 79,920 80,787 2005 1,664,364 1,798,156 1,584,444 1,717,369 79,920 80,787 N 4thQtr. 98,617 222,365 (123,748) (102,903) 34,425 34,425 93,679 750 750 1437 133,792 222,365 (88,573) (7,787) 1,931,948 1,939,734 (7,787) 581,084 0 1stQtr. 91,867 73,855 18,012 (84,890) 44,371 44,371 138,050 750 750 2,187 136,988 73,855 63,133 55,347 2,068,936 2,013,589 55,347 P 2006 2nd Qtr. Q 3rd Qtr. 91,867 111,422 (19,555) (104,445) 91,867 141,140 (49,273) (153,718) 44,371 44,371 44,371 182,421 44,371 226,792 750 750 750 2937 2". 136,988 111,422 25,566 80,913 2006 2,205,924 2,125,011 80,913 750 3687 136,988 141,140 (4,152) 76,761 2,342,913 2,266,152 76,761 547,953 R 4thQtr. 91,867 231,797 (139,930) (293,648) 44,371 44,371 271,163 750 750 4437 136,988 231,797 (94,809) (18,048) 2,479,901 2,497,948 (18,048) S 1stQtr. 160,292 112,560 47,732 (245,916) T 2007 2nd Qtr. U 3rd Qtr. 160,292 173,692 (13,400) (259,316) 160,292 160,292 (99,024) V 4thQtr. 160,292 160,292 61,268 W 1stQtr. 175,876 X 2008 2nd Qtr. 175,876 Y 3rd Qtr. 175,876 Z 4thQtr. 175,876 271,163 271,163 271,163 271,163 4437 160,292 112,560 47,732 29,684 2,640,193 2,610,508 29,684 4,437 20 160,292 173,692 (13,400) 16,284 2007 2,800,485 2,784,201 16,284 4437 160,292 160,292 176,576 2,960,777 2,784,201 176,576 4,437 160,292 160,292 336,868 3,121,069 2,784,201 336,868 175,876 175,876 175,876 175,876 641,168 AA TOTALS 3,130,435 2,641,982 160,292 488,453 671,184 138,780 532,404 17,500 3,438 14,062 3,819,119 2,784,201 160,292 1,034,919 3,121,069 2,784,201 336,868 Page 20 of45 &[DATE] SH ELL-MCCLU RG-053875 Benzene Health Research Consortium Fudan 2Q07 Financial Report A "I 2 ~ J:L ~ IL ~ ~ ~ LI -. L"I ~ '<0 Labor (salary + benefits) Budgeted Actual expense Current Variance Cumm Variance Expenses Budgeted Actual expense Current Variance Cumm Variance Overhead (15%) Budgeted Actual expense Current Variance Cumm Variance FUDAN (X81 08) Cost Centers Budgeted Actual expense Current Variance Cumm Variance Budgeted Expense Variance TOTALS CUMULATIVE TOTALS ~ Blue: future cumulative variance has no meaning until Expense entered. ~ 29 LET 813105 30 BJ 8101/05 ~ rdw 10/19/06 RT 10126/06 B 2001 9,620 9,620 9,620 17,600 17,600 17,600 4,083 4,083 4,083 2001 31,303 31,303 31,303 2001 31,303 31,303 C 2002 D 1Q12Q03 E 2003 3003 8,775 8,774 9,621 4,388 6,492 (2,105) 7,516 2,194 2,194 9,709 28,400 4,870 23,530 41,130 14,200 14,200 55,330 7,100 8,851 (1,751) 53,579 5,576 1,825 ~ 42,751 15,470 27,281 58,584 2002 74,054 15,470 58,584 2,788 788 10,622 21,376 6,492 14,883 73,467 95,430 21,962 73,467 1,394 1,394 12016 2003 10,688 8,851 1,837 75,305 2003 106,117 30,813 75,305 F 4Q03 1,548 1,548 11,257 4,645 1,168 3,477 57,056 1,095 1,095 13111 7,288 1,168 6,120 81,425 113,405 31,981 81,425 G 1Q04 1,548 1,548 12,805 4,645 4,645 61,701 1,095 1,095 14,206 7,288 7,288 88,713 120,693 31,981 88,713 H 2004 2Q04 3Q04 1,548 14,385 (12,837) (32) 1,548 1,548 1,516 4,645 9,750 (5,105) 56,596 4,645 4,645 61,241 1,095 3,620 (2,525) 11681 1,095 1,095 12776 DO 7,288 27,755 (20,467) 68,246 2004 127,981 59,736 68,246 7,288 7,288 75,534 135,269 59,736 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) 6909 7,287 64,354 (57,067) 18,467 142,556 124,090 18,467 K 1Q05 (43,345) 54,903 6,909 18,467 142,556 124,090 18,467 L 2005 2Q05 2005 2005 4,777 4,777 4,777 30,250 30,250 30,250 5,254 5,254 5,254 40,281 40,281 40,281 164,371 124,090 40,282 M 3005 4,777 30,250 5,254 40,281 164,371 124,090 40,282 N 4Q05 4,778 4,778 9,555 30,250 4,007 26,243 56,493 5,254 5,254 10508 40,282 4,007 36,275 76,556 204,653 128,097 76,557 DRAFT 2005 - variance zeroed out - only current cqtr variance shown 2005 - ez ense roections revised based on 3 Ma 05 a roved bud et Page 21 of45 &[DATE] SH ELL-MCCLU RG-053876 Benzene Health Research Consortium Fudan 2Q07 Financial Report 0 1Q06 "I 2 ~ 9,555 J:L ~ IL 56,493 ~ ~ ~ LI -. 10,508 76,556 L"I ~ '<0 204,653 128,097 76,557 ~ Note: budget is in 2001 $. ~ 29 30 ~ p 2006 2Q06 5,614 5,614 15,169 33,750 33,750 90,243 7,873 7,873 18,380 200. 47,236 47,236 123,792 2006 251,889 128,097 123,793 Q 3006 9,555 (9,555) 5,614 56,860 (56,860) 33,383 9,962 (9962) 8,418 76,377 (76,377) 47,415 251,889 204,474 47,415 R 4Q06 5,614 5,614 11,227 33,750 33,750 67,133 7,873 7,873 16,290 47,236 47,236 94,651 299,125 204,474 94,651 S 1Q07 11,227 67,133 16,290 94,651 299,125 204,474 94,651 TU 2007 2Q07 3007 6,507 6,507 17,734 17,734 25,775 25,775 92,908 92,908 8,071 8,071 24,361 24361 50,000 50,000 144,651 2007 349,125 204,474 144,651 144,651 349,125 204,474 144,651 V 4Q07 6,507 6,507 24,240 25,775 25,775 118,683 8,071 8,071 32,431 50,000 50,000 194,651 399,125 204,474 194,651 W 1Q07 10,000 X 2008 2Q07 10,000 Y 3007 10,000 Z 4Q07 10,000 AA TOTALS 109,856 85,616 6,507 24,240 215,172 96,489 25,775 118,683 54,800 22,369 8,071 32 <32 439,125 204,474 50,000 234,651 399,125 204,474 194,651 Page 22 of45 &[DATE] SH ELL-MCCLU RG-053877 A SRP + ERP (X8109) Cost Centers Albertini Budgeted Actual expense CurrentVanance CummVanance ~ Brody (DB5200X1503; resigned 4Q03) ~ Budgeted Actual expense CurrentVanance IL CummVanance Checkoway '" Budgeted Actual expense CurrentVanance CummVanance Cherrie/lOM 1::1 Budgeted Actual expense CurrentVanance L. CummVanance Greim Budgeted Actual expense L. CurrentVanance CummVanance ~Herrick ~ ")l. Budgeted Actual expense )L ~ ..)"+ ..):: ~ ~ ")C ..)t1 ~ ~ "+. CurrentVanance Cumm Vanance Idanpaan-Heikkila Budgeted Actual expense CurrentVanance Cumm Vanance Larson Budgeted Actual expense CurrentVanance CummVanance ~ ~ "+1: ,,+, ~ ~ ::>l. )L ~ ::>"+ ::>:: ~ ~ ::>C ::>t1 ~ ~ 0': ~ ~ 01: Budgeted Actual expense CurrentVanance CummVanance Minden I Ontario Cancer Institute (discontinuted2006) Budgeted Actual expense CurrentVanance Cumm Vanance Muelier (resigned 2Q03) Budgeted Actual expense CurrentVanance Cumm Vanance Rice Budgeted Actual expense CurrentVanance CummVanance Rockette Budgeted Actual expense CurrentVanance CummVanance ~ 'L '" OL. O~ OC Budgeted Actual expense CurrentVanance CummVanance Claytonijoined2Q04) Budgeted Actual expense CurrentVanance CummVanance Lombardoijoined2Q04) Budgeted Actual expense CurrentVanance CummVanance Budgeted Actual expense CurrentVanance CummulatlveVanance Budgeted Expense Vanance TOTALS CUMULATIVE TOTALS B 2001 4thOtr c 2002 1st-4thOtr DIE 1st&2ndOtr 2003 3rdOtr F 4thOtr 2,160 2,000 160 160 8,640 8,640 8,800 4,320 4,320 13,120 2,160 2,160 15,280 322 2,529 (2,207) 13,073 2,160 8,640 4,320 2,160 322 2,160 2,160 8,640 10,800 4,320 15,120 2,160 17,280 322 17,602 2,160 1,000 1,160 1,160 8,640 8,640 9,800 4,320 4,320 14,120 2,160 2,422 (262) 13,858 322 322 14,180 2,160 2,160 2,160 8,640 2,122 6,518 8,678 4,320 4,320 12,998 2,160 2,160 15,158 322 322 15,480 2,160 2,160 2,160 8,640 8,640 10,800 4,320 4,320 15,120 2,160 2,160 17,280 322 7,334 (7,012) 10,268 2,160 2,000 160 160 8,640 8,640 8,800 4,320 4,320 13,120 2,160 2,160 15,280 322 4,454 (4,132) 11,148 2,160 2,160 2,160 8,640 8,640 10,800 4,320 4,344 (24) 10,776 2,160 180 1,980 12,756 322 322 13,078 2,160 2,127 33 33 8,640 8,640 8,673 4,320 4,320 12,993 2,160 2,636 (476) 12,517 322 322 12,839 2,160 6,796 (4,636) (4,636) 8,640 3,000 5,640 1,004 4,320 4,320 5,324 2,160 2,160 7,484 322 13,094 (12,772) (5,288) 2,160 1,000 1,160 1,160 8,640 8,640 9,800 4,320 4,320 14,120 2,160 2,160 16,280 322 322 16,602 2,160 1,250 910 910 8,640 8,640 9,550 4,320 4,320 13,870 2,160 2,160 16,030 322 322 16,352 2,160 2,160 2,160 8,640 8,640 10,800 4,320 4,000 320 11,120 2,160 5,692 (3,532) 7,588 322 2,000 (1,678) 5,910 2,160 2,160 2,160 8,640 8,640 10,800 4,320 4,320 15,120 2,160 2,160 17,280 322 2,670 (2,348) 14,932 2,160 2,500 (340) (340) 8,640 8,640 8,300 4,320 1,650 2,670 10,970 2,160 6,054 (3,894) 7,076 322 322 7,398 2001 30,240 18,673 11,567 11,567 2001 30,240 18,673 11,567 2002 120,960 5,122 115,838 127,405 2002 151,200 23,795 127,405 60,480 9,994 50,486 177,891 211,680 33,789 177,891 2003 30,240 16,984 13,256 191,147 2003 241,920 50,773 191,147 4,508 32,081 (27,573) 163,574 246,428 82,854 163,574 Benzene Health Research Consortium SRP + ERP 2Q07 Financial Report G 1stOtr IHI I J 2004 2ndOtr 3rdOtr 4thOtr K I LIM I N 1stOtr 2005 2ndOtr 3rdOtr 4thOtr o 1stOtr I PIQ 2006 2ndOtr 3rdOtr IR 4thOtr SIT U 1stOtr 2007 2nd Qtr. 3rdOtr IV 4thOtr (13,073) (13,073) 250 3,000 3,401 250 (401) 250 (151) (151) (151) 250 3,000 3,750 1,000 2,443 250 3,000 (1,000) 1,307 99 3,099 2,099 2,099 3,406 3,406 3,406 3,406 3,750 3,750 7,156 7,156 (17,602) (17,602) 1,500 (1,500) (1,500) (1,500) (1,500) (1,500) (1,500) (1,500) (1,500) (1,500) (1,500) (1,500) (1,500) (1,500) (1,500) (1,500) (1,500) (14,180) (14,180) 250 3,000 250 3,000 3,750 3,036 4,609 250 (36) 250 (1,609) 3,750 250 214 214 214 464 (1,145) (1,145) (1,145) 2,605 2,605 2,605 2,605 3,750 3,750 6,355 6,355 (15,480) (15,480) (0) 7,029 (7,029) (7,029) 250 250 (6,779) 8,000 10,229 (2,229) (9,008) (9,008) (9,008) 250 250 (8,758) 8,000 8,090 (90) (8,848) (8,848) (8,848) 6,500 6,500 (2,348) 10,907 (10,907) (13,255) (13,255) (13,255) 6,500 6,500 (6,755) (6,755) (10,268) (10,268) 250 8,000 1.338 250 4,662 250 4,912 4,912 4,912 250 250 5,162 8,000 7,698 302 5,464 5,464 5,464 8,482 7,894 588 6,052 6,052 6,052 6,052 8,482 8,482 14,534 14,534 (11,148) (11,148) 250 3,000 415 250 2,585 250 2,835 2,835 2,835 250 250 3,085 3,000 3,000 6,085 6,085 6,085 3,900 3,900 9,985 4,941 (4,941) 5,044 5,044 5,044 3,900 3,900 8,944 8,944 (13,078) (13,078) 250 8,000 250 8,000 10,000 10,000 7,620 11.359 10,586 250 380 250 (3,359) (586) 10,000 250 630 630 630 880 (2,479) (2,479) (2,479) (3,065) (3,065) (3,065) (3,065) 6,935 6,935 (12,839) (12,839) 250 3,000 250 3,000 4,000 2,850 3,939 2,729 250 150 250 (939) 1,271 250 400 400 400 650 (289) (289) (289) 982 982 982 4,000 4,000 982 4,982 4,982 5,288 5,288 250 10,000 6,477 250 3,523 250 3,773 3,773 3,773 250 250 4,023 10,000 10,000 14,023 14,023 14,023 10,000 9,300 700 14,723 14,723 14,723 14,723 10,000 10,000 24,723 24,723 (16,602) 250 3,000 250 3,000 (16,602) 250 3,000 250 3,250 3,250 3,250 250 3,500 3,000 6,500 6,500 6,500 6,500 6,500 6,500 6,500 6,500 6,500 (16,352) (16,352) (5,410) 500 (5,910) (0) (14,932) (14,932) (7,398) (7,398) (163,074) 500 (163,574) 83,354 83,354 (0) 3,000 3,500 (500) (500) 1,500 2,500 (1,000) (1,500) 250 250 250 250 250 250 250 250 250 250 2004 3,000 12,029 (9,029) (9,029) 2004 86,354 95,383 (9,029) 250 250 4,750 2,500 2,250 (6,779) 91,104 97,883 (6,779) 4,000 6.311 (2,311) (3,811) 3,000 2,775 225 475 10,000 10,575 (575) (325) 3,000 6,009 (3,009) (2,759) 3,000 5,853 (2,853) (2,603) 72,000 83,830 (11,830) (18,609) 163,104 181,713 (18,609) 1,500 1,500 (2,311) 475 (325) (2,759) 2,603) 1,500 1,500 (17,109) 164,604 181,713 (17,109) 1,000 2,500 (1,500) (3,811) 1,000 14,016 (13,016) (16,827) 250 250 475 725 250 (325) 250 (75) 250 (2,759) 250 (2,509) 250 (2,603) 250 2,353) 2005 1,000 2,500 (1,500) (18,609) 2005 165,604 184,213 (18,609) 4,250 14,016 (9,766) (28,375) 169,854 198,229 (28,375) 2,000 11,251 (9,251) (26,078) 3,000 2,765 235 960 10,000 10,000 9,925 3,000 (2,113) (4,622) 3,000 4,837 (1,837) (4,190) 70,000 59,660 10,340 (18,035) 239,854 257,890 (18,036) 1,000 1,800 (800) (26,878) 960 2,000 2,000 11,925 (4,622) 823 823 (3,367) 3,823 2,800 1,023 (17,012) 243,677 260,690 (17,013) 1,000 4,800 (3,800) (30,678) 4,500 6,600 (2,100) (32,778) 3,000 3,000 960 3,960 11,925 15,000 13,900 1,100 13,025 5,689 (4,622) 5,689 1,067 (3,367) 2006 1,000 4,800 (3,800) (20,812) 2006 244,677 265,490 (20,813) 4,655 4,595 60 (3,306) 83,226 58,047 25,179 4,367 327,903 323,537 4,366 4,500 13,923 (9,423) (42,201) 3,960 13,025 1,067 (3,306) 4,500 29,771 (25,271) (20,905) 332,403 353,308 (20,905) 4,500 3,600 900 (41,301) 3,960 13,025 375 (375) 692 (3,306) 4,500 3,975 525 (20,380) 336,903 357,283 (20,380) 4,500 7,500 (3,000) (44,301) 4,500 4,500 (39,801) 3,000 3,960 3,000 6,960 15,000 13,025 15,000 28,025 375 (375) 317 5,689 5,689 6,006 4,655 (3,306) 2007 4,500 7,875 (3,375) (23,755) 2007 341,403 365,158 (23,755) 4,655 1,349 83,226 83,226 59,471 424,629 365,158 59,471 4,500 4,500 (35,301) 6,960 28,025 6,006 1,349 4,500 4,500 63,971 429,129 365,158 63,971 SH ELL-MCCLU RG-053878 W TOTALS ~ ~ -"'- IL I'! ~ 1::1 ...\L L ~ L ~ ~ .)~ jL ~ ,)'1 .)~ ~ ~ .)C ,)::1 ~ ~'I, '1~ ~ ~ 'Ie 'I, ~ ~ ,,~ )L ~ "'I ,,~ ~ ~ "C ,,::I ~ ~ o~ ~ ~ oe ~ ~ 'L ''I ~ ,::I ~ ~ OL o~ ~ ~ oe ~ ~ ::I~ 20,175 11,373 8,802 1,500 1,500 19,371 11,067 8,304 41,137 38,377 2,760 35,834 26,264 9,570 18,870 11,810 7,060 44,170 34,089 10,081 20,053 14,281 5,772 52,722 38,667 14,055 1,000 1,000 1,250 1,250 88,338 90,493 4,500 (2,155) 20,710 8,210 12,500 65,513 34,679 30,834 22,500 11,872 10,628 20,000 15,284 4,716 473,143 365,158 4,500 63,971 429,129 365,158 63,971 Benzene Health Research Consortium SRP + ERP 2Q07 Financial Report Page 24 of45 &[DATE] SH ELL-MCCLU RG-053879 A Blue fulure cumulallvevanance has no meaning unlll Expense enlered Benzene Health Research Consortium SRP + ERP 2Q07 Financial Report I B I c I D IE F G HI J K LMN0 PQ RS T UV 93 ::1"1 95 LT8/3/05 96 J:!c BJ4/05/05 rdw10/19/06 RT8/1/2007 DRAFT 1Q04budget ajustmentslo zeroourvanance I~CoefC" omme I~;~:~~I~;rs~f I~~;;:~ I:;~;~:;o~by OC meeting Page 25 of45 &[DATE] SH ELL-MCCLU RG-053880 Benzene Health Research Consortium Communications 2Q07 Financial Report ~ ~ APCO "I Budgeted Actual expense CurrentVariance Cumm Variance Travel ~ Budgeted Actual expense CurrentVariance Cumm Variance Other1 L<L Budgeted ~ Actual expense CurrentVariance Cumm Variance A COMMUNICATIONS (X8103) Cost Centers 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' K 1stOtL L 2 2nd OtL 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) 1,800 1,800 1,800 7,200 7,091 109 1,909 3,750 3,750 5,659 1,875 526 1,349 7,008 (5,876) 1,132 (7,008) 0 450 450 450 450 450 (1,350) 450 450 (1,350) 900 1,350 0 0 0 600 2,400 1,417 600 983 600 1,583 1,250 625 (3,364) 150 150 150 (448) 80 15 1,170 625 (3,379) 150 150 150 (448) 2753 3378 2 148 298 448 0 0 0 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 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $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~ Budgeted ~ Actual expense ~ CurrentVariance Cumm Variance .)~ ~ ~ .)t Budgeted Actual expense CurrentVariance ;j, Cumm Variance ~ ~ "I~ 4' Budgeted Actual expense CurrentVariance TOTALS ~ Cumm Variance ~ CUMULATIVE TOTALS "1"1 Budgeted 4~ Expense "10 Variance "I, - Telecommunications, Consulting Services, Duplicating/Copies Internal, Postage, Couriers, Telephone, Meals, Lexis Nexis Searches $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 2001 60,000 60,000 60,000 2001 60,000 60,000 $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 125,000 14,564 110,436 169,699 425,000 255,301 169,699 48 Blue: future cumulative variance has no meaning until Expense entered. 49 ~ .2 o;j 54 2 - Budget adjustment reflects budget reduction from $1 MM to $550k LT 8/3/05 RT 1/21/05 DRAFT *budget adjustment to lower program budget from $550K to $300K, as approved bv OC on 12/16/04 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 2003 62,500 7,877 54,623 224,322 2003 487,500 263,178 224,322 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 (196,636) 27,688 (224,324) (2) 15,001 15,001 14,999 290,864 290,866 (2) 305,865 290,866 14,999 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $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 294,161 294,161 0 294,161 294,161 0 $0.00 $0.00 $0.00 $0.00 2 0 2 294,161 294,161 0 Page 26 of45 &[DATE] SH ELL-MCCLU RG-053881 Benzene Health Research Consortium Communications 2Q07 Financial Report M 05 ~ 3rd Olr ~ "I N 4lh Olr 0 1sl0lr PQ 2006 2nd Olr 3rd Olr R 4lh Olr" (0) (0) (0) (0) (0) (0) S 1sl0lr TU 2007 2nd Otr. 3rd Olr V 4lh Olr (0) (0) (0) (0) W TOTALS 283,899 283,899 (0) (0) ~ 00000 0 0 8,749 8,749 0 000 0 1.<L 1,946 1,946 1,946 7,352 ~ 1,513 1,946 1,946 1,946 5,839 0 1,947 1,947 1,947 1,947 3,893 3,893 3,893 3,893 5,839 5,839 G:L "[ . ~ ~"I L~ ...t: $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 L~ $0.00 ~ $0.00 ~ $0.00 $0.00 .)~ ~ $0.00 ~ .)t $0.00 $0.00 ;j. $0.00 ~ 05 ~ "I~ 4 ~ 0 ~05 "1"1 294,161 4~ 294,161 "10 0 "I. 48 49 ~ .2 o;j 54 $0.00 $0.00 $0.00 $0.00 $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 1,946 1,946 296,107 294,161 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 296,107 294,161 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 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 2006 $0.00 $0.00 $0.00 $0.00 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 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 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 2007 $0.00 $0.00 $0.00 $0.00 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 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 of45 &[DATE] SH ELL-MCCLU RG-053882 Benzene Health Research Consortium Legal 2Q07 Financial Report A LEGAL (X81 04) 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 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 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 15 16 LT 813105 17 RT 8/112007 ~ L' -. DRAFT $0 $13,565 $1,728 E 2003 3rd Qtr. 31,250 31,250 228,457 243,750 15,293 228,457 $54,081 $0 F 4th Qtr.* G 1stQtr. HI 2004 2nd Qtr. 3rd Qtr. (210,542) 17,915 (228,457) 0 4,175 365 3,810 3810 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 $85,920 $7,810.86 $17,915 $365 $2,995 $1,870 J 4thQtr. K 1stQtr. L 2005 2nd Qtr. M 3rd Qtr. N 4thQtr. 0 1stQtr. P 2 2nd Qtr. 4,175 26,092 (21,918) (14,623) 4,175 4,827 (653) (15,276) 7,811 16,769 (8,958) (8,958) 7,811 7,811 1147 7,811 12,110 (4,299) 5446 7,811 5,776 2,035 (3,411) 7,811 6,084 1,727 (1,684) 49,906 64,529 (14,623) 54,081 69,356 (15,276) 77,167 86,125 (8,958) 84,978 86,125 (1,147) 92,789 98,235 (5,446) 100,600 104,011 (3,411) 108,411 110,096 (1,684) 2005 - variance adjusted to reflect only 2005 variance 2005 - Budget revised from $1 OOK to $140K per revised program budget approved 3 May 05 $26,092 $4,827 $16,769 $0 $12,110 $98,235 Page 28 of45 &[DATE] SH ELL-MCCLU RG-053883 Q DO 3rd Qtr. "I 7,811 .2 1,846 ~ 5,965 4,281 DO ~ 116,222 ~ 111,941 4,281 12 R 4thQtr. S 1stQtr. TU 2007 2nd Qtr. 3rd Qtr. 7,811 25,448 (17,637) (13,356) 124,033 137,390 (13,356) 17,811 13,891 3,920 (9,436) 141,844 151,280 (9,436) 17,811 24,224 (6,413) (15,849) 2007 159,655 175,505 (15,849) 17,810 17,810 1,961 177,465 175,505 1,961 V 4thQtr. 17,810 17,810 19,771 195,275 175,505 19,771 W TOTALS 180,000 175,505 4,495 4,495 180,000 175,505 4,495 14 15 16 17 ~ L' -. Benzene Health Research Consortium Legal 2Q07 Financial Report Page 29 of45 &[DATE] SH ELL-MCCLU RG-053884 Benzene Health Research Consortium QA-QC 2Q07 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 DE 2001 2002 2003 1st- 4th OtL 1st- 4th OtL 1st & 2nd OtL 3rd OtL 13,500 54,000 28,126 14,063 13,500 13,500 54,000 67,500 28,126 14,063 95,626 109,689 F 4th OtL GH I J 2004 1stOtL 2nd OtL 3rd OtL 4th Otr" K L MN 2005 1stOtL 2nd OtL 3rd OtL 4th OtL 0 1stOtL PQ 2006 2nd OtL 3rd OtL R 4th OtL S 1stOtL TU 2007 2nd OtL 3rd OtL V 4th OtL (109,689) 6,250 (109,689) 6,250 6,250 6,250 6,250 12,500 6,250 6,250 18,750 (18,750) 4,167 (18,750) 4,167 4,167 4,167 4,167 8,333 4,167 4,167 12,500 4,167 4,167 16,667 4,167 4,167 20,833 4,167 4,167 25,000 4,167 4,167 29,167 4,167 4,167 33,333 4,167 56 4,111 37,444 4,167 5,190 (1,023) 36,421 4,167 4,167 40,588 4,167 4,167 44,754 W TOTALS 50,000 5,246 44,754 44,754 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 1,202 1,202 (1,202) (1,202) (1,202) (1,202) (1,202) (1,202) (1,202) (1,202) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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 $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 13,500 13,500 2001 13,500 13,500 $0 $0 $0 $0 2002 54,000 54,000 67,500 2002 67,500 67,500 $0 $0 $0 $0 28,126 28,126 95,626 95,626 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~ 50 LT 813/05 DRAFT 51 RT 2/15/07 $0 $0 $0 $0 2003 14,063 14,063 109,689 2003 109,689 109,689 $0 $0 $0 $0 (109,689) (109,689) $0 $0 $0 $0 6,250 6,250 6,250 6,250 6,250 $0 $0 $0 $0 $0 $0 $0 $0 2004 6,250 6,250 6,250 6,250 12,500 18,750 2004 12,500 18,750 12,500 18,750 $0 $0 $0 $0 $0 $0 $0 $0 (18,750) 4,167 (18,750) 4,167 4,167 4,167 4,167 $0 $0 $0 $0 $0 $0 $0 $0 2005 4,167 4,167 4,167 4,167 8,333 12,500 2005 8,333 12,500 8,333 12,500 $0 $0 $0 $0 4,167 4,167 16,667 16,667 16,667 $0 $0 $0 $0 4,167 4,167 20,833 20,833 20,833 $0 $0 $0 $0 $0 $0 $0 $0 2006 4,167 4,167 4,167 4,167 25,000 29,167 2006 25,000 29,167 25,000 29,167 $0 $0 $0 $0 4,167 1,202 2,964 32,131 33,333 1,202 32,131 $0 $0 $0 $0 4,167 56 4,111 36,242 37,500 1,258 36,242 $0 $0 $0 $0 $0 $0 $0 $0 2007 4,167 4,167 5,190 (1,023) 4,167 35,219 39,385 2007 41,667 45,833 6,448 6,448 35,219 39,385 $0 $0 $0 $0 4,167 4,167 43,552 50,000 6,448 43,552 $0 $0 $0 $0 50,000 6,448 43,552 43,552 50,000 6,448 43,552 Page 30 of45 &[DATE] SH ELL-MCCLU RG-053885 A API ~ .2 ~ ~ ~ ~ 1"1 10 ~ I~ ~ -. L. L ~ ~ L' l. ~ ~ ,)u ;j' ~ ~ ,)"1 ;jo ~ .", Cost Centers Salaries Budgeted Actual expense CurrentVariance Cumm Variance Employee Benefits Budgeted Actual expense CurrentVariance Cumm Variance Employee Business Expenses I Travel Budgeted Actual expense CurrentVariance Cumm Variance Other Operating Expenses (& mtgs) Budgeted Actual expense CurrentVariance Cumm Variance API Recovered Overhead Budgeted Actual expense CurrentVariance Cumm Variance API Allocated Costs Budgeted Actual expense CurrentVariance Cumm Variance Supported Expense Budgeted Actual expense CurrentVariance Cumm Variance ;jts fALS ;j~ Budgeted ~ Actual expense ~ ~ CurrentVariance Cumm Variance 4;j CUMULATIVE TOTALS ~ Budgeted ~ "It Expense Variance "I, 48 LT 8/1/05 49 RT 8/1/2007 OL o"ected variances have no mean ina Benzene Health Research Consortium API Administration 2Q07 Financial Report B C D E IF 2000 2001 2002 2003 lst- 4th OtL lst- 4th OtL lst- 4th OtL 1st & 2nd OtL 3rd OtL G 4th OtL H lstOtL IJ 2004 2nd OtL 3rd OtL K 4th OtL L lstOtL 9,039 (9,039) (9,039) 26,045 18,749 6,552 (2,487) 104,180 89,669 14,511 12,024 54,260 57,297 (3,037) 8,987 27,130 32,217 (5,087) 3,900 22,250 32,800 (10,550) (6,650) 22,000 26,745 (4,745) (11,395) 22,000 25,357 (3,357) (14,752) 22,000 21,839 161 (14,591) 20,000 21,813 (1,813) (16,404) 12,000 16,492 (4,492) (20,896) 774 (774) (774) 3,256 2,329 927 153 13,022 11,209 1,813 1,966 6,783 7,163 (380) 1,586 3,391 4,027 (636) 950 2,750 4,100 (1,350) (400) 3,000 3,343 (343) (743) 3,000 3,169 (169) (912) 3,000 2,730 270 (642) 2,900 2,727 173 (469) 1,100 2,061 (961) (1,430) 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 1,000 15,815 1,000 1,152 (152) 15,663 3,000 2,027 973 16,636 1,000 1,710 (710) 15,926 1,000 716 284 16,210 1,673 (1,673) (1,673) 651 9,196 (8,545) (10,218) 2,604 16,270 (13,666) (23,884) 1,359 13,292 (11,933) (35,817) 679 72 607 (35,210) 16,184 26,276 (10,092) (45,302) 2,000 3,600 (1,600) (46,902) 2,000 3,808 (1,808) (48,710) 6,000 (3,223) 9,223 (39,487) 2,000 11,398 (9,398) (48,885) 430 2,010 (1,580) (50,465) 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 9,185 (2,935) 5,227 6,200 7,489 (1,289) 3,938 6,200 7,099 (899) 3,039 6,200 6,115 85 3,124 6,000 6,107 (107) 3,017 3,500 4,618 (1,118) 1,899 16,929 13,886 3,043 3,043 67,717 58,794 8,923 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 9,198 28,000 27,999 1 9,199 28,000 28,000 9,199 28,000 27,999 1 9,200 10,000 6,999 3,001 12,201 7,020 (7,020) 7,020 2000 24,600 (24,600) (24,600) 2000 24,600 (24,600) 6,511 1,712 4,799 2,221 2001 65,113 52,046 13,067 11,533 2UU1 65,113 76,646 (11,533) 26,045 26,045 23824 200 260,448 209,056 51,392 39859 2UU2 325,561 285,702 39,859 13,565 17,000 (3,435) 20389 2003 135,654 145,316 9662) oU,197 2UU3 461,215 431,018 30,197 6,783 8,499 (1,716) 18673 67,826 74,997 (7,171) 23026 529,041 506,015 23,026 5,750 (8,250) 14,000 32673 75,934 88,655 (12,721) 10305 604,975 594,670 10,305 4,500 (4,023) 8,523 41 196 2004 66,700 65,154 1,546 11851 'U4 671,675 659,824 11,851 4,500 4,500 41 196 66,700 73,084 (6,384) 5467 738,375 732,908 5,467 4,500 4,500 41 196 72,700 61,988 10,712 16179 811,075 794,896 16,179 4,500 4,500 41 196 1,250 4,500 (3,250) 37946 64,400 61,312 (11,854) 4325 29,280 37,396 (8,116) 3791 875,475 871,150 4,325 904,755 908,546 (3,791) M 2005 2nd OtL 2005 'UO N 3rd OtL 20,000 19,319 681 681 15,000 19,814 (4,814) (4,133) 2,400 2,414 (14) (14) 1,800 2,476 (676) (690) 1,000 542 458 458 1,000 94 906 1,364 1,000 684 316 316 1,000 1,209 (209) 107 5,600 5,410 190 190 4,200 5,547 (1,347) (1,157) 14,000 6,999 7,001 7,001 12,000 6,999 5,001 12,002 4,500 4,500 4,500 4,500 48,500 39,868 8,632 8632 39,500 40,639 (1,139) 7493 953,255 948,414 8,632 992,755 989,053 3,702 DRAFT 2Q05 - variance reflects 2005 variance, only 2005 - budgeted expenses revised to reflect 3 May 05 revised total program budget Page 31 of45 &[DATE] SH ELL-MCCLU RG-053886 Benzene Health Research Consortium API Administration 2Q07 Financial Report 0 4lh Olr. P IQ R 2006 1s101r. 2nd Olr. 3r.d Olr. S 4lh Olr. T 1s101r. U I V Iw 2007 2nd Otr.. 3r.d Olr. 4lh Olr. ...1. 25,000 15,000 10,000 15,000 15,000 15,000 15,000 20,000 20,000 .2 23,056 12,470 16,876 25,349 19,194 10,957 15,651 1,944 2,530 (6,876) (10,349) (4,194) 4,043 (651) 20,000 20,000 (2,189) 341 (6,535) (16,885) (21,078) (17,035) (17,686) 2,314 22,314 ~ J:!. 3,000 1,800 1,200 1,800 1,800 1,800 1,800 2,400 2,400 2,883 1,559 2,109 3,169 2,399 1,370 1,956 117 241 (909) (1,369) (599) 430 (156) 2,400 2,400 ~ (573) (332) (1,241) (2,610) (3,209) (2,779) (2,935) (535) 1,865 ~ 1"1 5,000 1,000 1,000 1,000 1,000 1,000 1,000 10,000 1,000 10 6,931 22 1,201 1,520 1,080 LQ. (1,931) 978 (201) (520) (80) 1,000 1,000 10,000 1,000 (567) 411 210 (310) (391) 609 1,609 11,609 12,609 I~ ~ -. L. L ~ ~ L' l. ~ ~ ..)u ;j' ~ ~ ,,)"1 ;jo ~ .", ;jts ;j~ ~ ...1. "IL 4;j ~ ~ "It "I, 48 49 OL 5,000 1,747 3,253 3,360 7,000 6,456 544 (613) 14,000 6,999 7,001 19,003 4,500 4,500 63,500 52,572 10,928 18,421 1,056,255 1,041,625 14,630 1,000 533 467 3,827 4,200 3,492 708 95 12,500 12,500 19,003 5,000 5,000 5,000 40,500 30,576 9,924 28,345 1,096,755 1,072,201 24,554 1,000 583 417 4,245 5,000 661 4,339 8,584 1,000 1,368 (368) 8,215 1,000 1,597 (597) 7,618 1,000 1,733 (733) 6,886 10,000 10,000 16,886 2,800 4,725 (1,925) (1,830) 4,200 7,098 (2,898) (4,728) 4,200 5,374 (1,174) (5,902) 4,200 3,068 1,132 (4,770) 4,200 4,382 (182) (4,952) 5,600 5,600 648 14,000 12,500 1,500 20,503 14,000 12,500 1,500 22,003 14,000 12,500 1,500 23,503 18,000 13,750 4,250 27,753 18,000 13,750 4,250 32,003 18,000 18,000 50,003 5,000 5,000 5,000 6,000 6,000 6,000 5,000 10,000 5,000 15,000 2006 35,000 46,000 37,995 50,296 -(2,995) 25,351 (4,296) 21,054 2006 1,177,755 1,160,492 21,560 17,263 5,000 20,000 42,000 41,916 84 21,139 1,219,755 1,202,407 17,348 6,000 26,000 47,000 30,741 16,259 37,397 1,266,755 1,233,149 33,606 6,000 32,000 6,000 38,000 2007 47,000 72,000 37,472 9,528 72,000 46,925 118,925 2007 1,313,755 1,385,755 1,270,621 1,270,621 43,134 115,134 6,450 6,450 23,336 5,600 5,600 6,248 18,000 18,000 68,003 6,000 6,000 44,000 59,450 59,450 178,375 1,445,205 1,270,621 174,584 X TOTALS 516,865 514,703 165,681 22,314 64,402 63,967 21,474 1,865 64,952 36,133 28,819 12,609 67,357 94,486 30,825 23,336 154,925 146,778 8,147 6,248 441,300 361,096 80,204 68,003 135,404 53,458 81,946 44,000 1,445,205 923,832 450,028 178,375 1,445,205 1,270,621 174,584 Page 32 of45 &[DATE] SH ELL-MCCLU RG-053887 Benzene Health Research Consortium Exposure Assess 2Q07 Financial Report A 1 Exposure asssessment (X8111) 2 Cost Centers 3 Herrick 4 Budgeted 5 Actual expense 6 CurrentVariance 7 Cumm Variance 8 Cherrie/lOM 9 Budgeted 10 Actual expense 11 CurrentVariance 12 Cumm Variance 13 TOTALS 14 Budgeted 15 Actual expense 16 Current Variance 17 Cummulative Variance 18 CUMULATIVE TOTALS 19 Budgeted 20 Expense 21 Variance 22 23 rdw 10/19106 24 RT 8/112007 B 1stQtr CD 2006 2nd Qtr 3rd Qtr 2006 2006 E 4th Qtr F 1stQtr GH 2007 2nd Qtr. 3rd Qtr 20,000 12,324 7,676 7,676 15,000 15,000 22,676 15,000 7,862 7,138 29,814 6,000 6,000 35,814 20,000 20,000 20,000 40,000 12,324 27,676 27,676 40,000 12,324 27,676 15,000 4,583 10,417 30,417 30,000 4,583 25,417 53,093 70,000 53,093 15,000 3,000 8,877 6,123 3,000 36,540 39,540 2007 30,000 9,000 16,739 13,261 9,000 66,354 75,354 2007 100,000 109,000 66,354 75,354 I 4th Qtr J TOTALS 35,814 56,000 20,186 35,814 35,814 39,540 53,000 13,460 39,540 39,540 75,354 109,000 33,646 75,354 75,354 109,000 75,354 SH ELL-MCCLU RG-053888 A 1 Cinpathogen (XB112) 2 Cost Centers 3 4 Budgeted 5 Actual expense 6 CurrentVariance 7 Cumm Variance 8 9 Budgeted 10 Actual expense 11 CurrentVariance 12 Cumm Variance 13 TOTALS 14 Budgeted 15 Actual expense 16 Current Variance 17 Cummulative Variance 18 CUMULATIVE TOTALS 19 Budgeted 20 Expense 21 Variance 22 23 24 RT 8/1/2007 B 1stQtr CD 2006 2nd Qtr 3rd Qtr E 4th Qtr F 1stQtr 2006 2006 G 2nd Qtr. H 2007 3rd Qtr 2,100,000 2,100,000 2007 2,100,000 2,100,000 2007 2,100,000 2,100,000 I 4th Qtr J 1stQtr K 200B 2nd Qtr L 3rd Qtr M 4th Qtr 1,275,000 1,275,000 1,275,000 1,275,000 1,275,000 1,275,000 3,375,000 1,275,000 N TOTALS 3,375,000 2,100,000 1,275,000 1,275,000 - 3,375,000 2,100,000 1,275,000 1,275,000 SH ELL-MCCLU RG-053889 Benzene Health Research Consortium Contingency Fund 2Q07 Financial Report A 1 2 3 Contingency Funds 4 5 Current quarter expense/commitment 6 Total spent/committed 7 Amount remaining 8 9 10 11 EXPENSE DETAIL 12 13 Reallocations from UCHSC 14 Reallocations from AHS 15 Histopath Review - J. Bennet! 16 Non-contract** 17 Newfields (Kreiger) 18 Committed on contract 19 Current quarter expense 20 Remaining funds 21 * Line item created 4003 B 2003* 4th Otr 101,473 101,473 288,799 48,839 52,634 22 ** to be reprogrammed as API expense in 3005 23 LT 8/3/05 24 RT 7/19/06 25 DRAFT 26 27 28 29 4003 Adjustment - per Technical Committee, transfer $48,839 from UCHSC expense detail to contingency because expenses not part of UCHS AHS - expense transfer of $52,634 from AHS expense detail to contingency because expenses not part of AHS full study budget Page 35 of 45 &[DATE] SH ELL-MCCLU RG-053890 Benzene Health Research Consortium Contingency Fund 2Q07 Financial Report C 1 2 2004 3 1stQtr 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 T3 24 grant budget: 25 26 1 June 2001 $25K grant to UCHSC; seed money exhausted (API & sponsor), expense not included in final grant cost estimate 27 2. $3600 IRB fees to U of CO (this will be a yearly fee, since IRB must review at least once per year) 28 3. 2002 invoice ($20,239) from EMBSI for final feasibility study work (very late billing to API) 29 DE FG 2nd Qtr 3rd Qtr 4th Qtr 1stQtr 101,473 188,799 101,473 188,799 101,473 188,799 3,000 104,473 485,799 50,296 154,769 435,503 H 2005 2nd Qtr 422 155,191 435,081 3,000 3,000 496 46,800 46,800 422 46,800 7,058 39,742 Contingen Total program budget as of 2Q07 spent/committed as of 2Q07 Remaining Page 36 of 45 &[DATE] SHELL-MCCLURG-053891 Benzene Health Research Consortium Contingency Fund 2Q07 Financial Report IJ 1 2 3 3rd Qlr 41h Qlr 4 5 1,200 6 155,191 156,391 7 850,695 850,695 8 9 10 11 12 13 14 15 16 1,200 17 18 39,742 39,742 19 288 20 39,742 39,454 21 22 ySummary 23 24 25 26 27 28 29 K 1slQlr LM 2006 2nd Qlr 3rd Qlr N 41h Qlr 0 1slQlr 156,391 850,695 156,391 850,695 156,391 840,900 156,391 798,907 156,391 814,988 1,570,593 156,391 1,414,201 PQ 2007 2nd Qlr 3rd Qlr 156,391 1,570,593 156,391 1,570,593 R 41h Qlr 156,391 1,570,593 Page 37 of 45 &[DATE] SH ELL-MCCLU RG-053892 A ~ ~ INCOME "I Sponsor Payments API Interest UCHSC Interest TOTALS Reporting Period ~ Cumulative 1 projected income ~ 14 LT 8123/05 rdw 10/19/06 RT 8/112007 B 2000 1st - 4th Qtr. C 2001 1st - 4th Qtr. D 2002 1st - 4th Qtr. E 1st & 2nd Qtr. 60,000 246 2,105,509 7,623 8,355,629 11,817 448,024 60,246 60,246 2,113,132 2,173,378 8,367,446 10,540,824 448,024 10,988,848 F 2003 3rd Qtr. 3,186 Benzene Health Research Consortium Income 2Q07 Financial Report G 4th Qtr. 4,259,965 5,276 H 1stQtr. 1,485,875 IJ 2004 2nd Qtr. 3rd Qtr. 6,746 6,506 K 4th Qtr. 9,292 L 1stQtr. 1,096,000 3,186 10,992,034 4,265,241 15,257,275 1,485,875 16,743,149 6,746 16,749,895 6,506 16,756,401 9,292 16,765,693 1,096,000 17,861,693 M 2nd Qtr. 2005 N 3rd Qtr. 365,334 6,809 2,933,879 14,899 61,009 372,143 18,233,836 3,009,787 21,243,623 0 4th Qtr. 674,000 54,727 728,727 21,972,350 P 1stQtr. 21,972,350 Q 2006 2nd Qtr. R 3rd Qtr. 1,914,080 20,211 16,582 15,192 1,934,291 23,906,641 31,774 23,938,415 DRAFT 23,698,294 Page 38 of45 &[DATE] SH ELL-MCCLU RG-053893 Benzene Health Research Consortium Income 2Q07 Financial Report ST ~ 4th Qtr. ~ 1stQtr. "I 4,916,018 56,081 UV 2007 2nd Qtr. 3rd Otr. 3,119,412 46,996 1,039,804 W 4th Qtr. X 1stQtr. YZ 2008 2nd Otr. 3rd Otr. AA 4th Qtr. 20,000 10,000 5,000 4,972,098 3,166,408 1,039,804 20,000 ~ 28,910,513 28,910,513 32,076,921 33,116,725 33,136,725 AB TOTALS 32,773,528 301,996 76,202 33,136,725 1 ~ 14 Page 39 of45 &[DATE] SH ELL-MCCLU RG-053894 Benzene Health Research Consortium Sponsor Invoice Detail 2Q07 Financial Report A T B CD EF 2001 G HI J 2002 (1 st - 2nd Otr.) K LM 2002 (3rd - 4th Otr.) N0 2003 P Q 2 Company Name 3 BP 4 5 6 Chevron 7 8 9 ConocoPhillips 10 11 12 ExxonMobii 13 14 15 16 Shell 17 18 19 20 Marathon 21 22 Total 23 24 25 26 (Seed Money) $15,000 $22,500 Inv. # 522922 528453 Date Paid 8-Nov-00 19-Jun-01 $15,000 522923 7-Nov-00 22-Aug-01 $768,941 Inv. # Date Paid 529301 4-0cl-01 $522,627 529302 9-0cl-01 $15,000 $7,500 522924 31-0cl-00 528574 31-Jul-01 $0 523540 $246,314 529309 17-Sep-01 $15,000 $15,000 523054 24-0cl-00 528333 15-May-01 $507,627 529305 25-Sep-01 $15,000 528541 14-Aug-01 $120,000 $2,045,509 2006 Invoicing Amendment NO.3 2007 9-Jan-02 $806,441 $537,627 $268,814 $1,612,882 $806,441 $806,441 $537,627 $5,376,273 Projected Inv. # 532263 532244 532245 532246 532247 Date Paid 22-Feb-02 27-Aug-02 $1,344,069 $112,008 Inv. # 535033 Date Paid 11-0cl-02 2-0cl-02 22-Feb-02 $896,046 535034 5-Nov-02 23-Sep-03 $1,431,041.00 Inv. # Date Paid 544951 4-Dec-03 $1,028,700.00 544953 19-Nov-03 27-Jan-05 $2,568,545.00 $365,334.00 16-Jan-02 $448,023 535035 26-Sep-02 $514,349.00 544954 27-0cl-03 $548,000.00 23-Jan-02 11-Feb-02 $1,344,069 535036 13-Sep-02 $1,543,049.00 $771,524.50 $771,524.50 544956 3-0cl-03 22-Mar-04 $548,000.00 $274,000.00 7-Feb-02 $896,046 $448,023 $448,023 535037 25-Sep-02 10-Feb-03 $1,028,700.00 $514,350 $514,350 544958 28 Ocl 03 14 Jan 04 $365,334.00 Maralhon Ashland Maralhon Oil $5,936,307 $150,000 $50,000 $8,317,588.00 548582 548581 20-Jan-04 3-Feb-04 $0 $4,669,213.00 2007 Projected Invoicing Amendment No.4 2008 Projected 27 Company Name 28 BP 29 30 Chevron 31 32 ConocoPhillips 33 34 ExxonMobii 35 36 37 Shell 38 39 40 Marathon 41 42 Total 43 44 45 LT 8/18/05 46 RT 8/112007 Amount $0.00 Inv. # Date Paid Amount $0.00 Inv. # Date Paid TOTALS $7,068,545 $911,959.00 575044 10-0cl-06 $435,071.00 581762 30-Apr-07 $4,712,364 $308,182 575045 19-Jun-06 $0.00 $2,356,182 $1,093,939 575042 31-May-06 $652,606.00 581763 28-Feb-07 $7,068,545 $400,000.00 $511,959 571301 575043 $0 $3,226,039 3-Mar-06 2-Jun-06 $435,071.00 581764 31-Jan-07 $4,712,364 $0 $215,000 $1,522,748 $26,133,000 DRAFT Company Name BP Chevron ConocoPhillips ExxonMobii Shell Marathon Total Amount Inv. # $2,481,311 Date Paid 1-Dec-06 $1,039,804 591129 $519,902 591131 30-Jun-07 $1,559,706 591130 30-Jun-07 $1,039,804 591128 30-Jun-07 $0 $6,640,527 Amount Inv. # $0 Date Paid $614,404 $307,202 $921,606 $614,404 $0 $2,457,616 TOTALS $9,549,856 $6,366,572 $3,183,286 $9,549,857 $6,366,572 $215,000 $35,231,143 Page 40 of45 &[DATE] SH ELL-MCCLU RG-053895 Benzene Health Research Consortium Sponsor Invoice Detail 2Q07 Financial Report R T 005 S TU 2006 V WX 2007 Y Z AA AB 2008 2 Inv. # Date Paid 3 563928 11-Jul-05 4 5 6 560056 19-Jul-05 7 8 9 560057 18-Mar-05 10 11 12 560058 17-Feb-05 13 564774 27-Dec-05 14 15 16 560059 28-Apr-05 17 18 19 20 21 4-Apr-06 $2,481,311.00 $911,959.00 $308,182.00 $1,093,939.00 $400,000.00 $511,959 $0 22 $5,707,350.00 23 24 25 26 Inv. # Date Paid $0.00 575044 10-0cl-06 575045 19-Jun-06 $435,071.00 $1,039,804.00 $519,902.00 575042 31-May-06 $652,606.00 $1,559,706.00 571301 575043 3-Mar-06 2-Jun-06 $435,071.00 $1,039,804.00 $0 $5,681,964.00 Inv. # Date Paid Inv. # $0 Date Paid 581762 591129 30-Apr-07 591131 30-Jun-07 581763 28-Feb-07 591130 30-Jun-07 581764 591128 31-Jan-07 30-Jun-07 $0 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 AC PAID TOTALS $7,068,545 $4,712,364 $2,876,084 $8,628,251 $5,752,168 $215,000 $29,252,412 26133 25859 274 Page 41 of45 &[DATE] SH ELL-MCCLU RG-053896 Benzene Health Research Consortium Sponsor Payment Detail 2Q07 Financial Report 1 10 2 3 A CompanyName 19982 Shell Chemical 20086 ConocoPhillips B 4 20972 ChevronTexaco 5 20239 BP International Limited 6 28285 Shell Chemical 7 28929 BP International Ltd 8 29861 ConocoPhillips 9 30179 Marathon Ashland Petroleum, LLC, 10 30853 ConocoPhillips 11 31000 Shell Chemical 12 31141 BP p,l.c, 13 31179 ChevronTexaco 14 33206 ConocoPhillips 15 34334 ExxonMobil Research and Engineering 16 34823 Shell Chemical 17 34889 ExxonMobil Research and Engineering 18 35200 ChevronTexaco 19 35207 BP p,l.c, 20 38625 ExxonMobil 21 38748 Shell Chemical 22 38779 ConocoPhillips 23 39101 BP p,l.c, 24 39214 BP p,l.c, 25 39493 ChevronTexaco 26 42934 American Petroleum Institute 27 44094 Shell Chemical 28 51153 ExxonMobil 29 51869 ConocoPhillips 30 51891 Shell Chemical 31 52332 ChevronTexaco 32 52633 BP p,l.c, 33 54618 Marathon Ashland Petroleum, LLC, 34 54472 Shell Chemical 35 55187 Marathon Oil Company 36 57362 ExxonMobil 37 560057 ConocoPhillips 38 560058 ExxonMobil 39 560059 Shell Chemical 40 41 563928 BP p,l.c, 42 560056 Chevron 43 79001 ExxonMobil 44 45 46 571301 Shell Chemical 47 575042 ExxonMobil 48 575045 Shell Chemical 49 575043 ConocoPhillips 50 51 52 none 575044 Chevron BP p,l.c, 53 581762 Chevron 54 581763 ExxonMobil 55 581764 Shell Chemical 56 591128 Shell Chemical 57 591130 ExxonMobil PaymentDate C DE PaymentAmount TOTALS 10/24/2000 $ 15,000,00 10/31/2000 $ 15,000,00 11/7/2000 $ 15,000,00 yr 2000 11/8/2000 $ 15,000,00 $ 60,000,00 5/15/2001 $ 6/19/2001 $ 7/31/2001 $ 8/14/2001 $ 9/17/2001 $ 9/25/2001 $ 10/4/2001 $ 10/9/2001 $ 15,000,00 22,500,00 7,500,00 15,000,00 246,314,00 507,627,00 768,941,00 522,627,00 $ yr 2001 2,105,509,00 1/16/2002 $ 1/23/2002 $ 2/7/2002 $ 2/11/2002 $ 2/22/2002 $ 2/22/2002 $ 9/13/2002 $ 9/25/2002 $ 9/26/2002 $ 10/2/2002 $ 10/11/2002 $ 11/5/2002 $ 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 $ yr 2002 8,355,629,00 1/17/2003 $ 2/10/2003 $ 109 448,023,00 $ 1+2Q03 448,024,09 10/3/2003 $ 10/27/2003 $ 10/28/2003 $ 11/19/2003 $ 12/4/2003 $ 771,524,50 514,349,00 514,350,00 1,028,700,00 4Q03 1,431,041,00 $ 4,259,964,50 1/20/2004 $ 1/13/2004 $ 2/3/2004 $ 3/22/2004 $ 150,000,00 514,350,00 50,000,00 771,524,50 $ 1Q04 1,485,874,50 3/18/2005 $ 2/17/2005 $ 548,000,00 1Q05 548,000,00 $ 1,096,000,00 4/28/2005 $ 365,334,00 $ 2Q05 365,334,00 7/11/2005 $ 7/19/2005 $ 2,568,545,00 3Q05 365,334,00 $ 2,933,879,00 12/27/2005 $ 274,000,00 $ 4Q05 274,000,00 3/3/2006 $ 400,000,00 $ 1Q06 400,000,00 5/31/2006 $ 1,093,939,00 2Q06 6/2/2006 $ 6/21/2006 $ 511,959,00 308,182,00 $ 1,914,080,00 10/10/2006 $ Oec-06 $ 911,959,00 $ 2,481,311,00 4Q06 3,393,270,00 1/31/2007 $ 2/28/2007 $ 435,071,00 1Q07 652,606,00 $ 1,087,677.00 4/30/2007 $ 435,071,00 2Q07 6/30/2007 $ 1,039,804,00 6/30/2007 $ 1,559,706,00 F Page 42 of45 G &[DATE] SH ELL-MCCLU RG-053897 A oil 591131 ConocoPhillips 59 60 61 62 LT 8/3/05 63 RT 8/1/2007 B DRAFT Benzene Health Research Consortium Sponsor Payment Detail 2Q07 Financial Report C 6/30/2007 $ (note - does not include interest income) $ DE 519,902.00 $ 3,554,483.00 31,733,724.09 F G $31,733,724.09 Page 43 of45 &[DATE] SH ELL-MCCLU RG-053898 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 BP p.Lc. 11 BP p.Lc. 12 ChevronTexaco 13 ChevronTexaco 14 ChevronTexaco 15 ChevronTexaco 16 ChevronTexaco 17 ChevronTexaco 18 Chevron 19 Chevron 20 ConocoPhillips 21 ConocoPhillips 22 ConocoPhillips 23 ConocoPhillips 24 ConocoPhillips 25 ConocoPhillips 26 ConocoPhillips 27 ConocoPhillips 28 ConocoPhillips 29 ExxonMobil Research and Engineering 30 ExxonMobil Research and Engineering 31 ExxonMobil 32 ExxonMobil 33 ExxonMobil 34 ExxonMobil 35 ExxonMobil 36 ExxonMobil 37 ExxonMobil 38 ExxonMobil 39 Marathon Ashland Petroleum, LLC. 40 Marathon Ashland Petroleum, LLC. 41 Marathon Oil Company 42 Shell Chemical 43 Shell Chemical 44 Shell Chemical 45 Shell Chemical 46 Shell Chemical 47 Shell Chemical 48 Shell Chemical 49 Shell Chemical 50 Shell Chemical BHRC Sponsor Payments Organized by Sponsor Company - 2Q07 BC D Date Paid Amount 1117/2003 $ 1.09 (I am trying to get this $1.09 removed from the books) 1118/2000 6/19/2001 10/4/2001 2/22/2002 10/2/2002 10/1112002 12/4/2003 7/1112005 12/112006 $ $ $ $ $ $ $ $ $ 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 2,481,311.00 $ BP Total 7,068,545.00 1117/2000 10/9/2001 2/22/2002 1115/2002 11119/2003 7/19/2005 10/10/2006 4/30/2007 $ $ $ $ $ $ $ $ 15,000.00 522,627.00 537,627.00 896,046.00 1,028,700.00 365,334.00 911,959.00 435,071.00 $ ChevronTexaco Total 4,712,364.00 10/3112000 7/3112001 9/17/2001 1116/2002 9/26/2002 10/27/2003 3/18/2005 6/19/2006 6/30/2007 $ $ $ $ $ $ $ $ $ 15,000.00 7,500.00 246,314.00 268,814.00 448,023.00 514,349.00 548,000.00 308,182.00 519,902.00 $ ConocoPhillips Total 2,876,084.00 1/23/2002 2/1112002 9/13/2002 10/3/2003 3/22/2004 2/17/2005 12/27/2005 5/3112006 2/28/2007 6/30/2007 $ $ $ $ $ $ $ $ $ $ 806,441.00 806,441.00 1,344,069.00 771,524.50 771,524.50 548,000.00 274,000.00 1,093,939.00 652,606.00 1,559,706.00 $ ExxonMobil Total 8,628,251.00 8/14/2001 $ 1/20/2004 $ 2/3/2004 $ 15,000.00 150,000.00 50,000.00 $ Marathon Ashland Total 215,000.00 10/24/2000 5/15/2001 9/25/2001 2/7/2002 9/25/2002 2/10/2003 10/28/2003 1113/2004 4/28/2005 $ $ $ $ $ $ $ $ $ 15,000.00 15,000.00 507,627.00 537,627.00 448,023.00 448,023.00 514,350.00 514,350.00 365,334.00 Shell Chemical Total E Page 44 of 45 &[DATE] SH ELL-MCCLU RG-053899 51 Shell Chemical 52 Shell Chemical 53 Shell Chemical 54 Shell Chemical 55 56 LT 8/3/05 57 RT 8/1107 A B 3/3/2006 $ 6/2/2006 $ 113112007 $ 4/30/2007 $ $ DRAFT C 400,000.00 511,959.00 435,071.00 1,039,804.00 31,733,724.09 $ BHRC Sponsor Payments Organized by Sponsor Company - 2Q07 D 5,752,168.00 E Page 45 of 45 &[DATE] SH ELL-MCCLU RG-053900