Attch_2_Barksdale_CSA_Pricing_Schedule_12_Jul_2018_v1.xlsx

XLSX spreadsheet 57 KB Posted Jul 30, 2018

Attached to: Local Telecommunications Services for Barksdale, LA
Solicitation number: FA8773-18-Q-0013
Issued by: Department of the Air Force Space Command

About this file

From the source

Pricing Schedule

View the file

Other files

File	Type	Posted
Combined_SynSol_Barksdale_CSA_Amendment_to_extend_due_date.docx	DOCX document	Aug 22, 2018
Attch_5_Barksdale_CSA_Question_Answer_Spreadsheet_31_Jul_2018.xlsx	XLSX spreadsheet	Jul 31, 2018
Combined_SynSol_Barksdale_CSA_6_Jul_2018.pdf	PDF	Jul 23, 2018
Attch_4_Barksdale_AFB_Addendum_52.212-2_20_Jul_18..pdf	PDF	Jul 23, 2018
Attch_3_Barksdale_AFB_Addendum_52.212-1_20_Jul_18..pdf	PDF	Jul 23, 2018
Attch_5_Barksdale_CSA_Question_Spreadsheet_19_Jul_2018.pdf	PDF	Jul 23, 2018
Attch_2_Barksdale_CSA_Pricing_Schedule_12_Jul_2018_v1.pdf	PDF	Jul 23, 2018
Attch_1_Barksdale_CSA_PWS_20_Jul_2018_v1.pdf	PDF	Jul 23, 2018

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.

Base Year

	Date:
	Pricing Schedule
	Contractor:
	Barksdale AFB, LA			CLIN 0001 (FFP)	CLIN 0002 (FFP)		CLIN 0003 (FFP)
Services & Function Items				Non-Recurring Charges	Recurring Charges		Cutover
SLIN	DESCRIPTION	Unit of Issue	Quantity	Annual Total NRC	Per Unit Monthly	Total Monthly

	A		Installation and Cutover (PWS Para. 4.3)
	A
s: Do not add SLINs above this line. Total calculations begin with this row.	A	Installation (PWS Para 4.3.1)	EA	1
	A	B	Cutover (PWS Para 4.3.2)	EA	1

		Customer Service Records
A	C	Customer Services Record (CSR)	EA	11

		Trunking Traffic Study/Analysis Report
A	D	City Trunk Traffic Analysis Study with Report	EA	5
A	E	Higher Bandwidth Transport Circuit Traffic Analysis Study, DS1 and Higher with Report	EA	5

		Invoice Reconciliation Report
A	F	Invoice Reconciliation Report	EA	6

B		Direct Inward Dial Directory Number (PWS Appendix 1, Para 5.2)
B	A	DID Directory Number	HD	150.02
B	B	Direct Inward Dial (DID) Directory Number Portability	HD	150.02
B	C	DID Directory Number	EA	50

C		Commercial Subscriber Lines (PWS Appendix 1, Para 5.3.1)
C	A	Flat Rate, Basic Services, Analog	EA	11
C	B	Local Number Portability Pool Fee	EA	11
C	C	Universal Service Surcharge/End User Common Line Charge	EA	11
C	D	Other Taxes, Fees and Surcharges	EA	11
C	E	Other Taxes, Fees and Surcharges (SLIN C/A)	EA	11

E		Local Exchange Digital ISDN (PRI) (PWS Appendix 1, Para 5.4.3)
E	A	ISDN Primary Rate Interface	EA	9
E	B	PRI Individual D-Channel	EA	9
E	C	Flat Rate, Basic Services, PRI Individual B-Channel 2 Way (2W)	EA	207
E	D	Local Number Portability Pool Fee	EA	9
E	E	Universal Service Surcharge/End User Common Line Charge	EA	9
E	F	Taxes, Fees & Surcharges	EA	9
E	G	Taxes, Fees & Surcharges (SLIN E/A)	EA	9

F		Circuit Extension (PWS Appendix 1, Para 5.8)
F	A	2-Wire Voice Circuit & Termination	EA	3
F	B	2-Wire Voice Circuit Transport Mileage	1/4 MI	38.5
F	C	Other Taxes, Fees and Surcharges	EA	3

G		Public Listings (PWS Appendix 1, Para 5.9)
G	A	Public Listings	EA	50
G	B	Cross-Reference Listing	EA	2

Total $ - 0 $ - 0 $ - 0 $ - 0

CSA Eng. Est. Master Rev 1.1, 08 Aug '97 Data Items 3, 4, & 6 are N/A after 1st year; once it is ordered, it is good for life of contract.

Include all items in service at the conclusion of cutover These are one-time expenses to invoke additional services not present at the end of cutover. The qtys are not cumulative.

These are recurring expenses to maintain existing services. The 1st year qtys should equal the cutover qty plus first year N/R. Out-year qtys are cumulative and should equal the sum of CLINs 1 & 2. Unit prices are for 1 month, not 12.

Multiply CLIN 3 by 12 because the price and qty's reflect one month of service in lieu of 12.

EA for CLIN 1 & 2, /MIN for CLIN 3

Option Yr 1

Date:				Option Year One
Pricing Schedule
Barksdale AFB, LA				CLIN 1001 (FFP)	CLIN 1002 (FFP)
Services & Function Items				Non-Recurring Charges	Recurring Charges
SLIN	DESCRIPTION	Unit of Issue	Quantity	Annual Total NRC	Per Unit Monthly	Total Monthly

	A		Installation and Cutover (PWS Para. 4.3)
	A
s: Do not add SLINs above this line. Total calculations begin with this row.	A	Installation (PWS Para 4.3.1)	EA	1		$ - 0	$ - 0
	A	B	Cutover (PWS Para 4.3.2)	EA	1		$ - 0	$ - 0

		Customer Service Records
A	C	Customer Services Record (CSR)	EA	11	$ - 0	$ - 0

		Trunking Traffic Study/Analysis Report
A	D	City Trunk Traffic Analysis Study with Report	EA	5	$ - 0	$ - 0
A	E	Higher Bandwidth Transport Circuit Traffic Analysis Study, DS1 and Higher with Report	EA	5	$ - 0	$ - 0

		Invoice Reconciliation Report
A	F	Invoice Reconciliation Report	EA	6	$ - 0	$ - 0

B		Direct Inward Dial Directory Number (PWS Appendix 1, Para 5.2)
B	A	DID Directory Number	HD	150.02	$ - 0	$ - 0
B	B	Direct Inward Dial (DID) Directory Number Portability	HD	150.02	$ - 0	$ - 0
B	C	DID Directory Number	EA	50	$ - 0	$ - 0

C		Commercial Subscriber Lines (PWS Appendix 1, Para 5.3.1)
C	A	Flat Rate, Basic Services, Analog	EA	11	$ - 0	$ - 0
C	B	Local Number Portability Pool Fee	EA	11	$ - 0	$ - 0
C	C	Universal Service Surcharge/End User Common Line Charge	EA	11	$ - 0	$ - 0
C	D	Other Taxes, Fees and Surcharges	EA	11	$ - 0	$ - 0
C	E	Other Taxes, Fees and Surcharges (SLIN C/A)	EA	11	$ - 0	$ - 0

E		Local Exchange Digital ISDN (PRI) (PWS Appendix 1, Para 5.4.3)
E	A	ISDN Primary Rate Interface	EA	9	$ - 0	$ - 0
E	B	PRI Individual D-Channel	EA	9	$ - 0	$ - 0
E	C	Flat Rate, Basic Services, PRI Individual B-Channel 2 Way (2W)	EA	207	$ - 0	$ - 0
E	D	Local Number Portability Pool Fee	EA	9	$ - 0	$ - 0
E	E	Universal Service Surcharge/End User Common Line Charge	EA	9	$ - 0	$ - 0
E	F	Taxes, Fees & Surcharges	EA	9	$ - 0	$ - 0
E	G	Taxes, Fees & Surcharges (SLIN E/A)	EA	9	$ - 0	$ - 0

F		Circuit Extension (PWS Appendix 1, Para 5.8)
F	A	2-Wire Voice Circuit & Termination	EA	3	$ - 0	$ - 0
F	B	2-Wire Voice Circuit Transport Mileage	1/4 MI	38.5	$ - 0	$ - 0
F	C	Other Taxes, Fees and Surcharges	EA	3	$ - 0	$ - 0

G		Public Listings (PWS Appendix 1, Para 5.9)
G	A	Public Listings	EA	50	$ - 0	$ - 0
G	B	Cross-Reference Listing	EA	2	$ - 0	$ - 0

Total $ - 0 $ - 0 $ - 0

Option Yr 2

Date:				Option Year Two
Pricing Schedule
Barksdale AFB, LA				CLIN 2001 (FFP)	CLIN 2002 (FFP)
Services & Function Items				Non-Recurring Charges	Recurring Charges
SLIN	DESCRIPTION	Unit of Issue	Quantity	Annual Total NRC	Per Unit Monthly	Total Monthly

	A		Installation and Cutover (PWS Para. 4.3)
	A
s: Do not add SLINs above this line. Total calculations begin with this row.	A	Installation (PWS Para 4.3.1)	EA	1		$ - 0	$ - 0
	A	B	Cutover (PWS Para 4.3.2)	EA	1		$ - 0	$ - 0

		Customer Service Records
A	C	Customer Services Record (CSR)	EA	11	$ - 0	$ - 0

		Trunking Traffic Study/Analysis Report
A	D	City Trunk Traffic Analysis Study with Report	EA	5	$ - 0	$ - 0
A	E	Higher Bandwidth Transport Circuit Traffic Analysis Study, DS1 and Higher with Report	EA	5	$ - 0	$ - 0

		Invoice Reconciliation Report
A	F	Invoice Reconciliation Report	EA	6	$ - 0	$ - 0

B		Direct Inward Dial Directory Number (PWS Appendix 1, Para 5.2)
B	A	DID Directory Number	HD	150.02	$ - 0	$ - 0
B	B	Direct Inward Dial (DID) Directory Number Portability	HD	150.02	$ - 0	$ - 0
B	C	DID Directory Number	EA	50	$ - 0	$ - 0

C		Commercial Subscriber Lines (PWS Appendix 1, Para 5.3.1)
C	A	Flat Rate, Basic Services, Analog	EA	11	$ - 0	$ - 0
C	B	Local Number Portability Pool Fee	EA	11	$ - 0	$ - 0
C	C	Universal Service Surcharge/End User Common Line Charge	EA	11	$ - 0	$ - 0
C	D	Other Taxes, Fees and Surcharges	EA	11	$ - 0	$ - 0
C	E	Other Taxes, Fees and Surcharges (SLIN C/A)	EA	11	$ - 0	$ - 0

E		Local Exchange Digital ISDN (PRI) (PWS Appendix 1, Para 5.4.3)
E	A	ISDN Primary Rate Interface	EA	9	$ - 0	$ - 0
E	B	PRI Individual D-Channel	EA	9	$ - 0	$ - 0
E	C	Flat Rate, Basic Services, PRI Individual B-Channel 2 Way (2W)	EA	207	$ - 0	$ - 0
E	D	Local Number Portability Pool Fee	EA	9	$ - 0	$ - 0
E	E	Universal Service Surcharge/End User Common Line Charge	EA	9	$ - 0	$ - 0
E	F	Taxes, Fees & Surcharges	EA	9	$ - 0	$ - 0
E	G	Taxes, Fees & Surcharges (SLIN E/A)	EA	9	$ - 0	$ - 0

F		Circuit Extension (PWS Appendix 1, Para 5.8)
F	A	2-Wire Voice Circuit & Termination	EA	3	$ - 0	$ - 0
F	B	2-Wire Voice Circuit Transport Mileage	1/4 MI	38.5	$ - 0	$ - 0
F	C	Other Taxes, Fees and Surcharges	EA	3	$ - 0	$ - 0

G		Public Listings (PWS Appendix 1, Para 5.9)
G	A	Public Listings	EA	50	$ - 0	$ - 0
G	B	Cross-Reference Listing	EA	2	$ - 0	$ - 0

Total $ - 0 $ - 0 $ - 0

Option Yr 3

Date:				Option Year Three
Pricing Schedule
Barksdale AFB, LA				CLIN 3001 (FFP)	CLIN 3002 (FFP)
Services & Function Items				Non-Recurring Charges	Recurring Charges
SLIN	DESCRIPTION	Unit of Issue	Quantity	Annual Total NRC	Per Unit Monthly	Total Monthly

	A		Installation and Cutover (PWS Para. 4.3)
	A
s: Do not add SLINs above this line. Total calculations begin with this row.	A	Installation (PWS Para 4.3.1)	EA	1		$ - 0	$ - 0
	A	B	Cutover (PWS Para 4.3.2)	EA	1		$ - 0	$ - 0

		Customer Service Records
A	C	Customer Services Record (CSR)	EA	11	$ - 0	$ - 0

		Trunking Traffic Study/Analysis Report
A	D	City Trunk Traffic Analysis Study with Report	EA	5	$ - 0	$ - 0
A	E	Higher Bandwidth Transport Circuit Traffic Analysis Study, DS1 and Higher with Report	EA	5	$ - 0	$ - 0

		Invoice Reconciliation Report
A	F	Invoice Reconciliation Report	EA	6	$ - 0	$ - 0

B		Direct Inward Dial Directory Number (PWS Appendix 1, Para 5.2)
B	A	DID Directory Number	HD	150.02	$ - 0	$ - 0
B	B	Direct Inward Dial (DID) Directory Number Portability	HD	150.02	$ - 0	$ - 0
B	C	DID Directory Number	EA	50	$ - 0	$ - 0

C		Commercial Subscriber Lines (PWS Appendix 1, Para 5.3.1)
C	A	Flat Rate, Basic Services, Analog	EA	11	$ - 0	$ - 0
C	B	Local Number Portability Pool Fee	EA	11	$ - 0	$ - 0
C	C	Universal Service Surcharge/End User Common Line Charge	EA	11	$ - 0	$ - 0
C	D	Other Taxes, Fees and Surcharges	EA	11	$ - 0	$ - 0
C	E	Other Taxes, Fees and Surcharges (SLIN C/A)	EA	11	$ - 0	$ - 0

E		Local Exchange Digital ISDN (PRI) (PWS Appendix 1, Para 5.4.3)
E	A	ISDN Primary Rate Interface	EA	9	$ - 0	$ - 0
E	B	PRI Individual D-Channel	EA	9	$ - 0	$ - 0
E	C	Flat Rate, Basic Services, PRI Individual B-Channel 2 Way (2W)	EA	207	$ - 0	$ - 0
E	D	Local Number Portability Pool Fee	EA	9	$ - 0	$ - 0
E	E	Universal Service Surcharge/End User Common Line Charge	EA	9	$ - 0	$ - 0
E	F	Taxes, Fees & Surcharges	EA	9	$ - 0	$ - 0
E	G	Taxes, Fees & Surcharges (SLIN E/A)	EA	9	$ - 0	$ - 0

F		Circuit Extension (PWS Appendix 1, Para 5.8)
F	A	2-Wire Voice Circuit & Termination	EA	3	$ - 0	$ - 0
F	B	2-Wire Voice Circuit Transport Mileage	1/4 MI	38.5	$ - 0	$ - 0
F	C	Other Taxes, Fees and Surcharges	EA	3	$ - 0	$ - 0

G		Public Listings (PWS Appendix 1, Para 5.9)
G	A	Public Listings	EA	50	$ - 0	$ - 0
G	B	Cross-Reference Listing	EA	2	$ - 0	$ - 0

Total $ - 0 $ - 0 $ - 0

Option Yr 4

Date:				Option Year Four
Pricing Schedule
Barksdale AFB, LA				CLIN 4001 (FFP)	CLIN 4002 (FFP)
Services & Function Items				Non-Recurring Charges	Recurring Charges
SLIN	DESCRIPTION	Unit of Issue	Quantity	Annual Total NRC	Per Unit Monthly	Total Monthly

	A		Installation and Cutover (PWS Para. 4.3)
	A
s: Do not add SLINs above this line. Total calculations begin with this row.	A	Installation (PWS Para 4.3.1)	EA	1		$ - 0	$ - 0
	A	B	Cutover (PWS Para 4.3.2)	EA	1		$ - 0	$ - 0

		Customer Service Records
A	C	Customer Services Record (CSR)	EA	11	$ - 0	$ - 0

		Trunking Traffic Study/Analysis Report
A	D	City Trunk Traffic Analysis Study with Report	EA	5	$ - 0	$ - 0
A	E	Higher Bandwidth Transport Circuit Traffic Analysis Study, DS1 and Higher with Report	EA	5	$ - 0	$ - 0

		Invoice Reconciliation Report
A	F	Invoice Reconciliation Report	EA	6	$ - 0	$ - 0

B		Direct Inward Dial Directory Number (PWS Appendix 1, Para 5.2)
B	A	DID Directory Number	HD	150.02	$ - 0	$ - 0
B	B	Direct Inward Dial (DID) Directory Number Portability	HD	150.02	$ - 0	$ - 0
B	C	DID Directory Number	EA	50	$ - 0	$ - 0

C		Commercial Subscriber Lines (PWS Appendix 1, Para 5.3.1)
C	A	Flat Rate, Basic Services, Analog	EA	11	$ - 0	$ - 0
C	B	Local Number Portability Pool Fee	EA	11	$ - 0	$ - 0
C	C	Universal Service Surcharge/End User Common Line Charge	EA	11	$ - 0	$ - 0
C	D	Other Taxes, Fees and Surcharges	EA	11	$ - 0	$ - 0
C	E	Other Taxes, Fees and Surcharges (SLIN C/A)	EA	11	$ - 0	$ - 0

E		Local Exchange Digital ISDN (PRI) (PWS Appendix 1, Para 5.4.3)
E	A	ISDN Primary Rate Interface	EA	9	$ - 0	$ - 0
E	B	PRI Individual D-Channel	EA	9	$ - 0	$ - 0
E	C	Flat Rate, Basic Services, PRI Individual B-Channel 2 Way (2W)	EA	207	$ - 0	$ - 0
E	D	Local Number Portability Pool Fee	EA	9	$ - 0	$ - 0
E	E	Universal Service Surcharge/End User Common Line Charge	EA	9	$ - 0	$ - 0
E	F	Taxes, Fees & Surcharges	EA	9	$ - 0	$ - 0
E	G	Taxes, Fees & Surcharges (SLIN E/A)	EA	9	$ - 0	$ - 0

F		Circuit Extension (PWS Appendix 1, Para 5.8)
F	A	2-Wire Voice Circuit & Termination	EA	3	$ - 0	$ - 0
F	B	2-Wire Voice Circuit Transport Mileage	1/4 MI	38.5	$ - 0	$ - 0
F	C	Other Taxes, Fees and Surcharges	EA	3	$ - 0	$ - 0

G		Public Listings (PWS Appendix 1, Para 5.9)
G	A	Public Listings	EA	50	$ - 0	$ - 0
G	B	Cross-Reference Listing	EA	2	$ - 0	$ - 0

Total $ - 0 $ - 0 $ - 0

Pricing Schedule Summary

	Date:
Pricing Schedule
	PRICING SUMMARY FOR
LOCAL COMMERCIAL TELECOMMUNICATIONS SERVICE
Barksdale AFB, LA

BASE YEAR OPTION YEAR ONE OPTION YEAR TWO OPTION YEAR THREE OPTION YEAR FOUR OPTIONAL 6-MO EXTENSION

		PRICING SUMMARY		PRICING SUMMARY		PRICING SUMMARY		PRICING SUMMARY		PRICING SUMMARY		PRICING SUMMARY
CLIN	Services & Function Items	MONTHLY	ANNUALLY	MONTHLY	ANNUALLY	MONTHLY	ANNUALLY	MONTHLY	ANNUALLY	MONTHLY	ANNUALLY	MONTHLY	ANNUALLY
0001	NON-RECURRING CHARGES (NRC)		$0.00		$0.00		$0.00		$0.00		$0.00		$0.00
0002	MONTHLY RECURRING CHARGES (MRC)	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
0004	CUTOVER		$0.00

TOTAL: $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

BASE YEAR + ALL OPTION YEARS TOTAL: $0.00

File details come from the government source that posted it.