Document 3epydK1ybJ5kLwoO6wNx4BZNx

From: Sent: To: Subject: Attach: Russell White <whiter@api.org> Monday, April 9, 2007 4:48 PM (GMT) BenzConsort-TC@listserve.api.org; BenzConsort-OC@listserve.api.org; myron.c.harrison@exxonmobi1.com; Snyder, Phil J SCC-DXX/9 <phil.snyder@shell.com> Shanghai Health Study - potentially useful materials for TODAY's call DRAFT 2006 EOY budget.xls; Timing of sponsor payments.xls Attached are the Amendment 4 budget summary and the executive summary sheet from the DRAFT 2006 EOY budget report. These may be useful for today's call. DRAFT 2006 EOY budget.xls Timing of sponsor payments.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-053688 SHANGHAI HEALTH STUDY - BUDGET ESTIMATE TO FINISH STUDY AND SUPPORT PUBLICATIONS AND LABORATORY PERSONNEL A 1 2 3 4 Cost Centers BC Original 2007 EOY projection D EF CURRENT Proposed APPROVED Increase BUDGET 2007 Sep-06 GH Proposed Increase 2008 IJ Proposed Increase 2009 K L Total M 5 6 UCHSC/Publications 7 JCML 8 JCML Personnel 9 Irons-Field Expense 10 Applied Health Sciences 11 Fudan Case Control 12 Scientific & Ethics Panels 13 Communications 14 Outside Legal Counsel 15 QAlQC Support 16 API Administrative 17 Exposure Assessment 18 Committed Contingency 19 Contingency #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! 18,332,769 - 1,413,428 2,930,841 379,829 473,142 300,000 140,000 50,000 1,445,205 109,000 156,391 402,395 1,019,274 4,740,590 400,000 - 165,663 - 100,000 65,000 150,000 - - 400,000 - 632,615 65,000 95,000 100,000 - 165,000 - 1,000,000 - 19,752,043 - 4,740,590 - 400,000 - 1,413,428 - 3,729,119 - 444,829 - 568,142 - 500,000 - 205,000 - 200,000 - 1,610,205 - 109,000 - 156,391 - 1,402,395 20 21 Total Expenses #REF! $ 26,133,000 $ 6,640,527 $ 2,457,615 $ - $ 35,231,142 22 23 24 New Sponsor Payments $ 2,481,311 $ 4,159,216 $ 2,457,615 $ - $ 35,231,142 25 26 BP 27 Chevron 28 ConocoPhillips 29 ExxonMobil 30 Shell Chemical 31 Total $ 2,481,311 $$$$$ 2,481,311 $$ 1,039,804 $ 519,902 $ 1,559,706 $ 1,039,804 $ 4,159,216 $$ 614,404 $ 307,202 $ 921,606 $ 614,404 $ 2,457,615 $ $ $ $ $ $ - $ 2,481,311 - $ 1,654,208 - $ 827,104 - $ 2,481,312 - $ 1,654,208 - $ 9,098,142 Timing of Sponsor Payments DRAFT, Data from EOY 2006 SH ELL-MCCLU RG-053689 SHANGHAI HEALTH STUDY - BUDGET ESTIMATE TO FINISH STUDY AND SUPPORT PUBLICATIONS AND LABORATORY PERSONNEL Timing of Sponsor Payments N0 1 2 3 4 Interest 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 276,202 20 21 $ 276,202 22 23 24 25 26 27 28 29 30 31 P DRAFT, Data from EOY 2006 SH ELL-MCCLU RG-053690 AB 1 2 3 4 5 6 7 Cost Centers Project # 8 9 Income 10 11 12 Cost Centers 13 UCHSC* X8105 14 Irons-Field Expense* X8106 15 Applied Health Sciences X8107 16 Fudan University X8108 17 Scientific & Ethics Panels X8109 18 Communications X8103 19 Outside Legal Counsel X8104 20 QAJQC Support X8110 21 API Administrative X8100 22 Exposure Assessment 23 Contingency** x8111 24 25 Total Expenses 26 27 Fund Balance 28 29 30 blue is projected fund balanced to project when current funds will run out 31 * amount disbursed by API ..;;.~ ** $300K added to contingency; $250K from Communicaitons & $50K 34 from QAJQC 35 *** ConocoPhillips pay remaining commitment in 2005 36 37 LT 8/3/05 DRAFT 38 RW 2/20/06 39 RT 7/19/06 40 rdw 10/19/06 C Inception Thru December 2004 $ 16,765,693 10,137,850 788,486 1,391,014 124,090 181,713 294,161 64,529 - 856,208 - 104,473 $ 13,942,525 $ 2,823,169 DE Actuals Actuals Jan - Dec 2005 Actuals Jan - Dec 2006 $ 5,206,657 $ 6,938,163 3,624,030 262,000 548,720 4,007 76,176 - 33,706 - 170,475 - 51,918 4,000,000 262,000 558,214 76,377 95,418 - 39,154 1,202 160,782 12,324 - $ 4,771,033 $ 5,205,472 $ 3,298,247 F Actuals Program to Date $ 28,910,513 17,761,880 1,312,486 2,497,948 204,474 353,308 294,161 137,390 1,202 1,187,466 12,324 156,391 $ 23,919,030 $ 5,030,938 G H I JK Cummlative 2006 EOY projection $ 28,910,513 2006 Jan - Dec $- 13,778,460 990,282 $ 17,761,880 1,312,486 2,487,687 222,569 350,439 296,107 129,479 16,667 1,190,183 40,000 156,391 23,963,888 4,000,000 262,000 547,953 94,472 92,549 1,946 31,244 16,667 163,500 40,000 - $ 5,250,331 Contingency Budget spent as of 2Q06 Remaining 854,988 156,391 698,596 SHELL-MCCLURG-053691 LM N 0 P Q 1 2 3 Budgeted 4 5 PROJECTED 6 2006 2007 Projected Program 7 Jan - Dec Jan - Dec inc/exp Budget 8 Income 9 $ 2,826,039 $ 1,535,748 30,446,261 $ 26,429,202 10 11 12 Expenses 13 4,000,000 570,889 18,332,769 18,332,769 14 262,000 100,942 1,413,428 1,413,428 15 547,953 502,311 3,000,259 2,930,841 16 94,472 80,704 285,178 379,829 17 92,549 96,726 450,034 473,142 18 1,946 1,946 296,107 300,000 19 31,244 31,242 168,632 140,000 20 16,667 16,667 17,869 50,000 21 163,500 225,450 1,412,916 1,445,205 22 40,000 23 - 69,000 - 81,324 156,391 109,000 854,988 24 25 $ 5,250,331 $ 1,695,877 $ 25,614,907 $ 26,429,202 26 27 $ 873,955 $713,826 28 29 30 31 32 Income Detail 33 sponsors 28,399,312 34 MAP contrib. $215,000 35 API interest 220,000 36 UCHSC interest 76,202 37 38 TOTAL $28,910,513 39 40 SH ELL-MCCLU RG-053692 A BC D E FGH I J K LM 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 ~ ~34 35 36 37 38 SH ELL-MCCLU RG-053693 N0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 P Q SH ELL-MCCLU RG-053694