An integrated solution for material requirements planning