3._Vehicle_Patrol_Kit.xlsx

XLSX spreadsheet 26 KB Posted

Attached to
LEE, Vehicle Patrol Kit, Category 3 Federal contract opportunity
Solicitation number
FA8003-13-R-0002
Issued by
Department of the Air Force Materiel Command Installation and Mission Support Center Installation Contracting Agency

About this file

From the source

Attachment 04 Patrol Kit Pricing Sheet

View the file

Other files for this federal contract opportunity

Other files attached to LEE, Vehicle Patrol Kit, Category 3, newest first.
File Type Posted
Amendment_10_-_FA8003-13-R-0002-0010.pdf PDF
Attachment_01_-_Vehicle_Patrol_Kit_Salient_Characteristics_-_31_Oct_2014.pdf PDF
Vehicle_Patrol_Kit_Questions_ _Answers.pdf PDF
Attachment_09_-_Vehicle_Patrol_Kit_Requirements_Acceptability_Checklist_31_Oct_2014.xlsx XLSX spreadsheet
Attachment_09_-_Vehicle_Patrol_Kit_Requirements_Acceptability_Checklist_28_Oct_2014.xlsx XLSX spreadsheet
Vehicle_Patrol_Kit_Questions_ _Answers.pdf PDF
Amendment_7_-_FA8003-13-R-0002-0007.pdf PDF
FA8003-13-R-0002-0006.pdf PDF
Vehicle_Patrol_Kit_Questions_ _Answers.pdf PDF
Attachment_04_-_A001_CDRL_LEE_Reporting_27_Feb_2013.pdf PDF
Attachment_02_-_Pricing_Worksheet_-_Vehicle_Patrol_Kit.xlsx XLSX spreadsheet
Attachment_09_-_AF_Law_Enforcement_Vehicle_Patrol_Kit_Requirements_Acceptability_Checklist_29_Apr_2014.xlsx XLSX spreadsheet
FA8003-13-R-0002-0005_Modification_Document.pdf PDF
Attachment_01_-_Vehicle_Patrol_Kit_Salient_Characteristics_-_28_April_2014.pdf PDF
Attachment_06_-_A001b_Appendix_B_Quarterly_Report_Definitions_-_18_Apr_2013.pdf PDF
Attachment_05_-_Quarterly_Report_Matrix.xlsx XLSX spreadsheet
FA8003-13-R-0002-0005_Conformed_Copy.pdf PDF
Attachment_13_-_DoD_eMall_Supplier_Registration_CAC_PKI_31_JAN_13.pdf PDF
Attachment_07_-_A002_CDRL_LEE_PMR.pdf PDF
Attachment_11_-_DoD_eMall_Registration_Process_Improvement_Guide_13_JAN_13.pdf PDF
VENDOR_QUESTION_RFP.pdf PDF
Atch_17_-VENDOR_QUESTION_RFP.pdf PDF
AF_Law_Enforcement_Requirements_Acceptability_Checklist_Rev_9_-_Vendor_FINAL_3_Jun_2013.xlsx XLSX spreadsheet
Amendment_3.pdf PDF
LEE_Salient_Characteristics_-_29_May_2013.pdf PDF
LEE_Salient_Characteristics_-_28_May_2013.pdf PDF
VENDOR_QUESTIONS.pdf PDF
1._Black_Nylon_Gear_ _Accessories.xlsx XLSX spreadsheet
3._Vehicle_Patrol_Kit.xlsx XLSX spreadsheet
2._Common_DoD_Civilian_ _Military.xlsx XLSX spreadsheet
Signed_JA_for_Safariland_Holster_Sole_Source.pdf PDF
A002_CDRL_-_LEE_-_PMR_FINAL_-_27_Feb_2013.pdf PDF
DoD_eMall_-_Registration_Process_Improvement_Guide_(13_JAN_13).pdf PDF
A001_CDRL_-_LEE_-_Reporting_27_Feb_2013.pdf PDF
A001a_Appendix_A_Quarterly_Report_Matrix_-_FINAL_-_18_Apr_2013.xlsx XLSX spreadsheet
DoD_eMall_-_Supplier_Registration_-_CAC-PKI_(31_JAN_13).pdf PDF
LEE_Salient_Characteristics_18_Apr_2013FINAL_for_AFSFC_SFX_Approval.pdf PDF
A002a_Appendix_A-_Program_Management_Review_Content_and_Guidelines_-_FINAL_-_27_Feb_2013.docx DOCX document
Air_Force_Law_Enforcement_Requirements_Acceptability_Checklist_Rev_5_-_Vendor_FINAL.xlsx XLSX spreadsheet
1._Black_Nylon_Gear_and_Accessories.xlsx XLSX spreadsheet
2._Common_DoD_Civilian_and_Military.xlsx XLSX spreadsheet
A001_CDRL_-_LEE_-_Reporting_21_Dec_2012.pdf PDF
1__Black_Nylon_Gear__Accessories_(2).xlsx XLSX spreadsheet
2__Common_DoD_Civilian__Military_(4).xlsx XLSX spreadsheet
4__Law_Enforcement_Crime_Scene_Kit_(3).xlsx XLSX spreadsheet
BaseShippingLocations.pdf PDF
3__Vehicle_Patrol_Kit_(3).xlsx XLSX spreadsheet
A001a_Appendix_A_Semi-Annual_Report_Matrix_-_Update_21_December_2012.xlsx XLSX spreadsheet
A002_Appendix_A-_Program_Management_Review_Content_and_Guidelines_-_Update_21_Dec_2012.docx DOCX document
LEEDraftRFP(Final).pdf PDF
Show all 50

LEE, Vehicle Patrol Kit, Category 3 has more files on GovTribe.

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.

Instructions

Instructions for Offeror's to Complete the Pricing Spreadsheet

General:
1. Fill in only the yellow highlighted cells

2. Only take rates out two decimal places (e.g. $15.32). Entering formulas is unacceptable. If an input cell turns red that means you have entered more than two decimals.

3. Certain cells throughout the spreadsheet are locked. Any attempt to unlock or change these cells is unacceptable.

4. You must propose on a complete category. You must fill in a unit price for all items under Vehicle Patrol Kit. N/A and zero entries are not acceptable values.

5. Please pay close attention to the lines directly under the input area. To assist you in making sure you completely fill out the pricing model the Government has built
in a mechanism that will tell you if you have filled a unit rate in each appropriate spot. If you have filled in each rate you will see nothing. If you have not
filled in each rate you will see a message telling you that. This is built in as an informational assist and does not guarantee that your proposal fulfills the
completeness requirement
6. Please examin your Yearly prices and Total Evaluated Price carefully. There is always the possibility that you may have accidentally entered a unit price or growth
rate incorrectly. This can cause your Total Evaluated Price to be much higher or lower than you intended.
"Vehicle Patrol Kit" Tab:
1. On the "Vehicle Patrol Kit" tab please insert the Year 1 unit rate for each item in the yellow highlighted cells in Column F, Rows 3-11. You must fill in a two decimal
unit price for every unit listed in the tab. Please also fill in the cost for a complete kit in Column F, Row 13.
2. The spreadsheet will automatically calculate the Year 1 price (Column H) by multiplying the unit rate you enter by the Government provided Estimated Quantity in
Column G. The Year 2-Option unit price will be calculated by the spreadsheet using the growth rate percentages you enter in the yellow highlighted cells in Columns I,
L, O, R and U. Column I represents the growth from Year 1 to Year 2. For example, if you want your unit rate to increase by 5% from Year 1 to Year 2 you will enter
5 in Column I. If the offeror wishes, a different growth rate can be entered for each unit. Column L (Year 3) represents the growth from Year 2 to Year 3; and
so on through Column U (Option). If no growth is desired please enter 0.
3. At the very end of the spreadsheet (Column X) you will find the Total Evaluated Price which is what the award will be based on. This is a summation of the price
calculated in Years 1-Option.

4. In Columns B-E please insert the information identified in Line 2 of those Columns.

"Price List" Tab
1. No entry is necessary on this tab. Since the Government reserves the right to acquire any of the items on an individual basis this tab compiles
all of the unit prices and will serve as the price list for awarded contracts.

Vehicle Patrol Kit

Vehicle Patrol KitManufacturer NameProduct NamePart/Item #Manufacture #Year 1 Unit PriceEstimated QtyYear 1 PriceYear 2 Unit PriceEstimated QtyYear 2 PriceYear 3 Unit PriceEstimated QtyYear 3 PriceYear 4 Unit PriceEstimated QtyYear 4 PriceYear 5 Unit PriceEstimated QtyYear 5 Price6 month Option Unit PriceEstimated Qty6 month Option PriceTotal Evaluated Price
-Reflective Traffic/Safety Vest2,295$ - 0$ - 0817$ - 0$ - 0817$ - 0$ - 0818$ - 0$ - 0848$ - 0$ - 0428$ - 0$ - 0
-Expandable Traffic Cones w/ Lights828$ - 0$ - 0374$ - 0$ - 0301$ - 0$ - 0355$ - 0$ - 0402$ - 0$ - 0203$ - 0$ - 0
-Traffic Wand590$ - 0$ - 0255$ - 0$ - 0202$ - 0$ - 0261$ - 0$ - 0233$ - 0$ - 0118$ - 0$ - 0
-Flex Cuffs1,993$ - 0$ - 0929$ - 0$ - 0739$ - 0$ - 0780$ - 0$ - 0695$ - 0$ - 0351$ - 0$ - 0
-Flex Cuff Cutters269$ - 0$ - 0183$ - 0$ - 0158$ - 0$ - 0154$ - 0$ - 0229$ - 0$ - 0116$ - 0$ - 0
-Rechargeable Heavy Duty Flashlights298$ - 0$ - 0194$ - 0$ - 0194$ - 0$ - 0195$ - 0$ - 0215$ - 0$ - 0109$ - 0$ - 0
-Punch Hammer w/ Seatbelt Cutter307$ - 0$ - 0174$ - 0$ - 0149$ - 0$ - 0145$ - 0$ - 0195$ - 0$ - 098$ - 0$ - 0
-First Responder First Aid/BBP Kit573$ - 0$ - 0299$ - 0$ - 0229$ - 0$ - 0273$ - 0$ - 0230$ - 0$ - 0116$ - 0$ - 0
-Container/Organizer245$ - 0$ - 0164$ - 0$ - 0140$ - 0$ - 0140$ - 0$ - 0141$ - 0$ - 071$ - 0$ - 0
Yearly Sub-total$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Complete Vehicle Patrol Kit1,145$ - 0$ - 0215$ - 0$ - 0223$ - 0$ - 0215$ - 0$ - 0233$ - 0$ - 0118$ - 0$ - 0
Total Yearly Price$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
0
You have not entered a price for each of the items listed above.
Vehicle Patrol KitGrowth Rates
Year 2Year 3Year 4Year 56 month Option
-Reflective Traffic/Safety Vest
-Expandable Traffic Cones w/ Lights
-Traffic Wand
-Flex Cuffs
-Flex Cuff Cutters
-Rechargeable Heavy Duty Flashlights
-Punch Hammer w/ Seatbelt Cutter
-First Responder First Aid/BBP Kit
-Container/Organizer
Complete Vehicle Patrol Kit

Price List

Vehicle Patrol KitManufacturer NameProduct NamePart/Item #Manufacture #Year 1Year 2Year 3Year 4Year 56 month option
-Reflective Traffic/Safety Vest0000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
-Expandable Traffic Cones w/ Lights0000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
-Traffic Wand0000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
-Flex Cuffs0000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
-Flex Cuff Cutters0000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
-Rechargeable Heavy Duty Flashlights0000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
-Punch Hammer w/ Seatbelt Cutter0000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
-First Responder First Aid/BBP Kit0000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
-Container/Organizer0000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Complete Vehicle Patrol Kit$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

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