4._Law_Enforcement_Crime_Scene_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 05 Crime Scene 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
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
3._Vehicle_Patrol_Kit.xlsx XLSX spreadsheet
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 Law Enforcement Crime Scene 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.
"Crime Scene" Tab:
1. On the "Crime Scene" tab please insert the Year 1 unit rate for each item in the yellow highlighted cells in Column F, Rows 3-9. 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 14.
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.

Crime Scene

Law Enforcement Crime Scene 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
-Paper Evidence Bags (100)1,361$ - 0$ - 0626$ - 0$ - 0463$ - 0$ - 0539$ - 0$ - 0471$ - 0$ - 0238$ - 0$ - 0
-Police/Crime Scene Tape141$ - 0$ - 0256$ - 0$ - 0262$ - 0$ - 0225$ - 0$ - 0381$ - 0$ - 0192$ - 0$ - 0
-Photo Tape w/ Evidence Scale149$ - 0$ - 0121$ - 0$ - 0104$ - 0$ - 0128$ - 0$ - 0113$ - 0$ - 057$ - 0$ - 0
-Tape Measure42$ - 0$ - 044$ - 0$ - 039$ - 0$ - 037$ - 0$ - 039$ - 0$ - 020$ - 0$ - 0
-Crime Scene Reflective Chalk (Kit)252$ - 0$ - 0144$ - 0$ - 0141$ - 0$ - 0140$ - 0$ - 0154$ - 0$ - 078$ - 0$ - 0
-Non-Irritating Nitrile Gloves
-Small (100)91$ - 0$ - 046$ - 0$ - 042$ - 0$ - 046$ - 0$ - 042$ - 0$ - 021$ - 0$ - 0
-Medium (100)181$ - 0$ - 092$ - 0$ - 084$ - 0$ - 090$ - 0$ - 086$ - 0$ - 043$ - 0$ - 0
-Large (100)181$ - 0$ - 092$ - 0$ - 084$ - 0$ - 090$ - 0$ - 086$ - 0$ - 043$ - 0$ - 0
-Container/Organizer47$ - 0$ - 037$ - 0$ - 023$ - 0$ - 018$ - 0$ - 027$ - 0$ - 014$ - 0$ - 0
Yearly Sub-total$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Complete Law Enforcement Crime Scene Kit430$ - 0$ - 0130$ - 0$ - 0159$ - 0$ - 0130$ - 0$ - 0163$ - 0$ - 082$ - 0$ - 0
Total Yearly Price$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
0
You have not entered a unit price for each of the units listed above.
Law Enforcement Crime Scene KitGrowth Rates
Year 2Year 3Year 4Year 56 month Option
-Paper Evidence Bags
-Police/Crime Scene Tape
-Photo Tape w/ Evidence Scale
-Tape Measure
-Crime Scene Reflective Chalk
-Non-Irritating Nitrile GlovesN/AN/AN/AN/AN/A
-Small
-Medium
-Large
-Container/Organizer
Complete Law Enforcement Crime Scene Kit

Price List

Law Enforcement Crime Scene KitManufacturer NameProduct NamePart/Item #Manufacture #Year 1Year 2Year 3Year 4Year 56 month Option
-Paper Evidence Bags0000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
-Police/Crime Scene Tape0000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
-Photo Tape w/ Evidence Scale0000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
-Tape Measure0000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
-Crime Scene Reflective Chalk0000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
-Non-Irritating Nitrile Gloves
-Small0000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
-Medium0000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
-Large0000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
-Container/Organizer0000$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Complete Law Enforcement Crime Scene Kit$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

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