Attachment_1_-_Pricing_Schedule.xlsx

XLSX spreadsheet 111 KB Posted Aug 4, 2023

Attached to: GPS CLOCK SYSTEM Federal contract opportunity
Solicitation number: 140A2323Q0615
Issued by: Department of the Interior Bureau of Indian Affairs Bureau of Indian Education

About this file

Written by GovTribe AI · Dec 21, 2023

This document contains two cost estimates for a GPS clock system project for an Indian school. The first estimate is for clocks at the high school, totaling approximately $50,249. It includes materials, labor, and fees for a transmitter, 95 analog clocks, wiring, conduit, and installation. The second estimate is for clocks at the elementary and middle schools, without pricing as the document appears to be a template.

The related federal contract opportunity is solicitation number 140A2323Q0615 from the Department of the Interior Bureau of Indian Affairs Bureau of Indian Education for a GPS clock system. No further details are provided on response dates, award dates, pricing terms, or other contract requirements.

View the file

Other files for this federal contract opportunity

Other files attached to GPS CLOCK SYSTEM, newest first.
File	Type	Posted
Sol_140A2323Q0615_Amd_0002.pdf	PDF	Sep 15, 2023
Sol_140A2323Q0615_Amd_0001.pdf	PDF	Aug 11, 2023
B09__Attachment-140A2323Q0615_(0001)_0001.pdf	PDF	Aug 11, 2023
Sol_140A2323Q0615.pdf	PDF	Aug 4, 2023
Attachment_2_-_SOW.pdf	PDF	Aug 4, 2023

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.

High School Primex Clock

Project Title:	Clock System for School from Beacon
Location:	ST. STEPHENS INDIAN SCHOOL
Date:	March 14, 2023
Subject:	Rough Order of Magnitude Cost Estimate

							Basis of Estimate	Material Cost	Labor Cost	Equipment Cost	Material Unit Cost	Crew	Labor Hours	Labor Rates	Labor Unit Cost	Equipment Unit Cost	REFERENCES
Item	Description		QTY	UOM	Unit Price USD	Total USD											RS MEANS	Web Reference
I.	230031 St Stephen Indian School - High School - Primex Clocks
		FCC License	1.00	EA	$ 2,389.60	$ 2,389.60		$ 1,424.35	$ 965.25	$ - 0	$ 1,424.35		24.240		$ 965.25		275313500100
		Transmitter 1 Watt with Ethernet Port (with GPS)	1.00	EA	$ 3,078.54	$ 3,078.54		$ 2,918.75	$ 159.79	$ - 0	$ 2,918.75		4.000		$ 159.79		275313500600
		Transmitter Accessory Pack - Transmitter Rack	1.00	EA	$ 1,371.05	$ 1,371.05		$ 1,330.95	$ 40.10	$ - 0	$ 1,330.95		1.000		$ 40.10		271116200120
		Transmitter Accessory Pack - UPS	1.00	EA	$ 1,283.74	$ 1,283.74		$ 1,144.15	$ 139.59	$ - 0	$ 1,144.15		3.500		$ 139.59		263353100110
		GPS Extension Cable for XR Transmitters, Coaxial	1.00	CLF	$ 94.27	$ 94.27		$ 54.17	$ 40.10	$ - 0	$ 54.17		1.000		$ 40.10		271533103870
		72Mhz Analog Clock, 12.5" Black	95.00	EA	$ 142.84	$ 13,569.80		$ 9,760.30	$ 3,809.50	$ - 0	$ 102.74		1.000		$ 40.10		275313504100
		Dual D-cell Alkaline Battery Pack	95.00	EA	$ 76.31	$ 7,249.45		$ 3,439.95	$ 3,809.50	$ - 0	$ 36.21		1.000		$ 40.10		275313504100	https://www.grainger.com/product/DURACELL-D-Battery-Premium-21EK77
		18" X 18" Analog Wire Guard	6.00	EA	$ 234.94	$ 1,409.64		$ 1,183.44	$ 226.20	$ - 0	$ 197.24		0.800		$ 37.70		055823900400
		Power Supply Outlets	2.00	Ea	$ 48.28	$ 96.56		$ 72.86	$ 23.70	$ - 0	$ 36.43		0.296		$ 11.85		262726202540
		Fire Blocking (Fire Caulk)	10.00	Ea	$ 37.34	$ 373.40		$ 199.10	$ 174.30	$ - 0	$ 19.91		0.500		$ 17.43		078413100200
		Multi Pair Non Plenum Shileded #18, 2pair PVC Jacketed Cables	3.00	C.L.F.	$ 208.59	$ 625.77		$ 470.73	$ 155.04	$ - 0	$ 156.91		1.300		$ 51.68		271513138502
		Wire, copper, stranded, 600 volt, #12AWG, type THWN, normal installation conditions in wireway, conduit, cable tray	6.00	C.L.F.	$ 88.75	$ 532.50	Electrical supply wiring	$ 329.64	$ 202.86	$ - 0	$ 54.94	1 ELEC	0.727		$ 33.81		260519901200
		Cat 6 #24 4pair Stranded PVC Jacket	3.00	C.L.F.	$ 77.83	$ 233.49	Signal wiring	$ 74.10	$ 159.39	$ - 0	$ 24.70	1 ELEC	1.143		$ 53.13		271513137244
		3/4" Rigid Steel Conduit including fittings and supports	450.00	L.F.	$ 9.54	$ 4,293.00	Conduit for wiring	$ 2,196.00	$ 2,097.00	$ - 0	$ 4.88	1 ELEC	0.100		$ 4.66		260533131770
		J-Hook 4"	25.00	Ea	$ 14.12	$ 353.00		$ 233.50	$ 119.50	$ - 0	$ 9.34	1 ELEC	0.120		$ 4.78		270529100140
		Lock out and Tag Out	10.00	Ea	$ 9.15	$ 91.50		$ 72.70	$ 18.80	$ - 0	$ 7.27	1 ELEC	0.040		$ 1.88		013114200120
		System Testing and commissioning	1.00	Lot	$ 370.45	$ 370.45		$ - 0	$ 370.45	$ - 0					$ 370.45		019113500250
								$ 24,904.69	$ 12,511.07	$ - 0
						$ 37,415.76		$ 37,415.76
	Contingencies 20%					$ 7,483.15											012116500050	20%
	Security adjustment factor, Escort required to be with tradesperson during work effort					$ 781.94											012153600440	6.25% of labor
Total Direct Cost						$ 45,680.86
	FEE 10%					$ 4,568.09
ESTIMATED TOTAL COST						$ 50,248.94

https://www.grainger.com/product/DURACELL-D-Battery-Premium-21EK77 High School Primex Clock Labor

Project Title:	Clock System for School from Beacon
Location:	ST. STEPHENS INDIAN SCHOOL
Date:	March 16, 2023
Subject:	Rough Order of Magnitude Cost Estimate

							Basis of Estimate	Material Cost	Labor Cost	Equipment Cost	Material Unit Cost	Crew	Labor Hours	Labor Rates	Labor Unit Cost	Equipment Unit Cost	REFERENCES
Item	Description		QTY	UOM	Unit Price USD	Total USD											RS MEANS	Web Reference
I.	230031 St Stephen Indian School - High School - Primex Clocks
		FCC License	1.00	EA		$ - 0							24.240
		1 Electrician	24.24	HOURS		$ - 0	LABOR FOR INSTALLATION OF FCC License					1 ELEC	24.240
		Transmitter 1 Watt with Ethernet Port (with GPS)	1.00	EA		$ - 0							4.000
		1 Electrician	4.00	HOURS		$ - 0	LABOR FOR INSTALLATION OF TRANSMITTER					1ELEC	4.000
		Transmitter Accessory Pack - Transmitter Rack	1.00	EA		$ - 0							1.000
		1 Electrician	1.00	HOURS		$ - 0	LABOR FOR INSTALLATION OF TRANSMITTER RACK					1ELEC	1.000
		Transmitter Accessory Pack - UPS	1.00	EA		$ - 0							3.500
		1 Electrician	3.50	HOURS		$ - 0	LABOR FOR INSTALLATION OF UPS					1ELEC	3.500
		GPS Extension Cable for XR Transmitters, Coaxial	1.00	CLF		$ - 0							1.000
		1 Electrician	1.00	HOURS		$ - 0	LABOR FOR INSTALLATION OF GPS Extension Cable					1ELEC	1.000
		72Mhz Analog Clock, 12.5" Black	95.00	EA		$ - 0							1.000
		1 Electrician	95.00	HOURS		$ - 0	LABOR FOR INSTALLATION Analog Clock					1ELEC	1.000
		Dual D-cell Alkaline Battery Pack	95.00	EA		$ - 0							1.000
		1 Electrician	95.00	HOURS		$ - 0	LABOR FOR INSTALLATION OF BATTERY					1ELEC	1.000
		18" X 18" Analog Wire Guard	6.00	EA		$ - 0							0.800
		CREW E-4	4.80	HOURS		$ - 0	LABOR FOR INSTALLATION OF ANALOG WIRE GUARD, Crew E-4 composition: 1 STRUC. STEEL FOREMAN & 3 STRUC. STEEL WORKERS					E-4	0.800
		Power Supply Outlets	2.00	Ea		$ - 0							0.296
		1 Electrician	0.59	HOURS		$ - 0	LABOR FOR INSTALLATION OF Power Supply Outlets					1ELEC	0.296
		Fire Blocking (Fire Caulk)	10.00	Ea		$ - 0							0.500
		1 Carpenter	5.00	HOURS		$ - 0	LABOR FOR INSTALLATION Fire Block					1CARP	0.500
		Multi Pair Non Plenum Shileded #18, 2pair PVC Jacketed Cables	3.00	C.L.F.		$ - 0							1.300
		1 Electrician	3.90	HOURS		$ - 0	LABOR FOR INSTALLATION OF Cables					1ELEC	1.300
		Wire, copper, stranded, 600 volt, #12AWG, type THWN, normal installation conditions in wireway, conduit, cable tray	6.00	C.L.F.		$ - 0	Electrical supply wiring						0.727
		1 Electrician	4.36	HOURS		$ - 0	LABOR FOR INSTALLATION OF Electrical Supply Wiring					1 ELEC	0.727
		Cat 6 #24 4pair Stranded PVC Jacket	3.00	C.L.F.		$ - 0	Signal wiring						1.143
		1 Electrician	3.43	HOURS		$ - 0	LABOR FOR INSTALLATION OF Signal Wiring					1 ELEC	1.143
		3/4" Rigid Steel Conduit including fittings and supports	450.00	L.F.		$ - 0	Conduit for wiring						0.100
		1 Electrician	45.00	HOURS		$ - 0	LABOR FOR INSTALLATION OF Conduit					1 ELEC	0.100
		J-Hook 4"	25.00	Ea		$ - 0							0.120
		1 Electrician	3.00	HOURS		$ - 0	LABOR FOR INSTALLATION OF J-Hook					1 ELEC	0.120
		Lock out and Tag Out	10.00	Ea		$ - 0							0.040
		1 Electrician	0.40	HOURS		$ - 0	LABOR FOR INSTALLATION OF LOTO DEVICE					1 ELEC	0.040
		System Testing and commissioning	1.00	Lot		$ - 0

		$ - 0
	Contingencies 20%	$ - 0
	Security adjustment factor, Escort required to be with tradesperson during work effort
Total Direct Cost		$ - 0
	FEE 10%	$ - 0
ESTIMATED TOTAL COST		$ - 0

Elem and Middle- Primex Clock

Project Title:	Clock System for School from Beacon
Location:	ST. STEPHENS INDIAN SCHOOL
Date:	March 14, 2023
Subject:	Rough Order of Magnitude Cost Estimate

Basis of Estimate

Material Cost

Labor Cost

Equipment Cost

Material Unit Cost

Crew

Labor Hours

Labor Rates

Labor Unit Cost

Equipment Unit Cost

REFERENCES

Item

Description

QTY

UOM

Unit Price USD

Total USD

RS MEANS

Web Reference

230030 St Stephen Indian School - Elem and Middle School - Primex Clocks

FCC License

1.00

24.240

Transmitter 1 Watt with Ethernet Port (with GPS)

1.00

4.000

Transmitter Accessory Pack - Transmitter Rack

1.00

1.000

Transmitter Accessory Pack - UPS

1.00

3.500

GPS Extension Cable for XR Transmitters, Coaxial

1.00

CLF

1.000

72Mhz Analog Clock, 12.5" Black

56.00

1.000

Dual D-cell Alkaline Battery Pack

56.00

1.000

18" X 18" Analog Wire Guard

3.00

0.800

Power Supply Outlets

2.00

0.296

Fire Blocking (Fire Caulk)

10.00

0.500

Multi Pair Non Plenum Shileded #18, 2pair PVC Jacketed Cables

3.00

C.L.F.

1.300

Wire, copper, stranded, 600 volt, #12AWG, type THWN, normal installation conditions in wireway, conduit, cable tray

6.00

C.L.F.

Electrical supply wiring

1 ELEC

0.727

Cat 6 #24 4pair Stranded PVC Jacket

3.00

C.L.F.

Signal wiring

1 ELEC

1.143

3/4" Rigid Steel Conduit including fittings and supports

450.00

L.F.

Conduit for wiring

1 ELEC

0.100

J-Hook 4"

25.00

1 ELEC

0.120

Lock out and Tag Out

10.00

1 ELEC

0.040

System Testing and commissioning

1.00

Lot

		$ - 0
	Contingencies 20%	$ - 0
	Security adjustment factor, Escort required to be with tradesperson during work effort
Total Direct Cost		$ - 0
	FEE 10%	$ - 0
ESTIMATED TOTAL COST		$ - 0

Elem and Middle- Primex Clo Lab

Project Title:	Clock System for School from Beacon
Location:	ST. STEPHENS INDIAN SCHOOL
Date:	March 16, 2023
Subject:	Rough Order of Magnitude Cost Estimate

Basis of Estimate

Material Cost

Labor Cost

Equipment Cost

Material Unit Cost

Crew

Labor Hours

Labor Rates

Labor Unit Cost

Equipment Unit Cost

REFERENCES

Item

Description

QTY

UOM

Unit Price USD

Total USD

RS MEANS

Web Reference

230030 St Stephen Indian School - Elem and Middle School - Primex Clocks

FCC License

1.00

24.240

1 Electrician

24.24

HOURS

LABOR FOR INSTALLATION OF FCC License

1 ELEC

24.240

Transmitter 1 Watt with Ethernet Port (with GPS)

1.00

4.000

1 Electrician

4.00

HOURS

LABOR FOR INSTALLATION OF TRANSMITTER

1ELEC

4.000

Transmitter Accessory Pack - Transmitter Rack

1.00

1.000

1 Electrician

1.00

HOURS

LABOR FOR INSTALLATION OF TRANSMITTER RACK

1ELEC

1.000

Transmitter Accessory Pack - UPS

1.00

3.500

1 Electrician

3.50

HOURS

LABOR FOR INSTALLATION OF UPS

1ELEC

3.500

GPS Extension Cable for XR Transmitters, Coaxial

1.00

CLF

1.000

1 Electrician

1.00

HOURS

LABOR FOR INSTALLATION OF GPS Extension Cable

1ELEC

1.000

72Mhz Analog Clock, 12.5" Black

56.00

1.000

1 Electrician

56.00

HOURS

LABOR FOR INSTALLATION Analog Clock

1ELEC

1.000

Dual D-cell Alkaline Battery Pack

56.00

1.000

1 Electrician

56.00

HOURS

LABOR FOR INSTALLATION OF BATTERY

1ELEC

1.000

18" X 18" Analog Wire Guard

3.00

0.800

CREW E-4

2.40

HOURS

LABOR FOR INSTALLATION OF ANALOG WIRE GUARD, Crew E-4 composition: 1 STRUC. STEEL FOREMAN & 3 STRUC. STEEL WORKERS

E-4

0.800

Power Supply Outlets

2.00

0.296

1 Electrician

0.59

HOURS

LABOR FOR INSTALLATION OF Power Supply Outlets

1ELEC

0.296

Fire Blocking (Fire Caulk)

10.00

0.500

1 Carpenter

5.00

HOURS

LABOR FOR INSTALLATION Fire Block

1CARP

0.500

Multi Pair Non Plenum Shileded #18, 2pair PVC Jacketed Cables

3.00

C.L.F.

1.300

1 Electrician

3.90

HOURS

LABOR FOR INSTALLATION OF Cables

1ELEC

1.300

Wire, copper, stranded, 600 volt, #12AWG, type THWN, normal installation conditions in wireway, conduit, cable tray

6.00

C.L.F.

Electrical supply wiring

0.727

1 Electrician

4.36

HOURS

LABOR FOR INSTALLATION OF Electrical Supply Wiring

1 ELEC

0.727

Cat 6 #24 4pair Stranded PVC Jacket

3.00

C.L.F.

Signal wiring

1.143

1 Electrician

3.43

HOURS

LABOR FOR INSTALLATION OF Signal Wiring

1 ELEC

1.143

3/4" Rigid Steel Conduit including fittings and supports

450.00

L.F.

Conduit for wiring

0.100

1 Electrician

45.00

HOURS

LABOR FOR INSTALLATION OF Conduit

1 ELEC

0.100

J-Hook 4"

25.00

0.120

1 Electrician

3.00

HOURS

LABOR FOR INSTALLATION OF J-Hook

1 ELEC

0.120

Lock out and Tag Out

10.00

0.040

1 Electrician

0.40

HOURS

LABOR FOR INSTALLATION OF LOTO DEVICE

1 ELEC

0.040

System Testing and commissioning

1.00

Lot

		$ - 0
	Contingencies 20%	$ - 0
	Security adjustment factor, Escort required to be with tradesperson during work effort
Total Direct Cost
	FEE 10%
ESTIMATED TOTAL COST

Assumptions

Assumptions:

1.) Excluded scope from Beacon are included in these estimates: Grounding bus bars, Conduits, Boxes , Cat5E cables, power supply cables(THHN), and Twisted Pair cables 18/2.

2.)Due to absence of layout drawings, Cat5E cables, power supply cables(THHN), Twisted Pair cables 18/2 are estimated 3 clf only for main control/equipments for Elem and Middle School. field clocks are wireless.

3.)Due to absence of layout drawings, Cat5E cables, power supply cables(THHN), Twisted Pair cables 18/2 are estimated are estimated 3 clf only for main control/equipments for High School. Field clocks are wireless.

4.)Conduits are based on the linear lengths of power and communication cable.

Grand Totals

High school

Elementary school

Grand Total

RFI

RFI
ITEM	RFI	Client's Response
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
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128

image1.png

File details come from the government source that posted it. Updated Aug 4, 2023.