在數位轉型情境下，中小企業雖多已導入ERP系統，惟補貨決策仍常因資料分散、更新延遲與缺乏標準化計算邏輯，而高度仰賴人工經驗判斷，導致決策耗時、資訊不一致，並衍生缺料與庫存偏高等問題。本研究以工業潤滑油製造企業為個案場域，依循自働生產管理環(Jidoka–JIT Cycle, JJC)理念，建構基於ERP資料之雲端智慧補貨決策系統。本系統以Google Workspace為基礎，結合Google Apps Script串接ERP匯出資料，並透過Data Studio建置視覺化報表，形成雲端資料自動化流程、標準化補貨運算及異常警示監控機制。同時，運用資訊流圖(Information Stream Mapping, iSM)量化評估系統導入前後之資訊流效率。導入後，資訊流之自動化、中心化與即時化程度皆明顯提升，採購補貨決策作業時間由4小時縮短至1小時，有效改善資訊流動與作業效率。為提升補貨策略之適配性，進一步提出同時考量使用價值、需求型態與供應限制之三維補貨分類框架，並依分類結果指派差異化補貨策略。模擬結果顯示，三維分類差異化補貨策略相較於經驗法則可降低平均庫存價值約30.4%，相較於單一標準化補貨策略亦可降低約8.2%，並在維持相對穩定服務水準之前提下，降低補貨作業負荷。綜合而言，本文提出一套具實務導入可行性於中小企業之雲端補貨決策支援流程，能有效提升資訊流效率、補貨決策一致性與存貨管理績效。

In the context of digital transformation, many small and medium-sized enterprises have adopted ERP systems; however, replenishment decisions often remain dependent on human experience due to dispersed data, delayed updates, and the lack of standardized calculation logic. This study takes an industrial lubricant manufacturing company as the case context and develops a cloud-based intelligent replenishment decision system based on ERP data, following the concept of the Jidoka–JIT Cycle (JJC).
The proposed system is built on Google Workspace, integrates ERP-exported data through Google Apps Script, and uses Data Studio to construct visualized reports. It establishes an automated cloud-based data process, standardized replenishment calculations, and abnormality alert mechanisms. Information Stream Mapping (iSM) is also applied to evaluate the improvement in information flow efficiency before and after implementation.
The results show that the system improves the automation, centralization, and real-time availability of information flow. The replenishment decision-making time was reduced from four hours to one hour. In addition, the proposed three-dimensional replenishment classification framework, which considers usage value, demand pattern, and supply constraints, reduced average inventory value by approximately 30.4% compared with the experience-based rule and by approximately 8.2% compared with a single standardized replenishment strategy, while maintaining a relatively stable service level.

經濟部中小及新創企業署. (2025). 2025年中小企業白皮書. https://www.sme.gov.tw/article-tw-2345-13928
Cardós, M., & Babiloni, E. (2011). Exact and approximate calculation of the cycle service level in periodic review inventory policies. International Journal of Production Economics, 131(1), 63–68.
Coussement, K., Abedin, M. Z., Kraus, M., Maldonado, S., & Topuz, K. (2024). Explainable AI for enhanced decision-making. Decision Support Systems, 184, 114276.
De Bock, K. W., Coussement, K., De Caigny, A., Słowiński, R., Baesens, B., Boute, R. N., Choi, T.-M., Delen, D., Kraus, M., & Lessmann, S. (2024). Explainable AI for operational research: A defining framework, methods, applications, and a research agenda. European Journal of Operational Research, 317(2), 249–272.
Google. (2026a). Data Studio. Retrieved May 2, 2026 from https://cloud.google.com/data-studio
Google. (2026b). Google Workspace. Retrieved May 2, 2026 from https://workspace.google.com/resources/
Google Cloud. (2026). Gemini CLI. Retrieved May 2, 2026 from https://docs.cloud.google.com/gemini/docs/codeassist/gemini-cli
Google Developers. (2025). Hands-on with Gemini CLI. Retrieved April 8, 2026 from https://codelabs.developers.google.com/gemini-cli-hands-on
Google for Developers. (2026, April 20). Google Apps Script Overview. Retrieved May 2, 2026 from https://developers.google.com/apps-script/overview
Gupta, P., Seetharaman, A., & Raj, J. R. (2013). The usage and adoption of cloud computing by small and medium businesses. International Journal of Information Management, 33(5), 861–874.
Haddud, A., DeSouza, A., Khare, A., & Lee, H. (2017). Examining potential benefits and challenges associated with the Internet of Things integration in supply chains. Journal of Manufacturing Technology Management, 28(8), 1055–1085.
Hines, P., & Rich, N. (1997). The seven value stream mapping tools. International Journal of Operations & Production Management, 17(1), 46–64.
Ivanov, D. (2022). Viable supply chain model: integrating agility, resilience and sustainability perspectives—lessons from and thinking beyond the COVID-19 pandemic. Annals of Operations Research, 319(1), 1411–1431.
Kobeissi, M., Assy, N., Gaaloul, W., Defude, B., Benatallah, B., & Haidar, B. (2023). Natural language querying of process execution data. Information Systems, 116, 102227.
Koumanakos, D. P. (2008). The effect of inventory management on firm performance. International Journal of Productivity and Performance Management, 57(5), 355–369.
Lolli, F., Ishizaka, A., Gamberini, R., & Rimini, B. (2017). A multicriteria framework for inventory classification and control with application to intermittent demand. Journal of Multi‐Criteria Decision Analysis, 24(5-6), 275–285.
Marston, S., Li, Z., Bandyopadhyay, S., Zhang, J., & Ghalsasi, A. (2011). Cloud computing—The business perspective. Decision Support Systems, 51(1), 176–189.
Maxwell, W. L., & Muckstadt, J. A. (1985). Establishing consistent and realistic reorder intervals in production-distribution systems. Operations Research, 33(6), 1316–1341.
Model Context Protocol. (2025). Model Context Protocol Specification. Model Context Protocol. https://modelcontextprotocol.io/specification/2025-11-25
Petropoulos, F., Makridakis, S., Assimakopoulos, V., & Nikolopoulos, K. (2014). ‘Horses for Courses’ in demand forecasting. European Journal of Operational Research, 237(1), 152–163.
Ramanathan, R. (2006). ABC inventory classification with multiple-criteria using weighted linear optimization. Computers & Operations Research, 33(3), 695–700.
Roh, P., Kunz, A., & Wegener, K. (2019). Information stream mapping: Mapping, analysing and improving the efficiency of information streams in manufacturing value streams. CIRP Journal of Manufacturing Science and Technology, 25, 1–13.
Sugimori, Y., Kusunoki, K., Cho, F., & Uchikawa, S. (1977). Toyota production system and kanban system materialization of just-in-time and respect-for-human system. The International Journal of Production Research, 15(6), 553–564.
Syntetos, A. A., Boylan, J. E., & Croston, J. D. (2005). On the categorization of demand patterns. Journal of the Operational Research Society, 56(5), 495–503.
Tajbakhsh, M. M. (2010). On the distribution free continuous-review inventory model with a service level constraint. Computers & Industrial Engineering, 59(4), 1022–1024.
Theodorou, E., Spiliotis, E., & Assimakopoulos, V. (2023). Optimizing inventory control through a data-driven and model-independent framework. EURO Journal on Transportation and Logistics, 12, 100103.
Tokar, T. (2010). Behavioural research in logistics and supply chain management. The International Journal of Logistics Management, 21(1), 89–103.
Torabi, S. A., Hatefi, S. M., & Pay, B. S. (2012). ABC inventory classification in the presence of both quantitative and qualitative criteria. Computers & Industrial Engineering, 63(2), 530–537.
van Donselaar, K., Broekmeulen, R., & de Kok, T. (2021). Heuristics for setting reorder levels in periodic review inventory systems with an aggregate service constraint. International Journal of Production Economics, 237, 108137.
Wang, L., & Chen, H. (2022). Optimization of a stochastic joint replenishment inventory system with service level constraints. Computers & Operations Research, 148, 106001.
Yang, T., & Fujimoto, T. (2026). Jidoka just-in-time cycle – from genba kaizen to the introduction of artificial intelligence. International Journal of Production Research. https://doi.org/10.1080/00207543.2026.2656950
Yarbrough, A. C., Harris, G. A., & Purdy, G. T. (2022). Improving the flow of data and information in manufacturing. Manufacturing Letters, 32, 1–4.
Yigitbasioglu, O. M., & Velcu, O. (2012). A review of dashboards in performance management: Implications for design and research. International Journal of Accounting Information Systems, 13(1), 41–59.