En stor utmaning för företag som befinner sig på den internationella E-handelsmarknaden är att ha fullständig kontroll över utgående transportkostnader. Oväntade kostnader kopplade därtill är ett dyrt och tidskrävande problem för en verksamhets Supply chain management. Last mile transporten, den avslutande transporten av en kundbeställning, påverkas speciellt mycket då den betraktas som den dyraste delen av försörjningskedjan. Syftet med examensarbetet är således att undersöka om det finns en besparingspotential i att få ökas kontroll över inkomna fakturor för last mile transporter. Det här examensarbetet har genomförts på ett fallföretag inom E-handel. För att uppnå syftet och besvara frågeställningar har fallstudien använt det vetenskapliga angreppssättet abduktion, vilket har möjliggjort växling mellan litteratur och empiriskt material. Med hjälp av intervju, observation och dataanalys samt en kompletterande litteraturgenomgång har materialet analyserats och diskuterats för att slutligen dra en slutsats. På fallföretaget genomförs den nuvarande kontrollen av inkomna faktorur för last mile transporter genom stickprov, och de oväntade kostnader som påträffas misstänks vara feldebiteringar. Examensarbetets slutsats är att oväntade kostnader kan orsakas av att skillnaden mellan angiven och debiterad vikt är störra än ett kilo, samt att bränsletillägget är större än 50 procent av transportens grundpris. Problematiken är omfattande dels då effektiviteten och kundnöjdheten ur ett långsiktigt perspektiv påverkas negativt, dels då insikten om och förståelsen för verksamhetens utgående kostnader är nödvändigt för företag som verkar på den internationella marknaden. Slutligen har en mer tidseffektiv arbetsmetodik i programvaruverktyget Microsoft Excel rekommenderats för att urskilja möjliga orsaker till oväntade kostnader vid last mile transporter.

I samband med digitaliseringens intåg har nya förbättrade BIM-verktyg börjat användas för att effektivisera konstruktörens arbete. Med hjälp av implementering av grafiska tredjepartsprogram kan BIM verktygen bidra med ökat funktionalitet. Ett exempel på ett sådant program är tredjepartsprogrammet Grasshopper kopplat till BIM-verktygen Tekla Structures som skapar parameterstyrning, vilket innebär att modellens data styrs och nås av de externa programmen. På Rambolls Bro- och Tunnelavdelning vill man idag, som många andra konsultföretag bli mer BIMorienterade. Dock saknas en uppskattning av den totala tidsbesparingen och nyttjande av tredjepartsprogrammen. Syftet med detta examensarbete har varit att komma fram till en slutsats som ger stöd i beslutsfattande kring vilka typer av projekt som parameterstyrda modeller kan vara lämpliga för. Genom uppbyggnad av ett automatiserat skript för en stödmur har denna studie visat kopplingen mellan programvarorna Microsoft Excel, Rhinoceros-Grasshopper och Tekla Structures. Med denna tillämpning har man lyckats skapa ett lätthanterligt användargränssnitt. Vidare har man jämfört det färdiga skriptet i Grasshopper med en modellering i Civil 3D där man har kommit fram till att man kan vinna tid på att ha ett optimalt skript. Man har även kunnat dra slutsatser under vilka förhållanden det lämpar sig att använda parametrisk modellering och automatisering som pekar mot tidiga skeden i projektering och standardkonstruktioner. / In connection with the digitalization's entry, the companies has begun to apply new improved BIMtools to streamline the constructor's work. With the help of the implementation of graphical thirdparty applications, the BIM-tools can achieve increased functionality. An example of such a program is the third party applications Grasshopper linked to the Tekla Structure, which creates so called computational design, which means that the model's data is controlled and accessed by the external programs. The Bridge and Tunnel department at Ramboll wants to become, like many other consulting firms, more BIM oriented. However, there is no estimate of total timesaving and utilization of the implementation today. The purpose of this thesis project has been to come at a conclusion that provides support in decision-making regarding which types of projects that parameter-controlled models may be suitable for. By building an automated script for a retaining wall, this study has shown the connection between the software Microsoft Excel, Rhinoceros-Grasshopper and Tekla Structures. With this application, one has succeeded in creating an easy-to-use interface. Furthermore, one has compared the finished script in Grasshopper with a model in Civil 3D where the assumption that one can gain time by having a finished script. It has also been possible to draw conclusions under which conditions it is suitable to use parametric modeling and automation that points to early stages in design and standard constructions.

In my work I deal with the issue of data mining and its use in the commercial sphere. Specifically, I focused on marketing and sales forecast. The aim of my work was first to assemble knowledge from data mining and then use it to create sales forecasts using data mining add-on for Excel. In the first part I gather the theoretical information about data mining. I focused on definition, the methodology, algorithms and of course on the most frequent usage. The second part consists of the practical application of acquired knowledge. I focus on making the sales forecast of HERO CZECH company. I used data mining add-on for Microsoft Excel 2007. Results are compared with real forecasts prepared by the Key Account Manager. Results of my work proved that forecasts from data mining add-on for Excel were not more accurately than the existing ones from Key Account Manager. Nevertheless, I believe that the use of data mining methods have found use in preparing the forecast, at least as a means of support.

The presented diploma thesis deals with the improvement of system support at the department Sales Planning and Reporting in Skoda Auto a.s. Its major objective is proposal, creation and implementation of the main analytical tool for sales and production planning in this department with regard to the economic efficiency of this solution. The main task of this tool is to make the process of planning in the company more effective and support management’s decision making process. The entire project is implemented in Microsoft Excel using Visual Basic.

This diploma thesis deals with the evaluation of supplier risk for a chosen company Vinařství Soška using the fuzzy logic principles. This company like many others is forced to shift its sales to the Internet environment due to the government restrictions established to reflect the pandemic situation. For a successful Internet business, it is necessary to choose an optimal ecommerce software based on the company requirements. For this purpose, two fuzzy logic models are built in Microsoft Excel and MATLAB software. Their aim is to evaluate the potential risk of all of the suppliers. Based on this evaluation, the results are transformed into specific recommendations on how to choose the optimal solution for the company. The first chapters deal with the general theory that is later used in the analytical part.

This thesis deals with the use of modern methods of analysis and modeling for the selection of optimal suppliers. This work used the theory of fuzzy logic. The basis of the work is to create tools that help you select the best supplier works for redevelopment of the former railway superstructure on the bike path. This work could arise due to data provided by the Municipal Authorities in Zábřeh.

This diploma thesis deals with development of a fuzzy decision-making system for evaluating of REONTECH CZ s.r.o. company suppliers. The first part is dedicated to theory of fuzzy logic. The next part contains firstly an analysis of the current situation and then a description of the development process of the fuzzy decision-making system. The main outcome of this thesis is a tool that meets needs and requirements of the company and serves as a decision-making support tool.

This master thesis deals with the application of fuzzy logic for evaluating the quality of customers in company PPL CZ s.r.o. For evaluation was used Microsoft Excel and MathWorks MATLAB. There are going to be created models using fuzzy logic. The introductory part is devoted to the theoretical bases that are necessary to understand the whole issue. The second part includes information about the company and analyzes of the current situation. Finally, the last part presents fuzzy models used to evaluation of existing customers.

Individuals who train to become behavior analysts should be able to organize, create, and display data accurately in order to make a data-based decision about the interventions being used for his or her clients. Behavior analysts most commonly use the visual analysis of the data to continuously evaluate the relationship between the intervention and the target behavior being measured. A multiple probe design across behaviors (i.e., Reversal Design, Alternating treatments and Multiple baseline design) was used to evaluate the effects of behavioral skills training (BST) with video modeling on three potential behavior analysts’ single-subject design graphing skills in Microsoft Excel™. Behavioral skills training is a training package made up of multiple components, but for the purpose of this study BST included: rehearsal, video modeling w/ instructions, and feedback. The three participants were taught remotely via Zoom how to accurately complete the steps in the graph creation process for a reversal design, alternating treatments design, and a multiple baseline design. Results indicate that BST with video modeling was an effective and efficient intervention to increase the accuracy of three potential behavior analysts’ single-subject design graphing skills on Microsoft Excel™. / Applied Behavioral Analysis

The thesis Teaching Microsoft Office using multimedia assesses the possibilities of creating multimedia teaching materials for Microsoft Office software suite. The partial goals include publication on YouTube.com, creation of text support materials, analyzing the availability of educational video materials for Microsoft Office in Czech Republic and abroad, and theoretical analysis of software used in practical part. One of the most interesting results from theoretical part is the amount of online content that exists in video format. Currently it makes up more than 50% of the consumed content and by 2019 it should be up to 80%. Currently, the average user in Czech Republic spends almost 30 hours each month consuming content from YouTube. In the practical part, the author selected the methodology and correct hardware and software equipment for creation of video materials. It was also necessary to create screenplay to ensure the required quality of the final product. Finally, it was necessary to edit created materials in a nonlinear editing program. For this purpose, the author chose Adobe Premiere Pro 2015.1. Next step was to create the appropriate YouTube channel called Abeceda Microsoft Office (Microsoft Office Alphabet) and upload video to it. After that, the author performed pilot tests on a sample of high school students.