{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Pre-Con  Exhibit G","Pre-Con CSI Cost Est Summary","List"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,1,26,9],[16,0,16,2],[22,0,22,2],[25,0,25,3],[0,13,0,14],[0,9,0,10],[1,0,1,3],[14,1,14,11],[17,1,17,11],[20,1,20,8],[11,1,11,8],[23,1,23,9]]}
[null,null,null,null,null,null,null,null," = to be completed by CM","Rev. 9/16/19"]
["Pre-Construction Proposal (PCS)",null,null,null,null,null,null,null," = predetermined or automatic calculation"]
[]
["Section G.1. CSI Cost Estimate - Instructions for Completion"]
[]
["This section is intended for Pre-Construction related investigation by trades workers"]
[]
["Trade Contractor investigation, Self-Performed investigation and Estimates must be detailed and summarized per the following \"column\" instructions:"]
[]
[]
["Scope/Trade Category"]
[null,"• List all applicable Trade Categories in sequential order by CSI Numbers"]
[]
["Proposed Trade Contractor, Self-Perform Work or Estimates"]
[null,"• List Trade Contractor, Self-Perform or Estimate"]
[]
["Proposed Amount"]
[null,"• List the proposed amount"]
[]
["EMR"]
[null,"• Note the current EMR for the selected Trade Contractor or N/A for Self-Perform work or Estimate"]
[]
["Proposal Detail"]
[null,"• List summary of work to be performed, including but not limited to, why Trade Contractor was chosen or how the estimate was calculated"]
[]
["Pre-Construction Total"]
[null,"• Note Total Not to Exceed to be awarded"]

{"sheet":"Pre-Con  Exhibit G","index":1,"n_rows":96,"n_cols":11,"rows_kept":96,"cut":false,"hidden":false,"merged":[[17,4,17,7],[17,8,17,9],[4,0,4,1],[10,8,10,9],[15,0,15,1],[15,4,15,7],[16,4,16,7],[7,1,7,9],[10,4,10,6],[9,4,9,6],[62,0,62,1],[63,0,63,1],[63,4,63,6],[27,4,27,5],[31,4,31,5],[53,6,53,7],[54,6,54,7],[33,3,33,10],[34,3,34,10],[35,3,35,10],[41,0,49,10],[18,4,18,5],[18,6,18,7],[18,8,18,9],[19,4,19,5],[33,0,33,1],[23,8,23,10],[23,4,23,6],[66,0,66,1],[66,4,66,6],[67,0,67,1],[67,4,67,6],[64,0,64,1],[64,4,64,6],[65,0,65,1],[65,4,65,6],[87,2,87,7],[248,0,248,1],[248,4,248,6],[91,2,91,7],[89,2,89,7],[93,2,93,7],[95,2,95,7],[68,0,68,1],[68,4,68,6],[69,0,69,1],[69,4,69,6],[70,0,70,1],[70,4,70,6]]}
[null,null,null,null,null,null,null,null,null,"Rev.","2019-09-16"]
[null,null,null,null,null,null,null," = to be completed by Construction Manager"]
[null,null,null,null,null,null,null," = predetermined or automatic calculation"]
[]
["Exhibit G"]
[]
["PROPOSAL FOR PRE-CONSTRUCTION SERVICES (PCS)"]
[null,"(Complete cover pages and sections G.2, G.3, G.4.    Include investigatory trades work in section G.1 if required)"]
["In accordance with the Purchasing Contract Professional Terms and Conditions and Attachment A - Rates/Fees "]
["by Job Classification of AEC Department Contract #",null,null,null,{"$f":"IF(E11=\"Aims Group\",List!B1,IF(E11=\"A.Z.Shmina\",List!B2,IF(E11=\"Commercial Contracting Corporation\",List!B3,IF(E11=\"Kasco, Inc.\",List!B4,0))))","v":0},null,null,"for CM Services for Small Projects"]
["between The Regents of the University of Michigan and",null,null,null,null,null,null,", dated","2018-08-01",null,"the following"]
["Pre-Con proposal is submitted for:"]
[]
[]
[]
["PROJECT:",null,"BUILDING NAME:"]
[null,null,"BUILDING No. "]
[null,null,"PROJECT DESCRIPTION:"]
[]
[null,null,"U-M PROJECT NO. "]
[]
[]
[]
["Submitted via Email to:",null,null,"Design/Project Manager:",null,null,null,"Email:"]
[]
[]
[]
[null,null,null,"Date Submitted:"]
[]
[]
[]
[null,"Pre-Construction Services Proposal:",null,"Not-to-Exceed $",{"$f":"IFERROR('Pre-Con CSI Cost Est Summary'!M170:M170,0)","v":0}]
[]
[null,null,"Submitted By: ",{"$f":"E11","v":0}]
[null,null,"Address: "]
[]
[]
[null,null,null,null,null,null,null,null," = to be completed by Contractor"]
[null,null,null,null,null,null,null,null," = predetermined or automatic calculation"]
["GENERAL DESCRIPTION OF PROJECT AND SERVICES TO BE PROVIDED:"]
["[Scope of Work]"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["SCHEDULES (Part 3.7 and the Agreement For Professional Construction Management Services \"Agreement\")"]
[]
["The  Fixed Limit of Construction Cost (FLCC) Proposal will be submitted by :"]
["Additional established contract milestone dates are  "]
[]
[]
[]
[]
["PROJECT TEAM"]
["The following Project Team will be utilized for this project and unless otherwise noted below, will be dedicated full time to the project."]
[]
["Title",null,"Name","% Effort","Explain Hours/Week/Project"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Acceptance of the above proposed team does not preclude the Construction Manager from providing the necessary personnel required for the "]
["Construction Manager to perform its services detailed in the Pre-Construction Services RFP.  Therefore, if the Construction Manager requires additional "]
["personnel to perform these services, such personnel shall be added without an increase to the Pre-Construction Services agreement, unless such "]
["increase in personnel is required due to circumstances detailed in Article 2.10.3.1 of the Construction Manager Agreement."]
[]
["In addition to any other audit rights which it might enjoy, the Owner shall also have the right to audit the Construction Manager's books and records "]
["pertaining to the monthly lump sums charged for staff.  The audit shall be for the purpose of verifying that (i) the calculation of the monthly lump sums"]
["is accurate and (ii) that the funds paid by the Owner for staff were applied by the Construction Manager as intended by the formula by which the "]
["amount of the monthly sum payments were derived."]
[]
[]
["PROPOSAL SIGNATURE"]
["The information provided herein is true and sufficiently complete so as not to be misleading."]
[]
[]
["Construction Manager:",null,{"$f":"E11","v":0}]
[]
["Signature:"]
[]
["Printed: "]
[]
["Title:"]
[]
["Date:"]

{"sheet":"Pre-Con CSI Cost Est Summary","index":2,"n_rows":268,"n_cols":14,"rows_kept":268,"cut":false,"hidden":false,"merged":[[0,0,0,11],[2,0,3,9],[43,8,46,11],[43,12,46,13],[267,0,267,11],[267,12,267,13],[266,0,266,4],[266,5,266,6],[266,7,266,9],[266,10,266,11],[262,0,265,1],[262,2,265,3],[262,4,265,5],[262,6,265,7],[262,8,265,11],[262,12,265,13],[49,12,49,13],[76,0,76,11],[76,12,76,13],[74,0,75,11],[74,12,75,13],[81,0,81,11],[47,12,47,13],[43,0,46,1],[81,12,81,13],[85,12,85,13],[27,12,30,13],[27,0,30,1],[27,6,30,7],[31,12,34,13],[35,12,38,13],[35,0,38,1],[27,2,30,3],[31,2,34,3],[35,2,38,3],[27,4,30,5],[31,4,34,5],[35,4,38,5],[27,8,30,11],[31,8,34,11],[35,8,38,11],[35,6,38,7],[39,12,42,13],[43,2,46,3],[43,4,46,5],[43,6,46,7],[31,0,34,1],[31,6,34,7],[19,12,22,13],[15,0,18,1],[15,6,18,7],[19,0,22,1],[19,6,22,7],[23,12,26,13],[15,2,18,3],[15,4,18,5],[15,8,18,11],[19,2,22,3],[23,2,26,3],[19,4,22,5],[23,4,26,5],[19,8,22,11],[23,8,26,11],[15,12,18,13],[23,0,26,1],[23,6,26,7],[11,12,14,13],[11,6,14,7],[11,0,14,1],[7,8,10,11],[7,2,10,3],[7,4,10,5],[11,2,14,3],[4,12,6,13],[7,0,10,1],[7,6,10,7],[7,12,10,13],[4,0,6,1],[4,2,6,3],[4,4,6,5],[4,6,6,7],[4,8,6,11],[11,4,14,5],[11,8,14,11],[72,16,72,17],[72,18,72,19],[78,0,78,11],[78,12,78,13],[79,0,79,11],[79,12,79,13],[77,0,77,11],[77,12,77,13],[80,12,80,13],[80,0,80,11],[87,12,87,13],[101,0,101,10],[101,12,101,13],[82,0,82,11],[82,12,82,13],[83,0,83,11],[83,12,83,13],[84,0,84,11],[84,12,84,13],[87,0,87,11],[85,0,85,11],[105,12,105,13],[103,0,103,10],[103,12,103,13],[110,0,110,11],[110,12,110,13],[107,12,107,13],[107,0,107,11],[106,12,106,13],[106,0,106,11],[104,0,104,10],[105,0,105,11],[128,14,128,15],[145,0,145,11],[146,0,146,5],[146,6,146,11],[144,0,144,11],[111,12,111,13],[108,0,108,11],[108,12,108,13],[109,0,109,11],[109,12,109,13],[120,0,120,4],[120,5,120,6],[120,7,120,9],[120,10,120,11],[117,0,118,4],[117,5,118,6],[117,7,118,9],[117,10,118,11],[119,0,119,4],[119,5,119,6],[119,7,119,9],[119,10,119,11],[111,0,111,11],[122,0,122,4],[155,12,155,13],[157,12,157,13],[153,0,153,11],[151,12,151,13],[152,12,152,13],[153,12,153,13],[154,12,154,13],[124,5,124,6],[147,12,147,13],[143,0,143,4],[124,0,124,4],[124,7,124,9],[124,10,124,11],[127,10,127,11],[127,0,127,9],[125,0,125,4],[125,5,125,6],[125,7,125,9],[125,10,125,11],[126,0,126,4],[126,5,126,6],[126,7,126,9],[126,10,126,11],[162,0,162,11],[162,12,162,13],[163,0,163,11],[163,12,163,13],[169,12,169,13],[164,0,164,11],[164,12,164,13],[165,0,165,11],[165,12,165,13],[166,12,166,13],[166,7,166,11],[166,0,166,6],[167,0,167,11],[167,12,167,13],[169,0,169,11],[39,0,42,1],[39,2,42,3],[39,4,42,5],[39,6,42,7],[39,8,42,11],[123,5,123,6],[123,7,123,9],[123,10,123,11],[121,0,121,4],[121,5,121,6],[121,7,121,9],[121,10,121,11],[49,0,49,2],[102,0,102,10],[122,5,122,6],[122,7,122,9],[122,10,122,11],[123,0,123,4]]}
["CONSTRUCTION MANAGER PRE-CONSTRUCTION SERVICES (PCS) PROPOSAL for SMALL PROJECTS",null,null,null,null,null,null,null,null,null,null,null,"Rev.","2019-09-16"]
["G.1   Investigatory Trades Bid Summary "]
["Attach all Trade Contractor proposals, including declinations, in order as listed below.  If self-performed, attach Owner provided Contractor Quotation Sheet with supporting documentation (available at https://umaec.umich.edu/for-vendors/project-documents/bid-resources/).",null,null,null,null,null,null,null,null,null,null," = to be completed by CM"]
[null,null,null,null,null,null,null,null,null,null,null," = predetermined or automatic calculation"]
["Scope/Trade\n(Includes CSI #'s for clarity)",null,"Proposed Trade Contractor / Self Perform / Estimate",null,"Proposed Amount",null,"EMR",null,"Proposal Detail",null,null,null,"Proposal Total"]
[]
[]
["(CSI # / Category)",null,null,null,0,null,null,null,null,null,null,null,{"$f":"E8","v":0}]
[]
[]
[]
["(CSI # / Category)",null,null,null,0,null,null,null,null,null,null,null,{"$f":"E12","v":0}]
[]
[]
[]
["(CSI # / Category)",null,null,null,0,null,null,null,null,null,null,null,{"$f":"E16","v":0}]
[]
[]
[]
["(CSI # / Category)",null,null,null,0,null,null,null,null,null,null,null,{"$f":"E20","v":0}]
[]
[]
[]
["(CSI # / Category)",null,null,null,0,null,null,null,null,null,null,null,{"$f":"E24","v":0}]
[]
[]
[]
["(CSI # / Category)",null,null,null,0,null,null,null,null,null,null,null,{"$f":"E28","v":0}]
[]
[]
[]
["(CSI # / Category)",null,null,null,0,null,null,null,null,null,null,null,{"$f":"E32","v":0}]
[]
[]
[]
["(CSI # / Category)",null,null,null,0,null,null,null,null,null,null,null,{"$f":"E36","v":0}]
[]
[]
[]
["(CSI # / Category)",null,null,null,0,null,null,null,null,null,null,null,{"$f":"E40","v":0}]
[]
[]
[]
["(CSI # / Category)",null,null,null,0,null,null,null,null,null,null,null,{"$f":"E44","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Investigatory Trade Contractor & Self-Perform Total - Not to Exceed",{"$f":"SUBTOTAL(9,M8:N47)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Total Amount:",{"$f":"M48","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["G.2. CM General Conditions Costs"]
[]
["Description",null,null,null,null,null,null,null,null,null,null,null,"Amount"]
[]
["Temp Protection",null,null,null,null,null,null,null,null,null,null,null,0]
["Dumpsters",null,null,null,null,null,null,null,null,null,null,null,0]
["Safety",null,null,null,null,null,null,null,null,null,null,null,0]
["Signage",null,null,null,null,null,null,null,null,null,null,null,0]
["IT Consumables",null,null,null,null,null,null,null,null,null,null,null,0]
["Progress/Final cleaning",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
["Total CM General Conditions Costs - Not to Exceed:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,M77:N87)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Insurance Costs will be $ per One Thousand $ ($1,000)",null,null,null,null,null,null,null,null,null,null,0,{"$f":"M112*L102/1000","v":0}]
["Subtotal",null,null,null,null,null,null,null,null,null,null,{"$f":"M102+M112","v":0}]
["Performance and Payment Bond Cost will be $ per One Thousand $ ($1,000)",null,null,null,null,null,null,null,null,null,null,0,{"$f":"L103*L104/1000","v":0}]
["Subtotal",null,null,null,null,null,null,null,null,null,null,{"$f":"M104+L103","v":0}]
["Total General Conditions Costs",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M88+M102+M104","v":0}]
[]
["G.1 Trades",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M50","v":0}]
["G.2 Subtotal General Conditions (excludes insurance and bonds)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M88","v":0}]
["G.3.1 Pre-Construction",null,null,null,null,null,null,null,null,null,null,null,{"$f":"K128","v":0}]
["G.4.1 Pre-Construction Fee",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M148","v":0}]
["Total CM General Conditions Costs - Not to Exceed:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M108:N111)","v":0}]
[]
["G.3 CM Pre-Construction Personnel Costs"]
[]
["G.3.1 Pre-Construction"]
[]
["Title/Name",null,null,null,null,"Job Charge Rate",null,"Total Hours",null,null,"Extended Amount"]
[]
[null,null,null,null,null,0,null,0,null,null,{"$f":"F120*H120","v":0}]
[null,null,null,null,null,0,null,0,null,null,{"$f":"F121*H121","v":0}]
[null,null,null,null,null,0,null,0,null,null,{"$f":"F122*H122","v":0}]
[null,null,null,null,null,0,null,0,null,null,{"$f":"F123*H123","v":0}]
[null,null,null,null,null,0,null,0,null,null,{"$f":"F124*H124","v":0}]
[null,null,null,null,null,0,null,0,null,null,0]
[null,null,null,null,null,0,null,0,null,null,0]
[]
["Total Pre-Construction Personnel Costs - Not to Exceed",null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,K120:L127)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["G.4.CM Pre-Construction Fee"]
[]
["Pre-Construction Fee* is calculated based on",null,null,null,null,0,"of combined Investigatory Trades, General Conditions and CM Personnel Costs."]
["    *Includes parking, transportation and required insurance and bonds during pre-construction"]
[]
["Subtotal Above Multiplied by CM Pre-Construction Fee of ",null,null,null,null,null,{"$f":"F142","v":0}]
["                                                                                                                     ",null,null,null,null,null,null,null,null,null,null,"Total CM Pre-Construction Fee - Not to Exceed",{"$f":"(K128+M88+M48)*F144","v":0}]
[]
["Construction - Fee is based upon",null,null,null,null,null,null,0.04,"of total Trade Contractor Costs"]
[]
["Construction Fee",null,null,null,null,null,null,null,null,null,null,null,"Amount"]
["Trade Contract Costs from Section G.1 CSI Cost Estimate Summary Trade Amount",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M50","v":0}]
["Subtotal",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M153","v":0}]
["Subtotal Above Multiplied by CM Construction Fee of ",null,null,null,null,null,null,null,null,{"$f":"H150","v":0.04},null,null,{"$f":"M154*J155","v":0}]
["                                                                                                   ",null,null,null,null,null,null,null,null,null,null,"Total CM Construction Fee - Not to Exceed",{"$f":"M155","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Total Pre-Construction and Construction Fee - Not to Exceed",{"$f":"M156+M148","v":0}]
[]
[]
["CM Pre-Construction Services Cost Summary"]
[]
["G.1 Investigatory Trades Total",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M48","v":0}]
["G.2 CM General Conditions Costs Total",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M88","v":0}]
["G.3 Total Pre-Construction and Construction Personnel Costs",null,null,null,null,null,null,null,null,null,null,null,{"$f":"K128","v":0}]
["G.4 CM Fee Total",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M148","v":0}]
[]
["G.5 Total (Sum of G.2, G.3, and G.4)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,M164:N166)","v":0}]
[]
["PRE-CONSTRUCTION SERVICES COST (Sum of G.1 and G.4)   -  Not to Exceed",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M164+M163+M165+M166","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["(CSI # / Category)",null,null,null,0,null,null,null,null,null,null,null,{"$f":"E263","v":0}]
[]
[]
[]
[null,null,null,null,null,0,null,0,null,null,{"$f":"F267*H267","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"List","index":3,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Aims Group","CM-073121-1"]
["A.Z.Shmina","CM-073121-2"]
["Commercial Contracting Corporation","CM-073121-3"]
["Kasco, Inc.","CM-073121-4"]