JA42_B_Schedules_and_Price_Data_Sheets.xlsx

XLSX spreadsheet 42 KB Posted

Attached to
Utilities Privatization - Privatization of the Electric Utility System at Norfolk Naval Shipyard, VA
Solicitation number
SP060025R0800
Issued by

About this file

This document is a pricing template (JA42_B_Schedules_and_Price_Data_Sheets.xlsx) for a DLA Energy Utilities Privatization solicitation for the Electric Utility System at Norfolk Naval Shipyard, Virginia. The file contains detailed pricing schedules (B-1 and B-2) and six price data sheets that outline the financial components for a 50-year utility system privatization contract. Key pricing elements include a monthly utility services charge of $10,000, with a $2,000 monthly credit for purchase price, a $50,000 transition period charge, and provisions for initial system deficiency corrections and upgrades.

The pricing template requires offerors to complete comprehensive financial projections across multiple contract line items (CLINs), including operations and maintenance costs, renewals and replacements, federal income taxes, and purchase price recovery. The document provides extensive worksheets for detailing nominal and real dollar estimates for each of the 50 contract years, with specific instructions for calculating various cost components such as non-federal income taxes, purchase price credits, and system upgrade amortization. The goal is to enable a thorough financial evaluation of potential utility system privatization proposals in accordance with 10 U.S.C. 2688 - Utility Systems: Conveyance Authority.

View the file

Other files

Show all 23

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

Schedule B-1

B.2.1 Schedule B-1 Regulated Tariff a
Available to offerors proposing regulated rates.
Utility System: ________________
CLINSupplies/ServicesQtyUnitUnit PriceTotal
0001Utility Services Charge12Months$10,000.00$120,000.00
FP
The unit price is the Applicable Tariff(s) less the monthly credit as payment for the purchase price plus the recoverable portion of the purchase price.

Applicable Tariff $ 10,000.00

Monthly Credit for PP $ (2,000.00)
# of Months 240
Interest Rate 4.5%
Recoverable Portion of PP $ 2,000.00
# of Months 240
Interest Rate 4.5%

Unit Price $ 10,000.00

0002Initial System Deficiency Corrections/ Upgrades/Connection Charges b
FFP
0003Transition Period1Each$50,000.00$50,000.00
FP

a Utility system to be filled in by the Offeror. A Schedule B-1 must be completed for each utility system offered. Utility systems are shown in paragraph B.1, Systems to be Privatized. Offerors shall provide a comprehensive description of proposed tariffs in their Price Proposals.

b CLIN 0002 is required only if the tariff provides for separate identification of initial system deficiency corrections and connection charges. If separate identification is not provided, it will be assumed the tariff rate includes these costs.

Schedule B-2

B.2.2 Schedule B-2 Fixed Price Economic Price Adjustment a
Available to offerors proposing a Fixed Price Economic Price Adjustment (FPEPA)
Utility System: ________________
CLINSupplies/ServicesQtyUnitUnit PriceTotal
0001Utility Services Charge12Months$10,000.00$120,000.00
FPEPA
The unit price is the Utility Services Charge less the monthly credit as payment for the purchase price (PP) plus the recoverable portion of the purchase price.

Utility Services Charge $ 10,000.00

Monthly Credit for PP $ (2,000.00)
# of Months 240
Interest Rate 4.5%
Recoverable Portion of PP $ 2,000.00
# of Months 240
Interest Rate 4.5%

Unit Price $ 10,000.00

0002Initial System Deficiency Corrections/ Upgrades/Connection Charges b
FFP
0003Transition Period1Each$50,000.00$50,000.00
FFP
a Utility system to be filled in by the Offeror. A Schedule B-2 must be completed for each utility system offered. Utility systems are shown in paragraph B.1, Systems to be Privatized.
b The offeror should enter the Utility Services Charge, as computed in Price Data Sheet 1.

Price Data Sheet 1

B.3.1 Price Data Sheet 1 – Utility Services Charge
ComponentMonthly Charge

1. Operations and Maintenance (O&M)

2. Renewals and Replacements (R&R)

Total Utility Services Charge
(to be entered into CLIN 0001 for Schedule B-1 (if applicable)
and Schedule B-2)

Price Data Sheet 2

B.3.2 Price Data Sheet 2 – Renewals and Replacements – 50-YEAR Plan
Notes: For each inventory component/item listed in the utility specific attachment, clearly show the $ value of the planned R&R (if any) for each year 1-50
This Plan represents the offeror’s conceptual methodology that will be used for evaluation purposes.
ItemSizeQuantityUnitApprox Year InstalledExisting Unit RCNExisting Item Service LifeFirst Expected Replacement DateNew ItemNew Item Service LifeNew Unit Cost RCNNew Item RCNPlanned Renewals & ReplacementsCumulative TotalResidual Value in Year 50 (Const $)

Year 1 (Const $) Year XX (Const $) Year 50 (Const $)

Total

Price Data Sheet 3 B.3.3 Price Data Sheet 3 – Initial System Deficiency Correction(s) / Upgrade(s) / Connection Charge(s) / Transition Period

Project Name Interest Rate Project Cost (Current $) Project Start Month First Full Month Project will Be In Service Amortization Period (Months) Monthly Charge

Price Data Sheet 4 B.3.4 Price Data Sheet 4 – Recoverable Portion of Purchase Price

Item Interest Rate Amount Amortization Period (Months) Monthly Charge

Recoverable Portion of
Purchase Price

Price Data Sheet 5

INSTALLATION NAMESOLICITATION NUMBER
DLA ENERGY UTILITIES PRIVATIZATIONUTILITIES PRIVATIZATION
B.7.5 Price Data Sheet 5 – Proposal 50-Year Charges to the Government
Contract Items
CLIN 0001 - Utility Service ChargeCLIN 0002 - Initial System Deficiency Corrections / Connection ChargesCLIN 0003 - Transition Period Charges
abcdefghijklmn
Contract YearApplicable Tariff less FITFIT for Applicable TariffCredit for Purchase PriceRecoverable Portion of Purchase PriceSubtotal CLIN 0001 (b+c+d+e)ISDC Projects less FITFIT for ISDC ProjectsSubtotal CLIN 0002 (g+h)Transition Charges less FITFIT for Transition ChargesSubtotal CLIN 0003 (j+k)Total Contract Costs (f+i+l)Assumed Inflation Rate (%)
NominalNominalNominalNominalNominalNominalNominalNominal
1$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
2$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
3$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
4$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
5$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
6$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
7$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
8$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
9$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
10$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
11$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
12$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
13$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
14$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
15$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
16$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
17$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
18$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
19$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
20$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
21$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
22$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
23$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
24$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
25$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
26$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
27$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
28$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
29$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
30$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
31$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
32$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
33$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
34$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
35$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
36$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
37$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
38$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
39$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
40$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
41$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
42$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
43$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
44$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
45$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
46$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
47$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
48$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
49$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
50$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
Totals$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
Notes:
1. Regulated offerors shall fill in each contract item for Years 1-50.
2. The nominal dollar estimates are applicable to the specific years of the Contract and reflect the inflation rate assumption to be provided by the Government..
3. Column d: Enter the sum of the monthly amortized costs (i.e., principal and interest) of the Credit for Purchase Price associated with the applicable contract year detailed in Schedule 4.
4. Column e: If Recoverable Portion of the Purchase Price is included in the Applicable Tariff less FIT, enter "Column b".
5. Column e: If Recoverable Portion of the Purchase Price is not included in the Applicable Tariff less FIT, enter the sum of the monthly amortized costs (i.e., the principal and interest) in the applicable contract year.
6. Column g: If the ISDC Project price is included in the Applicable Tariff less FIT, enter "Column b".
7. Column h: If the FIT for ISDC Project price is included in the FIT for Applicable Tariff, enter "Column c".
8. Column i: If the ISDC Project price and FIT for ISDC Project price are included in the Applicable Tariff and Applicable Tariff Less FIT, enter "Columns b & c".

Price Data Sheet 6

INSTALLATION NAMESOLICITATION NUMBER
DLA ENERGY UTILITIES PRIVATIZATIONUTILITIES PRIVATIZATION
B.7.5 Price Data Sheet 6 – Proposal 50-Year Charges to the Government
Contract Items
CLIN 0001 - Utility Service ChargeCLIN 0002 - Initial System Deficiency Corrections / Connection ChargesCLIN 0003 - Transition Period Charges
(a)(b)(c)(d)(e)(f)(g)(h)(i)(j)(k)(l)(m)(n)(o)(p)(q)(r)
Contract YearOperations & Maintenance less FITFIT for O&MOther Costs & Credits, NetFIT for Other Costs & Credits, NetNon Federal Income Taxes & FeesPurchase Price RecoveryPurchase Price CreditRenewals & Replacements less FITFIT for R&RSubtotal CLIN 0001ISDC Projects Amortization less FITFIT for ISDC ProjectsSubtotal CLIN 0002Transition Charges less FITFIT for Transition ChargesSubtotal CLIN 0003Total Contract Costs
RealRealRealRealRealNominalNominalRealReal--NominalNominalNominalNominalNominalNominal--
1$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
2$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
3$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
4$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
5$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
6$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
7$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
8$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
9$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
10$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
11$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
12$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
13$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
14$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
15$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
16$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
17$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
18$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
19$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
20$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
21$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
22$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
23$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
24$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
25$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
26$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
27$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
28$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
29$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
30$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
31$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
32$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
33$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
34$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
35$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
36$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
37$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
38$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
39$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
40$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
41$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
42$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
43$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
44$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
45$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
46$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
47$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
48$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
49$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
50$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
Totals$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
Notes:
1. Offerors shall fill in each contract item for Years 1-50.
2. The real dollars estimates are applicable to the initial two years of the Contract and exclude the effects of inflation beyond the initial two-year pricing period.
3. The nominal dollars are applicable to the actual contract year in which the credit / charges / amortization will be invoiced under the Contract.
4. Column (b) should include all O&M and G&A related costs expenses including the O&M related profit (if any) and excluding the federal income tax (FIT) related to the O&M related profit (coumn (c).
5. Column (d) should include all other costs and credits on a net basis, including capital credits, etc.
6. Column (e) should include all non-federal taxes, such as state income tax, property taxes, any local taxes, etc.
7. Column (f) should equal the sum of the monthly amortized costs (i.e., the principal and interest) associated with the recoverable portion of the purchase price in the applicable contract year detailed in Schedule 4.
8. Column (g) should equal the sum of the monthly amortized costs (i.e., the principal and interest) associated with the purchase price credit in the applicable contract year.
9. The sum of columns (b) through and including column (g) should equal the total operation and maintenance (O&M) costs detailed in Schedule 1. The total O&M costs should include all costs including O&M related profit, income taxes, general and administrative (G&A), other costs and credits, non-federal income taxes, the pruchase price recovery and purchase price credit, etc. necessary to provide the utility service.
10. Column (h) plus column (i) should equal the total levelized R&R component costs detailed in Schedules 1 and 2.
11. Column (j), Subtotal CLIN 0001, should equal the sum of columns (b) through column (i).
12. Column (k) plus column (l) should equal the annual summation of the monthly amortized costs (i.e., the principal and interest) associated with the ISDC / connection charges in the applicable contract year detailed in Schedule 3. TH sum of which is totalled in Column (m), Subtotal CLIN 0002
13. Column (n) plus column (o) should equal the annual summation of the monthly amortized costs (i.e., the principal and interest) associated with the transition related expenses included in column (p), Subtotal CLIN 0003.
14. Column (c) plus Column (e) plus Column (j) should include all Federal Income taxes included in price proposal, except FIT related to ISDC charges (Column (m)) and/or Transition Charges (Column (o)), and should equal the Federal Income Tax shown on Schedule 1, Item 3

File details come from the government source that posted it. Updated .