ATTACHMENT IV - A-E FEE PROPOSAL WORKSHEET.xls

XLS spreadsheet 269 KB Posted

Attached to
AE MATOC IDIQ (NCO 22) SOLICITATION Federal contract opportunity
Solicitation number
36C26224R0013_1
Issued by
Department of Veterans Affairs Veterans Health Administration Veterans Integrated Service Network 22

About this file

This document is an Architect-Engineering (A-E) Fee Proposal Worksheet that provides instructions and a template for submitting pricing proposals for A-E services. It includes worksheets for the prime contractor and subcontractors, with sections for entering hours, labor rates, overhead, profit, and other direct costs for three types of services: Concept (Type A), Design (Type B), and Construction Support (Type C). The worksheet also includes a Cover Sheet that summarizes the total proposed pricing. The template is designed to be used for a federal contract opportunity related to providing A-E design services on an as-needed basis under a Multiple Award Indefinite Delivery Indefinite Quantity (IDIQ) contract for the Department of Veterans Affairs Veterans Integrated Service Network 22 (VISN 22). The contract will have a base period and four option periods, with a total anticipated value not to exceed $45 million. The North American Industry Classification System (NAICS) codes for this opportunity are 541310 Architectural Services, 541320 Landscape Architectural Services, and 541330 Engineering Services.

View the file

Other files for this federal contract opportunity

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Instructions

1. This is an automated version of a "Boiler Plate" Worksheet and Cover Page for Architect-Engineer Proposals and Independent Government Estimates (IGE).

2. The "Prime A-E Worksheet" rolls up data from each subconsultant worksheet.

3. The "Cover Sheet" rolls up most of the data from the Prime A-E Worksheet.

4. The "Detail" Tab is used for populating the hours proposed by each discipline (Prime in-house only) for Investigative (Type A), Design (Type B) and Construction Support (Type C) services. Those hours will be reflected in the "Prime" worksheet.

5. All editable areas of this workbook should be highlighted in Yellow. All other areas are locked to prevent accidental erasure of formulas. There are also some individual Comments attached to some of the blocks giving more detailed instructions. Please take the time to read these comments before entering any data, as they may affect related areas in the workbook.

6. Each Contractor Proposal or IGE will include the Cover Sheet, the Prime A-E Worksheet and any subcontractor sheets as appropriate.

7. Should something not work properly, please notify the Contracting Officer so he/she can try to correct it.

(Spreadsheet Formulas Updated as of: 10 May 2008) (Coversheet Updated as of: 10 May 2008) (Updated/Corrected MCC 6% formula on 18 March 2003)

Prime

Architect-Engineer Worksheet
RFP/Project Number:Contract No:
Title:DO/TO No:
Contractor:Date:
Concept A ServicesDesign B ServicesConstruction C Services
Services (In House)HoursRateTotalHoursRateTotalHoursRateTotal
Project Manager0$0.000$0.00$0.000$0.00$0.00
Sr. Architect0$0.000$0.00$0.000$0.00$0.00
Civil Engr0$0.000$0.00$0.000$0.00$0.00
Struct. Engr0$0.000$0.00$0.000$0.00$0.00
Mech. Engr0$0.000$0.00$0.000$0.00$0.00
Electrical Engr0$0.000$0.00$0.000$0.00$0.00
CADD0$0.000$0.00$0.000$0.00$0.00
Arch Drafter0$0.000$0.00$0.000$0.00$0.00
Elect Drafter0$0.000$0.00$0.000$0.00$0.00
Mech Drafter0$0.000$0.00$0.000$0.00$0.00
Spec Writer0$0.000$0.00$0.000$0.00$0.00
Estimator (see sub1)0$0.000$0.00$0.000$0.00$0.00
Typist0$0.000$0.00$0.000$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Subtotal$0.00Subtotal$0.00$0.00
On-site InspectionHours per day$ xDays =
Cost:00$0.00
Subtotal$0.00
Direct Labor Overhead (%)150.00%$0.00$0.00$0.00
Gen & Admin. Overhead (%)0.00%$0.00$0.00$0.00
Materials & Supplies
Subtotal:$0.00Subtotal:$0.00Subtotal:$0.00
Other - Subcontractor / Consultants
0$0.00$0.00$0.00
SUB 2$0.00$0.00$0.00
SUB 3$0.00$0.00$0.00
0$0.00$0.00$0.00
SUB 1$0.00$0.00$0.00
Subtotal$0.00Subtotal$0.00Subtotal$0.00
Profit or Fee (%)10.00%$0.00$0.00$0.00
Travel Cost (per JTR)$0.00$0.00$0.00
Subtotal$0.00Subtotal$0.00Subtotal$0.00
Sumbmittal Reproduction Cost (Show here if not part of G&A Overhead)As-Built Drawings
Cost xSets
35%$20.00$0.00
65%$20.00$0.00
100%$20.00$0.00
Final$40.00$0.00
Totals (Each Service)Total A$0.00Total B$0.00Total C$0.00
Subtotal for A, B & C$0.00
CostSets
Bid Reproduction Documents:$0.00
Code and Criteria Review:$0.00
(Sample comments: Lump sum price for each written report. No revision to drawings or specs. Performed at 6 month intervals.)
Grand Total$0.00
Estimated Number of Drawings: Site _ Civil _ Arch __ Mech _ Elect __ Other ___l .
Maximum Cost of Const:
Type A % of MCC:0.00%Type B % of MCC:0.00%Type C % of MCC:0.00%
(Statutory Max of 6% for Type B)

Change and add disciplines as necessary. This will populate the column header in "Detail" tab Enter the Rates in the Type A Services Culumn Only. They will carry Thru to This Column.

Enter the Rates in the Type A Services Culumn Only. They will carry Thru to This Column.

Include Itemized Breakdown for any Travel Costs not incluced in Overhead.

Include Itemized Breakdown for any Travel Costs not incluced in Overhead.

Include Itemized Breakdown for any Travel Costs not incluced in Overhead.

Include Itemized Breakdown for any Travel Costs not incluced in Overhead.

Include Itemized Breakdown for any Costs not incluced in Overhead.

Include Itemized Breakdown for any Costs not incluced in Overhead.

Include Itemized Breakdown for any Costs not incluced in Overhead.

Include Itemized Breakdown for any Costs not incluced in Overhead.

The MCC block must be completed as well as at least some of the data in the top portion for any of the percentages on this line to work.

Add the rates in this column only - even if not using the discipline for Type A Services. The rate will carry through to the Type B and C columns.

Check the appropriate block indicating whether this is the Proposal or the IGE Check the appropriate block indicating whether this is the Initial or Revised Proposal/IGE.

Note: The hours for this column are entered in the "Detail" tab for each discipline. Do not enter here.

PHOENIX:

The hours for this column are entered in the "Detail" tab for each discipline

PHOENIX:

The hours for this column are entered in the "Detail" tab for each discipline

PHOENIX:

Note: Disciplines entered in this column will reflect on the "Detail" tab as headers for hourly rates.

Government Estimate Fee Proposal Initial Revised

Sub1

Architect-Engineer Worksheet
RFP/Project Number:Contract No:
Title:DO No:
Contractor:SUB 1Date:
Concept A ServicesDesign B ServicesInspection C Services
Services (In House)HoursRateTotalHoursRateTotalHoursRateTotal
$0.000$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Add individual desciplines$0.00$0.00$0.00$0.00$0.00
as they apply to each$0.00$0.00$0.00$0.00$0.00
project.$0.00$0.00$0.00$0.00$0.00
Insure the rates are$0.00$0.00$0.00$0.00$0.00
correct for the option$0.00$0.00$0.00$0.00$0.00
period you are in$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Subtotal$0.00Subtotal$0.00$0.00
Inspection Cost:Hours per day$ xDays =
$0.00
Subtotal$0.00
Direct Labor Overhead (%)130.00%$0.00$0.00$0.00
Gen & Admin. Overhead (%)0.00%$0.00$0.00$0.00
Materials & Supplies$0.00$0.00
Subtotal:$0.00Subtotal:$0.00Subtotal:$0.00
Other - Subcontractor / Consultants
Subtotal$0.00Subtotal$0.00Subtotal$0.00
Profit or Fee (%)10.00%$0.00$0.00$0.00
Travel Cost (per JTR)
Subtotal$0.00Subtotal$0.00Subtotal$0.00
Total for A, B & C$0.00

Check the appropriate block indicating whether this is the Proposal or the IGE Check the appropriate block indicating whether this is the Initial or Revised Proposal/IGE.

Change and add disciplines as necessary Enter the Rates in the Type A Services Culumn Only. They will carry Thru to This Column.

Enter the Rates in the Type A Services Culumn Only. They will carry Thru to This Column.

Include Itemized Breakdown for any Costs not incluced in Overhead.

Include Itemized Breakdown for any Costs not incluced in Overhead.

Include Itemized Breakdown for any Costs not incluced in Overhead.

Include Itemized Breakdown for any Costs not incluced in Overhead.

Include Itemized Breakdown for any Travel Costs not incluced in Overhead.

Include Itemized Breakdown for any Travel Costs not incluced in Overhead.

Include Itemized Breakdown for any Travel Costs not incluced in Overhead.

Include Itemized Breakdown for any Travel Costs not incluced in Overhead.

Government Estimate Fee Proposal Initial Revised

Sub2

Architect-Engineer Worksheet
RFP/Project Number:Contract No:
Title:DO No:
Contractor:SUB 2Date:
Concept A ServicesDesign B ServicesInspection C Services
Services (In House)HoursRateTotalHoursRateTotalHoursRateTotal
Add individual desciplines$0.00$0.00$0.00$0.00$0.00
as they apply to each$0.00$0.00$0.00$0.00$0.00
project.$0.00$0.00$0.00$0.00$0.00
Insure the rates are$0.00$0.00$0.00$0.00$0.00
correct for the option$0.00$0.00$0.00$0.00$0.00
period you are in$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Subtotal$0.00Subtotal$0.00$0.00
Inspection Cost:Hours per day$ xDays =
$0.00
Subtotal$0.00
Direct Labor Overhead (%)$0.00$0.00$0.00
Gen & Admin. Overhead (%)0.00%$0.00$0.00$0.00
Materials & Supplies$0.00$0.00$0.00
Subtotal:$0.00Subtotal:$0.00Subtotal:$0.00
Other - Subcontractor / Consultants
Subtotal$0.00Subtotal$0.00Subtotal$0.00
Profit or Fee (%)10.00%$0.00$0.00$0.00
Travel Cost (per JTR)
Subtotal$0.00Subtotal$0.00Subtotal$0.00
Total for A, B & C$0.00

Check the appropriate block indicating whether this is the Proposal or the IGE Check the appropriate block indicating whether this is the Initial or Revised Proposal/IGE.

Change and add disciplines as necessary Add the rates in this column only - even if not using the discipline for Type A Services. The rate will carry through to the Type B and C columns.

Enter the Rates in the Type A Services Culumn Only. They will carry Thru to This Column.

Enter the Rates in the Type A Services Culumn Only. They will carry Thru to This Column.

Include Itemized Breakdown for any Costs not incluced in Overhead.

Include Itemized Breakdown for any Costs not incluced in Overhead.

Include Itemized Breakdown for any Costs not incluced in Overhead.

Include Itemized Breakdown for any Costs not incluced in Overhead.

Include Itemized Breakdown for any Travel Costs not incluced in Overhead.

Include Itemized Breakdown for any Travel Costs not incluced in Overhead.

Include Itemized Breakdown for any Travel Costs not incluced in Overhead.

Include Itemized Breakdown for any Travel Costs not incluced in Overhead.

Government Estimate Fee Proposal Initial Revised

Sub3

Architect-Engineer Worksheet
RFP/Project Number:Contract No:
Title:DO No:
Contractor:SUB 3Date:
Concept A ServicesDesign B ServicesInspection C Services
Services (In House)HoursRateTotalHoursRateTotalHoursRateTotal
Geologist$0.00$0.00$0.00$0.00$0.00
HAZMAT Inspector/Eng$0.00$0.00$0.00$0.00$0.00
Technician/HAZMAT$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Subtotal$0.00Subtotal$0.00$0.00
Inspection Cost:Hours per day$ xDays =
$0.00
Subtotal$0.00
Direct Labor Overhead (%)$0.00$0.00$0.00
Gen & Admin. Overhead (%)0.00%$0.00$0.00$0.00
Materials & Supplies$0.00$0.00
Subtotal:$0.00Subtotal:$0.00Subtotal:$0.00
Other - Subcontractor / Consultants
Subtotal$0.00Subtotal$0.00Subtotal$0.00
Profit or Fee (%)10.00%$0.00$0.00$0.00
Travel Cost (per JTR)
Subtotal$0.00Subtotal$0.00Subtotal$0.00
Total for A, B & C$0.00

Check the appropriate block indicating whether this is the Proposal or the IGE Check the appropriate block indicating whether this is the Initial or Revised Proposal/IGE.

Change and add disciplines as necessary Add the rates in this column only - even if not using the discipline for Type A Services. The rate will carry through to the Type B and C columns.

Enter the Rates in the Type A Services Culumn Only. They will carry Thru to This Column.

Enter the Rates in the Type A Services Culumn Only. They will carry Thru to This Column.

Include Itemized Breakdown for any Costs not incluced in Overhead.

Include Itemized Breakdown for any Costs not incluced in Overhead.

Include Itemized Breakdown for any Costs not incluced in Overhead.

Include Itemized Breakdown for any Costs not incluced in Overhead.

Include Itemized Breakdown for any Travel Costs not incluced in Overhead.

Include Itemized Breakdown for any Travel Costs not incluced in Overhead.

Include Itemized Breakdown for any Travel Costs not incluced in Overhead.

Include Itemized Breakdown for any Travel Costs not incluced in Overhead.

Government Estimate Fee Proposal Initial Revised

Sub4

Architect-Engineer Worksheet
RFP/Project Number:Contract No:
Title:DO No:
Contractor:Date:
Concept A ServicesDesign B ServicesInspection C Services
Services (In House)HoursRateTotalHoursRateTotalHoursRateTotal
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Subtotal$0.00Subtotal$0.00$0.00
Inspection Cost:Hours per day$ xDays =
$0.00
Subtotal$0.00
Direct Labor Overhead (%)$0.00$0.00$0.00
Gen & Admin. Overhead (%)0.00%$0.00$0.00$0.00
Materials & Supplies$0.00$0.00$0.00
Subtotal:$0.00Subtotal:$0.00Subtotal:$0.00
Other - Subcontractor / Consultants
Subtotal$0.00Subtotal$0.00Subtotal$0.00
Profit or Fee (%)10.00%$0.00$0.00$0.00
Travel Cost (per JTR)
Subtotal$0.00Subtotal$0.00Subtotal$0.00
Total for A, B & C$0.00

Check the appropriate block indicating whether this is the Proposal or the IGE Check the appropriate block indicating whether this is the Initial or Revised Proposal/IGE.

Change and add disciplines as necessary Add the rates in this column only - even if not using the discipline for Type A Services. The rate will carry through to the Type B and C columns.

Enter the Rates in the Type A Services Culumn Only. They will carry Thru to This Column.

Enter the Rates in the Type A Services Culumn Only. They will carry Thru to This Column.

Include Itemized Breakdown for any Costs not incluced in Overhead.

Include Itemized Breakdown for any Costs not incluced in Overhead.

Include Itemized Breakdown for any Costs not incluced in Overhead.

Include Itemized Breakdown for any Costs not incluced in Overhead.

Include Itemized Breakdown for any Travel Costs not incluced in Overhead.

Include Itemized Breakdown for any Travel Costs not incluced in Overhead.

Include Itemized Breakdown for any Travel Costs not incluced in Overhead.

Include Itemized Breakdown for any Travel Costs not incluced in Overhead.

Government Estimate Fee Proposal Initial Revised

Sub5

Architect-Engineer Worksheet
RFP/Project Number:Contract No:
Title:DO No:
Contractor:Date:
Concept A ServicesDesign B ServicesInspection C Services
Services (In House)HoursRateTotalHoursRateTotalHoursRateTotal
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Subtotal$0.00Subtotal$0.00$0.00
Inspection Cost:Hours per day$ xDays =
$0.00
Subtotal$0.00
Direct Labor Overhead (%)$0.00$0.00$0.00
Gen & Admin. Overhead (%)0.00%$0.00$0.00$0.00
Materials & Supplies$0.00$0.00$0.00
Subtotal:$0.00Subtotal:$0.00Subtotal:$0.00
Other - Subcontractor / Consultants
Subtotal$0.00Subtotal$0.00Subtotal$0.00
Profit or Fee (%)10.00%$0.00$0.00$0.00
Travel Cost (per JTR)
Subtotal$0.00Subtotal$0.00Subtotal$0.00
Total for A, B & C$0.00

Check the appropriate block indicating whether this is the Proposal or the IGE Check the appropriate block indicating whether this is the Initial or Revised Proposal/IGE.

Change and add disciplines as necessary Add the rates in this column only - even if not using the discipline for Type A Services. The rate will carry through to the Type B and C columns.

Enter the Rates in the Type A Services Culumn Only. They will carry Thru to This Column.

Enter the Rates in the Type A Services Culumn Only. They will carry Thru to This Column.

Include Itemized Breakdown for any Costs not incluced in Overhead.

Include Itemized Breakdown for any Costs not incluced in Overhead.

Include Itemized Breakdown for any Costs not incluced in Overhead.

Include Itemized Breakdown for any Costs not incluced in Overhead.

Include Itemized Breakdown for any Travel Costs not incluced in Overhead.

Include Itemized Breakdown for any Travel Costs not incluced in Overhead.

Include Itemized Breakdown for any Travel Costs not incluced in Overhead.

Include Itemized Breakdown for any Travel Costs not incluced in Overhead.

Government Estimate Fee Proposal Initial Revised

Cover Sheet

Section B
Supplies or Services and PricesContract No:0
DO/TO No:0
Title:0Date:31-Dec-99
ITEMDescriptionQTYUNITAMOUNTTOTAL
0001Concept (Type A / 35%)1SV$0.00$0.00
0002Design Services (Type B)
0002AAPre-Final (65%)1SV$0.00
0002ABFinal (incl. 100%)1SV$0.00
Subtotal:$0.00
Sub-Total "A" and "B" Services$0.00
0003Code and Criteria Review (Estimate that reviews will be conducted at 6-8 months intervals.)SV$0.00$0.00
0004Bid Reproduction1SV$0.00$0.00
0005Inspection Services (Type C)
0005AAProfessional Services1SV$0.00
0005ABOn-Site Inspection Services1NTE SVC$0.00
(Per__ Hr Day = $.00 X __ Days = SV)
Sub-Total "C" Services$0.00
TOTAL TYPE "A" THRU "C"$0.00
Name and TitleName of Firm or Government Agency
SignatureDate of Submission

Detail

ServicesProject ManagerSr. ArchitectCivil EngrStruct. EngrMech. EngrElectrical EngrCADDArch DrafterElect DrafterMech DrafterSpec WriterEstimator (see sub1)Typist
Concept (Type A svcs)
Site Investigation
As-built drawings
35% Drawings
Specfications
35% Cost Estimate
Review Meeting
Subtotal0000000000000
Design (Type B svcs)
65% Submittal drawings
100% Submittal drawings
Backcheck Submittal
65% spec's
100% spec's
Backcheck spec's
65% Cost Estimate
100% Cost Estimate
65% review meeting
100% review meeting
Subtotal0000000000000
Construction (Type C svcs)
Shop drawing review
RFI / Change order review
As-built drawings
Subtotal0000000000000

PHOENIX:

Total Project Mgr hours for C svcs included in Prime sheet

PHOENIX:

Total Project Mgr hours for B svcs included in Prime sheet

PHOENIX:

Total Project Mgr hours for A svcs included in Prime sheet

File details come from the government source that posted it. Updated .