DFSP San Pedro CCTV Install Summary.xlsx

XLSX spreadsheet 21 KB Posted

Attached to
San Pedro CCTV
Solicitation number
N66001-19-Q-6321
Issued by

View the file

Other files

File Type Posted
PWS - DFSP San Pedro Final.pdf PDF
Eval Criteria _DFSP San Pedro.docx DOCX document
20190222 - DFSP San Pedro CCTV Upgrade Notional Design.pdf PDF
WD 15-5613 LA.pdf PDF
JNCP redacted.pdf PDF

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

Summary Summary Rationale for Basis:

The materials are estimated based on a site survey with the customer and the labor hours are estimated based on the materials and the work expected. The site survey is intended to minimize assumptions made and any assumptions are documented in the PWS. Material costs are estimated using market research on Google and various vendors. Labor rates are estimated based on previous TO awards and invoices.

Para 3.0CLIN 0001Labor$ - 0ERROR:#DIV/0!
CLIN 0002ODC$ - 0
CLIN 0003Data$ - 0
$ - 0

Labor PWS 3.0

CategoryRateHoursSubtotal
Project Admin100$ - 0
Program Manager100$ - 0
System Administrator0$ - 0
Lead Technician185$ - 0
Technician340$ - 0
Drafter110$ - 0
Fee$ - 0
835$ - 0

ODC PWS 3.0

DescriptionPart NumberCost/UnitQuantitySubtotal
CCTV WorkstationDell Precision 58202$ - 0
License, 1 ChannelAvigilon 1C-HD-NVMS-ENT25$ - 0
Network Video Recorder, 16 TBAvigilon HD-NVR4-STD-16TB2$ - 0
Camera, FixedAxis P1367-E25$ - 0
Outdoor POE SwitchAxis T8504-E16$ - 0
Outdoor POE ExtenderAxis T8129-E6$ - 0
UPS, TowerAPC SMT15002$ - 0
UPS, Rack MountAPC SMT3000RM2U1$ - 0
SFP Module SM-1000BaseCisco SFP-GLC-LH-SMD34$ - 0
Network Switch, 12 Port PoECisco WS-C3560CX-12PC-S2$ - 0
Network Switch, 12 Port SFP OnlyCisco WS-C3850-12S-S2$ - 0
Monitor, 27"Dell P2717H2$ - 0
Equipment Rack, 12U Wall Mount RackGreat Lakes GL24WM1$ - 0
MaterialsMiscellaneous1$ - 0
40' Boom Lift RentalRental per Week2$ - 0
KVM ConsoleTripp-Lite B030-008-17-IP1$ - 0
40" LED Wall Display, 24/7 OperationNEC V404-AVT22$ - 0
Display Wall Mount KitPremier AM1752$ - 0
Cable, 1,000 ft.Ethernet, CAT64$ - 0
Cable, 1,000 ft.Fiber, 12-Strand SM, Plenum1$ - 0
Cable, 1,000 ft.Power, 18/2, Plenum1$ - 0
Conduit, 100 ft.Conduit, 1 in. EMT8$ - 0
M&S$ - 0
Travel (see 'Travel' tab)$ - 0
$ - 0

Subtotal $ - 0

Travel

Input DataSubtotals per Trip4.80%Labor Estimate
Task - Labor CategoryFromToFTEsDays / TripNightsTripsLodgingPer DiemAirfareRental CarOther Transport ExpensesDaily
ExpensesLodging TaxMileage (one way)Travel Time (one way)Baggage Fee
(one way)LodgingPer DiemAirfareCar RentalOther Transportation ExpensesDaily
ExpensesLodging TaxMileageBaggage FeeSubtotal
(all trips)G&ATotalWorking HoursTravel HoursOT HoursTotal
1 - TechnicianSan Diego, CASan Pedro, CA2545$ - 0$ - 03.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0340.0060.000.00400.00
1 - TechnicianSan Diego, CASan Pedro, CA1216$ - 0$ - 03.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 060.0036.000.0096.00
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.000.000.000.00
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.000.000.000.00
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.000.000.000.00
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.000.000.000.00

$ - 0 400.00 96.00 0.00 496.00

File details come from the government source that posted it.