{
  "head": {
    "rfps": 12,
    "nights_in_play": 60515,
    "spend_in_play": 18443067.89,
    "awarded_saving": 344876.63000000024,
    "pipeline_saving": 1133395.5199999998,
    "awarded": 4
  },
  "pipeline": [
    {
      "rfp_id": "RFP-202603",
      "station": "HKG",
      "city": "Hong Kong",
      "entity": "ASL Airlines France",
      "season": "Summer 2027",
      "status": "negotiating",
      "opened_at": "2026-03-03",
      "due_at": "2026-08-22",
      "awarded_at": null,
      "annual_nights": 6198,
      "current_rate": 348.92,
      "target_rate": 325.47,
      "awarded_rate": null,
      "awarded_property": null,
      "owner": "P. Costa",
      "reason": "Rate above benchmark for two quarters"
    },
    {
      "rfp_id": "RFP-202609",
      "station": "JNB",
      "city": "Johannesburg",
      "entity": null,
      "season": "Summer 2027",
      "status": "negotiating",
      "opened_at": "2026-01-09",
      "due_at": "2026-08-28",
      "awarded_at": null,
      "annual_nights": 3876,
      "current_rate": 266.26,
      "target_rate": 235.48,
      "awarded_rate": null,
      "awarded_property": null,
      "owner": "R. Menon",
      "reason": "Volume now justifies contracting"
    },
    {
      "rfp_id": "RFP-202610",
      "station": "TLS",
      "city": "Toulouse",
      "entity": "ASL Airlines Ireland",
      "season": "Winter 2026/27",
      "status": "evaluating",
      "opened_at": "2026-02-01",
      "due_at": "2026-09-20",
      "awarded_at": null,
      "annual_nights": 5243,
      "current_rate": 273.45,
      "target_rate": 244.72,
      "awarded_rate": null,
      "awarded_property": null,
      "owner": "Loïc Berger",
      "reason": "Rate above benchmark for two quarters"
    },
    {
      "rfp_id": "RFP-202604",
      "station": "DXB",
      "city": "Dubai",
      "entity": "ASL Airlines Ireland",
      "season": "Winter 2026/27",
      "status": "evaluating",
      "opened_at": "2026-04-04",
      "due_at": "2026-09-23",
      "awarded_at": null,
      "annual_nights": 4963,
      "current_rate": 326.5,
      "target_rate": 299.66,
      "awarded_rate": null,
      "awarded_property": null,
      "owner": "R. Menon",
      "reason": "Crew score below threshold"
    },
    {
      "rfp_id": "RFP-202611",
      "station": "MRS",
      "city": "Marseille",
      "entity": "ASL Airlines Belgium",
      "season": "Summer 2027",
      "status": "out_to_bid",
      "opened_at": "2026-03-02",
      "due_at": "2026-10-21",
      "awarded_at": null,
      "annual_nights": 9116,
      "current_rate": 270,
      "target_rate": 234.9,
      "awarded_rate": null,
      "awarded_property": null,
      "owner": "P. Costa",
      "reason": "Crew score below threshold"
    },
    {
      "rfp_id": "RFP-202605",
      "station": "MAD",
      "city": "Madrid",
      "entity": null,
      "season": "Summer 2027",
      "status": "out_to_bid",
      "opened_at": "2026-05-05",
      "due_at": "2026-10-24",
      "awarded_at": null,
      "annual_nights": 5002,
      "current_rate": 289.45,
      "target_rate": 265.57,
      "awarded_rate": null,
      "awarded_property": null,
      "owner": "Loïc Berger",
      "reason": "No contract at this station"
    },
    {
      "rfp_id": "RFP-202606",
      "station": "LYS",
      "city": "Lyon",
      "entity": "ASL Airlines France",
      "season": "Winter 2026/27",
      "status": "planning",
      "opened_at": "2026-06-06",
      "due_at": "2026-11-25",
      "awarded_at": null,
      "annual_nights": 4662,
      "current_rate": 269.48,
      "target_rate": 246.48,
      "awarded_rate": null,
      "awarded_property": null,
      "owner": "Loïc Berger",
      "reason": "Allotment consistently overflowing"
    },
    {
      "rfp_id": "RFP-202612",
      "station": "EMA",
      "city": "East Midlands",
      "entity": "ASL Airlines France",
      "season": "Winter 2026/27",
      "status": "planning",
      "opened_at": "2026-04-03",
      "due_at": "2026-11-22",
      "awarded_at": null,
      "annual_nights": 1643,
      "current_rate": 324.13,
      "target_rate": 300.84,
      "awarded_rate": null,
      "awarded_property": null,
      "owner": "Loïc Berger",
      "reason": "No contract at this station"
    },
    {
      "rfp_id": "RFP-202601",
      "station": "BRU",
      "city": "Brussels",
      "entity": null,
      "season": "Summer 2027",
      "status": "awarded",
      "opened_at": "2026-01-01",
      "due_at": "2026-06-20",
      "awarded_at": "2026-06-10",
      "annual_nights": 7383,
      "current_rate": 336.87,
      "target_rate": 304.41,
      "awarded_rate": 319.52,
      "awarded_property": "Thon Hotel EU",
      "owner": "R. Menon",
      "reason": "Contract expires within 90 days"
    },
    {
      "rfp_id": "RFP-202607",
      "station": "STN",
      "city": "London Stansted",
      "entity": "ASL Airlines Ireland",
      "season": "Summer 2027",
      "status": "awarded",
      "opened_at": "2026-07-07",
      "due_at": "2026-06-26",
      "awarded_at": "2026-06-16",
      "annual_nights": 7018,
      "current_rate": 339.42,
      "target_rate": 303.11,
      "awarded_rate": 321.19,
      "awarded_property": "Radisson Blu Stansted",
      "owner": "P. Costa",
      "reason": "Property suspended, replacement needed"
    },
    {
      "rfp_id": "RFP-202602",
      "station": "CGN",
      "city": "Cologne",
      "entity": "ASL Airlines Belgium",
      "season": "Winter 2026/27",
      "status": "awarded",
      "opened_at": "2026-02-02",
      "due_at": "2026-07-21",
      "awarded_at": "2026-07-11",
      "annual_nights": 3492,
      "current_rate": 295.42,
      "target_rate": 270.73,
      "awarded_rate": 281.98,
      "awarded_property": "Ibis Koln Messe",
      "owner": "R. Menon",
      "reason": "Volume now justifies contracting"
    },
    {
      "rfp_id": "RFP-202608",
      "station": "BHX",
      "city": "Birmingham",
      "entity": "ASL Airlines Belgium",
      "season": "Winter 2026/27",
      "status": "awarded",
      "opened_at": "2026-08-08",
      "due_at": "2026-07-27",
      "awarded_at": "2026-07-17",
      "annual_nights": 1919,
      "current_rate": 310.34,
      "target_rate": 281.88,
      "awarded_rate": 288.5,
      "awarded_property": "Novotel Birmingham Airport",
      "owner": "R. Menon",
      "reason": "Contract expires within 90 days"
    }
  ],
  "byRfp": {
    "RFP-202601": [
      {
        "bid_id": "BID-1",
        "rfp_id": "RFP-202601",
        "property_id": "P-117",
        "property_name": "Thon Hotel EU",
        "chain": "Thon",
        "bid_rate": 287.86,
        "currency": "EUR",
        "rate_includes": "Wifi only",
        "allotment_offered": 24,
        "transfer_minutes": 37,
        "crew_suitable": 1,
        "received_at": "2026-01-11",
        "status": "awarded",
        "score": 76.69,
        "note": "Awarded — best all-in against transfer time"
      },
      {
        "bid_id": "BID-4",
        "rfp_id": "RFP-202601",
        "property_id": "P-117",
        "property_name": "Thon Hotel EU",
        "chain": "Thon",
        "bid_rate": 308.04,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi, taxes, parking",
        "allotment_offered": 13,
        "transfer_minutes": 20,
        "crew_suitable": 1,
        "received_at": "2026-01-14",
        "status": "shortlisted",
        "score": 64.55,
        "note": null
      },
      {
        "bid_id": "BID-3",
        "rfp_id": "RFP-202601",
        "property_id": "P-119",
        "property_name": "Sheraton Brussels Airport",
        "chain": "Marriott",
        "bid_rate": 341.92,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi, taxes, parking",
        "allotment_offered": 8,
        "transfer_minutes": 25,
        "crew_suitable": 1,
        "received_at": "2026-01-13",
        "status": "rejected",
        "score": 66.53,
        "note": null
      },
      {
        "bid_id": "BID-2",
        "rfp_id": "RFP-202601",
        "property_id": "P-118",
        "property_name": "NH Brussels Airport",
        "chain": "NH",
        "bid_rate": 350.33,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi, taxes",
        "allotment_offered": 17,
        "transfer_minutes": 34,
        "crew_suitable": 1,
        "received_at": "2026-01-12",
        "status": "rejected",
        "score": 66.84,
        "note": null
      }
    ],
    "RFP-202602": [
      {
        "bid_id": "BID-7",
        "rfp_id": "RFP-202602",
        "property_id": "P-109",
        "property_name": "Novotel Koln City",
        "chain": "Accor",
        "bid_rate": 255.53,
        "currency": "EUR",
        "rate_includes": "Wifi only",
        "allotment_offered": 11,
        "transfer_minutes": 31,
        "crew_suitable": 1,
        "received_at": "2026-02-13",
        "status": "shortlisted",
        "score": 63.22,
        "note": null
      },
      {
        "bid_id": "BID-5",
        "rfp_id": "RFP-202602",
        "property_id": "P-107",
        "property_name": "Ibis Koln Messe",
        "chain": "Accor",
        "bid_rate": 256.89,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi",
        "allotment_offered": 17,
        "transfer_minutes": 27,
        "crew_suitable": 1,
        "received_at": "2026-02-11",
        "status": "awarded",
        "score": 77.38,
        "note": "Awarded — best all-in against transfer time"
      },
      {
        "bid_id": "BID-6",
        "rfp_id": "RFP-202602",
        "property_id": "P-108",
        "property_name": "Leonardo Hotel Koln",
        "chain": "Leonardo",
        "bid_rate": 259.9,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi, taxes, parking",
        "allotment_offered": 4,
        "transfer_minutes": 42,
        "crew_suitable": 1,
        "received_at": "2026-02-12",
        "status": "shortlisted",
        "score": 59.7,
        "note": null
      }
    ],
    "RFP-202603": [
      {
        "bid_id": "BID-10",
        "rfp_id": "RFP-202603",
        "property_id": "P-120",
        "property_name": "Regal Airport Hotel",
        "chain": "Regal",
        "bid_rate": 311.39,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi, taxes, parking",
        "allotment_offered": 24,
        "transfer_minutes": 33,
        "crew_suitable": 0,
        "received_at": "2026-03-13",
        "status": "shortlisted",
        "score": 58.77,
        "note": null
      },
      {
        "bid_id": "BID-8",
        "rfp_id": "RFP-202603",
        "property_id": "P-120",
        "property_name": "Regal Airport Hotel",
        "chain": "Regal",
        "bid_rate": 362.57,
        "currency": "EUR",
        "rate_includes": "Wifi only",
        "allotment_offered": 7,
        "transfer_minutes": 27,
        "crew_suitable": 1,
        "received_at": "2026-03-11",
        "status": "rejected",
        "score": 64.52,
        "note": null
      },
      {
        "bid_id": "BID-9",
        "rfp_id": "RFP-202603",
        "property_id": "P-121",
        "property_name": "Hong Kong SkyCity Marriott",
        "chain": "Marriott",
        "bid_rate": 363.45,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi, taxes",
        "allotment_offered": 5,
        "transfer_minutes": 50,
        "crew_suitable": 1,
        "received_at": "2026-03-12",
        "status": "rejected",
        "score": 94.85,
        "note": null
      },
      {
        "bid_id": "BID-11",
        "rfp_id": "RFP-202603",
        "property_id": "P-121",
        "property_name": "Hong Kong SkyCity Marriott",
        "chain": "Marriott",
        "bid_rate": 394.48,
        "currency": "EUR",
        "rate_includes": "Wifi only",
        "allotment_offered": 8,
        "transfer_minutes": 20,
        "crew_suitable": 1,
        "received_at": "2026-03-14",
        "status": "rejected",
        "score": 64.44,
        "note": null
      }
    ],
    "RFP-202604": [
      {
        "bid_id": "BID-12",
        "rfp_id": "RFP-202604",
        "property_id": "P-122",
        "property_name": "Millennium Airport Hotel Dubai",
        "chain": "Millennium",
        "bid_rate": 288.8,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi",
        "allotment_offered": 21,
        "transfer_minutes": 31,
        "crew_suitable": 1,
        "received_at": "2026-04-11",
        "status": "shortlisted",
        "score": 78.43,
        "note": null
      },
      {
        "bid_id": "BID-14",
        "rfp_id": "RFP-202604",
        "property_id": "P-122",
        "property_name": "Millennium Airport Hotel Dubai",
        "chain": "Millennium",
        "bid_rate": 334.71,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi, taxes",
        "allotment_offered": 24,
        "transfer_minutes": 29,
        "crew_suitable": 1,
        "received_at": "2026-04-13",
        "status": "rejected",
        "score": 82.6,
        "note": null
      },
      {
        "bid_id": "BID-13",
        "rfp_id": "RFP-202604",
        "property_id": "P-123",
        "property_name": "Le Meridien Dubai",
        "chain": "Marriott",
        "bid_rate": 361.79,
        "currency": "EUR",
        "rate_includes": "Wifi only",
        "allotment_offered": 11,
        "transfer_minutes": 17,
        "crew_suitable": 1,
        "received_at": "2026-04-12",
        "status": "rejected",
        "score": 75.52,
        "note": null
      }
    ],
    "RFP-202605": [
      {
        "bid_id": "BID-16",
        "rfp_id": "RFP-202605",
        "property_id": "P-136",
        "property_name": "Novotel Madrid Barajas",
        "chain": "Accor",
        "bid_rate": 289.19,
        "currency": "EUR",
        "rate_includes": "Wifi only",
        "allotment_offered": 13,
        "transfer_minutes": 7,
        "crew_suitable": 1,
        "received_at": "2026-05-12",
        "status": "rejected",
        "score": 53.96,
        "note": null
      },
      {
        "bid_id": "BID-17",
        "rfp_id": "RFP-202605",
        "property_id": "P-135",
        "property_name": "Melia Barajas",
        "chain": "Melia",
        "bid_rate": 298.8,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi, taxes, parking",
        "allotment_offered": 19,
        "transfer_minutes": 32,
        "crew_suitable": 1,
        "received_at": "2026-05-13",
        "status": "rejected",
        "score": 76.75,
        "note": null
      },
      {
        "bid_id": "BID-15",
        "rfp_id": "RFP-202605",
        "property_id": "P-135",
        "property_name": "Melia Barajas",
        "chain": "Melia",
        "bid_rate": 306.02,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi, taxes, parking",
        "allotment_offered": 21,
        "transfer_minutes": 15,
        "crew_suitable": 1,
        "received_at": "2026-05-11",
        "status": "rejected",
        "score": 79.75,
        "note": null
      },
      {
        "bid_id": "BID-18",
        "rfp_id": "RFP-202605",
        "property_id": "P-136",
        "property_name": "Novotel Madrid Barajas",
        "chain": "Accor",
        "bid_rate": 307.58,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi, taxes",
        "allotment_offered": 14,
        "transfer_minutes": 47,
        "crew_suitable": 0,
        "received_at": "2026-05-14",
        "status": "rejected",
        "score": 71.35,
        "note": null
      }
    ],
    "RFP-202606": [
      {
        "bid_id": "BID-22",
        "rfp_id": "RFP-202606",
        "property_id": "P-130",
        "property_name": "Comfort Hotel Lyon",
        "chain": "Choice",
        "bid_rate": 240.25,
        "currency": "EUR",
        "rate_includes": "Wifi only",
        "allotment_offered": 21,
        "transfer_minutes": 19,
        "crew_suitable": 1,
        "received_at": "2026-06-14",
        "status": "shortlisted",
        "score": 91.58,
        "note": null
      },
      {
        "bid_id": "BID-21",
        "rfp_id": "RFP-202606",
        "property_id": "P-129",
        "property_name": "NH Lyon Airport",
        "chain": "NH",
        "bid_rate": 258.25,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi",
        "allotment_offered": 23,
        "transfer_minutes": 50,
        "crew_suitable": 1,
        "received_at": "2026-06-13",
        "status": "shortlisted",
        "score": 77.34,
        "note": null
      },
      {
        "bid_id": "BID-20",
        "rfp_id": "RFP-202606",
        "property_id": "P-130",
        "property_name": "Comfort Hotel Lyon",
        "chain": "Choice",
        "bid_rate": 271.8,
        "currency": "EUR",
        "rate_includes": "Wifi only",
        "allotment_offered": 18,
        "transfer_minutes": 46,
        "crew_suitable": 1,
        "received_at": "2026-06-12",
        "status": "rejected",
        "score": 67.75,
        "note": null
      },
      {
        "bid_id": "BID-19",
        "rfp_id": "RFP-202606",
        "property_id": "P-129",
        "property_name": "NH Lyon Airport",
        "chain": "NH",
        "bid_rate": 293.63,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi, taxes",
        "allotment_offered": 7,
        "transfer_minutes": 44,
        "crew_suitable": 1,
        "received_at": "2026-06-11",
        "status": "rejected",
        "score": 84.82,
        "note": null
      }
    ],
    "RFP-202607": [
      {
        "bid_id": "BID-23",
        "rfp_id": "RFP-202607",
        "property_id": "P-115",
        "property_name": "Radisson Blu Stansted",
        "chain": "Radisson",
        "bid_rate": 358.24,
        "currency": "EUR",
        "rate_includes": "Wifi only",
        "allotment_offered": 19,
        "transfer_minutes": 34,
        "crew_suitable": 1,
        "received_at": "2026-07-11",
        "status": "awarded",
        "score": 60.7,
        "note": "Awarded — best all-in against transfer time"
      },
      {
        "bid_id": "BID-24",
        "rfp_id": "RFP-202607",
        "property_id": "P-116",
        "property_name": "Hampton by Hilton Stansted",
        "chain": "Hilton",
        "bid_rate": 363.81,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi",
        "allotment_offered": 11,
        "transfer_minutes": 33,
        "crew_suitable": 1,
        "received_at": "2026-07-12",
        "status": "rejected",
        "score": 78.2,
        "note": null
      }
    ],
    "RFP-202608": [
      {
        "bid_id": "BID-26",
        "rfp_id": "RFP-202608",
        "property_id": "P-114",
        "property_name": "Ibis Birmingham Airport",
        "chain": "Accor",
        "bid_rate": 299.65,
        "currency": "EUR",
        "rate_includes": "Wifi only",
        "allotment_offered": 9,
        "transfer_minutes": 31,
        "crew_suitable": 1,
        "received_at": "2026-08-12",
        "status": "rejected",
        "score": 88.7,
        "note": null
      },
      {
        "bid_id": "BID-25",
        "rfp_id": "RFP-202608",
        "property_id": "P-113",
        "property_name": "Novotel Birmingham Airport",
        "chain": "Accor",
        "bid_rate": 300.86,
        "currency": "EUR",
        "rate_includes": "Wifi only",
        "allotment_offered": 5,
        "transfer_minutes": 32,
        "crew_suitable": 1,
        "received_at": "2026-08-11",
        "status": "awarded",
        "score": 90.27,
        "note": "Awarded — best all-in against transfer time"
      },
      {
        "bid_id": "BID-28",
        "rfp_id": "RFP-202608",
        "property_id": "P-114",
        "property_name": "Ibis Birmingham Airport",
        "chain": "Accor",
        "bid_rate": 308.45,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi, taxes",
        "allotment_offered": 17,
        "transfer_minutes": 8,
        "crew_suitable": 1,
        "received_at": "2026-08-14",
        "status": "rejected",
        "score": 92.82,
        "note": null
      },
      {
        "bid_id": "BID-27",
        "rfp_id": "RFP-202608",
        "property_id": "P-113",
        "property_name": "Novotel Birmingham Airport",
        "chain": "Accor",
        "bid_rate": 311.09,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi, taxes, parking",
        "allotment_offered": 23,
        "transfer_minutes": 51,
        "crew_suitable": 1,
        "received_at": "2026-08-13",
        "status": "rejected",
        "score": 87.44,
        "note": null
      }
    ],
    "RFP-202609": [
      {
        "bid_id": "BID-33",
        "rfp_id": "RFP-202609",
        "property_id": "P-124",
        "property_name": "Protea OR Tambo",
        "chain": "Marriott",
        "bid_rate": 224.78,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi, taxes",
        "allotment_offered": 8,
        "transfer_minutes": 30,
        "crew_suitable": 0,
        "received_at": "2026-01-15",
        "status": "shortlisted",
        "score": 81.57,
        "note": null
      },
      {
        "bid_id": "BID-30",
        "rfp_id": "RFP-202609",
        "property_id": "P-125",
        "property_name": "InterContinental OR Tambo",
        "chain": "IHG",
        "bid_rate": 250.77,
        "currency": "EUR",
        "rate_includes": "Wifi only",
        "allotment_offered": 19,
        "transfer_minutes": 35,
        "crew_suitable": 0,
        "received_at": "2026-01-12",
        "status": "rejected",
        "score": 58.4,
        "note": null
      },
      {
        "bid_id": "BID-32",
        "rfp_id": "RFP-202609",
        "property_id": "P-125",
        "property_name": "InterContinental OR Tambo",
        "chain": "IHG",
        "bid_rate": 257.49,
        "currency": "EUR",
        "rate_includes": "Wifi only",
        "allotment_offered": 20,
        "transfer_minutes": 21,
        "crew_suitable": 1,
        "received_at": "2026-01-14",
        "status": "rejected",
        "score": 58.99,
        "note": null
      },
      {
        "bid_id": "BID-31",
        "rfp_id": "RFP-202609",
        "property_id": "P-124",
        "property_name": "Protea OR Tambo",
        "chain": "Marriott",
        "bid_rate": 273.46,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi",
        "allotment_offered": 26,
        "transfer_minutes": 21,
        "crew_suitable": 1,
        "received_at": "2026-01-13",
        "status": "rejected",
        "score": 63.99,
        "note": null
      },
      {
        "bid_id": "BID-29",
        "rfp_id": "RFP-202609",
        "property_id": "P-124",
        "property_name": "Protea OR Tambo",
        "chain": "Marriott",
        "bid_rate": 282.28,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi, taxes",
        "allotment_offered": 25,
        "transfer_minutes": 11,
        "crew_suitable": 1,
        "received_at": "2026-01-11",
        "status": "rejected",
        "score": 91.77,
        "note": null
      }
    ],
    "RFP-202610": [
      {
        "bid_id": "BID-34",
        "rfp_id": "RFP-202610",
        "property_id": "P-133",
        "property_name": "Pullman Toulouse Airport",
        "chain": "Accor",
        "bid_rate": 246.59,
        "currency": "EUR",
        "rate_includes": "Wifi only",
        "allotment_offered": 12,
        "transfer_minutes": 25,
        "crew_suitable": 1,
        "received_at": "2026-02-11",
        "status": "shortlisted",
        "score": 57.55,
        "note": null
      },
      {
        "bid_id": "BID-35",
        "rfp_id": "RFP-202610",
        "property_id": "P-134",
        "property_name": "Ibis Toulouse Blagnac",
        "chain": "Accor",
        "bid_rate": 251.66,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi, taxes, parking",
        "allotment_offered": 21,
        "transfer_minutes": 45,
        "crew_suitable": 1,
        "received_at": "2026-02-12",
        "status": "shortlisted",
        "score": 90.67,
        "note": null
      },
      {
        "bid_id": "BID-37",
        "rfp_id": "RFP-202610",
        "property_id": "P-134",
        "property_name": "Ibis Toulouse Blagnac",
        "chain": "Accor",
        "bid_rate": 262.18,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi, taxes",
        "allotment_offered": 26,
        "transfer_minutes": 34,
        "crew_suitable": 1,
        "received_at": "2026-02-14",
        "status": "rejected",
        "score": 60.35,
        "note": null
      },
      {
        "bid_id": "BID-36",
        "rfp_id": "RFP-202610",
        "property_id": "P-133",
        "property_name": "Pullman Toulouse Airport",
        "chain": "Accor",
        "bid_rate": 264.96,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi",
        "allotment_offered": 14,
        "transfer_minutes": 41,
        "crew_suitable": 1,
        "received_at": "2026-02-13",
        "status": "rejected",
        "score": 76.45,
        "note": null
      }
    ],
    "RFP-202611": [
      {
        "bid_id": "BID-40",
        "rfp_id": "RFP-202611",
        "property_id": "P-131",
        "property_name": "Best Western Marseille Airport",
        "chain": "BWH",
        "bid_rate": 225.24,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi, taxes, parking",
        "allotment_offered": 10,
        "transfer_minutes": 52,
        "crew_suitable": 1,
        "received_at": "2026-03-13",
        "status": "shortlisted",
        "score": 57.15,
        "note": null
      },
      {
        "bid_id": "BID-38",
        "rfp_id": "RFP-202611",
        "property_id": "P-131",
        "property_name": "Best Western Marseille Airport",
        "chain": "BWH",
        "bid_rate": 252.31,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi",
        "allotment_offered": 5,
        "transfer_minutes": 35,
        "crew_suitable": 0,
        "received_at": "2026-03-11",
        "status": "rejected",
        "score": 88.72,
        "note": null
      },
      {
        "bid_id": "BID-39",
        "rfp_id": "RFP-202611",
        "property_id": "P-132",
        "property_name": "Holiday Inn Marseille",
        "chain": "IHG",
        "bid_rate": 269.33,
        "currency": "EUR",
        "rate_includes": "Wifi only",
        "allotment_offered": 21,
        "transfer_minutes": 41,
        "crew_suitable": 1,
        "received_at": "2026-03-12",
        "status": "rejected",
        "score": 56.43,
        "note": null
      }
    ],
    "RFP-202612": [
      {
        "bid_id": "BID-44",
        "rfp_id": "RFP-202612",
        "property_id": "P-104",
        "property_name": "Hilton East Midlands",
        "chain": "Hilton",
        "bid_rate": 288.42,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi, taxes, parking",
        "allotment_offered": 5,
        "transfer_minutes": 28,
        "crew_suitable": 1,
        "received_at": "2026-04-14",
        "status": "shortlisted",
        "score": 88.05,
        "note": null
      },
      {
        "bid_id": "BID-42",
        "rfp_id": "RFP-202612",
        "property_id": "P-105",
        "property_name": "Holiday Inn Castle Donington",
        "chain": "IHG",
        "bid_rate": 298.4,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi, taxes, parking",
        "allotment_offered": 14,
        "transfer_minutes": 10,
        "crew_suitable": 1,
        "received_at": "2026-04-12",
        "status": "shortlisted",
        "score": 66.76,
        "note": null
      },
      {
        "bid_id": "BID-41",
        "rfp_id": "RFP-202612",
        "property_id": "P-104",
        "property_name": "Hilton East Midlands",
        "chain": "Hilton",
        "bid_rate": 316.94,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi",
        "allotment_offered": 11,
        "transfer_minutes": 52,
        "crew_suitable": 1,
        "received_at": "2026-04-11",
        "status": "rejected",
        "score": 70.53,
        "note": null
      },
      {
        "bid_id": "BID-43",
        "rfp_id": "RFP-202612",
        "property_id": "P-106",
        "property_name": "Premier Inn Kegworth",
        "chain": "Whitbread",
        "bid_rate": 336.16,
        "currency": "EUR",
        "rate_includes": "Breakfast, wifi",
        "allotment_offered": 21,
        "transfer_minutes": 10,
        "crew_suitable": 1,
        "received_at": "2026-04-13",
        "status": "rejected",
        "score": 68.71,
        "note": null
      }
    ]
  },
  "renewals": [
    {
      "kind": "hotel",
      "id": "P-102",
      "name": "Maldron Hotel Dublin Airport",
      "station": "DUB",
      "contract_end": "2026-10-31",
      "rate": 285.07,
      "status": "expiring"
    },
    {
      "kind": "hotel",
      "id": "P-105",
      "name": "Holiday Inn Castle Donington",
      "station": "EMA",
      "contract_end": "2026-10-31",
      "rate": 320.85,
      "status": "expiring"
    },
    {
      "kind": "hotel",
      "id": "P-108",
      "name": "Leonardo Hotel Koln",
      "station": "CGN",
      "contract_end": "2026-10-31",
      "rate": 292.91,
      "status": "expiring"
    },
    {
      "kind": "hotel",
      "id": "P-111",
      "name": "Ibis Liege Centre",
      "station": "LGG",
      "contract_end": "2026-10-31",
      "rate": 297.91,
      "status": "expiring"
    },
    {
      "kind": "hotel",
      "id": "P-114",
      "name": "Ibis Birmingham Airport",
      "station": "BHX",
      "contract_end": "2026-10-31",
      "rate": 302.99,
      "status": "expiring"
    },
    {
      "kind": "hotel",
      "id": "P-116",
      "name": "Hampton by Hilton Stansted",
      "station": "STN",
      "contract_end": "2026-10-31",
      "rate": 328.32,
      "status": "expiring"
    },
    {
      "kind": "hotel",
      "id": "P-118",
      "name": "NH Brussels Airport",
      "station": "BRU",
      "contract_end": "2026-10-31",
      "rate": 354.09,
      "status": "expiring"
    },
    {
      "kind": "hotel",
      "id": "P-121",
      "name": "Hong Kong SkyCity Marriott",
      "station": "HKG",
      "contract_end": "2026-10-31",
      "rate": 321.14,
      "status": "expiring"
    },
    {
      "kind": "hotel",
      "id": "P-123",
      "name": "Le Meridien Dubai",
      "station": "DXB",
      "contract_end": "2026-10-31",
      "rate": 317.03,
      "status": "expiring"
    },
    {
      "kind": "hotel",
      "id": "P-125",
      "name": "InterContinental OR Tambo",
      "station": "JNB",
      "contract_end": "2026-10-31",
      "rate": 258.82,
      "status": "expiring"
    },
    {
      "kind": "hotel",
      "id": "P-127",
      "name": "Pullman Paris CDG",
      "station": "CDG",
      "contract_end": "2026-10-31",
      "rate": 318.4,
      "status": "expiring"
    },
    {
      "kind": "hotel",
      "id": "P-130",
      "name": "Comfort Hotel Lyon",
      "station": "LYS",
      "contract_end": "2026-10-31",
      "rate": 298.09,
      "status": "expiring"
    },
    {
      "kind": "hotel",
      "id": "P-132",
      "name": "Holiday Inn Marseille",
      "station": "MRS",
      "contract_end": "2026-10-31",
      "rate": 286.23,
      "status": "expiring"
    },
    {
      "kind": "hotel",
      "id": "P-134",
      "name": "Ibis Toulouse Blagnac",
      "station": "TLS",
      "contract_end": "2026-10-31",
      "rate": 291.64,
      "status": "expiring"
    },
    {
      "kind": "hotel",
      "id": "P-136",
      "name": "Novotel Madrid Barajas",
      "station": "MAD",
      "contract_end": "2026-10-31",
      "rate": 298.02,
      "status": "expiring"
    },
    {
      "kind": "transport",
      "id": "TP-100",
      "name": "Dublin Executive Cars",
      "station": "DUB",
      "contract_end": "2026-11-30",
      "rate": 148.26,
      "status": "expiring"
    },
    {
      "kind": "transport",
      "id": "TP-103",
      "name": "Liège Crew Transfers",
      "station": "LGG",
      "contract_end": "2026-11-30",
      "rate": 99.94,
      "status": "expiring"
    },
    {
      "kind": "transport",
      "id": "TP-106",
      "name": "Brussels Crew Transfers",
      "station": "BRU",
      "contract_end": "2026-11-30",
      "rate": 52.02,
      "status": "expiring"
    },
    {
      "kind": "transport",
      "id": "TP-112",
      "name": "Marseille Aviation Ground",
      "station": "MRS",
      "contract_end": "2026-11-30",
      "rate": 117.07,
      "status": "expiring"
    },
    {
      "kind": "hotel",
      "id": "P-101",
      "name": "Clayton Hotel Dublin Airport",
      "station": "DUB",
      "contract_end": "2027-03-31",
      "rate": 259.01,
      "status": "suspended"
    },
    {
      "kind": "hotel",
      "id": "P-104",
      "name": "Hilton East Midlands",
      "station": "EMA",
      "contract_end": "2027-03-31",
      "rate": 319.58,
      "status": "active"
    },
    {
      "kind": "hotel",
      "id": "P-107",
      "name": "Ibis Koln Messe",
      "station": "CGN",
      "contract_end": "2027-03-31",
      "rate": 274.89,
      "status": "active"
    },
    {
      "kind": "hotel",
      "id": "P-110",
      "name": "Van der Valk Liege",
      "station": "LGG",
      "contract_end": "2027-03-31",
      "rate": 282.73,
      "status": "active"
    },
    {
      "kind": "hotel",
      "id": "P-113",
      "name": "Novotel Birmingham Airport",
      "station": "BHX",
      "contract_end": "2027-03-31",
      "rate": 300.89,
      "status": "active"
    },
    {
      "kind": "hotel",
      "id": "P-115",
      "name": "Radisson Blu Stansted",
      "station": "STN",
      "contract_end": "2027-03-31",
      "rate": 343.84,
      "status": "active"
    },
    {
      "kind": "hotel",
      "id": "P-117",
      "name": "Thon Hotel EU",
      "station": "BRU",
      "contract_end": "2027-03-31",
      "rate": 350.52,
      "status": "active"
    },
    {
      "kind": "hotel",
      "id": "P-120",
      "name": "Regal Airport Hotel",
      "station": "HKG",
      "contract_end": "2027-03-31",
      "rate": 320.08,
      "status": "active"
    },
    {
      "kind": "hotel",
      "id": "P-122",
      "name": "Millennium Airport Hotel Dubai",
      "station": "DXB",
      "contract_end": "2027-03-31",
      "rate": 311.79,
      "status": "active"
    },
    {
      "kind": "hotel",
      "id": "P-124",
      "name": "Protea OR Tambo",
      "station": "JNB",
      "contract_end": "2027-03-31",
      "rate": 248.18,
      "status": "suspended"
    },
    {
      "kind": "hotel",
      "id": "P-126",
      "name": "Novotel Paris CDG",
      "station": "CDG",
      "contract_end": "2027-03-31",
      "rate": 319.12,
      "status": "active"
    },
    {
      "kind": "hotel",
      "id": "P-129",
      "name": "NH Lyon Airport",
      "station": "LYS",
      "contract_end": "2027-03-31",
      "rate": 289.89,
      "status": "active"
    },
    {
      "kind": "hotel",
      "id": "P-131",
      "name": "Best Western Marseille Airport",
      "station": "MRS",
      "contract_end": "2027-03-31",
      "rate": 293.63,
      "status": "active"
    },
    {
      "kind": "hotel",
      "id": "P-133",
      "name": "Pullman Toulouse Airport",
      "station": "TLS",
      "contract_end": "2027-03-31",
      "rate": 269.25,
      "status": "active"
    },
    {
      "kind": "hotel",
      "id": "P-135",
      "name": "Melia Barajas",
      "station": "MAD",
      "contract_end": "2027-03-31",
      "rate": 316.44,
      "status": "active"
    },
    {
      "kind": "transport",
      "id": "TP-101",
      "name": "East Midlands Airport Coaches",
      "station": "EMA",
      "contract_end": "2027-06-30",
      "rate": 142.64,
      "status": "active"
    },
    {
      "kind": "transport",
      "id": "TP-102",
      "name": "Cologne Aviation Ground",
      "station": "CGN",
      "contract_end": "2027-06-30",
      "rate": 109.16,
      "status": "active"
    },
    {
      "kind": "transport",
      "id": "TP-105",
      "name": "London Stansted Aviation Ground",
      "station": "STN",
      "contract_end": "2027-06-30",
      "rate": 150.66,
      "status": "active"
    },
    {
      "kind": "transport",
      "id": "TP-107",
      "name": "Hong Kong Airport Coaches",
      "station": "HKG",
      "contract_end": "2027-06-30",
      "rate": 137.31,
      "status": "active"
    },
    {
      "kind": "transport",
      "id": "TP-108",
      "name": "Dubai Crew Transfers",
      "station": "DXB",
      "contract_end": "2027-06-30",
      "rate": 155.9,
      "status": "active"
    },
    {
      "kind": "transport",
      "id": "TP-110",
      "name": "Paris CDG Executive Cars",
      "station": "CDG",
      "contract_end": "2027-06-30",
      "rate": 97.49,
      "status": "active"
    },
    {
      "kind": "transport",
      "id": "TP-111",
      "name": "Lyon Executive Cars",
      "station": "LYS",
      "contract_end": "2027-06-30",
      "rate": 74.54,
      "status": "active"
    },
    {
      "kind": "transport",
      "id": "TP-113",
      "name": "Toulouse Executive Cars",
      "station": "TLS",
      "contract_end": "2027-06-30",
      "rate": 156.79,
      "status": "active"
    }
  ]
}