Develop a production planning MVP solution that can determine an optimal schedule based on planned orders and factory constraints using OR techniques.

1) Inability of traditional production planning solutions to respond to rapidly changing customer orders

2) Suboptimal production quantities are not aligned with customer demand, resulting in shortages for certain SKUs and excess inventory for other SKUs.

Tredence’s smart MPS optimization tool employs OR algorithms to optimize production planning and simulates scenarios to visualise the impact on the plan of changing planning parameters or planning objectives. This results in increased revenue by reducing lost sales and lowering finished goods inventory by manufacturing the optimal quantity of products to meet demand.

This implementation uses the following native Azure components:

1) Azure Data Factory: For data extract-transform-load (ETL) to deal with data coming from disparate production systems.

2) Azure App Services: For developing web apps for users to consume insights and provide inputs on the production plan

3) Azure Databricks: For developing optimization and simulation models to generate the ideal production plan.