@article{KunklerKellner2023, author = {Kunkler, Jan and Kellner, Florian}, title = {Sustainable City Evaluation Using the Database for Estimation of Road Network Performance}, series = {Sustainability}, volume = {15}, journal = {Sustainability}, number = {1}, doi = {10.3390/su15010733}, pages = {733}, year = {2023}, abstract = {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.}, language = {en} } @book{KellnerLienlandLukesch2022, author = {Kellner, Florian and Lienland, Bernhard and Lukesch, Maximilian}, title = {Produktionswirtschaft: Planung, Steuerung und Industrie 4.0}, edition = {3}, publisher = {Springer Gabler}, address = {Berlin, Heidelberg}, doi = {10.1007/978-3-662-65803-1}, year = {2022}, abstract = {Dieses Buch bietet eine einsteigerfreundliche Einf{\"u}hrung in die f{\"u}r industrielle Betriebe maßgebliche Aufgabe der Produktionswirtschaft. Im Zentrum steht dabei das operative Produktionsmanagement. Hierzu geh{\"o}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 {\"U}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{\"a}sentiert.}, language = {de} } @article{KraftKellner2022, author = {Kraft, Sarah Katharina and Kellner, Florian}, title = {Can Blockchain Be a Basis to Ensure Transparency in an Agricultural Supply Chain?}, series = {Sustainability}, volume = {14}, journal = {Sustainability}, number = {13}, doi = {10.3390/su14138044}, pages = {8044}, year = {2022}, abstract = {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.}, language = {en} } @article{Kellner2022, author = {Kellner, Florian}, title = {Generating greenhouse gas cutting incentives when allocating carbon dioxide emissions to shipments in road freight transportation}, series = {OR Spectrum}, volume = {44}, journal = {OR Spectrum}, doi = {10.1007/s00291-022-00675-y}, pages = {833 -- 874}, year = {2022}, abstract = {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.}, language = {en} } @inproceedings{KellnerSchroeder2022, author = {Kellner, Florian and Schr{\"o}der, Nadine}, title = {Location Planning \& Analysis Using Uncertain Data}, series = {2021 International Conference on Decision Aid Sciences and Application (DASA)}, booktitle = {2021 International Conference on Decision Aid Sciences and Application (DASA)}, doi = {10.1109/DASA53625.2021.9682323}, pages = {720 -- 723}, year = {2022}, abstract = {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.}, language = {en} } @article{KellnerLienlandUtz2021, author = {Kellner, Florian and Lienland, Bernhard and Utz, Sebastian}, title = {A multi-criteria decision-making approach for assembling optimal powertrain technology portfolios in low GHG emission environments}, series = {Journal of Industrial Ecology}, volume = {25}, journal = {Journal of Industrial Ecology}, number = {6}, doi = {10.1111/jiec.13148}, pages = {1412 -- 1429}, year = {2021}, abstract = {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.}, language = {en} } @article{KunklerBraunKellner2021, author = {Kunkler, Jan and Braun, Maximilian and Kellner, Florian}, title = {Speed Limit Induced CO2 Reduction on Motorways: Enhancing Discussion Transparency through Data Enrichment of Road Networks}, series = {Sustainability}, volume = {13}, journal = {Sustainability}, number = {1}, doi = {10.3390/su13010395}, pages = {395}, year = {2021}, abstract = {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.}, language = {en} } @book{LukeschKellner2020, author = {Lukesch, Maximilian and Kellner, Florian}, title = {{\"U}bungsbuch Produktionswirtschaft: Planung, Steuerung und Industrie 4.0}, edition = {2}, publisher = {Springer Gabler}, address = {Berlin, Heidelberg}, doi = {10.1007/978-3-662-62087-8}, year = {2020}, abstract = {Dieses Buch bietet Studierenden mehr als 70 {\"U}bungsaufgaben und drei Fallstudien inklusive ausf{\"u}hrlicher L{\"o}sungen zu ausgew{\"a}hlten Themen der Produktionswirtschaft und Industrie 4.0. Jedes Kapitel enth{\"a}lt eine kurze Einleitung sowie zu erreichende Lernziele. Querverweise auf das Lehrbuch „Produktionswirtschaft" von Kellner/Lienland/Lukesch erleichtern das Selbststudium und erm{\"o}glichen eine optimale Pr{\"u}fungsvorbereitung. In der 2. Auflage wurden umfangreiche {\"U}berarbeitungen hinsichtlich Sprache und Aufbau von Aufgaben, L{\"o}sungswegen und Abbildungen vorgenommen sowie zahlreiche neue Aufgaben erg{\"a}nzt.}, language = {de} } @article{Kellner2021, author = {Kellner, Florian}, title = {Exploring the impact of urbanization on consumer goods distribution networks}, series = {Journal of Asian Business and Economic Studies}, volume = {28}, journal = {Journal of Asian Business and Economic Studies}, number = {2}, doi = {10.1108/JABES-12-2019-0127}, pages = {101 -- 120}, year = {2021}, abstract = {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.}, language = {en} } @book{KellnerBrabaender2020, author = {Kellner, Florian and Brab{\"a}nder, Christian}, title = {VBA mit Excel}, publisher = {Springer Gabler}, address = {Berlin, Heidelberg}, doi = {10.1007/978-3-662-59740-8}, year = {2020}, abstract = {Dieses Buch bietet eine anwendungsorientierte Einf{\"u}hrung in die Programmierung mit Visual Basic for Applications (VBA) in Microsoft Excel. Es erm{\"o}glicht auch Einsteigern die selbstst{\"a}ndige L{\"o}sung kleiner bis mittelgroßer Programmieraufgaben aus dem betriebswirtschaftlichen Alltag. Der Schwierigkeitsgrad der Inhalte ist {\"u}berwiegend einfach gehalten, sodass Nutzer, die bereits grundlegende T{\"a}tigkeiten in MS Excel beherrschen, sich nach ihren jeweiligen Anforderungen entsprechend fortbilden k{\"o}nnen. Zahlreiche Praxisbeispiele und {\"U}bungen, die auf einem Windows-Betriebssystem entwickelt und getestet wurden, unterst{\"u}tzen das Lernen Schritt f{\"u}r Schritt und zeigen, wie hilfreich VBA durch Automatisierung und Individualisierung in jedem B{\"u}ro sein kann.}, language = {de} } @book{KellnerLienlandLukesch2020, author = {Kellner, Florian and Lienland, Bernhard and Lukesch, Maximilian}, title = {Produktionswirtschaft: Planung, Steuerung und Industrie 4.0}, edition = {2}, publisher = {Springer Gabler}, address = {Berlin, Heidelberg}, doi = {10.1007/978-3-662-61446-4}, year = {2020}, language = {de} }