Solving Classic Discrete Facility Location Problems Using Excel Spreadsheets
نویسندگان
چکیده
منابع مشابه
Location problems solving by spreadsheets
Location problems have been the focus of considerable attention both in research and practice for many years. Numerous extensions have been described to broaden its appeal and enhance its applicability. This study proposes a spreadsheet approach for three well-known facility location problems, the p-median problem (PMP), capacitated p-median (CPMP), and maximal covering location problem (MCLP)....
متن کاملSolving Constrained Two-facility Location Problems
A general approach to optimally solve multiple facility location problems based on the “Big Triangle Small Triangle” approach to solving single facility problems is proposed. The proposed procedure is especially effective when the solution is constrained to a given polygon such as the convex hull of demand points. The procedure is tested on the two facilities Weber problem with attraction and r...
متن کاملA Survey of Discrete Facility Location Problems
Facility location is a complex real-world problem which needs a strategic management decision. This paper provides a general review on studies, efforts and developments in Facility Location Problems which are classical optimization problems having a wide-spread applications in various areas such as transportation, distribution, production, supply chain decisions and telecommunication. Our goal ...
متن کاملSolving Configuration Problems in Excel
This work shows how Excel can be leveraged to tackle configuration problems. We demonstrate this by presenting the full development cycle of a PC-configurator prototype. We articulate our demonstration by exemplifying several important points. First, Excel can be used to import raw products and services data. Second, these data can be used by a constraint modelling to correctly instantiate a se...
متن کاملSolving Sequencing Problems in Spreadsheets
Suppose that we wish to solve such sequencing problems as the flow shop scheduling problem or the traveling salesperson problem. This paper reports computational experiments that shed light on how large a problem we might be able to solve, assuming that our work is done using a spreadsheet-based approach and the conventional hardware and software available to today's undergraduate student: a la...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: INFORMS Transactions on Education
سال: 2021
ISSN: 1532-0545,1532-0545
DOI: 10.1287/ited.2021.0245