System planowania potrzeb materiałowych (MRP) w przedsiębiorstwie produkcyjnym

Przedmiotem pracy jest opis narzędzia wspomagającego proces planowania potrzeb materiałowych (MRP) w przedsiębiorstwie produkcyjnym. Model został stworzony w oparciu o aplikację Microsoft Excel. Szczególną uwagę poświęcono analizie przydatności narzędzia w przypadku zmian struktur produktów oraz wystąpienia ograniczeń dostaw na rynku.

The aim of this article was to present material requirements planning system (MRP) as a useful tool that can be used for the planning of production irrespectively of the capacity of a company, changing structures of manufactured bands and cases to impose restrictions on the service providers. The main system objective is to ensure adequate quantities of raw materials and materials necessary to achieve the planned production and delivery to the customer, to maintain the lowest inventory levels and to support the planning policies relating to business scheduling of deliveries and assembly operations. Due to that, the author developed and described an application that enables the efficient and accurate calculation of material requirements for various raw materials and components depending on the demand for the final product. There were analyzed and presented the examples of scheduling orders for a lot number of products, for the procurement of limited quantities and for production processes with a variable structure of the product. In description of the methodology of calculation of MRP system, the author presented simple examples (maximum of three structural levels). However, it is shown in this article that this tool can be efficiently and effectively used for the calculation and planning a lot more complex cases, in which it will be necessary to use computer equipment.