2._Common_DoD_Civilian_ _Military.xlsx
XLSX spreadsheet 35 KB Posted
- Attached to
- LEE, Vehicle Patrol Kit, Category 3 Federal contract opportunity
- Solicitation number
- FA8003-13-R-0002
About this file
Updated Pricing Model for Common DoD Civilian Military Items
View the file
Other files for this federal contract opportunity
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
Text version
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 Common DoD Civilian & Military. 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. |
| "DoD Civ & Military" Tab: |
| 1. On the "DoD Civ & Military" please insert the Year 1 unit rate for each item in the yellow highlighted cells in Column F, Rows 4-7, 9 and 11-18. You must fill in a two |
| decimal unit price for every unit listed in the tab. |
| 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. 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. In the event that you produce Concealable Body Armor in sizes that the Government has not listed on the "DoD Civ & Military" tab, lines 24-43 |
| have been highlighted in yellow and are available for you to fill in. If you have additional sizes, please list the size in Column B and the apropriate unit price in Columns |
| G-L. These inputs will not be a part of the Total Evaluated Price but will be analyzed and used in the event the Government requires one of these sizes. |
DoD Civ & Military
| Common DoD Civilian & Military | Manufacturer Name | Product Name | Part/Item # | Manufacture # | Year 1 Unit Price | Estimated Qty | Year 1 Price | Year 2 Unit Price | Estimated Qty | Year 2 Price | Year 3 Unit Price | Estimated Qty | Year 3 Price | Year 4 Unit Price | Estimated Qty | Year 4 Price | Year 5 Unit Price | Estimated Qty | Year 5 Price | 6 month Option Unit Price | Estimated Qty | 6 month Option Price | Total Evaluated Price |
| -Concealable Body Armor | |||||||||||||||||||||||
| -Mens S-Regular | 1,302 | $ - 0 | $ - 0 | 443 | $ - 0 | $ - 0 | 475 | $ - 0 | $ - 0 | 511 | $ - 0 | $ - 0 | 599 | $ - 0 | $ - 0 | 303 | $ - 0 | $ - 0 | |||||
| -Womens S-Regular | 230 | $ - 0 | $ - 0 | 78 | $ - 0 | $ - 0 | 84 | $ - 0 | $ - 0 | 90 | $ - 0 | $ - 0 | 106 | $ - 0 | $ - 0 | 53 | $ - 0 | $ - 0 | |||||
| -Mens S-Long | 326 | $ - 0 | $ - 0 | 111 | $ - 0 | $ - 0 | 119 | $ - 0 | $ - 0 | 128 | $ - 0 | $ - 0 | 150 | $ - 0 | $ - 0 | 76 | $ - 0 | $ - 0 | |||||
| -Womens S-Long | 57 | $ - 0 | $ - 0 | 20 | $ - 0 | $ - 0 | 21 | $ - 0 | $ - 0 | 23 | $ - 0 | $ - 0 | 26 | $ - 0 | $ - 0 | 13 | $ - 0 | $ - 0 | |||||
| -Mens M-Regular | 3,256 | $ - 0 | $ - 0 | 1,108 | $ - 0 | $ - 0 | 1,188 | $ - 0 | $ - 0 | 1,276 | $ - 0 | $ - 0 | 1,498 | $ - 0 | $ - 0 | 757 | $ - 0 | $ - 0 | |||||
| -Womens M-Regular | 575 | $ - 0 | $ - 0 | 196 | $ - 0 | $ - 0 | 210 | $ - 0 | $ - 0 | 225 | $ - 0 | $ - 0 | 264 | $ - 0 | $ - 0 | 134 | $ - 0 | $ - 0 | |||||
| -Mens M-Long | 1,085 | $ - 0 | $ - 0 | 369 | $ - 0 | $ - 0 | 396 | $ - 0 | $ - 0 | 425 | $ - 0 | $ - 0 | 499 | $ - 0 | $ - 0 | 252 | $ - 0 | $ - 0 | |||||
| -Womens M-Long | 192 | $ - 0 | $ - 0 | 65 | $ - 0 | $ - 0 | 70 | $ - 0 | $ - 0 | 75 | $ - 0 | $ - 0 | 88 | $ - 0 | $ - 0 | 45 | $ - 0 | $ - 0 | |||||
| -Mens L-Regular | 2,713 | $ - 0 | $ - 0 | 924 | $ - 0 | $ - 0 | 990 | $ - 0 | $ - 0 | 1,064 | $ - 0 | $ - 0 | 1,249 | $ - 0 | $ - 0 | 631 | $ - 0 | $ - 0 | |||||
| -Womens L-Regular | 479 | $ - 0 | $ - 0 | 163 | $ - 0 | $ - 0 | 175 | $ - 0 | $ - 0 | 188 | $ - 0 | $ - 0 | 220 | $ - 0 | $ - 0 | 111 | $ - 0 | $ - 0 | |||||
| -Mens L-Long | 760 | $ - 0 | $ - 0 | 259 | $ - 0 | $ - 0 | 277 | $ - 0 | $ - 0 | 298 | $ - 0 | $ - 0 | 350 | $ - 0 | $ - 0 | 177 | $ - 0 | $ - 0 | |||||
| -Womens L-Long | 134 | $ - 0 | $ - 0 | 46 | $ - 0 | $ - 0 | 49 | $ - 0 | $ - 0 | 53 | $ - 0 | $ - 0 | 62 | $ - 0 | $ - 0 | 31 | $ - 0 | $ - 0 | |||||
| -Mens XL-Regular | 760 | $ - 0 | $ - 0 | 259 | $ - 0 | $ - 0 | 277 | $ - 0 | $ - 0 | 298 | $ - 0 | $ - 0 | 350 | $ - 0 | $ - 0 | 177 | $ - 0 | $ - 0 | |||||
| -Womens XL-Regular | 134 | $ - 0 | $ - 0 | 46 | $ - 0 | $ - 0 | 49 | $ - 0 | $ - 0 | 53 | $ - 0 | $ - 0 | 62 | $ - 0 | $ - 0 | 31 | $ - 0 | $ - 0 | |||||
| -Mens XL-Long | 434 | $ - 0 | $ - 0 | 148 | $ - 0 | $ - 0 | 158 | $ - 0 | $ - 0 | 170 | $ - 0 | $ - 0 | 200 | $ - 0 | $ - 0 | 101 | $ - 0 | $ - 0 | |||||
| -Womens XL-Long | 77 | $ - 0 | $ - 0 | 26 | $ - 0 | $ - 0 | 28 | $ - 0 | $ - 0 | 30 | $ - 0 | $ - 0 | 35 | $ - 0 | $ - 0 | 18 | $ - 0 | $ - 0 | |||||
| -Mens 2XL-Regular | 163 | $ - 0 | $ - 0 | 55 | $ - 0 | $ - 0 | 59 | $ - 0 | $ - 0 | 64 | $ - 0 | $ - 0 | 75 | $ - 0 | $ - 0 | 38 | $ - 0 | $ - 0 | |||||
| -Womens 2XL-Regular | 29 | $ - 0 | $ - 0 | 10 | $ - 0 | $ - 0 | 10 | $ - 0 | $ - 0 | 11 | $ - 0 | $ - 0 | 13 | $ - 0 | $ - 0 | 7 | $ - 0 | $ - 0 | |||||
| -Mens 2XL-Long | 54 | $ - 0 | $ - 0 | 18 | $ - 0 | $ - 0 | 20 | $ - 0 | $ - 0 | 21 | $ - 0 | $ - 0 | 25 | $ - 0 | $ - 0 | 13 | $ - 0 | $ - 0 | |||||
| -Womens 2XL-Long | 10 | $ - 0 | $ - 0 | 3 | $ - 0 | $ - 0 | 3 | $ - 0 | $ - 0 | 4 | $ - 0 | $ - 0 | 4 | $ - 0 | $ - 0 | 2 | $ - 0 | $ - 0 | |||||
| -Safariland M9 Holster - Left | 1,259 | $ - 0 | $ - 0 | 399 | $ - 0 | $ - 0 | 441 | $ - 0 | $ - 0 | 511 | $ - 0 | $ - 0 | 532 | $ - 0 | $ - 0 | 269 | $ - 0 | $ - 0 | |||||
| -Safariland M9 Holster - Right | 11,327 | $ - 0 | $ - 0 | 3,592 | $ - 0 | $ - 0 | 3,973 | $ - 0 | $ - 0 | 4,603 | $ - 0 | $ - 0 | 4,783 | $ - 0 | $ - 0 | 2,415 | $ - 0 | $ - 0 | |||||
| -QLS Kit (1 QLS-19 & 2 QLS-22L) | 12,586 | $ - 0 | $ - 0 | 3,991 | $ - 0 | $ - 0 | 4,414 | $ - 0 | $ - 0 | 5,114 | $ - 0 | $ - 0 | 5,315 | $ - 0 | $ - 0 | 2,684 | $ - 0 | $ - 0 | |||||
| -QLS-19 Replacement | 400 | $ - 0 | $ - 0 | 399 | $ - 0 | $ - 0 | 441 | $ - 0 | $ - 0 | 511 | $ - 0 | $ - 0 | 531 | $ - 0 | $ - 0 | 268 | $ - 0 | $ - 0 | |||||
| -6004-8-13 MOLLE Plate | 12,586 | $ - 0 | $ - 0 | 3,991 | $ - 0 | $ - 0 | 4,414 | $ - 0 | $ - 0 | 5,114 | $ - 0 | $ - 0 | 5,315 | $ - 0 | $ - 0 | 2,684 | $ - 0 | $ - 0 | |||||
| -6070UBL-2 | 12,586 | $ - 0 | $ - 0 | 3,991 | $ - 0 | $ - 0 | 4,414 | $ - 0 | $ - 0 | 5,114 | $ - 0 | $ - 0 | 5,315 | $ - 0 | $ - 0 | 2,684 | $ - 0 | $ - 0 | |||||
| -Baton | 12,805 | $ - 0 | $ - 0 | 3,861 | $ - 0 | $ - 0 | 3,651 | $ - 0 | $ - 0 | 3,895 | $ - 0 | $ - 0 | 3,786 | $ - 0 | $ - 0 | 1,912 | $ - 0 | $ - 0 | |||||
| -Handcuffs | 13,954 | $ - 0 | $ - 0 | 4,200 | $ - 0 | $ - 0 | 4,086 | $ - 0 | $ - 0 | 4,503 | $ - 0 | $ - 0 | 4,444 | $ - 0 | $ - 0 | 2,244 | $ - 0 | $ - 0 | |||||
| -Mini Flashlight | 13,395 | $ - 0 | $ - 0 | 4,660 | $ - 0 | $ - 0 | 4,231 | $ - 0 | $ - 0 | 4,588 | $ - 0 | $ - 0 | 4,914 | $ - 0 | $ - 0 | 2,482 | $ - 0 | $ - 0 | |||||
| -Whistle | 13,736 | $ - 0 | $ - 0 | 3,817 | $ - 0 | $ - 0 | 4,077 | $ - 0 | $ - 0 | 4,415 | $ - 0 | $ - 0 | 4,549 | $ - 0 | $ - 0 | 2,297 | $ - 0 | $ - 0 | |||||
| Yearly Sub-total | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 0 | |||||||||||||||||||||||
| You have not entered a unit price for each of the units listed above. |
| Common DoD Civilian & Military | Growth Rates | |||||
| Year 2 | Year 3 | Year 4 | Year 5 | Option | ||
| -Concealable Body Armor | N/A | N/A | N/A | N/A | N/A | |
| -Mens S-Regular | ||||||
| -Womens S-Regular | ||||||
| -Mens S-Long | ||||||
| -Womens S-Long | ||||||
| -Mens M-Regular | ||||||
| -Womens M-Regular | ||||||
| -Mens M-Long | ||||||
| -Womens M-Long | ||||||
| -Mens L-Regular | ||||||
| -Womens L-Regular | ||||||
| -Mens L-Long | ||||||
| -Womens L-Long | ||||||
| -Mens XL-Regular | ||||||
| -Womens XL-Regular | ||||||
| -Mens XL-Long | ||||||
| -Womens XL-Long | ||||||
| -Mens 2XL-Regular | ||||||
| -Womens 2XL-Regular | ||||||
| -Mens 2XL-Long | ||||||
| -Womens 2XL-Long | ||||||
| -Safariland M9 Holster - Left | ||||||
| -Safariland M9 Holster - Right | ||||||
| -QLS Kit (1 QLS-19 & 2 QLS-22L) | ||||||
| -QLS-19 Replacement | ||||||
| -6004-8-13 MOLLE Plate | ||||||
| -6070UBL-2 | ||||||
| -Baton | ||||||
| -Handcuffs | ||||||
| -Mini Flashlight | ||||||
| -Whistle |
Price List
| Common DoD Civilian & Military | Manufacturer Name | Product Name | Part/Item # | Manufacture # | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Option |
| -Concealable Body Armor | ||||||||||
| -Mens S-Regular | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Womens S-Regular | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Mens S-Long | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Womens S-Long | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Mens M-Regular | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Womens M-Regular | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Mens M-Long | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Womens M-Long | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Mens L-Regular | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Womens L-Regular | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Mens L-Long | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Womens L-Long | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Mens XL-Regular | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Womens XL-Regular | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Mens XL-Long | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Womens XL-Long | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Mens 2XL-Regular | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Womens 2XL-Regular | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Mens 2XL-Long | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Womens 2XL-Long | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Safariland M9 Holster - Left | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Safariland M9 Holster - Right | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -QLS Kit (1 QLS-19 & 2 QLS-22L) | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -QLS-19 Replacement | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -6004-8-13 MOLLE Plate | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -6070UBL-2 | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Baton | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Handcuffs | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Mini Flashlight | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Whistle | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
File details come from the government source that posted it. Updated .