Pricing_Workbook_-_Protected_AMENDMENT_12192016.xlsx

XLSX spreadsheet 47 KB Posted

Attached to
CREW, IdOps, and GBOSS Team Portfolios Acquisition and Management Support
Solicitation number
M67854-17-R-2603
Issued by

About this file

Pricing Workbook Amendment 0001

View the file

Other files

Show all 17

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

M67854-17-R-2603 - PRICING WORKBOOK Tab 1 - Instructions Tab 2 - Contract FFP CLINS PRIME Tab 3 - Contract Labor Rates and Categories Tab 4-Warehouse Stepladder Pricing
Tab 1 - Instructions:
Tab 2 - Contract FFP CLINS PRIME - This worksheet is where the Prime Offeror shall enter its total proposed pricing (includes subcontractor costs) for all FFP CLINs for all IDIQ Ordering Periods. The numbers within this spreadsheet shall match the numbers proposed in Schedule B of the Model Contract.
Tab 3 - Contract Labor Rates and Categories - This worksheet is where the Prime Offeror shall enter it's Labor Categories, Roles and Responsibilities, Education, Years of Experience, 2016 hourly Compensation Rate, Ordering Periods 1 through 5 year IDIQ Fully Burdened Labor Rates,including Overhead/G&A/Subcontractor/Handling fee. These rates will remain fixed over the 5 Year ordering period of the IDIQ
Tab 4-Warehouse Stepladder Pricing

Contract FFP CLINs PRIME

ATTACHMENT 2- M67854-17-R-2603
Contract FFP CLINS PRIME - TOTAL COST
CLIN NO.ID/IQ Ordering Period 1CLIN NO.ID/IQ Ordering Period 2CLIN NO.ID/IQ Ordering Period 3CLIN NO.ID/IQ Ordering Period 4CLIN NO.ID/IQ Ordering Period 5
1001$0.002001$0.003001$0.004001$0.005001$0.00
1002$0.002002$0.003002$0.001002$0.005002$0.00
1003$0.002003$0.003003$0.004003$0.005003$0.00
1004$0.002004$0.003004$0.004004$0.005004$0.00
1005$0.002005$0.003005$0.004005$0.005005$0.00
1006$0.002006$0.003006$0.004006$0.005006$0.00
1007$0.002007$0.003007$0.004007$0.005007$0.00
1008$0.002008$0.003008$0.004008$0.005008$0.00
1009$0.002009$0.003009$0.004009$0.005009$0.00
1010
1011$200,000.00$200,000.00$200,000.00$200,000.00$200,000.00
TOTAL
Note 1: This worksheet provides the Total FFP for CLINs 1001 through 1010, 2001 through 2010, 3001 through 3010, 4001 through 4010, 5001 through 5010. Pricing within this worksheet shall match pricing provided under Model Contract, Schedule B CLINs .
Note 2: CLIN 1011, 2011, 3011, 4011 and 5011 represent the Governments estimated ODC/Travel estimate for the entire 5 year ordering period.

Lookup Values

EducationFacility
High SchoolContractor
AssociateGovernment
Bachelor
Master
Doctorate

Labor Rates and Categories

ATTACHMENT 5 - M67854-17-R-2603
STEP 1: Contract Labor Rates/Categories
Entries in this worksheet will constitute the final list of labor categories and associated data to be utilized for the entirety of the ID/IQ and any awarded task orders, pending any discussions and final proposal revisions. Changes to this list, subsequent to award of an ID/IQ contract are not authorized. This information, minus the columns labeled with, "FAR 52.222-46" will be incorporated into the ID/IQ award.
#Labor CategoryRoles and ResponsibilitiesEducation (Degree Type)Experience (Years)2016 Hourly Compensation ($) 52.222-462016 Hourly Fringe ($) 52.222-46ID/IQ Ordering Period 1 Performance Fully-Burdened Labor Rate (date of award through 1 year)ID/IQ Ordering Period 2 Performance Fully-Burdened Labor Rate (13-24 month)ID/IQ Ordering Period 3 Performance Fully-Burdened Labor Rate (25-36 month)ID/IQ Ordering Period 4 Performance Fully-Burdened Labor Rate (37 -48 month)ID/IQ Ordering Period 5 Performance Fully-Burdened Labor Rate (49-60 month)Company Name
1Program Manager$0.00ABC - Prime
2Financial Analyst$0.00
3Subject Matter Expert$0.00
4Logistician$0.00
5Administrative$0.00
Assistant$0.00
6Administrative$0.00
Assistant$0.00
FSR (CONUS)$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

Warehouse Stepladder Pricing

Year 1 (Months 1 through 12)Step 1 (80,000 sq. ft. )Step 2 (60,000 sq. ft. )Step 3 (40,000 sq. ft. )Step 4 (20,000)
Warehouse
Year 2 (Months 13 through 24)Step 1 (80,000 sq. ft. )Step 2 (60,000 sq. ft. )Step 3 (40,000 sq. ft. )Step 4 (20,000)
Warehouse
Year 3 (Months 25 through 36)Step 1 (80,000 sq. ft. )Step 2 (60,000 sq. ft. )Step 3 (40,000 sq. ft. )Step 4 (20,000)
Warehouse
Year 4 (Months 37 through 48)Step 1 (80,000 sq. ft. )Step 2 (60,000 sq. ft. )Step 3 (40,000 sq. ft. )Step 4 (20,000)
Warehouse
Year 5 (Months 49 through 60)Step 1 (80,000 sq. ft. )Step 2 (60,000 sq. ft. )Step 3 (40,000 sq. ft. )Step 4 (20,000)
Warehouse

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