Attachment_2_-_Non-FR_Combat_Shirt_Pricing_Worksheet.xlsx
XLSX spreadsheet 23 KB Posted
- Attached to
- Non Fire-Resistant Combat Shirt Federal contract opportunity
- Solicitation number
- FA8054-16-R-0001
About this file
Attachment 2 - Pricing Worksheet
View the file
Other files for this federal contract opportunity
Show all 24
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. The cells will change to white after an input has been generated. |
| 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. If only a single digit is entered, a zero will automatically follow (i.e. - enter $4.2 and $4.20 will be shown). |
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 Year 1 Unit Price, column F, for all items under NON-FIRE RESISTANT COMBAT SHIRT. |
| N/A and zero entries are not acceptable values. |
| 5. Please pay close attention to the borders 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 cell (row 13). If you have filled in each rate you will not see a message. If you have not |
| filled in each rate you will see the message "You have not entered a unit price for each of the units listed above". This is built in as an informational assist and does not |
| guarantee that your proposal fulfills the completeness requirement. |
| 6. Please examine 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. |
| "Non-FR Combat Shirt" Tab: |
| 1. On the "Non-FR Combat Shirt" tab please insert the Year 1 Unit Price for each item in the yellow highlighted cells in Column F, Rows 4-10. |
| You must fill in a two decimal unit price for every unit listed in the tab. If a number with three decimals is entered, the cell will turn red. |
| 2. The spreadsheet will automatically calculate the Year 1 Price (Column H) by multiplying the Year 1 Unit Price you enter by the Government provided Estimated Quantity |
| in Column G. The Year 2 - 5 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 and R. 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 |
| .05 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. If no growth is desired please enter 0. |
| 3. At the very end of the spreadsheet (Column U) 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 - 5. |
4. In Columns B-E please insert the information identified in Line 2 of those Columns (Manufacturer Name, Product Name, Part/Item #, Manufacturer #).
| "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. |
Non-FR Combat Shirt
NON-FIRE RESISTANT COMBAT SHIRT Manufacturer Name Product Name Part/Item # Manufacture # Year 1 Unit Price Estimated Qty FY 14 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 Total Evaluated Price
| NON-FR COMBAT SHIRT (XS) (ABU) | 640 | $ - 0 | $ - 0 | 640 | $ - 0 | $ - 0 | 640 | $ - 0 | $ - 0 | 640 | $ - 0 | $ - 0 | 640 | $ - 0 | $ - 0 | |
| NON-FR COMBAT SHIRT (S) (ABU) | 4,120 | $ - 0 | $ - 0 | 4,120 | $ - 0 | $ - 0 | 4,120 | $ - 0 | $ - 0 | 4,120 | $ - 0 | $ - 0 | 4,120 | $ - 0 | $ - 0 | |
| NON-FR COMBAT SHIRT (M) (ABU) | 7,900 | $ - 0 | $ - 0 | 7,900 | $ - 0 | $ - 0 | 7,900 | $ - 0 | $ - 0 | 7,900 | $ - 0 | $ - 0 | 7,900 | $ - 0 | $ - 0 | |
| NON-FR COMBAT SHIRT (L) (ABU) | 8,000 | $ - 0 | $ - 0 | 8,000 | $ - 0 | $ - 0 | 8,000 | $ - 0 | $ - 0 | 8,000 | $ - 0 | $ - 0 | 8,000 | $ - 0 | $ - 0 | |
| NON-FR COMBAT SHIRT (XL) (ABU) | 5,300 | $ - 0 | $ - 0 | 5,300 | $ - 0 | $ - 0 | 5,300 | $ - 0 | $ - 0 | 5,300 | $ - 0 | $ - 0 | 5,300 | $ - 0 | $ - 0 | |
| NON-FR COMBAT SHIRT (XXL) (ABU) | 1,260 | $ - 0 | $ - 0 | 1,260 | $ - 0 | $ - 0 | 1,260 | $ - 0 | $ - 0 | 1,260 | $ - 0 | $ - 0 | 1,260 | $ - 0 | $ - 0 | |
| NON-FR COMBAT SHIRT (XXXL) (ABU) | 280 | $ - 0 | $ - 0 | 280 | $ - 0 | $ - 0 | 280 | $ - 0 | $ - 0 | 280 | $ - 0 | $ - 0 | 280 | $ - 0 | $ - 0 | |
| Yearly Sub-total | 27,500 | $ - 0 | 27,500 | $ - 0 | 27,500 | $ - 0 | 27,500 | $ - 0 | 27,500 | $ - 0 | $ - 0 | |||||
| 0 | ||||||||||||||||
| You have not entered a unit price for each of the units listed above. |
| NON-FIRE RESISTANT COMBAT SHIRT | GROWTH RATES | |||||
| Year 2 | Year 3 | Year 4 | Year 5 | |||
| NON-FR COMBAT SHIRT (XS) (ABU) | ||||||
| NON-FR COMBAT SHIRT (S) (ABU) | ||||||
| NON-FR COMBAT SHIRT (M) (ABU) | ||||||
| NON-FR COMBAT SHIRT (L) (ABU) | ` | |||||
| NON-FR COMBAT SHIRT (XL) (ABU) | ||||||
| NON-FR COMBAT SHIRT (XXL) (ABU) | ||||||
| NON-FR COMBAT SHIRT (XXXL) (ABU) |
Price List
NON-FIRE RESISTANT COMBAT SHIRT Manufacturer Name Product Name Part/Item # Manufacture # Year 1 Year 2 Year 3 Year 4 Year 5
| NON-FR COMBAT SHIRT (XS) (ABU) | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| NON-FR COMBAT SHIRT (S) (ABU) | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| NON-FR COMBAT SHIRT (M) (ABU) | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| NON-FR COMBAT SHIRT (L) (ABU) | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| NON-FR COMBAT SHIRT (XL) (ABU) | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| NON-FR COMBAT SHIRT (XXL) (ABU) | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| NON-FR COMBAT SHIRT (XXXL) (ABU) | 0 | 0 | 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
File details come from the government source that posted it. Updated .