Document 6B97oq8QqeJjpDxNk9Jonzwpm
To: stephen. m. bowes@exxonmobil.com <stephen. m. bowes@exxonmobil.com>; Cagen,
Stuart Z SHLOIL-SHOIL-SHS <stuart.cagen@shell.com>
From:
Russell White <whiter@api.org>
Cc: Clegg, Patsy M SCC-DCS/22 <patsy.clegg@shell.com>; Robin Tillery
<tilleryr@api.org>
Bcc:
Received Date:
2006-07-0512:05:12 GMT
Subject:
Benzene Health Research Consortium - Mid year budget
Steve & Stuart,
Attached is the standard API finance report that is updated every month. I would like to review it with you, show you the "drill down" feature and other quirks, perhaps the week of July 10? Send me you availability.
This report doesn't meet the needs of a multi-year project in several areas (income detail and contingency fund management to name a few) but it does a great job of tracking monthly expenditures and is the authoritative source for current funds available. I think we can simplify budget management if we use it as the core resource and augment it with a few manually maintained spreadsheets. I would like to discuss that possibility when we review the spreadsheets.
>
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
Attachments: SHS Budget June 30 2006.xls
SHELL-MCCLURG-062516
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J) 1. Table of Contents I'V
c..n
.....lo.
-.....J
37136.62 Report Name Statement of Operation s Statement of Operation s Trended by Month Current Month General Ledger Detail YTD General Ledger Detail
American Petroleum Institute Report Workbook Table of Contents Benzene Health Research (SP5200X81)
Period Ended June 30, 2006
AUTODATE,AUTODATE
Report Explanation
1 of 42
llJ C\I f- '<t
-0 0
0 C\I
f-
::J
llJ
f-
0
0
f-
::J
(J)
c
:;0::::;
.C..O..
Q)
Cl..
1/1 0
-...1/1
Q)
0
Q.
-EQ.
-en:::s (j)
.0.. C\i
Q)
N
U;
SHELL-MCCLURG-062518
llJ C\I f- '<t
-0
0
0 cry
f-
::J
llJ
f-
0
0
f-
::J
(J)
oc
~
Q)
oCl..
'0
E
U5
C\i
SHELL-MCCLURG-062519
llJ C\I f- '<t
-0 0
0 '<t
f-
::J
llJ
f-
0
0
f-
::J
(J)
oc
~
Q)
oCl..
'0
E
U5
C\i
SH ELL-MCCLU RG-062520
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
I
0
(J) 2. Stmt of Operations
I'V
c..n
I'V
.....lo.
AUTODATE,AUTODATE
ZeroSupp 6,232,479 30,707 5,107,833 1,093,939 6,232,479 6,232,479
240,127 98,314 98,314
12,096 12,096
1,223 1,223
533 533
Revenue 7050 7601 7610 Total Revenue
Interest Income Leveraged Research Revenue Special Solicitations
Operating
Expenses
Salaries
901B
Salaries
Employee
benefits &
payroll
taxes
903B
Emp. benefits & payroll taxes
Employee
business
expenses
9111
Travel & Entertainment
Other
operating
expenses
9125
Food & Beverage
917B
Other operating expenses
5 of 42
American Petroleum Institute Statement of Operations
Benzene Health Research (SP5200X81) Period Ended June 30, 2006
DRAFT
AUTODATE,AUTODATE
Current Month Actual Budget Variance
Actual
Year to Date
Budget
Variance
Total Year Pending Executed Remaining Budget Contracts Contracts Balance
268,833 (268,833) 268,833 (268,833)
20,211 1,093,939 1,114,150
495 1,613,000
19,716 (1,613,000)
1,093,939
1,613,495 (499,345)
10,000 3,226,000
3,236,000
.d .d .d
- (2,121,850) .d
4,337 4,337
4,337 4,337
22,675 22,675
22,303 22,303
(373) (373)
49,000 49,000
531 531
2,834
2,731
(103)
6,000
531 531
2,834
2,731
(103)
6,000
(J)
I
m
r
1,223
(1,223)
s:r I
1,223
(1,223)
()
()
r 533 (533)
C
;a
533 (533)
G)
I
0
(J) 2. Stmt of Operations I'V c..n I'V I'V
26,325 .d 26,325 .d
3,166 .d 3,166 .d
(1,223) .d (1,223) .d
(533) .d (533) .d
-.d
6 of 42
llJ C\I f- '<t
-0
0
0
r--.
f-
::J
llJ
f-
0
0
f-
::J
(J)
c
:;0::::;
.C..O..
Q)
Cl..
1/1 0
-...1/1
Q)
0
Q.
-EQ.
-en:::s (j)
.0.. C\i
Q)
N
U;
SH ELL-MCCLU RG-062523
llJ C\I f- '<t
-0
0
0
ex:>
f-
::J
llJ
f-
0
0
f-
::J
(J)
oc
~
Q)
oCl..
'0
E
U5
C\i
SH ELL-MCCLU RG-062S24
llJ C\I f- '<t
-0 0
0 0')
f-
::J
llJ
f-
0
0
f-
::J
(J)
oc
~
Q)
oCl..
'0
E
U5
C\i
SH ELL-MCCLU RG-062525
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
I
0
(J) 2. Stmt of Operations I'V c..n I'V
(J)
AUTODATE,AUTODATE
ZeroSupp 27,960
100,000
240,127 240,127
15,089,700 116,874 4,000 98,230
15,836,667 1,624,142 2,198,037 418,490 207,957 34,000
(5,448,697)
15,089,700 15,089,700
15,329,826
9941 9945
API Recovered Overhead API Allocated Costs
Total Operating Expenses
Project
Expenses
X8101
General Account
X8103 Communications
X8104
Legal
X8105
USCHS
X8106
Irons-Field
X8107 Applied Health Sciences
X8108
Fudan Unversity
X8109 Scientific/Ethics Panels
X8110 QAlQC Support
X8199 Total
Prior Year Commitments
Project
Expenses
Total Expenses
10 of 42
American Petroleum Institute Statement of Operations
Benzene Health Research (SP5200X81) Period Ended June 30, 2006
DRAFT
AUTODATE,AUTODATE
Current Month
Actual Budget Variance
1,239
1,239
4,167
4,167
Year to Date
Actual
Budget
6,349
6,372
20,833
25,000
Variance 23
4,167
Total Year Pending Budget Contracts 14,000
50,000
Executed Contracts
Remaining Balance 7,651 .d 29,167 .d
10,273
10,273
54,448
56,406
1,958
119,000
64,552 .d
38,958
38,958
38,958
2,000
2,000
2,000
3,729
(3,729)
11,860
36,295
24,435
36,295
2,000,000 5,632,889 3,632,889 5,632,889
131,000
628,714
497,714
628,714
31,008
(31,008)
185,277
905,010
719,733
905,010
157,830
157,830
157,830
2,400
(2,400)
7,600
90,652
83,052
90,652
(J)
17,000
17,000
17,000
I
m
r r
s:I 37,137
(37,137)
(2,724,348) (2,724,348) (2,724,348)
2,335,737
4,785,000 2,449,263
4,785,000
()
()
r
C
37,137 10,273 (26,863)
2,390,185 4,841,406 2,451,221
4,904,000
;a
G)
I
0
(J) 2. Stmt of Operations
I'V
c..n
I'V -.....J
38,958
10,050 2,570,889
235,714 171,733 102,830
16,652
-
-.d 2,000 .d 14,385 .d 1,062,000 .d 262,000 .d 548,000 .d 55,000 .d 66,400 .d 17,000 .d (2,724,348) .d
3,146,826 (697,563) .d
3,146,826
(633,011) .d
11 of 42
llJ C\I f- '<t
-0 0
0 C\I
f-
::J
llJ
f-
0
0
f-
::J
(J)
c
:;0::::;
.C..O..
Q)
Cl..
1/1 0
-...1/1
Q)
0
Q.
-EQ.
-en:::s (j)
.0.. C\i
Q)
N
U;
SH ELL-MCCLU RG-062528
llJ C\I f- '<t
-0
0
0 cry
f-
::J
llJ
f-
0
0
f-
::J
(J)
oc
~
Q)
oCl..
'0
E
U5
C\i
SH ELL-MCCLU RG-062529
llJ C\I f- '<t
-0 0
0 '<t
f-
::J
llJ
f-
0
0
f-
::J
(J)
oc
~
Q)
oCl..
'0
E
U5
C\i
SH ELL-MCCLU RG-062S30
llJ
f-
0
0
f-
::J
llJ
f-
0
0
f-
::J
Q)
_ 0E
Q) U
z..!:
r:::-
aa..
'<t
Ct)
...en:::l ~ 0')
00
Q) e;":
N
-C\I
'<t
0
L()
(J)
oc
~
Q)
oCl..
'0
E
U5
C\i
SH ELL-MCCLU RG-062S31
American Petroleum Institute Statement of Operations
Benzene Health Research (SP5200X81) Period Ended June 30, 2006
DRAFT
AUTODATE,AUTODATE
Current Month Actual Budget Variance
Actual
Year to Date
Budget
Variance
Total Year Pending Executed Remaining Budget Contracts Contracts Balance
$ (37,137) $ 258,560 $ (295,697) $ (1,276,035) $ (3,227,910) $1,951,875 $ (1,668,000) $ - $ (3,146,826) (2,754,860)
Beginning year fund 3,298,248 balance
- Net Transfers ------Current fund
2,022,213 balance
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI (J) 2. Stmt of Operations
I'V
c..n
c..> I'V
16 of 42
llJ C\I f- '<t
-0
0
0
r--.
f-
::J
llJ
f-
0
0
f-
::J
(J)
c
:;0::::;
.C..O..
Q)
---Cl..
0
0
E
(j)
"0
III Q)
...III "0
Q) C
Q. .Q...).
Q.
:::s
f-
(/) M
.0..
Q)
N
ll.
SH ELL-MCCLU RG-062S33
llJ C\I f- '<t
-0
0
0
ex:>
f-
::J
llJ
f-
0
0
f-
::J
(J)
oc
~
Q)
oCl..
'0
E
U5
"0
Q)
"0 C
~ fet:>
SH ELL-MCCLU RG-062S34
llJ C\I f- '<t
-0 0
0 0')
f-
::J
llJ
f-
0
0
f-
::J
(J)
oc
~
Q)
oCl..
'0
E
U5
"0
Q)
"0 C
~ fet:>
SH ELL-MCCLU RG-062535
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI (J) 3. Trended Stmt of Operations
I'V
c..n
c..>
(J)
AUTODATE,AUTODATE
ZeroSupp
60,918 8,065,000 2,187,878 10,313,796 10,313,796
403,301 165,653 165,653
20,400 20,400
2,447 2,447
1,065 1,065
Revenue 7050 7601 7610 Total Revenue
Interest Income Leveraged Research Revenue Special Solicitations
Operating
Expenses
Salaries
901B
Salaries
Employee
benefits &
payroll
taxes
903B
Emp. benefits & payroll taxes
Employee
business
expenses
9111
Travel & Entertainment
Other
operating
expenses
9125
Food & Beverage
917B
Other operating expenses
20 of 42
AUTODATE,AUTODATE
American Petroleum Institute Trended Statement of Operations Benzene Health Research (SP5200X81)
Period Ended June 30, 2006
DRAFT
January February March
April
Year to Date Year to Date
May June Actual
Budget
January February March
April
May
(400,000) (400,000)
- 400,000
- 400,000
20,211 1,093,939
20,211 1,093,939
20,211 1,093,939 1,114,150
495 1,613,000
1,613,495
495 268,833 268,833 268,833 268,833 268,833
268,833 268,833 268,833 269,329 268,833
1,173 1,173
5,719 5,719
5,578 5,578
7,052 7,052
3,152 3,152
147 715 697
882 394
147 715 697
882 394
(J)
I
m
r 22 1,201
s:r I
22 1,201
()
()
r 109 423
C
;a
533
G) 109 (109) I
0
(J) 3. Trended Stmt of Operations I'V c..n c..> -.....J
22,675 22,675
22,303 22,303
4,715 4,715
3,103 3,103
2,453 2,453
4,186 4,186
3,509 3,509
2,834 2,834
1,223 1,223
533 533
2,731 2,731
577 380 300 513 430 577 380 300 513 430
21 of 42
AUTODATE,AUTODATE
June
July
Total Year August September October November December Budget
268,833
1,084 268,833
4,439 268,833
268,833 269,917 273,272
268,833
2,114 268,833
268,833
1,868 268,833
268,833 270,947 268,833 270,701
10,000 .d 3,226,000 .d
-.d
3,236,000 .d
4,337 4,337
3,109 3,109
5,891 5,891
3,339 3,339
4,806 4,806
7,567 7,567
1,986 1,986
49,000 .d 49,000 .d
531 381 721
409 588 927 243
6,000 .d
531 381 721
409 588 927 243
6,000 .d
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J) 3. Trended Stmt of Operations I'V
c..n
c..> ex>
-.d -.d
-.d -.d -.d
22 of 42
llJ C\I f- '<t
-0
0
f-
0 cry C\I
::J
llJ
f-
0
0
f-
::J
(J)
c
:;0::::;
.C..O..
Q)
---Cl..
0
0
E
(j)
"0
III Q)
...III "0
Q) C
Q. .Q...).
Q.
:::s
f-
(/) M
.0..
Q)
N
ll.
SH ELL-MCCLU RG-062S39
llJ C\I f- '<t
-0 0
0
f-
'<t C\I
::J
llJ
f-
0
0
f-
::J
(J)
oc
~
Q)
oCl..
'0
E
U5
"0
Q)
"0 C
~ fet:>
SH ELL-MCCLU RG-062540
llJ C\I f- '<t
-0 0
0
f-
L()
C\I
::J
llJ
f-
0
0
f-
::J
(J)
oc
~
Q)
oCl..
'0
E
U5
"0
Q)
"0 C
~ fet:>
SH ELL-MCCLU RG-062S41
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI
(J) 3. Trended Stmt of Operations I'V
c..n
..j:::o.
I'V
AUTODATE,AUTODATE
ZeroSupp 47,070
166,667
403,301 403,301
19,026,474 116,874 6,000 132,607
20,898,667 2,148,142 3,085,583 473,490 287,157 51,000
(8,173,045)
19,026,474 19,026,474
19,429,776
9941 9945
API Recovered Overhead API Allocated Costs
Total Operating Expenses
Project
Expenses
X8101
General Account
X8103
Communications
X8104
Legal
X8105
USCHS
X8106
Irons-Field
X8107
Applied Health Sciences
X8108
Fudan Unversity
X8109
Scientific/Ethics Panels
X8110 QAlQC Support
X8199 Total
Prior Year Commitments
Project
Expenses
Total Expenses
26 of 42
AUTODATE,AUTODATE
American Petroleum Institute Trended Statement of Operations Benzene Health Research (SP5200X81)
Period Ended June 30, 2006
DRAFT
January February March
328 1,601 1,562
4,167
4,167 4,167
April 1,975 4,167
May 883
4,167
June
Year to Date Year to Date
Actual
Budget
6,349
6,372
20,833
25,000
January February
1,347
887
4,167
4,167
March 701
4,167
April 1,196 4,167
May 1,003 4,167
5,814 12,312 12,449
15,277
8,596
54,448
56,406
10,807
8,536
7,620 10,061
9,108
38,958
38,958
2,000
2,000
5,776
2,356
3,729
11,860
36,295
36,295
2,000,000
2,000,000 5,632,889 5,632,889
- 131,000
131,000
628,714
628,714
73,855
35,436
44,978 31,008
185,277
905,010
905,010
157,830
157,830
2,800
2,400 2,400
7,600
90,652
90,652
(J)
17,000
17,000
I (2,724,348) (2,724,348)
m
r
r
s: -I
213,431 2,037,792
47,378 37,137 2,335,737 4,785,000 4,785,000
()
()
r
C
5,814 12,312 225,880 2,053,069
55,973 37,137 2,390,185 4,841,406 4,795,807
8,536
7,620 10,061
9,108
;a
G)
I
0
(J) 3. Trended Stmt of Operations
27 of 42
I'V
c..n
..j:::o.
c..>
AUTODATE,AUTODATE
June 1,239 4,167
July 888
4,167
August September
1,683
954
4,167
4,167
October November December
1,373
2,162
567
4,167
4,167
4,167
Total Year Budget 14,000 .d 50,000 .d
10,273
8,545 12,462
8,868 10,934
14,822
6,964
119,000 .d
38,958 .d
2,000 .d
36,295 .d
5,632,889 .d
628,714 .d
905,010 .d
157,830 .d
90,652 .d
(J) 17,000 .d
I (2,724,348) .d
m
r r
s:I 4,785,000 .d
()
()
r
C
10,273
8,545 12,462
8,868 10,934
14,822
6,964 4,904,000 .d
;a
G)
oI (J) 3. Trended Stmt of Operations
I'V
c..n
..j:::o.
..j:::o.
28 of 42
llJ C\I f- '<t
-0 0
0
f-
0') C\I
::J
llJ
f-
0
0
f-
::J
(J)
c
:;0::::;
.C..O..
Q)
---Cl..
0
0
E
(j)
"0
III Q)
...III "0
Q) C
Q. .Q...).
Q.
:::s
f-
(/) M
.0..
Q)
N
ll.
SH ELL-MCCLU RG-062545
rll-J
C\I '<t
-0 0
0r-
0
et)
::J
rll-J
0
0r-
::J
(J)
oc
~
Q)
oCl..
'0
E
U5
"0
Q)
"0 C
~
r-
et:>
SH ELL-MCCLU RG-062546
rll-J
C\I '<t
-0 0
T"""
0r- et)
::J
rll-J
0
0r-
::J
(J)
oc
~
Q)
oCl..
'0
E
U5
"0
Q)
"0 C
~
r-
et:>
SH ELL-MCCLU RG-062S47
rll-J
0
0r-
::J rll-J
0
0r-
::J
Q)
_ 0E
Q) U
z..!:
aa..
6ro'
0')
...e:n::l LC5
0
Q)
e;":
N
-C\I
'<t
0 C\I
et)
(J)
oc
~
Q)
oCl..
'0
E
U5
"0
Q)
"0 C
~
r-
et:>
SH ELL-MCCLU RG-062548
AUTODATE,AUTODATE
American Petroleum Institute Trended Statement of Operations Benzene Health Research (SP5200X81)
Period Ended June 30, 2006
DRAFT
January February March
April
Year to Date Year to Date
May June Actual
Budget
January February March
April
May
(405,814) (12,312) 174,120 (2,032,857) 1,037,966 (37,137) $ (1,276,035) $ (3,227,910) $ (4,526,973) $ 260,297 $ 261,213 $ 259,267 $ 259,725
Beginning year fund 3,298,248 balance
- Net Transfers -----Current fund
2,022,213 balance
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI (J) 3. Trended Stmt of Operations
I'V
c..n
..j:::o.
<D
33 of 42
June
July
Total Year August September October November December Budget
$ 258,560 $ 261,373 $ 260,810 $ 259,965 $ 260,013 $ 254,011 $ 263,738 $ (1,668,000)
AUTODATE,AUTODATE
(J)
I
m
r r
sI :
() ()
r
C
;a
G)
oI (J) 3. Trended Stmt of Operations
I'V
c..n c..n o
34 of 42
Dept: Start Date: End Date:
Benzene Health Research (SP5200X8 1) 06/01/06 06/30106
General Ledger Detail - Grouped by Account
AUTODATE,AUTODATE
Fund 9091 - Law
Fees SP SP
9094 -
Studies, Research & Analysis
SP SP
Dept Activity Acct Date
Amount Batch Description Line Item Description Journal
5200 X8104 5200 X8104
9091 6/16/2006 9091 6/26/2006
3,728.72 3,114.03 Purchases
614.69 Purchases
Cont# 2005101580 Cont# 2005101580
PMTRX PMTRX
5200 X8107 5200 X8109
33,407.90 9094 6/8/2006 31,007.90 Purchases 9094 6/16/2006 2,400.00 Purchases
Cont#2004101153 Period:- 061406
PMTRX PMTRX
37,136.62
(J)
I
m
r r
sI :
()
()
r
C
;a
G)
oI (J) 35 of 42
I'V
c..n c..n
.....lo.
Vendor
Steptoe & Johnson LLP Steptoe & Johnson LLP
Invoice # JE #
2181583 89155 2183513 89441
Applied Health Sciences, Inc. 1068-0605 88880
Jerry M. Rice ,PhD
2006 API 3 89169
~
I
m
rr-
I
~
o o
r-
C
~
I
QCm)
~ (n (n ~
AUTODATE, AUTODATE
~d~
Dept: Start Date: End Date:
Benzene Health Research (SP5200X8 1) 01/01/06 06/30106
AUTODATE,AUTODATE General Ledger Detail - Grouped by Account
7050 Interest Income
7610 Special Solicitations
901B Salaries
Fund
SP
SP SP SP
SP SP SP SP SP
Dept Activity Acct Date
Amount
Batch Description
Line Item Description
5200 X8100 7050 4/21/2006
(20,211.34) (20,211.34)
Qtrly RASA Interest
5200 X8100 5200 X8100 5200 X8100
7610 7610 7610
1/1/2006 3/31/2006 5/31/2006
(1,093,939.00)
400,000.00 2005 Benzene
(400,000.00) CGI BatchlD = 8904 (1,093,939.00) CGI BatchlD = 9094
2005 Unshipped CGI Invoices Mar06-0rders Upload May06-0rders Upload
5200 X8100 5200 X8100 5200 X8100 5200 X8100 5200 X8100
901B 901B 901B 901B 901B
1/31/2006 2/28/2006 3/31/2006 4/30/2006 5/31/2006
22,675.06 1,172.66 JAN 2006 RASA ALLOCATIONS 5,719.44 FEB 2006 RASA ALLOCATIONS 5,578.38 MAR 2006 RASA ALLOCATIONS 7,052.31 APR 2006 RASA ALLOCATIONS 3,152.27 MAY 2006 RASA ALLOCATIONS
Jan Allocations Feb06 Allocations Mar06 RASA ALLOCS Reclass Monthly RASA Entry
903B
Emp.
benefits &
(J)
I
payroll taxes
2,834.38
m SP 5200 X8100 903B 1/31/2006 146.58 JAN 2006 RASA ALLOCATIONS Jan Allocations
r r
SP 5200 X8100 903B 2/28/2006 714.93 FEB 2006 RASA ALLOCATIONS Feb06 Allocations
s:I SP 5200 X8100 903B 3/31/2006 697.30 MAR 2006 RASA ALLOCATIONS Mar06 RASA ALLOCS
() SP 5200 X8100 903B 4/30/2006 881.54 APR 2006 RASA ALLOCATIONS Reclass
() SP 5200 X8100 903B 5/31/2006 394.03 MAY 2006 RASA ALLOCATIONS Monthly RASA Entry
r 9091 - Law
C
;a
Fees
11,860.25
G)
SP 5200 X8104 9091 3/31/2006 477.27 Purchases
Cont# 2005101580
I
0
(J) 37 of 42
I'V
c..n c..n
c..>
Journal Vendor
GJ
GJ CGIO CGIO
GJ ALLOC GJ GJ GJ
Invoice #
JE #
87264
84471 86690 88652
85374 85991 86942 87845 88745
(J)
I
m GJ
r r
ALLOC
s:I GJ
() GJ
() GJ
85374 85991 86942 87845 88745
r
C
;a
G)
PMTRX Steptoe & Johnson LLP
2169971
86828
oI
(J)
I'V
c..n c..n
..j:::o.
AUTODATE,AUTODATE
38 of 42
Dept: Start Date: End Date:
Benzene Health Research (SP5200X8 1) 01/01/06 06/30/06
AUTODATE,AUTODATE General Ledger Detail - Grouped by Account
9094 Studies,
Research &
Analysis
Fund SP SP SP SP
SP SP SP
Dept 5200 5200 5200 5200
Activity Acct X8104 9091 X8104 9091 X8104 9091 X8104 9091
Date
Amount
3/31/2006
5,298.63
4/28/2006
2,355.63
6/16/2006
3,114.03
6/26/2006
614.69
Batch Description Purchases Purchases Purchases Purchases
5200 X8107 5200 X8107 5200 X8109
9094 9094 9094
3/17/2006 3/17/2006 3/21/2006
323,876.97 34,093.70 Purchases 39,761.17 Purchases 1,800.00 Purchases
Line Item Description Cont# 2005101580 Cont#20051 01580 Cont# 2005101580 Cont# 2005101580
Cont#2004101153 Cont#2004101153 Period: - 1/18 to 2/27/06
SP
5200 X8109 9094 3/28/2006
1,000.00 Purchases
Period:- 110405
SP 5200 X8106 9094 3/31/2006 131,000.00 Purchases
Cont#2004101138-1
SP
5200 X8107 9094 4/7/2006
35,436.40 Purchases
Cont#2004101153
SP
5200 X8107 9094 5/8/2006
44,977.80 Purchases
Cont# 2004101153
SP
5200 X8109 9094 5/9/2006
2,400.00 Purchases
Period:- 3/16 to 4/30/06
SP
5200 X8107 9094 6/8/2006
31,007.90 Purchases
Cont#2004101153
SP 9111 - Travel
5200 X8109 9094 6/16/2006
2,400.00 Purchases
Period:- 061406
&
(J)
I
Entertainmen
mt
1,223.44
r r
SP 5200 X8100 9111 3/24/2006
22.00 Todd M ERPT
Paid EFT 03/31/06
s:I
SP
5200 X8100 9111 4/14/2006
1,201.44 Todd M ERPT
() 9125 - Food
Co. Cards Exps subm 04/14
() & Beverage
532.62
r
SP
5200 X8100 9125 3/1/2006
532.62 MINDY'S DISTINCTIVE CATER 02/24 Pcard Detail
C
;a
G)
I
0
(J) 39 of 42
I'V
c..n c..n c..n
Journal PMTRX PMTRX PMTRX PMTRX
Vendor Steptoe & Johnson LLP Steptoe & Johnson LLP Steptoe & Johnson LLP Steptoe & Johnson LLP
Invoice # 2176179 2178695 2181583 2183513
JE # 86829 87663 89155 89441
PMTRX PMTRX PMTRX
Applied Health Sciences, Inc. Applied Health Sciences, Inc. Jerry M. Rice ,PhD
1068-0601 1068-0602 2006 API1
86181 86182 86267
PMTRX PMTRX PMTRX PMTRX PMTRX PMTRX PMTRX
Richard J. Albertini, MD, PhD Dr. Richard D. Irons Applied Health Sciences, Inc. Applied Health Sciences, Inc. Jerry M. Rice ,PhD Applied Health Sciences, Inc. Jerry M. Rice ,PhD
32706 032906-FEB06 1068-0603 1068-0604 2006 API2 1068-0605 2006 API3
86518 86728 86968 87885 87966 88880 89169
(J)
I
m
r r
CONCUR
s:I CONCUR
()
()
r PCRD
C
;a
G)
I
0
(J)
I'V
c..n c..n
(J)
86426 87260
86352
AUTODATE,AUTODATE 40 of 42
Dept: Start Date: End Date:
Benzene Health Research (SP5200X8 1) 01/01/06 06/30106
AUTODATE,AUTODATE General Ledger Detail - Grouped by Account
917B Other operating expenses
Fund
SP SP
Dept Activity Acct Date
Amount
Batch Description
5200 X8100 917B 2/28/2006 5200 X8100 917B 3/31/2006
109.45 RASA Allocation (109.45) RASA Allocation
Line Item Description
Feb Allocations 2 Mar 2006 Allocations
9403 - Grants
2,000,000.00
SP 5200 X8105 9403 4/30/2006 2,000,000.00 Purchases
Cont# 0100004788
9941 - API
Recovered
Overhead
6,348.97
SP
5200 X8100 9941 1/31/2006
328.33 JAN 2006 RASA ALLOCATIONS Jan Allocations
SP
5200 X8100 9941 2/28/2006
1,601.44 FEB 2006 RASA ALLOCATIONS Feb06 Allocations
SP
5200 X8100 9941 3/31/2006
1,561.94 MAR 2006 RASA ALLOCATIONS Mar06 RASA ALLOCS
SP
5200 X8100 9941 4/30/2006
1,974.64 APR 2006 RASA ALLOCATIONS Reclass
SP 5200 X8100 9941 5/31/2006 882.62 MAY 2006 RASA ALLOCATIONS Monthly RASA Entry
9945 - API
Allocated
Costs
20,833.35
SP
5200 X8100 9945 1/31/2006
4,166.67 Recur. JE Fixed Allocated Cost Recur 9945
(J)
I
SP
5200 X8100 9945 2/28/2006
4,166.67 Recur. JE Fixed Allocated Cost Recur 9945
m
SP
5200 X8100 9945 3/30/2006
4,166.67 Recur. JE Fixed Allocated Cost RECUR 9945
r r
SP
5200 X8100 9945 4/30/2006
4,166.67 Recur. JE Fixed Allocated Cost RECUR 9945
s:I
SP
5200 X8100 9945 5/30/2006
4,166.67 Recur. JE Fixed Allocated Cost RECUR 9945
()
() 1,276,034.70 r
C
;a
G)
oI (J) 41 of 42
I'V
c..n c..n
-.....J
Journal Vendor
Invoice #
JE #
ALLOC ALLOC
PMTRX University of Colorado
85994 86965
APRIL-2006 87817
GJ ALLOC GJ GJ GJ
85374 85991 86942 87845 88745
GJ
(J)
I
m
RECR RECR
r r
RECR
sI : RECR
()
()
r
C
;a
G)
oI
(J)
I'V
c..n c..n ex>
85373 85373 86671 86671 86671
AUTODATE,AUTODATE 42 of 42