TY - JOUR A1 - Kellner, Florian A1 - Otto, Andreas T1 - Allocating CO2 emissions to shipments in road freight transportation JF - Journal of Management Control N2 - Logistic activity, in particular transportation, produces green house gases (GHG). For different purposes GHG need to be allocated to objects. This paper studies how to allocate the GHG volume of a transportation process (delivery tour) to the single shipments moved by the process. First, it identifies classes of generic allocation schemes and presents 15 allocation methods. Second, since the majority of these methods has not been designed for allocating GHG, we apply and compare them in the short distance transport context within a numerical example. The aim is to study how the schemes perform according to criteria. We suggest using causality, efficiency, empty core robustness, symmetry, individual rationality, coalition stability, ease of application, and set robustness as appraisal criteria and attempt to mainstream the discussion by recommending selected allocation methods. Y1 - 2012 U6 - https://doi.org/10.1007/s00187-011-0143-6 VL - 22 IS - 4 SP - 451 EP - 479 PB - Springer ER - TY - CHAP A1 - Lukesch, Maximilian A1 - Kellner, Florian ED - Pradel, Uwe-Heiner T1 - Geoinformationssysteme für Logistikmanager: Eine praxisorientierte Einführung am Beispiel der Freeware QGIS T2 - Praxishandbuch Logistik Y1 - 2019 PB - Wolters Kluwer CY - Köln ER - TY - INPR A1 - Kellner, Florian A1 - Utz, Sebastian T1 - Sustainability in Supplier Selection and Order Allocation: Combining Integer Variables With Markowitz Portfolio Theory T2 - SSRN Electronic Journal N2 - This research presents a decision support methodology for the multi-criteria supplier selection and order allocation problem. The proposed approach supports purchasing managers in assembling mid-term supplier portfolios while making them aware of the trade-offs between the supplier sustainability, the purchasing costs, and the overall supply risk. First, we propose a multi-objective optimization model with three objectives: to maximize the supplier sustainability, to select the supplier portfolio with the lowest purchasing costs, and to minimize the supply risk. Our model extends existing mathematical approaches that follow the portfolio theory fathered by H. Markowitz by integrating the aspect ‘risk’ into the supplier selection problem. Secondly, since we allow for integer variables in our model — in contrast to the classical Markowitz portfolio theory — we use the ε-constraint method to visualize the efficient surface. The possibility of considering the non-dominated set of supplier portfolios is advantageous for purchasing managers as they gain a picture of the different optimal supplier portfolios and are able to analyze the trade-offs between the different purchasing goals before making a decision. Finally, we illustrate the applicability of the proposed methodology in a real-world supplier selection and order allocation case from the automotive industry. In the example case, we identify 1,754 optimal supplier portfolios that may be assembled based on the eight available suppliers. Our analyses show that each optimal portfolio consists of two suppliers, with one specific supplier being included in each portfolio. Furthermore, four suppliers are not part of any optimal solution. Y1 - 2018 U6 - https://doi.org/10.2139/ssrn.3296016 N1 - Erschienen bei Springer im Journal of Cleaner Production 214, 2025: https://doi.org/10.1016/j.jclepro.2018.12.315 PB - SSRN ER - TY - INPR A1 - Kellner, Florian T1 - Generating Greenhouse Gas Cutting Incentives when Allocating Carbon Dioxide Emissions to Shipments in Road Freight Transportation T2 - SSRN Electronic Journal N2 - Road freight transportation accounts for a great share of the anthropogenic greenhouse gas (GHG) emissions. In order to provide a common methodology for carbon accounting related to transport activities, the European Committee for Standardization has published the European Norm EN-16258. Unfortunately, EN-16258 contains in its current version some gaps and ambiguities and leaves room for interpretation, which makes the comparison of the environmental performance of different logistics networks still difficult and hinders the identification of best practices. This research aims to overcome the ambiguities of EN-16258 concerning the allocation of GHG emissions to shipments in road freight transportation. In detail, we apply concepts of the cooperative game theory to identify among all allocation units specified by EN-16258 the most meaningful one. In doing so, we continue previous research projects that analyzed two important aspects of the EN-16258 allocation rules: accuracy and fairness. This study provides further insights into this allocation problem by investigating the incentive power of the different allocation schemes to opt for the GHG minimal way of running a road freight transport network. First, we complement the list of transport scenarios introduced by the prior research projects and present two novel transport scenarios. Second, we carry out a series of numerical experiments to compare the performance of the EN-16258 allocation rules with respect to accuracy, fairness, and the GHG minimizing incentive. Across all aspects, and taking the findings of the prior research projects into account, we conclude that the distance-based allocation rule is the most meaningful one. Y1 - 2020 U6 - https://doi.org/10.2139/ssrn.3518014 N1 - Erschienen bei Springer im OR-Spektrum 44, 2020(3): https://doi.org/10.1007/s00291-022-00675-y ER - TY - JOUR A1 - Kunkler, Jan A1 - Kellner, Florian T1 - Sustainable City Evaluation Using the Database for Estimation of Road Network Performance JF - Sustainability N2 - This article introduces the Database for Estimation of Road Network Performance (DERNP) to enable wide-scale estimation of relevant Road Network Performance (RNP) factors for major German cities. The methodology behind DERNP is based on a randomized route sampling procedure that utilizes the Worldwide Harmonized Light Vehicles Test Procedure (WLTP) in combination with the tile-based HERE Maps Traffic API v7 and a digital elevation model provided by the European Union’s Earth Observation Programme Copernicus to generate a large set of independent and realistic routes throughout OpenStreetMap road networks. By evaluating these routes using the PHEMLight5 framework, a comprehensive list of RNP parameters is estimated and translated into polynomial regression models for general usage. The applicability of these estimations is demonstrated based on a case study of four major German cities. This case study considers network characteristics in terms of detours, infrastructure, traffic congestion, fuel consumption, and CO2 emissions. Our results show that DERNP and its underlying randomized route sampling methodology overcomes major limitations of previous wide-scale RNP approaches, enabling efficient, easy-to-use, and region-specific RNP comparisons. Y1 - 2023 U6 - https://doi.org/10.3390/su15010733 VL - 15 IS - 1 PB - MDPI ER - TY - GEN A1 - Lukesch, Maximilian A1 - Kellner, Florian T1 - Business Analytics and Big Data: Production, Logistics and Supply Chain Management T2 - 1. Regensburger Big Data Day, 30 Oktober 2018, Regensburg N2 - Das Poster befasst sich mit dem Beitrag der Auswertung von "Big Data" für die Anwendungsbereiche der Produktion, der Logistik und des Supply Chain Management. Im Kern steht dabei die Anwendung von Business Analytics Methoden und die Umsetzung der Analytics-Ergebnisse in anwendungsorientierte Use Cases. Als Beispiele werden besprochen: Predictive Maintenance, Supply Chain Monitoring, Supply Chain Risk Management, Demand Forecasting. Y1 - 2018 U6 - https://doi.org/10.5283/epub.37889 ER - TY - BOOK A1 - Kellner, Florian A1 - Brabänder, Christian T1 - VBA mit Excel : Einführung für Betriebswirte N2 - Dieses Buch bietet eine anwendungsorientierte Einführung in die Programmierung mit Visual Basic for Applications (VBA) in Microsoft Excel. Es ermöglicht auch Einsteigern die selbstständige Lösung kleiner bis mittelgroßer Programmieraufgaben aus dem betriebswirtschaftlichen Alltag. Der Schwierigkeitsgrad der Inhalte ist überwiegend einfach gehalten, sodass Nutzer, die bereits grundlegende Tätigkeiten in MS Excel beherrschen, sich nach ihren jeweiligen Anforderungen entsprechend fortbilden können. Zahlreiche Praxisbeispiele und Übungen, die auf einem Windows-Betriebssystem entwickelt und getestet wurden, unterstützen das Lernen Schritt für Schritt und zeigen, wie hilfreich VBA durch Automatisierung und Individualisierung in jedem Büro sein kann. Y1 - 2019 SN - 9783662597408 U6 - https://doi.org/10.1007/978-3-662-59740-8 PB - Springer Gabler CY - Berlin ER - TY - BOOK A1 - Lukesch, Maximilian A1 - Kellner, Florian T1 - Übungsbuch Produktionswirtschaft : Planung, Steuerung und Industrie 4.0 N2 - Dieses Buch bietet Studierenden mehr als 70 Übungsaufgaben und drei Fallstudien inklusive ausführlicher Lösungen zu ausgewählten Themen der Produktionswirtschaft und Industrie 4.0. Jedes Kapitel enthält eine kurze Einleitung sowie zu erreichende Lernziele. Querverweise auf das Lehrbuch „Produktionswirtschaft“ von Kellner/Lienland/Lukesch erleichtern das Selbststudium und ermöglichen eine optimale Prüfungsvorbereitung. In der 2. Auflage wurden umfangreiche Überarbeitungen hinsichtlich Sprache und Aufbau von Aufgaben, Lösungswegen und Abbildungen vorgenommen sowie zahlreiche neue Aufgaben ergänzt. Y1 - 2020 SN - 978-3-662-62086-1 U6 - https://doi.org/10.1007/978-3-662-62087-8 PB - Springer Gabler CY - Berlin ET - 2., überarbeitete und erweiterte Auflage ER - TY - GEN A1 - Kellner, Florian A1 - Utz, Sebastian T1 - Using Inverse Optimization to Discover Sustainability Priorities in Purchasing Decisions T2 - International Conference on Operations Research 2023 // 29. Aug. - 01. Sep. 2023, Hamburg Y1 - 2023 ER - TY - GEN A1 - Kellner, Florian T1 - Multi-objective supplier portfolio configuration under supply risk and sustainability considerations T2 - International Conference on Operations Research (OR2017), September 2017, Berlin Y1 - 2017 ER - TY - CHAP A1 - Kellner, Florian A1 - Otto, Andreas A1 - Busch, Andreas ED - Ivanov, Dimitri ED - Sokolov, Boris ED - Käschel, Joachim T1 - Distribution Networks - Rigid Investments In Dynamic Environments T2 - Flexibility and adaptability of global supply chains - Proceedings of the 7th German-Russian Logistics Workshop (DR-LOG 2012) Y1 - 2012 SP - 103 EP - 111 CY - Sankt Petersburg ER - TY - GEN A1 - Kellner, Florian T1 - Visual decision support for the multi-objective supplier selection problem T2 - International Conference on Multiple Objective Programming and Goal Programming (MOPGP), 30-31 October 2017, Metz, France Y1 - 2017 ER - TY - GEN A1 - Kellner, Florian A1 - Utz, Sebastian T1 - Exploring Sustainability Priorities in Purchasing Decisions Based on Inverse Optimization T2 - NAMA Conference 2023, 28.-29. Sep. 2023, Oldenburg Y1 - 2023 ER -