Designing An Online Inventory Database, Bulk Density Validation and Shelf Life Assessment for Partially Processed Raw Materials

Abstract

PT Global Vita Nutritech (GVN) is Indonesia’s first local premix batching manufacturer specializing in vitamins, minerals, and other functional ingredients to be used by food, beverage, and nutraceutical industries. As a premix manufacturer, PT Global Vita Nutritech intends to help in minimizing raw materials days inventory outstanding, enhancing production control, and simplifying the supply chain process by providing premix to other businesses. The author had done several projects including the development of an online inventory application, shelf life analysis on partially processed materials and premix, bulk density validation, and new or alternative raw materials assessments within the process development department. The development of online inventory applications using AppSheet platform improved the efficiency of inventory management by integrating all inventory data into a single platform that is accessible from anywhere. The improved system accessibility provided by the online inventory system supported the departments by providing a platform for process development teams to monitor inventory updates in real-time, enabling them to plan trials more effectively creating a more robust and efficient workflow. Furthermore, the partially processed materials stability which were zinc sulphate heptahydrate showed no significant degradation in all parameters indicating the materials were still applicable for further process. Lastly, the bulk density validation project needs to be continued by assessing the premix bulk density based on its dominant raw materials contained in the product because the discrepancy value of theoretical and actual premix bulk density were over than the limit.