MRP_Excel 2.0

MRP_Excel 2.0 stands for Manufacturing Resource Planning (MRP) system in Excel that satisfies you with no macros or VBA code, nothing is hidden.

The system may be modified by an Excel literate person, and adapted for use by a range of manufacturing companies. The system is loaded with sample data from a fictional shampoo manufacturer who makes 3 variants each in 3 pack sizes on a single bottling line.

Working from a sales forecast and finished inventory, the system schedules the bottling line so that the desired inventory cover is maintained. It also explodes the production requirements through a bill of materials (BOM), and calculates the raw materials to be purchased, taking into account the materials that are in inventory and on order from suppliers.

There is also a module which determines the best mix of products to make with the raw material inventory on hand, taking into account that some of the materials are common to several products, while others are unique.