Attachment_S4A_Coefficient_Spreadsheet_(Example).xls
XLS spreadsheet 52 KB Posted
- Attached to
- CANNON AFB, NM SABER Federal contract opportunity
- Solicitation number
- FA4855-13-R-0009
About this file
Attachment S4a
View the file
Other files for this federal contract opportunity
Show all 50
CANNON AFB, NM SABER 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
Sheet1
| COEFFICIENT SPREADSHEET | |||
| Offeror's Name: | |||
| Base Performance Period (based on an average volume of $5,000,000)(Note 1) | |||
| Type of Requirement | Adjusted Annual Amount Based on Percent of Average Volume | Coefficient Proposed (Insert value 1.XXXXX) | Adjusted Total Estimated Value (Note 2) |
| Standard Requirement | $ 3,750,000 | 1.175 | $ 4,406,250 |
| Non-Standard Requirement | $ 1,150,000 | 1.235 | $ 1,420,250 |
| Emergency/Time Critical | $ 100,000 | 1.25 | $ 125,000 |
| Total Estimated Usage | $ 5,000,000 | $ 5,951,500 | |
| Option Period 1 (based on an average volume of $5,000,000) | |||
| Type of Requirement | Adjusted Annual Amount Based on Percent of Average Volume | Coefficient Proposed (Insert value 1.XXXXX) | Adjusted Total Estimated Value (Note 2) |
| Standard Requirement | $ 3,750,000 | 1.7755 | $ 6,658,125 |
| Non-Standard Requirement | $ 1,150,000 | 1.235 | $ 1,420,250 |
| Emergency/Time Critical | $ 100,000 | 1.25 | $ 125,000 |
| Total Estimated Usage | $ 5,000,000 | $ 8,078,375 | |
| Option Period 2 (based on an average volume of $5,000,000) | |||
| Type of Requirement | Adjusted Annual Amount Based on Percent of Average Volume | Coefficient Proposed (Insert value 1.XXXXX) | Adjusted Total Estimated Value (Note 2) |
| Standard Requirement | $ 3,750,000 | 1.18125 | $ 4,429,688 |
| Non-Standard Requirement | $ 1,150,000 | 1.235 | $ 1,420,250 |
| Emergency/Time Critical | $ 100,000 | 1.25 | $ 125,000 |
| Total Estimated Usage | $ 5,000,000 | $ 5,849,938 | |
| Option Period 3 (based on an average volume of $5,000,000) | |||
| Type of Requirement | Adjusted Annual Amount Based on Percent of Average Volume | Coefficient Proposed (Insert value 1.XXXXX) | Adjusted Total Estimated Value (Note 2) |
| Standard Requirement | $ 3,750,000 | 1.18255 | $ 4,434,563 |
| Non-Standard Requirement | $ 1,150,000 | 1.235 | $ 1,420,250 |
| Emergency/Time Critical | $ 100,000 | 1.25 | $ 125,000 |
| Total Estimated Usage | $ 5,000,000 | $ 5,854,813 | |
| Option Period 4 (based on an average volume of $5,000,000) | |||
| Type of Requirement | Adjusted Annual Amount Based on Percent of Average Volume | Coefficient Proposed (Insert value 1.XXXXX) | Adjusted Total Estimated Value (Note 3) |
| Standard Requirement | $ 3,750,000 | 1.1875 | $ 4,453,125 |
| Non-Standard Requirement | $ 1,150,000 | 1.235 | $ 1,420,250 |
| Emergency/Time Critical | $ 100,000 | 1.25 | $ 125,000 |
| Total Estimated Usage | $ 5,000,000 | $ 5,873,375 | |
| TOTAL PROPOSED PRICE FOR ALL YEARS (Note 3) | $ 31,608,000 | ||
| NOTES: | |||
| 1. Average volume is based on a maximum contract value of $25M over 5 years ($5M 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. | |||
| 5. Coefficient information provided in this example is for demonstration purposes only and does not represent actual or past coefficient figures. |
&LAttachment S4A&CFA4855-13-R-0009&R&"Arial,Bold"&14&KFF0000EXAMPLE &CPage &P of &N
Sheet2
Sheet3
File details come from the government source that posted it. Updated .