Attachment_04_Pricing_Worksheet__2_DF-LCS2_Non-Flame_Resistant_Combat_Shirt_(16_Sep_13).xlsx
XLSX spreadsheet 24 KB Posted
- Solicitation number
- FA8054-13-R-0001
About this file
Attachment 04_Pricing Worksheet 2 DF-LCS2 Non-Flame Resistant Combat Shirt
View the file
Other files
Show 40 more
Latest 50 of 58 listed here. See the rest on GovTribe.
On GovTribe
Work with this file
- 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 Non-FR Combat Shirt. 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. |
| "Non-FR Combat Shirt" Tab: |
| 1. On the "Non-FR Combat Shirt" please insert the Year 1 unit rate for each item in the yellow highlighted cells in Column F, Rows 4-7. 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 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 |
| 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. 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-5. |
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. |
Non-FR Combat Shirt
| DF-LCS2 Program | 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-FLAME RESISTANT COMBAT SHIRT | ||||||||||||||||||||
| NON-FR COMBAT SHIRT (XS) (ABU) | 855 | $ - 0 | $ - 0 | 506 | $ - 0 | $ - 0 | 515 | $ - 0 | $ - 0 | 538 | $ - 0 | $ - 0 | 509 | $ - 0 | $ - 0 | |||||
| NON-FR COMBAT SHIRT (S) (ABU) | 2,371 | $ - 0 | $ - 0 | 954 | $ - 0 | $ - 0 | 966 | $ - 0 | $ - 0 | 1,053 | $ - 0 | $ - 0 | 998 | $ - 0 | $ - 0 | |||||
| NON-FR COMBAT SHIRT (M) (ABU) | 5,232 | $ - 0 | $ - 0 | 1,597 | $ - 0 | $ - 0 | 1,560 | $ - 0 | $ - 0 | 1,622 | $ - 0 | $ - 0 | 1,676 | $ - 0 | $ - 0 | |||||
| NON-FR COMBAT SHIRT (L) (ABU) | 5,133 | $ - 0 | $ - 0 | 1,540 | $ - 0 | $ - 0 | 1,466 | $ - 0 | $ - 0 | 1,569 | $ - 0 | $ - 0 | 1,629 | $ - 0 | $ - 0 | |||||
| NON-FR COMBAT SHIRT (XL) (ABU) | 1,653 | $ - 0 | $ - 0 | 639 | $ - 0 | $ - 0 | 618 | $ - 0 | $ - 0 | 637 | $ - 0 | $ - 0 | 771 | $ - 0 | $ - 0 | |||||
| NON-FR COMBAT SHIRT (XXL) (ABU) | 600 | $ - 0 | $ - 0 | 300 | $ - 0 | $ - 0 | 300 | $ - 0 | $ - 0 | 300 | $ - 0 | $ - 0 | 300 | $ - 0 | $ - 0 | |||||
| NON-FR COMBAT SHIRT (XXXL) (ABU) | 200 | $ - 0 | $ - 0 | 100 | $ - 0 | $ - 0 | 100 | $ - 0 | $ - 0 | 100 | $ - 0 | $ - 0 | 100 | $ - 0 | $ - 0 | |||||
| Yearly Sub-total | $ - 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. |
| Growth Rates | |||||
| Year 2 | Year 3 | Year 4 | Year 5 | ||
| NON-FLAME RESISTANT COMBAT SHIRT | N/A | N/A | N/A | N/A | |
| 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
| Common DoD Civilian & Military | Manufacturer Name | Product Name | Part/Item # | Manufacture # | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| NON-FLAME RESISTANT COMBAT SHIRT | |||||||||
| 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 .