A Development of Raw Material Management System for the Bakery Store
Article Sidebar
Main Article Content
Abstract
The purpose of this research is to develop a raw material information management system for bakery businesses in the form of a web application. With the process of analysis and design according to the SDLC method, the system is developed using the PHP language and MySQL database system, the system is evaluated and tested by experts, and the satisfaction of using the system is evaluated by users who own the bakery. The results show that the developed system can work according to the objectives, which is the store owner, who can use the system to manage raw material information. Check the raw materials that need to be ordered and the employees who can use the system to receive the raw materials. The system can automatically calculate safe order points and cut off the stock of raw materials used on a first-in, first-out basis. To solve the problem of the expiration of short-lived raw materials. The system can calculate the average cost of raw materials calculated as a percentage of the actual amount of raw materials. The amount of loss during production is deducted, which is a problem that occurs in bakeries that makes it impossible to calculate the actual cost. The results of the system test by experts showed that the system was able to function correctly and meet the expected results. Results of the overall job satisfaction assessment It was found to be at a very good level. It has an average of 4.58 and a standard deviation of 0.33.
Article Details
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
The content and information in the articles published in the Journal of Science and Technology, Sisaket Rajabhat University reflect the opinions and responsibilities of the respective authors. The editorial board of the journal does not necessarily agree with, nor share responsibility for, these views.
Articles, information, content, images, etc., published in the Journal of Science and Technology, Sisaket Rajabhat University are copyrighted by the Faculty of Science and Technology, Sisaket Rajabhat University. If any individual or organization wishes to republish all or part of the content, or use it for any other purpose, they must obtain written permission from the Journal of Science and Technology, Sisaket Rajabhat University beforehand.
References
Abhiprayasakul, K. (2017). Warehouse cost management. Bangkok: Focus Media and Publishing Company Limited. (in Thai)
Bierig, R., Brown, S., Galván, E., & Timoney, J. (2021). Essentials of software testing. New York: Cambridge University Press.
Buthphorm, O. & Pompubpa, M. (2018). FIFO Toward Warehouse Performance Improvement: A Case Study of Automotive Parts Company. Journal of Administration and Management, 8(1), 60-70. (in Thai)
Date, C.J. (2019). Database design and relational theory: normal forms and all that jazz. Apress.
Iamsiriwong, O. (2023). System analysis and design (additional revised edition). Bangkok: SE-Education Public Company Limited. (in Thai)
Jacob,L. (2017). Bootstrap 4 Quick Start [Online]. Retrieved March 25, 2024, from: https://bootstrapclasses.com/wp-content/uploads/2017/11/bootstrap-tutorial.pdf
Jampathong, B. & Klomklao, H. (2018). Thong Fuan’s Raw Material Management System of Virgin F&B Co., Ltd. Thesis project Bachelor of Business Administration. Rajapruek University. (in Thai)
Paengo, Y., Niamsri, A., Ruphun, C., and Ngewtung, P. (2022). Online Bakery Ordering SystemCase Study: Namfon Bakery. Journal of Management Science, 4(1), 32-46. (in Thai)
Permsin, S. & Munngoen. P. (2024). Defect Reduction in the Puff Pastry Forming Process: A Case Study of Bakery Production Factory. Journal of Science and Technology Thonburi University, 4(1), 32-46. (in Thai)
Sinhirunviwat, K. (2016). Single or Sole Proprietorship. MFU Connexion: Journal of Humanities and Social Sciences, 5(1), 66-86. (in Thai)
Srisa-ard, B. (2017). Basic Research. 10th Edition. Bangkok: Suviriyasan Company Limited. (in Thai)
Sukarno, B.N. (2020). Database Design of Raw Materials Information Systems in Bread Company. International Journal of Computer Trends and Technology, 68(3), 28-34.
Yoddee B. & Chompu-inwai R. (2023). Loss Analysis in Bread Production Process Using Material Flow Cost Accounting Technique. International Journal of Science and Technology, 9, 85-100.
