194x Filetype XLSX File size 0.02 MB Source: endev.info
Sheet 1: RBF bid calculator
Name of Applicant (organization): | ||||||||
Submission Date (dd/mm/yy): | ||||||||
NOTE: Your verified past performance combined with your RBF proposal will be used to assess how realistic/achievable your RBF sales projections are likely to be (for more information and guidance refer to the Call for Applications). Add row if need be | ||||||||
Provide your sales projections per product per county for the period beginning January 2022 to September 2023 (Note: The last quarter of 2023 will be an RBF contract finalization period). Only include sales projection for the products proposed in section 4 of application template. | ||||||||
To compute the EUR equivalent of the Energy Service Potential (ESP) Bonus (Column E), use your Tier calculation (from your product table in section 4 of application template) to get the corresponding ESP bonus rates, then multiply the ESP Bonus rate with your proposed base level incentive for that product. | ||||||||
To compute the EUR equivalent of the Quality Assurance (QA) bonus (Column F), use your Tier calculation (from your product table in section 4 of application template) to get the corresponding QA bonus rate, then multiply the QA bonus rate with your proposed base level incentive for that product. | ||||||||
The total Incentive Value (Column G) = BLI + ESP + QA (Columns D, E, and F) is in the table below. | ||||||||
The total RBF Bid Value (Column H) = Projected sales (Column C) * Total Incentive Value (Column G). Grant total should not exceed EUR 100,000. | ||||||||
A | B | C | D | E | F | G | H | |
County | Product Name (as proposed for project support) | Projected Sales (Units) | Base Level Incentive (BLI) Value | Energy Service Potential (ESP) | Quality Assurance | Total Incentive Value | Total RBF Bid Value (EUR) | |
Jan 22 - Sep 23 | (EUR) | EUR = D * ESP Bonus Rate | EUR = D * QA Bonus Rate | EUR = D+E+F | ||||
Machakos | 0 | 0 | ||||||
0 | 0 | |||||||
Makueni | 0 | 0 | ||||||
0 | 0 | |||||||
Kajiado | 0 | 0 | ||||||
0 | 0 | |||||||
Kirinyaga | 0 | 0 | ||||||
0 | 0 | |||||||
Meru | 0 | 0 | ||||||
0 | 0 | |||||||
Muranga | 0 | 0 | ||||||
0 | 0 | |||||||
TOTALS | 0 | 0 | 0 |
no reviews yet
Please Login to review.