Attachment_7_RSFMS_Pricing_Template.xlsx

XLSX spreadsheet 115 KB Posted

Attached to
Rivanna Station Facilities Maintenance Services (RSFMS)
Solicitation number
W911W517R0002
Issued by

About this file

Attachment 7 RSFMS Pricing Template

View the file

Other files

File Type Posted
Attachment_3_Addenda_52.212-1,_Instructions_to_Offerors_Amendment_0002.docx DOCX document
Attachment_2_Performance_Work_Statement_Amendment_0002.docx DOCX document
Attachment_9_Q&A_Site_Visit_Attendees_Amendment_0002.docx DOCX document
PWS_Attachment_1_List_of_Equipment_to_be_Maintained_Amendment_0002.xlsx XLSX spreadsheet
PWS_Attachment_2,_Cleaning_&_Custodial_Tasks_&_Frequency_of_Services_Amendment_0002.pdf PDF
PWS_Attachment_5,_Consolidated_CDRL's_Amendment_0001.pdf PDF
Attachment_3_Addenda_52.212-1,_Instructions_to_Offerors_Amendment_0001.docx DOCX document
Attachment_2_Performance_Work_Statement_Amendment_0001.docx DOCX document
Attachment_9_Q&A_Site_Visit_Attendees_Amendment_0001.docx DOCX document
Attachment_4_Addenda_52.212-2,_Evaluation_--_Commercial_Items.docx DOCX document
Attachment_1_Contract_Line_Items.docx DOCX document
PWS_Attachment_3,_Clean_Room_Tasks_&_Frequency_of_Services_&_Training.pdf PDF
PWS_Attachment_2,_Cleaning_&_Custodial_Tasks_&_Frequency_of_Services.pdf PDF
Attachment_6_Past_Performance_Evaluation_Questionnaire_Form.docx DOCX document
PWS_Attachment_5,_Consolidated_CDRL's.pdf PDF
Attachment_2_Performance_Work_Statement_22_Mar_2017.docx DOCX document
Attachment_8_Wage_Determination_15-2545-Revision_No_5_-_Dated_30_Dec_16.pdf PDF
Attachment_5_Cover_Letter_for_Past_Performance_Questionaire.docx DOCX document
PWS_Attachment_1_List_of_Equipment_to_be_Maintained.xlsx XLSX spreadsheet
PWS_Attachment_4,_DD_Form_254_and_all_DD_Form_254_attachments_and_addenda_02162017.pdf PDF
Attachment_3_Addenda_52.212-1,_Instructions_to_Offerors.docx DOCX document
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

Text version

INSTRUCTIONS

INSTRUCTIONS
(DOUBLE CLICK THE ICON FOR INSTRUCTIONS)

SECTION B

SAMPLE SECTION B - SUPPLIES OR SERVICES & PRICES
(This is for sample purposes only. The Section B actually submitted shall conform to the format contained in the letter request for proposal.)
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0001Phase-In - 30-days1Lot$ 92,355.40$ 4.20From Price Summary worksheet
FFP Labor
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0002Base Period - Months 1-66Months$37.12$222.70From Price Summary worksheet
FFP RSFMS Custodial Labor-Material-Supplies-Equipment
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0003Base Period - Months 1-66Months$37.12$222.70From Price Summary worksheet
FFP RSFMS Level I Preventive Maintenance Labor-Material-Supplies-Equipment
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0004Base Period - Months 1-61Lot$ 26,000.00$26,000.00From Price Summary worksheet
Cost Level II Maintenance NTE
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0005Base Period - Months 1-61Lot$65,000.00$65,000.00From Price Summary worksheet
Cost Level III Maintenance NTE
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
0006Base Period - Months 1-61Lot$0.00$0.00
FFP CMRA Not Separately Priced
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
1001Option Year 1 - Months 7-1812Months$18.56$222.70From Price Summary worksheet
FFP RSFMS Custodial Labor-Material-Supplies-Equipment
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
1002Option Year 1 - Months 7-1812Months$18.56$222.70From Price Summary worksheet
FFP RSFMS Level I Preventive Maintenance Labor-Material-Supplies-Equipment
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
1003Option Year 1 - Months 7-181Lot$ 52,000.00$52,000.00From Price Summary worksheet
Cost Level II Maintenance NTE
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
1004Option Year 1 - Months 7-181Lot$130,000.00$130,000.00From Price Summary worksheet
Cost Level III Maintenance NTE
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
1005Option Year 1 - Months 7-181Lot$0.00$0.00
FFP CMRA Not Separately Priced
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
2001Option Year 2 - Months 19-3012Months$18.56$222.70From Price Summary worksheet
FFP RSFMS Custodial Labor-Material-Supplies-Equipment
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
2002Option Year 2 - Months 19-3012Months$18.56$222.70From Price Summary worksheet
FFP RSFMS Level I Preventive Maintenance Labor-Material-Supplies-Equipment
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
2003Option Year 2 - Months 19-301Lot$ 53,040.00$53,040.00From Price Summary worksheet
Cost Level II Maintenance NTE
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
2004Option Year 2 - Months 19-301Lot$132,600.00$132,600.00From Price Summary worksheet
Cost Level III Maintenance NTE
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
2005Option Year 2 - Months 19-301Lot$0.00$0.00
FFP CMRA Not Separately Priced
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
3001Option Year 3 - Months 31-4212Months$18.56$222.70From Price Summary worksheet
FFP RSFMS Custodial Labor-Material-Supplies-Equipment
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
3002Option Year 3 - Months 31-4212Months$18.56$222.70From Price Summary worksheet
FFP RSFMS Level I Preventive Maintenance Labor-Material-Supplies-Equipment
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
3003Option Year 3 - Months 31-421Lot$ 54,100.80$54,100.80From Price Summary worksheet
Cost Level II Maintenance NTE
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
3004Option Year 3 - Months 31-421Lot$135,252.00$135,252.00From Price Summary worksheet
FFP Level III Maintenance NTE
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
3005Option Year 3 - Months 31-421Lot$0.00$0.00
FFP CMRA Not Separately Priced
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
4001Option Year 4 - Months 43-5412Months$ 18.56$222.70From Price Summary worksheet
FFP RSFMS Custodial Labor-Material-Supplies-Equipment
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
4002Option Year 4 - Months 43-5412Months$18.56$222.70From Price Summary worksheet
FFP RSFMS Level I Preventive Maintenance Labor-Material-Supplies-Equipment
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
4003Option Year 4 - Months 43-541Lot$ 55,182.82$55,182.82From Price Summary worksheet
Cost Level II Maintenance NTE
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
4004Option Year 4 - Months 43-541Lot$137,957.04$137,957.04From Price Summary worksheet
Cost Level III Maintenance NTE
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
4005Option Year 4 - Months 43-541Lot$0.00$0.00
FFP CMRA Not Separately Priced
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
5001Option 52.217-8 Up to 6-Months 55-606Months$ 37.12$222.70From Price Summary worksheet
FFP RSFMS Custodial Labor-Material-Supplies-Equipment
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
5002Option 52.217-8 Up to 6-Months 55-606Months$37.12$222.70From Price Summary worksheet
FFP RSFMS Level I Preventive Maintenance Labor-Material-Supplies-Equipment
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
5003Option 52.217 Up to 6-months Months 55-606Months$4,598.57$27,591.41From Price Summary worksheet
Cost Level II Maintenance NTE
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
5004Option 52.217 Up to 6-months Months 55-606Months$11,496.42$68,978.52From Price Summary worksheet
Cost Level III Maintenance NTE
CLINSUPPLIES/SERVICESQUANTITYUNITUNIT PRICEAMOUNT
5003Option 52.217-8 Up to 6-Months 55-601Lot$0.00$0.00
FFP CMRA Not Separately Priced
Transition-in$4.20
Base Period$91,445.40
Option Year 1$182,445.40
Option Year 2$186,085.40
Option Year 3$189,798.20
Option Year 4$193,585.26
52.217-8$97,015.33
Total$940,379.19
Check$940,379.19From Price Summary worksheet

PRICE SUMMARY

Cost Detail Spreadsheet
Solicitation No W911W5-17-R-0002
Prime Contractor/Subcontractor Name/Division:
Period of Performance: Base; 4, 1-year Options; and up to 6-months Option FAR Clause 52.217-8
PRICE SUMMARY
Phase-In 30-dayBase Period (Months 1-6)Option1
(Months 7-18)Option 2
(Months 19-30)Option 3
(Months 31-42)Option 4 (Months 43-54)Option 52.217-8
(Months 55-60)Option 2 Period (months 25-36)
LABOR HOURSTotal
Labor & Subcontract Labor Phase-In Hours44Loaded RateHoursCostFrom Phase-IN & RSFMS Custodial Worksheet
RSFMS Custodial Labor & Subcontract Labor - Hours88888848From Phase-IN & RSFMS Custodial Worksheet
RSFMS Level I Maintenance Labor & Subcontract Labor - Hours88888848From RSFMS Level I
Phase-In, RSFMS Custodial and Level I Maintenance Total Labor Hours416161616161696
LABOR COSTS
Labor & Subcontract Labor - Phase-In Regular Hours$ 4.08$ 4.08From Phase-IN & RSFMS Custodial Worksheet
Labor & Subcontract Labor - Phase-In Profit$ 0.12$ 0.12From Phase-IN & RSFMS Custodial Worksheet
RSFMS Custodial Labor & Subcontract Labor - Hours$ 8.24$ 8.24$ 8.24$ 8.24$ 8.24$ 8.24$ 49.44From Phase-IN & RSFMS Custodial Worksheet
RSFMS Custodial Profit$ 0.24$ 0.24$ 0.24$ 0.24$ 0.24$ 0.24$ 1.44From Phase-IN & RSFMS Custodial Worksheet
RSFMS Level I Maintenance Labor & Subcontract Labor - Hours$ 8.24$ 8.24$ 8.24$ 8.24$ 8.24$ 8.24$ 49.44From RSFMS Level I
RSFMS Level I Maintenance Profit$ 0.24$ 0.24$ 0.24$ 0.24$ 0.24$ 0.24$ 1.44From RSFMS Level I
Total Labor Costs$ 4.20$ 16.96$ 16.96$ 16.96$ 16.96$ 16.96$ 16.96$ 105.96
RSFMS Custodial Material-Supplies-Equipment$ 212.10$ 212.10$ 212.10$ 212.10$ 212.10$ 212.10$ 1,272.60From Phase-IN & RSFMS Custodial Worksheet
Profit RSFMS Custodial Material-Supplies-Equipment$ 2.12$ 2.12$ 2.12$ 2.12$ 2.12$ 2.12$ 12.72From Phase-IN & RSFMS Custodial Worksheet
RSFMS Level I Maintenance Material-Supplies-Equipment$ 212.10$ 212.10$ 212.10$ 212.10$ 212.10$ 212.10$ 1,272.60From RSFMS Level I
Profit RSFMS Level I Material-Supplies-Equipment$ 2.12$ 2.12$ 2.12$ 2.12$ 2.12$ 2.12$ - 0$ 12.72From RSFMS Level I
Total Material-Supplies-Equipment$ 428.44$ 428.44$ 428.44$ 428.44$ 428.44$ 428.44$ 2,570.64ERROR:#REF!ERROR:#REF!
Level II Maintenance Not-To Exceed$26,000.00$52,000.00$53,040.00$54,100.80$55,182.82$27,591.41$267,915.03From RSFMS Level II
G&A Level II Maintenance$260.00$520.00$530.40$541.01$551.83$275.91$2,679.15From RSFMS Level II
Total Level II Maintenance$26,260.00$52,520.00$53,570.40$54,641.81$55,734.65$27,867.32$270,594.18
Level III Maintenance Not-To Exceed$65,000.00$130,000.00$132,600.00$135,252.00$137,957.04$68,978.52$669,787.56From RSFMS Level III
G&A Level III Maintenance$650.00$1,300.00$1,326.00$1,352.52$1,379.57$689.79$6,697.88From RSFMS Level III
Total Level III Maintenance$65,650.00$131,300.00$133,926.00$136,604.52$139,336.61$69,668.31$676,485.44
Total Evaluated Price$ 4.20$ 92,355.40$ 184,265.40$ 187,941.80$ 191,691.73$ 195,516.66$ 97,981.03$ - 0$ 949,756.22ERROR:#REF!
Award Price Less Level II & III G&A$ 4.20$ 91,445.40$ 182,445.40$ 186,085.40$ 189,798.20$ 193,585.26$ 97,015.33
Check
$ 949,756.22
Check
$ 940,379.19

Phase-In & RSFMS Custodial

Cost Detail Spreadsheet
Solicitation No W911W5-17-R-0002
Prime Contractor/Subcontractor Name/Division:
Period of Performance: Base; 4, 1-year Options; and up to 6-months Option FAR Clause 52.217-8LABOR - SUPPLIES - EQUIPMENT DETAIL
30-day Phase-In Period 4 Jul 17 - 3 Aug 17 CLIN 00011.00%2.00%3.00%
OCCUPATION TITLEEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col e=S, Enter Name of Subcontractor & Go to Col fHourly Base Pay Rate (Note 3 )Fringe/Overhead (Note 4)Rate Before Application Of Prime G&A & Profit (Note 5)G&ASubtotalProfitLoaded Productive Hour RateHours (Note-1)Total Price
abcdef=d + egh=f + gij=h + ikl=j X k
Enter P or S1.000.001.000.021.020.031.0511.05
Enter P or S1.000.001.000.021.020.031.0511.05
Enter P or S1.000.001.000.021.020.031.0511.05
Enter P or S1.000.001.000.021.020.031.0511.05
$ 4.00- 00.084.080.124.00$ 4.20
Base Period (months 1-6) CLIN 00021.00%2.00%3.00%
OCCUPATION TITLEEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col e=S, Enter Name of Subcontractor & Go to Col fHourly Base Pay Rate (Note 3 )Fringe/Overhead (Note 4)Rate Before Application Of Prime G&A & Profit (Note 5)G&ASubtotalProfitLoaded Productive Hour RateHoursTotal Price
abcdef=d + egh=f + gij=h + ikl=j X k
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
$ 8.000.080.168.240.248.00$ 8.48
Option Year 1 (months 7-18) CLIN 10011.00%2.00%3.00%
OCCUPATION TITLEEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col e=S, Enter Name of Subcontractor & Go to Col fHourly Base Pay Rate (Note 3 )Fringe/Overhead (Note 4)Rate Before Application Of Prime G&A & Profit (Note 5)G&ASubtotalProfitLoaded Productive Hour RateHoursTotal Price
abcdef=d + egh=f + gij=h + ikl=j X k
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
$ 8.000.080.168.240.248.00$ 8.48
Option 2 (months 25-36)
POSITON TITLESEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col e=S, Enter Name of Subcontractor & Go to Col fHourly Base Pay Rate (Note 3 )Fringe/Overhead (Note 4)Rate Before Application Of Prime G&A & Profit (Note 5)G&ASubtotalProfitLoaded Productive Hour RateTotal Hours (Do Not Change These Hours - Note 1)Total Price
abcdef=d + egh=f + gij=h + ikl=j X k
Off Site
0Enter P or S0.000.000.000.000.000.00- 0
0Enter P or S0.000.000.000.000.000.000.00- 0
0Enter P or S0.000.000.000.000.000.000.00- 0
0Enter P or S0.000.000.000.000.000.000.00- 0
ERROR:#REF!Enter P or S0.000.000.000.000.000.000.00- 0
ERROR:#REF!Enter P or S0.000.000.000.000.000.000.00- 0
Enter P or S0.000.000.000.000.000.000.00- 0
Enter P or S0.000.000.000.000.000.000.00- 0
Enter P or S0.000.000.000.000.000.000.00- 0
Enter P or S0.000.000.000.000.000.000.00- 0
Enter P or S0.000.000.000.000.000.000.00- 0
Enter P or S0.000.000.000.000.000.000.00- 0
$ - 0- 0- 0- 0- 0- 0$ - 0
Labor=ERROR:#DIV/0!
Fringe/OH=ERROR:#DIV/0!ERROR:#DIV/0!
G&A=ERROR:#DIV/0!ERROR:#DIV/0!
Profit=ERROR:#DIV/0!ERROR:#DIV/0!
Total=ERROR:#DIV/0!
Option Year 2 (months 19-30) CLIN 20011.00%2.00%3.00%
OCCUPATION TITLEEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col e=S, Enter Name of Subcontractor & Go to Col fHourly Base Pay Rate (Note 3 )Fringe/Overhead (Note 4)Rate Before Application Of Prime G&A & Profit (Note 5)G&ASubtotalProfitLoaded Productive Hour RateHoursTotal Price
abcgef=d + egh=f + gij=h + ikl=j X k
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
$ 8.000.080.168.240.248.00$ 8.48
Option Year 3 (months 31-42) CLIN 30011.00%2.00%3.00%
OCCUPATION TITLEEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col e=S, Enter Name of Subcontractor & Go to Col fHourly Base Pay Rate (Note 3 )Fringe/Overhead (Note 4)Rate Before Application Of Prime G&A & Profit (Note 5)G&ASubtotalProfitLoaded Productive Hour RateHoursTotal Price
abcgef=d + egh=f + gij=h + ikl=j X k
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
$ 8.000.080.168.240.248.00$ 8.48
Option Year 4 (months 43-54) CLIN 40011.00%2.00%3.00%
OCCUPATION TITLEEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col e=S, Enter Name of Subcontractor & Go to Col fHourly Base Pay Rate (Note 3 )Fringe/Overhead (Note 4)Rate Before Application Of Prime G&A & Profit (Note 5)G&ASubtotalProfitLoaded Productive Hour RateHoursTotal Price
abcgef=d + egh=f + gij=h + ikl=j X k
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
$ 8.000.080.168.240.248.00$ 8.48
FAR Clause 52.217-8 Up To 6-months (Months 55-60) CLIN 5001 Note-61.00%2.00%3.00%
OCCUPATION TITLEEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col e=S, Enter Name of Subcontractor & Go to Col fHourly Base Pay Rate (Note 3 )Fringe/Overhead (Note 4)Rate Before Application Of Prime G&A & Profit (Note 5)G&ASubtotalProfitLoaded Productive Hour RateProductive HoursTotal Price
abcgef=d + egh=f + gij=h + ikl=j X k
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
$ 8.000.080.168.240.248.00$ 8.48
Proposed Material-Supplies-Equipment for RSFMS Custodial Base Period CLIN 0002 Note-71.00%1.00%
NomenclatureQuantityCostPriceG&APrice + G&AProfitTotal
10$ 1.00$ 10.00$ 0.10$ 10.10$ 0.10$ 10.20
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
10$ 20.00$ 200.00$ 2.00$ 202.00$ 2.02$ 204.02
Total$ 212.10$ 2.12$ 214.22
Proposed Material-Supplies-Equipment for RSFMS Custodial Base Period CLIN 1001 Note-71.00%1.00%
NomenclatureQuantityCostPriceG&APrice + G&AProfitTotal
10$ 1.00$ 10.00$ 0.10$ 10.10$ 0.10$ 10.20
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
10$ 20.00$ 200.00$ 2.00$ 202.00$ 2.02$ 204.02
Total$ 212.10$ 2.12$ 214.22
Proposed Material-Supplies-Equipment for RSFMS Custodial Base Period CLIN 2001 Note-71.00%1.00%
NomenclatureQuantityCostPriceG&APrice + G&AProfitTotal
10$ 1.00$ 10.00$ 0.10$ 10.10$ 0.10$ 10.20
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
10$ 20.00$ 200.00$ 2.00$ 202.00$ 2.02$ 204.02
Total$ 212.10$ 2.12$ 214.22
Proposed Material-Supplies-Equipment for RSFMS Custodial Base Period CLIN 3001 Note-71.00%1.00%
NomenclatureQuantityCostPriceG&APrice + G&AProfitTotal
10$ 1.00$ 10.00$ 0.10$ 10.10$ 0.10$ 10.20
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
10$ 20.00$ 200.00$ 2.00$ 202.00$ 2.02$ 204.02
Total$ 212.10$ 2.12$ 214.22
Proposed Material-Supplies-Equipment for RSFMS Custodial Base Period CLIN 4001 Note-71.00%1.00%
NomenclatureQuantityCostPriceG&APrice + G&AProfitTotal
10$ 1.00$ 10.00$ 0.10$ 10.10$ 0.10$ 10.20
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
10$ 20.00$ 200.00$ 2.00$ 202.00$ 2.02$ 204.02
Total$ 212.10$ 2.12$ 214.22
Proposed Material-Supplies-Equipment for RSFMS Custodial Base Period CLIN 5001 Notes 6&71.00%1.00%
NomenclatureQuantityCostPriceG&APrice + G&AProfitTotal
10$ 1.00$ 10.00$ 0.10$ 10.10$ 0.10$ 10.20
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
10$ 20.00$ 200.00$ 2.00$ 202.00$ 2.02$ 204.02
Total$ 212.10$ 2.12$ 214.22

RSFMS Level I

Cost Detail Spreadsheet
Solicitation No W911W5-17-R-0002
Prime Contractor/Subcontractor Name/Division:
Period of Performance: Base; 4, 1-year Options; and up to 6-months Option FAR Clause 52.217-8LABOR - SUPPLIES - EQUIPMENT DETAIL
Base Period (months 1-6) CLIN 00031.00%2.00%3.00%
OCCUPATION TITLEEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col e=S, Enter Name of Subcontractor & Go to Col fHourly Base Pay Rate (Note 3 )Fringe/Overhead (Note 4)Rate Before Application Of Prime G&A & Profit (Note 5)G&ASubtotalProfitLoaded Productive Hour RateHoursTotal Price
abcdef=d + egh=f + gij=h + ikl=j X k
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
$ 8.000.080.168.240.248.00$ 8.48
Option Year 1 (months 7-18) CLIN 10021.00%2.00%3.00%
OCCUPATION TITLEEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col e=S, Enter Name of Subcontractor & Go to Col fHourly Base Pay Rate (Note 3 )Fringe/Overhead (Note 4)Rate Before Application Of Prime G&A & Profit (Note 5)G&ASubtotalProfitLoaded Productive Hour RateHoursTotal Price
abcdef=d + egh=f + gij=h + ikl=j X k
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
$ 8.000.080.168.240.248.00$ 8.48
Option 2 (months 25-36)
POSITON TITLESEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col e=S, Enter Name of Subcontractor & Go to Col fHourly Base Pay Rate (Note 3 )Fringe/Overhead (Note 4)Rate Before Application Of Prime G&A & Profit (Note 5)G&ASubtotalProfitLoaded Productive Hour RateTotal Hours (Do Not Change These Hours - Note 1)Total Price
abcdef=d + egh=f + gij=h + ikl=j X k
Off Site
0Enter P or S0.000.000.000.000.000.00- 0
0Enter P or S0.000.000.000.000.000.000.00- 0
0Enter P or S0.000.000.000.000.000.000.00- 0
0Enter P or S0.000.000.000.000.000.000.00- 0
ERROR:#REF!Enter P or S0.000.000.000.000.000.000.00- 0
ERROR:#REF!Enter P or S0.000.000.000.000.000.000.00- 0
Enter P or S0.000.000.000.000.000.000.00- 0
Enter P or S0.000.000.000.000.000.000.00- 0
Enter P or S0.000.000.000.000.000.000.00- 0
Enter P or S0.000.000.000.000.000.000.00- 0
Enter P or S0.000.000.000.000.000.000.00- 0
Enter P or S0.000.000.000.000.000.000.00- 0
$ - 0- 0- 0- 0- 0- 0$ - 0
Labor=ERROR:#DIV/0!
Fringe/OH=ERROR:#DIV/0!ERROR:#DIV/0!
G&A=ERROR:#DIV/0!ERROR:#DIV/0!
Profit=ERROR:#DIV/0!ERROR:#DIV/0!
Total=ERROR:#DIV/0!
Option Year 2 (months 19-30) CLIN 20021.00%2.00%3.00%
OCCUPATION TITLEEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col e=S, Enter Name of Subcontractor & Go to Col fHourly Base Pay Rate (Note 3 )Fringe/Overhead (Note 4)Rate Before Application Of Prime G&A & Profit (Note 5)G&ASubtotalProfitLoaded Productive Hour RateHoursTotal Price
abcgef=d + egh=f + gij=h + ikl=j X k
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
$ 8.000.080.168.240.248.00$ 8.48
Option Year 3 (months 31-42) CLIN 30021.00%2.00%3.00%
OCCUPATION TITLEEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col e=S, Enter Name of Subcontractor & Go to Col fHourly Base Pay Rate (Note 3 )Fringe/Overhead (Note 4)Rate Before Application Of Prime G&A & Profit (Note 5)G&ASubtotalProfitLoaded Productive Hour RateHoursTotal Price
abcgef=d + egh=f + gij=h + ikl=j X k
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
$ 8.000.080.168.240.248.00$ 8.48
Option Year 4 (months 43-54) CLIN 40021.00%2.00%3.00%
OCCUPATION TITLEEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col e=S, Enter Name of Subcontractor & Go to Col fHourly Base Pay Rate (Note 3 )Fringe/Overhead (Note 4)Rate Before Application Of Prime G&A & Profit (Note 5)G&ASubtotalProfitLoaded Productive Hour RateHoursTotal Price
abcgef=d + egh=f + gij=h + ikl=j X k
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
$ 8.000.080.168.240.248.00$ 8.48
FAR Clause 52.217-8 Up To 6-months (Months 55-60) CLIN 5002 Note-61.00%2.00%3.00%
OCCUPATION TITLEEffort To Be Performed By The Prime (P) or Subcontractor (S)? (Note 2)If Col e=S, Enter Name of Subcontractor & Go to Col fHourly Base Pay Rate (Note 3 )Fringe/Overhead (Note 4)Rate Before Application Of Prime G&A & Profit (Note 5)G&ASubtotalProfitLoaded Productive Hour RateProductive HoursTotal Price
abcgef=d + egh=f + gij=h + ikl=j X k
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
Enter P or S1.000.011.010.021.030.031.0611.06
$ 8.000.080.168.240.248.00$ 8.48
Proposed Material-Supplies-Equipment for RSFMS Level I Preventive Maintenance Base Period CLIN 0003 Note-71.00%1.00%
Nomenclature, System UseQuantityCostPriceG&APrice &G&AProfitTotal
10$ 1.00$ 10.00$ 0.10$ 10.10$ 0.10$ 10.20
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
10$ 20.00$ 200.00$ 2.00$ 202.00$ 2.02$ 204.02
Total$ 212.10$ 2.12$ 214.22
Proposed Material-Supplies-Equipment for RSFMS Level I Preventive Maintenance Option Year 1 CLIN 1002 Note-71.00%1.00%
Nomenclature, System UseQuantityCostPriceG&APrice &G&AProfitTotal
10$ 1.00$ 10.00$ 0.10$ 10.10$ 0.10$ 10.20
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
10$ 20.00$ 200.00$ 2.00$ 202.00$ 2.02$ 204.02
Total$ 212.10$ 2.12$ 214.22
Proposed Material-Supplies-Equipment for RSFMS Level I Preventive Maintenance Option Year 2 CLIN 2002 Note-71.00%1.00%
Nomenclature, System UseQuantityCostPriceG&APrice &G&AProfitTotal
10$ 1.00$ 10.00$ 0.10$ 10.10$ 0.10$ 10.20
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
10$ 20.00$ 200.00$ 2.00$ 202.00$ 2.02$ 204.02
Total$ 212.10$ 2.12$ 214.22
Proposed Material-Supplies-Equipment for RSFMS Level I Preventive Maintenance Option Year 3 CLIN 3002 Note-71.00%1.00%
Nomenclature, System UseQuantityCostPriceG&APrice &G&AProfitTotal
10$ 1.00$ 10.00$ 0.10$ 10.10$ 0.10$ 10.20
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
10$ 20.00$ 200.00$ 2.00$ 202.00$ 2.02$ 204.02
Total$ 212.10$ 2.12$ 214.22
Proposed Material-Supplies-Equipment for RSFMS Level I Preventive Maintenance Option Year 4 CLIN 4002 Note-71.00%1.00%
Nomenclature, System UseQuantityCostPriceG&APrice &G&AProfitTotal
10$ 1.00$ 10.00$ 0.10$ 10.10$ 0.10$ 10.20
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
10$ 20.00$ 200.00$ 2.00$ 202.00$ 2.02$ 204.02
Total$ 212.10$ 2.12$ 214.22
Proposed Material-Supplies-Equipment for RSFMS Level I Preventive Maintenance 52.217-8 CLIN 5002 Note-71.00%1.00%
Nomenclature, System UseQuantityCostPriceG&APrice &G&AProfitTotal
10$ 1.00$ 10.00$ 0.10$ 10.10$ 0.10$ 10.20
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
10$ 20.00$ 200.00$ 2.00$ 202.00$ 2.02$ 204.02
Total$ 212.10$ 2.12$ 214.22

RSFM Level II

Cost Detail Spreadsheet
Solicitation No W911W5-17-R-0002
Prime Contractor/Subcontractor Name/Division:
Period of Performance: Base; 4, 1-year Options
RSFMS LEVEL II COST DETAIL
1.00%
CLINRSFMS LevelNormalized Sum (Note 8)G&A RateBurdened G&A
abcd = b X ce=c + d
CLIN 0004 Base Period (months 1-6)RSFM Level II Maintenance$26,000.00$260.00$26,260.00
CLIN 1003 Option Year 1 (months 7-18)RSFM Level II Maintenance$52,000.00$520.00$52,520.00
CLIN 2003 Option Year 2 (months 19-30)RSFM Level II Maintenance$53,040.00$530.40$53,570.40
CLIN 3003 Option Year 3 (months 31-42)RSFM Level II Maintenance$54,100.80$541.01$54,641.81
CLIN 4003 Option Year 4 (months 43-54)RSFM Level II Maintenance$55,182.82$551.83$55,734.65
CLIN 5003 Clause 52.217-8 (months 55-60)RSFM Level II Maintenance$27,591.41$275.91$27,867.32

RSFM Level III

Cost Detail Spreadsheet
Solicitation No W911W5-17-R-0002
Prime Contractor/Subcontractor Name/Division:
Period of Performance: Base; 4, 1-year Options
RSFMS Level IIII COST DETAIL
1.00%
CLINRSFMS LevelNormalized Sum (Note 8)G&A RateBurdened G&A
abcd = b X ce=c + d
CLIN 0005 Base Period (months 1-6)RSFM Level III Maintenance$65,000.00$650.00$65,650.00
CLIN 1004 Option Year 1 (months 7-18)RSFM Level III Maintenance$130,000.00$1,300.00$131,300.00
CLIN 2004 Option Year 2 (months 19-30)RSFM Level III Maintenance$132,600.00$1,326.00$133,926.00
CLIN 3004 Option Year 3 (months 31-42)RSFM Level III Maintenance$135,252.00$1,352.52$136,604.52
CLIN 4004 Option Year 4 (months 43-54)RSFM Level III Maintenance$137,957.04$1,379.57$139,336.61
CLIN 5004 Clause 52.217-8 (months 55-60)RSFM Level III Maintenance$68,978.52$689.79$69,668.31

INDIRECT RATE SUMMARY

Cost Detail Spreadsheet
Solicitation No W911W5-17-R-0002
Prime Contractor/Subcontractor Name/Division:
Period of Performance: Base; 4, 1-year Options; and up to 6-months Option FAR Clause 52.217-8
SUMMARY OF PROPOSED INDIRECT RATES
Enter Whether Subcontract Is Cost Reimbursable (i.e. CPFF, etc) or Time and Material (T&M)FRINGE RATEOVERHEAD RATEG&A RATEPROPOSED PROFIT RATE% OF EFFORT PERFORMED BY PRIME AND SUBS BASED ON LABOR HOURS
Base Period
PRIME CONTRACTORn/a0%0%0%0%0%
SUBCONTRACTOR 10%0%0%0%0%
SUBCONTRACTOR 20%0%0%0%0%
SUBCONTRACTOR 30%0%0%0%0%
ETC0%0%0%0%0%
0%(i.e. 100%)
YEAR 1
PRIME CONTRACTORn/a0%0%0%0%0%
SUBCONTRACTOR 10%0%0%0%0%
SUBCONTRACTOR 20%0%0%0%0%
SUBCONTRACTOR 30%0%0%0%0%
ETC0%0%0%0%0%
0%(i.e. 100%)
YEAR 2
PRIME CONTRACTORn/a0%0%0%0%0%
SUBCONTRACTOR 10%0%0%0%0%
SUBCONTRACTOR 20%0%0%0%0%
SUBCONTRACTOR 30%0%0%0%0%
ETC0%0%0%0%0%
0%(i.e. 100%)
YEAR 3
PRIME CONTRACTORn/a0%0%0%0%0%
SUBCONTRACTOR 10%0%0%0%0%
SUBCONTRACTOR 20%0%0%0%0%
SUBCONTRACTOR 30%0%0%0%0%
ETC0%0%0%0%0%
0%(i.e. 100%)
YEAR 4
PRIME CONTRACTORn/a0%0%0%0%0%
SUBCONTRACTOR 10%0%0%0%0%
SUBCONTRACTOR 20%0%0%0%0%
SUBCONTRACTOR 30%0%0%0%0%
ETC0%0%0%0%0%
0%(i.e. 100%)
Please enter corresponding indirect rates for the prime and each subcontractor for each of the periods.
Subcontractors may provide data separately in the above format for proprietary reasons.
Provide the necessary narrative describing how the rates were derived and applied, the composition of the
allocation pools & bases, and provide any supporting forward rate agreements and DCAA/DCMA agreements/reports.
If rates proposed are other than based on actuals or actual budgets describe why.
Sample Fringe/Overhead and G&A worksheet schedules follow this tab.

Sample Fringe-OH Worksheet

DIRECT LABOR FRINGE/OVERHEAD RATE

Company, Inc.
Anycity, USA
Proposal Submitted In Response to XXXXX
DIRECT LABOR FRINGE/OVERHEAD RATE
FY2012EstimatedEstimated
Overhead Expenses:ActualYear 1Year 2
Indirect payroll$ - 0$ - 0$ - 0
Payroll taxes (FICA, FUTA, SUTA, Workmans Comp)$ 12,000.00$ 11,000.00$ 10,000.00
Vacation (PTO)$ 12,000.00$ 11,000.00$ 10,000.00
Holiday$ - 0$ - 0$ - 0
Sick Leave$ 600.00$ 600.00$ 600.00
Health/Disability Ins$ 7,000.00$ 7,000.00$ 7,000.00
Workmans Compensation/Defense Base Act$ 4,000.00$ 4,000.00$ 4,000.00
Bonuses$ 1,000.00$ 1,000.00$ 1,000.00
Retention Pay$ 2,000.00$ 1,000.00$ 1,000.00
401k Match$ 4,000.00$ 3,500.00$ 3,000.00
Mil Leave$ 100.00$ 100.00$ 100.00
Breavement$ 100.00$ 200.00$ 200.00
Insurance$ 200.00$ 200.00$ 200.00
Total Pool$ 43,000.00$ 39,600.00$ 37,100.00
Less: FAR 31 Unallowable Cost
Entertainment, etc.
Net Allowable cost$ 43,000.00$ 39,600.00$ 37,100.00
Labor Base
Direct Labor$ 113,500.00$ 100,000.00$ 90,000.00
OH Labor$ 4,352.00$ 4,200.00$ 4,100.00
B&P Labor$ 1,200.00$ 1,100.00$ 1,100.00
Total Labor Base$ 119,052.00$ 105,300.00$ 95,200.00

Rate 36.12% 37.61% 38.97%

This exhibit shows a combined fringe benefit/overhead allocation. However the offeror may in actuality have separate
allocations for fringe benefits and overhead depending on its accounting system.
Please provide any FPRAs/FPRRs/Rate Agreements to corroborate proposed rates.

Sample G&A Worksheet

GENERAL & ADMINISTRATIVE (G&A) EXPENSE

Company, Inc
Yourcity, USA
Proposal Submitted In Response to Letter Request for Proposal
GENERAL & ADMINISTRATIVE (G&A) EXPENSE RATE
FY2012EstimatedEstimated
G&A Expenses:ActualYear 1Year 2
Labor11,000.0011,000.0011,000.00
Fringe2,700.002,700.002,600.00
Subscriptions85.0085.0085.00
Postage45.0045.0045.00
Printing16.0016.0016.00
Supplies101.00100.00100.00
Telephone334.00334.00334.00
Travel675.00650.00625.00
Misc118.00110.00105.00
Training294.00270.00260.00
Recruiting87.0087.0087.00
Maint125.00125.00125.00
Equip265.00265.00265.00
Consultants35.0035.0035.00
Prof fees573.00570.00570.00
Filings300.00300.00300.00
Legal275.00275.00275.00
Total G&A17,028.0016,967.0016,827.00
Less: FAR 31 Unallowable Costs
Interest
Contributions
Advertising, etc.
Total Unallowable Costs0.000.000.00
G&A Pool After Deducting Unallowable Cost17,028.0016,967.0016,827.00
Allocation Base
Direct Labor$240,000.00$239,000.00$238,000.00
Fringe$82,000.00$81,000.00$80,000.00
Overhead (including any unallowable cost)$33,500.00$33,400.00$33,300.00
Other Direct Costs (including any unallowable cost)$373,000.00$372,000.00$371,000.00

Total G&A Allocation Base $728,500.00 $725,400.00 $722,300.00

Rate 2.30% 2.30% 2.30%

Please provide any FPRAs/FPRRs/Rate Agreements to corroborate proposed rates.

Microsoft_Word_Document1.docx

INSTRUCTIONS

General: Offeror is to provide a cost/price proposal in response to the solicitation. FAR 15.403-5(b) allows the contracting officer to specify the format of cost or pricing data or data other than certified cost or pricing data. The completed enclosed spreadsheets shall be included in the cost/price proposal. This is a required flow down requirement to subcontractors, and therefore shall be submitted for the prime offeror AND for any and all divisions and subcontractors proposed to perform effort in response to this solicitation. The information will be evaluated for acceptability, fairness, and reasonableness based on the price analysis criteria in FAR 15.404-1 as determined appropriate by the Contracting Officer as described in Section M. Please enter the requested data in the light blue shaded areas in the following worksheets: Transition-In & RSFMS Custodial, RSFMS Level I, and RSFMS Level II & III, and Indirect Rate Summary spreadsheets. The worksheets are designed to automatically compute and populate other cells in the Excel spreadsheet and worksheets.

Section B Workheet: The Section B is used as a basis for the proposed formal Section B.

Labor – Worksheets Phase-In & RSFMS Custodial and RSFMS Level I Maintenance:

General: Enter the requested data in the blue shaded cells. It may be necessary for offeror to revise the number of rows, columns, and/or formulas to reflect differences or nuances in the offeror's accounting and estimating systems. However, it is requested that the general format be maintained as much as possible for cost/price analysis and contract administration purposes.

NOTE 1: Each offeror is to propose productive hours to meet the requirement. Enter hours in column k.

NOTE 2: Columns A, B, and C of the Transition-In & RSFMS Custodial Worksheet is where labor costs are entered. Column A enter the Wage Determination Occupation title. If labor occupation is wage determination exempt add reason (supervisory or administrative). During contract performance these categories ostensibly may be performed by the prime contractor and/or other divisions or subcontractors. The offeror is to enter a P in Col B if the effort is to be performed by the prime contractor, and an S if performed by another division or subcontractor. Enter the name of the division or contractor in Col C. If the particular individual category is to be performed jointly by more than one entity (i.e. the prime and a sub or subs), the offeror will be required to insert additional row(s) under the labor category and to allocate the Col k hours for the individual category to be performed among the prime and subs . After this allocation, the total of the original and inserted rows under the individual category in Col K shall total to the number of hours provided by the Govt for the respective labor category.

NOTE 3: Please enter the base labor rate for the labor categories listed. The base labor rate is the rate actual paid to the employee EXCLUSIVE of social security, federal unemployment, state unemployment, workman's compensation, and non-statutory fringe benefits (i.e. 401K, vacations, holidays, etc), overhead, G&A, and fee. For proprietary reason, subcontractors may provide this information directly to the Contracting Officer if the subcontractor chooses not to disclose this information to the offeror.

NOTE 4: Additional entry cells at the top have…

This is the start of the file's text. The full file is on GovTribe.

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