1._Black_Nylon_Gear_ _Accessories.xlsx
XLSX spreadsheet 26 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 Black Nylon Gear Accessories
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 Black Nylon Gear/Accessories. 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. |
| "Black Nylon" Tab: |
| 1. On the "Black Nylon" tab please insert the Year 1 unit rate for each item in the yellow highlighted cells in Column F, Rows 4-16. 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. 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. |
Black Nylon
| Black Nylon Gear/Accessories | 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 |
| -Utility Belt | |||||||||||||||||||||||
| -Small | 2,625 | $ - 0 | $ - 0 | 767 | $ - 0 | $ - 0 | 811 | $ - 0 | $ - 0 | 884 | $ - 0 | $ - 0 | 892 | $ - 0 | $ - 0 | 450 | $ - 0 | $ - 0 | |||||
| -Medium | 3,937 | $ - 0 | $ - 0 | 1,151 | $ - 0 | $ - 0 | 1,217 | $ - 0 | $ - 0 | 1,327 | $ - 0 | $ - 0 | 1,338 | $ - 0 | $ - 0 | 676 | $ - 0 | $ - 0 | |||||
| -Large | 4,593 | $ - 0 | $ - 0 | 1,343 | $ - 0 | $ - 0 | 1,420 | $ - 0 | $ - 0 | 1,548 | $ - 0 | $ - 0 | 1,561 | $ - 0 | $ - 0 | 788 | $ - 0 | $ - 0 | |||||
| -Extra Large | 1,968 | $ - 0 | $ - 0 | 576 | $ - 0 | $ - 0 | 608 | $ - 0 | $ - 0 | 663 | $ - 0 | $ - 0 | 669 | $ - 0 | $ - 0 | 338 | $ - 0 | $ - 0 | |||||
| -Utility Belt Keepers | 14,255 | $ - 0 | $ - 0 | 4,696 | $ - 0 | $ - 0 | 4,876 | $ - 0 | $ - 0 | 4,257 | $ - 0 | $ - 0 | 5,466 | $ - 0 | $ - 0 | 2,760 | $ - 0 | $ - 0 | |||||
| -Handcuff Case | 12,321 | $ - 0 | $ - 0 | 3,726 | $ - 0 | $ - 0 | 3,981 | $ - 0 | $ - 0 | 4,312 | $ - 0 | $ - 0 | 4,371 | $ - 0 | $ - 0 | 2,207 | $ - 0 | $ - 0 | |||||
| -Radio Case | 12,271 | $ - 0 | $ - 0 | 3,646 | $ - 0 | $ - 0 | 3,901 | $ - 0 | $ - 0 | 4,202 | $ - 0 | $ - 0 | 4,291 | $ - 0 | $ - 0 | 2,167 | $ - 0 | $ - 0 | |||||
| -M9 (9mm) Ammo Pouch | 12,331 | $ - 0 | $ - 0 | 3,671 | $ - 0 | $ - 0 | 4,001 | $ - 0 | $ - 0 | 4,352 | $ - 0 | $ - 0 | 4,391 | $ - 0 | $ - 0 | 2,217 | $ - 0 | $ - 0 | |||||
| -M4 Magazine Pouch | 12,331 | $ - 0 | $ - 0 | 3,671 | $ - 0 | $ - 0 | 4,001 | $ - 0 | $ - 0 | 4,352 | $ - 0 | $ - 0 | 4,391 | $ - 0 | $ - 0 | 2,217 | $ - 0 | $ - 0 | |||||
| -Chemical Spray Holder | 10,755 | $ - 0 | $ - 0 | 3,331 | $ - 0 | $ - 0 | 3,435 | $ - 0 | $ - 0 | 3,697 | $ - 0 | $ - 0 | 3,425 | $ - 0 | $ - 0 | 1,730 | $ - 0 | $ - 0 | |||||
| -Baton Holder | 11,605 | $ - 0 | $ - 0 | 3,481 | $ - 0 | $ - 0 | 3,660 | $ - 0 | $ - 0 | 4,047 | $ - 0 | $ - 0 | 3,650 | $ - 0 | $ - 0 | 1,843 | $ - 0 | $ - 0 | |||||
| -Silent Key Ring Holder | 11,901 | $ - 0 | $ - 0 | 3,501 | $ - 0 | $ - 0 | 3,756 | $ - 0 | $ - 0 | 4,057 | $ - 0 | $ - 0 | 4,146 | $ - 0 | $ - 0 | 2,094 | $ - 0 | $ - 0 | |||||
| -Glove Pouch/Case | 12,135 | $ - 0 | $ - 0 | 3,446 | $ - 0 | $ - 0 | 3,740 | $ - 0 | $ - 0 | 4,057 | $ - 0 | $ - 0 | 4,130 | $ - 0 | $ - 0 | 2,086 | $ - 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. |
| Black Nylon Gear/Accessories | Growth Rates | |||||
| Year 2 | Year 3 | Year 4 | Year 5 | 6 month Option | ||
| -Utility Belt | N/A | N/A | N/A | N/A | N/A | |
| -Small | ||||||
| -Medium | ||||||
| -Large | ||||||
| -Extra Large | ||||||
| -Utility Belt Keepers | ||||||
| -Handcuff Case | ||||||
| -Radio Case | ||||||
| -M9 (9mm) Ammo Pouch | ||||||
| -M4 Magazine Pouch | ||||||
| -Chemical Spray Holder | ||||||
| -Baton Holder | ||||||
| -Silent Key Ring Holder | ||||||
| -Glove Pouch/Case |
Price List
| Black Nylon Gear/Accessories | Manufacturer Name | Product Name | Part/Item # | Manufacture # | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | 6 month Option |
| -Utility Belt | ||||||||||
| -Small | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Medium | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Large | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Extra Large | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Utility Belt Keepers | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Handcuff Case | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Radio Case | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -M9 Ammo Pouch | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -M4 Magazine Pouch | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Chemical Spray Holder | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Baton Holder | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Silent Key Ring Holder | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| -Glove Pouch/Case | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
File details come from the government source that posted it. Updated .