Many companies use Excel spreadsheets to keep stock records and to calculate process-specific data. These spreadsheets are often hard to understand and track. And if the user does not protect them, there is a risk that the user randomly changes or erase formulas. The paper focuses on the stocks of products used in a blending process with a known recipe. Developing an application that can bring this data in a centralized form and that can assist the operator in decide is a necessity. When a programmer implements an application that uses data from plants he needs to consider one fundamental aspect as reading real-time data from the process. The real-time stock analysis application takes into account all the above elements. The application is easy to use by an operator in the command room of installation because of the planning algorithms integrated into it. The algorithms proposed and implemented in this paper have well-defined goals: identifying the ingredients needed to achieve the blending process for required quantities, determine the quantities of the finished product that can be made with the existing ingredients and determine the optimum quantities of the finished product. The application implemented in C# intensively uses these algorithms and gives the user the ability to build the result step by step.
[1]
Dimitri J. Papageorgiou,et al.
An MILP-MINLP decomposition method for the global optimization of a source based model of the multiperiod blending problem
,
2016,
Comput. Chem. Eng..
[2]
Gabriela Cristina Ionescu,et al.
System for the Management of Raw Materials Based on RFID Technology
,
2013
.
[3]
Franklin Djeumou Fomeni,et al.
A multi-objective optimization approach for the blending problem in the tea industry
,
2018,
International Journal of Production Economics.
[4]
Günter Gruhn,et al.
Short-term scheduling and recipe optimization of blending processes
,
2001
.
[5]
Günter Gruhn,et al.
Short-term scheduling and recipe optimization of blending processes
,
2000
.
[6]
Hiroyuki Morikawa,et al.
Multi-Hop LoRa Networks Enabled by Concurrent Transmission
,
2017,
IEEE Access.
[7]
Jaime Cerdá,et al.
Optimizing Gasoline Recipes and Blending Operations Using Nonlinear Blend Models
,
2016
.
[8]
M. H. Husni,et al.
Feasibility of LoRa Implementation for Remote Weather Monitoring System through Field Measurement and Case Study Analysis
,
2018
.