Attachment_G_-_Pricing_Tables_-_A005.xlsx

52 KB Posted

Attached to
Physical Security Information Management
Solicitation number
SAQMMA14R0187
Issued by

About this file

From the source

Attachment G - Pricing Tables - A005

View the file

Other files

File Type Posted
Attachment_G2_-_AlarmNet_Optional_Task_Pricing_Tables_-_A005.xlsx XLSX spreadsheet
PSIM_RFP_-_SAQMMA14R0187_-_A005_Confomed_Copy_(4-10-15).docx DOCX document
PSIM_RFP_-_SAQMMA14R0187_-_A005_Track_Changes_(4-10-15).docx DOCX document
PSIM_SF-30_-_A005.pdf PDF
PSIM_RFP_-_SAQMMA14R0187_-_A004_-_Track_Changes.pdf PDF
PSIM_SF-30_-_A004.pdf PDF
PSIM_SF-33_A004.pdf PDF
PSIM_RFP_-_SAQMMA14R0187_-_A004_-_Conformed.pdf PDF
PSIM_RFP_Questions_and__Answers_SAQMMA14R0187_2.pdf PDF
PSIM_RFP_-_SAQMMA14R0187_-_A003_-_Conformed.pdf PDF
PSIM_RFP_-_SAQMMA14R0187_-_A003_-_Track_Changes.pdf PDF
PSIM_SF-30_A003.pdf PDF
Attachment_G2_-_AlarmNet_Optional_Task_Pricing_Tables_-_A003.xlsx XLSX spreadsheet
Attachment_G_-_Pricing_Tables_-_A003.xlsx XLSX spreadsheet
PSIM_SF-33_A003.pdf PDF
PSIM_RFP_Questions_and_Answers_-_SAQMMA14R0187.pdf PDF
SCAWD05-2103(Rev15).pdf PDF
Attachment_G_-_Pricing_Tables_-_A002.xlsx XLSX spreadsheet
PSIM_SF-33_A002.pdf PDF
PSIM_RFP_-_SAQMMA14R0187_-_A002_(Conformed).pdf PDF
PSIM_RFP_-_SAQMMA14R0187_-_A002_(Track_Changes).pdf PDF
PSIM_SF-30_A002.pdf PDF
Attachment_F_-_Past_Performance_Questionnaire_-_A002.docx DOCX document
A001.pdf PDF
PSIM_SF-33_A001.docx DOCX document
IVE_1-3.zip ZIP file
Texures_2_of_2.zip ZIP file
Attachment_D_-_Minimum_OpenNet_Extension_Requirements.docx DOCX document
OpenFlight.zip ZIP file
PSIM_RFP_-_SAQMMA14R0187.pdf PDF
Attachment_F_-_Past_Performance_Questionnaire.docx DOCX document
Attachment_C_-_Special_Definitions_MTTS.docx DOCX document
Attachment_B_-_Bidders_Form_DD-254.pdf PDF
Texures_1_of_2.zip ZIP file
PSIM_SF-33.docx DOCX document
Attachment_A_-_Acronyms_and_Abbreviations.docx DOCX document
Attachment_G_-_Pricing_Tables_1-8.xlsx XLSX spreadsheet
IVE_4-7.zip ZIP file
Show all 38

On GovTribe

Work with this file

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

Text version

The file's text, extracted by GovTribe without its formatting.

1. Compliance Checklist

Table 1Price Volume Compliance Checklist
RFP
ReferenceRequirementComply
(Yes/No)Proposal Reference
L.14.2.2 (1)The electronic price proposal shall consist of the following, which are described further in this subsection:

a. Narrative (in Word or PDF)

b. Pricing Tables 1-8 (in one folder containing one Excel workbook)

c. Detail Pricing Tables (in a second folder containing one or more Excel workbooks)

d. Supporting Information (in Word or PDF)

Offerors shall prepare on a CD-ROM one electronic file for each of the above sections. Therefore, offerors shall prepare four files on each CD-ROM.

L.14.2.2 (2) The hard-copy price proposal shall consist of the following, which are described further in this subsection:

a. Narrative

b. Pricing Tables 1-8

c. Detail Pricing Tables

d. Supporting Information

Offerors shall separate each of the above sections by a distinct tab and divider page.

L.14.2.2 (3)The content of the electronic price proposal and hard-copy price proposal shall match. If differences exist between the two proposals, the hard-copy proposal shall take precedence.
L.14.2.2 (4)Pricing Tables 1-8 are provided by the Government and shall be completed by the offerors. Detail Pricing Tables shall be created by the offeror and will be used to support the information provided in Pricing Tables 1-8.
L.14.2.2 (5)Offerors shall not add, delete, or otherwise alter the existing format or content in Pricing Tables 1-8. Offerors shall complete the required areas only.
L.14.2.2 (6)Offerors shall use for pricing purposes the following period of performance:

Base Period: June 1, 2015 through May 31, 2016 Option Period 1: June 1, 2016 through May 31, 2017 Option Period 2: June 1, 2017 through May 31, 2018 Option Period 3: June 1, 2018 through May 31, 2019 Option Period 4: June 1, 2019 through May 31, 2020

Option Period 5: June 1, 2020 through May 31, 2021
Option Period 6: June 1, 2021 through May 31, 2022
Option Period 7: June 1, 2022 through May 31, 2023
Option Period 8: June 1, 2023 through May 31, 2024
Option Period 9: June 1, 2024 through May 31, 2025
L.14.2.2 (7)In Pricing Table 1, offerors shall complete the “Comply (Yes/No)” and “Proposal Reference” columns.
L.14.2.2 (8)In Pricing Table 2, offerors shall identify their most current indirect cost rates that would be used as the proposed provisional billing rates. If applicable, these indirect cost rates should be reflected in the most current indirect cost rate agreement that has been negotiated between the Offeror and its cognizant Federal agency official (CFAO).
L.14.2.2 (9)In Pricing Table 2, the proposed provisional billing indirect cost rates shall not exceed the ceiling indirect cost rates proposed in Pricing Table 3.
L.14.2.2 (10)In Pricing Tables 2 and 3, offerors shall propose only their own indirect cost rates. Indirect cost rates for subcontractors and/or other entities not proposed as the offeror shall not be included in part or in whole.
L.14.2.2 (11)In Pricing Tables 2 and 3, offerors shall add or delete rows as necessary. The number (e.g., “1)”) in the “Indirect Cost Rate Description” column signifies a specific indirect cost rate description. For example, an offeror may elect to propose “Fringe Benefits” next to “1)”, “Overhead” next to “2)”, and “G&A” next to “3).”
L.14.2.2 (12)In Pricing Tables 2 and 3, each row will apply to a different Contractor Fiscal Year Period, which offerors shall identify with month, day, and year in the right-most column.
L.14.2.2 (13)In Pricing Tables 2 and 3, offerors shall propose a Contractor Fiscal Year Period for each of its fiscal years through the life of the contract. Offerors shall assume that the life of the contract, including any extension, is June 1, 2015 through May 31, 2020.
L.14.2.2 (14)In Pricing Tables 2 and 3, Facilities Capital Cost of Money (FCCOM) factors shall be separately identified IF the offeror allocates FCCOM costs as part of its established cost accounting practices.
L.14.2.2 (15)In Pricing Table 4, offerors shall propose one profit percentage per contract period.
L.14.2.2 (16)In Pricing Table 4, the proposed profit percentages shall not exceed two decimal places.
L.14.2.2 (17)In Pricing Table 5, offerors shall propose one not-to-exceed (NTE) fully-loaded hourly labor rate per labor category/Sub-CLIN per period, regardless of which entity (offeror, subcontractor offeror, or other) is anticipated to perform the labor category.
L.14.2.2 (18)In Pricing Table 5, each proposed NTE fully-loaded hourly labor rate shall consist of a proposed unloaded hourly rate, any labor-related direct costs (e.g., fringe benefits, bonuses), applicable indirect costs, and profit. It shall not consist of any other costs, including other compensation like post hardship differential pay and danger pay.
L.14.2.2 (19)In Pricing Table 5, the proposed NTE fully-loaded hourly labor rates shall apply only to individuals who have legal status to work in the United States of America (e.g., United States citizens, United States resident aliens, and individuals with permits showing authorization to work in the United States).
L.14.2.2 (20)In Pricing Table 5, the proposed NTE fully-loaded hourly labor rates shall not exceed two decimal places
L.14.2.2 (21)In Pricing Table 5, offerors shall identify under “Proposed” all internal labor categories that do not meet the labor category descriptions in Section H.9, and are intended to be used during contract performance. Offerors shall also propose the associate NTE fully-loaded hourly labor rates. If an Offeror submits labor categories aside from those that are RFP-specified, the Offeror is responsible for ensuring that the calculations are included in the Subtotal, Total, and Grand Total prices.
L.14.2.2 (22)In Pricing Table 6, the Government provided formulas to calculate automatically each proposed subtotal under the two labor sections. Each formula is “Positions Per Year” multiplied by “NTE Rate” multiplied by “Hours.” However, offerors shall verify the arithmetic accuracy and make any necessary corrections.
L.14.2.2 (23)In Pricing Table 6, the estimated indirect cost in the “Ind $” column shall reflect the product of the applicable proposed ceiling indirect cost rate(s) proposed in Pricing Table 3 and the RFP-specified estimated direct travel cost.
L.14.2.2 (24)In Pricing Table 6, the Government provided formulas to calculate automatically the proposed Subtotal, Total, and Overall Proposed Price. However, offerors shall verify the arithmetic accuracy and make any necessary corrections.
L.14.2.2 (25)In Pricing Table 6, the proposed Subtotal, Total, and Overall Proposed Price shall be in whole numbers (i.e., no decimals).
L.14.2.2 (26)In Pricing Table 6, in order that the Government fosters a fair competition, offerors shall not add any labor categories or associated NTE rates identified under “Proposed” in Pricing Table 5 or 7.
L.14.2.2(27)In Pricing Table 7, offerors shall propose one NTE fully-loaded hourly labor rate per period for each labor category (RFP-specified and otherwise) proposed to be performed only by employees not exempt under the Fair Labor Standards Act. This NTE fully-loaded hourly labor rate is regardless of which entity (offeror, subcontractor offeror, or other) is anticipated to perform the labor category.
L.14.2.2 (28)In Pricing Table 7, each proposed NTE fully-loaded hourly labor rate shall consist of a proposed unloaded hourly rate, overtime premium, any labor-related direct costs (e.g., fringe benefits, bonuses), applicable indirect costs, and profit. It shall not consist of any other costs, including other compensation like post hardship differential pay and danger pay (See Section B.8).
L.14.2.2 (29)In Pricing Table 7, the proposed NTE fully-loaded hourly labor rates shall apply only to individuals who have legal status to work in the United States of America (e.g., U.S. citizens, U.S. resident aliens, and individuals with permits showing authorization to work in the United States).
L.14.2.2 (30)In Pricing Table 7, the proposed NTE fully-loaded hourly labor rates shall be listed in the “Rate” column.
L.14.2.2 (31)In Pricing Table 7, the overtime premium included in each proposed NTE fully-loaded hourly labor rate shall be listed in the “Premium” column.
L.14.2.2 (32)In Pricing Table 7, the overtime premium listed in the “Premium” column shall include any indirect costs and profit associated with such premium, and which were included in the proposed NTE fully-loaded hourly labor rate listed in the “Rate” column.
L.14.2.2 (33)In Pricing Table 7, the proposed NTE fully-loaded hourly labor rates and premium costs shall not exceed two decimal places.
L.14.2.2 (34)In Pricing Table 7, offerors shall identify under “Proposed” all internal labor categories that do not meet the RFP-specified labor category descriptions and are intended to be used during contract performance. Offerors shall also propose the associated NTE fully-loaded hourly labor rates.
L.14.2.2 (35)In Pricing Table 8, offerors shall propose their partial delivery payment schedule for CLIN X002 (PSIM Software)
L.14.2.2 (36)In the Detail Pricing Tables (for Pricing Tables 5 and 7), offerors shall show for each performance period the build-up of each NTE fully-loaded hourly labor rate proposed in Pricing Tables 5 and 7 (Note: At this time, the Government does not require submission of subcontractor offerors' build-up of their proposed negotiated fully-loaded hourly labor rates, or breakdown of subcontractor offerors' proposed or negotiated unit prices). Offerors shall identify on the build-up schedule:

a. Each RFP-specified labor category

b. Each internal labor category corresponding to RFP-specified labor category (if applicable)

c. Each internal labor category not corresponding to RFP-specified labor category ("Proposed" category) (if applicable)

d. Identification of whether the proposed fixed fully-loaded hourly labor rate applies to labor performed by a service employee (as defined in FAR 22.001) or by a professional employee (as defined in 29 CFR 541)

e. Identification of whether the proposed NTE fully-loaded hourly labor rate applies to labor performed by : 1) the offeror; 2) subcontractor offeror(s); and/or 3) divisions, subsidiaries, or affiliates of teh offeror under a common control

f. Proposed unloaded hourly labor rate g. Each proposed labor-related direct cost description (if applicable) (e.g., fringe, benefits, bonuses) h. Each proposed labor-related direct cost (if applicable) i. Each proposed indirect cost rate description (e.g., Overhead, G&A) j. Each proposed indirect cost rate k. Each proposed indirect cost l. Proposed profit percentage m. Proposed profit dollar amount n. Proposed NTE fully-loaded hourly labor rate Offerors shall prepare on a CD-ROM one electronic file for each of the above sections. Therefore, offerors shall prepare four files on each CD-ROM.

L.14.2.2 (37)In the Detail Pricing Tables (for Pricing Tables 5 and 7), each proposed profit percentage used in the build-up of each fixed fully-loaded hourly labor rate proposed in Pricing Tables 5 and 7 shall match the respective profit percentage proposed in Pricing Table 4.
L.14.2.2 (38)In the Detail Pricing Tables (for Pricing Tables 5 and 7) (in electronic submission only), offerors shall show with formulas the arithmetic process by which they calculated their proposed NTE fully-loaded hourly labor rates in Pricing Tables 5 and 7.
L.14.2.2 (39)In the Detail Pricing Tables (for Pricing Table 6) (in electronic submission only), offerors shall show with formulas the arithmetic process by which they calculated their estimated indirect costs and subtotal for travel.
L.14.2.2 (40)In Pricing Tables 1-8 and the Detail Pricing Tables, offerors shall complete all applicable data cells.
L.14.2.2 (41)In Pricing Tables 1-8 and the Detail Pricing Tables (in electronic submission only), offerors shall not hide or lock any rows, columns, or cells that contain proposed data.
L.14.2.2 (42)In Pricing Tables 1-8 and the Detail Pricing Tables, offerors shall propose all rates, costs, and prices in United States currency.
L.14.2.2 (43)In the Narrative, offerors shall identify, for each labor category, the basis of estimate of the proposed unloaded hourly labor rates. Examples are actual salary, market survey(s), and letter of intent to hire.
L.14.2.2 (44)In the Narrative, offerors shall identify, based on Pricing Table 6, their:

a. proposed subcontractors;

b. total dollars estimated to be subcontracted to each proposed subcontractor;

c. total dollars estimated to be performed by the offeror; and

d. percentage of work (based on estimated total dollars) to be performed by the offeror and each proposed subcontractor.

L.14.2.2 (45)In the Narrative, offerors shall identify the name and full contact information of their cognizant Federal auditor (e.g., local Defense Contract Audit Agency branch).
L.14.2.2 (46)In the Narrative, offerors shall identify the name and fully contact information of their cognizant Federal agency official (CFAO). The CFAO works in the offeror’s cognizant Federal agency, which is normally the agency with which the offeror has the largest dollars in negotiated contracts, including option periods. See FAR 42.003.
L.14.2.2 (47)In the Supporting Information, offerors shall submit evidence to support the proposed provisional billing indirect cost rates in Pricing Table 2. Offerors shall submit such at least one of the following pieces of evidence pursuant to the following order of preference:

a. Current negotiated indirect cost rate agreement with the offeror’s cognizant Federal agency official

b. Current forward pricing rate recommendation issued by the offeror’s cognizant Federal agency official

c. Most recent (within the last two years) audit report from the Defense Contract Audit Agency (DCAA) or other qualified external auditor

d. Most recent (within the last two years) audit report from a qualified internal auditor

e. Current indirect cost rate proposal submitted to the offeror’s cognizant Federal agency official and cognizant auditor

f. Identification of the indirect cost pools and respective allocation bases, and breakdown of the cost elements/costs comprising such pools and bases. The Government prefers that the offeror submit such evidence in a format similar to the applicable schedules in Enclosure 6 (Incurred Cost Proposals) of DCAA’s Information for Contractors, which may be found on DCAA’s Web site (www.dcaa.mil) under the “Audit Process Overview” link under the "Guidance" tab at the top of the homepage.

L.14.2.2 (48) In the Supporting Information, offerors, in accordance with FAR 15.404-3(b) (Subcontract Pricing Considerations), shall conduct appropriate cost or price analyses to establish the reasonableness of proposed subcontract prices, and shall include the results of these analyses.

a. Results shall be in the form of the cost/price analysis report(s), which shall include:

1. cost/price analysis technique(s) used (e.g., comparison of proposed prices received in response to the solicitation);

2. summary findings;

3. detailed findings; and

4. basis for the determination of fair and reasonable proposed subcontract prices.

&"Times New Roman,Regular"&12

2. Provisional Billing Rates

Pricing Table 2Proposed Provisional Billing Indirect Cost Rates
Indirect Cost Rate Description (e.g., Fringe Benefits, Overhead, G&A)Proposed Provisional Billing RateBasis of Estimate of Proposed Provisional Billing Rate
(e.g., Negotiated Indirect Cost Rate Agreement with Cognizant FAO)Allocation Base
(e.g., Direct Labor Dollars, Total Cost Input)Contractor Fiscal Year Period

(e.g., January 1, 2012 - December 31, 2012) 1)

2)

THE FOLLOWING IS FOR ILLUSTRATION PURPOSES ONLY:

Indirect Cost Rate DescriptionProposed Provisional Billing RateBasis of Estimate of Proposed Provisional Billing RateAllocation Base
Contractor Fiscal Year Period

1) G&A 6.29% March 15, 2014 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Cost Input January 1, 2014 - December 31, 2014 G&A 6.27% March 15, 2014 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Cost Input January 1, 2015 - December 31, 2015 G&A 6.25% March 15, 2014 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Cost Input January 1, 2016 - December 31, 2016 G&A 6.00% March 15, 2014 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Cost Input January 1, 2017 - December 31, 2017 G&A 5.95% March 15, 2014 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Cost Input January 1, 2018 - December 31, 2018 G&A 5.80% March 15, 2014 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Cost Input January 1, 2019 - December 31, 2019 G&A 5.80% March 15, 2014 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Cost Input January 1, 2020 - December 31, 2020

3. Ceiling Indirect Cost Rates Pricing Table 3 Proposed Ceiling Indirect Cost Rates

Indirect Cost Rate Description (e.g., Fringe Benefits, Overhead, G&A)Proposed Ceiling Indirect Cost RateBasis of Estimate of Proposed Ceiling Indirect Cost Rate
(e.g., Negotiated Indirect Cost Rate Agreement with Cognizant FAO)Allocation Base
(e.g., Direct Labor Dollars, Total Cost Input)Contractor Fiscal Year Period

(e.g., January 1, 2012 - December 31, 2012) 1)

2)

THE FOLLOWING IS FOR ILLUSTRATION PURPOSES ONLY:

Indirect Cost Rate DescriptionProposed Provisional Billing RateBasis of Estimate of Proposed Provisional Billing RateAllocation Base
Contractor Fiscal Year Period

1) G&A 6.29% March 15, 2014 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Cost Input January 1, 2014 - December 31, 2014 G&A 6.27% March 15, 2014 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Cost Input January 1, 2015 - December 31, 2015 G&A 6.25% March 15, 2014 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Cost Input January 1, 2016 - December 31, 2016 G&A 6.00% March 15, 2014 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Cost Input January 1, 2017 - December 31, 2017 G&A 5.95% March 15, 2014 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Cost Input January 1, 2018 - December 31, 2018 G&A 5.80% March 15, 2014 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Cost Input January 1, 2019 - December 31, 2019 G&A 5.80% March 15, 2014 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Cost Input January 1, 2020 - December 31, 2020

4. Profit and Fee Percentages Pricing Table 4 Proposed Profit Percentages

Proposed Profit Percentages

Base Period Option Period 1 Option Period 2 Option Period 3 Option Period 4 Option Period 5 Option Period 6 Option Period 7 Option Period 8 Option Period 9

5. NTE Labor Rates Pricing Table 5 Proposed Fixed Fully-loaded Hourly Labor Rates (in US Currency)

Base YearOption Year 1Option Year 2Option Year 3Option Year 4Option Year 5Option Year 6Option Year 7Option Year 8Option Year 9
Sub-Positions
CLINLabor CategoryPer YearFixed RateHoursSubtotalFixed RateHoursSubtotalFixed RateHoursSubtotalFixed RateHoursSubtotalFixed RateHoursSubtotalFixed RateHoursSubtotalFixed RateHoursSubtotalFixed RateHoursSubtotalFixed RateHoursSubtotalFixed RateHoursSubtotal

RFP-specified

X003ASoftware Engineer/Integrator III (Senior)(To be proposed)1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!
X003BSoftware Engineer/Integrator II (Mid-Level)(To be proposed)1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!
X003CSoftware Engineer/Integrator (Junior)(To be proposed)1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!
X003DQuality Control Specialist(To be proposed)1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!
X003E3-D Modeler(To be proposed)1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!
X003FTechnical Writer(To be proposed)1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!
X003GLead Applications Engineer(To be proposed)1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!
X003HApplications Developer(To be proposed)1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!
X003IApplication System Analyst(To be proposed)1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!
X003JConfiguration Management Specialist(To be proposed)1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!
X003KData Architect(To be proposed)1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!
X003LData Warehousing Specialist(To be proposed)1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!
X003MDatabase Specialist(To be proposed)1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!
X003NGeographic Information System (GIS) Analyst/Programmer(To be proposed)1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!
X003OInformation Assurance/Security Specialist(To be proposed)1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!
X003PTest Engineer(To be proposed)1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!
X003QSenior Graphic Designer(To be proposed)1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!
X004ATraining Specialist(To be proposed)1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!1,880ERROR:#VALUE!

Proposed

TOTAL (x003)ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
TOTAL (x004)ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Notes
Positions Per Year = RFP-specified estimated positions per year
Fixed Rate = Proposed fixed fully-loaded hourly labor rate
Hours = RFP-specified estimated productive hours
Subtotal = Positions Per Year x Fixed Rate x Hours
Total = Sum of Subtotal prices
Grand Total = Sum of Total prices
1) The proposed fixed fully-loaded hourly labor rates shall be based on a normal workweek of 40 hours. A normal workweek is defined in FAR 22.103-1 (Overtime).
2) The proposed fixed fully-loaded hourly labor rates shall not exceed two decimal places and shall be in United States currency.
3) The Government provided formulas to calculate automatically the proposed Subtotal, Total, and Grand Total prices. However, offerors shall verify the arithmetic accuracy. If an offeror submits labor categories aside from those that are RFP-specified, the offeror is responsible for ensuring that the calculations are included in the Subtotal, Total, and Grand Total prices.
and make any necessary corrections.
4) The proposed Subtotal, Total, and Grand Total prices shall be in whole numbers; they shall not contain decimals.
5) The RFP-specified estimated productive hours were arbitrarily selected based on 2,080 annual hours (40 hours/week x 52 weeks/year) minus 200 non-productive (vacation, sick, holidays) hours.
6) The Government does not commit to usage of the RFP-specified estimated positions per year or productive hours. These positions and hours are being used for
price evaluation purposes for award of the contract.
7) The Government provided formulas to transfer automatically the proposed Total prices in row 31 to the respective applicable cells under CLIN X003 and X004 in Pricing Table 6.

6. Prices Pricing Table 6 Proposed Prices (in US Dollars)

Base Year Option Year 1 Option Year 2 Option Year 3 Option Year 4 Option Year 5 Option Year 6 Option Year 7 Option Year 8 Option Year 9

CLIN Description Cont Type RFP Cost Ce Rate(s) Ind $ Subtotal RFP Cost Ce Rate(s) Ind $ Subtotal RFP Cost Ce Rate(s) Ind $ Subtotal RFP Cost Ce Rate(s) Ind $ Subtotal RFP Cost Ce Rate(s) Ind $ Subtotal RFP Cost Ce Rate(s) Ind $ Subtotal RFP Cost Ce Rate(s) Ind $ Subtotal RFP Cost Ce Rate(s) Ind $ Subtotal RFP Cost Ce Rate(s) Ind $ Subtotal RFP Cost Ce Rate(s) Ind $ Subtotal TOTAL

X001Program ManagementFFP0
X002APSIM SoftwareFFP0
X002BPSIM MaintenanceFFP0
X003Model Creation and EngineeringTimeERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
X004PSIM Training (Instructor Led)TimeERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
X005Other Direct CostsMat1,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,00010,000,000

TOTAL ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!

GRAND TOTAL ERROR:#VALUE!

Notes
Cont Type = Contract type
FFP = Firm-fixed-price
Time = Time portion of time-and-materials
Mat. = Materials portion of time-and-materials
RFP Cost = RFP-specified estimated cost
Ce Rate(s) = Proposed applicable ceiling indirect cost rate(s) applied to RFP Cost
Ind $ = Proposed indirect cost after multiplying applicable proposed ceiling indirect cost rate(s) by RFP Cost
Subtotal (FFP) = Proposed firm-fixed-price
Total = Sum of Subtotal prices
Grand Total = Sum of Total prices

7. NTE Overtime Labor Rates Pricing Table 7 Proposed Not-To-Exceed (NTE) Fully-Loaded Hourly Labor Rates for Overtime Performance

Base Period Option Period 1 Option Period 2 Option Period 3 Option Period 4 Option Period 5 Option Period 6 Option Period 7 Option Period 8 Option Period 9

RatePremiumRatePremiumRatePremiumRatePremiumRatePremiumRatePremiumRatePremiumRatePremiumRatePremiumRatePremium
CLINLabor Category

RFP-specified

Proposed

Notes
Rate = Proposed NTE fully-loaded hourly overtime labor rate based on overtime performance under a 40-hour normal workweek.
Premium = Portion of proposed NTE fully-loaded hourly overtime rate attributable to the overtime premium (includes associated indirect costs and profit).

8. Partial Delivery Payments Pricing Table 8 Partial Delivery Payments

CLIN X002A: PSIM Software

Partial Delivery Payment Dollar Amount Percentage of Total

1$%
2$%
3$%
4$%
TOTAL$0.00100%

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