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 ...

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...

Related files

Share

Help

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
Machakos						0	0
Makueni						0	0
Makueni						0	0
Kajiado						0	0
Kajiado						0	0
Kirinyaga						0	0
Kirinyaga						0	0
Meru						0	0
Meru						0	0
Muranga						0	0
Muranga						0	0
TOTALS		0				0	0

Related files

Share

Share to social media

Help

Login Area