Propuesta de un sistema de control en la entrega de materiales y manejo del stock para optimizar la administración de inventarios en la bodega de materia prima en la empresa PLASMADE

Abstract

The need for better control in the cellar of raw material of the line of finishes for the construction of the company PLASMADE Bermeo Hnos.Cia. Ltda., the objective of the present thesis topic is to provide this section of a computer system of control and supply using spreadsheets in Excel® which allows you to review and estimate the quantity of materials to deliver daily to the different production areas of the company, in addition to providing you with results and immediate answers and real about the daily situation of inputs that are handles to the date.

This program has basic aspects of a system of control, such as for example the windows of inflow and outflow of material, it enables the timely replenishment of stock to inventory because it has a window of review of the entire database is handled in the winery and its respective color coding to indicate the current status of each input (when you do not have stock, when it is already necessary replenish or when the stock is ok). It also offers the possibility to calculate and dispense the material just and necessary depending on the daily workload and the amount of people in each area of work. Finally and once calculated to deliver the material, this may be a graduate from the program directly with what we have organized, streamlined and controlled the work in the bodega avoiding waste by misuse of the inputs that occupies each section of the company.