Šis darbas apima vaistinių tinklo klientų duomenų analizės modelio sudarymą ir sukūrimą. Kuriant ir projektuojant duomenų saugyklas, susiduriama su įvairiomis problemomis. Viena didžiausių ir daugiausia laiko užimančių duomenų saugyklų projektavimo ir kūrimo problemų – tai duomenų išgavimas iš esamų sistemų ir jų perkėlimas į analizės sistemas (ETL procesas). Analizuojamoje įmonėje naudojama Oracle duomenų bazė darbiniams duomenims saugoti. Tačiau kuriant duomenų saugyklą, buvo palygintos technologijos ir pačiai saugyklai realizuoti pasirinktos Microsoft SQL Server priemonės. Duomenų saugykla yra skirta vaistinių tinklui, kur be tradicinių pardavimų duomenų, yra ir tik farmacijoje naudojami duomenys (kompensuojamųjų vaistų receptai, draudimo nuolaidos ir pan.). Darbo metu sukurtas OLAP analizės kubas, apimantis vaistinių tinklo pardavimų, nuolaidų kortelių panaudojimo duomenis. Tai leidžia įmonės analitikams efektyviau analizuoti klientų įpročius, paklausiausias prekes ir pasiūlyti klientams tinkamiausius sprendimus, išlaikant esamus klientus ir pritraukiant naujus. Darbo metu realizuotas analizės kubas, nustatyti jo atnaujinimo intervalai, ištestuotas bendras sistemos veikimas. Taip pat nustatytos pagrindinės duomenų saugyklų projektavimo, realizavimo problemos. / This work investigates Pharmacy Data Warehouse model and practice. The development and design of data warehouse is faced with various problems. One of the biggest and most time consuming data warehousing design and development issues - is the data extraction from existing systems, transformations and load (ETL process) to target systems. Analyzed company uses Oracle database as operational data store. Examination of the current situation, the technical base, for the implementation of the data warehouse is selected the Microsoft SQL Server 2000 Analysis Services tools. Because these tools already exist in the company, thus reducing the overall costs needed. During this work is realized the cube of Pharmacy customers analysis, tested overall system performance, in addition, an example schedules for cube updating are created. This enables the analysts to more effectively analyze customer behavior, sales and offer customers the most appropriate solutions, while retaining existing customers and attracting new ones.

Veiklos analizavimas bei sprendimų priėmimas labai svarbus šiandieninėje įmonių veikloje. Norėdamos atlikti veiklos statistinę analizę, įmonės perka brangius ir sudėtingus produktus nesigilindamos apie tų produktų nauda įmonės veikloje. Vienas iš sprendimo būdų kaip efektyviai atlikti statistinę duomenų analizę neinvestuojant didelių resursų – naudoti standartines DBVS statistines priemones. Šiomis priemonėmis įmonės gali atlikti įvairią statistinę analizę kasdienėje veikloje naudojant statistinės analizės metodus: linijinę regresiją, koreliacijos analizę, nuspėjamąją duomenų analitika, Pareto analitika, Chi kvadrato analitika, ANOVA. / This work reviews advantages and disadvantages of existing statistical analysis tools usage for small and mid sized enterprises, explores usage of statistical analysis of enterprise data in data warehouse, reviews integrated statistical analysis functions in existing database management systems and integrated graphical software for graphical statistical analysis usage. In this work were analyzed Oracle, Microsoft SQL Server and DB2 DBMS. The new statistical analysis solution was offered. This solution allows statistical analysis of existing data using integrated statistical functions of the database management systems and integrated graphical tool. Proposed solution has been designed and realized for the statistical analysis of insurance company‘s data. Oracle DBMS was selected for statistical analysis, because this DBMS is used by insurance company. Oracle has a large number of integrated statistical analysis functions; it ensures more diverse and rapid analysis. Graphic depiction of the selected Oracle Discoverer tool to optimally exploit data analysis potential of Oracle DBMS. The proposed statistical analysis process is versatile and suitable for different business areas and can be applied to other DBMS, which has an integrated analytical functions and graphical tools for the results display.

Sukurta firmai „West END Knitwear Ltd.“ Sandėlio vadymo sistema „Maelstrom“. Ši programą optimizuoja įmonės darbą pateikdama ataskaitas apie produkciją bei darbuotojų veiksmus. Darbas atliktas optimizuojant programą pagal tam tikras, darbe aprašytas taisykles. / Warehouse Management System “Maelstrom” is created for “West END Knitwear Ltd.” Company. This program optimizes company's work by providing accurate reports on sales and employees actions. Also it was done in an efficient way by following some rules that were defined in this work.

Despite several developments in logistics that strive to decrease costs, tendencies can be found for increased logistical costs (Pewe, 2011, p. 17). Some factors causing increased system complexity are increased selection and faster market movements. The Warehouse Department at Carlsberg Sverige in Falkenberg has been chosen to be studied regarding continuous quality improvements. Carlsberg Sverige implemented an automated inventory system and automated order-picking system in 2012-2013, which has had about 40% increase of stock keeping units (SKUs) since the investments. Since the implementation of the automation Carlsberg Sverige has encountered challenges with other quality of goods. The system has become more sensitive and it has become more important to eliminate deviation.The study aimed to develop a way for long-term reduction or elimination of quality errors that result in negative effects to the system. A specific area investigated was regarding both effect of the organization in a holistic perspective and on a level of detail of the analyzed area. The study did not include quality of beverages, but only external quality problems of goods, such as faulty stacking of packages or plastic wrapping hanging outside of the goods.An exploratory study was conducted with predominantly quantitative data collection methods. Initially a current state mapping was made, a flow chart was created through interviews and observations of employees. Critical activities / situations were identified in the flow chart and three areas were determined for further investigation regarding quality errors. Observations were carried out where all occurred abnormalities were registered. The results were analyzed and a focus area determined for continued deeper examination. A final model was created with the influence of theories and collected data from the case study.The examined focus area was part of the fully automated warehouse. Adaptation to the new automation was still under investigation and a need for more clarity in the continuous quality improvements . From the observations, it was revealed that in approximately 70% of the observing time in the focus area, there was an error in the area affected system. Registered errors were categorized into ten groups, seven groups were included in the research scope. Out of the seven categories there were two significance regarding amount of repetitions of registered errors; unreadable label was measured 30 times, and plastic wrapping outside goods was discovered 12 times during 7 hours of measurement. Significance regarding average duration was discovered for; system errors of labels and wood detected by sensors on conveyors.Detected errors with significance were further analyzed with fishbone diagrams to find root-causes. Several common causes were discovered in the fishbone diagrams, for instance regarding inadequate methods and measurements. The discoveries functioned as basis for the final model that consists of: Key Performance Indexes (KPI's), a flow chart of affecting processes, daily whiteboard meetings, improved communication channels and a process for implementation of routines. The model developed was to fit this case study, which represents; a complex system with lots of shift work, both manual and automated processes and handling of beverage goods. Despite this, the model is considered to function as a basis to work on continuous quality improvements for organizations outside the mentioned scope, but with modifications of the model.

Bei der Bekämpfung von Lebensmittelabfällen steht die Nachhaltigkeit an erster Stelle. Aus Nachhaltigkeitsgesichtspunkten ist eine Ressourcen- und Lebensmittelverschwendung inakzeptabel. Das Forschungsziel ist die Reduzierung von Abfällen in Lebensmittelketten unter Berücksichtigung der Gesamtkosten in den Lagerstufen. In dem Promotionsvorhaben werden stufenübergreifende Lagerhaltungsstrategien auf Abfallquoten hin untersucht. Als Forschungsmethode wird die Simulation angewendet. Es werden ausschließlich Frischwaren mit dem Haltbarkeits- und Verfallsdatum betrachtet, da diese Warengruppe den größten Anteil von Abfällen ausmacht.

This thesis examines the barriers that impede intensification (infill and redevelopment) within Regina’s Warehouse District (The District). In addition this study provides recommendations to overcome said barriers in order to facilitate residential development. This research expands upon two previous studies from 2002 and 2009, which were initiated by community stakeholders and that identified the need for additional residential development within The District. To date, success of the two previous plans in attracting new infill and redevelopment has been limited. This research looks to understand why this is, through the use of semi- structured interviews with key informants. Additional data from secondary documents and visual observations was collected to substantiate this approach. This research found that intensification in The District has been limited due to; unbalanced growth, existing municipal policies and zoning, a negative perception, proximity to noxious uses, an absence of amenities and services, unfavourable land development economics, and a soft demand amongst prospective residents. The second part of this research identified possibilities or factors to facilitate intensification within The District. Similarly these findings are grounded in the discussion with key informants. This data is corroborated by existing planning literature, as well as best practices from a number of North American jurisdictions. This study found that intensification could be facilitated in The District by; balancing growth, revising municipal policy and zoning, increasing public investment, improving the perception, having the city engaged in development, and with increased financial incentives. This research has explored intensification in two unique contexts, a mid-sized Canadian city and a historically industrial neighbourhood. It has contributed to the academic literature by establishing a better understanding of the barriers to intensification within both contexts. More specifically, it has explored intensification within Regina’s Warehouse District, a city that has been largely bypassed by academic planning literature.

In the distribution network of a large retailer, shipments can either be transported by the retailer's own trucks or outsourced to third-party logistics (3PL) companies. In the former case, shipments are consolidated and transported from their origins through an intermediate facility, namely a crossdock. At a crossdock, shipments are unloaded, sorted, re-consolidated, loaded and transported to their destinations. The consolidation process offers economies of scale that reduce the transportation costs. At the same time, it increases travel distances and incurs handling costs at a crossdock. For this reason, consolidation is uneconomic for a shipment in which origin and destination are located close to one other, especially through a distant crossdock. It is cheaper to outsource transportation of such a shipment to 3PL companies. This shipping decision raises a series of questions. Should a shipment be consolidated through a crossdock or outsourced to 3PL companies? How do facility locations, the operational cost of a crossdock and mode of shipments influence the shipping decision? Can the robustness and potential growth of a crossdock be measured? How does outsourcing affect the robustness and potential growth of a crossdock? We formulate a strategic model of a retailer's distribution network as an economic trade-off between consolidated shipments through a crossdock and outsourced shipments to 3PL companies. We study the locus of facility locations where the costs of a consolidated shipment and an outsourced shipment are equal and discover that the trade-off can be modeled by classical geometric curves, particularly an ellipse, a hyperbola, a limacon and a Cartesian oval. These curves can be developed into a preliminary routing and locating tool. We also observe interesting connections between the single hub crossdocking network and other fields of geometric study, such as Voronoi diagrams and geometric inversion. In addition, the area bounded by these curves represents the likelihood in which a particular shipment is consolidated through a crossdock. We expand this concept to multiple vendor-store pairs and suggest an index that measures robustness and potential growth of a particular crossdock. This asymptotic-probability index explains economic driving factors of consolidation and outsourcing. Although the derivation of the index is limited by the dimension and spatial distribution of facilities, its numerical value can be determined by a computer simulation. Therefore, we use Monte Carlo simulation to compute the proposed index to explain the outsourcing and the interaction between TL threshold0.1 and mode of shipments. The analysis and computer simulation suggest that outsourcing may cause an adverse effect in a single hub crossdocking network, resulting in the abrupt reduction of consolidated shipments in the network. Furthermore, we propose transportation planning to alleviate this effect and compare them to the optimal allocation. The routing and locating application of the model is illustrated using the Home Depot distribution network. Our model predicts 5.5% and additional 1.0% savings in transportation cost by re-allocation of shipments and re-location of crossdocks, respectively. The empirical study shows that the adverse effect of outsourcing can be eliminated by limiting the number of crossdocks used by each store.

Universiẗat, Master-Thesis--Leipzig, 2006.

Zugl.: Oldenburg, Univ., Diss., 2007

Sankt Gallen, Universiẗat, Diss., 2008.