Abstract

This paper introduces FLP Spreadsheet Solver, an open source spreadsheet based Decision Support System for Facility Location Problems. Structure of the spreadsheets, interface of the solver, and a Tabu Search algorithm implemented within the solver are described. An integer programming formulation of the underlying facility location problem is provided. Computational tests show that FLP Spreadsheet Solver can solve benchmark p-median and capacitated p-median instances to near optimality. The paper also includes a case study consisting of the application of FLP Spreadsheet Solver to a healthcare facility location problem.

Original languageEnglish
Article number113116
Pages (from-to)1-12
Number of pages12
JournalDecision Support Systems
Volume125
Early online date8 Aug 2019
DOIs
Publication statusPublished - 1 Oct 2019

Keywords

  • Facility location analysis
  • Health services
  • Open source
  • Spreadsheets

ASJC Scopus subject areas

  • Management Information Systems
  • Information Systems
  • Developmental and Educational Psychology
  • Arts and Humanities (miscellaneous)
  • Information Systems and Management

Cite this