Document 15enLzpwaZJLRVo2o3g5gZkLd
From: Sent: To:
Cc: Subject: Attach:
Paula Podhasky <Podhaskyp@api.org> Tuesday, May 6, 2003 8:28 PM (GMT) Cagen, Stuart Z SCC <stuart.cagen@Shel1.Com>; Samuel, Tarita B SCC <taritao samuel@Shell. Com> BenzConsort-TC@listserve.api.org RE: Benzene cost tracking UC cashflow.xls
OOPs forgot to attach this one. It is the UC grant spreadsheet. The Technical Committee may wish to edit and add milestones. pp
-----Original Message----From: Paula Podhasky
Sent: Tuesday, May 06, 2003 4:08 PM
To: Cagen, Stuart Z SCC; Samuel, Tarita B SCC Cc: BenzConsort-TC@listserve.apLorg; BenzConsort-CC@listserve.apLorg
Subject: RE: Benzene cost tracking
Stu and Tarita, Here is some of the material requested. The Technical Committee is responsible for the research related contracts and therefore will need to identify milestones and associated costs for those contracts. Included under the research umbrella are: ERP, SRP, Fudan, UC Grant, Irons, AHS. Bruce Jarnot is the contact with UC (Mary McConnell). The Communications committee oversees the APCO contract and therefore should provide that information. I do not manage any BHRC contracts but, I do track income, administration costs and other operating expenses and can provide more detail as required. By copy of this email I would like the Technical and Communications Committees to identify milestones and if available the associated cost/payments. Thank you, Paula Podhasky
-----Original Message----From: Cagen, Stuart Z SCC [mailto:stuart.cagen@shell.com]
Sent: Tuesday, May 06,20033:13 PM
To: Paula Podhasky; Samuel, Tarita B SCC
Subject: Benzene cost tracking
Paula:
Tarita Samuel (of Shell Chemical LP) has agreed to look through some of the Shanghai Benzene financials to help the consortium get an improved sense of study costs and projections.
I am away on vacation this week, but I spoke with her briefly today about our current situation. What I think we need:
1) tracking study costs, including costs peripheral to the study such as investigator expenses and travel, as well as costs peripheral to the investigators, communications budgets (contractors), and main study administration via API. All of this is captured in a total study budget of almost $ 23 million ..
2) this tracking should be in association with study performance milestones, including projected costs and
SH ELL-MCCLU RG-053029
milestones until work is in public literature 3) early warning in possible overspending. I would guess this is going to be an iterative process, with the help of the technical committee for the milestones part. Paula: you or Bruce or Lorraine should still be the direct contacts with the University of Colorado and Applied Health Sciences but Tarita could help frame the questions. Paula: I have not yet seen your note with the spreadsheets for me to forward to Tarita, so please send her a copy when you sent them to me so she is not waiting for me to forward these. Now that I have connected the two of you, please feel free to contact each other directly. Thanks Stuart Stuart Cagen Shell Chemical LP One Shell Plaza, 910 Louisiana, Houston, TX 77002-4916 Tel: +1 713241 1407 Fax: +1 713241 3325 Other Tel: +1 8326463987 Email: stuart.cagen@shell.com Internet: http://www.shell.com/chemicals
SH ELL-MCCLU RG-053030
University of Colorado Grant: Cash Flow
A 1 2 3 4
5
6
7
r.!.. Cumulative Payment Total 9
10
11
12 Payments
13
14 Personnel 15 Budgeted 16 Operating Expenses 17 Budgeted 18 Subcontracts 19 Budgeted 20 Travel 21 Budgeted 22 Equipment 23 Budgeted 24 Indirect 25 Budgeted 26 TOTALS 27 Budgeted
28
29 Balance
30 31 Notes: 32 33 34
35 36
B
Oec-01 1,200,000
C
Actual
Jun-02 4,099,505
1,200,000
2,899,505
$172,140
$224,883
$13,131
$94,401
$123,629
$688,452
$0 $8,429
$291,568
$253,578
$47,922
$111,454
$648,390
$1,381,197
551,610
2,069,918
1 Payments are made in August 2 Real budget values were used when available. 3 Travel is included for trainees; part of this budget. 4 The large fluctuations in the subcontracts is due to EMBSI invoicing UC for the total amount due at the beginning of their fiscal year
5 The increased "subcontracts" amount for Dec-02 is for 2001-2002 funds due to EMBSI subcontract 6 The Grant ends Dec-06.
DE
Oec-02
7,515,759
3,416,254
$348,277 $284,061 $1,106,578
$15,518 $665,067 $168,442 $2,587,943 2,898,230
SH ELL-MCCLU RG-053031
University of Colorado Grant: Cash Flow
FG H
I
J
K
LM
N
1
2
3 Projected
4
5
Jun-03
Dec-03
Jun-04
Dec-04
Jun-05
Dec-05
Jun-06
Dec-06
Totals
6
7
8
10,096,509
12,677,259
15,258,009
9
10
11 12 2,580,750 2,580,750 2,580,750
13
14
15 $331,316
$293,007
$282,480
$297,450
$293,713
$310,768
$298,684 $244,179
$3,096,897
16
17 $198,373
$259,003
$228,529
$268,289
$252,851
$301,653
$277,143 $151,160
$2,328,595
18
19 $549,014
$988,733
$449,506
$934,456
$453,377
$860,043
$415,102 $202,694
$6,771,584
20
21 $11,340
$4,127
$3,418
$4,245
$0 $1,852 $1,945
$0 $50,873
22
23 $0 $350,000 $0 $0 $0 $0 $0 $0 $1,560,213
24
25 $140,668
$144,596
$133,751
$148,196
$142,107
$159,711
$150,221 $102,788
$1,449,855
26
27 $1,230,711 $2,039,465 $1,097,683 $1,652,637 $1,142,048 $1,634,027 $1,143,094 $700,822 $15,258,017
28
29 1,667,518 2,208,803 1,111,120 2,039,233
30 31 32 33 34
897,185
1,843,908
700,814
Contract SRP total
-8
$ $ $
13,665,017 1,593,000
15,258,017
35 $15,258,017 36
SH ELL-MCCLU RG-053032