ID09180038_D.3_-_PRICE_SUMMARY_WORKBOOK.xlsx

XLSX spreadsheet 236 KB Posted

Attached to
Manpower Personnel Testing Analysis (MPTA) Support Services
Solicitation number
ID09180038
Issued by

About this file

D.3 - Price Summary Workbook

View the file

Other files

File Type Posted
A0003_ID09180038_SF30.pdf PDF
ID09180038_REQUEST_FOR_PROPOSAL_A0001.pdf PDF
A0002_ID09180038_SF30.pdf PDF
Amendment_A0002_ID09180038_MPTA_Q&A.pdf PDF
Amendment_A0001_ID09180038_D.3_-_PRICE_SUMMARY_WORKBOOK.xlsx XLSX spreadsheet
Amendment_A0001_ID09180038_D.1_ATTACHMENT_1_HISTORICAL_AND_PROJECTED_WORKLOAD.pdf PDF
A0001_ID09180038_D.8_PAST_PERFORMANCE_REFERENCE_SHEET.docx DOCX document
A0001_ID09180038_SF30.pdf PDF
ID09180038_D.1_ATTACHMENT_1_HISTORICAL_AND_PROJECTED_WORKLOAD.pdf PDF
ID09180038_D.1_ATTACHMENT_5_SAMPLE_TASK_ORDER__1.pdf PDF
ID09180038_D.1_ATTACHMENT_3_PROBLEM_NOTIFICATION_REPORT.pdf PDF
ID09180038_REQUEST_FOR_PROPOSAL.pdf PDF
ID09180038_SECTION_D.1_PERFORMANCE_WORK_STATEMENT.pdf PDF
ID09180038_D.5_QUALITY_ASSURANCE_SURVEILLANCE_PLAN.pdf PDF
ID09180038_D.2_TRAVEL_AUTHORIZATION_REQUEST.pdf PDF
ID09180038_D.7_SMALL_BUSINESS_PARTICIPATION_INFORMATION_SHEET.pdf PDF
ID09180038_D.1_ATTACHMENT_6_SAMPLE_TASK_ORDER_2.pdf PDF
ID09180038_D.8_PAST_PERFORMANCE_REFERENCE_SHEET.pdf PDF
ID09180038_D.4_KEY_PERSONNEL_REQUIREMENTS_SUMMARY.pdf PDF
ID09180038_D.6_NON-DISCLOSURE_AGREEMENT.pdf PDF
ID09180038_D.1_ATTACHMENT_7_-_SAMPLE_TASK_ORDER_3_-_TASK_ORDER_0001.pdf PDF
ID09180038_D.1_ATTACHMENT_4_MONTHLY_STATUS_REPORT.pdf PDF
ID09180038_D.1_ATTACHMENT_2_GOVERNMENT_FURNISHED_PROPERTY.pdf PDF
Show all 23

On GovTribe

Work with this file

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

Text version

Instructions

ID09180038 PRICE SUMMARY WORKBOOK - INSTRUCTIONS
General Instructions:
1Insert Offeror Name
2Fill out all yellow highlighted cells on subsequent tabs of this worksheet.
3Include all applicable prices and costs for the contract on the Price Input Tab, including both prime and suboffer (subcontract) amounts.
4Ensure all formulas are functional and intact on the proposal submission.
Periods Tab Instructions:
1Column C - If offeror nomenclature differs from Government provided labor category name, add offeror's equivalent name for each Government 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.
3Column F - Enter fully burdened labor rates 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.
5Do 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.
Price Summary Tab Instructions:
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.
Sample Task Order 1, 2, and 3 Price Tab Instructions
Fill 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.
Fill 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.
Ensure totals for Labor hours, labor price, other direct costs, travel, as well as overall total price is accurate.
Sample Task Order 1, 2, and 3 Backup Tab Instructions
Include a description of each other direct cost item proposed for the task order with any applicable quantities and unit price amounts
Include a summary of any proposed travel costs to include identification of number of travelers, destination, duration, and price for each trip.
If no ODC or travel is proposed, leave blank.

Base Period

Base Year (July 2018-July 2019)
CLIN 0001 Labor Category (LCAT) - OnSiteProvide offeror's equivalent LCAT name (if different than LCAT Name in Column B, otherwise leave blank)Indicate if labor proposed from prime or subofferor (sub) (If sub, also include name of sub)Labor HoursFully Burdened Labor RateBase Total
A001AA/Expert Contributor (Behavioral)140$0.00
A001AB/Task Leader/Senior Contributor (Behavioral)140$0.00
A001AC/Mid-Range Technical Contributor (Behavioral)4,759$0.00
A001AD/Junior Technical Contributor (Behavioral)140$0.00
A001AE/Expert Contributor (Analytic)140$0.00
A001AF/Task Leader/Senior Contributor (Analytic)140$0.00
A001AG/Task Leader/Senior Contributor (Data Coll. Oper.)140$0.00
A001AH/Mid-Range Technical Contributor (Data Coll. Oper.)140$0.00
A001AJ/Junior Technical Contributor (Data Coll. Oper.)140$0.00
A001AK/Data Collection Supervisor140$0.00
A001AL/Data Collection Senior Technician140$0.00
A001AM/Data Collection Technician140$0.00
A001AN/Senior Technical Editor140$0.00
A001AP/Mid-Level Technical Editor3,130$0.00
A001AQ/Junior Technical Editor140$0.00
A001AR/Production Staff140$0.00
A001AS/Mid-Range Technical Contributor (Analytic)140$0.00
A001AT/Junior Technical Contributor (Analytic)4,203$0.00
A001AU/Programming & Analytic Support Staff50,626$0.00
A001AV Program Management1,048.50$0.00
CLIN 0001 Labor Category - Offsite
A001AA/Expert Contributor (Behavioral)1,232$0.00
A001AB/Task Leader/Senior Contributor (Behavioral)5,686$0.00
A001AC/Mid-Range Technical Contributor (Behavioral)17,108$0.00
A001AD/Junior Technical Contributor (Behavioral)1,919$0.00
A001AE/Expert Contributor (Analytic)670$0.00
A001AF/Task Leader/Senior Contributor (Analytic)10,096$0.00
A001AG/Task Leader/Senior Contributor (Data Coll. Oper.)140$0.00
A001AH/Mid-Range Technical Contributor (Data Coll. Oper.)140$0.00
A001AJ/Junior Technical Contributor (Data Coll. Oper.)4,446$0.00
A001AK/Data Collection Supervisor140$0.00
A001AL/Data Collection Senior Technician140$0.00
A001AM/Data Collection Technician140$0.00
A001AN/Senior Technical Editor7,695$0.00
A001AP/Mid-Level Technical Editor341$0.00
A001AQ/Junior Technical Editor20,733$0.00
A001AR/Production Staff419$0.00
A001AS/Mid-Range Technical Contributor (Analytic)6,661$0.00
A001AT/Junior Technical Contributor (Analytic)140$0.00
A001AU/Programming & Analytic Support Staff4,552$0.00
A001AV Program Management1,048.50$0.00
Total Labor Hours149,313
Total Labor Price$0.00

CLIN 0002 Total Other Direct Costs $1,000,000.00

CLIN 0003 Total Travel Costs $180,000.00

Totals Total Base Year $1,180,000.00

Option Period 1

Option 1 - (July 2019-July 2020)
CLIN 1001 Labor Category (LCAT) - OnSiteProvide offeror's equivalent LCAT name (if different than LCAT Name in Column B, otherwise leave blank)Indicate if labor proposed from prime or subofferor (sub) (If sub, also include name of sub)Labor HoursFully Burdened Labor RateBase Total
A001AA/Expert Contributor (Behavioral)147$0.00
A001AB/Task Leader/Senior Contributor (Behavioral)147$0.00
A001AC/Mid-Range Technical Contributor (Behavioral)4,992$0.00
A001AD/Junior Technical Contributor (Behavioral)147$0.00
A001AE/Expert Contributor (Analytic)147$0.00
A001AF/Task Leader/Senior Contributor (Analytic)147$0.00
A001AG/Task Leader/Senior Contributor (Data Coll. Oper.)147$0.00
A001AH/Mid-Range Technical Contributor (Data Coll. Oper.)147$0.00
A001AJ/Junior Technical Contributor (Data Coll. Oper.)147$0.00
A001AK/Data Collection Supervisor147$0.00
A001AL/Data Collection Senior Technician147$0.00
A001AM/Data Collection Technician147$0.00
A001AN/Senior Technical Editor147$0.00
A001AP/Mid-Level Technical Editor3,283$0.00
A001AQ/Junior Technical Editor147$0.00
A001AR/Production Staff147$0.00
A001AS/Mid-Range Technical Contributor (Analytic)147$0.00
A001AT/Junior Technical Contributor (Analytic)4,409$0.00
A001AU/Programming & Analytic Support Staff53,106$0.00
A001AV Program Management1,049$0.00
CLIN 1001 Labor Category - Offsite
A001AA/Expert Contributor (Behavioral)1,292$0.00
A001AB/Task Leader/Senior Contributor (Behavioral)5,964$0.00
A001AC/Mid-Range Technical Contributor (Behavioral)17,946$0.00
A001AD/Junior Technical Contributor (Behavioral)2,013$0.00
A001AE/Expert Contributor (Analytic)703$0.00
A001AF/Task Leader/Senior Contributor (Analytic)10,591$0.00
A001AG/Task Leader/Senior Contributor (Data Coll. Oper.)147$0.00
A001AH/Mid-Range Technical Contributor (Data Coll. Oper.)147$0.00
A001AJ/Junior Technical Contributor (Data Coll. Oper.)4,664$0.00
A001AK/Data Collection Supervisor147$0.00
A001AL/Data Collection Senior Technician147$0.00
A001AM/Data Collection Technician147$0.00
A001AN/Senior Technical Editor8,072$0.00
A001AP/Mid-Level Technical Editor357$0.00
A001AQ/Junior Technical Editor21,749$0.00
A001AR/Production Staff440$0.00
A001AS/Mid-Range Technical Contributor (Analytic)6,987$0.00
A001AT/Junior Technical Contributor (Analytic)147$0.00
A001AU/Programming & Analytic Support Staff4,775$0.00
A001AV Program Management1,048.50$0.00
Total Labor Hours156,527
Total Labor Price$0.00

CLIN 1002 Total Other Direct Costs $1,100,000.00

CLIN 1003 Total Travel Costs $198,000.00

Totals Total Base Year $1,298,000.00

Option Period 2

Option 2 - (July 2020 - July 2021)
CLIN 2001 Labor Category (LCAT) - OnSiteProvide offeror's equivalent LCAT name (if different than LCAT Name in Column B, otherwise leave blank)Indicate if labor proposed from prime or subofferor (sub) (If sub, also include name of sub)Labor HoursFully Burdened Labor RateBase Total
A001AA/Expert Contributor (Behavioral)154$0.00
A001AB/Task Leader/Senior Contributor (Behavioral)154$0.00
A001AC/Mid-Range Technical Contributor (Behavioral)5,236$0.00
A001AD/Junior Technical Contributor (Behavioral)154$0.00
A001AE/Expert Contributor (Analytic)154$0.00
A001AF/Task Leader/Senior Contributor (Analytic)154$0.00
A001AG/Task Leader/Senior Contributor (Data Coll. Oper.)154$0.00
A001AH/Mid-Range Technical Contributor (Data Coll. Oper.)154$0.00
A001AJ/Junior Technical Contributor (Data Coll. Oper.)154$0.00
A001AK/Data Collection Supervisor154$0.00
A001AL/Data Collection Senior Technician154$0.00
A001AM/Data Collection Technician154$0.00
A001AN/Senior Technical Editor154$0.00
A001AP/Mid-Level Technical Editor3,444$0.00
A001AQ/Junior Technical Editor154$0.00
A001AR/Production Staff154$0.00
A001AS/Mid-Range Technical Contributor (Analytic)154$0.00
A001AT/Junior Technical Contributor (Analytic)4,624$0.00
A001AU/Programming & Analytic Support Staff55,702$0.00
A001AV Program Management1,048.50$0.00
CLIN 2001 Labor Category - Offsite
A001AA/Expert Contributor (Behavioral)1,355$0.00
A001AB/Task Leader/Senior Contributor (Behavioral)6,256$0.00
A001AC/Mid-Range Technical Contributor (Behavioral)18,823$0.00
A001AD/Junior Technical Contributor (Behavioral)2,112$0.00
A001AE/Expert Contributor (Analytic)737$0.00
A001AF/Task Leader/Senior Contributor (Analytic)11,109$0.00
A001AG/Task Leader/Senior Contributor (Data Coll. Oper.)154$0.00
A001AH/Mid-Range Technical Contributor (Data Coll. Oper.)154$0.00
A001AJ/Junior Technical Contributor (Data Coll. Oper.)4,892$0.00
A001AK/Data Collection Supervisor154$0.00
A001AL/Data Collection Senior Technician154$0.00
A001AM/Data Collection Technician154$0.00
A001AN/Senior Technical Editor8,467$0.00
A001AP/Mid-Level Technical Editor375$0.00
A001AQ/Junior Technical Editor22,812$0.00
A001AR/Production Staff461$0.00
A001AS/Mid-Range Technical Contributor (Analytic)7,329$0.00
A001AT/Junior Technical Contributor (Analytic)154$0.00
A001AU/Programming & Analytic Support Staff5,008$0.00
A001AV Program Management1,048.50$0.00
Total Labor Hours164,073
Total Labor Price$0.00

CLIN 2002 Total Other Direct Costs $1,210,000.00

CLIN 2003 Total Travel Costs $217,800.00

Totals Total Base Year $1,427,800.00

Price Summary

Contract PeriodCLINDescriptionPrice
Base Year0001Services in accordance with PWS$ - 0
0002Other Direct Costs$ 1,000,000.00
0003Travel$ 180,000.00
Option Year 11001Services in accordance with PWS$ - 0
1002Other Direct Costs$ 1,100,000.00
1003Travel$ 198,000.00
Option Year 22001Services in accordance with PWS$ - 0
2002Other Direct Costs$ 1,210,000.00
2003Travel$ 217,800.00
TOTAL PROPOSED PRICE$ 3,905,800.00

Sample Task Order 1

MANPOWER PERSONNEL AND TRAINING ANALYSIS SUPPORT (MPTA)
SAMPLE TASK ORDER ONE
CLIN - 0001 Labor Category (LCAT) - OnSiteProvide offeror's equivalent LCAT name (if different than LCAT Name in Column B, otherwise leave blank)Indicate if labor proposed from prime or subofferor (sub) (If sub, also include name of sub)Labor HoursFully Burdened Labor RateBase Total
A001AA/Expert Contributor (Behavioral)$0.00
A001AB/Task Leader/Senior Contributor (Behavioral)$0.00
A001AC/Mid-Range Technical Contributor (Behavioral)$0.00
A001AD/Junior Technical Contributor (Behavioral)$0.00
A001AE/Expert Contributor (Analytic)$0.00
A001AF/Task Leader/Senior Contributor (Analytic)$0.00
A001AG/Task Leader/Senior Contributor (Data Coll. Oper.)$0.00
A001AH/Mid-Range Technical Contributor (Data Coll. Oper.)$0.00
A001AJ/Junior Technical Contributor (Data Coll. Oper.)$0.00
A001AK/Data Collection Supervisor$0.00
A001AL/Data Collection Senior Technician$0.00
A001AM/Data Collection Technician$0.00
A001AN/Senior Technical Editor$0.00
A001AP/Mid-Level Technical Editor$0.00
A001AQ/Junior Technical Editor$0.00
A001AR/Production Staff$0.00
A001AS/Mid-Range Technical Contributor (Analytic)$0.00
A001AT/Junior Technical Contributor (Analytic)$0.00
A001AU/Programming & Analytic Support Staff$0.00
A001AV Program Management$0.00
CLIN - 0001 Labor Category (LCAT) - OffSite
A001AA/Expert Contributor (Behavioral)$0.00
A001AB/Task Leader/Senior Contributor (Behavioral)$0.00
A001AC/Mid-Range Technical Contributor (Behavioral)$0.00
A001AD/Junior Technical Contributor (Behavioral)$0.00
A001AE/Expert Contributor (Analytic)$0.00
A001AF/Task Leader/Senior Contributor (Analytic)$0.00
A001AG/Task Leader/Senior Contributor (Data Coll. Oper.)$0.00
A001AH/Mid-Range Technical Contributor (Data Coll. Oper.)$0.00
A001AJ/Junior Technical Contributor (Data Coll. Oper.)$0.00
A001AK/Data Collection Supervisor$0.00
A001AL/Data Collection Senior Technician$0.00
A001AM/Data Collection Technician$0.00
A001AN/Senior Technical Editor$0.00
A001AP/Mid-Level Technical Editor$0.00
A001AQ/Junior Technical Editor$0.00
A001AR/Production Staff$0.00
A001AS/Mid-Range Technical Contributor (Analytic)$0.00
A001AT/Junior Technical Contributor (Analytic)$0.00
A001AU/Programming & Analytic Support Staff$0.00
A001AV Program Management$0.00
Total Labor Hours0
Total Labor Price$0.00

CLIN 0002 Total Other Direct Costs $0.00

CLIN 0003 Total Travel Costs $0.00

Totals Total $0.00

Sample Task Order 2

MANPOWER PERSONNEL AND TRAINING ANALYSIS SUPPORT (MPTA)
SAMPLE TASK ORDER TWO
CLIN - 0001 Labor Category (LCAT) - OnSiteProvide offeror's equivalent LCAT name (if different than LCAT Name in Column B, otherwise leave blank)Indicate if labor proposed from prime or subofferor (sub) (If sub, also include name of sub)Labor HoursFully Burdened Labor RateBase Total
A001AA/Expert Contributor (Behavioral)$0.00
A001AB/Task Leader/Senior Contributor (Behavioral)$0.00
A001AC/Mid-Range Technical Contributor (Behavioral)$0.00
A001AD/Junior Technical Contributor (Behavioral)$0.00
A001AE/Expert Contributor (Analytic)$0.00
A001AF/Task Leader/Senior Contributor (Analytic)$0.00
A001AG/Task Leader/Senior Contributor (Data Coll. Oper.)$0.00
A001AH/Mid-Range Technical Contributor (Data Coll. Oper.)$0.00
A001AJ/Junior Technical Contributor (Data Coll. Oper.)$0.00
A001AK/Data Collection Supervisor$0.00
A001AL/Data Collection Senior Technician$0.00
A001AM/Data Collection Technician$0.00
A001AN/Senior Technical Editor$0.00
A001AP/Mid-Level Technical Editor$0.00
A001AQ/Junior Technical Editor$0.00
A001AR/Production Staff$0.00
A001AS/Mid-Range Technical Contributor (Analytic)$0.00
A001AT/Junior Technical Contributor (Analytic)$0.00
A001AU/Programming & Analytic Support Staff$0.00
A001AV Program Management$0.00
CLIN - 0001 Labor Category (LCAT) - OffSite
A001AA/Expert Contributor (Behavioral)$0.00
A001AB/Task Leader/Senior Contributor (Behavioral)$0.00
A001AC/Mid-Range Technical Contributor (Behavioral)$0.00
A001AD/Junior Technical Contributor (Behavioral)$0.00
A001AE/Expert Contributor (Analytic)$0.00
A001AF/Task Leader/Senior Contributor (Analytic)$0.00
A001AG/Task Leader/Senior Contributor (Data Coll. Oper.)$0.00
A001AH/Mid-Range Technical Contributor (Data Coll. Oper.)$0.00
A001AJ/Junior Technical Contributor (Data Coll. Oper.)$0.00
A001AK/Data Collection Supervisor$0.00
A001AL/Data Collection Senior Technician$0.00
A001AM/Data Collection Technician$0.00
A001AN/Senior Technical Editor$0.00
A001AP/Mid-Level Technical Editor$0.00
A001AQ/Junior Technical Editor$0.00
A001AR/Production Staff$0.00
A001AS/Mid-Range Technical Contributor (Analytic)$0.00
A001AT/Junior Technical Contributor (Analytic)$0.00
A001AU/Programming & Analytic Support Staff$0.00
A001AV Program Management$0.00
Total Labor Hours0
Total Labor Price$0.00

CLIN 0002 Total Other Direct Costs $0.00

CLIN 0003 Total Travel Costs $0.00

Totals Total $0.00

Sample Task Order 3- TO 0001

MANPOWER PERSONNEL AND TRAINING ANALYSIS SUPPORT (MPTA)
SAMPLE TASK ORDER THREE
CLIN - 0001 Labor Category (LCAT) - OnSiteProvide offeror's equivalent LCAT name (if different than LCAT Name in Column B, otherwise leave blank)Indicate if labor proposed from prime or subofferor (sub) (If sub, also include name of sub)Labor HoursFully Burdened Labor RateBase Total
A001AA/Expert Contributor (Behavioral)$0.00
A001AB/Task Leader/Senior Contributor (Behavioral)$0.00
A001AC/Mid-Range Technical Contributor (Behavioral)$0.00
A001AD/Junior Technical Contributor (Behavioral)$0.00
A001AE/Expert Contributor (Analytic)$0.00
A001AF/Task Leader/Senior Contributor (Analytic)$0.00
A001AG/Task Leader/Senior Contributor (Data Coll. Oper.)$0.00
A001AH/Mid-Range Technical Contributor (Data Coll. Oper.)$0.00
A001AJ/Junior Technical Contributor (Data Coll. Oper.)$0.00
A001AK/Data Collection Supervisor$0.00
A001AL/Data Collection Senior Technician$0.00
A001AM/Data Collection Technician$0.00
A001AN/Senior Technical Editor$0.00
A001AP/Mid-Level Technical Editor$0.00
A001AQ/Junior Technical Editor$0.00
A001AR/Production Staff$0.00
A001AS/Mid-Range Technical Contributor (Analytic)$0.00
A001AT/Junior Technical Contributor (Analytic)$0.00
A001AU/Programming & Analytic Support Staff$0.00
A001AV Program Management$0.00
CLIN - 0001 Labor Category (LCAT) - OffSite
A001AA/Expert Contributor (Behavioral)$0.00
A001AB/Task Leader/Senior Contributor (Behavioral)$0.00
A001AC/Mid-Range Technical Contributor (Behavioral)$0.00
A001AD/Junior Technical Contributor (Behavioral)$0.00
A001AE/Expert Contributor (Analytic)$0.00
A001AF/Task Leader/Senior Contributor (Analytic)$0.00
A001AG/Task Leader/Senior Contributor (Data Coll. Oper.)$0.00
A001AH/Mid-Range Technical Contributor (Data Coll. Oper.)$0.00
A001AJ/Junior Technical Contributor (Data Coll. Oper.)$0.00
A001AK/Data Collection Supervisor$0.00
A001AL/Data Collection Senior Technician$0.00
A001AM/Data Collection Technician$0.00
A001AN/Senior Technical Editor$0.00
A001AP/Mid-Level Technical Editor$0.00
A001AQ/Junior Technical Editor$0.00
A001AR/Production Staff$0.00
A001AS/Mid-Range Technical Contributor (Analytic)$0.00
A001AT/Junior Technical Contributor (Analytic)$0.00
A001AU/Programming & Analytic Support Staff$0.00
A001AV Program Management$0.00
Total Labor Hours0
Total Labor Price$0.00

CLIN 0002 Total Other Direct Costs $0.00

CLIN 0003 Total Travel Costs $0.00

Totals Total $0.00

File details come from the government source that posted it.