Orange County NC Website
DocuSign Envelope ID:2AD3F596-76A7-4BB6-86CF-7B4E6C3E358E <br /> JORDAN LAKE PARTNERSHIP <br /> SUPPLEMENTAL ARTICLE No. 7 <br /> Compendium of Potential Raw Water Sources <br /> Triangle J Council of Governments <br /> Draft Scope:Revised July24,2015 Percent Total SCHEDULE and HOURS by MONTH <br /> Deliverable of Total Hours: Ml M2 M3 M4 MS M6 <br /> Tasks Hours 308 41 59 57 55 74 22 <br /> Al. Bibliography and Summary Matrix(SM) 34% 105 31 41 33 0 0 0 <br /> Create templates for Bibliography and its entries 2 2 <br /> Create SM template and notation conventions 6 6 <br /> Obtain JLP input on templates via email;revise if necessary 4 4 <br /> Review refs in Vol.1 Individual Source Summaries against appendix 1 1 <br /> Obtain compiled Characklis model source info(Excel files) 0 <br /> Reformat refs in Vol.1to Bibliographyformat 6 6 <br /> Create new entries for Bibliography from new docs/info 10 5 5 <br /> Ask J LP to review Bibliography for completeness 2 2 <br /> Skim information from Bibliography to populate SM 31 5 26 <br /> Review Bibliography documents for refs to additional docs 12 10 2 <br /> Obtain additional(secondary)documents/information 6 6 <br /> Scan additional documents not already available digitally 0 <br /> Create entries for additional documents in Bibliography 8 8 <br /> Skim additional documents to populate SM 12 12 <br /> Check SM against existing Source Summaries'content 5 5 <br /> [no tertiary-level document retrieval/review] <br /> A2. Additional and Revised Source Summaries (SS) 40% 122 0 14 20 51 37 0 <br /> Create a table listing existing Source Summaries 4 4 <br /> Decide how to handle SS with variations or conflicting info 4 4 <br /> Create a consistent naming and unique IDs for Sources 4 4 <br /> Define with JLP what constitutes an information"gap" 2 2 <br /> Refine existing SS based on review of Al documents 40 20 20 <br /> Develop new SS based on review of Al documents 50 25 25 <br /> Flag potential gaps and send all SS to JLP for review 12 6 6 <br /> Revise SS based on J LP review and update Appendix C 6 6 <br /> A3. TM of findings and remaining information gaps 13% 41 0 0 0 0 33 s <br /> Review all gaps in revised SS and outline TM 5 5 <br /> Summarize gaps based on flags in revised SS 10 10 <br /> Review gaps with J LP and prioritize gaps for future research 2 2 <br /> Develop graphics for memo and PowerPoint presentation 16 16 <br /> Send memo forJLP review via email;revise memo 8 8 <br /> A4. PowerPoint presentation(s) 3% 10 0 0 0 0 0 10 <br /> Develop master presentation 10 10 <br /> PM:Project management 10% 30 10 4 4 4 4 4 <br /> Execute Agreement for Project 1 3 3 <br /> Set up project in Sage;TJCOG budget amendment 3 3 <br /> Establish and monitor project schedule 12 2 2 2 2 2 2 <br /> Run Sage report monthly after indirect has been allocated 0 <br /> Monitor budget(enter Sage costs and recalculate burn rate) 6 1 1 1 1 1 1 <br /> Invoice and report on progress to JLP 6 1 1 1 1 1 1 <br /> Prepare annual budget package for TJCOG Finance 0 <br /> Budgeted Rate:$95 $ 29,260 <br /> Jordan Lake Partnership Supplemental Article 7 Page 7 of 19 July 26,2015 <br />