| 摘要: | 存貨數量的制訂對企業一直以來都是重要的課題，貨品庫存量不足，可能會導致客戶抱怨，進而流失訂單；貨品庫存量太多，則會增加資金壓力，讓公司有較高的風險虧損，因此，該如何規劃調適公司各項資源進而制定一個適當的服務水準(Service Level,SL)與安全庫存量(Safety Stock,SS)是許多公司正面臨的問題。在過去學術研究中，主要針對以單一品項的數學存貨模型推導為主，而同時考慮多品項安全庫存的存貨模型所能處理的品項有限，且未能針對完成品進行存貨改善，加上根據我們所知，目前全球ERP系統中，並無輔助制訂安全存貨的功能涵蓋在標準的ERP模組中，因此本研究試著在ERP既有的產品資訊與銷貨記錄中，藉由資料探勘(Data Mining)技術中關聯規則(Association Rule)的運用，找出哪幾種產品是具有銷售上的關聯性，並進一步設計演算法來同時調整這些產品的服務水準，最後計算出安全存貨的建議值。 在系統實作應用上，本研究以SAP公司的ECC6.0 ERP系統為基礎，使用ABAP程式語言撰寫所設計的演算法，為了驗證本研究所提出方法的可行性，會以系統銷售的歷史資料進行來進行系統模擬，從模擬結果中可發現，如採用本研究所提的方法，不但能找出銷售關聯性高的產品，且能同時計算出合適的安全存貨量，作為規劃人員的參考依據。 For businesses, the stock has been the formulation of the number of important issues. If the portfolio stock, this could lead to customer complaints, then the loss of orders; if too much inventory of goods, will increase the financial pressure, so the company will have a higher risk of loss. Therefore, how to adapt the company planning the resources, then develop an appropriate service levels and safety stock, many companies are facing problems. In the past academic research, the main items for a single mathematical model is derived mainly inventory, while many items to consider safety stock inventory model can handle limited and items and not for finished goods for inventory improvement. According to our knowledge, the current global ERP system, no auxiliary functions to formulate the safety stock included in the standard ERP modules. Therefore, this study tried to existing product information in the ERP and sales records, data mining technology by the use of association rules to find out what kinds of products with sales of relevance, and further design algorithm to simultaneously adjust the service level of these products, and finally calculate the value of safety stock recommendations. Applications in the system implementation, this study SAP ECC6.0 system based on ABAP programming language used to write the design algorithms. To prove the feasibility of the proposed method, the system will be the historical sales data for system simulation. From the simulation results can be found, such as the use of this research proposed scheme not only able to identify the products with high sales associate, and can also calculate the appropriate safety stock level, as the planners of reference. |
