Exhibit D - Price Proposal Table.xlsx

XLSX spreadsheet 34 KB Posted Nov 2, 2022

Attached to: Provide High Voltage Electricity At US Naval Support Facility, Romanian Military Base, Deveselu, Romania
Solicitation number: N3319123R9002
Issued by: Department of the Navy Naval Facilities Engineering Command

View the file

Other files

File	Type	Posted
Amend 0002.pdf	PDF	Nov 28, 2022
Exhibit A - Experience Providing Electric Supply (Amend 0001).docx	DOCX document	Nov 9, 2022
Amend 0001.pdf	PDF	Nov 9, 2022
Exhibit C - Regulated Charges Information Form.docx	DOCX document	Nov 2, 2022
RFP- N33191-22-R-4023 Romania Electricity 11_2_22.pdf	PDF	Nov 2, 2022
Exhibit A - Experience Providing Electric Supply.docx	DOCX document	Nov 2, 2022
Enclosure1_to_5_Draft.xlsx	XLSX spreadsheet	Nov 2, 2022
Exhibit B - Letter of Financial Capability.docx	DOCX document	Nov 2, 2022
Exhibit E - Provisions.pdf	PDF	Nov 2, 2022
Exhibit F - Historic Hourly Energy Consumption.pdf	PDF	Nov 2, 2022

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Price Proposal Table

	Solicitation N33191-22-R-4023
	EXHIBIT D - Price Proposal Table
		Period	PIsol
			Published OpCom Index by Formula [lei/MWh]	Transaction Fee
[lei/MWh]	Reference Consumption [MWh]	Total Annual Values

(PI+TF)*Consumption (lei)

1st year	0.00	fill in	14,660.00	ERROR:#VALUE!
2nd year	0.00	fill in	14,660.00	ERROR:#VALUE!
3rd year	0.00	fill in	14,660.00	ERROR:#VALUE!
		TOTAL OFFER VALUE [LEI]		ERROR:#VALUE!

NOTEs:

PIsol is given only for the purpose of price evaluation as a coefficient of the solicitation and is equal for all three years.

TF = Transaction Fees for each of the three one-year periods. The Transaction fee shall remain constant during each of the three years of contract performance. Transaction fees can be different by year.

In order to avoid errors in filling a cell this sheet has been protected - Please fill out the highlighted yellow cells 'fill out' only, in LEI/MWh (€/MWh XX.XX) currency, two decimals only.

The Government’s evaluation of price will be based on "Total Offer Value" that is the sum of the three Total Annual Values

The Government evaluation of price will be based on consumption referred to CY2021 [MWh] indicated in above table

For Price evaluation Sample Only: (see tab "Price Proposal Example")

Statement: The Offeror agrees to hold the offer price for 10 days from the date of submission.

Signature, Date, and Stamp:

PI sol Romania OPCOM Prices, Price Index Tables, Calculation of PIsol for Solicitation Evaluation ROPEX FM (opcom.ro)

	OPCOM Prices 2023 (lei)
	Day 1	Day 2	Day 3	Day 4	Day 5			Price Index Table 2023*
Delivery Month	17-Oct	18-Oct	19-Oct	20-Oct	21-Oct	2022	Delivery Month	5-Day Average	Consumption Profile	5-Day Weighted Average
Jan-23	914.14	914.14	914.14	914.14	914.14		Jan-23	914.14	9%	82.62
Feb-23	914.16	914.16	914.16	914.16	914.16		Feb-23	914.16	8%	76.70
Mar-23	899.75	899.75	899.75	899.75	899.75		Mar-23	899.75	8%	76.41
Apr-23	895.79	895.79	895.79	895.79	895.79		Apr-23	895.79	8%	68.44
May-23	859.17	859.17	859.17	859.17	859.17		May-23	859.17	8%	68.57
Jun-23	859.19	859.19	859.19	859.19	859.19		Jun-23	859.19	8%	72.67
Jul-23	852.31	852.31	852.31	852.31	852.31		Jul-23	852.31	9%	72.67
Aug-23	852.31	852.31	852.31	852.31	852.31		Aug-23	852.31	9%	72.96
Sep-23	852.31	852.31	852.31	852.31	852.31		Sep-23	852.31	8%	68.02
Oct-23	852.31	852.31	852.31	852.31	852.31		Oct-23	852.31	8%	67.73
Nov-23	852.31	852.31	852.31	852.31	852.31		Nov-23	852.31	8%	68.31
Dec-23	852.31	852.31	852.31	852.31	852.31		Dec-23	852.31	9%	76.45
							Annual Average	871.34	100%	871.57
								*Sep dates used as placeholder (9/26-9/30/2022)

Notes:
OPCOM pricing published on	ROPEX FM (opcom.ro)
PI formula: AVERAGE [Average (Day 1: 12 months of forwards) + Average (Day 2: 12 months of forwards) + Average (Day 3: 12 months of forwards) + Average (Day 4: 12 months of futures) + Average (Day 5: 12 months of forwards)]
FOR SOLICITATION PURPOSE ONLY, Day 1 corresponds to October 17, 2022

https://www.opcom.ro/rapoarte/ropexfm.php?lang=rohttps://www.opcom.ro/rapoarte/ropexfm.php?lang=ro PI Table

Romania OPCOM Prices, Price Index Tables, and Calculations for Interim Price Adjustments

ROPEX FM (opcom.ro)

Pricing Table

Three-year contract with index and pre-determined formulas

OPCOM Prices 2023 (lei)

Contract

Supplier Markup:

51%

Day 1

Day 2

Day 3

Day 4

Day 5

Price Index Table 2023*

Delivery Month

12-Dec

13-Dec

14-Dec

15-Dec

16-Dec

2022

Delivery Month

5-Day Average

Consumption Profile

5-Day Weighted Average

NAS Deveselu

Period

PI* (lei/MWh)

CLIN Transaction Fee (lei/MWh)

Total Offer Price (PI + CLIN fee) (lei/MWh)

Jan-23

Year 1 (2023)

Feb-23

Year 2 (2024)

Mar-23

Year 3 (2025)

Apr-23

May-23

Jun-23

Jul-23

Aug-23

Sep-23

Oct-23

Nov-23

Dec-23

Annual Average

100%

*Sep dates used as placeholder (9/26-9/30/2022)

OPCOM Prices 2024 (lei)

Day 1

Day 2

Day 3

Day 4

Day 5

Price Index Table 2024*

Delivery Month

11-Dec

12-Dec

13-Dec

14-Dec

15-Dec

2023

Delivery Month

5-Day Average

Consumption Profile

5-Day Weighted Average

Jan-24

Jan-23

Feb-24

Feb-23

Mar-24

Mar-23

Apr-24

Apr-23

May-24

May-23

Jun-24

Jun-23

Jul-24

Jul-23

Aug-24

Aug-23

Sep-24

Sep-23

Oct-24

Oct-23

Nov-24

Nov-23

Dec-24

Dec-23

Annual Average

100%

*Sep dates used as placeholder (9/26-9/30/2022)

OPCOM Prices 2025 (lei)

Day 1

Day 2

Day 3

Day 4

Day 5

Price Index Table 2025*

Delivery Month

9-Dec

10-Dec

11-Dec

12-Dec

13-Dec

2024

Delivery Month

5-Day Average

Consumption Profile

5-Day Weighted Average

Jan-25

Jan-23

Feb-25

Feb-23

Mar-25

Mar-23

Apr-25

Apr-23

May-25

May-23

Jun-25

Jun-23

Jul-25

Jul-23

Aug-25

Aug-23

Sep-25

Sep-23

Oct-25

Oct-23

Nov-25

Nov-23

Dec-25

Dec-23

Annual Average

100%

*Sep dates used as placeholder (9/26-9/30/2022)

Notes:
OPCOM pricing published on	ROPEX FM (opcom.ro)
PI formula: AVERAGE [Average (Day 1: 12 months of forwards) + Average (Day 2: 12 months of forwards) + Average (Day 3: 12 months of forwards) + Average (Day 4: 12 months of futures) + Average (Day 5: 12 months of forwards)]
Day 1 corresponds to the first weekday of the second full week of December for Year 1 and for Years 2 and 3

https://www.opcom.ro/rapoarte/ropexfm.php?lang=rohttps://www.opcom.ro/rapoarte/ropexfm.php?lang=ro Price Proposal Example

	Solicitation N33191-22-R-4023
	EXHIBIT D - Price Proposal Table
		Period	PIsol
			Published OpCom Index by Formula [lei/MWh]	Transaction Fee
[lei/MWh]	Reference Consumption [MWh]	Total Annual Values

(PI+TF)*Consumption (lei)

1st year	875.00	680.00	14,660.00	22,796,300.00
2nd year	875.00	650.00	14,660.00	22,356,500.00
3rd year	875.00	630.00	14,660.00	22,063,300.00
		TOTAL OFFER VALUE [LEI]		67,216,100.00

NOTEs:

PIsol is given only for the purpose of price evaluation as a coefficient of the solicitation and is equal for all three years.

In order to avoid errors in filling a cell this sheet has been protected - Please fill out the highlighted yellow cells 'fill out' only, in LEI/MWh (€/MWh XX.XX) currency, two decimals only.

The Government’s evaluation of price will be based on "Total Offer Value" that is the sum of the three Total Annual Values

The Government evaluation of price will be based on consumption referred to CY2021 [MWh] indicated in above table

Statement: The Offeror agrees to hold the offer price for 7 days from the date of submission.

Signature and stamp:

File details come from the government source that posted it. Updated Nov 2, 2022.