JA42_Dyess__AFB_Schedules_and_Price_Data_Sheets_5_and_6.xlsx

XLSX spreadsheet 27 KB Posted

Attached to
Privatization of the electrical distribution at Dyess Air Force Base (AFB), Texas
Solicitation number
GS-00P-13-BSC-0935
Issued by

About this file

Attachment JA42 (Dyess AFT Schedules and Price Data Sheets)

View the file

Other files

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

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 5

DYESS AFB, TXGS-00P-13-BSC-0935
UTILITIES 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

DYESS AFB, TXSOLICITATION NUMBER
UTILITIES 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 .