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 41
- Downloads 0
Schyłek finansowo-premiowych systemów motywacyjnych
This paper is an attempt to show the impact on staff material and financial motivation system. The work provides brief descriptions of various definitions of motivation and effects which a given type of motivation may ha...
Bezpieczeństwo procesów produkcyjnych w aspekcie zapalności pyłów organicznych
The occurrence of dust, which, due to their physico-chemical properties can ignite and cause an explosion is widespread in the industry. Technological advances and the related development of explosion protection can sign...
SELECTED ASPECTS OF PRODUCTION CONTROL A CRANKSHAFT WITH A FREE FORGING METHOD TR
The quality evaluation shall be the primary objective of acceptance testing of forgings for crankshafts. This paper presents technological issues concerning the production of crankshafts. It also characterizes and presen...
Ocena propozycji usprawnień produkcji
Market is demanding for competing organizations in present days. Present management of enterprises has to be on high level and have to be one step ahead of the competition. This is reason to introduce modern management p...
Analiza funkcjonowania systemu kanban w przedsiębiorstwie produkcyjnym
Paper presents an assessment of the functioning of the production control system in a manufacturing company. The assessment was based on the perception of the employees. In the opinion of the surveyed employees kanban ha...