ࡱ> ]\ T8\pKayla R Fesperman [Ba= ThisWorkbook=[; 8X@"1 Arial1 Calibri1 Calibri1 Calibri1 Arial1 Arial1 Arial1 Arial1  Arial1 Arial1 Arial1 Arial1 Arial1 Calibri1  Calibri1Calibri14Calibri1 Calibri1Calibri1Calibri1,8Calibri18Calibri18Calibri1>141<Calibri1?Calibri1h8Cambria1Calibri1 Calibri"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                                                                      ff  +  )  ,  *     P  P        `            a>      H     !x @ @  " "8  "8 "8 "X  !8 x@ @  x@ @  x 8  x @ @   x @ @    8  x X X  8@ @   x"@ @   x@ @   x @ @  x@ @   x@ @   x@ @  8@ @  x@ @  x@ @  x@ @  !8@ @  !8@ @  ) ||c#}A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef ;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L ;_(@_) }A} 00\);_(*23;_(@_) }A} 00\);_(*23;_(@_) }A} 00\);_(*23;_(@_) }A} 00\);_(*23;_(@_) }A}  00\);_(*23;_(@_) }A}! 00\);_(*23 ;_(@_) }A}" 00\);_(*;_(@_) }A}# 00\);_(*;_(@_) }A}$ 00\);_(*;_(@_) }A}% 00\);_(*;_(@_) }A}& 00\);_(*;_(@_) }A}' 00\);_(* ;_(@_) }A}( 00\);_(*;_(@_) }}) }00\);_(*;_(@_)    }}* 00\);_(*;_(@_) ??? ??? ??? ???}-}/ 00\);_(*}A}0 a00\);_(*;_(@_) }A}1 00\);_(*;_(@_) }A}2 00\);_(*?;_(@_) }A}3 00\);_(*23;_(@_) }-}4 00\);_(*}}5 ??v00\);_(*̙;_(@_)    }A}6 }00\);_(*;_(@_) }A}7 e00\);_(*;_(@_) }x}800\);_(*;_(  }}9 ???00\);_(*;_(??? ???  ??? ???}-}; 00\);_(*}U}< 00\);_(*;_( }-}= 00\);_(* 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L渷 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ږ % 60% - Accent3M( 60% - Accent3 23כ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text % 0Good;Good  a%1 Heading 1G Heading 1 I}%O2 Heading 2G Heading 2 I}%?3 Heading 3G Heading 3 I}%234 Heading 49 Heading 4 I}% 5InputuInput ̙ ??v% 6 Linked CellK Linked Cell }% 7NeutralANeutral  e%"Normal 8Noteb Note   9OutputwOutput  ???%????????? ???:$Percent ;Title1Title I}% <TotalMTotal %OO= Warning Text? Warning Text %XTableStyleMedium9PivotStyleLight16` _HRoles & Responsibilities  ;Y   ; n#Proposal Preparation and Submission!Roles and Responsibilities MatrixRegulatory CompliancePI Pre-AwardOtherEffort Reporting Sub-process:Process:Contracts and GrantsGrant ManagementDocument Title:9Reviews requests for proposals for technical requirements;Reviews requests for proposals for institutional complianceBDevelops initial budget draft to accomplish proposed scope of workUReviews budget for appropriated salaries, fringes, tuition, indirect, and escalations8Reviews and approves required and voluntary cost sharingSNegotiates material transfer, confidentiality agreements, and intellectual property(Negotiates sponsored research agreementsgPrepares and submits protocols for research involving human subjects, animal use, and biosafety hazardsApproves compliance protocolsKMaintains export control documentation and clearances for faculty and staff.Initiates and encumbers personnel transactions3Reviews and reports cost sharing efforts to sponsor4Reviews expenditures in restricted budget categories5Initiates request for re-budgeting and cost transfers(Documents cost sharing funds as requiredResponsibilitiesOCaReviews proposed project to verify that it is in-line with departmental and institutional missionDean / DirectorVC for ResearchResearch Compliance OfficerVVerifies investigators are submitting protocols to appropriate compliance committee(s)FProvides documentation of certification and representations to sponsornVerifies compliance with federal regulations regarding financial disclosure of potential conflicts of interestProvides oversight of sponsored project administration including the review and approval of cost transfers and effort reportingClosing Out the AwardManaging the Award - Financial"Managing the Award - Non-Financial%Distribute and collect effort reports?Provide information on compliance with effort reporting policy $Accept award on behalf of University0Award Negotiation, Acceptance, and EstablishmentInitiate request for sub-awardSApprove pre-award costs and commitment of department funds if project is not fundedGNegotiate, approve, and notify the PI of project terms and conditions. @Provide documentation of certifications of approvals to sponsors'File appropriate closeout documentation>Notify PI of the need for completion of final technical report;Respond to closeout checklist and confirm award termination0Provide interim financial reports to the sponsor5Provide information for and prepare financial reports9Review and analyze financial reports to external sponsorsFinancial Reporting%Initiate material transfer agreementsbProvide oversight on the implementation of University, state, and federal policies and regulationsVConduct the sponsored project and provide overall oversight on all research activities1Hire or assign research personnel for the project*Review programmatic changes to the project9Review and approve incoming materials transfer agreementsInactivate fundPurpose of document: FunctionsLThis matrix is designed to provide guidance on the assignment of responsibilities across campus functions as they relate to the management of an award. This matrix should be referenced by all parties that are involved in any point along the award life cycle. This matrix is not an exhaustive list of all campus business practices. Moreover, this matrix does not replace departmental policy. The normal business practices of the campus function should be followed. It should only be used as a guide for communicating owners (O) and contributors (C) of award management responsibilities. Legend:O = Owner, C = ContributorO - IRB/IACUC/IBC.Verify compliance with effort reporting policyNPrepares and submits to sponsor financial report and final invoice as required6Prepares and submits to sponsor final technical reportbProvides authorized University signature and submits proposal as dictated by sponsor instructions.;Agree to terms and conditions regarding performance clauses'Develop, draft, and negotiate sub-award?Establish fund in financial system based on award documentationXVerifies the allowability, reasonableness, allocability, and consistency of expendituresUComplete time and effort reports including approving certification of other personnel1Certifies cost sharing and provides to Post-Award`Manage time and effort reporting system and maintain certifications of time and effort reports. WApproves requests for re-budgeting and cost transfers according to sponsor requirementsRequests no-cost time extension8Reviews and approves requests for no-cost time extension>Submits all invoices (including sub-award invoices) to sponsor*Monitors invoices and aging of receivablesRevenue collectionApproves payment of sub-recipient invoices (including certification on final invoice for agreement with completion of sub-recipient's work)Applies payment to proper fund,Performs drawdowns (i.e., letters of credit)OPerforms follow-up on outstanding receivables and determines need for write-offSend copy of Award Letter (i.e., Notice of Award) to PI and appropriate department support (e.g.,Unit Business Administrator). Also notify PI that fund has been established.=Provides proposal to Pre-Award in advance of sponsor deadline Tech Transfer0Requests and documents approval for cost sharing4Approves and provides documentation for cost sharingPrepare technical proposal^Prepare and submit technical reports and provide other deliverables to the sponsor as requiredBRequest pre-award fund setup (e.g., Letter of Guarantee) if neededReconciles cash to GLCollege / Dept Level Admin&Contracts & Grants Office (Post-Award)Department ChairVC for Business & FinancePrepares final version of proposal as required by the sponsor. Completes the college/department's portion of the Internal Routing Forms and, as appropriate, other attachments. Routes all forms for internal department signatures.Requests and documents University signature approvals of Internal Routing Forms and, as appropriate, other attachments. Routes all forms for University signatures.-Maintains proposal pending files and databaseIndirect Cost Rate Negotiation!Indirect Cost Receipts Allocation O - ProvostC - Controller's Officerw. /r0m23-5+@78~ :* ={?@(B0DKFccB T8 $Z]l.{x@  dMbP?_*+%, + 1 F )&&CDocument Reference - III.A&R&P of &N&ffffff?'(\?(RQ?))\(?MRICOH Aficio MP 6500 PCL 6 odXXLegal (8.5" x 14")RICOH Aficio MP 6500 PCL 6LPT1: hd''''do dDefault"<XX??&U} ?} 9?} D}  H} IH} $ H;?;?;??;?;???,D E E E E EE,EEEEEEEE,EE,DEEEEEE > ? 6@@@@@@@@@@@@@@@@@@@@@@@@ > ? 6@@@@@@@@@@@@@@@@@@@@@@@@ > ?6@@@@@@@@@@@@@@@@@@@@@@@@ >? bA6bbbbbbbbbbb@@@@@@@@@@@@@:AB@@@@@@@@@@@@@@@@@@@@@@@@ >B IC6GF@@@@@@@@@@@@@@@@@@@@@@ A@ ]@4^^^^^^^^^_@@@@@@@@@@@@@ `a [ [e [ [ [d [c [f  [  [!  [\  [\ XCCCCCCCCCCC ~ U? W Y JJ J JJJJ J JKLLMM~ U@ W Y JJ J JJJJJJKLLMM~ U@ W_ Y" JJJJJJJJJKLLMM~ U@ W Y J J J JJJJJJKLLMM~ U@ W Y JJ J JJJJJJKLLMM~ U@ W Y JJ JJJJJJJKLLMM~ U@ W] Y"JJJJJJJJJKLLMM~ U @ W^ Y J JJJJJJJJKLLMM~ U"@ W YJJ JJJJJJJKLLMM~ U$@ Wg Y JJ JJJJJJJKLLMM~ U&@ Wh YJJ JJJJJJJKLLMM~ U(@ W[ Y"JJJJJJJJJKLLMM~ U*@ WH YJJ JJJJJJJKLLMM~ U,@ W Y JJ JJJJJJ  J KLLMM~ U.@ W YJJ JJJJJJJKLLMM~ U0@ Wi YJJ JJJJJJJKLLMMU V$NNNNNNNNNNOPPPP~ U? W Y J JJJJJJJJKMMMM~ U@ W" Y JJJJJJJ  J JKMMMM~ U@ W YJJ JJJJJ  J J  KD MMMM~ U@ W# Y JJ JJJJJJJKMMMM~ U@ W$ Y JJ J JJJ  J  J J  Kl MMMM~ U@ W YJJ J JJJ  J  J JKMMMMDlVVVV>VT8|fPtffP\ZpZPZ|ZZ@\rf ,D!E"E#E$E%E&E'E(E)E*E+,D,E-E.E/E0E1,D2E3E4E5E6E7E8E9E:E;E<E=E>E?E U X,$ NNNNNNNNNNOPPPP~ !U? !W+ !YJJ !J!JJJJJJKMMMM~ "U@ "W/ "YJJ "J"JJJJJJKMMMM~ #U@ #WI #Y #JJ #J#JJJJJJKMMMM~ $U@ $WK$YJJJ $J$JJJJJKMMMM~ %U@ %WZ%YJJJ %J%JJJJJKMMMM~ &U@ &W0 &Y &JJ &J&JJJJJJKMMMM~ 'U@ 'Wa 'Y"'JJJJJJJJJKMMMM~ (U @ (W.(Y (J (J(JJJJJJJKMMMM~ )U"@ )W- )Y")JJJJJJJJJKMMMM~ *U$@ *WJ *YJJ *J*JJJJJJKMMMM+U +X$+NNNNNNNNNNOPPPP~ ,U? ,W* ,YJ ,J,J ,J,J ,J , J, JJKMMMM~ -U@ -W)-YJJJ -J-JJJJJKMMMM~ .U@ .WM .Y".JJJJJJJJJKMMMM~ /U@ /WE /YJ /J/J /J/J /J / J/ JJKMMMM~ 0U@ 0ZO0YJJJ 0J0JJJJJKMMMM1U 1X'$1NNNNNNNNNNOPPPP~ 2U? 2WL 2Y 2JJJ 2J2JJJJJKMMMM~ 3U@ 3W%3YJJJ 3J3JJJJJKMMMM~ 4U@ 4W 4Y 4JJJ 4J4JJJJJKMMMM~ 5U@ 5WN 5Y"5JJJJJJJJJKMMMM~ 6U@ 6W6YJJJ 6J6JJJJJKMMMM~ 7U@ 7W 7Y 7JJJ 7J7JJJJJKMMMM~ 8U@ 8W 8Y"8JJJJJJJJJKMMMM~ 9U @ 9WP 9YJJ 9J 9J9JJJJJKMMMM~ :U"@ :WQ :Y":JJJJJJJJJKMMMM~ ;U$@ ;WR ;YJJ ;J ;J;JJJJJKMMMM~ <U&@ <Wj<YJJJ <J<JJJJJKMMMM~ =U(@ =Wk=YJJJ =J=J =J = J = JJ = Kl= MMMM~ >U*@ >WV >Y >JJJ >J>JJJJJKMMMM~ ?U,@ ?WS?YJJJ ?J?JJJJJKMMMMD>l@ZZfZZfPdPZ@ZPZ@fZfPZfPfPfZf@EAEBECEDEEEF,DGEHEIEJEKELEMEN,DOIEPIEQIER,ESETEUEVEWEXEYEZ;D[,\,],^,_,~ @U.@ @WX@YJJJ @J@JJJJJKMMMM~ AU0@ AWTAYJJJ AJAJJJJJKMMMM~ BU1@ BWY BY BJ BJBJ BJBJJJJJKMMMM~ CU2@ CWUCYJJJ CJCJJJJJ C KmC MMMM~ DU3@ DWWDYJJJ DJDJJJJJKMMMM~ EU4@ EWbEYJJJ EJEJJJJJKMMMMFU FX($FNNNNNNNNNNOPPPP~ GU? GW: GY GJ GJGJJJJJJJKMMMM~ HU@ HW; HY"HJJJJJJJJJKMMMM~ IU@ IW` IY IJJ IJIJJJJJJKMMMM~ JU@ JW8 JYJJJJJJJJJ J JJ KMMMM~ KU@ KW9 KY KJ KJ KJJJ KJ K JK JJKMMMM~ LU@ LW< LY"LJJJJJJJJJKMMMM~ MU@ MW=MYJJJJJJJJ M JM KMMMMNU NX7$NNNNNNNNNNNOPPPP~ OU? OW5 OY OJJJ OJOJJJJJKMMMM~ PU@ PW6 PY PJJJ PJPJJJJJKMMMM~ QU@ QW4 QY QJJJ QJQJJJJJKMMMMRU RX&$RNNNNNNNNNNOMMMM~ SU? SW SY SJJJ SJSJJJJJKMMMM~ TU@ TW3 TY TJJJ TJTJJJJJKMMMM~ UU@ UW2 UYJJ UJUJJJJJJKMMMM~ VU@ VWG VY"VJJJJJJJJJKMMMM~ WU@ WWF WY WJJJ WJWJJJJJKMMMM~ XU@ XW>XYJJJ XJXJJJJJKMMMM~ YU@ YW1YYJJJ YJYJJJJJKMMMM(Z??PPPQQRRRSSTPPPP$[PPPPPSSSSSTSSSS$\PPPPPSSSSSTSSSS$]PPPPPSSSSSTSSSS$^PPPPPSSSSSTSSSS$_PPPPPSSSSSSSSSSD lZZ|pZZ@hPffPZ@fff@ffZPfZZ,((((`,a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z,{,|,},~,,$`PPPPPSSSSSSSSSS$aPPPPPSSSSSSSSSS$bPPPPPSSSSSSSSSS$cPPPPPSSSSSSSSSS$dPPPPPSSSSSSSSSS$ePPPPPSSSSSSSSSS$fPPPPPSSSSSSSSSS$gPPPPPSSSSSSSSSS$hPPPPPSSSSSSSSSS$iPPPPPSSSSSSSSSS$jPPPPPSSSSSSSSSS$kPPPPPSSSSSSSSSS$lPPPPPSSSSSSSSSS$mPPPPPSSSSSSSSSS$nPPPPPSSSSSSSSSS$oPPPPPSSSSSSSSSS$pPPPPPSSSSSSSSSS$qPPPPPSSSSSSSSSS$rPPPPPSSSSSSSSSS$sPPPPPSSSSSSSSSS$tPPPPPSSSSSSSSSS$uPPPPPSSSSSSSSSS$vPPPPPSSSSSSSSSS$wPPPPPSSSSSSSSSS$xPPPPPSSSSSSSSSS$yPPPPPSSSSSSSSSS$zPPPPPSSSSSSSSSS${PPPPPSSSSSSSSSS$|PPPPPSSSSSSSSSS$}PPPPPSSSSSSSSSS$~PPPPPSSSSSSSSSS$PPPPPSSSSSSSSSSDl(((((((((((((((((((((((((((((((,,,,,,,,,,,,,,,,,,,,,,,,,,$PPPPPSSSSSSSSSS$PPPPPSSSSSSSSSS$PPPPPSSSSSSSSSS$PPPPPSSSSSSSSSS$PPPPPSSSSSSSSSS$PPPPPSSSSSSSSSS$PPPPPSSSSSSSSSS$PPPPPSSSSSSSSSS$PPPPPSSSSSSSSSS$PPPPPSSSSSSSSSS$PPPPPSSSSSSSSSS$PPPPPSSSSSSSSSS$PPPPPSSSSSSSSSS$PPPPPSSSSSSSSSS$PPPPPSSSSSSSSSS$PPPPPSSSSSSSSSS$PPPPPSSSSSSSSSS$PPPPPSSSSSSSSSS$PPPPPSSSSSSSSSS$PPPPPSSSSSSSSSS$PPPPPSSSSSSSSSS$PPPPPSSSSSSSSSS$PPPPPSSSSSSSSSS$PPPPPSSSSSSSSSS$PPPPPSSSSSSSSSS$PPPPPSSSSSSSSSS8(((((((((((((((((((((((((>@KKPR  7 Sheet1ggD Oh+'0HPh Whitney FreemanKayla R FespermanMicrosoft Excel@r@\G|=@~mr՜.+,0T PXp x Ernst & Young Roles & Responsibilities&'Roles & Responsibilities'!Print_Area('Roles & Responsibilities'!Print_Titles  Worksheets Named Ranges  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKMNOPQRSUVWXYZ[Root Entry FWorkbookuSummaryInformation(LDocumentSummaryInformation8T