10_PWS_Attachment_Pricing_Spreadsheet_ID04190008_09_Apr_2019.xlsx

XLSX spreadsheet 35 KB Posted

Attached to
Large Area Maintenance Shelter (LAMS) Support
Solicitation number
ID04190008
Issued by

About this file

PWS Attachment Pricing Spreadsheet_ID04190008_09 Apr 2019.xlsx

View the file

Other files

Show all 13

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

Cover

ORANGE PREFILLED CELLS AND FORMULAS SHALL NOT BE CHANGED. ANY CHANGES MADE WILL BE REVERTED BACK TO THE ORIGINAL NUMBERS AND FORMULAS
BLUE CELLS ARE FILLABLE
Task Number:ID04190008
Program Title:Large Area Maintaence Shelter Support
Company Name:
Basic YearOption Year IOption Year IIOption Year IIIOption Year IVExtension PeriodTotal
CLIN X001$0.00$0.00$0.00$0.00$0.00$0.00$0.00
CLIN X002$0.00$0.00$0.00$0.00$0.00$0.00$0.00
CLIN X003$456,049.00$456,049.00$456,049.00$456,049.00$456,049.00$228,024.50$2,508,269.50
CLIN X004$374,700.00$374,700.00$374,700.00$374,700.00$374,700.00$187,350.00$2,060,850.00
CLIN X005$386,500.00$386,500.00$386,500.00$386,500.00$386,500.00$193,250.00$2,125,750.00
Total$1,217,249.00$1,217,249.00$1,217,249.00$1,217,249.00$1,217,249.00$608,624.50$6,694,869.50

Total Evaluated Price (TEP): $6,694,869.50

Basic Year

ORANGE PREFILLED CELLS AND FORMULAS SHALL NOT BE CHANGED. ANY CHANGES MADE WILL BE REVERTED BACK TO THE ORIGINAL NUMBERS AND FORMULAS
BLUE CELLS ARE FILLABLE
Basic Period of Performance (2019-2020)
CLIN 0001 Installs (FFP)Labor HoursBurdened Labor RateTotal
Program Manager$0.00
Senior Equipment Specialist$0.00
Equipment Specialist$0.00
Total per Install$0.00
Total for BEQ of 10$0.00
CLIN 0002 Strikes (FFP)Labor HoursBurdened Labor RateTotal
Program Manager$0.00
Senior Equipment Specialist$0.00
Equipment Specialist$0.00
Total per Install$0.00
Total for BEQ of 5$0.00
CLIN 0003 Resets, Repairs, Maintanence, and Assistance (T&M)Labor Hours for Labor /Dollars for MaterialBurdened Labor Rate for Labor/G&A (%) for MaterialTotal
Program Manager928$0.00
Senior Equipment Specialist1116$0.00
Equipment Specialist5972$0.00
Program Manager-Contingency552$0.00
Senior Equipment Specialist-Contingency3630$0.00
Equipment Specialist-Contingency3630$0.00
Parts and Materials (G&A rate only should be proposed)$456,049.00$456,049.00
Total for BEQ of 20$456,049.00
CLINs 0004 and 0005 Other Ancillary SupportEstimateG&A or Material Handling (%)Total
CLIN 0004-Travel$374,700.00$374,700.00
CLIN 0005-Other Direct Costs (Equipment and Supplies)$386,500.00$386,500.00

Basic Year Grand Total $1,217,249.00

Option Year I

ORANGE PREFILLED CELLS AND FORMULAS SHALL NOT BE CHANGED. ANY CHANGES MADE WILL BE REVERTED BACK TO THE ORIGINAL NUMBERS AND FORMULAS
BLUE CELLS ARE FILLABLE
Option Year I Period of Performance (2020-2021)
CLIN 1001 Installs (FFP)Labor HoursBurdened Labor RateTotal
Program Manager$0.00
Senior Equipment Specialist$0.00
Equipment Specialist$0.00
Total per Install$0.00
Total for BEQ of 10$0.00
CLIN 1002 Strikes (FFP)Labor HoursBurdened Labor RateTotal
Program Manager$0.00
Senior Equipment Specialist$0.00
Equipment Specialist$0.00
Total per Install$0.00
Total for BEQ of 5$0.00
CLIN 1003 Resets, Repairs, Maintanence, and Assistance (T&M)Labor Hours for Labor /Dollars for MaterialBurdened Labor Rate for Labor/G&A (%) for MaterialTotal
Program Manager928$0.00
Senior Equipment Specialist1116$0.00
Equipment Specialist5972$0.00
Program Manager-Contingency552$0.00
Senior Equipment Specialist-Contingency3630$0.00
Equipment Specialist-Contingency3630$0.00
Parts and Materials (G&A rate only should be proposed)$456,049.00$456,049.00
Total for BEQ of 20$456,049.00
CLINs 1004 and 1005 Other Ancillary SupportEstimateG&A or Material Handling (%)Total
CLIN 1004-Travel$374,700.00$ 374,700.00
CLIN 1005-Other Direct Costs (Equipment and Supplies)$386,500.00$ 386,500.00

Option Year I Grand Total $1,217,249.00

Option Year II

ORANGE PREFILLED CELLS AND FORMULAS SHALL NOT BE CHANGED. ANY CHANGES MADE WILL BE REVERTED BACK TO THE ORIGINAL NUMBERS AND FORMULAS
BLUE CELLS ARE FILLABLE

Option Year II Period of Performance (2021-2022)

CLIN 2001 Installs (FFP)Labor HoursBurdened Labor RateTotal
Program Manager$0.00
Senior Equipment Specialist$0.00
Equipment Specialist$0.00
Total per Install$0.00
Total for BEQ of 10$0.00
CLIN 2002 Strikes (FFP)Labor HoursBurdened Labor RateTotal
Program Manager$0.00
Senior Equipment Specialist$0.00
Equipment Specialist$0.00
Total per Install$0.00
Total for BEQ of 5$0.00
CLIN 2003 Resets, Repairs, Maintanence, and Assistance (T&M)Labor Hours for Labor /Dollars for MaterialBurdened Labor Rate for Labor/G&A for MaterialTotal
Program Manager928$0.00
Senior Equipment Specialist1116$0.00
Equipment Specialist5972$0.00
Program Manager-Contingency552$0.00
Senior Equipment Specialist-Contingency3630$0.00
Equipment Specialist-Contingency3630$0.00
Parts and Materials (G&A rate only should be proposed)$456,049.00$456,049.00
Total for BEQ of 20$456,049.00
CLINs 2004 and 2005 Other Ancillary SupportEstimateG&A or Material Handling (%)Total
CLIN 2004-Travel$374,700.00$ 374,700.00
CLIN 2005-Other Direct Costs (Equipment and Supplies)$386,500.00$ 386,500.00

Option Year II Grand Total $1,217,249.00

Option Year III

ORANGE PREFILLED CELLS AND FORMULAS SHALL NOT BE CHANGED. ANY CHANGES MADE WILL BE REVERTED BACK TO THE ORIGINAL NUMBERS AND FORMULAS
BLUE CELLS ARE FILLABLE
Option Year III Period of Performance (2022-2023)
CLIN 3001 Installs (FFP)Labor HoursBurdened Labor RateTotal
Program Manager$0.00
Senior Equipment Specialist$0.00
Equipment Specialist$0.00
Total per Install$0.00
Total for BEQ of 10$0.00
CLIN 3002 Strikes (FFP)Labor HoursBurdened Labor RateTotal
Program Manager$0.00
Senior Equipment Specialist$0.00
Equipment Specialist$0.00
Total per Install$0.00
Total for BEQ of 5$0.00
CLIN 3003 Resets, Repairs, Maintanence, and Assistance (T&M)Labor Hours for Labor /Dollars for MaterialBurdened Labor Rate for Labor/G&A (%) for MaterialTotal
Program Manager928$0.00
Senior Equipment Specialist1116$0.00
Equipment Specialist5972$0.00
Program Manager-Contingency552$0.00
Senior Equipment Specialist-Contingency3630$0.00
Equipment Specialist-Contingency3630$0.00
Parts and Materials (G&A rate only should be proposed)$456,049.00$456,049.00
Total for BEQ of 20$456,049.00
CLINs 3004 and 3005 Other Ancillary SupportEstimateG&A or Material Handling (%)Total
CLIN 3004-Travel$374,700.00$ 374,700.00
CLIN 3005-Other Direct Costs (Equipment and Supplies)$386,500.00$ 386,500.00

Option Year III Grand Total $1,217,249.00

Option Year IV

ORANGE PREFILLED CELLS AND FORMULAS SHALL NOT BE CHANGED. ANY CHANGES MADE WILL BE REVERTED BACK TO THE ORIGINAL NUMBERS AND FORMULAS
BLUE CELLS ARE FILLABLE
Option Year IV Period of Performance (2023-2024)
CLIN 4001 Installs (FFP)Labor HoursBurdened Labor RateTotal
Program Manager$0.00
Senior Equipment Specialist$0.00
Equipment Specialist$0.00
Total per Install$0.00
Total for BEQ of 10$0.00
CLIN 4002 Strikes (FFP)Labor HoursBurdened Labor RateTotal
Program Manager$0.00
Senior Equipment Specialist$0.00
Equipment Specialist$0.00
Total per Install$0.00
Total for BEQ of 5$0.00
CLIN 4003 Resets, Repairs, Maintanence, and Assistance (T&M)Labor Hours for Labor /Dollars for MaterialBurdened Labor Rate for Labor/G&A (%) for MaterialTotal
Program Manager928$0.00
Senior Equipment Specialist1116$0.00
Equipment Specialist5972$0.00
Program Manager-Contingency552$0.00
Senior Equipment Specialist-Contingency3630$0.00
Equipment Specialist-Contingency3630$0.00
Parts and Materials (G&A rate only should be proposed)$456,049.00$456,049.00
Total for BEQ of 20$456,049.00
CLINs 4004 and 4005 Other Ancillary SupportEstimateG&A or Material Handling (%)Total
CLIN 4004-Travel$374,700.00$ 374,700.00
CLIN 4005-Other Direct Costs (Equipment and Supplies)$386,500.00$ 386,500.00

Option Year IV Grand Total $1,217,249.00

Extension Period

ORANGE PREFILLED CELLS AND FORMULAS SHALL NOT BE CHANGED. ANY CHANGES MADE WILL BE REVERTED BACK TO THE ORIGINAL NUMBERS AND FORMULAS
BLUE CELLS ARE FILLABLE

Extension Period of Performance (2024)

CLIN 5001 Installs (FFP)Labor HoursBurdened Labor RateTotal
Program Manager$0.00
Senior Equipment Specialist$0.00
Equipment Specialist$0.00
Total per Install$0.00
Total for BEQ of 5$0.00
CLIN 5002 Strikes (FFP)Labor HoursBurdened Labor RateTotal
Program Manager$0.00
Senior Equipment Specialist$0.00
Equipment Specialist$0.00
Total per Install$0.00
Total for BEQ of 3$0.00
CLIN 5003 Resets, Repairs, Maintanence, and Assistance (T&M)Labor Hours for Labor /Dollars for MaterialBurdened Labor Rate for Labor/G&A (%) for MaterialTotal
Program Manager464$0.00
Senior Equipment Specialist558$0.00
Equipment Specialist2986$0.00
Program Manager-Contingency276$0.00
Senior Equipment Specialist-Contingency1815$0.00
Equipment Specialist-Contingency1815$0.00
Parts and Materials (G&A rate only should be proposed)$228,024.50$228,024.50
Total for BEQ of 10$228,024.50
CLINs 5004 and 5005 Other Ancillary SupportEstimateG&A or Material Handling (%)Total
CLIN 5004-Travel$187,350.00$ 187,350.00
CLIN 5005-Other Direct Costs (Equipment and Supplies)$193,250.00$ 193,250.00

Extension Period Grand Total $608,624.50

File details come from the government source that posted it.