jagomart
digital resources
picture1_Spreadsheet Calculator 46168 | Bid Matrix Application Seffa Project Nov 2021


 194x       Filetype XLSX       File size 0.02 MB       Source: endev.info


File: Spreadsheet Calculator 46168 | Bid Matrix Application Seffa Project Nov 2021
combined with your rbf proposal will be used to assess how realisticachievable your  ...

icon picture XLSX Filetype Excel XLSX | Posted on 17 Aug 2022 | 3 years ago
Partial file snippet.
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

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet rbf bid calculator name of applicant organization submission date ddmmyy note your verified past performance combined with proposal will be used to assess how realisticachievable sales projections are likely for more information and guidance refer the call applications add row if need provide per product county period beginning january september last quarter an contract finalization only include projection products proposed in section application template compute eur equivalent energy service potential esp bonus nbsp column e use tier calculation from table get corresponding rates then multiply rate base level incentive that quality assurance qa f total value g bli columns d is below h projected c grant should not exceed a b as project support units jan sep def machakos makueni kajiado kirinyaga meru muranga totals...

no reviews yet
Please Login to review.