Page Header Logo Applied Science and Engineering Progress

Home > ONLINE FIRST > Kengpol

A Dynamic Cost Estimation Framework for Customized Manufacturing: A Case Study of the Ambulance Assembly Industry

Athakorn Kengpol, Thosawat Raksakul

Abstract


The customized manufacturing industry faces a major challenge in achieving accurate and rapid cost estimation. The difficulty arises from product complexity and diverse data generated across multiple departments. This often results in scattered and outdated information that causes operational delays and reduces competitive advantage. The study proposes an Engineering Framework for Dynamic Cost Estimation through data integration with Power BI serving as the core platform. The framework was implemented and validated through a case study in the ambulance assembly industry, which represents a highly complex manufacturing sector. The quantitative results show that the proposed framework reduces the time required for ambulance type determination by 54.7% and decreases cost estimation time by 61.6%. These improvements address the specific challenges identified in the case study and also enhance overall operational efficiency. The findings provide a significant contribution to the advancement of manufacturing engineering. The research also delivers a validated model and knowledge that can be adapted to improve efficiency in other customized manufacturing sectors.

Keywords



[1]    K. O. Ogunsola et al., “Optimizing operational efficiency through business intelligence and data-driven strategic decision-making,” International Journal of Academic Management Science Research, vol. 9, no. 3, pp. 124–132, 2025.

[2]    G. Steven and H. Lauren, “Mapping COVID-19 in Los Angeles with Power BI,” Terra Digitalis International e-journal of Maps, vol. 4, no. 2, pp. 1–5, 2020.

[3]    V. Lorenzo et al., “Developing a growth learning data mindset: A secondary school approach to creating a culture of data driven improvement,” Journal of Learning Analytics, vol. 9, no. 2, pp. 87–104, 2022.

[4]    R. Adhikari et al., “Data visualization in tableau using a hypothetical dataset,” Journal of Emerging Technologies and Innovative Research, vol. 11, no. 3, pp. 1–12, 2024.

[5]    P. Rupesh, “Comparative analysis of data visualization tools: Power BI and tableau,” International Journal of Scientific Research in Engineering and Management, vol. 7, no. 10, pp. 2–3, 2023.

[6]    R. Podeschi, “Experiential learning using qlikview business intelligence software,” Information Systems Education Journal, vol. 13, no. 4, pp. 71–80, 2015.

[7]    F. Jeremy and H. Sue, “Reviewing ambulance design for clinical efficiency and paramedic safety,” Applied Ergonomics, vol. 36, no. 1, pp. 97–105, 2005.

[8]    K. Yulia, V. Fulgencia, and V. Eva, “Realistic strategies for dynamic ambulance relocation,” Socio-Economic Planning Sciences, vol. 101, p. 102279, 2025.

[9]    S. Prachasarn. “Fishbone diagram and mind map.” prachasan.com.  Accessed: Oct. 10, 2024. [Online]. Available: http://www.prachasan.com/ mindmapknowledge/fishbonem.

[10]  J. Narisara. “Knowledge Sheet on Fishbone Diagram.” pubhtml5.com. Accessed: Oct. 11, 2024. [Online]. Available: https://pubhtml5.com/ hehc/amqi/basic/.

[11]  K. Swapna, “XML based representation of DFD removal of diagramming ambiguity,” International Journal of Advanced Computer Science and Applications, vol. 2, no. 8, pp. 22–24, 2011.

[12]  S. Natthahan, “Development of the alumni database system, Faculty of Science and Technology, Phetchaburi Rajabhat University,” M.S. thesis, Department of Information Science for Education, Graduate School, Silpakorn University, Nakhon Pathom, Thailand, 2017 (in Thai).

[13]  A. Ophas, Database Design and Management. Bangkok: SE-ED Education, 2002, pp. 409–438.

[14]  T. Ezhilarasi and S. Jaswanth, “A study on implementation of power BI dashboards to streamline business processes,” International Journal for Research in Applied Science and Engineering Technology, vol. 1, no. 7, pp. 1–6, 2024.

[15]  P. Claudiu, M. Niculae, and C. Radu. “Business intelligence development with power BI applied nonconventional technologies.” research.ebsco.com. Accessed: Mar. 15, 2025. [Online]. Available: https://research.ebsco.com/c/4jxjv6/viewer/pdf/tk6wjfcunv

[16]  S. Chat, “Design of database management program to reduce working time in the Industrial Engineering,” M.S. thesis, Faculty of Engineering, King Mongkut’s University of Technology North Bangkok, Bangkok, Thailand, 2021 (in Thai).

[17]  Z. Xiaotao and M. Fuxin, “Dynamic estimation method of construction cost based on particle swarm optimization algorithm,” in IEEE Global Conference for Advancement in Technology (GCAT), 2023, pp. 1–6.

[18]  R. N. Diyana, “The perception and usage of google drive among higher education institution students in Brunei Darussalam,” International Journal of Asian Business and Information Management, vol. 12, no. 3, pp. 223–241, 2021.

[19]  M. Paul. “Principles of Computer Security.” accessengineeringlibrary.com. Accessed: Oct. 11, 2024. [Online]. Available: https://www. accessengineeringlibrary.com/content/book/9781260474312/chapter/chapter18#/c9781260474312ch18lev1sec04

[20]  S. Alaa. “Students’ acceptance of file sharing systems as a tool for sharing course materials: The case of Google Drive.” springer.com.  Accessed: Feb. 11, 2025. [Online]. Available: https://link.springer.com/article/10.1007/s10639-016-9556-z

[21]  B. Hossein, K. Maryam, and D. Kimia, “The impact of google-drive e-portfolio assessment on EFL learners’ attitudes and emotions,” sciencedirect.com. Accessed Mar. 15, 2025. [Online]. Available: https://www.sciencedirect.com/ science/article/pii/S8755461524000434

[22]  I. Hiromi, O. Ryoya, and Y. Hirokazu. “Forensic discrimination of fiber microspectrophotometry data by resampling and repeating two-sample hypothesistesting.” sciencedirect.com. Accessed: Mar. 15, 2025. [Online]. Available: https://www. sciencedirect.com/science/article/abs/pii/S0026265X24015522

[23]  C. Douglas and C. George, Applied Statistics and Probability for Engineers, 6th ed., Hoboken, N.J.: Wiley, 2014, pp. 376–378.

[24]  J. R. Naphadon and P. Manwika, Organizational Performance Evaluation Tools. Bangkok: Imagining Group, 2009, pp. 85–92.

[25]  K. Phongsada. “Development of project tracking system of the Faculty of Science and Technology.” research.rmutsb.ac.th. Accessed: Sep. 25, 2024. [Online]. Available: https://research. rmutsb.ac.th/fullpaper/2558/2558240240280.pdf

[26]  A. Michael and S. Mario, “Estimating the population variance, standard deviation, and coefficient of variation: Sample size and accuracy,” Computational Statistics & Data Analysis, vol. 172, p. 107491, 2022.

[27]  R. Christina, Statistics: Open for Everyone. Los Angeles Valley College: LibreTexts libraries, 2024, pp. 73–74.

[28]  H. Trapp. “Benefits of an intranet-based knowledge management system measuring the effect.” avinci.delcompetence.  Accessed: Feb. 11, 2025. [Online]. Available: http://www. avinci.delcompetence/publikatinoeu/diplomarbeitholgetrapp.pdf

[29]  G. Narasimhaiah, S. Toni, and W. Betty. “Organizational impact of system quality, information quality and service quality.” sciencedirect.com. Accessed: Mar. 14, 2025. [Online]. Available: https://www.sciencedirect. com/science/article/pii/S0963868710000181/pdfft?md5=24cec1897f8b35b51f3afdca3b4caf1d&pid=1-s2.0- S0963868710000181-main.pdf

[30] K. Athakorn and P. Kringkrai, “Development of a database management system for reducing time to prepare documents of procurement spare parts and maintenance: A case study in a logistic industry,” project report, Department of Industrial Engineering, Faculty of Engineering, King Mongkut’s University of Technology North Bangkok, Bangkok, Thailand, Mar. 20, 2019 (in Thai).

[31] P. Thawatchai, T. Chertchai, and T. Tongtang, “Work study and standard time for processing dragon jars: Case study of a dragon jar,” presented at the Faculty of Industrial Technology Conference, Muban Chombueng Rajabhat University, Ratchaburi, Thailand, Jun. 13–15, 2022 (in Thai).

[32]  S. Chumphon, Management Information System, 2nd ed., Bangkok, Thailand: P. Sampanpanit, 2000, pp. 158–165.

[33]  K. Athakorn et al., “Design of web application program for reducing processing time of raw material incoming in an appliance industry,” Applied Science and Engineering Progress, vol. 13, no. 4, pp. 370–376, 2020, doi: 10.14416/j.asep.2020.04.001.

[34]  K. Jayaraman and S. Jain, “Leveraging power BI for advanced business intelligence and reporting,” International Journal for Research in Management and Pharmacy, vol. 19, no. 11, pp. 21–36, 2024.

Full Text: PDF

Refbacks

  • There are currently no refbacks.


Copyright © 2025 by King Mongkut’s University of Technology North Bangkok. All rights reserved.