N33191-22-R-4014_J-200000-04 Final.xlsx
XLSX spreadsheet 29 KB Posted
- Solicitation number
- N33191-22-R-4014
View the file
Other files
| File | Type | Posted |
|---|---|---|
| N33191-22-R-4014 Amendment 0002.pdf | ||
| N33191-22-R-4014 Amendment 0001.pdf | ||
| N33191-22-R-4014 Elec Service Italy.pdf | ||
| N33191-22-R-4014 Elec Service Italy.pdf | ||
| N33191-22-R-4014_J-200000-03 Final.xlsx | XLSX spreadsheet | |
| N33191-22-R-4014_J-200000-01 Final.docx | DOCX document | |
| N33191-22-R-4014_J-200000-02 Final.xlsx | XLSX spreadsheet | |
| N33191-22-R-4014_J-200000-06_NV1.xlsx | XLSX spreadsheet | |
| N33191-22-R-4014_J-200000-05 Final.docx | DOCX document | |
| N33191-22-R-4014_J-200000-06_AF1.xlsx | XLSX spreadsheet | |
| N33191-22-R-4014_J-200000-06_NV2.xlsx | XLSX spreadsheet |
Show all 11
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
PriceProposalSheet Solicitation N33191-22-R-4014 5/15/22
Attachment J-200000-04
Base Offer / Offerta di Base
| Line Item/ Sigla | Pertinent Area/ Area di pertinenza | Period / Periodo | F1 | F2 | F3 | TOTAL OFFER VALUE | ||||||
| Transaction Fee [€/MWh] | Published monthly arithmetic average price (PUNm F1) [€/MWh] | F1 Reference Consumption (CF1) [MWh] | Transaction Fee [€/MWh] | Published monthly arithmetic average price (PUNm F2) [€/MWh] | F2 Reference Consumption (CF2) [MWh] | Transaction Fee [€/MWh] | Published monthly arithmetic average price (PUNm F3) [€/MWh] | F3 Reference Consumption (CF3) [MWh] | Total Value F1+F2+F3 |
[(TFs+PUNs)*Consumptions]
| AF1 | Friuli, e altre | 1st year | fill out/compilare | 256.23 | 18,123.43 | fill out/compilare | 266.58 | 10,892.03 | fill out/compilare | 228.86 | 18,716.41 | ERROR:#VALUE! |
| AF1 | Friuli, e altre | 2nd year | fill out/compilare | 256.23 | 18,123.43 | fill out/compilare | 266.58 | 10,892.03 | fill out/compilare | 228.86 | 18,716.41 | ERROR:#VALUE! |
| Total value of offer for AF1 | ERROR:#VALUE! |
| Line Item/ Sigla | Pertinent Area/ Area di pertinenza | Period / Periodo | F1 | F2 | F3 | TOTAL OFFER VALUE | ||||||
| Transaction Fee [€/MWh] | Published monthly arithmetic average price (PUNm F1) [€/MWh] | F1 Reference Consumption (CF1) [MWh] | Transaction Fee [€/MWh] | Published monthly arithmetic average price (PUNm F2) [€/MWh] | F2 Reference Consumption (CF2) [MWh] | Transaction Fee [€/MWh] | Published monthly arithmetic average price (PUNm F3) [€/MWh] | F3 Reference Consumption (CF3) [MWh] | Total Value F1+F2+F3 |
[(TFs+PUNs)*Consumptions]
| NV1 | Campania e Lazio | 1st year | fill out/compilare | 256.23 | 23,812.95 | fill out/compilare | 266.58 | 15,204.07 | fill out/compilare | 228.86 | 26,726.83 | ERROR:#VALUE! |
| NV1 | Campania e Lazio | 2nd year | fill out/compilare | 256.23 | 23,812.95 | fill out/compilare | 266.58 | 15,204.07 | fill out/compilare | 228.86 | 26,726.83 | ERROR:#VALUE! |
| Total value of offer for NV1 | ERROR:#VALUE! |
| Line Item/ Sigla | Pertinent Area/ Area di pertinenza | Period / Periodo | F1 | F2 | F3 | TOTAL OFFER VALUE | ||||||
| Transaction Fee [€/MWh] | Published monthly arithmetic average price (PUNm F1) [€/MWh] | F1 Reference Consumption (CF1) [MWh] | Transaction Fee [€/MWh] | Published monthly arithmetic average price (PUNm F2) [€/MWh] | F2 Reference Consumption (CF2) [MWh] | Transaction Fee [€/MWh] | Published monthly arithmetic average price (PUNm F3) [€/MWh] | F3 Reference Consumption (CF3) [MWh] | Total Value F1+F2+F3 |
[(TFs+PUNs)*Consumptions]
| NV2 | Sicilia | 1st year | fill out/compilare | 256.23 | 18,408.50 | fill out/compilare | 266.58 | 12,925.90 | fill out/compilare | 228.86 | 22,139.07 | ERROR:#VALUE! |
| NV2 | Sicilia | 2nd year | fill out/compilare | 256.23 | 18,408.50 | fill out/compilare | 266.58 | 12,925.90 | fill out/compilare | 228.86 | 22,139.07 | ERROR:#VALUE! |
| Total value of offer for NV2 | ERROR:#VALUE! |
Total Line Items AF1+NV1+NV2 ERROR:#VALUE!
| NOTEs: | CF1,CF2,CF3 are given as a coefficients of the solicitation (CY21 Load data). The aforementioned coefficients are set equal to 2nd year only for the purpose of price evaluation. |
| PUNm 2nd Y are set equal to PUNm 1st Y only for the purpose of price evaluation. |
| PUNm is the monthly arithmetic average of the GME (Gestore Mercato Elettrico) prices in €/MWh determined for each day of the month of withdrawal. |
| A full definition of PUNm is provided at Art. 4 of the solicitation. |
| PUNm value in this sheet is provided for the purpose of price evaluation only, and is equal to the PUNm published monthly average for April 2022. |
| As described at Art.4 of Solicitation, for invoicing purposes the PUNm will change as monthly published on the GME website (https://www.mercatoelettrico.org/it/Statistiche/ME/PrezzoMedioFasce.aspx) |
TF = Transaction Fees for each of the two one-year periods. The Transaction fee shall remain constant during each of the two years of contract performance. Transaction fees can be different by year, and by band (F1, F2, F3, On-Peak and Off-Peak) and by area. See Art. 4 of Solicitation.
In order to avoid errors in filling a cell this sheet has been protected - Please fill out the highlighted yellow cells 'fill out/compilare' only, in Euro/MWh (€/MWh XX.XX) currency, two decimals only.
The Government’s evaluation of price will be based on "2 Years € "Total Line Items (Af1+NV1+NV2) Amount".
The Government evaluation of price will be based on consumes referred to CY2021 [MWh] indicated in above table
For Price evaluation Sample Only: (see tab "Price Proposal Example")
| The offeror agrees to hold above offer prices from the date of price submittal through JULY XXth, 2022 date of the contract award. |
| Il Proponente si impegna a mantenere ferma l’offerta economica sopra riportata fino al XX luglio 2022, data della'ggiudicazione. |
Signature and Corporation stamp / Timbro societario e Firma
PriceProposalExample Solicitation N33191-22-R-4014 5/6/22
Attachment J-200000-04
Base Offer / Offerta di Base
| Line Item/ Sigla | Pertinent Area/ Area di pertinenza | Period / Periodo | F1 | F2 | F3 | TOTAL OFFER VALUE | ||||||
| Transaction Fee [€/MWh] | Published monthly arithmetic average price (PUNm F1) [€/MWh] | F1 Reference Consumption (CF1) [MWh] | Transaction Fee [€/MWh] | Published monthly arithmetic average price (PUNm F2) [€/MWh] | F2 Reference Consumption (CF2) [MWh] | Transaction Fee [€/MWh] | Published monthly arithmetic average price (PUNm F3) [€/MWh] | F3 Reference Consumption (CF3) [MWh] | Total Value F1+F2+F3 |
[(TFs+PUNs)*Consumptions]
| AF1 | Friuli, e altre | 1st year | 1.50 | 256.23 | 18,123.43 | 2.00 | 266.58 | 10,892.03 | 2.50 | 228.86 | 18,716.41 | € 11,926,563.58 |
| AF1 | Friuli, e altre | 2nd year | 3.00 | 256.23 | 18,123.43 | 3.50 | 266.58 | 10,892.03 | 4.00 | 228.86 | 18,716.41 | € 11,998,161.39 |
| Total value of offer for AF1 | € 23,924,724.97 |
| Line Item/ Sigla | Pertinent Area/ Area di pertinenza | Period / Periodo | F1 | F2 | F3 | TOTAL OFFER VALUE | ||||||
| Transaction Fee [€/MWh] | Published monthly arithmetic average price (PUNm F1) [€/MWh] | F1 Reference Consumption (CF1) [MWh] | Transaction Fee [€/MWh] | Published monthly arithmetic average price (PUNm F2) [€/MWh] | F2 Reference Consumption (CF2) [MWh] | Transaction Fee [€/MWh] | Published monthly arithmetic average price (PUNm F3) [€/MWh] | F3 Reference Consumption (CF3) [MWh] | Total Value F1+F2+F3 |
[(TFs+PUNs)*Consumptions]
| NV1 | Campania e Lazio | 1st year | 4.50 | 256.23 | 23,812.95 | 5.00 | 266.58 | 15,204.07 | 5.50 | 228.86 | 26,726.83 | € 16,601,571.86 |
| NV1 | Campania e Lazio | 2nd year | 10.10 | 256.23 | 23,812.95 | (2.56) | 266.58 | 15,204.07 | (5.85) | 228.86 | 26,726.83 | € 16,316,632.07 |
| Total value of offer for NV1 | € 32,918,203.94 |
| Line Item/ Sigla | Pertinent Area/ Area di pertinenza | Period / Periodo | F1 | F2 | F3 | TOTAL OFFER VALUE | ||||||
| Transaction Fee [€/MWh] | Published monthly arithmetic average price (PUNm F1) [€/MWh] | F1 Reference Consumption (CF1) [MWh] | Transaction Fee [€/MWh] | Published monthly arithmetic average price (PUNm F2) [€/MWh] | F2 Reference Consumption (CF2) [MWh] | Transaction Fee [€/MWh] | Published monthly arithmetic average price (PUNm F3) [€/MWh] | F3 Reference Consumption (CF3) [MWh] | Total Value F1+F2+F3 |
[(TFs+PUNs)*Consumptions]
| NV2 | Sicilia | 1st year | (2.50) | 256.23 | 18,408.50 | 6.32 | 266.58 | 12,925.90 | 5.95 | 228.86 | 22,139.07 | € 13,396,742.75 |
| NV2 | Sicilia | 2nd year | 3.85 | 256.23 | 18,408.50 | 4.56 | 266.58 | 12,925.90 | 7.21 | 228.86 | 22,139.07 | € 13,518,782.40 |
| Total value of offer for NV2 | € 26,915,525.14 |
Total Line Items AF1+NV1+NV2 € 83,758,454.04
| NOTEs: | CF1,CF2,CF3 are given as a coefficients of the solicitation. The aforementioned coefficients are set equal to 2nd year only for the purpose of price evaluation. |
| PUNm 2nd Y are set equal to PUNm 1st Y only for the purpose of price evaluation. |
| PUNm is the monthly arithmetic average of the GME (Gestore Mercato Elettrico) prices in €/MWh determined for each day of the month of withdrawal. |
| A full definition of PUNm is provided at Art. 4 of the solicitation. |
| PUNm value in this sheet is provided for the purpose of price evaluation only, and is equal to the PUNm published monthly average for April 2022. |
| As described at Art.4 of Solicitation, for invoicing purposes the PUNm will change as monthly published on the GME website (https://www.mercatoelettrico.org/it/Statistiche/ME/PrezzoMedioFasce.aspx) |
TF = Transaction Fees for each of the two one-year periods. The Transaction fee shall remain constant during each of the two years of contract performance. Transaction fees can be different by year, and by band (F1, F2, F3, On-Peak and Off-Peak) and by area. See Art. 4 of Solicitation.
In order to avoid errors in filling a cell this sheet has been protected - Please fill out the highlighted yellow cells 'fill out/compilare' only, in Euro/MWh (€/MWh XX.XX) currency, two decimals only.
The Government’s evaluation of price will be based on "2 Years € "Total Line Items (Af1+NV1+NV2) Amount".
The Government evaluation of price will be based on consumes referred to CY2021 [MWh] indicated in above table
For Price evaluation Sample Only: (see tab "Price Proposal Example")
| The offeror agrees to hold above offer prices from the date of price submittal through JULY XXth, 2022 date of the contract award. |
| Il Proponente si impegna a mantenere ferma l’offerta economica sopra riportata fino al XX luglio 2022, data della'ggiudicazione. |
Signature and Corporation stamp / Timbro societario e Firma
Rate Components EE
| unità di misura | Unit of measura | Rate | note | ||
| MATERIA ENERGIA | ENERGY | ||||
| PUNm | €/kWh | GME indexed - invoicing month | €/kWh | monthly average PUN | see "Price Proposal Sheet" TAB |
| TF | €/kWh | Transaction Fee | €/kWh | Offer Price / Prezzo di Offerta | see "Price Proposal Sheet" TAB |
| PD | €/kWh | PD | €/kWh | NOT TO BE INVOICED - DA NON FATTURARE | |
| PCV | €/year | PCV | €/year | NOT TO BE INVOICED - DA NON FATTURARE | |
| DISPbt | €/year | DISPbt | €/year | NOT TO BE INVOICED - DA NON FATTURARE | |
| PPE | €/kWh | PPE | €/kWh | NOT TO BE INVOICED - DA NON FATTURARE | |
| DISPACCIAMENTO | SETTLEMENT, DISPATCHING | ||||
| art. 44 - dispacciamento | €/kWh | art. 44 dispatching | €/kWh | ARERA Resolution | Applicable as pass-thru and excluded from offer price |
| art. 25 - salvaguardia transitoria | €/kWh | art. 25 - transitional "salvaguardia" market | €/kWh | ARERA Resolution | Applicable as pass-thru and excluded from offer price |
| art. 44 bis modulazione produzione eolica | €/kWh | art 44 bis wind production modulation | €/kWh | ARERA Resolution | Applicable as pass-thru and excluded from offer price |
| art. 45.1 copertura costi unità essenziali | €/kWh | art. 45.1 coverage of essential unit power plant costs | €/kWh | ARERA Resolution | Applicable as pass-thru and excluded from offer price |
| art. 45.2 copertura costi generazione | €/kWh | art. 45.2 generation cost coverage | €/kWh | ARERA Resolution | Applicable as pass-thru and excluded from offer price |
| art. 46 - ex art. 37.1 - funzionamento TERNA | €/kWh | art. 46 - ex art. 37.1 - TERNA operation | €/kWh | ARERA Resolution | Applicable as pass-thru and excluded from offer price |
| art. 48 - ex CD | €/kWh | art.48 - ex CD | €/kWh | ARERA Resolution | Applicable as pass-thru and excluded from offer price |
| art. 73 - ex INT | €/kWh | art.73 - ex INT | €/kWh | ARERA Resolution | Applicable as pass-thru and excluded from offer price |
| Sbilanciamento | €/kWh | unbalancing | €/kWh | NOT TO BE INVOICED - DA NON FATTURARE | |
| Capacity market peak - Del. 566/2021/R/eel | €/kWh | Capacity market peak Del. 566/2021/R/eel | €/kWh | ARERA Resolution | Applicable as pass-thru and excluded from offer price |
| Capacity market off-peak - Del. 566/2021/R/eel | €/kWh | Capacity market off-peak Del. 566/2021/R/eel | €/kWh | ARERA Resolution | Applicable as pass-thru and excluded from offer price |
| TRASPORTO E GESTIONE DEL CONTATORE | TRANSPORT, DISTRIBUTION AND METERING | ||||
| quota potenza | €/kW/anno | power fee | €/kW/year | ARERA Resolution | Applicable as pass-thru and excluded from offer price |
| quota fissa | €/mese | fixed fee | €/year | ARERA Resolution | Applicable as pass-thru and excluded from offer price |
| quota energia | €/kWh | energy fee | €/kWh | ARERA Resolution | Applicable as pass-thru and excluded from offer price |
| TRAS | €/kWh | TRAS | €/kWh | ARERA Resolution | Applicable as pass-thru and excluded from offer price |
| MIS | €/mese | MIS | €/year | ARERA Resolution | Applicable as pass-thru and excluded from offer price |
| UC3 | €/kWh | UC3 | €/kWh | ARERA Resolution | Applicable as pass-thru and excluded from offer price |
| UC6 | €/kWh | UC6 | €/kWh | ARERA Resolution | Applicable as pass-thru and excluded from offer price |
| ONERI DI SISTEMA | SYSTEM CHARGES | ||||
| ASOS | €/kWh | ASOS | €/kWh | ARERA Resolution | Applicable as pass-thru and excluded from offer price |
| ASOS | €/anno | ASOS | €/year | ARERA Resolution | Applicable as pass-thru and excluded from offer price |
| ASOS | €/kW/anno | ASOS | €/kW/year | ARERA Resolution | Applicable as pass-thru and excluded from offer price |
| ARIM | €/kWh | ARIM | €/kWh | ARERA Resolution | Applicable as pass-thru and excluded from offer price |
| ARIM | €/anno | ARIM | €/year | ARERA Resolution | Applicable as pass-thru and excluded from offer price |
| ARIM | €/kW/anno | ARIM | €/kW/year | ARERA Resolution | Applicable as pass-thru and excluded from offer price |
| ACCISE | EXCISE | ||||
| Accise su scaglioni di consumo | €/kWh | Excise duties on consumption brackets | €/kWh | TAX EXEMPT | not applicable |
| IVA, Addizionali regionali e locali | % | VAT, Regional and Local Taxes | % | TAX EXEMPT | not applicable |
Conversion
| eur/MWh | factor | eurcent/Smc | eur/Smc | |
| March | 129.329 | 1.05833 | 136.87276057 | 1.3687276057 |
File details come from the government source that posted it. Updated .