JA42_Army_Schedules_B-1_and_B-2_and_Price_Data_Sheets_5_and_6.xlsx

XLSX spreadsheet 31 KB Posted Sep 28, 2012

Attached to: Utilities privatization of the electric, natural gas, water and wastewater utility systems at Gillem Enclave, GA
Solicitation number: SPE600-12-R-0821
Issued by: Defense Logistics Agency Energy

About this file

From the source

JA42 - Army B Schedules and Price Data Sheets 5 6

View the file

Other files

File	Type	Posted
QA_V_-_Gillem_Enclave.pdf	PDF	Jan 22, 2013
Amendment_0005_to_SPE600-12-R-0821.pdf	PDF	Jan 22, 2013
Amendment_0004_to_SPE600-12-R-0821.pdf	PDF	Jan 17, 2013
QA_IV_-_Gillem_Enclave.pdf	PDF	Jan 7, 2013
QA_III_-_Gillem_Enclave.pdf	PDF	Dec 27, 2012
Amendment_0003_to_SPE600-12-R-0821.pdf	PDF	Dec 20, 2012
QA_II_-_Gillem_Enclave.pdf	PDF	Dec 12, 2012
JA42_Army_B_Schedules_and_Price_Data_Sheets.xlsx	XLSX spreadsheet	Nov 16, 2012
Amendment_0002_to_SPE600-12-R-0821.pdf	PDF	Nov 16, 2012
JA38_Federal_Equivalents.pdf	PDF	Nov 16, 2012
Amendment_0001_to_SPE600-12-R-0821.pdf	PDF	Oct 19, 2012
QA_I_-_Gillem_Enclave.pdf	PDF	Oct 18, 2012
JA41_Wage_Determination.pdf	PDF	Sep 28, 2012
JA39_Past_Performance_Information.pdf	PDF	Sep 28, 2012
JA40_Example_Completion_of_Schedule_B-2_ _Price_Data_Sheets_for_FP-EPA_Type_Contracts.pdf	PDF	Sep 28, 2012
JR1_Sample_Bill_of_Sale_ _Model_Easement.pdf	PDF	Sep 28, 2012
Final_RFP_Gillem_Enclave.pdf	PDF	Sep 28, 2012
JR2_Technical_Evaluation_Categories.pdf	PDF	Sep 28, 2012
JR3_-_OUTWEST_Offeror_Tab.pdf	PDF	Sep 28, 2012
JE1_Subcontracting_Plan.pdf	PDF	Sep 28, 2012

Show all 20

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.

Schedule B-1

B.2.1 Schedule B-1 Regulated Tariff a
Available to offerors proposing regulated rates.
	Utility System: ________________

CLIN	Supplies/Services	Qty	Unit	Unit Price	Total
0001	Utility Services Charge	12	Months	$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

0002	Initial System Deficiency Corrections/ Upgrades/Connection Charges b
	FFP

0003	Transition Period	1	Each	$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.

&12Attachment JA42 Army Schedules B-1 and B-2 and Price Data Sheets 5 and 6 Utilities Privatization

Schedule B-2

B.2.2 Schedule B-2 Fixed Price with Economic Price Adjustment a
Available to offerors proposing a Fixed Price with Economic Price Adjustment (FPEPA)
	Utility System: ________________

CLIN	Supplies/Services	Qty	Unit	Unit Price	Total
0001	Utility Services Charge	12	Months	$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.b

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

0002	Initial System Deficiency Corrections/ Upgrades/Connection Charges
	FFP

0003	Transition Period	1	Each	$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

GILLEM ENCLAVE, GA	SPE600-12-R-0821
DLA ENERGY UTILITIES PRIVATIZATION	UTILITIES PRIVATIZATION
B.3.5 Price Data Sheet 5 – Proposal 50-Year Charges to the Government, Applicable Tariff

Contract Items
	CLIN 0001 - Utility Service Charge	CLIN 0002 - Initial System Deficiency Corrections / Connection Charges	CLIN 0003 - Transition Period Charges

Contract Year

Applicable Tariff less FIT

FIT for Applicable Tariff

Credit for Purchase Price

Recoverable Portion of Purchase Price

Subtotal CLIN 0001 (b+c+d+e)

ISDC Projects less FIT

FIT for ISDC Projects

Subtotal CLIN 0002 (g+h)

Transition Charges less FIT

FIT for Transition Charges

Subtotal CLIN 0003 (j+k)

Total Contract Costs (f+i+l)

Nominal

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 Price Data Sheet 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

GILLEM ENCLAVE, GA	SPE600-12-R-0821
DLA ENERGY UTILITIES PRIVATIZATION	UTILITIES PRIVATIZATION
B.3.6 Price Data Sheet 6 – Proposal 50 Year Charges to the Government, Constant 2014$

Contract Items
	CLIN 0001 - Utility Service Charge	CLIN 0002 - Initial System Deficiency Corrections / Connection Charges	CLIN 0003 - Transition Period Charges

(a)

(b)

(c)

(d)

(e)

(f)

(g)

(h)

(i)

(j)

(k)

(l)

(m)

(n)

(o)

(p)

(q)

Contract Year

Operations & Maintenance less FIT

FIT for O&M

Other Costs & Credits, Net

Non Federal Income Taxes & Fees

Purchase Price Recovery

Purchase Price Credit

Renewals & Replacements less FIT

FIT for R&R

Subtotal CLIN 0001

ISDC Projects Amortization less FIT

FIT for ISDC Projects

Subtotal CLIN 0002

Transition Charges less FIT

FIT for Transition Charges

Subtotal CLIN 0003

Total Contract Costs

Real

Nominal

Real

Nominal

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 Price Data Sheet 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 Price Data Sheet 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 Price Data Sheets 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.

File details come from the government source that posted it. Updated Nov 14, 2017.