Predikování poptávky a řízení zásob hotových výrobků

Abstract

This thesis topic is demand prediction and inventory management of finished goods in an existing company. Inventories currently represent a major problem for companies, because they contain a large amount of financial resources and carry substantial costs. Methods of ABC and XYZ analysis are used for the inventory analysis. Regarding ABC analysis, its multiple criterial form is employed. The first criterion is an amount of sales and the second is an inventory turnover. ABC analysis earmarked the most important inventory items of assortment and also the problematic ones. XYZ analysis, conducted only for the most important inventory items of the assortment, indicated demand variability. A demand prediction regarding inventory items with medium predictive ability is performed for the month of March 2016 using prediction method of exponential smoothing. Microsoft Excel is used for all the calculations. The thesis also presents recommendations based on the performed analysis. Suggestions should help optimize the finished goods inventory management by reducing costs of holding stock, and other suggestions aim to make the demand prediction more accurate. Suggestions are focused mainly on the inventory management, in particular recommendations concerning the assigning of production orders, an amount of safety stock, order levels and delivery rates are made. Remaining suggestions concern demand prediction, establishing contractual penalties and improvements regarding the information system.