Office of Research Administration KPI Summary/Highlights Proposals - - PowerPoint PPT Presentation

Office of Research Administration KPI Summary/Highlights

Proposals FYTD February 2020

1

School % change 2018 vs 2019 % change 2019 vs 2020 Total Proposal Proposed (#) Total Proposal Proposed (#) Total Proposal Proposed (#) College of Arts and Sciences

• 16.03%
• 9.27%

$38,306,391 174 $32,165,933 168 $29,184,698 166 Medicine

• 1.08%

5.31% $381,681,833 1543 $377,542,878 1481 $397,606,978 1590 Nursing

• 28.27%

45.22% $13,451,485 57 $9,648,933 42 $14,012,035 60 Other 9.78% 35.81% $4,580,923 14 $5,028,783 17 $6,829,634 25 Public Health 17.88%

• 34.61%

$83,311,215 261 $98,208,859 273 $64,222,446 262 Yerkes

• 1.77%

10.57% $51,232,547 90 $50,323,571 95 $55,643,892 102 $572,564,394 2139 $572,918,957 2076 $567,499,683 2205 2018 2019 2020 Grand Total

Office of Research Administration KPI Summary/Highlights

Awards FYTD – February 2020

2

School % Variance 2018 vs 2019($) % Variance 2019 vs 2020($) Aw ard ($) Aw ard (#) Aw ard ($) Aw ard (#) Aw ard ($) Aw ard (#) College of Arts and Sciences

• 8.61%
• 43.61%

13,100,780 70 11,973,455 67 6,752,058 68 Medicine

• 14.17%

21.17% 189,367,668 1105 162,536,524 1147 196,952,384 1223 Nursing

• 34.85%

40.11% 4,383,335 29 2,855,704 19 4,001,244 29 Other 13.88% 63.79% 1,738,172 21 1,979,414 26 3,242,177 23 Public Health

• 39.62%

8.54% 55,731,034 180 33,651,498 184 36,526,005 184 Yerkes 15.44% 12.02% 17,117,253 62 19,760,862 48 22,135,294 54 281,438,242 1467 232,757,458 1491 269,609,162 1581 Grand Total 2018 2019 2020

Office of Research Administration KPI Summary/Highlights

Expenditures FYTD – February 2020

3

FY2020 Expenditures as of 3/14/2020 * As of 01.31.2020

PPY to PY V i PY to CY Variance 2018 2019 2020 College or Arts and Sciences 12.55% 0.22% 14,387,902 16,193,714 16,228,804 Medicine 12.27% 8.69% 164,044,540 184,173,515 200,181,008 Nursing (8.70%) 9.21% 6,322,268 5,772,455 6,304,029 Other 8.81% (18.36%) 4,721,585 5,137,706 4,194,444 Public Health 8.07% 7.00% 50,415,351 54,486,137 58,300,244 Yerkes (6.41%) (1.03%) 36,254,260 33,929,582 33,579,542 276,145,907 299,693,110 318,788,072 Expenditures Grand Total

Expenses 3-Year Variance By Operating Unit

OSP & OTT KPI Summary/Highlights – February 2020

• Average Contracts Negotiation Processing Time

*Median in Parenthesis

4

Agreement Type PHASE 1: Received by Contract Group To First Revision PHASE 2: First Revision To Negotiations Completed PHASE 3: Negotiations Completed To Fully Executed Total Time: Received by Contract Group To Fully Executed Industry CTAs 7 (6.5) 11 (4.5) 44 (47) 86 (73.5) non-Industry CTAs** 8 (4) 60 (58.5) 39 (26) 84 (93) Industry Research Agreements 3 (3) 27 (14) 36 (16.5) 59 (32.5) non-Industry Research Agreements 1 (1) 24 (2.5) 15 (7) 33 (25) Research Services Agreements 18 (17) 14 (3) 10 (10) 39 (39.5) Confidentiality Agreements 5 (4) 7 (3) 4 (3.5) 18 (11) Amendments 2 (1) 1 (1) 24 (10) 28 (11) Other 9 (2.5) 21 (7) 16 (15) 30 (26.5)

*Median in parenthesis

OTT KPI Summary/Highlights – February 2020

Average Contracts Negotiation Processing Time

5 20 40 60 80 100 120 03/2019 04/2019 05/2019 06/2019 07/2019 08/2019 09/2019 10/2019 11/2019 12/2019 01/2020 02/2020

Clinical Trials Turnaround Median Days

Phase 1 Phase 2 Phase 3 Total Time

Industry Contracts

Turnaround Targets vs Actual February 2020

Agreement Type PHASE 1: Received by ICG to 1st Revision PHASE 2: 1st Revision to Negotiation Complete PHASE 3: Negotiation Complete to Fully Executed* Total Time For All Steps Target Actual Target Actual Target Actual Target Actual Industry CTAs 8 6.5 20 4.5 5 1 30 12 Industry Research Agmt. 10 5 20 17.5 5 4 30 26.5 Research Services Agmt. 10 17 20 3 5 1.5 30 21.5 Confidentiality Agmt. 4 2 8 3 5 1 19 6 Amendments 4 2 5 1 5 2 14 5 Other 10 14 5 14 5 1 15 29

OTT-ICG: Median Contract Processing Times in Business Days

* Calculated from the date the partially-executed agreement is sent to sponsor until the fully-executed agreement is received back from sponsor.