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 -