jagomart
digital resources
picture1_Ms Excel Formula Pdf File Download 31718 | Exhibits Ae Agree


 242x       Filetype XLS       File size 0.12 MB       Source: www2.calstate.edu


File: Ms Excel Formula Pdf File Download 31718 | Exhibits Ae Agree
sheet 1 instructions completing the designbidaward ae exhibits legend editinsert project information as indicated a data entry cell user to enter appropriate information formatting is automatic do not enter commas ...

icon picture XLS Filetype Excel XLS | Posted on 08 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Instructions



Completing the Design-Bid-Award A/E Exhibits





Legend:


[Insert…]
Edit/Insert project information as indicated.







A data entry cell. User to enter appropriate information.



Formatting is automatic. Do not enter commas or '$' signs.







A calculated cell. Values generated by formula based on values entered in select data entry cells.



Formatting is automatic. Do not enter commas or '$' signs.




Building Fee Schedule Classification



Header
Edit/insert agreement number, project name, and name of service provider in header of worksheet.

Cell D6
Enter the single digit building schedule classification that most completely represents the project. This is either 0, 1, 2, 3, 4, or 5. Enter or leave 0 (zero) for building type where no dollar value is listed.
Exhibit B Schedule of Lump Sum Fees for Design-Bid-Award Projects



Header
Edit/insert agreement number, project name, and name of service provider in header of worksheet.

Cell E14
Edit the placeholder value for New Construction. Enter 0 (zero) when none. This value is the Item 5 'Subtotal: Building, Sitework and Escalation" in the 2-7. It includes Item 1 'Total Building', Item 2 'Total Site work' and Item 4 'Escalation'. Enter or leave 0 (zero) if there is no dollar value.

Cell F14
Edit the placeholder value for Building Fee Type. A value of 1, 2, 3, 4, or 5 must be entered to calculate fees. A entry of zero here will return a 'zero' for fee.

Cell E16
Edit the placeholder value for Renovation Construction. Enter 0 (zero) when none. This value is the Item 5 'Subtotal: Building, Sitework and Escalation' in the 2-7. It includes Item 1 'Total Building', Item 2 'Total Site work' and Item 4 'Escalation'. Enter or leave 0 (zero) if there is no dollar value.

Cell F16
Edit the placeholder value for Building Fee Type. A value of 1, 2, 3, 4, or 5 must be entered to calculate fees. A entry of zero here will return a 'zero' for fee.
Exhibit C Project Design Schedule



Header
Edit/insert agreement number, project name, and name of service provider in header of worksheet.

Dates
Enter desired dates (dd/mm/yy). These are the original target dates. The Agreement describes how these dates shall be further defined and adjusted during the course of the project.
Exhibits D Submittal Requirements & Procedure Guide for CSU Capital Projects





Download current Pro Guide edition from CPDC A/E website, This is Exhibit D. Attach it, along with the completed Agreement, Rider A, and Exhibits A, B, C, and E to complete the Agreement package.
Exhibits E Architect/Engineer Hourly Rate Schedules Applicable to this Project





Include the Architect's and their Normal Consulting Engineer's hourly rates schedules applicable to the project. Assemble and label each 'Exhibit E, Page x of y'.

Sheet 2: Bldg Fee Schedule



BUILDING SCHEDULE CLASSIFICATION


















This project is classified as a Schedule 2 Building for purposes of fee calculation.








Schedule 1


Schedule 3 - continued

101
Monuments
317
Industrial Arts
102
Entrance Structure
318
Language Arts
103
Bridges
319
Music
104
Other
320
Physical Education/ Gymnasium/ Dance Studios




321
Psychology
Schedule 2


322
Social Science
201
Biological Science
323
Other
202
Cafeteria



203
College Union



204
Computer Facility
Schedule 4

205
Health Clinic
401
Amphitheater
206
Little Theater & Auditorium (<500 seats)
402
Parking Lot
207
Library/ Information Resource Center
403
Parking Structure
208
Museum & Gallery
404
Residence/Student Housing
209
Performing Arts Facility/ Theatre (500+ seats)
405
Site Development
210
Physical Science
406
Stadium
211
Student Recreation Center
407
Utilities/ Infrastructure/ Telecom
212
Other
408
Other














Schedule 3


Schedule 5

301
Administration
501
Corporation Yard (warehouses)
302
Agriculture
502
Farm Building (simple)
303
Aquatic Facility
503
Other
304
Art



305
Asbestos Abatement/Alterations



306
Bookstore



307
Business Admin./ Student Business Services



308
Central Heating and Cooling Plant



309
Child Care



310
Cogeneration Buildings & Equipment



311
Corporation Yard (shops)



312
Education



313
Engineering



314
Faculty Offices



315
Home Economics



316
Humanities




Sheet 3: Exhibit B




Exhibit B








SCHEDULE OF LUMP SUM FEES for DESIGN-BID-AWARD PROJECTS








ARCHITECTS/ENGINEER'S BASIC SERVICES



































Date:








Project: [Insert]





This is a look up table

Campus: [Insert]





Not necessary to print

A/E: [Insert]

















A/E FEE CALCULATION

Construction Building Type A/E A/E Fee as a %
Fee Calculation Information




Budget (0,1,2,3,4, or 5) Fee of Construction (3)
LOG Calculations & Coefficients

New Construction

$0 0 $0 0.00%
Err:502











Renovation Construction

$0 0 $0 0.00%
Err:502









Err:502

Total A/E Construction Budget

$0
$0

Err:502









Err:502











A/E FEE PAYMENT SCHEDULE (1)









Schematic Preliminary Construction
Construction Record


Total Design Design Documents Bidding Administration (2) Drawings


100% 25% 15% 35% 2% 21% 2%
Fee value to 2 places

$0 $0 $0 $0 $0 $0 $0
$0.00

at 25% - - $0





at 50% $0 $0 $0 at 100% Monthly At 100%


at 75% - - $0





at 100% $0 $0 $0

























Notes:








#1) Fee formula is described at CPDC A/E website:








http://www.calstate.edu/cpdc/Suam/Appendices/Appendix_C.shtml








#2) Construction Administration fee paid in monthly payments








equal to the percentage of project's construction completion.








#3) Fee percentage falls logarithmically as project construction costs increases.








Fee percentage is a result of the fee calculation. It is not the originator of the fee.




























Fee Summary








P
$0
Schematics + Design Development




W
$0
Construction Documents + Bidding




C
$0
Const. Admin. + Rec. Dwgs.














TOTAL
$0
Total PWC














The words contained in this file might help you see if this file matches what you are looking for:

...Sheet instructions completing the designbidaward ae exhibits legend editinsert project information as indicated a data entry cell user to enter appropriate formatting is automatic do not commas or signs calculated values generated by formula based on entered in select cells building fee schedule classification header agreement number name and of service provider worksheet d single digit that most completely represents this either leave zero for type where no dollar value listed exhibit b lump sum fees projects e edit placeholder new construction when none item subtotal sitework escalation quot it includes total site work if there f must be calculate here will return renovation c design dates desired ddmmyy these are original target describes how shall further defined adjusted during course submittal requirements amp procedure guide csu capital download current pro edition from cpdc website attach along with completed rider complete package architectengineer hourly rate schedules applic...

no reviews yet
Please Login to review.