Herramienta funcional para desarrollo y manejo de un modelo de gestión de inventarios

Abstract

This thesis emerges as an opportunity to create an improvement tool for the companies, for a better control of the stock due to disorders of the market prices, unplanned promotions, and the confrontation of optimistic forecasts vs. Conservative forecasts, which affects the portfolio of the company, generates a large volume of returns and directly affects the strategic goals companies.

After this clear opportunity of improvement, the decision is made to evaluate the forecasting model that yields the most accurate values for demand planning; on the other hand the best stock model was analyzed with their key performance indicators. Giving as a result a parameterized tool in Excel, that yields data more accurate of the sales forecasts and optimize stock management.

Therefore, this tool contains a management stock model of continuous review , providing more accurate information of demand that the company faces, the sales it can generate, and the processes needed to support its business plan.