Attachment L-6c__CNSSD_Africa I Regional_Template_DB.xlsx

XLSX spreadsheet 89 KB Posted

Attached to
Counter Nuclear Smuggling System Deployment (CNSSD) Federal contract opportunity
Solicitation number
89233123RNA000175
Issued by
Department of Energy National Nuclear Security Administration

View the file

Other files for this federal contract opportunity

Other files attached to Counter Nuclear Smuggling System Deployment (CNSSD), newest first.
File Type Posted
AMENDMENT__CNSSD RFP__89233123RNA000175_0003__1 June 2023.pdf PDF
Attachment L-6b__CNSSD_NigerGrp1_Template_May15_Rev.1.xlsx XLSX spreadsheet
Attachment L-6c__CNSSD_Africa I Regional_Template_May15_Rev.1.xlsx XLSX spreadsheet
AMENDMENT__CNSSD RFP__89233123RNA000175_0002__18 May 2023.pdf PDF
Attachment 2_Reporting Requirements Checklist (rev 05152023).pdf PDF
Attachment 5__FINAL CNSSD RFP Q-A RESPONSES.pdf PDF
Attachment L-4a Africa I Regional SOW (revision 05152023).pdf PDF
Attachment L-5 - CNSSD Past Performance Questionnaire (PPQ) 5.15.23__Rev1.doc DOC document
Attachment L-1b Relevant Corporate Experience Summary Matrix FINAL.docx DOCX document
Attachment L-4b Africa I WA 001 FINAL.pdf PDF
Attachment L-5 - CNSSD Past Performance Questionnaire (PPQ).doc DOC document
Attachment L-6a__CNSSD_PM_Templatev2.xlsx XLSX spreadsheet
Attachment 2__Reporting Requirements Checklist.pdf PDF
Attachment 4__Draft RFP Questions and Responses.xlsx XLSX spreadsheet
Attachment L-1a Relevant Corporate Experience Form FINAL.docx DOCX document
Attachment L-2a - Key Personnel Resume Elements FINAL.docx DOCX document
Attachment L-4a Africa I Regional SOW FINAL.pdf PDF
AMENDMENT__CNSSD RFP__89233123RNA000175_0001__02 May 2023.pdf PDF
Attachment L-3 CNSSD Scenario Map FINAL.pptx PPTX presentation
Attachment L-4c NEG1 Deployment Requirements FINAL.pdf PDF
Attachment L-6b__CNSSD_NigerGrp1_Template_DB.xlsx XLSX spreadsheet
Attachment L-7__PREAWARD SURVEY OF PROSPECTIVE CONTRACTOR__SF1408.pdf PDF
FINAL CNSSD RFP__89233123RNA000175__01 May 2023.pdf PDF
Attachment 1_CNSDD Master SOW FINAL.pdf PDF
Attachment L-2b - Letter of Commitment FINAL (1).pdf PDF
Attachment 3 CNSSD Program Manager Task Order SOW.pdf PDF
Show all 26

On GovTribe

Work with this file on GovTribe

  • 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.

Africa I-Summary

Contractor Name:
Initial Task Order: Africa I - Summary
COMPLETE YELLOW HIGHLIGHTED AREAS WITHIN SUMMARY TAB
POINT OF ENTRY (POE)Base PeriodOPTION 1OPTION 2OPTION 3OPTION 4OPTION 5OPTION 6Option to Extend ServicesTOTAL
Escalation0%0%0%0%0%0%0%
Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fee$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Quantity111111118
Total POE$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
NON POINT OF ENTRY (NON-POE)Base PeriodOPTION 1OPTION 2OPTION 3OPTION 4OPTION 5OPTION 6Option to Extend ServicesTOTAL
Escalation0%0%0%0%0%0%0%
Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fee$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Quantity2334433123
Total NON-POE$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
GRAND TOTAL AFRICA I REGIONAL LINE ITEMBase PeriodOPTION 1OPTION 2OPTION 3OPTION 4OPTION 5OPTION 6Option to Extend ServicesTOTAL
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

CUI//SP-PROCURE/SP-SSEL/SP-PROPIN

CFYSUMMARY-POE-Table 1a

Contractor Name:NOTE: LABOR CATEGORIES, SUBCONTRACTS, TYPES OF COSTS, BASES AND RATES IN TABLE 1 ARE FOR ILLUSTRATION PURPOSES ONLY.
Initial Task Order: Africa I - Point of Entry Line ItemPROPOSE ALL COSTS IN ACCORDANCE WITH YOUR ESTABLISHED ACCOUNTING AND ESTIMATING PRACTICES.
TABLE 1a
COST ELEMENT SUMMARY
CONTRACTOR FISCAL YEAR (CFY) 1CFY 2TOTAL
PROPOSEDPROPOSEDPROPOSED
COST ELEMENTBASERATEAMOUNTBASERATEAMOUNTBASEAMOUNT
DIRECT LABORLabor HoursLabor HoursLabor Hours
LABOR CATEGORY 10$ - 0$ - 00$ - 0$ - 00$ - 0
LABOR CATEGORY 20$ - 0$ - 00$ - 0$ - 00$ - 0
LABOR CATEGORY 30$ - 0$ - 00$ - 0$ - 00$ - 0
LABOR CATEGORY 40$ - 0$ - 00$ - 0$ - 00$ - 0
ETC.0$ - 0$ - 00$ - 0$ - 00$ - 0
TOTAL DIRECT LABOR0$ - 00$ - 00$ - 0
FRINGE BENEFITS$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 0
LABOR OVERHEAD$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 0
SUBTOTAL INDIRECT LABOR EXPENSE$ - 0$ - 0$ - 0
SUBCONTRACTS/CONSULTANTS/INTERCOMPANY
SUB-1 (See Sub Cost Proposal)$ - 0$ - 0$ - 0
SUB-2 (See Sub Cost Proposal)$ - 0$ - 0$ - 0
SUB-3 (See Sub Cost Proposal)$ - 0$ - 0$ - 0
OTHER SUBCONTRACTS$ - 0$ - 0$ - 0
INTERCOMPANY$ - 0$ - 0$ - 0
TOTAL SUBCONTRACTS/CONSULTANTS/INTERCOMPANY$ - 0$ - 0$ - 0

MATERIALS/EQUIPMENT (See Material- Tbl 3) $ - 0 $ - 0 $ - 0

OTHER DIRECT COSTS
TRAVEL (See Travel - Tbl 4 )$ - 0$ - 0$ - 0
ODC's (See ODC's - Tbl 5)$ - 0$ - 0$ - 0

TOTAL ODC'S $ - 0 $ - 0 $ - 0

SUBTOTAL $ - 0 $ - 0 $ - 0

G&A $ - 0 0.00% $ - 0 $ - 0 0.00% $ - 0 $ - 0

TOTAL COSTS $ - 0 $ - 0 $ - 0

FIXED FEE/PROFIT $ - 0 0.00% $ - 0 $ - 0 0.00% $ - 0 $ - 0

TOTAL PRICE $ - 0 $ - 0 $ - 0

CUI//SP-PROCURE/SP-SSEL/SP-PROPIN

SUB-IOTs - Table 2

Contractor Name:
Initial Task Order: Africa I - Point of Entry/Non Point of Entry Line Item
TABLE 2
SUBCONTRACTS/INTERCOMPANY TRANSFERS/CONSULTANTS
PRICE SUMMARY
SUBCONTRACTOR NAMESUBCONTRACT TASKSPOE/NON-POECFY (if more than 1 CFY proposedSUBCONTRACT CONTRACT TYPEBASIS OF PROPOSED PRICE*SUBCONTRACT PRICE PROPOSED BY PRIME
Explanatory Notes:
*Attach supporting pricing information sufficient to justify the reasonableness of the proposed price. See FAR 15.404-3.

CUI//SP-PROCURE/SP-SSEL/SP-PROPIN

CFYSummary-nonPOE-Table1b

Contractor Name:NOTE: LABOR CATEGORIES, SUBCONTRACTS, TYPES OF COSTS, BASES AND RATES IN TABLE 1 ARE FOR ILLUSTRATION PURPOSES ONLY.
Initial Task Order: Africa I - Non Point of Entry Line ItemPROPOSE ALL COSTS IN ACCORDANCE WITH YOUR ESTABLISHED ACCOUNTING AND ESTIMATING PRACTICES.
TABLE 1b
COST ELEMENT SUMMARY
CONTRACTOR FISCAL YEAR (CFY) 1CFY 2TOTAL
PROPOSEDPROPOSEDPROPOSED
COST ELEMENTBASERATEAMOUNTBASERATEAMOUNTBASEAMOUNT
DIRECT LABORLabor HoursLabor HoursLabor Hours
LABOR CATEGORY 10$ - 0$ - 00$ - 0$ - 00$ - 0
LABOR CATEGORY 20$ - 0$ - 00$ - 0$ - 00$ - 0
LABOR CATEGORY 30$ - 0$ - 00$ - 0$ - 00$ - 0
LABOR CATEGORY 40$ - 0$ - 00$ - 0$ - 00$ - 0
ETC.0$ - 0$ - 00$ - 0$ - 00$ - 0
TOTAL DIRECT LABOR0$ - 00$ - 00$ - 0
FRINGE BENEFITS$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 0
LABOR OVERHEAD$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 0
SUBTOTAL INDIRECT LABOR EXPENSE$ - 0$ - 0$ - 0
SUBCONTRACTS/CONSULTANTS/INTERCOMPANY
SUB-1 (See Sub Cost Proposal)$ - 0$ - 0$ - 0
SUB-2 (See Sub Cost Proposal)$ - 0$ - 0$ - 0
SUB-3 (See Sub Cost Proposal)$ - 0$ - 0$ - 0
OTHER SUBCONTRACTS$ - 0$ - 0$ - 0
INTERCOMPANY$ - 0$ - 0$ - 0
TOTAL SUBCONTRACTS/CONSULTANTS/INTERCOMPANY$ - 0$ - 0$ - 0

MATERIALS/EQUIPMENT (See Material- Tbl 3) $ - 0 $ - 0 $ - 0

OTHER DIRECT COSTS
TRAVEL (See Travel - Tbl 4 )$ - 0$ - 0$ - 0
ODC's (See ODC's - Tbl 5)$ - 0$ - 0$ - 0

TOTAL ODC'S $ - 0 $ - 0 $ - 0

SUBTOTAL $ - 0 $ - 0 $ - 0

G&A $ - 0 0.00% $ - 0 $ - 0 0.00% $ - 0 $ - 0

TOTAL COSTS $ - 0 $ - 0 $ - 0

FIXED FEE/PROFIT $ - 0 0.00% $ - 0 $ - 0 0.00% $ - 0 $ - 0

TOTAL PRICE $ - 0 $ - 0 $ - 0

CUI//SP-PROCURE/SP-SSEL/SP-PROPIN

Material - Table 3

Contractor Name:
Initial Task Order: Africa I - Point of Entry/Non Point of Entry Line Item
TABLE 3

MATERIAL/EQUIPMENT

AFRICA I REGIONAL - Point of Entry

ItemCFY (if more than 1 CFY proposedDescription of MaterialQtyUnit of IssueUnit PriceTotal PriceManufacturerVendor/SourcePurchase LocationWarrantyBasis of EstimateVAT ExemptionCurrency of Estimate
1Self Explantory0ea.$0.00$0Company NameCountry Name# of yrsPurchase OrderY/NDate of Purchase Order,
20hrs$0.00$0Website URLQuoteQuote, Catalog, Invoice,
30$0.00$0Etc.Engineering Estimateetc. (Explain how price
40$0.00$0Catalog Pricewas derived if not same
50$0.00$0Invoiceas catalog, invoice, etc.)
60$0.00$0Etc.
70$0.00$0
80$0.00$0
90$0.00$0
100$0.00$0
110$0.00$0
120$0.00$0
130$0.00$0
140$0.00$0
150$0.00$0
160$0.00$0
170$0.00$0
180$0.00$0
190$0.00$0
200$0.00$0
210$0.00$0
Subtotal Materials$0
AFRICA I REGIONAL - Non Point of Entry
ItemCFY (if more than 1 CFY proposedDescription of MaterialQtyUnit of IssueUnit PriceTotal PriceManufacturerVendor/SourcePurchase LocationWarrantyBasis of EstimateVAT ExemptionCurrency of Estimate
1Self Explantory0ea.$0.00$0Company NameCountry Name# of yrsPurchase OrderY/NDate of Purchase Order,
20hrs$0.00$0Website URLQuoteQuote, Catalog, Invoice,
30$0.00$0Etc.Engineering Estimateetc. (Explain how price
40$0.00$0Catalog Pricewas derived if not same
50$0.00$0Invoiceas catalog, invoice, etc.)
60$0.00$0Etc.
70$0.00$0
80$0.00$0
90$0.00$0
100$0.00$0
110$0.00$0
120$0.00$0
130$0.00$0
140$0.00$0
150$0.00$0
160$0.00$0
170$0.00$0
180$0.00$0
190$0.00$0
200$0.00$0
210$0.00$0

Subtotal Materials $0

CUI//SP-PROCURE/SP-SSEL/SP-PROPIN

Travel - Table 4

Contractor Name:
Initial Task Order: Africa I - Point of Entry/Non Point of Entry Line Item
TABLE 4
AFRICA I - POINT OF ENTRY
FROM ___________
NumberNumberNumberNumberPer DiemPer DiemCar
CFYTRIPSTRVLRSDAYSNIGHTSAIRMEALSLODGINGRentalMISC.TOTAL
Destination 10000$0$0$0.00$0.00
trip costs$0$0$0$0$0$0
Destination 20000$0$0$0.00$0.00
trip costs$0$0$0$0$0$0
Destination 30000$0$0$0.00$0.00
trip costs$0$0$0$0$0$0
Destination 40000$0$0$0.00$0.00
trip costs$0$0$0$0$0$0
Destination 50000$0$0$0.00$0.00
trip costs$0$0$0$0$0$0
Destination 60000$0$0$0.00$0.00
trip costs$0$0$0$0$0$0
Destination 70000$0$0$0.00$0.00
trip costs$0$0$0$0$0$0
Destination 80000$0$0$0.00$0.00
trip costs$0$0$0$0$0$0
Destination 90000$0$0$0.00$0.00
trip costs$0$0$0$0$0$0
Destination 100000$0$0$0.00$0.00
trip costs$0$0$0$0$0$0
TOTAL$0
FROM ___________AFRICA I - NON POINT OF ENTRY
NumberNumberNumberNumberPer DiemPer DiemCar
CFYTRIPSTRVLRSDAYSNIGHTSAIRMEALSLODGINGRentalMISC.TOTAL
Destination 10000$0$0$0.00$0.00
trip costs$0$0$0$0$0$0
Destination 20000$0$0$0.00$0.00
trip costs$0$0$0$0$0$0
Destination 30000$0$0$0.00$0.00
trip costs$0$0$0$0$0$0
Destination 40000$0$0$0.00$0.00
trip costs$0$0$0$0$0$0
Destination 50000$0$0$0.00$0.00
trip costs$0$0$0$0$0$0
Destination 60000$0$0$0.00$0.00
trip costs$0$0$0$0$0$0
Destination 70000$0$0$0.00$0.00
trip costs$0$0$0$0$0$0
Destination 80000$0$0$0.00$0.00
trip costs$0$0$0$0$0$0
Destination 90000$0$0$0.00$0.00
trip costs$0$0$0$0$0$0
Destination 100000$0$0$0.00$0.00
trip costs$0$0$0$0$0$0
TOTAL$0

CUI//SP-PROCURE/SP-SSEL/SP-PROPIN

ODC's - Table 5

Contractor Name:
Initial Task Order: Africa I Task Order - Point of Entry/Non Point of Entry Line Item
TABLE 5
AFRICA I - POINT OF ENTRY
Item #CFY (if more than 1 CFY proposedDescriptionUnit of MeasureQtyUnit PriceTotalBasis of Estimate + WBS Requirement
exampleInternational Cell PhonePer Minute600$2.99$1,794.00Cellular phone charges based on per min (60 min usage per day) while in country for 2 people. Quote in back-up (60 min x 5 days x 2 people = 600 min)
1$0.00
2$0.00
3$0.00
4$0.00
5$0.00
6$0.00
7$0.00
8$0.00
9$0.00
10$0.00
11$0.00
12$0.00
13$0.00
14$0.00
15$0.00
16$0.00
17$0.00
18$0.00
19$0.00
20$0.00
Subtotal$0.00
AFRICA I - NON POINT OF ENTRY
Item #CFY (if more than 1 CFY proposedDescriptionUnit of MeasureQtyUnit PriceTotalBasis of Estimate + WBS Requirement
exampleInternational Cell PhonePer Minute300$2.99$897.00Cellular phone charges based on per min (60 min usage per day) while in country for x people. Quote in back-up
1$0.00
2$0.00
3$0.00
4$0.00
5$0.00
6$0.00
7$0.00
8$0.00
9$0.00
10$0.00
11$0.00
12$0.00
13$0.00
14$0.00
15$0.00
16$0.00
17$0.00
18$0.00
19$0.00
20$0.00
Subtotal$0.00

CUI//SP-PROCURE/SP-SSEL/SP-PROPIN

DPLH - Table 6

Company Name:
Initial Task Order: Africa I - Point of Entry/Non Point of Entry Line Item
TABLE 6
DIRECT PRODUCTIVE LABOR HOUR (DPLH) DETAIL
DPLH CALCULATION for ONE FTE
Available Hours (52 wks x 40 hrs/wk)2,080
Less Vacation Leave0
Less Sick Leave0
Less Admin/Holiday/All Other Leave0
Team Member DPLH2,080

CUI//SP-PROCURE/SP-SSEL/SP-PROPIN

Staffing Plan - Table 7a

Company Name:
Initial Task Order: Africa I - Point of Entry Line Item
TABLE 7a
Please enter all information as required within the highlighted yellow cells for all years. You may add additional labor categories and supporting information as necessary.
Staffing Plan - Table 7aBASE PERIOD - Africa I POE
Labor CategoryWBS 4.1 Engineering/ Communications SurveyWBS 4.2 Communications System Design DevelopmentWBS 4.3 Pre-Deployment ActivitiesWBS 4.4 Deployment/ Construction/ IntegrationWBS 4.5 Site Inspection & TestingWBS 4.6 TrainingWBS 4.7 Operational Testing and EvaluationWBS 4.8 Mobile VansWBS 4.9 SustainabilityWBS 4.10 Project ManagementWBS 4.11 Labor HoursWBS 4.12 Labor HoursWBS 4.13 Labor HoursWBS 4.14 Labor HoursTotal Hours by Labor CategoryEquivalent FTE per Labor CategoryLabor Category % Estimated under Task Order
Labor Category - 100.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
Totals0000000000000000.000.00%
Equivalent FTE Count0.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Labor % by Task Area0.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%

CUI//SP-PROCURE/SP-SSEL/SP-PROPIN

Staffing Plan - Table 7b

Company Name:
Initial Task Order: Africa I - Non Point of Entry Line Item
TABLE 7b
Please enter all information as required within the highlighted yellow cells for all years. You may add additional labor categories and supporting information as necessary.
Staffing Plan - Table 7bBASE PERIOD - Africa I NON Point of Entry
Labor CategoryWBS 4.1 Engineering/ Communications SurveyWBS 4.2 Communications System Design DevelopmentWBS 4.3 Pre-Deployment ActivitiesWBS 4.4 Deployment/ Construction/ IntegrationWBS 4.5 Site Inspection & TestingWBS 4.6 TrainingWBS 4.7 Operational Testing and EvaluationWBS 4.8 Mobile VansWBS 4.9 SustainabilityWBS 4.10 Project ManagementWBS 4.11 Labor HoursWBS 4.12 Labor HoursWBS 4.13 Labor HoursWBS 4.14 Labor HoursTotal Hours by Labor CategoryEquivalent FTE per Labor CategoryLabor Category % Estimated under Task Order
Labor Category - 100.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
00.000.00%
Totals0000000000000000.000.00%
Equivalent FTE Count0.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Labor % by Task Area0.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%

CUI//SP-PROCURE/SP-SSEL/SP-PROPIN

image1.png

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