{
  "abstract": "We developed a staff rostering system for complex employment and staffing requirements at a municipal water utility and deployed it in routine operations at the Water Purification Office of Suita City Waterworks Bureau, Japan, in May 2026. We estimated that preparing a monthly roster took approximately 2-3 h after deployment, compared with 12-18 h previously. The system represents roster states, effective staffing and office assignments using binary and auxiliary integer variables and optimises the entire planning horizon. When the normal model yields no feasible solution, a second stage attempts to generate a reference roster by penalising weekly day-off shortages while retaining the other hard constraints. Outputs identify shortages and meeting-date changes applied before solving. Computational experiments used operational inputs for 14 staff over 245 days. The baseline was solved to optimality in approximately 177 s; a modified meeting-day scenario produced a reference roster with five staff-days of shortage. Independent monthly solving without history produced 16 staff-week cases of excess days off across two month-boundary weeks. This case demonstrates the practical value of optimisation-based decision support for staff rostering in municipal water utilities by showing how mathematical optimisation can be integrated into roster preparation and checking workflows with reduced preparation time.",
  "abstract_shown": true,
  "affiliations": [],
  "article_type": null,
  "arxiv": "2610.14674",
  "author_total": 3,
  "authors": [
    {
      "name": "Takaaki Kobayashi"
    },
    {
      "name": "Satoshi Matsumura"
    },
    {
      "name": "Satoko Moriguchi"
    }
  ],
  "bibtex": "https://research.draconitic.com/paper/7xet1q1v8ayhx.bib",
  "cited_by": 0,
  "doi": "10.48550/arxiv.2610.14674",
  "fulltext_url": null,
  "id": "7xet1q1v8ayhx",
  "issns": [],
  "landing_url": "https://arxiv.org/abs/2610.14674",
  "language": null,
  "licence": "LicenseRef-arXiv-nonexclusive-1.0",
  "licence_label": "arXiv licence",
  "licence_source": "article",
  "licence_url": "http://arxiv.org/licenses/nonexclusive-distrib/1.0/",
  "metadata_licence": "CC0-1.0",
  "native_subjects": [
    [
      "arxiv",
      "math.OC"
    ],
    [
      "openalex",
      "1803|Scheduling and Timetabling Solutions"
    ]
  ],
  "openalex": "W7221754803",
  "pdf_url": "https://arxiv.org/pdf/2610.14674",
  "pmcid": null,
  "pmid": null,
  "published": "2026-10-10",
  "publisher": null,
  "ris": "https://research.draconitic.com/paper/7xet1q1v8ayhx.ris",
  "sources": [
    {
      "first_seen": "2026-10-30T12:29:15Z",
      "native_id": "2610.14674",
      "source": "arxiv",
      "url": "https://arxiv.org/abs/2610.14674"
    }
  ],
  "subjects": [
    {
      "field": "mathematics",
      "origin": "arxiv:math.OC",
      "subfield": "optimisation-control"
    }
  ],
  "title": "Development and operational deployment of a staff rostering system using mathematical optimisation in a municipal water utility",
  "title_text": "Development and operational deployment of a staff rostering system using mathematical optimisation in a municipal water utility",
  "type": "preprint",
  "updated_at": "2026-10-30T12:29:15Z",
  "url": "https://research.draconitic.com/paper/7xet1q1v8ayhx",
  "venue": "arXiv",
  "versions": []
}