KMITL Innovation 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

CO Breathalyzer with Voice Response

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

CO Breathalyzer with Voice Response

CO Breathalyzer with Voice Response is the device to measured the level of CO residual in a person's lung who consume tobacco. Measuring residual CO in human breath can identify the tobacco addiction level instead of measuring nicotine in blood.

Read more
Study on the Production Process and Shelf-Life Preservation of  Plant-Based Crab Cake under Refrigerated Conditions (Lab Scale)

คณะอุตสาหกรรมอาหาร

Study on the Production Process and Shelf-Life Preservation of Plant-Based Crab Cake under Refrigerated Conditions (Lab Scale)

Plant-based refers to food or products that are primarily made from plants. It can be divided into two categories: one is food that comes entirely from plants and does not include any animal products, and the other is food that contains small amounts of animal products, such as products that contain milk and eggs in limited quantities, which may also be considered part of the definition of plant-based. Plant-based meat products that closely resemble real meat and attract consumers are considered a relatively new innovation. Although tofu, tempeh, and seitan have been around for a long time, recent discoveries have led to the production of plant-based meat products that provide a sensory experience, making it difficult for consumers to distinguish between real meat and plant-based meat. Furthermore, the development of plant-based food products must prioritize quality and safety to maximize consumer benefits. Textured Vegetable Protein (TVP) is a plant-based protein made from soybeans using an extruder. It is used as a primary ingredient in the production of plant-based food products due to several advantages. These include: • High Protein Content: TVP is made from soybeans with the fat extracted, resulting in a high protein content. • Texture: When rehydrated, TVP has a texture that closely resembles meat. • Versatility: TVP has a neutral flavor, allowing it to easily absorb the flavors of various seasonings and sauces. • Cost-Effectiveness: Compared to other protein sources, TVP is relatively inexpensive while providing desirable characteristics. These benefits make TVP an attractive option in the production of plant-based foods. This study focuses on developing TVP into a plant-based crab cake and investigating the shelf life of the product in a tightly sealed container under refrigeration. It also analyzes the hygiene and cleanliness of the production process and how these factors affect the presence or growth of microorganisms that may pose a risk to consumers, referencing the cold food safety standards of Thailand. Finally, recommendations for cleaning operational areas will be provided to establishments as a guideline for developing preliminary food safety procedures in laboratory settings.

Read more
Development of Terminalia Chebula Retz. Extract loaded Edible Film for mouth against wound

คณะอุตสาหกรรมอาหาร

Development of Terminalia Chebula Retz. Extract loaded Edible Film for mouth against wound

This study focused on the development of an edible film containing Terminalia chebula Retz extract for the treatment of oral ulcers. The film was designed to dissolve in the mouth without the need for swallowing or chewing, which is suitable for people with canker sores or oral inflammation. Terminalia chebula extract has been shown to have several pharmacological properties, including antimicrobial, antioxidant, and anti-inflammatory activities.

Read more