Attachment_S4_-_Coefficient_Spreadsheet.xls
XLS spreadsheet 52 KB Posted
- Attached to
- CANNON AFB, NM SABER
- Solicitation number
- FA4855-13-R-0009
About this file
Attachment S4
View the file
Other files
Show 40 more
Latest 50 of 53 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
Section B
| COEFFICIENT SPREADSHEET | |||
| Offeror's Name: | |||
| Base Ordering Period (based on an average volume of $3,000,000)(Note 1) | |||
| Type of Requirement | Adjusted Annual Amount Based on Percent of Average Volume | Coefficient Proposed (Insert value X.XXXXX) | Adjusted Total Estimated Value (Note 2) |
| Standard Requirement | $ 2,250,000 | 1.2 | $ 2,700,000 |
| Non-Standard Requirement | $ 690,000 | 1.1 | $ 759,000 |
| Emergency/Time Critical | $ 60,000 | 0.9 | $ 54,000 |
| Total Estimated Usage | $ 3,000,000 | $ 3,513,000 | |
| Ordering Period 1 (based on an average volume of $3,000,000) | |||
| Type of Requirement | Adjusted Annual Amount Based on Percent of Average Volume | Coefficient Proposed (Insert value X.XXXXX) | Adjusted Total Estimated Value (Note 2) |
| Standard Requirement | $ 2,250,000 | 1.2 | $ 2,700,000 |
| Non-Standard Requirement | $ 690,000 | 1.1 | $ 759,000 |
| Emergency/Time Critical | $ 60,000 | 0.9 | $ 54,000 |
| Total Estimated Usage | $ 3,000,000 | $ 3,459,000 | |
| Ordering Period 2 (based on an average volume of $3,000,000) | |||
| Type of Requirement | Adjusted Annual Amount Based on Percent of Average Volume | Coefficient Proposed (Insert value X.XXXXX) | Adjusted Total Estimated Value (Note 2) |
| Standard Requirement | $ 2,250,000 | 1.3 | $ 2,925,000 |
| Non-Standard Requirement | $ 690,000 | 0.97 | $ 669,300 |
| Emergency/Time Critical | $ 60,000 | 1.1 | $ 66,000 |
| Total Estimated Usage | $ 3,000,000 | $ 3,594,300 | |
| Ordering Period 3 (based on an average volume of $3,000,000) | |||
| Type of Requirement | Adjusted Annual Amount Based on Percent of Average Volume | Coefficient Proposed (Insert value X.XXXXX) | Adjusted Total Estimated Value (Note 2) |
| Standard Requirement | $ 2,250,000 | 1.2 | $ 2,700,000 |
| Non-Standard Requirement | $ 690,000 | 1.1 | $ 759,000 |
| Emergency/Time Critical | $ 60,000 | 0.9 | $ 54,000 |
| Total Estimated Usage | $ 3,000,000 | $ 3,459,000 | |
| Ordering Period 4 (based on an average volume of $3,000,000) | |||
| Type of Requirement | Adjusted Annual Amount Based on Percent of Average Volume | Coefficient Proposed (Insert value X.XXXXX) | Adjusted Total Estimated Value (Note 3) |
| Standard Requirement | $ 2,250,000 | 1.2 | $ 2,700,000 |
| Non-Standard Requirement | $ 690 | 1.1 | $ 759 |
| Emergency/Time Critical | $ 60,000 | 0.9 | $ 54,000 |
| Total Estimated Usage | $ 2,310,690 | $ 2,700,759 | |
| TOTAL PROPOSED PRICE FOR ALL YEARS (Note 3) | $ 16,726,059 | ||
| NOTES: | |||
| 1. Average volume is based on a maximum contract value of $15M over 5 years ($3M per year), and will be used for evaluation purposes only. The offeror should not consider this figure as any indication of proposed contract usage, nor base the proposed coefficient rates on any expectation that such levels of award will be made by the Government. | |||
| 2. This amount is based on the adjusted annual amount for each category listed times the proposed coefficient provided by the offeror. As in Note 1 above, this amount is for evaluation purposes only and does not reflect any anticipated volume of dollars to be awarded under the resulting contract. | |||
| 3. This figure will be used by the Government to determine which offeror has provided the lowest overall price to the Government. | |||
| 4. The offeror is responsible for ensuring all calculations are accurate. The Government will not be held responsible for any errors associated with the equations provided in this Excel document. |
&LAttachment S4&CFA4855-13-R-0009 &CPage &P of &N
Summary Table
| Base | Option 1 | Option 2 | Option 3 | Option 4 | |
| Type of Requirement | Coefficient Proposed (Insert value X.XXXXX) | Coefficient Proposed (Insert value X.XXXXX) | Coefficient Proposed (Insert value X.XXXXX) | Coefficient Proposed (Insert value X.XXXXX) | Coefficient Proposed (Insert value X.XXXXX) |
| Standard Requirement | 1.20 | 1.30 | 1.20 | 1.20 | 1.20 |
| Non-Standard Requirement | 1.10 | 0.97 | 1.10 | 1.10 | 1.10 |
| Emergency/Time Critical | 0.90 | 1.10 | 0.90 | 0.90 | 0.90 |
File details come from the government source that posted it. Updated .