ORTools integration. Manufacturing planning system
Budget: €250 – €750 EUR
Target: Design a system capable of optimize use of materials, minimizing intermediate product remaining.
Entry Data
- Recipes: table with specification of how a component is maked from his subcomponents or raw materials. Each row is a “Version Component”, specifies version number (recipe), Parent/Child reference, and quantity of subcomponens needed for produce a single unit of parent.
- Stock: table with quantity of availables products, subcomponents and raw materials. Each row specifies reference of material, creation date and expiration date. Materials cannot be used after his expiration date
- Orders: table with required materials. Each row specifies final reference, quantity and target date (date when we need the material without expired components).
Desired Output
System must chose between diferent recipes to consume the most available suproducts, and generate as less as possible intermediate products.
- Min stock: target function to minimize is remanining stock after obtain the orders.
Entry Data
- Recipes: table with specification of how a component is maked from his subcomponents or raw materials. Each row is a “Version Component”, specifies version number (recipe), Parent/Child reference, and quantity of subcomponens needed for produce a single unit of parent.
- Stock: table with quantity of availables products, subcomponents and raw materials. Each row specifies reference of material, creation date and expiration date. Materials cannot be used after his expiration date
- Orders: table with required materials. Each row specifies final reference, quantity and target date (date when we need the material without expired components).
Desired Output
System must chose between diferent recipes to consume the most available suproducts, and generate as less as possible intermediate products.
- Min stock: target function to minimize is remanining stock after obtain the orders.