RFP_Exhibit_A_-_Price_Schedule.xlsx

41 KB Posted

Attached to
Analytical Support for the Office of People Analytics
Solicitation number
ID09180048
Issued by

About this file

From the source

RFP Exhibit A

View the file

Other files

File Type Posted
RFP_ID09180048_Q&A_Revision_2.pdf PDF
RFP_Attachment_3_-_Contract_PWS_Amendment_0002.pdf PDF
RFP_ID09180048_Q&A_Revision.pdf PDF
RFP_ID09180048_Amendment_0002_(SF30).pdf PDF
RFP_Attachment_5_-_Sample_Task_Order_A_PWS_Amendment_0001.pdf PDF
RFP_Attachment_7_-_Sample_Task_Order_C_PWS_Amendment_0001.pdf PDF
RFP_Attachment_4_-_Task_Order_0001_PWS_Amendment_0001.pdf PDF
RFP_Attachment_6_-_Sample_Task_Order_B_PWS_Amendment_0001.pdf PDF
RFP_ID09180048_Amendment_0001_(SF30).pdf PDF
RFP_Attachment_3_-_Contract_PWS_Amendment_0001.pdf PDF
RFP_ID09180048_Q&A.pdf PDF
RFP_Attachment_1_-_Small_Business_Participation_Information_Sheet.docx DOCX document
RFP_Attachment_5_-_Sample_Task_Order_A_PWS.pdf PDF
RFP_Attachment_6-_Sample_Task_Order_B_PWS.pdf PDF
RFP_Attachment_2_-_Reference_Information_Sheet.docx DOCX document
RFP_Attachment_7_-_Sample_Task_Order_C_PWS.pdf PDF
RFP_Attachment_8_-_QASP.pdf PDF
RFP_Attachment_4_-_Task_Order_0001_PWS.pdf PDF
RFP_Attachment_3_-_Contract_PWS.pdf PDF
RFP_ID09180048.pdf PDF
DRAFT_PWS.pdf PDF
Show all 21

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.

Instructions

ID09180048 RFP Exhibit A - INSTRUCTIONS
General Instructions:
1Insert Offeror Name
2Fill out all applicable yellow highlighted cells on all tabs of this Excel workbook.
3Include all applicable prices and costs for the IDIQ contract on the Price Input Tab, including both prime and suboffer (subcontract) amounts. Task order pricing shall go on the task order tabs.
4Ensure all formulas are functional and intact on the proposal submission.
Price Input Tab Instructions:
1Column C - If offeror nomenclature differs from Government provided labor category name, add offeror's equivalent name for each Government provided labor category. Otherwise, leave blank.
2Column D - Note if information in this row will be for the prime contractor or a subcontractor. Provide subcontractor name if applicable.
3Columns F, J, N, R, V - Enter one fully burdened labor rate for each Government site and offsite labor category. Provide labor rates that are fair, reasonable, and realistic for the work to be accomplished in the PWS.
4If proposing to add indirect burdens to the Government's travel or other direct cost estimate, provide a description of the burden type, applicable rate, and amount for each type of indirect burden in the price narrative, not in this spreadsheet.
5Enter any escalation rate used or applied to develop option year labor rates in row 35.
6Do not edit labor hours per labor category, total labor hours, or total travel or other direct costs. These are provided for proposal consistency purposes and to help develop realistic maximum IDIQ contract amounts.
Subcontracts Tab Instructions:
1If applicable, provide detail related to subcontract pricing amounts for the IDIQ contract on the Subcontracts tab. If proposing no subcontracts, leave blank.
2Include only subcontract prices and costs that are also included on the Price Input Tab. (See General Instructions #3 Above)
3Small business subcontract amounts shall support information proposed in the Small Business Participation Information Sheet and Small Business Subcontracting Plan (if large business concern)
Contract Price Summary Tab Instructions:
1Table should fill in automatically if all data is inserted properly in the price input tab. Ensure formulas are correct and the chart accurately fills in all blanks and reflects proposed prices.
Task Order 0001 and Sample Task Order A, B, and C Price Tab Instructions
1Fill in applicable direct labor hours and fully burdened hourly labor rates for each labor category proposed for the task order. If a labor category is not used, leave rate and hour information blank.
2Fill in any applicable other direct costs and travel information and show any applicable indirect burdens on cost and note their application. No fee is allowed on ODC or travel.
3Ensure totals for Labor hours, labor price, other direct costs, travel, as well as overall total price is accurate.
Task Order 0001 and Sample Task Order A, B, and C Backup Tab Instructions
1Include a description of each other direct cost item proposed for the task order with any applicable quantities and unit price amounts.
2Include a summary of any proposed travel costs to include identification of number of travelers, destination, duration, and price for each trip.
3If no ODC or travel is proposed, leave blank.

Price Input

Base Year (July 2018-July 2019)Option 1 - (July 2019-July 2020)Option 2 - (July 2020 - July 2021)Option 3 - (July 2021 - July 2022)Option 4 - (July 2022 - July 2023)Contract Total
Labor Category (LCAT) - Government SiteProvide offeror's equivalent LCAT name (if different than LCAT Name in Column B, otherwise leave blank)Indicate if labor proposed is from prime or subofferor (sub) (If sub, also include name of sub)Estimated Labor HoursFully Burdened Labor RateBase TotalEstimated Labor HoursFully Burdened Labor RateOY1 TotalEstimated Labor HoursFully Burdened Labor RateOY2 TotalEstimated Labor HoursFully Burdened Labor RateOY3 TotalEstimated Labor HoursFully Burdened Labor RateOY4 Total
Subject Matter Expert 1666$0.00572$0.00612$0.00652$0.00652$0.00
Project Manager1,536$0.001,536$0.001,536$0.001,536$0.001,536$0.00
Consultant3,516$0.003,074$0.003,074$0.003,074$0.003,074$0.00
Project Leader2,128$0.001,600$0.001,680$0.001,680$0.001,760$0.00
Project Coordinator15,650$0.0013,398$0.0013,878$0.0013,478$0.0013,878$0.00
Senior Associate19,032$0.0015,032$0.0015,512$0.0016,568$0.0017,048$0.00
Associate22,636$0.0019,158$0.0020,158$0.0021,318$0.0021,558$0.00
Analyst30,720$0.0025,948$0.0025,054$0.0026,452$0.0027,572$0.00
Research Analyst8,912$0.006,400$0.006,276$0.006,504$0.006,824$0.00
Data Collection Manager12,288$0.008,448$0.008,448$0.008,448$0.008,448$0.00
Labor Category - Offsite
Subject Matter Expert 1166$0.00144$0.00154$0.00164$0.00164$0.00
Project Manager384$0.00384$0.00384$0.00384$0.00384$0.00
Consultant880$0.00766$0.00766$0.00766$0.00766$0.00
Project Leader532$0.00400$0.00420$0.00420$0.00440$0.00
Project Coordinator3,912$0.003,350$0.003,470$0.003,370$0.003,470$0.00
Senior Associate4,758$0.003,758$0.003,878$0.004,142$0.004,262$0.00
Associate5,660$0.004,790$0.005,040$0.005,330$0.005,390$0.00
Analyst7,680$0.006,488$0.006,262$0.006,612$0.006,892$0.00
Research Analyst2,228$0.001,600$0.001,570$0.001,626$0.001,706$0.00
Data Collection Manager3,072$0.002,112$0.002,112$0.002,112$0.002,112$0.00
Total Labor Hours146,356118,958120,284124,636127,936638,170
Total Labor Price$0.00$0.00$0.00$0.00$0.00$0.00

Total Travel Costs $210,000.00 $292,000.00 $216,000.00 $220,000.00 $270,000.00 $1,208,000.00

Total Other Direct Costs $5,000.00 $5,150.00 $5,304.50 $5,463.64 $5,627.54 $26,545.68

TotalsTotal Base Year$215,000.00Total OY 1$297,150.00Total OY 2$221,304.50Total OY 3$225,463.64Total OY 4$275,627.54$1,234,545.68Grand Total
Indicate Any Escalation Rate Applied to labor rates from one year to the next in this row as a percentage (example: 2.00%)Esc rate for OP1Esc rate for OP2Esc rate for OP3Esc rate for OP4

Subcontracts

Subcontractor NameBase Period AmountOption Year 1 AmountOption Year 2 AmountOption Year 3 AmountOption Year 4 AmountTotal Amount
Subcontract 1Labor$0.00
Other Direct Costs$0.00
Total Subcontract$0.00
Subcontract 2Labor$0.00
Other Direct Costs$0.00
Total Subcontract$0.00
Subcontract 3Labor$0.00
Other Direct Costs$0.00
Total Subcontract$0.00
(Offerors may add or subtract rows as necessary to enter all subcontract pricing information)

Contract Price Summary

Contract PeriodCLINDescriptionPrice
Base Year0001Services in accordance with PWS$ - 0
0002Travel$ 210,000.00
0003Other Direct Costs$ 5,000.00
Option Year 11001Services in accordance with PWS$ - 0
1002Travel$ 292,000.00
1003Other Direct Costs$ 5,150.00
Option Year 22001Services in accordance with PWS$ - 0
2002Travel$ 216,000.00
2003Other Direct Costs$ 5,304.50
Option Year 33001Services in accordance with PWS$ - 0
3002Travel$ 220,000.00
3003Other Direct Costs$ 5,463.64
Option Year 44001Services in accordance with PWS$ - 0
4002Travel$ 270,000.00
4003Other Direct Costs$ 5,627.54
TOTAL PROPOSED PRICE$ 1,234,545.68

Task Order 0001 Price

Labor Category (LCAT) - Government SiteLabor HoursFully Burdened Labor RateTotal
Subject Matter Expert 1$ - 0
Project Manager$ - 0
Consultant$ - 0
Project Leader$ - 0
Project Coordinator$ - 0
Senior Associate$ - 0
Associate$ - 0
Analyst$ - 0
Research Analyst$ - 0
Data Collection Manager$ - 0
Labor Category - Offsite
Subject Matter Expert 1$ - 0
Project Manager$ - 0
Consultant$ - 0
Project Leader$ - 0
Project Coordinator$ - 0
Senior Associate$ - 0
Associate$ - 0
Analyst$ - 0
Research Analyst$ - 0
Data Collection Manager$ - 0
Total Labor Hours0
Total Labor Price (CLIN 0001)$ - 0
Direct Travel Costs (if applicable)
Indirect burdens (if Applicable:)
Total Travel Costs (CLIN 0002)$ - 0
Other Direct Costs excluding travel (if applicable)
Indirect burdens (if Applicable:)

Total Other Direct Costs excluding travel (CLIN 0003) $ - 0

Total Price for Task Order $ - 0

Task Order 0001 Backup If proposed, provide quantity and description and unit prices of any ODCs and travel related to Sample Task A here:

Sample Task A Price

Contract Type and CLINLabor Category (LCAT) - Government SiteLabor HoursFully Burdened Labor RateTotal
Subject Matter Expert 1$ - 0
Project Manager$ - 0
Consultant$ - 0
Project Leader$ - 0
Project Coordinator$ - 0
Senior Associate$ - 0
Associate$ - 0
Analyst$ - 0
Research Analyst$ - 0
Data Collection Manager$ - 0
Labor Category - Offsite
Subject Matter Expert 1$ - 0
Project Manager$ - 0
Consultant$ - 0
Project Leader$ - 0
Project Coordinator$ - 0
Senior Associate$ - 0
Associate$ - 0
Analyst$ - 0
Research Analyst$ - 0
Data Collection Manager$ - 0
Total Labor Hours0
FFP - CLIN 0001Total Labor Price$ - 0
Direct Travel Costs (if applicable)
Indirect burdens (if applicable:)
CR - CLIN 0002Total Travel Costs (if applicable)$ - 0
Other Direct Costs excluding travel (if applicable)
Indirect burdens (if applicable:)

CR - CLIN 0003 Total Other Direct Costs excluding travel (if applicable) $ - 0

Total Price for Task Order $ - 0

Sample Task A Backup If proposed, provide quantity and description and unit prices of any ODCs and travel related to Sample Task A here:

Sample Task B Price

Contract Type and CLINLabor Category (LCAT) - Government SiteLabor HoursFully Burdened Labor RateTotal
Subject Matter Expert 1$ - 0
Project Manager$ - 0
Consultant$ - 0
Project Leader$ - 0
Project Coordinator$ - 0
Senior Associate$ - 0
Associate$ - 0
Analyst$ - 0
Research Analyst$ - 0
Data Collection Manager$ - 0
Labor Category - Offsite
Subject Matter Expert 1$ - 0
Project Manager$ - 0
Consultant$ - 0
Project Leader$ - 0
Project Coordinator$ - 0
Senior Associate$ - 0
Associate$ - 0
Analyst$ - 0
Research Analyst$ - 0
Data Collection Manager$ - 0
Total Labor Hours0
FFP - CLIN 0001Total Labor Price$ - 0
Direct Travel Costs (if applicable)
Indirect burdens (if applicable:)
CR - CLIN 0002Total Travel Costs (if applicable)$ - 0
Other Direct Costs excluding travel (if applicable)
Indirect burdens (if applicable:)

CR - CLIN 0003 Total Other Direct Costs excluding travel (if applicable) $ - 0

Total Price for Task Order $ - 0

Sample Task B Backup If proposed, provide quantity and description and unit prices of any ODCs and travel related to Sample Task B here:

Sample Task C Price

Contract Type and CLINLabor Category (LCAT) - Government SiteLabor HoursFully Burdened Labor RateTotal
Subject Matter Expert 1$ - 0
Project Manager$ - 0
Consultant$ - 0
Project Leader$ - 0
Project Coordinator$ - 0
Senior Associate$ - 0
Associate$ - 0
Analyst$ - 0
Research Analyst$ - 0
Data Collection Manager$ - 0
Labor Category - Offsite
Subject Matter Expert 1$ - 0
Project Manager$ - 0
Consultant$ - 0
Project Leader$ - 0
Project Coordinator$ - 0
Senior Associate$ - 0
Associate$ - 0
Analyst$ - 0
Research Analyst$ - 0
Data Collection Manager$ - 0
Total Labor Hours0
FFP - CLIN 0001Total Labor Price$ - 0
Direct Travel Costs (if applicable)
Indirect burdens (if applicable:)
CR - CLIN 0002Total Travel Costs (if applicable)$ - 0
Other Direct Costs excluding travel (if applicable)
Indirect burdens (if applicable:)

CR - CLIN 0003 Total Other Direct Costs excluding travel (if applicable) $ - 0

Total Price for Task Order $ - 0

Sample Task C Backup If proposed, provide quantity and description and unit prices of any ODCs and travel related to Sample Task C here:

File details come from the government source that posted it.