KMITL Expo 2026 LogoKMITL 66th Anniversary Logo

Productivity Improvement in Warehouse Using Power BI and Power Automate

Productivity Improvement in Warehouse Using Power BI and Power Automate

Abstract

This cooperative education project aims to enhance speed and facilitate the verification process for stock issuance, transfers, distributions, and receipts in the warehouse. The primary focus is to address issues related to wasted time and delays in operational processes. Through analysis, it was found that SAP, the current system, involves complex processes requiring specialized expertise. Although the company has developed the iWarehouse system to improve efficiency, delays and procedural complexity persist. To resolve these challenges, Power BI was utilized to visualize data related to stock issuance, transfers, distributions, and receipts, allowing warehouse staff to work more efficiently by minimizing waste and accelerating processes. Additionally, Power Automate was integrated to automate the processing of received stock numbers from emails, reducing errors and delays caused by manual data entry. The results of this improvement indicate a significant increase in employee efficiency and a noticeable reduction in wasted time. Upon project completion, the findings and development approach will be provided to the company for further enhancement.

Objective

เนื่องจากในกระบวนการทำงานในคลังสินค้า ในหน่วยงานส่วนจัดหาและบริหารพัสดุ กรณีศึกษาบริษัท ปตท. จำกัด (มหาชน) ศูนย์ปฏิบัติการชลบุรี มีเวลาสูญเปล่าเกิดขึ้นเป็นจำนวนมาก และมีกระบวนการทำงานที่ซับซ้อน และยังขาดเครื่องมือหรือเทคโนโลยีสมัยใหม่

Other Innovations

Dream High Packaging Protection from Mycelium

คณะบริหารธุรกิจ

Dream High Packaging Protection from Mycelium

In a world increasingly focused on sustainability and reducing environmental impact, DreamHigh is pioneering an innovative approach to packaging solutions using mycelium—a natural, biodegradable, and renewable material derived from fungi. Our mission is to revolutionize the packaging industry by offering eco-friendly alternatives that not only reduce waste but also align with global efforts to combat climate change. Mycelium packaging offers a compelling alternative to traditional plastic and Styrofoam packaging, which contribute significantly to environmental pollution. It is fully biodegradable, compostable, and capable of breaking down in natural environments within weeks, leaving no toxic residues behind. Additionally, mycelium-based products are lightweight, durable, and customizable, making them suitable for a wide range of applications, from consumer goods packaging to protective shipping materials. DreamHigh’s business plan outlines a scalable production process leveraging advanced mycelium cultivation techniques and partnerships with local agricultural sectors to utilize agricultural waste as a key raw material. This not only ensures cost-efficiency but also supports a circular economy by repurposing waste that would otherwise be discarded.

Read more
The Innovative Role of Recycled Aggregates in Concrete for Future Construction

คณะวิศวกรรมศาสตร์

The Innovative Role of Recycled Aggregates in Concrete for Future Construction

This research suggested natural hemp fiber-reinforced ropes (FRR) polymer usage to reinforce recycled aggregate square concrete columns that contain fired-clay solid brick aggregates in order to reduce the high costs associated with synthetic fiber-reinforced polymers (FRPs). A total of 24 square columns of concrete were fabricated to conduct this study. The samples were tested under a monotonic axial compression load. The variables of interest were the strength of unconfined concrete and the number of FRRlayers. According to the results, the strengthened specimens demonstrated an increased compressive strength and ductility. Notably, the specimens with the smallest unconfined strength demonstrated the largest improvement in compressive strength and ductility. Particularly, the compressive strength and strain were enhanced by up to 181% and 564%, respectively. In order to predict the ultimate confined compressive stress and strain, this study investigated a number of analytical stress–strain models. A comparison of experimental and theoretical findings deduced that only a limited number of strength models resulted in close predictions, whereas an even larger scatter was observed for strain prediction. Machine learning was employed by using neural networks to predict the compressive strength. A dataset comprising 142 specimens strengthened with hemp FRP was extracted from the literature. The neural network was trained on the extracted dataset, and its performance was evaluated for the experimental results of this study, which demonstrated a close agreement.

Read more
Real time mosquito counter by ripple detection system

คณะวิศวกรรมศาสตร์

Real time mosquito counter by ripple detection system

The designing of mosquitoes counting system instrument is presented in this work. The mosquitoes that were counted died in order not to measure duplicate counting data. As soon as the input source counting machine can detect the mosquito, the single trigger signal is transmitted to the IOT system to interrupt the server immediately. The number of real mosquito is not transmitting to the IOT but only a signal to interrupt the server. The server records the number of the interrupt signal with real-time clock. Then the interrupt information will be further handled. The front end counting machine consist of the high voltage generate with the suitable voltage value and electrode distance for the required mosquitoes size. The low trigger pulse signals of the mosquitoes killed by high voltage are sending to the controller unit. Immediately, interrupt counting signal of the number of mosquitoes is sent to the big stream data collection on IOT system by the time stamp technique. Form the measurement results, 10 live sample mosquitoes in a limited space box to fly though the counting machine show that the count results are 100% correct count.

Read more