1__Black_Nylon_Gear__Accessories_(2).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
LEE Draft Pricing Model Category 1
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.
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 or growth 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). |
| 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 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 Ammo Pouch | ||||||
| -M4 Magazine Pouch | ||||||
| -Chemical Spray Holder | ||||||
| -Baton Holder | ||||||
| -Silent Key Ring Holder | ||||||
| -Glove Pouch/Case | ||||||
| 0 | 0 | 0 | 0 | 0 | ||
| You have not entered a unit growth rate for each of the units listed above. |
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 .