Zastosowanie baz danych w analizie danych historycznych sprzedaży na potrzeby klasyfikacji pozycji materiałowych i sterowania zapasami
Journal Title: Zarządzanie Przedsiębiorstwem - Year 2015, Vol 0, Issue 4
Abstract
The idea of database for sale historical data analysis is presented in this paper. General description of material items classification using ABC/XYZ methods is also included. The main idea was to create open tool to enable fast data analysis. As a result, the logic scheme was developed and also implementation in MS Access 2010. Presented module includes: set of needed tables, user interface and many SQL queries and VBA macros. The structure of developed database is ready to test on any example. For testing purpose, the virtual company was defined, which produce the mix of velocity reducers. Into database was entered data about 38 products and 234 items (materials, parts). Moreover, author developed special VBA procedure which allows to random generation of sale historical data. In this procedure is possible to define: the range of dates (including work system, holidays etc.), the number of customers, the number of products, customer order details etc. Using this procedure, the sale historical data was generated including 5.5 years from 2008 till 2013. Example data analysis of sale in 2012 is also presented. By the set of cascade SQL queries the following results are generated automatically (based on recorded customer orders): daily quantity aggregation of products and its parts usage, weekly and monthly quantity aggregation of material items (parts) usage, ABC classification, XYZ classification. The database was tested also on real xamples from industry. The simply design, easy adaptability to other tasks, fast data processing are the most advantages of developed database.
Authors and Affiliations
J. Habel
Keywords
Related Articles
- EP ID EP352911
- DOI -
- Views 36
- Downloads 0
Koncepcja zastosowania narzędzi predykcji w projektowaniu harmonogramów odpornych
The development of competitiveness on world markets caused the need to increase production flexibility. An essential tool in achieving this purpose could be production scheduling. Unfortunately, the production process is...
System komputerowego wspomagania przygotowania receptur do produkcji pianek poliuretanowych
In the article meaning of polyurethane foam as well as basics of its production are presented. Requirements for IT system, which could support technologists in the process of preparation of recipes to produce polyurethan...
Integrating simulation into data mining
This article describes a way to integrate a simulation into a data mining technology, particularly with respect to CRISP-DM standard. Aim of this approach is to enable data mining in various cases, when available data do...
THE ANALYSIS AND IMPROVEMENT OF PRODUCT QUALITY USING SELECTED METHODS AND TOOLS IN AUTOMOTIVE INDUSTRY ENTERPRISE
The work included a qualitative analysis of a product installed in passenger cars of a selected make and model. The product is an airbag module manufactured for one type of passenger car. This product is produced by an i...
Obliczanie składowej jakości oee przy wielu operacjach technologicznych
Aim of this article is to present way of calculation of the OEE rate for work stations. The OEE rate is a tool used in searching for the best way of improvement of functionality of a work station. During the research in...