NOTA_Vehicle_Camera_RFP_Pricing_Workbook.xlsx

XLSX spreadsheet 31 KB Posted

Attached to
NOTA Onboard Vehicle Camera System State and local contract opportunity
Solicitation number
2025-1002
Issued by
Berrien County, Michigan

About this file

This is an Excel-based Vehicle Camera Request for Proposal (RFP) from the North Oakland Transportation Authority (NOTA), a Michigan nonprofit transportation authority. The RFP solicits proposals for purchasing, delivering, installing, configuring, and supporting an onboard vehicle camera system for NOTA's fleet, which includes 68 total vehicles across multiple vehicle types such as Cutaways, Transits, Minivans, Transit Connects, and Snowplows. The fleet is divided into locally funded vehicles (38 total) and federally funded vehicles (30 total), with vehicle years ranging from 2015 to 2025. The RFP (Control Number RFP 2025-1002) seeks a comprehensive camera system solution that includes cameras, mobile digital video recorders (MDVR), network video recorders (NVR), associated software, storage, accessories, and training.

The proposal requires compliance with Federal Transit Administration (FTA) funding requirements and is tax-exempt. The document indicates that pricing should be all-inclusive, covering labor, travel, tools, freight, delivery, and incidentals. While specific pricing details are not fully completed in the spreadsheet, the RFP framework suggests a per-vehicle bundled approach with options for camera configurations, licensing, storage, and potential upgrades like live streaming. The system specifications include multiple camera views such as front view, driver view, passenger view, lift view, and wheelchair area views. The solicitation emphasizes that GPS/telematics integration should include vehicle health and diagnostic data if available, and NOTA intends to award the contract to the most advantageous proposer considering price and other evaluation factors.

View the file

Other files for this state and local contract opportunity

Other files attached to NOTA Onboard Vehicle Camera System, newest first.
File Type Posted
v5 NOTA Updated_RFP_Vehicle_Camera_v4 10 31 25 (Final).pdf PDF

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

Text version

NOTA Vehicle Local funded

YEARLOANER OR OWNEDVEHICLE ID NO (Chassis Serial Number)NOTA BUS NUMBERSMART BUS NUMBERLIFT/RAMPMILEAGEIN SERVICE DATEORIGINAL FUNDING SOURCETransit//PromasterVoyager MinivanSnowplow/Ford Connect
Front View, Driver View, Passenger View, Lift view, exterior of lift viewFront View, Driver View, Wheelchair view, exterior of wheelchair viewFront View, Driver View
2015OWNEDNM0AS8F7XF1201261122NO9449706/23/2015NOTAFORDCONNECT1
2018OWNED1FTYR3XM7JKA69079134YES12976306/06/2018NOTAFORDTRANSIT1
2019OWNED1FTRS4XM5KKB71996137YES13157712/17/2019NOTAFORDTRANSIT1
2021OWNED3C6LRVPG2ME532520143YES6433111/01/2021NOTARAMPROMASTER1
2021OWNED3C6LRVPG2ME532521144YES9471711/01/2021NOTARAMPROMASTER1
2023OWNED1FDAX2C80PKA26475148YES5239204/15/2023NOTAFORDTRANSIT1
2023OWNED1FDAX9CG4PKA42498149YES5053506/15/2023NOTAFORDTRANSIT1
2023OWNED2C4RC1CG0PR548626150YES4025108/01/2023NOTACHRYSLERVOYAGER1
2023OWNED2C4RC1CG0PR548643151YES4328108/01/2023NOTACHRYSLERVOYAGER1
2023OWNED2C4RC1CG5PR538903152YES4680308/01/2023NOTACHRYSLERVOYAGER1
2023OWNED2C4RC1CFG7PR53889153YES3777208/01/2023NOTACHRYSLERVOYAGER1
2023OWNED2C4RC1CG8PR579509154YES3900008/01/2023NOTACHRYSLERVOYAGER1
2023OWNED1FD7X2B69NEF47393155NO50009/19/2023NOTAFORDF-2501
2023OWNED3C6LRVPG3NE116446156YES3263201/02/2024NOTARAM1
2023OWNED2C4RC1CG1PR587919158YES2833302/05/2023NOTACHRYSLERVOYAGER1
2023OWNED2C4RC1CG1PR588083159YES2089102/05/2023NOTACHRYSLERVOYAGER1
2023OWNED2C4RC1CG8PR582880160YES2878002/05/2024NOTACHRYSLERVOYAGER1
2023OWNED1FDVU4X86PKA59190161YES3368402/27/2024NOTAFORDTRANSIT1
2023OWNED1FDVU4X82PKA60515170YES2480703/15/2024NOTAFORDTRANSIT1
2023OWNED1FDVU4X8XPKA61086171YES1857203/22/2024NOTAFORDTRANSIT1
2023OWNED1FDVU4X80PKA59198172YES2792003/22/2024NOTAFORDTRANSIT1
2023OWNED1FDVU4X84PKA59611173YES2650804/09/2024NOTAFORDTRANSIT1
2023OWNED1FDVU4X87PKA58369174YES2537704/092024NOTAFORDTRANSIT1
2023OWNED1FDVU4X87PKA59991175YES2775904/11/2024NOTAFORDTRANSIT1
2023OWNED1FDVU4X8PKA61069176YES2044805/23/2024NOTAFORDTRANSIT1
2023OWNED1FDVU4X80PKA59427177YES1799106/10/2024NOTAFORDTRANSIT1
2023OWNED1FDVU4X85PKA60539178YES1909606/21/2024NOTAFORDTRANSIT1
2023OWNED1FDVU5XG1RKA65964179YES2186906/21/2024NOTAFORDTRANSIT1
2023OWNED1FDVU5XG1RKA64104180YES2011306/20/2024NOTAFORDTRANSIT1
2023OWNED1FDVU5XG7RKA64110181YES1795307/02/2024NOTAFORDTRANSIT1
2023OWNED1FDVU5XG1RKA64894182YES1760107/02/2024NOTAFORDTRANSIT1
2023OWNED1FDVU5XG0RKA64174183YES1554907/02/2024NOTAFORDTRANSIT1
2023OWNED1FDVU5XG9RKA64173184YES1425207/02/2024NOTAFORDTRANSIT1
2023OWNED1FDVU5XFG8RKA63788185YES1636707/02/2024NOTAFORDTRANSIT1
2023OWNED1FDVU5XG4RKA64906186YES1817007/02/2024NOTAFORDTRANSIT1
2023OWNED1FDVU5XG1RKA63663187YES1563507/02/2024NOTAFORDTRANSIT1
2023OWNED1FDVU5XG9RKA65159188YES1739507/24/2024NOTAFORDTRANSIT1
20251FBVU4X82RKB73084195YES45845NOTAFORDTRANSIT1Total

Number by Vehicle Type 28 8 2 38

SMART Vehicles Federal Funded

YEARVEHICLE ID NO (Chassis Serial Number)NOTA BUS NUMBERSMART BUS NUMBERLIFT/RAMPCutawayTransit/PromasterVoyager MinivanSnowplow/Ford Connect
Forward Facing, Driver, Passengers, Interior wheelchair securement area and lift, Exterior wheelchair lift exiting/enteringForward Facing, Driver, Passengers, Interior wheelchair securement area and lift, Exterior wheelchair lift exiting/enteringDual facing camera, Passenger area and lift area1 Dual facing camera
20151GB6G5BL3F114052812435093YESCHEVF-4501
20151GB6G5BL2F114034312335099YESCHEVF-4501
20161GB6GUBL2G125471219136135YESCMCF-4501
20161GB6GUBL4G125478919236136YESCMCF-4501
20181FDFE4FS9JDC3852719338006YESCMCF-4501
20181FDFE4FS0JDC3852819438007YESCMCF-4501
20181FDFE4FS2JDC3852913538008YESFORDE4501
20191FDFE4FS7KDC4576713639114YESFORDE4501
20201FDVU4XMXKKB8609314039156YESFORDTRANSIT1
20201FDVU4XM1KKB8609414139157YESFORDTRANSIT1
20201FDVU4XM3KKB8609513839158YESFORDTRANSIT1
20201FDVU4XM5KKB8609613939159YESFORDTRANSIT1
20201FDVU4XM2KKB8610514239168YESFORDTRANSIT1
20211FDVU4X81LKB7568219041002YESFORDTRANSIT1
20211FDVU4X87LKB7568514541005YESFORDTRANSIT1
20211FDVU4X80LKB7568614641006YESFORDTRANSIT1
20211FDVU4X80LKB7568714741007YESFORDTRANSIT1
20241FDFE4FN8RDD2077216843012YESFORDF-4501
20241FDFE4FN9RDD2077816943018YESFORDF-4501
20241FDVU4X8XPKB6027818944009YESFORDTRANSIT1
20241FDVU4X84PKB6002016644015YESFORDTRANSIT1
20241FDVU4X81PKB6002416244016YESFORDTRANSIT1
20241FDVU4X84PKB6009616344017YESFORDTRANSIT1
20241FDVU4X88PKB6012016444018YESFORDTRANSIT1
20241FDVU4X86PKB6029316544019YESFORDTRANSIT1
20241FDVU4X81PKB6034616744020YESFORDTRANSIT1
20251FDFE4FN2SDD18442On Order45023YESCMCCH230FL1
20251FDFE4FN9SDD18454On Order45024YESCMCCH230FL1
20251FDFE4FN0SDD18455On Order45025YESCMCCH230FL1
20251FDFE4FN4SDD18457On Order45026YESCMCCH230FL1

Number by Vehicle Type 12 18 0 0 30

Cover & Assumptions

RFP TitleNOTA Vehicle Camera RFP
RFP Control NumberRFP 2025-1002
Offeror Legal Name
Primary Contact (Name/Title)
Email / Phone
Proposal Valid Until (≥180 days)
CurrencyUSD
FOBDestination
Tax StatusNOTA is TAX-EXEMPT. Do NOT include sales/use tax.
NotesPrices are all-in: include labor, travel, tools, freight, delivery, incidentals.
InstructionsComplete all tabs. Excel governs over any PDFs. Use provided headers.

Per-Vehicle Bundles

Vehicle_ClassBundle_DescriptionCameras_CountMDVR/NVR_ModelIncluded_Components (mounts/cables/commissioning/as-builts)Per-Vehicle_PriceQty VehiclesExtended_TotalNotes
0
ie Standard 6-cam 1080p bundleInclude all install labor0
SMART OWNED - FEDERALLY FUNDED: (SEE SEPARATE WORKSHEET FOR VEHICLE DETAILS)0
Cutaways120
Transits180
0
0
NOTA OWNED - LOCALLY FUNDED:0
Cutaways00
Transits280
Minivans80
Transit Connect (no lift - small vehicle)10
Snowplow10
0
0
680
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

Hardware & Spares

CategoryMake/ModelPart_NoDescriptionUnitUnit_PriceWarranty_Term (months)Advance_Replacement (Y/N)Notes
Camera-Interior1080p interior domeeach36Y/N

Licensing & Storage

ModuleBasis (per-veh/per-user/GB-mo)Qty_BasisAnnual_Unit_PriceAnnual_TotalTerm_YearsNotes
0Include alerting & dashboards
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

Options & Upgrades

Option_ItemDescriptionPricing_BasisUnit_PriceQtyExtended_TotalNotes
Live StreamingOn-demand live view per vehicleper-vehicle per month0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

Milestones & Payment

MilestoneDescription%_of_TotalDollar_ValueAcceptance_Criteria (tie to RFP deliverables)Invoice_TriggerNotes
Production Tranchee.g., 20 vehicles acceptedAs-builts + inventory receivedUpon tranche acceptance
Final AcceptanceAll deliverables completeAll items closed; training completeUpon final acceptance

TCO Summary (Y1–Y5)

YearHardwareInstallationLicensesStorage (GB-mo or hrs/veh)Support/MaintenanceOptionsSparesSubtotalCumulative_TotalAssumptions/Notes
Y100
Y200
Y300
Y4 (Option)00
Y5 (Option)00

File details come from the government source that posted it. Updated .