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. KW - road network performance; urban sustainability; economic sustainability; traffic congestion; greenhouse gas emissions; data collection methods; navigation services Y1 - 2023 U6 - https://doi.org/10.3390/su15010733 VL - 15 IS - 1 SP - 733 ER - TY - BOOK A1 - Kellner, Florian A1 - Lienland, Bernhard A1 - Lukesch, Maximilian T1 - Produktionswirtschaft: Planung, Steuerung und Industrie 4.0 N2 - Dieses Buch bietet eine einsteigerfreundliche Einführung in die für industrielle Betriebe maßgebliche Aufgabe der Produktionswirtschaft. Im Zentrum steht dabei das operative Produktionsmanagement. Hierzu gehören die erfolgswirksame Bewirtschaftung der Produktionsfaktoren Mensch, Betriebsmittel und Material, der Einsatz von Information sowie die Planung und Steuerung der industriellen Produktion. Mithilfe zahlreicher Unternehmensbeispiele und Übungsaufgaben wird der Leser durch produktionswirtschaftliche Grundlagen sowie durch Ablauf und Inhalt zentraler Prozesse in der Industrie geleitet. Auch die aktuelle Diskussion um das Thema Industrie 4.0 und cyber-physische Produktionssysteme werden lesefreundlich und mit konkretem Anwendungsbezug präsentiert. Y1 - 2022 U6 - https://doi.org/10.1007/978-3-662-65803-1 PB - Springer Gabler CY - Berlin, Heidelberg ET - 3 ER - TY - JOUR A1 - Kraft, Sarah Katharina A1 - Kellner, Florian T1 - Can Blockchain Be a Basis to Ensure Transparency in an Agricultural Supply Chain? JF - Sustainability N2 - Many supply chains within developing countries lack transparency and are fraught with fraud, corruption, and a substantial number of intermediaries. For several decades, the cocoa sector has faced multiple social, economic, and environmental challenges, some of which include the issue of child labor and very low incomes for farmers, leading to poor living conditions. Blockchain technology has a high potential to reduce—or completely eradicate—some of these hurdles. In this article, we present a blockchain-based solution based on the open-source framework Hyperledger Fabric for the cocoa supply chain to promote transparency and reduce fraud. In doing so, we explicitly describe how farmers can be directly integrated into the whole blockchain solution considering the limited infrastructure, knowledge, and technologies available to them. Since about 70% of all cocoa worldwide is produced in West Africa, this case study uses the cocoa sector in Ghana as an example. KW - sustainability; cocoa; blockchain; supply chain; transparency Y1 - 2022 U6 - https://doi.org/10.3390/su14138044 VL - 14 IS - 13 SP - 8044 ER - TY - JOUR A1 - Kellner, Florian T1 - Generating greenhouse gas cutting incentives when allocating carbon dioxide emissions to shipments in road freight transportation JF - OR Spectrum 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 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 contributes to the identification of particularly meaningful principles for the allocation of GHG to shipments in road freight transportation by presenting an analytical framework for studying the performance of the EN-16258 allocation schemes with respect to accuracy, fairness, and the GHG minimizing incentive. In doing so, we continue previous studies 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 network. First, we complement the list of transport scenarios introduced in prior studies and present two novel scenarios. Second, we carry out a series of numerical experiments to compare the EN-16258 allocation rules with respect to accuracy, fairness, and the GHG minimizing incentive. We find that the results may differ significantly for the two scenarios, suggesting a case-by-case recommendation. This is particularly interesting because the first scenario confirms the results of the prior studies, while the second scenario rather contradicts them. KW - GHG allocation KW - Road freight transportation KW - Cooperative game theory KW - EN-16258 Y1 - 2022 U6 - https://doi.org/10.1007/s00291-022-00675-y VL - 44 SP - 833 EP - 874 ER - TY - CHAP A1 - Kellner, Florian A1 - Schröder, Nadine T1 - Location Planning & Analysis Using Uncertain Data T2 - 2021 International Conference on Decision Aid Sciences and Application (DASA) N2 - In today's big data era, a humongous amount of data are collected from various sources. In many cases, these data are incomplete, imprecise, and uncertain. An illustrative example is the OpenStreetMap project, where users all over the world contribute data on a more or less precise and complete level. This research shows whether these data are suited to support management decisions. A real-world example demonstrates the extent to which location decisions of a fast-food restaurant chain can be reproduced using techniques from the field of advanced analytics. The problem deals with classifying potential locations and comparing the predicted locations with the actual ones. The data used for this example are retrieved from the OpenStreetMap project. We find that the OpenStreetMap data are generally suitable for predicting location decisions. However, the choice of the data analytics technique is crucial. In our illustrative example case, boosted trees resulted in the best forecast, thereby outperforming neural networks, classic trees, and logit models. Y1 - 2022 U6 - https://doi.org/10.1109/DASA53625.2021.9682323 SP - 720 EP - 723 ER - TY - JOUR A1 - Kellner, Florian A1 - Lienland, Bernhard A1 - Utz, Sebastian T1 - A multi-criteria decision-making approach for assembling optimal powertrain technology portfolios in low GHG emission environments JF - Journal of Industrial Ecology N2 - Environmental regulations force car manufacturers to renew the powertrain technology portfolio offered to the customer to comply with greenhouse gas (GHG) emission targets. In turn, automotive companies face the task of identifying the “right” powertrain technology portfolio consisting of, for example, internal combustion engines and electric vehicles, because the selection of a particular powertrain technology portfolio affects different company targets simultaneously. What makes this decision even more challenging is that future market shares of the different technologies are uncertain. Our research presents a new decision-support approach for assembling optimal powertrain technology portfolios while making decision-makers aware of the trade-offs between the achievable profit, the achievable market share, the market share risk, and the GHG emissions generated by the selected vehicle fleet. The proposed approach combines “a posteriori” decision-making with multi-objective optimization. In an application case, we feed the outlooks of selected market studies into the proposed decision-support system. The result is a visualization and analysis of the current real-world decision-making problem faced by many automotive companies. Our findings indicate that for the proposed GHG restriction at work in 2030 in the European Union, no optimal powertrain technology portfolio with less than 35% of vehicles equipped with an electric motor exists. KW - automotive sector KW - decision-support system KW - industrial ecology KW - portfolio optimization KW - power-train technologies KW - technology selection Y1 - 2021 U6 - https://doi.org/10.1111/jiec.13148 VL - 25 IS - 6 SP - 1412 EP - 1429 ER - TY - JOUR A1 - Kunkler, Jan A1 - Braun, Maximilian A1 - Kellner, Florian T1 - Speed Limit Induced CO2 Reduction on Motorways: Enhancing Discussion Transparency through Data Enrichment of Road Networks JF - Sustainability N2 - Considering climate change, recent political debates often focus on measures to reduce CO2 emissions. One key component is the reduction of emissions produced by motorized vehicles. Since the amount of emission directly correlates to the velocity of a vehicle via energy consumption factors, a general speed limit is often proposed. This article presents a methodology to combine openly available topology data of road networks from OpenStreetMap (OSM) with pay-per-use API traffic data from TomTom to evaluate such measures transparently by analyzing historical real-world circumstances. From our exemplary case study of the German motorway network, we derive that most parts of the motorway network on average do not reach their maximum allowed speed throughout the day due to traffic, construction sites and general road utilization by network participants. Nonetheless our findings prove that the introduction of a speed limit of 120 km per hour on the German autobahn would restrict 50.74% of network flow kilometers for a CO2 reduction of 7.43% compared to the unrestricted state. KW - road network analysis; CO2 emissions; speed limits; traffic; navigation services Y1 - 2021 U6 - https://doi.org/10.3390/su13010395 VL - 13 IS - 1 SP - 395 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. KW - Produktion KW - Produktionswirtschaft Y1 - 2020 U6 - https://doi.org/10.1007/978-3-662-62087-8 PB - Springer Gabler CY - Berlin, Heidelberg ET - 2 ER - TY - JOUR A1 - Kellner, Florian T1 - Exploring the impact of urbanization on consumer goods distribution networks JF - Journal of Asian Business and Economic Studies N2 - Purpose Due to the growing percentage share of urban dwellers, the physical distribution of products faces altering conditions. This research explores the effects that urbanization has on the performance of a fast-moving consumer goods distribution network. A focus is set on changes in distribution cost, the cost-minimal network design, and greenhouse gas emissions. Design/methodology/approach The analyses are based on a quantitative distribution network model of an existing manufacturer of consumer goods. Findings The results indicate that the foreseen population shift will affect the network's economic and environmental performance. Effects are, among others, due to differences in the efficiency of supplying urban and nonurban regions. The combined effects of urbanization and the development of the population size will even more affect the network's performance. Originality/value Research dealing with distribution logistics and urbanization primarily focuses on city logistics. In this paper, the object of analysis is the entire distribution system. KW - Distribution network KW - Distribution logistics KW - Urbanization KW - Fast-moving consumer goods Y1 - 2021 U6 - https://doi.org/10.1108/JABES-12-2019-0127 VL - 28 IS - 2 SP - 101 EP - 120 ER - TY - BOOK A1 - Kellner, Florian A1 - Brabänder, Christian T1 - VBA mit Excel BT - 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 - 2020 U6 - https://doi.org/10.1007/978-3-662-59740-8 PB - Springer Gabler CY - Berlin, Heidelberg ER - TY - BOOK A1 - Kellner, Florian A1 - Lienland, Bernhard A1 - Lukesch, Maximilian T1 - Produktionswirtschaft: Planung, Steuerung und Industrie 4.0 Y1 - 2020 U6 - https://doi.org/10.1007/978-3-662-61446-4 PB - Springer Gabler CY - Berlin, Heidelberg ET - 2 ER - TY - CHAP A1 - Kellner, Florian A1 - Lienland, Bernhard A1 - Utz, Sebastian T1 - Optimal engine technology mix in a low carbon economy T2 - 2020 International Conference on Decision Aid Sciences and Application (DASA) N2 - Environmental regulations force automotive companies to modify the powertrain technology portfolio offered to the customer to comply with greenhouse gas (GHG) emission targets. Automotive companies, in turn, are faced with the decision of finding the right powertrain technology portfolio because the selection of a particular technology portfolio affects different company targets at the same time. What makes this decision even more interesting is the fact that future market shares of the different technologies are uncertain. With its numerous objectives, this challenge requires multi-criteria decision-making techniques to identify the optimal powertrain technology portfolio. The objective of this research is to present a new decision support approach for assembling optimal powertrain technology portfolios while making decision-makers aware of the trade-offs between the achievable market share, the market share risk, and the GHG emissions generated by the selected vehicle fleet. The proposed approach combines `a posteriori' decision-making, multi-objective optimization, and the Markowitz portfolio theory. In an application case, the outlooks of selected market studies are fed into the proposed decision support system. The result is a visualization and analysis of the current real-world decision-making problem faced by many automotive companies. Interesting findings of this research include that for the assumed GHG restrictions in place in 2030, there exists no optimal powertrain technology portfolio that is not composed of at least 20% of electric vehicles. Y1 - 2020 U6 - https://doi.org/10.1109/DASA51403.2020.9317094 SP - 95 EP - 98 ER - TY - CHAP A1 - Lukesch, Maximilian A1 - Kellner, Florian T1 - Geoinformationssysteme für Logistikmanager: Eine praxisorientierte Einführung am Beispiel der Freeware QGIS T2 - Praxishandbuch Logistik: Erfolgreiche Logistik in Industrie, Handel und Dienstleistungsunternehmen KW - Logistik KW - GIS KW - Geoinformationssysteme KW - Distributionslogistik KW - QGIS Y1 - 2019 SN - 978-3-87156-340-9 PB - Fachverlag Deutscher Wirtschaftsdienst CY - Köln ER - TY - JOUR A1 - Kellner, Florian A1 - Lienland, Bernhard A1 - Utz, Sebastian T1 - An a posteriori decision support methodology for solving the multi-criteria supplier selection problem JF - European Journal of Operational Research N2 - This research presents a novel, state-of-the-art methodology for solving a multi-criteria supplier selection problem considering risk and sustainability. It combines multi-objective optimization with the analytic network process to take into account sustainability requirements of a supplier portfolio configuration. To integrate ‘risk’ into the supplier selection problem, we develop a multi-objective optimization model based on the investment portfolio theory introduced by Markowitz. The proposed model is a non-standard portfolio selection problem with four objectives: (1) minimizing the purchasing costs, (2) selecting the supplier portfolio with the highest logistics service, (3) minimizing the supply risk, and (4) ordering as much as possible from those suppliers with outstanding sustainability performance. The optimization model, which has three linear and one quadratic objective function, is solved by an algorithm that analytically computes a set of efficient solutions and provides graphical decision support through a visualization of the complete and exactly-computed Pareto front (a posteriori approach). The possibility of computing all Pareto-optimal supplier portfolios is beneficial for decision makers as they can compare all optimal solutions at once, identify the trade-offs between the criteria, and study how the different objectives of supplier portfolio configuration may be balanced to finally choose the composition that satisfies the purchasing company's strategy best. The approach has been applied to a real-world supplier portfolio configuration case to demonstrate its applicability and to analyze how the consideration of sustainability requirements may affect the traditional supplier selection and purchasing goals in a real-life setting. KW - Supply chain management; Supplier selection; Sustainability; Logistics; Decision support systems Y1 - 2019 U6 - https://doi.org/10.1016/j.ejor.2018.06.044 VL - 272 IS - 2 SP - 505 EP - 522 ER - TY - JOUR A1 - Kellner, Florian A1 - Schneiderbauer, Miriam T1 - Further insights into the allocation of greenhouse gas emissions to shipments in road freight transportation: the pollution routing game JF - European Journal of Operational Research N2 - At present, there is no globally accepted standard for the allocation of greenhouse gas (GHG) emissions to shipments in road freight transportation. The only official international standard for emission calculation of transport operations is the European Norm EN-16258. However, even this norm still allows choosing from several alternative emission allocation schemes. This research aims to harmonize the process of GHG declarations for supply chains by identifying among all allocation units specified by EN-16258 the one that describes a shipment's contribution to GHG emissions best. For this purpose, concepts of the cooperative game theory are used. First, we develop three transport scenarios that allow studying a shipment's effect on GHG: a vehicle routing problem, a network flow model, and a mixed scenario. Our approach extends previous research projects because we take into account that shipment characteristics in terms of origin, destination, weight, and volume consume transport capacities to different degrees, impact the routing of the commercial vehicles and, thus, determine GHG. Second, we present the results of a computational study that bases on the introduced transport scenarios and that compares the allocation vectors resulting from the EN-16258 allocation rules with the Shapley value, which serves as a benchmark for a shipment's contribution to GHG. Furthermore, we show how often the EN-16258 allocation principles are in line with a set of game theoretical fairness criteria. The results indicate that the allocation unit ‘distance’ is the closest to the game theory benchmark and most often in line with game theoretical fairness criteria. KW - OR in environment and climate change; Allocation; Road freight transportation; Cooperative game theory; EN-16258 Y1 - 2019 U6 - https://doi.org/10.1016/j.ejor.2019.04.007 VL - 278 IS - 1 SP - 296 EP - 313 ER - TY - GEN A1 - Kellner, Florian A1 - Lukesch, Maximilian T1 - Business Analytics and Big Data: Production, Logistics and Supply Chain Management KW - Big Data KW - Analytics KW - Business Analystics KW - Logistik KW - Supply Chain Management Y1 - 2018 ER - TY - BOOK A1 - Lukesch, Maximilian A1 - Kellner, Florian T1 - Übungsbuch Produktionswirtschaft KW - Produktionswirtschaft KW - Produktion KW - Operatives Management KW - Operations Management KW - Operations Y1 - 2018 U6 - https://doi.org/10.1007/978-3-662-57689-2 PB - Springer Gabler CY - Berlin, Heidelberg ER - TY - CHAP A1 - Otto, Andreas A1 - Lukesch, Maximilian A1 - Brabänder, Christian A1 - Kellner, Florian ED - Corsten, Hans ED - Gössinger, Ralf ED - Spengler, Thomas S. T1 - Konsumgüterdistribution T2 - Handbuch Produktions- und Logistikmanagement in Wertschöpfungsnetzwerken N2 - Der Beitrag untersucht die Konsumgüterdistribution aus systemtheoretischer Sicht.Der Fokus liegt auf der logistischen Funktion der Warenverteilung mit Einschränkung auf schnelldrehende Konsumgüter (FMCG) in Deutschland. Der eng an die Empirie angelehnten Beschreibung der Funktion, der Strukturelemente (Kunden, Hersteller, Handel, Logistikdienstleister, Sortimente, Sendungen, Betriebsmittel) sowie der Prozesse (Netzplanung, Distributionsplanung, Auftragsabwicklung, Transporte) folgt die Diskussion prinzipieller Arbeitsfelder (Systemführerschaft, Bündelung, Beschleunigung, Segmentierung, Kanalintegration, Kooperation) zur Umgestaltung der Konsumgüterdistribution. KW - Distribution KW - Distributionslogistik KW - Konsumgüter KW - FMCG Y1 - 2018 U6 - https://doi.org/10.1515/9783110473803-039 SP - 737 EP - 758 PB - De Gruyter Oldenbourg CY - Berlin, Boston ER - TY - BOOK A1 - Kellner, Florian A1 - Lienland, Bernhard A1 - Lukesch, Maximilian T1 - Produktionswirtschaft: Planung, Steuerung und Industrie 4.0 KW - Produktionswirtschaft KW - Produktionsmanagement KW - operatives Produktionsmanagement KW - Produktion KW - Operations Management Y1 - 2018 U6 - https://doi.org/10.1007/978-3-662-54341-2 PB - Springer Gabler CY - Berlin, Heidelberg ER - TY - GEN A1 - Lukesch, Maximilian A1 - Kellner, Florian T1 - Der kleine Leistungsersteller: Ein Übungsheft KW - Produktionsmanagement KW - Leistungserstellung KW - Industrielle Produktion Y1 - 2016 ER - TY - JOUR A1 - Lukesch, Maximilian A1 - Kellner, Florian T1 - Green Controlling in Logistiknetzwerken JF - Controlling - Zeitschrift für erfolgsorientierte Unternehmensteuerung KW - Logistik KW - Controlling KW - Green Controlling KW - Emissionsmessung Y1 - 2016 VL - 28 IS - 8-9 SP - 526 EP - 529 ER - TY - JOUR A1 - Zeng, Li A1 - Kellner, Florian A1 - Lienland, Bernhard T1 - Rucksackprobleme in der Praxis - schnelle Entscheidungen schwer gemacht JF - HMD - Praxis der Wirtschaftsinformatik N2 - Unternehmen sind häufig mit Situationen konfrontiert, in denen schnell Entscheidungen bezüglich der Auswahl mehrerer Handlungsalternativen gefunden werden müssen. Mathematische Verfahren können hierbei unterstützen, z. B. für die Ermittlung einer ersten Diskussionsbasis. Verfügbare Softwarelösungen errechnen zwar häufig optimale Ergebnisse, zeigen jedoch Schwächen bei der praktischen Anwendbarkeit. So ist eine Einarbeitung in komplexe Optimierungssoftware für die teilweise sporadisch auftretenden Probleme in der Regel für Unternehmen nicht möglich, unter anderem auch unter Anbetracht der teilweise hohen Kosten der Standardsoftware und dem benötigten hohen Einarbeitungsaufwand. Gerade Problemstellungen in Fachbereichen, die nicht auf mathematische Problemlösung spezialisiert sind, münden daher regelmäßig in Ineffizienzen. Basierend auf den in der Literatur diskutierten Lösungsansätzen wurde ein praxisorientierter Ansatz zur Entscheidungsunterstützung für Rucksackprobleme bzw. 0–1 Probleme mithilfe von Genetischen Algorithmen (GA) entwickelt und technisch in Microsoft Excel® umgesetzt. Ein Praxistest bei einem chinesischen Textilunternehmen belegt erhöhte Effektivität und Effizienz. Die Software kann kostenfrei nach MIT Lizenz unter http://www.solvega.de/ heruntergeladen werden. Y1 - 2016 U6 - https://doi.org/10.1365/s40702-016-0207-z VL - 53 IS - 3 SP - 310 EP - 322 ER - TY - THES A1 - Kellner, Florian T1 - Distribution Network Analysis for Fast Moving Consumer Goods N2 - This dissertation summarizes three reserach contributions that have been published in academic journals. The reserach analyzes economic and environmental sensitivites of Fast Moving Consumer Goods distribution networks. N2 - Die Dissertation fast drei Forschungsbeiträge zusammen, welche in wissenschaftlichen Fachzeitschriften veröffentlicht worden sind. Die Forschung beschäftigt sich mit ökonomischen und ökologischen Sensitivitäten von Distributionsnetzen in der Konsumgüterindustrie. Y1 - 2016 ER -