Spreadsheet: 136938d1326894438-auto-populate-on-different-sheet-from-lowest-total-bidder-dollars-and-name-fee-tabulation-example
Sheet: Arch Fee

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  | Percentage of Total Hours for Average Sheet: |  | 0 | 0 | 0.05 | 0 | 0 | 0 | 0.1 | 0 | 0 | 0.8 | 0.05 |  | 1
 | Sht No. | Architectural Drawings | Total Hours Per Sheet |  | Senior Principal | Principal | Supervisor | Professional I | Professional II | Tech I | Tech II | Tech III | Tech IV | Tech V | Tech VI
P1 |  | Scope Trip
 |  | Trip Coordination
 |  | Proposal, Permitting  / Initial Due Diligence |  |  |  |  | 2
 |  | Scope Trip Time / Travel Time |  |  |  |  |  |  |  |  | 4 |  |  | 4
 |  | Scope Trip Report |  |  |  |  |  |  |  |  |  |  |  | 3
 |  | Total Hours: |  |  | 0 | 0 | 2 | 0 | 0 | 0 | 4 | 0 | 0 | 7 | 0
 |  | Total Hours: |  |  | 0 | 0 | 2 | 0 | 0 | 0 | 4 | 0 | 0 | 7 | 0 |  | 13
 |  | Hourly Rates: |  |  | 190 | 167 | 125 | 120 | 115 | 105 | 98 | 93 | 88 | 78 | 70
 |  | Total Fee: |  |  | 0 | 0 | 250 | 0 | 0 | 0 | 392 | 0 | 0 | 546 | 0 |  | 1188 | 1200
P1 | Building Survey  / Pre-Development / Landlord Package
 | CS1.0 | Cover Sheet | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | AS1.0 | Exterior & Site Plan Issues | 5 |  | 0 | 0 | 0.25 | 0 | 0 | 0 | 0.5 | 0 | 0 | 4 | 0.25
 | A1.0 | Floor Plan & Vacant Space/ Demising Wall | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A4.0 | RCP & Lighting | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A5.0 | Skylights Layout & Coordination | 7 |  | 0 | 0 | 0.35 | 0 | 0 | 0 | 0.7000000000000001 | 0 | 0 | 5.600000000000001 | 0.35
 | A6.0 | Exterior Storefront Elevations & Signage | 6 |  | 0 | 0 | 0.3 | 0 | 0 | 0 | 0.6000000000000001 | 0 | 0 | 4.800000000000001 | 0.3
 |  | Total Hours: | 18 |  | 0 | 0 | 0.9000000000000001 | 0 | 0 | 0 | 1.8 | 0 | 0 | 14.4 | 0.9000000000000001 |  | 18
 |  | Hourly Rates: |  |  | 190 | 167 | 125 | 120 | 115 | 105 | 98 | 93 | 88 | 78 | 70
 |  | Total Fee: |  |  | 0 | 0 | 112.5 | 0 | 0 | 0 | 176.4 | 0 | 0 | 1123.2 | 63.00000000000001 |  | 1475.1 | 1500
 |  | Due Diligence |  |  |  |  | 1 |  |  |  | 1 |  |  | 2
 |  | Design Development Package/Coordination |  |  |  |  | 2 |  |  |  | 2 |  |  | 2
 |  | Consultant Coord. & Distribution |  |  |  |  | 1 |  |  |  | 2 |  |  | 1
 |  | Owner Coordination |  |  |  |  | 1 |  |  |  | 0.5 |  |  | 0.5
 |  | Devolper Coodination |  |  |  |  |  |  |  |  | 1 |  |  | 1
 |  | Miscellaneous |  |  |  |  | 3 |  |  |  | 2 |  |  | 2
 |  | Total Hours: |  |  | 0 | 0 | 8 | 0 | 0 | 0 | 8.5 | 0 | 0 | 8.5 | 0
 |  | Total Hours: |  |  | 0 | 0 | 8 | 0 | 0 | 0 | 8.5 | 0 | 0 | 8.5 | 0 |  | 25
 |  | Hourly Rates: |  |  | 190 | 167 | 125 | 120 | 115 | 105 | 98 | 93 | 88 | 78 | 70
 |  | Total Fee: |  |  | 0 | 0 | 1000 | 0 | 0 | 0 | 833 | 0 | 0 | 663 | 0 |  | 2496 | 2500
P2 |  | Construction Documents
 | CS1.0 | Cover Sheet, Index and Location Maps | 2 |  | 0 | 0 | 0.1 | 0 | 0 | 0 | 0.2 | 0 | 0 | 1.6 | 0.1
 | CS1.1 | Symbols / Abbreviations | 1 |  | 0 | 0 | 0.05 | 0 | 0 | 0 | 0.1 | 0 | 0 | 0.8 | 0.05
 | AS1.0 | Architectural Site Plan | 2 |  | 0 | 0 | 0.1 | 0 | 0 | 0 | 0.2 | 0 | 0 | 1.6 | 0.1
 | LS1.0 | Life Safety Plan/ Code Analysis | 3 |  | 0 | 0 | 0.15 | 0 | 0 | 0 | 0.3 | 0 | 0 | 2.4 | 0.15
 | [NAME] | Demo Plan | 8 |  | 0 | 0 | 0.4 | 0 | 0 | 0 | 0.8 | 0 | 0 | 6.4 | 0.4
 | D2.0 | Demo Section & Details | 6 |  | 0 | 0 | 0.3 | 0 | 0 | 0 | 0.6000000000000001 | 0 | 0 | 4.800000000000001 | 0.3
 | A1.0 | [NAME] | 14 |  | 0 | 0 | 0.7000000000000001 | 0 | 0 | 0 | 1.4 | 0 | 0 | 11.2 | 0.7000000000000001
 | A3.0 | Finish Plan | 4 |  | 0 | 0 | 0.2 | 0 | 0 | 0 | 0.4 | 0 | 0 | 3.2 | 0.2
 | A4.0 | Reflected Ceiling Plan | 10 |  | 0 | 0 | 0.5 | 0 | 0 | 0 | 1 | 0 | 0 | 8 | 0.5
 | A5.0 | [NAME] | 6 |  | 0 | 0 | 0.3 | 0 | 0 | 0 | 0.6000000000000001 | 0 | 0 | 4.800000000000001 | 0.3
 | A6.0 | Exterior Elevations | 6 |  | 0 | 0 | 0.3 | 0 | 0 | 0 | 0.6000000000000001 | 0 | 0 | 4.800000000000001 | 0.3
 | A7.0 | Interior Elevations | 6 |  | 0 | 0 | 0.3 | 0 | 0 | 0 | 0.6000000000000001 | 0 | 0 | 4.800000000000001 | 0.3
 | A8.0 | Restroom Plan & Elevations | 6 |  | 0 | 0 | 0.3 | 0 | 0 | 0 | 0.6000000000000001 | 0 | 0 | 4.800000000000001 | 0.3
 | A9.0 | Door Schedule & Details | 2 |  | 0 | 0 | 0.1 | 0 | 0 | 0 | 0.2 | 0 | 0 | 1.6 | 0.1
 | A9.1 | Storefront Sections & Details | 8 |  | 0 | 0 | 0.4 | 0 | 0 | 0 | 0.8 | 0 | 0 | 6.4 | 0.4
 | A10.0 | Wall Sections | 10 |  | 0 | 0 | 0.5 | 0 | 0 | 0 | 1 | 0 | 0 | 8 | 0.5
 | A10.1 | Wall Sections | 6 |  | 0 | 0 | 0.3 | 0 | 0 | 0 | 0.6000000000000001 | 0 | 0 | 4.800000000000001 | 0.3
 | A10.2 | Wall Sections | 6 |  | 0 | 0 | 0.3 | 0 | 0 | 0 | 0.6000000000000001 | 0 | 0 | 4.800000000000001 | 0.3
 | A11.0 | Details | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A11.1 | Exterior Details | 8 |  | 0 | 0 | 0.4 | 0 | 0 | 0 | 0.8 | 0 | 0 | 6.4 | 0.4
 | A11.2 | Interior Details | 3 |  | 0 | 0 | 0.15 | 0 | 0 | 0 | 0.3 | 0 | 0 | 2.4 | 0.15
 | A13.0 | MDC- [NAME] | 3 |  | 0 | 0 | 0.15 | 0 | 0 | 0 | 0.3 | 0 | 0 | 2.4 | 0.15
 | A13.1 | MDC- Reflected Ceiling Plan | 3 |  | 0 | 0 | 0.15 | 0 | 0 | 0 | 0.3 | 0 | 0 | 2.4 | 0.15
 | A13.2 | MDC- Schedules & Legends | 3 |  | 0 | 0 | 0.15 | 0 | 0 | 0 | 0.3 | 0 | 0 | 2.4 | 0.15
 | A13.3 | MDC- Interior Elevations | 3 |  | 0 | 0 | 0.15 | 0 | 0 | 0 | 0.3 | 0 | 0 | 2.4 | 0.15
 | A13.4 | MDC- Details | 3 |  | 0 | 0 | 0.15 | 0 | 0 | 0 | 0.3 | 0 | 0 | 2.4 | 0.15
 | A14.0 | MHT Floor Plan & Schedule | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A14.1 | MHT Finish Plan | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A14.2 | MHT Reflected Ceiling Plan | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A14.3 | [NAME] | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A15.0 | PS Enlarged Plans | 6 |  | 0 | 0 | 0.3 | 0 | 0 | 0 | 0.6000000000000001 | 0 | 0 | 4.800000000000001 | 0.3
 | F-1 | Fixture Plan | 2 |  | 0 | 0 | 0.1 | 0 | 0 | 0 | 0.2 | 0 | 0 | 1.6 | 0.1
 | F-2 | Fixture Sign & Paint Plan | 2 |  | 0 | 0 | 0.1 | 0 | 0 | 0 | 0.2 | 0 | 0 | 1.6 | 0.1
 | F-4 | Fixture Extension Plan & Details | 2 |  | 0 | 0 | 0.1 | 0 | 0 | 0 | 0.2 | 0 | 0 | 1.6 | 0.1
 | F-5 | Fixture Extension Details | 2 |  | 0 | 0 | 0.1 | 0 | 0 | 0 | 0.2 | 0 | 0 | 1.6 | 0.1
 | F-6 | PS Stone Counter-top Plan | 2 |  | 0 | 0 | 0.1 | 0 | 0 | 0 | 0.2 | 0 | 0 | 1.6 | 0.1
 |  | Total Hours: | 148 |  | 0 | 0 | 7.4 | 0 | 0 | 0 | 14.8 | 0 | 0 | 118.4 | 7.4 |  | 148
 |  | Hourly Rates: |  |  | 190 | 167 | 125 | 120 | 115 | 105 | 98 | 93 | 88 | 78 | 70
 |  | Total Fee: |  |  | 0 | 0 | 925 | 0 | 0 | 0 | 1450.4 | 0 | 0 | 9235.2 | 518 |  | 12128.6 | 12100
P2 |  | CD Coordination
 |  | Owner Coordination |  |  |  |  | 2 |  |  |  | 1 |  |  | 1
 |  | Devolper Coodination |  |  |  |  |  |  |  |  | 1 |  |  | 1
 |  | Specifications |  |  |  |  | 4 |  |  |  | 1
 |  | Redlining / QC& QA |  |  |  |  | 4 |  |  |  | 1 |  |  | 1
 |  | Plotting Distribution |  |  |  |  |  |  |  |  | 1 |  |  | 4
 |  | Miscellaneous |  |  |  |  | 1 |  |  |  | 1 |  |  | 1
 |  | Total Hours: |  |  | 0 | 0 | 8 | 0 | 0 | 0 | 8.5 | 0 | 0 | 8.5 | 0
 |  | Total Hours: |  |  | 0 | 0 | 11 | 0 | 0 | 0 | 6 | 0 | 0 | 8 | 0 |  | 25
 |  | Hourly Rates: |  |  | 190 | 167 | 125 | 120 | 115 | 105 | 98 | 93 | 88 | 78 | 70
 |  | Total Fee: |  |  | 0 | 0 | 1375 | 0 | 0 | 0 | 588 | 0 | 0 | 624 | 0 |  | 2587 | 2600
P3 |  | Balance of Construction Documents
 | CS1.0 | Cover Sheet, Index and Location Maps | 1 |  | 0 | 0 | 0.05 | 0 | 0 | 0 | 0.1 | 0 | 0 | 0.8 | 0.05
 | CS1.1 | Symbols / Abbreviations | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | AS1.0 | Architectural Site Plan | 0.5 |  | 0 | 0 | 0.025 | 0 | 0 | 0 | 0.05 | 0 | 0 | 0.4 | 0.025
 | LS1.0 | Life Safety Plan/ Code Analysis | 0.5 |  | 0 | 0 | 0.025 | 0 | 0 | 0 | 0.05 | 0 | 0 | 0.4 | 0.025
 | [NAME] | Demo Plan | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | D2.0 | Demo Section & Details | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A1.0 | [NAME] | 2 |  | 0 | 0 | 0.1 | 0 | 0 | 0 | 0.2 | 0 | 0 | 1.6 | 0.1
 | A3.0 | Finish Plan | 0.5 |  | 0 | 0 | 0.025 | 0 | 0 | 0 | 0.05 | 0 | 0 | 0.4 | 0.025
 | A4.0 | Reflected Ceiling Plan | 1 |  | 0 | 0 | 0.05 | 0 | 0 | 0 | 0.1 | 0 | 0 | 0.8 | 0.05
 | A5.0 | [NAME] | 1 |  | 0 | 0 | 0.05 | 0 | 0 | 0 | 0.1 | 0 | 0 | 0.8 | 0.05
 | A6.0 | Exterior Elevations | 2 |  | 0 | 0 | 0.1 | 0 | 0 | 0 | 0.2 | 0 | 0 | 1.6 | 0.1
 | A7.0 | Interior Elevations | 2 |  | 0 | 0 | 0.1 | 0 | 0 | 0 | 0.2 | 0 | 0 | 1.6 | 0.1
 | A8.0 | Restroom Plan & Elevations | 1 |  | 0 | 0 | 0.05 | 0 | 0 | 0 | 0.1 | 0 | 0 | 0.8 | 0.05
 | A9.0 | Door Schedule & Details | 0.5 |  | 0 | 0 | 0.025 | 0 | 0 | 0 | 0.05 | 0 | 0 | 0.4 | 0.025
 | A9.1 | Storefront Sections & Details | 1 |  | 0 | 0 | 0.05 | 0 | 0 | 0 | 0.1 | 0 | 0 | 0.8 | 0.05
 | A10.0 | Wall Sections | 2 |  | 0 | 0 | 0.1 | 0 | 0 | 0 | 0.2 | 0 | 0 | 1.6 | 0.1
 | A10.1 | Wall Sections | 1 |  | 0 | 0 | 0.05 | 0 | 0 | 0 | 0.1 | 0 | 0 | 0.8 | 0.05
 | A10.2 | Wall Sections | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A11.0 | Details | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A11.1 | Exterior Details | 1 |  | 0 | 0 | 0.05 | 0 | 0 | 0 | 0.1 | 0 | 0 | 0.8 | 0.05
 | A11.2 | Interior Details | 3 |  | 0 | 0 | 0.15 | 0 | 0 | 0 | 0.3 | 0 | 0 | 2.4 | 0.15
 | A13.0 | MDC- [NAME] | 1 |  | 0 | 0 | 0.05 | 0 | 0 | 0 | 0.1 | 0 | 0 | 0.8 | 0.05
 | A13.1 | MDC- Reflected Ceiling Plan | 1 |  | 0 | 0 | 0.05 | 0 | 0 | 0 | 0.1 | 0 | 0 | 0.8 | 0.05
 | A13.2 | MDC- Schedules & Legends | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A13.3 | MDC- Interior Elevations | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A13.4 | MDC- Details | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A14.0 | MHT Floor Plan & Schedule | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A14.1 | MHT Finish Plan | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A14.2 | MHT Reflected Ceiling Plan | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A14.3 | [NAME] | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A15.0 | PS Enlarged Plans | 2 |  | 0 | 0 | 0.1 | 0 | 0 | 0 | 0.2 | 0 | 0 | 1.6 | 0.1
 | F-1 | Fixture Plan | 1 |  | 0 | 0 | 0.05 | 0 | 0 | 0 | 0.1 | 0 | 0 | 0.8 | 0.05
 | F-2 | Fixture Sign & Paint Plan | 1 |  | 0 | 0 | 0.05 | 0 | 0 | 0 | 0.1 | 0 | 0 | 0.8 | 0.05
 | F-4 | Fixture Extension Plan & Details | 1 |  | 0 | 0 | 0.05 | 0 | 0 | 0 | 0.1 | 0 | 0 | 0.8 | 0.05
 | F-5 | Fixture Extension Details | 1 |  | 0 | 0 | 0.05 | 0 | 0 | 0 | 0.1 | 0 | 0 | 0.8 | 0.05
 | F-6 | PS Stone Counter-top Plan | 1 |  | 0 | 0 | 0.05 | 0 | 0 | 0 | 0.1 | 0 | 0 | 0.8 | 0.05
 |  | Total Hours: | 29 |  | 0 | 0 | 1.450000000000001 | 0 | 0 | 0 | 2.900000000000001 | 0 | 0 | 23.20000000000001 | 1.450000000000001 |  | 29.00000000000001
 |  | Hourly Rates: |  |  | 190 | 167 | 125 | 120 | 115 | 105 | 98 | 93 | 88 | 78 | 70
 |  | Total Fee: |  |  | 0 | 0 | 181.2500000000001 | 0 | 0 | 0 | 284.2000000000001 | 0 | 0 | 1809.600000000001 | 101.5 |  | 2376.550000000001 | 2400
P3 |  | Construction Administration
 |  | Consultant Coordination & Distribution |  |  |  |  | 2 |  |  |  |  |  |  | 2
 |  | Redlining / QC& QA |  |  |  |  | 4 |  |  |  |  |  |  | 2
 |  | [NAME] |  |  |  |  | 1 |  |  |  |  |  |  | 1
 |  | [NAME] |  |  |  |  | 1 |  |  |  |  |  |  | 2
 |  | Plotting Distribution |  |  |  | 0.5 | 0.5 |  |  |  |  |  |  | 2
 |  | Bldg. Dept Coordination & Revisions |  |  |  |  | 2 |  |  |  |  |  |  | 6
 |  | Construction Administration |  |  |  |  | 6 |  |  |  |  |  |  | 10 | 2
 |  | X-list / GO-21 & GO-13 Updates |  |  |  |  | 2 |  |  |  |  |  |  | 6
 |  | Construction Observation Visits/Punchlist |  |  |  |  | 2 |  |  |  |  |  |  | 4
 |  | Review Shop Drawings / RFI's / GC Questions |  |  |  |  | 2 |  |  |  |  |  |  | 8
 |  | As-Builts & Archiving |  |  |  |  | 1 |  |  |  |  |  |  | 2
 |  | Final Close-out of Project |  |  |  | 1 | 1 |  |  |  |  | 2 |  | 2 | 2
 |  | .
 |  | SubTotal Hours: |  |  | 0 | 1.5 | 24.5 | 0 | 0 | 0 | 0 | 2 | 0 | 47 | 4
 |  | Total Hours: |  |  | 0 | 1.5 | 24.5 | 0 | 0 | 0 | 0 | 2 | 0 | 47 | 4 |  | 79
 |  | Hourly Rates: |  |  | 190 | 167 | 125 | 120 | 115 | 105 | 98 | 93 | 88 | 78 | 70
 |  | Total Fee: |  |  | 0 | 250.5 | 3062.5 | 0 | 0 | 0 | 0 | 186 | 0 | 3666 | 280 |  | 7445 | 7400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sub Total: |  | 29696.25 | 29700
 |  |  |  |  |  |  |  |  |  |  | Reimbursables |  |  | Consultants Estimate
 |  |  |  |  |  |  |  |  |  | Architectural | 1800 |  |  |  | Mechanical |  | 0
 |  |  |  |  |  |  |  |  |  | Mechanical | 0 |  |  |  | Electrical |  | 0
 |  | Total Architectural Hours = | 337 |  |  |  |  |  |  | Electrical | 0 |  |  |  | Structural |  | 0
 |  |  |  |  |  |  |  |  |  | Structural | 0 |  |  |  | F.P. / F.A. |  | 0
 |  |  |  |  |  |  |  |  |  | F.P. / F.A. | 0 |  |  |  | Civil |  | 0
 |  |  |  |  |  |  |  |  |  | Functional Commissioning | 0 |  |  |  | Reimbursables |  | 1800
 |  |  |  |  |  |  |  |  |  | Civil Engineering | 0 |  |  |  | Functional Comm. |  | 0
 |  |  |  |  |  |  |  |  |  | Bldg. Dept. Plan Review Fees | 0 |  |  |  | Bldg. Dept. Plan Review Fees |  | 0
 |  |  |  |  |  |  |  |  |  | GeoTech | 0 |  |  |  | GeoTech |  | 0
 |  |  |  |  |  |  |  |  |  | Skylight Energy Modeling | 0 |  |  |  | Skylight Energy Modeling |  | 0
 |  |  |  |  |  |  |  |  |  | Expediter/Third Party Reviewer | 0 |  |  |  | Expediter/Third Party Reviewer |  | 0
 |  |  |  |  |  |  |  |  |  | Landscaping | 0 |  |  |  | Landscaping |  | 800
 |  |  |  |  |  |  |  |  |  | Sub Total: | 1800 |  |  |  | Grand Total: |  | 32300