# INTEG BOQ — translated from MRT7 INTEGRATION BOQ.xlsx (sheet "INTEG BOQ") to standard YAML
# Per Design Principle D — translation step before downstream work consumes the BOQ structure.
# Source: 00-customer-inputs/MRT7 INTEGRATION BOQ.xlsx, sheet "INTEG BOQ", rows 11-25
# Customer item codes preserved for traceability; bidder-added DUPA structure for Phase 6.

metadata:
  project: "SMC MRT-7 Stations and Depot Electronics Networks (FDAS + ACS Integration)"
  customer: "SMC MASS RAIL TRANSIT 7, INC."
  bid_pack_source: "MRT7 INTEGRATION BOQ.xlsx → INTEG BOQ sheet"
  date_translated: "2026-04-29"
  translator_notes: |
    The INTEG BOQ sheet contains 12 lump-sum lines split across two phases:
    - Phase 1 (rows 1-7): Stations to Depot-Admin Bldg-OCC Integration
    - Phase 2 (rows 8-12): Depot Buildings to Depot-Admin Bldg-FCCR Integration
    Bidder must DUPA-decompose each lump sum into materials/equipment + labor sub-lines.
    All unit costs are blank in source — bidder fills.
    Currency: PHP. VAT-inclusive (per Email_Text §2 + TOR §3.4 + A-401).
    Customer item codes (e.g., 1123.2.8.A) reference ANNEX_C1 spec sections.

# Bidder-added "General Requirements" (per Email_Text §3 + TOR §11.4 — DPWH-style item codes)
# Per D-013 / WBS Section 0 — these are added to the bid; not in the customer's INTEG BOQ.
general_requirements:
  - id: GR-01
    item_code: "B.7(2)"
    description: "Occupational Safety and Health Program (180 CD multi-site)"
    unit: "L.S."
    quantity: 1
    wbs_ref: "0.1"
    dupa_components: ["safety officer fees", "PPE bulk", "safety signage", "safety training", "incident reports"]
  - id: GR-02
    item_code: "B.8(2)"
    description: "Traffic Management (multi-site rotation across 12 stations + depot)"
    unit: "L.S."
    quantity: 1
    wbs_ref: "0.2"
    dupa_components: ["traffic plans", "barricades", "warning signs", "flagman labor"]
  - id: GR-03
    item_code: "B.9"
    description: "Mobilization and Demobilization (12 stations + depot)"
    unit: "L.S."
    quantity: 1
    wbs_ref: "0.3"
    dupa_components: ["mobilization to depot", "per-station mobilization × 12", "demob"]
  - id: GR-04
    item_code: "—"
    description: "Project Manager (REE, full-time on-site, 6 months) per TOR §8.3"
    unit: "month"
    quantity: 6
    wbs_ref: "0.4"
  - id: GR-05
    item_code: "—"
    description: "Engineer-in-charge (REE, full-time on-site) per TOR §8.4"
    unit: "month"
    quantity: 6
    wbs_ref: "0.5"
  - id: GR-06
    item_code: "—"
    description: "PEE supervisory engagement (R.A. 9292)"
    unit: "month"
    quantity: 6
    wbs_ref: "0.6"
  - id: GR-07
    item_code: "—"
    description: "Site Supervisors × 2 (full-time, 6 months)"
    unit: "month"
    quantity: 12  # 2 supervisors × 6 months
    wbs_ref: "0.7"
  - id: GR-08
    item_code: "—"
    description: "Interface Manager + Engineer (part-time at engineering phases)"
    unit: "L.S."
    quantity: 1
    wbs_ref: "0.8"
  - id: GR-09
    item_code: "—"
    description: "All-risk + third-party + workmen's-compensation insurance (180 CD coverage)"
    unit: "L.S."
    quantity: 1
    wbs_ref: "0.9"
  - id: GR-10
    item_code: "—"
    description: "Surety bonds — Advance Payment + Performance Bond (20% of Contract Price, valid until Taking-Over) + Warranty Bond (10% of Contract Price, valid 2 years)"
    unit: "L.S."
    quantity: 1
    wbs_ref: "0.10"
  - id: GR-11
    item_code: "—"
    description: "All local + government permits (LGU + MMDA + DOLE + working permits)"
    unit: "L.S."
    quantity: 1
    wbs_ref: "0.11"
  - id: GR-12
    item_code: "—"
    description: "BOC duties for imported items + VAT pass-through"
    unit: "L.S."
    quantity: 1
    wbs_ref: "0.12"
  - id: GR-13
    item_code: "—"
    description: "Daily + Weekly Accomplishment Reports + Monthly Primavera P6 schedule update + As-built drawing prep + signed/sealed hard copy"
    unit: "L.S."
    quantity: 1
    wbs_ref: "0.13"
  - id: GR-14
    item_code: "—"
    description: "Site office + temporary power + comms + vehicles + tools (180 CD)"
    unit: "L.S."
    quantity: 1
    wbs_ref: "0.14"

# Phase 1 — Stations to Depot-Admin Bldg-OCC Integration (per INTEG BOQ rows 13-22)
phase_1:
  description: "Phase 1 (Stations to Depot-Admin Bldg-OCC Integration)"
  items:
    - id: P1-01
      item_code: "1123.2.8"
      description: |
        Fire Detection and Alarm System (FDAS) Workstation Computer System (1123.2.8)
        Complete with the following:
          • Workstation Computer (1123.2.8.A*) To use 32" LED Monitor [A-103]
          • Server (for centralized FDAS management) (1123.2.8.B*)
          • Software (1123.2.8.C*) — Notifier OnyxWorks compatible with NFS2-3030 [A-101]
          • Network Switch (1123.2.8.D*) — managed industrial Ethernet UL 508 [A-106]
          • Uninterruptible Power Supply (UPS) (1123.2.8.E*) — 2 kVA online double-conversion [A-104]
          • Peripherals (1123.2.8.E*) — HP LaserJet color printer [A-107]
        Per Engineering Specification (Electronics) for Depot — ANNEX_C1 §1123.2.8.
        Software (Monitoring and Control), including GUI, perpetual license.
      unit: "Lot"
      quantity: 1
      wbs_ref: "2.1, 4.1"
      dupa_components:
        - "Workstation PC (Intel i7 12gen, 32GB DDR4, 1TB NVMe SSD, 32\" LED FHD)"
        - "Server (Intel Xeon Silver, 64GB ECC, 2x2TB RAID-1, 4U rackmount)"
        - "Notifier OnyxWorks server license (perpetual)"
        - "Notifier OnyxWorks client license (perpetual)"
        - "L2 Industrial Ethernet Switch (24x10/100/1000 + 4 SFP, UL 508)"
        - "Online double-conversion UPS 2 kVA / 1.6 kW"
        - "HP LaserJet color printer (≥30 ppm, 1200 dpi)"
        - "Server rack 42U + cable management"
        - "Software licenses installation + database build labor"
        - "Equipment delivery + setup labor"
    - id: P1-02
      item_code: "1124.2.6"
      description: |
        Access Control System (ACS) Workstation Computer System (1124.2.6)
        Complete with the following:
          • Server Computer (1124.2.7*)
          • L2 (Layer 2) Switch with SFP Ports (1124.2.8*)
          • Badge Printer (1124.2.12*) — ZebraID-class color card printer [A-107]
          • System Software (1124.2.13*) — Suprema BioStar 2 Enterprise compatible with CS-40 [A-102]
          • System Database (1124.2.14*) — Microsoft SQL Server 2019
        Per ANNEX_C1 §1124.2.6 / 2.7 / 2.8 / 2.12 / 2.13 / 2.14.
        Software (Monitoring and Control), including GUI, perpetual license.
      unit: "Lot"
      quantity: 1
      wbs_ref: "2.2, 4.1"
      dupa_components:
        - "ACS Server Computer (i7 3.0 GHz 64-bit, 16+ GB RAM)"
        - "Suprema BioStar 2 Enterprise license (perpetual)"
        - "Suprema BioStar 2 Client license (perpetual)"
        - "Microsoft SQL Server 2019 LTS license"
        - "L2 Industrial Ethernet Switch with SFP (24x10/100/1000 + 4 SFP, UL 508) — separate from FDAS [A-106]"
        - "ZebraID-class badge printer + ribbon kit"
        - "Suprema BioMini Plus 2 fingerprint enrollment device + DE-620 card encoder"
        - "Software installation + database build + DB schema setup labor"
        - "Equipment delivery + setup labor"
    - id: P1-03
      item_code: "—"
      description: "Supply and installation of required network interface card and or other required media converter and gateways including software's for the system integration."
      unit: "ps"
      quantity: 1
      wbs_ref: "2.3, 2.7, 4.4"
      dupa_components:
        - "Notifier ONYXWorks NCM-W or equivalent network communication module × 12 stations (FDAS gateway per station)"
        - "ACS gateway / media converter (Ethernet to FOC) × 12 stations"
        - "Surge protector + power conditioner × 24 (one per gateway)"
        - "Wall enclosure / mounting × 12 (where exposed)"
        - "Cable terminations + IP config + OnyxWorks node-add + BioStar 2 controller pairing labor × 12 stations"
        - "Per-station coordination with REC + per-station respective contractor labor (D-017)"
    - id: P1-04
      item_code: "—"
      description: "Supply and installation of Control and Communication Cable including related accessories to complete the system (workstation ↔ CER @ OCC)"
      unit: "ps"
      quantity: 1
      wbs_ref: "2.4, 4.2, 4.3"
      dupa_components:
        - "Control and communication cable @ OCC (workstation-to-CER) — STP / FOC patch as needed"
        - "Cable terminations (RJ45, LC, screw terminals)"
        - "Cable IDs + labels"
        - "Pulling + termination labor"
    - id: P1-05
      item_code: "—"
      description: "Supply and installation of Power Supply Cables including Conduit and Boxes and other related accessories to complete the system @ OCC"
      unit: "ps"
      quantity: 1
      wbs_ref: "2.5, 4.2"
      dupa_components:
        - "Power supply cable to UPS + workstation + server (2.5/4 mm² THW)"
        - "EMT conduit + boxes + fittings @ OCC"
        - "Pull boxes + cable trays + supports"
        - "Pulling + termination + labeling labor"
    - id: P1-06
      item_code: "—"
      description: "Table and Chairs for Admin-OCC (workstation furniture per TOR §4.5 — table accommodates up to 4 workstations + ergonomic chairs)"
      unit: "ps"
      quantity: 1
      wbs_ref: "2.6, 4.1"
      dupa_components:
        - "Workstation table (4-PC capacity, ergonomic, depot-grade)"
        - "Ergonomic chairs × 4-6 (operator + supervisor seating)"
        - "Cable trays + monitor arms + accessories"
        - "Assembly + positioning labor"
    - id: P1-07
      item_code: "—"
      description: "Testing and commissioning (Phase 1 — Standalone + Integration + Performance per TOR §4.21)"
      unit: "Lot"
      quantity: 1
      wbs_ref: "7.1-7.6, 7.10"
      dupa_components:
        - "Pre-commissioning + cable tests"
        - "FDAS Standalone Test per panel (×12 stations)"
        - "ACS Standalone Test per controller (×12)"
        - "FDAS + ACS Integration Test per path (×24 — 12 stations × 2 systems)"
        - "Performance Test (multi-alarm; load; response-time)"
        - "T&C documentation + reports"
        - "Test instruments + tools"

# Phase 2 — Depot Buildings to Depot-Admin Bldg-FCCR Integration (per INTEG BOQ rows 23-27)
phase_2:
  description: "Phase 2 (Depot Buildings to Depot-Admin Bldg-FCCR Integration)"
  items:
    - id: P2-08
      item_code: "—"
      description: "Supply and installation of Control and Communication Cable including related accessories to complete the system (inter-building Phase 2 — depot)"
      unit: "Lot"
      quantity: 1
      wbs_ref: "3.3, 5.3, 5.4, 5.5, 5.6"
      dupa_components:
        - "Single-mode FOC inter-building (24-core OS2 armored, OSP-rated, per ANNEX_C1 §1124.2.9)"
        - "STP Cat6A inter-building (outdoor-rated underground, per §1124.2.10)"
        - "FOC patch cords + LC patch panels"
        - "Splice trays + fusion splices at manhole splice points (per ANNEX_A 13005)"
        - "Cable terminations + IDs"
        - "Surge protectors at every termination (per TOR §4.2 + A-205)"
        - "Pulling labor (through Civil-Contractor-built ductbank — A-005 site-dev conduit excluded)"
        - "Fusion splicing labor + OTDR test + Cat6A test labor"
    - id: P2-09
      item_code: "—"
      description: "Supply and installation of required network interface card and or other required media converter and gateways including software's for the system integration (Phase 2 — depot buildings)"
      unit: "ps"
      quantity: 1
      wbs_ref: "3.4, 5.7"
      dupa_components:
        - "FDAS gateway per depot integration point (~5 sites — Genset / Aux / TPSSR / etc.)"
        - "ACS gateway per depot integration point (~5 sites)"
        - "Surge protector + mounting × 10"
        - "Configuration + commissioning labor"
    - id: P2-10
      item_code: "—"
      description: "Supply and installation of Power Supply Cables including Conduit and Boxes and other related accessories to complete the system @ FCCR"
      unit: "Lot"
      quantity: 1
      wbs_ref: "3.5, 5.2"
      dupa_components:
        - "Power supply cable to FCCR head-end (UPS + WS + server) — 2.5/4 mm² THW"
        - "EMT conduit + boxes + fittings @ FCCR"
        - "Pull boxes + cable trays + supports"
        - "Pulling + termination + labeling labor"
    - id: P2-11
      item_code: "—"
      description: "Table and Chairs for Admin-FCCR (workstation furniture per TOR §4.5)"
      unit: "ps"
      quantity: 1
      wbs_ref: "3.6, 5.1"
      dupa_components:
        - "Workstation table (4-PC capacity, ergonomic)"
        - "Ergonomic chairs × 4-6"
        - "Cable trays + monitor arms"
        - "Assembly + positioning labor"
    - id: P2-12
      item_code: "—"
      description: "Testing and Commissioning (Phase 2 — Depot Buildings + FCCR)"
      unit: "Lot"
      quantity: 1
      wbs_ref: "7.1-7.6, 7.10"
      dupa_components:
        - "FDAS Standalone Test per depot panel-node (~5)"
        - "ACS Standalone Test per controller (~5)"
        - "Integration Test depot-to-FCCR (~10 paths)"
        - "Performance Test"
        - "T&C documentation + reports"

# Bidder-added line items at the bottom of the BOQ (per Email_Text §1: "Proposed additional items must inserted at the bottom most of the BOQ")
addenda:
  description: "Bidder-added line items per Email §1 + D-016"
  items:
    - id: ADD-01
      item_code: "—"
      description: "FDAS Field Devices @ Genset Building (smoke / heat / manual call points / horn-strobes / monitoring modules) — per Resp. Matrix Phase 2 Genset row + ANNEX_C1 §1123.2.5"
      unit: "Lot"
      quantity: 1
      wbs_ref: "3.7, 5.8"
      dupa_components: ["Notifier addressable smoke detector × N", "Heat detector × N", "Manual pull station × N", "Horn-strobe × N", "Monitoring module × N", "Mounting + addressing + walk-test labor"]
    - id: ADD-02
      item_code: "—"
      description: "FDAS Field Devices @ Guard Houses (3 buildings: GH-1, GH-2A, GH-2D) — per Resp. Matrix"
      unit: "Lot"
      quantity: 1
      wbs_ref: "3.8, 5.8"
      dupa_components: ["Notifier addressable smoke × 3-6", "Manual pull × 3", "Horn-strobe × 3", "Mounting + addressing + walk-test"]
    - id: ADD-03
      item_code: "—"
      description: "Phase 1 head-end at FCCR (mirror of OCC FDAS+ACS workstation systems) — Resp. Matrix Phase 2 Depot Admin FCCR row implies our Phase-2 deliverable includes FCCR head-end"
      unit: "Lot"
      quantity: 1
      wbs_ref: "3.1, 3.2, 5.1"
      dupa_components: ["FDAS WS+server+UPS+printer+L2 switch (FCCR mirror)", "ACS WS+server+UPS+badge printer+L2 switch (FCCR mirror)", "Furniture set (table + chairs)", "Software licenses (FDAS + ACS — additional client seats)"]
    - id: ADD-04
      item_code: "—"
      description: "**FAT travel — Notifier facility, Northford, Connecticut, USA** (per TOR §3.8 + §8.11; D-016 separate line item) — Owner + DOTr + Contractor witness (3-person team), 5-7 day duration"
      unit: "L.S."
      quantity: 1
      wbs_ref: "7.7"
      dupa_components: ["Round-trip airfare × 3 (US business/economy)", "Hotel × 7 nights × 3", "Per diem (USD) × 7 days × 3", "Ground transport (taxi/rental car)", "FAT day-rate witness fees", "Visa + travel insurance"]
    - id: ADD-05
      item_code: "—"
      description: "**FAT travel — Suprema facility, Seongnam, South Korea** (per TOR §3.8 + §8.11; D-016 separate line item) — Owner + DOTr + Contractor witness (3-person team), 5-7 day duration"
      unit: "L.S."
      quantity: 1
      wbs_ref: "7.8"
      dupa_components: ["Round-trip airfare × 3 (Korea)", "Hotel × 7 nights × 3", "Per diem (KRW) × 7 days × 3", "Ground transport", "FAT day-rate witness fees", "Visa + travel insurance"]
    - id: ADD-06
      item_code: "—"
      description: "Recommended 2-year spare-parts kit (FDAS + ACS) per TOR §4.18-4.19 with justification + metrics"
      unit: "Lot"
      quantity: 1
      wbs_ref: "8.4, 8.5"
      dupa_components: ["FDAS spares (Notifier addressable detectors, modules, batteries)", "ACS spares (Suprema controller spare, BioMini Plus 2 backup, certificates kit)", "L2 switch spare", "UPS spare battery"]
    - id: ADD-07
      item_code: "—"
      description: "O&M Manual + Training material development + Training certificates (FDAS + ACS, signed/sealed) per TOR §4.16-4.17, §4.22"
      unit: "Lot"
      quantity: 1
      wbs_ref: "8.1-8.7"
      dupa_components: ["O&M Manual authoring + signed/sealed binding", "Training slide decks (FDAS + ACS)", "Lab guides + quick-reference cards", "Training session delivery (Q-010 sizing)", "Training certificates"]
    - id: ADD-08
      item_code: "—"
      description: "3-year software support + upgrades package per TOR §4.23 (start: post-acceptance)"
      unit: "L.S."
      quantity: 1
      wbs_ref: "8.6"
      dupa_components: ["Year-1 support + upgrades", "Year-2 support + upgrades", "Year-3 support + upgrades", "Latest-version upgrade at completion (initial)"]

# Cross-reference: customer's INTEG BOQ row → our translated structure
customer_row_mapping:
  description: "Mapping from MRT7 INTEGRATION BOQ.xlsx INTEG BOQ rows to translated YAML"
  rows:
    - customer_row: 1
      customer_section: "Phase 1"
      customer_text: "FDAS Workstation Computer System (1123.2.8)"
      translated_id: "P1-01"
    - customer_row: 2
      customer_section: "Phase 1"
      customer_text: "ACS Workstation Computer System (1124.2.6)"
      translated_id: "P1-02"
    - customer_row: 3
      customer_section: "Phase 1"
      customer_text: "Network interface card / media converter / gateways"
      translated_id: "P1-03"
    - customer_row: 4
      customer_section: "Phase 1"
      customer_text: "Control and Communication Cable"
      translated_id: "P1-04"
    - customer_row: 5
      customer_section: "Phase 1"
      customer_text: "Power Supply Cables / Conduit / Boxes"
      translated_id: "P1-05"
    - customer_row: 6
      customer_section: "Phase 1"
      customer_text: "Table and Chairs for Admin-OCC"
      translated_id: "P1-06"
    - customer_row: 7
      customer_section: "Phase 1"
      customer_text: "Testing and commissioning"
      translated_id: "P1-07"
    - customer_row: 8
      customer_section: "Phase 2"
      customer_text: "Control and Communication Cable (inter-building)"
      translated_id: "P2-08"
    - customer_row: 9
      customer_section: "Phase 2"
      customer_text: "Network interface card / media converter / gateways"
      translated_id: "P2-09"
    - customer_row: 10
      customer_section: "Phase 2"
      customer_text: "Power Supply Cables / Conduit / Boxes"
      translated_id: "P2-10"
    - customer_row: 11
      customer_section: "Phase 2"
      customer_text: "Table and Chairs for Admin-FCCR"
      translated_id: "P2-11"
    - customer_row: 12
      customer_section: "Phase 2"
      customer_text: "Testing and Commissioning"
      translated_id: "P2-12"