CLIN Pricing Worksheet AMD02 832468978.xlsx

XLSX spreadsheet 39 KB Posted Dec 4, 2024

Attached to: Power Systems Maintenance and Repair Contract Federal contract opportunity
Solicitation number: HC102824R0073
Issued by: Defense Information Systems Agency

About this file

Written by GovTribe AI · Dec 4, 2024

This is a CLIN (Contract Line Item Number) pricing worksheet for a UPS Maintenance Contract with the Defense Information Systems Agency (DISA). The contract structure includes five CLINs across a base period and four option periods: Scheduled Preventative Maintenance (FFP), Critical Event Maintenance (T&M), Unscheduled Maintenance (T&M), Battery/Capacitor Replacement (FFP), and Travel Costs fixed at $8,000 per period. A 25% surge CLIN is included at $2,000 per period, bringing total costs to $10,000 per period or $50,000 total.

The worksheet details labor categories for Electronics Technicians I and II working at government sites, with 136 labor hours allocated per period. Material requirements include standard replacement parts (filters, fans, rectifiers, capacitors) and various battery types including Valve Regulated Lead Acid Batteries for different UPS systems (Eaton 48kW, APC SYCF40KF, APC SYCF100KF, APC PX200kw, and APC Symmetra Galaxy VS 50kVa). The labor rates and material costs are blank in this template, requiring contractor input.

View the file

Other files for this federal contract opportunity

Other files attached to Power Systems Maintenance and Repair Contract, newest first.
File	Type	Posted
CLIN Pricing Worksheet AMD01 832468978.xlsx	XLSX spreadsheet	Nov 22, 2024
PWS Table 3 832468978.docx	DOCX document	Nov 22, 2024
RFP AMD01 HC102824R0073.pdf	PDF	Nov 22, 2024
Eaton Battery Screenshot Sep 2024.png	PNG image	Nov 22, 2024
PWS Table 2 832468978.docx	DOCX document	Nov 22, 2024
QASP 832468978 JITC UPS.docx	DOCX document	Nov 22, 2024
PWS Table 1 832468978.docx	DOCX document	Nov 22, 2024
Screenshot 2024-09-09 125119 Eaton Battery.png	PNG image	Sep 10, 2024
Site Visit Instructions.doc	DOC document	Aug 23, 2024
JITC UPS pricing sheet.xlsx	XLSX spreadsheet	Aug 23, 2024
HC102824R0073 solicitation.pdf	PDF	Aug 23, 2024

Show all 11

On GovTribe

Work with this file on GovTribe

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.

(CUI) Summary Defense Information Systems Agency (DISA)

	COMPLETE THE FOLLOWING:
Solicitation Title	UPS Maintenance
Contract Vehicle	SAM.gov
Contractor
CAGE Code
UEI Number

	CLIN STRUCTURE SUMMARY
	CLIN Number	CLIN Description	Contract Type	Base Period	Option Period 1	Option Period 2	Option Period 3	Option Period 4	Total Price
	0001	PWS Task 1 - Scheduled
Preventative Maintenance	FFP	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0002	PWS Task 2 - Critical Event
Maintenance	T&M	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0003	PWS Task 3 - Unscheduled
Maintenance	T&M	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0004	PWS Task 4 - Battery/Capacitor
Replacement	FFP	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0005	Travel	Cost	$ 8,000.00	$ 8,000.00	$ 8,000.00	$ 8,000.00	$ 8,000.00	$ 40,000.00

		Subtotal:	$ 8,000.00	$ 8,000.00	$ 8,000.00	$ 8,000.00	$ 8,000.00	$ 40,000.00
9999	Surge (Not to Exceed)	25%	$ 2,000.00	$ 2,000.00	$ 2,000.00	$ 2,000.00	$ 2,000.00	$ 10,000.00
		TOTAL COST:	$ 10,000.00	$ 10,000.00	$ 10,000.00	$ 10,000.00	$ 10,000.00	$ 50,000.00

(CUI) IGCE-Base Period

	Defense Information Systems Agency (DISA)
	Base Period
	CLIN #	PWS Task	Labor Category #
(if applicable)	Labor Category	Government Site / Contractor Site	Developed/Source Labor Hr. Rate	Discount Percent	Estimated Labor Hr. Rate	Labor Hours	Amount

x001	6.1.1 Scheduled Preventative Maintenance	23181	Electronic Technician I	Government Site	$0.00	0	$ - 0
x001	6.1.1 Scheduled Preventative Maintenance	23182	Electronics Technician II	Government Site	$0.00	0	$ - 0

x002	6.1.2 Critical Event Maintenance	23181	Electronic Technician I (Normal Duty Hours)	Government Site	$0.00	22	$ - 0
x002	6.1.2 Critical Event Maintenance	23181	Electronic Technician I (OutsideDuty Hours)	Government Site	$0.00	16	$ - 0
x002	6.1.2 Critical Event Maintenance	23182	Electronics Technician II (Normal Duty Hours)	Government Site	$0.00	22	$ - 0
x002	6.1.2 Critical Event Maintenance	23182	Electronics Technician II (Outside Duty Hours)	Government Site	$0.00	16	$ - 0

x003	6.1.3 Unscheduled Maintenance	23181	Electronics Technician I (Normal Duty Hours)	Government Site	$0.00	30	$ - 0
x003	6.1.3 Unscheduled Maintenance	23182	Electronics Technician II (Normal Duty Hours)	Government Site	$0.00	30	$ - 0

x004	6.1.4 Battery/Capacitor Replacement	23181	Electronic Technician I	Government Site	$0.00	0	$ - 0
x004	6.1.4 Battery/Capacitor Replacement	23182	Electronic Technician II	Government Site	$0.00	0	$ - 0

Total Labor	136	$ - 0
Materials (from below)**		$ - 0
Total Estimated Price		$ - 0

Materials
CLIN	PWS/SOW Task	Proposed Item	Description	Part Number	Unit Cost	Quantity	Total Amount

	X001	6.1.1 Scheduled Preventative
Maintenance	Filters, fans, rectifiers, capacitors etc.	Standard replacement Parts	Varies	$ - 0	13	$ - 0
	X004	6.1.4 Battery/Capacitor
Replacement	Batteries	Valve Regulate Lead Acid Battery	VRLA AT-39 P	$ - 0	72	$ - 0
	x004	6.1.4 Battery/Capacitor Replacement	Capacitors	Capicitors for Toshiba and MGE	Varies	$ - 0	48	$ - 0

Materials Total $ - 0

(CUI) IGCE-Option Period 1

	Defense Information Systems Agency (DISA)
	Option Period 1
	CLIN #	PWS Task	Labor Category #
(if applicable)	Labor Category	Government Site / Contractor Site	Developed/Source Labor Hr. Rate	Discount Percent	Estimated Labor Hr. Rate	Labor Hours	Amount

x001	6.1.1 Scheduled Preventative Maintenance	23181	Electronic Technician I	Government Site	$0.00	0	$ - 0
x001	6.1.1 Scheduled Preventative Maintenance	23182	Electronics Technician II	Government Site	$0.00	0	$ - 0

x002	6.1.2 Critical Event Maintenance	23181	Electronic Technician I (Normal Duty Hours)	Government Site	$0.00	22	$ - 0
x002	6.1.2 Critical Event Maintenance	23181	Electronic Technician I (OutsideDuty Hours)	Government Site	$0.00	16	$ - 0
x002	6.1.2 Critical Event Maintenance	23182	Electronics Technician II (Normal Duty Hours)	Government Site	$0.00	22	$ - 0
x002	6.1.2 Critical Event Maintenance	23182	Electronics Technician II (Outside Duty Hours)	Government Site	$0.00	16	$ - 0

x003	6.1.3 Unscheduled Maintenance	23181	Electronics Technician I (Normal Duty Hours)	Government Site	$0.00	30	$ - 0
x003	6.1.3 Unscheduled Maintenance	23182	Electronics Technician II (Normal Duty Hours)	Government Site	$0.00	30	$ - 0

x004	6.1.4 Battery/Capacitor Replacement	23181	Electronic Technician I	Government Site	$0.00	0	$ - 0
x004	6.1.4 Battery/Capacitor Replacement	23182	Electronic Technician II	Government Site	$0.00	0	$ - 0

Total Labor	136	$ - 0
Materials (from below)**		$ - 0
Total Estimated Price		$ - 0

Materials
CLIN	PWS/SOW Task	Proposed Item	Description	Part Number	Unit Cost	Quantity	Total Amount

X001 6.1.1 Scheduled Preventative Maintenance Filters, fans, rectifiers, capacitors etc. Standard replacement Parts Varies $ - 0 13 $ - 0

Materials Total $ - 0

(CUI) IGCE-Option Period 2

	Defense Information Systems Agency (DISA)
	Option Period 2
	CLIN #	PWS Task	Labor Category #
(if applicable)	Labor Category	Government Site / Contractor Site	Developed/Source Labor Hr. Rate	Discount Percent	Estimated Labor Hr. Rate	Labor Hours	Amount

x001	6.1.1 Scheduled Preventative Maintenance	23181	Electronic Technician I	Government Site	$0.00	0	$ - 0
x001	6.1.1 Scheduled Preventative Maintenance	23182	Electronics Technician II	Government Site	$0.00	0	$ - 0

x002	6.1.2 Critical Event Maintenance	23181	Electronic Technician I (Normal Duty Hours)	Government Site	$0.00	22	$ - 0
x002	6.1.2 Critical Event Maintenance	23181	Electronic Technician I (OutsideDuty Hours)	Government Site	$0.00	16	$ - 0
x002	6.1.2 Critical Event Maintenance	23182	Electronics Technician II (Normal Duty Hours)	Government Site	$0.00	22	$ - 0
x002	6.1.2 Critical Event Maintenance	23182	Electronics Technician II (Outside Duty Hours)	Government Site	$0.00	16	$ - 0

x003	6.1.3 Unscheduled Maintenance	23181	Electronics Technician I (Normal Duty Hours)	Government Site	$0.00	30	$ - 0
x003	6.1.3 Unscheduled Maintenance	23182	Electronics Technician II (Normal Duty Hours)	Government Site	$0.00	30	$ - 0

x004	6.1.4 Battery/Capacitor Replacement	23181	Electronic Technician I	Government Site	$0.00	0	$ - 0
x004	6.1.4 Battery/Capacitor Replacement	23182	Electronic Technician II	Government Site	$0.00	0	$ - 0

Total Labor	136	$ - 0
Materials (from below)**		$ - 0
Total Estimated Price		$ - 0

Materials
CLIN	PWS/SOW Task	Proposed Item	Description	Part Number	Unit Cost	Quantity	Total Amount
X001	6.1.1 Scheduled Preventative Maintenance	Filters, fans, rectifiers, capacitors etc.	Standard replacement Parts	Varies	$ - 0	13	$ - 0
x004	6.1.4 Battery/Capacitor Replacement	Batteries Eaton 48kW	Valve Regulate Lead Acid Battery	AGM	$ - 0	160	$ - 0
x004	6.1.4 Battery/Capacitor Replacement	Batteries APC SYCF40KF	Valve Regulate Lead Acid Battery	4 X SYBTU1-PLP	$ - 0	4	$ - 0
x004	6.1.4 Battery/Capacitor Replacement	Batteries APC SYCF100KF	Valve Regulate Lead Acid Battery	4 X SYBTU1-PLP	$ - 0	17	$ - 0
Materials Total							$ - 0

(CUI) IGCE-Option Period 3

	Defense Information Systems Agency (DISA)
	Option Period 3
	CLIN #	PWS Task	Labor Category #
(if applicable)	Labor Category	Government Site / Contractor Site	Developed/Source Labor Hr. Rate	Discount Percent	Estimated Labor Hr. Rate	Labor Hours	Amount

x001	6.1.1 Scheduled Preventative Maintenance	23181	Electronic Technician I	Government Site	$0.00	0	$ - 0
x001	6.1.1 Scheduled Preventative Maintenance	23182	Electronics Technician II	Government Site	$0.00	0	$ - 0

x002	6.1.2 Critical Event Maintenance	23181	Electronic Technician I (Normal Duty Hours)	Government Site	$0.00	22	$ - 0
x002	6.1.2 Critical Event Maintenance	23181	Electronic Technician I (OutsideDuty Hours)	Government Site	$0.00	16	$ - 0
x002	6.1.2 Critical Event Maintenance	23182	Electronics Technician II (Normal Duty Hours)	Government Site	$0.00	22	$ - 0
x002	6.1.2 Critical Event Maintenance	23182	Electronics Technician II (Outside Duty Hours)	Government Site	$0.00	16	$ - 0

x003	6.1.3 Unscheduled Maintenance	23181	Electronics Technician I (Normal Duty Hours)	Government Site	$0.00	30	$ - 0
x003	6.1.3 Unscheduled Maintenance	23182	Electronics Technician II (Normal Duty Hours)	Government Site	$0.00	30	$ - 0

x004	6.1.4 Battery/Capacitor Replacement	23181	Electronic Technician I	Government Site	$0.00	0	$ - 0
x004	6.1.4 Battery/Capacitor Replacement	23182	Electronic Technician II	Government Site	$0.00	0	$ - 0

Total Labor	136	$ - 0
Materials (from below)**		$ - 0
Total Estimated Price		$ - 0

Materials
CLIN	PWS/SOW Task	Proposed Item	Description	Part Number	Unit Cost	Quantity	Total Amount
X001	6.1.1 Scheduled Preventative Maintenance	Filters, fans, rectifiers, capacitors etc.	Standard replacement Parts	Varies	$ - 0	13	$ - 0
x004	6.1.4 Battery/Capacitor Replacement	Batteries APC PX200kw	Valve Regulate Lead Acid Battery	1 X SYBTU2-PLP	$ - 0	240	$ - 0
x004	6.1.4 Battery/Capacitor Replacement	Batteries APC Symmetra Galaxy VS 50kVa	Valve Regulate Lead Acid Battery	1 X SYBTU2-PLP	$ - 0	16	$ - 0

Materials Total $ - 0

(CUI) IGCE-Option Period 4

	Defense Information Systems Agency (DISA)
	Option Period 4
	CLIN #	PWS Task	Labor Category #
(if applicable)	Labor Category	Government Site / Contractor Site	Developed/Source Labor Hr. Rate	Discount Percent	Estimated Labor Hr. Rate	Labor Hours	Amount

x001	6.1.1 Scheduled Preventative Maintenance	23181	Electronic Technician I	Government Site	$0.00	0	$ - 0
x001	6.1.1 Scheduled Preventative Maintenance	23182	Electronics Technician II	Government Site	$0.00	0	$ - 0

x002	6.1.2 Critical Event Maintenance	23181	Electronic Technician I (Normal Duty Hours)	Government Site	$0.00	22	$ - 0
x002	6.1.2 Critical Event Maintenance	23181	Electronic Technician I (OutsideDuty Hours)	Government Site	$0.00	16	$ - 0
x002	6.1.2 Critical Event Maintenance	23182	Electronics Technician II (Normal Duty Hours)	Government Site	$0.00	22	$ - 0
x002	6.1.2 Critical Event Maintenance	23182	Electronics Technician II (Outside Duty Hours)	Government Site	$0.00	16	$ - 0

x003	6.1.3 Unscheduled Maintenance	23181	Electronics Technician I (Normal Duty Hours)	Government Site	$0.00	30	$ - 0
x003	6.1.3 Unscheduled Maintenance	23182	Electronics Technician II (Normal Duty Hours)	Government Site	$0.00	30	$ - 0

x004	6.1.4 Battery/Capacitor Replacement	23181	Electronic Technician I	Government Site	$0.00	0	$ - 0
x004	6.1.4 Battery/Capacitor Replacement	23182	Electronic Technician II	Government Site	$0.00	0	$ - 0

Total Labor	136	$ - 0
Materials (from below)**		$ - 0
Total Estimated Price		$ - 0

Materials
CLIN	PWS/SOW Task	Proposed Item	Description	Part Number	Unit Cost	Quantity	Total Amount

X001	6.1.1 Scheduled Preventative Maintenance	Filters, fans, rectifiers, capacitors etc.	Standard replacement Parts	Varies	$ - 0	13	$ - 0
x004	6.1.4 Battery/Capacitor Replacement	Capacitors	Capicitors for Toshiba and MGE	Varies	$ - 0	48	$ - 0

Materials Total $ - 0

File details come from the government source that posted it. Updated Dec 4, 2024.