INFORMATIONAL - Rate Adjustment Example.xlsx
XLSX spreadsheet 142 KB Posted
- Attached to
- Space Enterprise Consortium Other Transaction Agreement Competition Federal contract opportunity
- Solicitation number
- FA8814-20-9-0001
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| SpEC Section 5.3 Document.docx | DOCX document | |
| SpEC Model Agreement.pdf | ||
| SpEC Solicitation 20200318.pdf |
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
Exponental Rate Sandbox
| 2d Lt George C Eberwine; 05 Mar 2020 | |
| IMPORTANT: All data in this spreadsheet represent an example only. No data on award size, throughput, or anything else should be taken as a forecast or projection of future awards. The intent of this spreadsheet is to allow for experimentation with an exponentially decaying rate structure only. The government does not guarantee that the contents of this document are error-free. Any use of this spreadsheet to calculate either estimates or values for proposal development is done at the Offeror's own risk. |
| Table 5.3.1A: Offeror’s Proposed Rate Adjustment Formula Inputs | Do not change this area, for calculation purposes only | ||||||||
| Description | Symbol | CM Proposed Value: | The number e | 2.71828182845904 | |||||
| Initial CM-Rate % | FI | 2.00% | <-- Insert CM Proposed | ||||||
| Rate-Reduction Constant | 2.50E-09 | <-- Insert CM Proposed | |||||||
| These two columns for generating data labels only | Award Amount | Rate | Minimum Rate | n/a | 0.57% | <-- Insert CM Proposed | [DETERMINED BY OFFEROR] | ||
| 0 | 2.00% | 0 | 2.00% | Dollar Value at which Min Rate is reached | n/a | $500,000,000 | <-- ENTER MANUALLY | [DETERMINED BY INPUT VALUES AND MINIMUM RATE SELECTED, does not auto-calculate, to display on graph, one must edit Colulmn C and D accordingly] | |
| 1000000 | 2.00% | In order to experiment with the function, simply alter the values of initial rate above and/or lambda to modify the equation. Throughout the spreadsheet, the green boxes are intended for your input. The orange boxes above do not automatically calcualte anything or affect the graph below. | |||||||
| 2000000 | 1.99% | ||||||||
| 3000000 | 1.99% | ||||||||
| 4000000 | 1.98% | ||||||||
| 5000000 | 1.98% | Calculator: Insert Award Amount | |||||||
| 6000000 | 1.97% | Award Amount | $123,456,789 | <-- Insert exact amount for which rate is to be calculated | |||||
| 7000000 | 1.97% | Rate Percentage | 1.47% | ||||||
| 8000000 | 1.96% | Rate Dollar Amount | $1,813,441.15 | ||||||
| 9000000 | 1.96% | ||||||||
| 10000000 | 1.95% | ||||||||
| 11000000 | 1.95% | ||||||||
| 12000000 | 1.94% | ||||||||
| 13000000 | 1.94% | ||||||||
| 14000000 | 1.93% | ||||||||
| 15000000 | 1.93% | ||||||||
| 16000000 | 1.92% | ||||||||
| 17000000 | 1.92% | ||||||||
| 18000000 | 1.91% | ||||||||
| 19000000 | 1.91% | ||||||||
| 20000000 | 1.90% | ||||||||
| 21000000 | 1.90% | ||||||||
| 22000000 | 1.89% | ||||||||
| 23000000 | 1.89% | ||||||||
| 24000000 | 1.88% | ||||||||
| 25000000 | 1.88% | ||||||||
| 26000000 | 1.87% | ||||||||
| 27000000 | 1.87% | ||||||||
| 28000000 | 1.86% | ||||||||
| 29000000 | 1.86% | ||||||||
| 30000000 | 1.86% | ||||||||
| 31000000 | 1.85% | ||||||||
| 32000000 | 1.85% | ||||||||
| 33000000 | 1.84% | ||||||||
| 34000000 | 1.84% | ||||||||
| 35000000 | 1.83% | ||||||||
| 36000000 | 1.83% | ||||||||
| 37000000 | 1.82% | ||||||||
| 38000000 | 1.82% | ||||||||
| 39000000 | 1.81% | ||||||||
| 40000000 | 1.81% | ||||||||
| 41000000 | 1.81% | ||||||||
| 42000000 | 1.80% | ||||||||
| 43000000 | 1.80% | ||||||||
| 44000000 | 1.79% | ||||||||
| 45000000 | 1.79% | ||||||||
| 46000000 | 1.78% | ||||||||
| 47000000 | 1.78% | ||||||||
| 48000000 | 1.77% | ||||||||
| 49000000 | 1.77% | ||||||||
| 50000000 | 1.76% | 50000000 | 1.76% | ||||||
| 51000000 | 1.76% | ||||||||
| 52000000 | 1.76% | ||||||||
| 53000000 | 1.75% | Table 5.3.1B: EXAMPLE Year Awards | |||||||
| 54000000 | 1.75% | Number of Projects | Project Value | Rate % | Per-Project Rate | Totals | |||
| 55000000 | 1.74% | (ProjValue)x(Rate%) | (Per-Proj Rate)x(#Proj) | Sum(Proj x # Proj) | |||||
| 56000000 | 1.74% | 1 | $1,000,000.00 | 2.00% | $19,950.06 | $19,950.06 | $1,000,000.00 | ||
| 57000000 | 1.73% | 3 | $3,000,000.00 | 1.99% | $59,551.68 | $178,655.05 | $9,000,000.00 | ||
| 58000000 | 1.73% | 4 | $10,000,000.00 | 1.95% | $195,061.98 | $780,247.93 | $40,000,000.00 | ||
| 59000000 | 1.73% | 5 | $30,000,000.00 | 1.86% | $556,646.09 | $2,783,230.46 | $150,000,000.00 | ||
| 60000000 | 1.72% | 2 | $100,000,000.00 | 1.56% | $1,557,601.57 | $3,115,203.13 | $200,000,000.00 | ||
| 61000000 | 1.72% | 2 | $300,000,000.00 | 0.94% | $2,834,199.32 | $5,668,398.63 | $600,000,000.00 | ||
| 62000000 | 1.71% | 0 | $500,000,000.00 | 0.57% | $2,865,047.97 | $0.00 | $0.00 | ||
| 63000000 | 1.71% | Project Sum $ = Sum((Value)x(#Proj)) | Effective Rate % =($Total)/($1,000,000,000.00) | [Black out these cells because summing this column yields a meaningless number] | RateTotal $ (TECG) =Sum((Per Proj Rate)x(#Proj)) | ||||
| 64000000 | 1.70% | $1,000,000,000.00 | 1.25% | $12,545,685.27 | |||||
| 65000000 | 1.70% | # OF AWARDS REPRESENT AN EXAMPLE, NOT A FORECAST/PROJECTON OF FUTURE THROUGHPUT; The government does not guarantee that the contents of this document are error-free. Any use of this spreadsheet to calculate either estimates or values for proposal development is done at the Offeror's own risk. | |||||||
| 66000000 | 1.70% | ||||||||
| 67000000 | 1.69% | ||||||||
| 68000000 | 1.69% | The effective rate is not a proposed value, but is a value calculated back out of the total throughput and the total compensation. This is for comparison purposes and shows what the total compensation (in %) would have been if it had been a flat-rate across the entire throughput. | |||||||
| 69000000 | 1.68% | ||||||||
| 70000000 | 1.68% | ||||||||
| 71000000 | 1.67% | ||||||||
| 72000000 | 1.67% | ||||||||
| 73000000 | 1.67% | ||||||||
| 74000000 | 1.66% | ||||||||
| 75000000 | 1.66% | ||||||||
| 76000000 | 1.65% | ||||||||
| 77000000 | 1.65% | ||||||||
| 78000000 | 1.65% | ||||||||
| 79000000 | 1.64% | ||||||||
| 80000000 | 1.64% | ||||||||
| 81000000 | 1.63% | ||||||||
| 82000000 | 1.63% | ||||||||
| 83000000 | 1.63% | ||||||||
| 84000000 | 1.62% | ||||||||
| 85000000 | 1.62% | ||||||||
| 86000000 | 1.61% | ||||||||
| 87000000 | 1.61% | ||||||||
| 88000000 | 1.61% | ||||||||
| 89000000 | 1.60% | ||||||||
| 90000000 | 1.60% | ||||||||
| 91000000 | 1.59% | ||||||||
| 92000000 | 1.59% | ||||||||
| 93000000 | 1.59% | ||||||||
| 94000000 | 1.58% | ||||||||
| 95000000 | 1.58% | ||||||||
| 96000000 | 1.57% | ||||||||
| 97000000 | 1.57% | ||||||||
| 98000000 | 1.57% | ||||||||
| 99000000 | 1.56% | ||||||||
| 100000000 | 1.56% | 100000000 | 1.56% | ||||||
| 101000000 | 1.55% | ||||||||
| 102000000 | 1.55% | ||||||||
| 103000000 | 1.55% | ||||||||
| 104000000 | 1.54% | ||||||||
| 105000000 | 1.54% | ||||||||
| 106000000 | 1.53% | ||||||||
| 107000000 | 1.53% | ||||||||
| 108000000 | 1.53% | ||||||||
| 109000000 | 1.52% | ||||||||
| 110000000 | 1.52% | ||||||||
| 111000000 | 1.52% | ||||||||
| 112000000 | 1.51% | ||||||||
| 113000000 | 1.51% | ||||||||
| 114000000 | 1.50% | ||||||||
| 115000000 | 1.50% | ||||||||
| 116000000 | 1.50% | ||||||||
| 117000000 | 1.49% | ||||||||
| 118000000 | 1.49% | ||||||||
| 119000000 | 1.49% | ||||||||
| 120000000 | 1.48% | ||||||||
| 121000000 | 1.48% | ||||||||
| 122000000 | 1.47% | ||||||||
| 123000000 | 1.47% | ||||||||
| 124000000 | 1.47% | ||||||||
| 125000000 | 1.46% | ||||||||
| 126000000 | 1.46% | ||||||||
| 127000000 | 1.46% | ||||||||
| 128000000 | 1.45% | ||||||||
| 129000000 | 1.45% | ||||||||
| 130000000 | 1.45% | ||||||||
| 131000000 | 1.44% | ||||||||
| 132000000 | 1.44% | ||||||||
| 133000000 | 1.43% | ||||||||
| 134000000 | 1.43% | ||||||||
| 135000000 | 1.43% | ||||||||
| 136000000 | 1.42% | ||||||||
| 137000000 | 1.42% | ||||||||
| 138000000 | 1.42% | ||||||||
| 139000000 | 1.41% | ||||||||
| 140000000 | 1.41% | ||||||||
| 141000000 | 1.41% | ||||||||
| 142000000 | 1.40% | ||||||||
| 143000000 | 1.40% | ||||||||
| 144000000 | 1.40% | ||||||||
| 145000000 | 1.39% | ||||||||
| 146000000 | 1.39% | ||||||||
| 147000000 | 1.38% | ||||||||
| 148000000 | 1.38% | ||||||||
| 149000000 | 1.38% | ||||||||
| 150000000 | 1.37% | 150000000 | 1.37% | ||||||
| 151000000 | 1.37% | ||||||||
| 152000000 | 1.37% | ||||||||
| 153000000 | 1.36% | ||||||||
| 154000000 | 1.36% | ||||||||
| 155000000 | 1.36% | ||||||||
| 156000000 | 1.35% | ||||||||
| 157000000 | 1.35% | ||||||||
| 158000000 | 1.35% | ||||||||
| 159000000 | 1.34% | ||||||||
| 160000000 | 1.34% | ||||||||
| 161000000 | 1.34% | ||||||||
| 162000000 | 1.33% | ||||||||
| 163000000 | 1.33% | ||||||||
| 164000000 | 1.33% | ||||||||
| 165000000 | 1.32% | ||||||||
| 166000000 | 1.32% | ||||||||
| 167000000 | 1.32% | ||||||||
| 168000000 | 1.31% | ||||||||
| 169000000 | 1.31% | ||||||||
| 170000000 | 1.31% | ||||||||
| 171000000 | 1.30% | ||||||||
| 172000000 | 1.30% | ||||||||
| 173000000 | 1.30% | ||||||||
| 174000000 | 1.29% | ||||||||
| 175000000 | 1.29% | ||||||||
| 176000000 | 1.29% | ||||||||
| 177000000 | 1.28% | ||||||||
| 178000000 | 1.28% | ||||||||
| 179000000 | 1.28% | ||||||||
| 180000000 | 1.28% | ||||||||
| 181000000 | 1.27% | ||||||||
| 182000000 | 1.27% | ||||||||
| 183000000 | 1.27% | ||||||||
| 184000000 | 1.26% | ||||||||
| 185000000 | 1.26% | ||||||||
| 186000000 | 1.26% | ||||||||
| 187000000 | 1.25% | ||||||||
| 188000000 | 1.25% | ||||||||
| 189000000 | 1.25% | ||||||||
| 190000000 | 1.24% | ||||||||
| 191000000 | 1.24% | ||||||||
| 192000000 | 1.24% | ||||||||
| 193000000 | 1.23% | ||||||||
| 194000000 | 1.23% | ||||||||
| 195000000 | 1.23% | ||||||||
| 196000000 | 1.23% | ||||||||
| 197000000 | 1.22% | ||||||||
| 198000000 | 1.22% | ||||||||
| 199000000 | 1.22% | ||||||||
| 200000000 | 1.21% | 200000000 | 1.21% | ||||||
| 201000000 | 1.21% | ||||||||
| 202000000 | 1.21% | ||||||||
| 203000000 | 1.20% | ||||||||
| 204000000 | 1.20% | ||||||||
| 205000000 | 1.20% | ||||||||
| 206000000 | 1.20% | ||||||||
| 207000000 | 1.19% | ||||||||
| 208000000 | 1.19% | ||||||||
| 209000000 | 1.19% | ||||||||
| 210000000 | 1.18% | ||||||||
| 211000000 | 1.18% | ||||||||
| 212000000 | 1.18% | ||||||||
| 213000000 | 1.17% | ||||||||
| 214000000 | 1.17% | ||||||||
| 215000000 | 1.17% | ||||||||
| 216000000 | 1.17% | ||||||||
| 217000000 | 1.16% | ||||||||
| 218000000 | 1.16% | ||||||||
| 219000000 | 1.16% | ||||||||
| 220000000 | 1.15% | ||||||||
| 221000000 | 1.15% | ||||||||
| 222000000 | 1.15% | ||||||||
| 223000000 | 1.15% | ||||||||
| 224000000 | 1.14% | ||||||||
| 225000000 | 1.14% | ||||||||
| 226000000 | 1.14% | ||||||||
| 227000000 | 1.13% | ||||||||
| 228000000 | 1.13% | ||||||||
| 229000000 | 1.13% | ||||||||
| 230000000 | 1.13% | ||||||||
| 231000000 | 1.12% | ||||||||
| 232000000 | 1.12% | ||||||||
| 233000000 | 1.12% | ||||||||
| 234000000 | 1.11% | ||||||||
| 235000000 | 1.11% | ||||||||
| 236000000 | 1.11% | ||||||||
| 237000000 | 1.11% | ||||||||
| 238000000 | 1.10% | ||||||||
| 239000000 | 1.10% | ||||||||
| 240000000 | 1.10% | ||||||||
| 241000000 | 1.09% | ||||||||
| 242000000 | 1.09% | ||||||||
| 243000000 | 1.09% | ||||||||
| 244000000 | 1.09% | ||||||||
| 245000000 | 1.08% | ||||||||
| 246000000 | 1.08% | ||||||||
| 247000000 | 1.08% | ||||||||
| 248000000 | 1.08% | ||||||||
| 249000000 | 1.07% | ||||||||
| 250000000 | 1.07% | 250000000 | 1.07% | ||||||
| 251000000 | 1.07% | ||||||||
| 252000000 | 1.07% | ||||||||
| 253000000 | 1.06% | ||||||||
| 254000000 | 1.06% | ||||||||
| 255000000 | 1.06% | ||||||||
| 256000000 | 1.05% | ||||||||
| 257000000 | 1.05% | ||||||||
| 258000000 | 1.05% | ||||||||
| 259000000 | 1.05% | ||||||||
| 260000000 | 1.04% | ||||||||
| 261000000 | 1.04% | ||||||||
| 262000000 | 1.04% | ||||||||
| 263000000 | 1.04% | ||||||||
| 264000000 | 1.03% | ||||||||
| 265000000 | 1.03% | ||||||||
| 266000000 | 1.03% | ||||||||
| 267000000 | 1.03% | ||||||||
| 268000000 | 1.02% | ||||||||
| 269000000 | 1.02% | ||||||||
| 270000000 | 1.02% | ||||||||
| 271000000 | 1.02% | ||||||||
| 272000000 | 1.01% | ||||||||
| 273000000 | 1.01% | ||||||||
| 274000000 | 1.01% | ||||||||
| 275000000 | 1.01% | ||||||||
| 276000000 | 1.00% | ||||||||
| 277000000 | 1.00% | ||||||||
| 278000000 | 1.00% | ||||||||
| 279000000 | 1.00% | ||||||||
| 280000000 | 0.99% | ||||||||
| 281000000 | 0.99% | ||||||||
| 282000000 | 0.99% | ||||||||
| 283000000 | 0.99% | ||||||||
| 284000000 | 0.98% | ||||||||
| 285000000 | 0.98% | ||||||||
| 286000000 | 0.98% | ||||||||
| 287000000 | 0.98% | ||||||||
| 288000000 | 0.97% | ||||||||
| 289000000 | 0.97% | ||||||||
| 290000000 | 0.97% | ||||||||
| 291000000 | 0.97% | ||||||||
| 292000000 | 0.96% | ||||||||
| 293000000 | 0.96% | ||||||||
| 294000000 | 0.96% | ||||||||
| 295000000 | 0.96% | ||||||||
| 296000000 | 0.95% | ||||||||
| 297000000 | 0.95% | ||||||||
| 298000000 | 0.95% | ||||||||
| 299000000 | 0.95% | ||||||||
| 300000000 | 0.94% | 300000000 | 0.94% | ||||||
| 301000000 | 0.94% | ||||||||
| 302000000 | 0.94% | ||||||||
| 303000000 | 0.94% | ||||||||
| 304000000 | 0.94% | ||||||||
| 305000000 | 0.93% | ||||||||
| 306000000 | 0.93% | ||||||||
| 307000000 | 0.93% | ||||||||
| 308000000 | 0.93% | ||||||||
| 309000000 | 0.92% | ||||||||
| 310000000 | 0.92% | ||||||||
| 311000000 | 0.92% | ||||||||
| 312000000 | 0.92% | ||||||||
| 313000000 | 0.91% | ||||||||
| 314000000 | 0.91% | ||||||||
| 315000000 | 0.91% | ||||||||
| 316000000 | 0.91% | ||||||||
| 317000000 | 0.91% | ||||||||
| 318000000 | 0.90% | ||||||||
| 319000000 | 0.90% | ||||||||
| 320000000 | 0.90% | ||||||||
| 321000000 | 0.90% | ||||||||
| 322000000 | 0.89% | ||||||||
| 323000000 | 0.89% | ||||||||
| 324000000 | 0.89% | ||||||||
| 325000000 | 0.89% | ||||||||
| 326000000 | 0.89% | ||||||||
| 327000000 | 0.88% | ||||||||
| 328000000 | 0.88% | ||||||||
| 329000000 | 0.88% | ||||||||
| 330000000 | 0.88% | ||||||||
| 331000000 | 0.87% | ||||||||
| 332000000 | 0.87% | ||||||||
| 333000000 | 0.87% | ||||||||
| 334000000 | 0.87% | ||||||||
| 335000000 | 0.87% | ||||||||
| 336000000 | 0.86% | ||||||||
| 337000000 | 0.86% | ||||||||
| 338000000 | 0.86% | ||||||||
| 339000000 | 0.86% | ||||||||
| 340000000 | 0.85% | ||||||||
| 341000000 | 0.85% | ||||||||
| 342000000 | 0.85% | ||||||||
| 343000000 | 0.85% | ||||||||
| 344000000 | 0.85% | ||||||||
| 345000000 | 0.84% | ||||||||
| 346000000 | 0.84% | ||||||||
| 347000000 | 0.84% | ||||||||
| 348000000 | 0.84% | ||||||||
| 349000000 | 0.84% | ||||||||
| 350000000 | 0.83% | 350000000 | 0.83% | ||||||
| 351000000 | 0.83% | ||||||||
| 352000000 | 0.83% | ||||||||
| 353000000 | 0.83% | ||||||||
| 354000000 | 0.83% | ||||||||
| 355000000 | 0.82% | ||||||||
| 356000000 | 0.82% | ||||||||
| 357000000 | 0.82% | ||||||||
| 358000000 | 0.82% | ||||||||
| 359000000 | 0.82% | ||||||||
| 360000000 | 0.81% | ||||||||
| 361000000 | 0.81% | ||||||||
| 362000000 | 0.81% | ||||||||
| 363000000 | 0.81% | ||||||||
| 364000000 | 0.81% | ||||||||
| 365000000 | 0.80% | ||||||||
| 366000000 | 0.80% | ||||||||
| 367000000 | 0.80% | ||||||||
| 368000000 | 0.80% | ||||||||
| 369000000 | 0.80% | ||||||||
| 370000000 | 0.79% | ||||||||
| 371000000 | 0.79% | ||||||||
| 372000000 | 0.79% | ||||||||
| 373000000 | 0.79% | ||||||||
| 374000000 | 0.79% | ||||||||
| 375000000 | 0.78% | ||||||||
| 376000000 | 0.78% | ||||||||
| 377000000 | 0.78% | ||||||||
| 378000000 | 0.78% | ||||||||
| 379000000 | 0.78% | ||||||||
| 380000000 | 0.77% | ||||||||
| 381000000 | 0.77% | ||||||||
| 382000000 | 0.77% | ||||||||
| 383000000 | 0.77% | ||||||||
| 384000000 | 0.77% | ||||||||
| 385000000 | 0.76% | ||||||||
| 386000000 | 0.76% | ||||||||
| 387000000 | 0.76% | ||||||||
| 388000000 | 0.76% | ||||||||
| 389000000 | 0.76% | ||||||||
| 390000000 | 0.75% | ||||||||
| 391000000 | 0.75% | ||||||||
| 392000000 | 0.75% | ||||||||
| 393000000 | 0.75% | ||||||||
| 394000000 | 0.75% | ||||||||
| 395000000 | 0.75% | ||||||||
| 396000000 | 0.74% | ||||||||
| 397000000 | 0.74% | ||||||||
| 398000000 | 0.74% | ||||||||
| 399000000 | 0.74% | ||||||||
| 400000000 | 0.74% | 400000000 | 0.74% | ||||||
| 401000000 | 0.73% | ||||||||
| 402000000 | 0.73% | ||||||||
| 403000000 | 0.73% | ||||||||
| 404000000 | 0.73% | ||||||||
| 405000000 | 0.73% | ||||||||
| 406000000 | 0.72% | ||||||||
| 407000000 | 0.72% | ||||||||
| 408000000 | 0.72% | ||||||||
| 409000000 | 0.72% | ||||||||
| 410000000 | 0.72% | ||||||||
| 411000000 | 0.72% | ||||||||
| 412000000 | 0.71% | ||||||||
| 413000000 | 0.71% | ||||||||
| 414000000 | 0.71% | ||||||||
| 415000000 | 0.71% | ||||||||
| 416000000 | 0.71% | ||||||||
| 417000000 | 0.71% | ||||||||
| 418000000 | 0.70% | ||||||||
| 419000000 | 0.70% | ||||||||
| 420000000 | 0.70% | ||||||||
| 421000000 | 0.70% | ||||||||
| 422000000 | 0.70% | ||||||||
| 423000000 | 0.69% | ||||||||
| 424000000 | 0.69% | ||||||||
| 425000000 | 0.69% | ||||||||
| 426000000 | 0.69% | ||||||||
| 427000000 | 0.69% | ||||||||
| 428000000 | 0.69% | ||||||||
| 429000000 | 0.68% | ||||||||
| 430000000 | 0.68% | ||||||||
| 431000000 | 0.68% | ||||||||
| 432000000 | 0.68% | ||||||||
| 433000000 | 0.68% | ||||||||
| 434000000 | 0.68% | ||||||||
| 435000000 | 0.67% | ||||||||
| 436000000 | 0.67% | ||||||||
| 437000000 | 0.67% | ||||||||
| 438000000 | 0.67% | ||||||||
| 439000000 | 0.67% | ||||||||
| 440000000 | 0.67% | ||||||||
| 441000000 | 0.66% | ||||||||
| 442000000 | 0.66% | ||||||||
| 443000000 | 0.66% | ||||||||
| 444000000 | 0.66% | ||||||||
| 445000000 | 0.66% | ||||||||
| 446000000 | 0.66% | ||||||||
| 447000000 | 0.65% | ||||||||
| 448000000 | 0.65% | ||||||||
| 449000000 | 0.65% | ||||||||
| 450000000 | 0.65% | 450000000 | 0.65% | ||||||
| 451000000 | 0.65% | ||||||||
| 452000000 | 0.65% | ||||||||
| 453000000 | 0.64% | ||||||||
| 454000000 | 0.64% | ||||||||
| 455000000 | 0.64% | ||||||||
| 456000000 | 0.64% | ||||||||
| 457000000 | 0.64% | ||||||||
| 458000000 | 0.64% | ||||||||
| 459000000 | 0.63% | ||||||||
| 460000000 | 0.63% | ||||||||
| 461000000 | 0.63% | ||||||||
| 462000000 | 0.63% | ||||||||
| 463000000 | 0.63% | ||||||||
| 464000000 | 0.63% | ||||||||
| 465000000 | 0.63% | ||||||||
| 466000000 | 0.62% | ||||||||
| 467000000 | 0.62% | ||||||||
| 468000000 | 0.62% | ||||||||
| 469000000 | 0.62% | ||||||||
| 470000000 | 0.62% | ||||||||
| 471000000 | 0.62% | ||||||||
| 472000000 | 0.61% | ||||||||
| 473000000 | 0.61% | ||||||||
| 474000000 | 0.61% | ||||||||
| 475000000 | 0.61% | ||||||||
| 476000000 | 0.61% | ||||||||
| 477000000 | 0.61% | ||||||||
| 478000000 | 0.61% | ||||||||
| 479000000 | 0.60% | ||||||||
| 480000000 | 0.60% | ||||||||
| 481000000 | 0.60% | ||||||||
| 482000000 | 0.60% | ||||||||
| 483000000 | 0.60% | ||||||||
| 484000000 | 0.60% | ||||||||
| 485000000 | 0.59% | ||||||||
| 486000000 | 0.59% | ||||||||
| 487000000 | 0.59% | ||||||||
| 488000000 | 0.59% | ||||||||
| 489000000 | 0.59% | ||||||||
| 490000000 | 0.59% | ||||||||
| 491000000 | 0.59% | ||||||||
| 492000000 | 0.58% | ||||||||
| 493000000 | 0.58% | ||||||||
| 494000000 | 0.58% | ||||||||
| 495000000 | 0.58% | ||||||||
| 496000000 | 0.58% | ||||||||
| 497000000 | 0.58% | ||||||||
| 498000000 | 0.58% | ||||||||
| 499000000 | 0.57% | ||||||||
| 500000000 | 0.57% | 500000000 | 0.57% |
Exponentially Decaying Rate Structure
Function= F(D)=FI·e- λD
FI = Initial Rate F(D) = Rate at any dollar amount e = the number e Lambda = "Rate-reduction-constant" D = The dollar amount at which the rate is to be calculated Exponentially Decaying Rate Based on Award Amount
| 0 | 1000000 | 2000000 | 3000000 | 4000000 | 5000000 | 6000000 | 7000000 | 8000000 | 9000000 | 10000000 | 11000000 | 12000000 | 13000000 | 14000000 | 15000000 | 16000000 | 17000000 | 18000000 | 19000000 | 20000000 | 21000000 | 22000000 | 23000000 | 24000000 | 25000000 | 26000000 | 27000000 | 28000000 | 29000000 | 30000000 | 31000000 | 32000000 | 33000000 | 34000000 | 35000000 | 36000000 | 37000000 | 38000000 | 39000000 | 40000000 | 41000000 | 42000000 | 43000000 | 44000000 | 45000000 | 46000000 | 47000000 | 48000000 | 49000000 |
| 0 | 50000000 | 100000000 | 150000000 | 200000000 | 250000000 | 300000000 | 350000000 | 400000000 | 450000000 | 500000000 | 0.02 | 1.7649938051691912E-2 | 1.5576015661428105E-2 | 1.3745785575819455E-2 | 1.213061319425268E-2 | 1.0705228570379819E-2 | 9.4473310548203078E-3 | 8.3372403935701809E-3 | 7.3575888234288598E-3 | 6.4930493471670094E-3 | 5.7300959372038164E-3 | Prototype Award Value ($) |
Rate % image1.png image2.jpeg
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .