建構銷售與作業規劃決策支援系統之研究

以作者查詢圖書館館藏

、以作者查詢臺灣博碩士

、以作者查詢全國書目

、勘誤回報

、線上人數：49

、訪客IP：3.15.17.60

姓名

王俊中(Jun-Zhong Wang) 查詢紙本館藏

畢業系所

企業管理學系

論文名稱

建構銷售與作業規劃決策支援系統之研究
(The Construction of Decision Support Systems of Sales and Operations Planning with the Integration of Material and Financial Flows)

相關論文

★ 在社群網站上作互動推薦及研究使用者行為對其效果之影響	★ 以AHP法探討伺服器品牌大廠的供應商遴選指標的權重決定分析
★ 以AHP法探討智慧型手機產業營運中心區位選擇考量關鍵因素之研究	★ 太陽能光電產業經營績效評估－應用資料包絡分析法
★ 建構國家太陽能電池產業競爭力比較模式之研究	★ 以序列採礦方法探討景氣指標與進出口值的關聯
★ ERP專案成員組合對績效影響之研究	★ 推薦期刊文章至適合學科類別之研究
★ 品牌故事分析與比較-以古早味美食產業為例	★ 以方法目的鏈比較Starbucks與Cama吸引消費者購買因素
★ 探討創意店家創業價值之研究- 以赤峰街、民生社區為例	★ 以領先指標預測企業長短期借款變化之研究
★ 應用層級分析法遴選電競筆記型電腦鍵盤供應商之關鍵因子探討	★ 以互惠及利他行為探討信任關係對知識分享之影響
★ 結合人格特質與海報主色以類神經網路推薦電影之研究	★ 資料視覺化圖表與議題之關聯

檔案

[Endnote RIS 格式]

[Bibtex 格式]

[相關文章]

[文章引用]

[完整記錄]

[館藏目錄]

至系統瀏覽論文 ( 永不開放)

摘要(中)

隨著企業規模擴大，供應鏈產銷整合的問題將變得更為複雜，產銷活動順暢與否一直是公司面臨的重要課題之一，如果出貨能力不足，會導致客戶抱怨，進而流失訂單；若貨品庫存量太多，公司會增加資金壓力，讓公司有高的風險虧損，因此在分派公司可用資源的決策考量過程中，往往需要許多不同決策情境試算來輔助產銷計畫的擬定。然而一個公司的產品動輒有數百項，實務上的做法多是由規劃人員自行經由Excel試算表輔以VBA巨集調整出各產品的生產數量與存貨水準，從管理的角度來看，此種方式雖能決定出可行的產銷計畫，但會有如下的問題所在: (1) 因人力有限，往往一個人只能顧及到某幾種產品，加上實務上多以規劃人員的經驗為主，故亦無標準的規劃方式，因此往往所產出的計畫多為可行解而非最佳解；(2) 目前的規劃方式多根據單一部門的角度來估算，無法擬定出多種資源限制下的計畫，而所擬定的計畫多未考慮到財務面的因素，像是應收帳款與應付帳款時間差所造成的現金水位缺口，會造成採購上的困難。
目前企業的ERP系統對供應鏈產銷整合多在資料處理的範疇，通常不牽涉到營運規劃的部分，對企業管理者制訂產銷計畫的決策支援有限。本研究在供應鏈網路環境下，考量短期財務規劃與中期生產規劃決策因素，以供應鏈整體營運資源整合分配的觀點，運用最佳化理論與資料倉儲技術，發展出銷售與作業規劃(Sales and operations planning, S&OP)所需的資料模型與決策模型以解決跨國供應鏈產銷多期多廠問題。本研究的貢獻包括：(1) 從ERP系統模組中找出與生產面及財務面相關之主營運資料(Master Data)欄位，並定義出多維度資料模型；(2) 根據資料模型定義出銷售與作業規劃所需的參數與變數，並在多規劃期多產品的四階供應鏈下，考量產能限制、生產技術限制、配送前置時間與應收應付帳款前置時間等特性建立一個以利潤極大化為績效目標的最佳化決策模型，此模型之產出結果包含建議之採購計畫、生產計畫、存貨計畫與配銷計畫；(3) 考慮到模型於實務應用時會有NP-Complete的問題，本研究提出了啟發式演算法，作為替代方案，之後並以不同的實驗情境比較來驗證求解的品質與效率。
最後為說明提出的模型如何應用，本研究考量企業本身營運狀況及實際運作上可能會面臨的環境選取來情境因子並進行實驗設計以測試不同的情境，訪談之後以產能負荷及、需求波動、製造成本及物流成本四個因子進行高低兩水準的四因子實驗設計，由測試的情境規劃結果可知，本研究所提出的方法論除了兼顧理論與實務，更以決策支援系統觀點從物流、金流與資訊流整合角度來處理問題，在實務應用上對企業應有所幫助。

摘要(英)

Sales and operations planning (S&OP) focus on balancing between supply and demand in a company. It is utilized to ensure the alignment of plans supporting the business strategic goal. To compete production globally and utilizing resources spread several continents, many companies pay special attention to supply chain management. The planning scope can be characterized by three types of flows: The forward material flow that integrates the functions of procurement, production, distribution and sales to satisfy the end customer demands, and the backward information flow that allows each member on the chain to effectively acquire and share data from downstream members. The last type is financial flow. The financial flows operations have many impacts on material flows. When a company has to make capacity allocation between two customer demands, the fact of selecting one has an impact on material flow because payables and receivables frequently influences the inbound and outbound activities.
The aim of our research is to fill in the gap of S&OP in financial planning by presenting a decision model combining material flows and financial flows. The model integrates payment terms, processing times, costs, and prices to make a corporate plan should be executed to optimize business profits subject to budget and capacity. The paper proposes a decision support tool by integrating data model of data warehouse and mathematical model for optimization of S&OP in a company supply chain. To explore the applicability of the present study, a numerical example is considered to determine the sales and operations planning for the decision variables and profit of the company.

關鍵字(中)

★ 供應鏈最佳化
★ 數學規劃
★ 演算法
★ 短期財務規劃
★ 中期生產規劃

關鍵字(英)

★ Supply chain optimization
★ Mathematical planning
★ Mid-term supply chain planning
★ Short-term financial planning

論文目次

Abstract Ι
Table of Contents V
List of Figures VI
List of Tables VII
Chapter 1 Research Motivation and Purpose 1
Chapter 2 Theoretical Framework 5
2-1 Supply chain Planning 5
2-2 Sales and operations planning 8
2-3 Data warehouse 10
Chapter 3 Decision Support System in Sales and Operations Planning 13
3-1 Solution framework 13
3-2 S&OP exploitation in the DSS environment 15
3-3 Designing Multi-dimensional Model for S&OP 19
3-4 MILP Model of Utilizing Multi-dimensional Model for S&OP 23
3-5 Heuristics of Utilizing Multi-dimensional Model for S&OP 31
3-6 Financial Consideration with MILP for S&OP 34
Chapter 4 Case application 44
4-1 Scenario Description and Simulation 44
4-2 Heuristics Effectiveness 50
4-3 Financial Flows Forecast 52
Chapter 5 Conclusions and Future Research 54
References 55
Appendix 58

參考文獻

Affonso, R., Marcotte, F. and Grabot, B., 2008. Sales and operations planning: the supply chain pillar. Production Planning & Control, 19 (2), 132-141.
Ahmad, I., Azhar, S. and Lukauskis, P., 2004. Development of a decision support system using data warehousing to assist builders/developers in site selection, Automation in Construction 13 (4), 525-542.
Bhutta, K.S., Huq, F., Frazier, G. and Mohamed, Z., 2003. An integrated location, production, and investment model for a multinational corporation. International Journal of Production Economics, 86 (3), 201-216.
Chern, C.-C. and Hsieh, J.-S., 2007. A heuristic algorithm for master planning that satisfies multiple objectives. Computers and Operational Research, 34(11), 3491-3513.
Chen-Ritzo, C.-H., Ervolina, T., Harrison, T.P. and Gupta, D., 2010. Sales and operations planning in systems with order configuration uncertainty. European Journal of Operational Research, 205 (3), 604 – 614.
Chen, Y.-T., and Hsu, P.-Y., 2007. A grain preservation translation algorithm: From ER diagram to multidimensional model, Information Sciences 177 (18), 3679 - 3695.
Combes, C., and Rivat, C., 2008. A modelling environment based on data warehousing to manage and to optimize the running of international company, International Journal of Production Economics 112 (1), 294-308.
Dhaenens-Flipo, C.D. and Finke, G., 2001. An integrated model for an industrial production-distribution problem. IIE Transactions, 33 (9), 705-715.
Dutta, G., and Fourer, R., 2008. Database structure for a class of multi-period mathematical programming models, Decision Support Systems 45 (4), 870 - 883.
Ereng??, S.S., Simpson, N.C. and Vakharia, A.J., 1999. Integrated production/distribution planning in supply chains: An invited review. European Journal of Operational Research, 115, 219-236.
Feng, Y., D'Amours, S. and Beauregard, R., 2008. The value of sales and operations planning in oriented strand board industry with make-to-order manufacturing system: Cross functional integration under deterministic demand and spot market recourse, International Journal of Production Economics. 115 (1) , 189-209.
Genin, P. and Lamouri, S., 2005. A. Thomas, Sales and operations planning optimization. Applied Optimization, 94, 191-204.
Genin, P., Thomas, A. and Lamouri, S., 2007. How to manage robust tactical planning with an APS (Advanced Planning Systems). Journal of Intelligent Manufacturing, 18 (2), 209-221.
Goetschalckx, M., Vidal, C.J., and Dogan, K., 2002. Modeling and design of global logistics systems: A review of integrated strategic and tactical models and design algorithms. European Journal of Operational Research, 143, 1-18.
Inmon, W.H., 2005. Building the Data Warehouse, John Wiley & Sons, Inc.
Jang, Y.-J., Jang, S.-Y., Chang, B.-M. and Park, J., 2002. A combined model of network design and production/distribution planning for a supply network. Computers and Industrial Engineering, 43 (1-2), 263-281.
Kimball, R., and Ross, M., 2003. The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses, second ed. Wiley, New York.
Min, H. and Zhou, G., 2002. Supply chain modeling: past, present and future. Computers and Industrial Engineering, 43, 231-249.
Olhager, J., Rudberg, M. and Wikner, J., 2001. Long-term capacity management: Linking the perspectives from manufacturing strategy and sales and operations planning. International Journal of Production Economics, 69 (2), 215-225.
Rudberg, M. and Thulin, J., 2009. Centralised supply chain master planning employing advanced planning systems. Production Planning & Control, 20 (2), 158-167.
Sen, A., and Sinha, A.P., 2005. A comparison of data warehousing methodologies, Communications of the ACM 48 (3), 79-84.
Shim, J.P., Warkentin, M., Courtney, J.F., Power, D.J., Sharda, R., and Carlsson, C., 2002. Past, present and future of decision support technology, Decision Support Systems 33, 111 – 126.
Yeh, W.-C., 2005. A hybrid heuristic algorithm for the multistage supply chain network problem. International Journal of Advanced Manufacturing Technology, 26, 675-685.
Vidal, C. J., and Goetschalckx, M., 1997. Strategic production-distribution models: A critical review with emphasis on global supply chain models. European Journal of Operational Research. 98, 1-18.
Zhou, G., Min, H., and Gen, M., 2002. The balanced allocation of customers to multiple distribution centers in the supply chain network: a genetic algorithm approach, Computers and Industrial Engineering. 43, 251-261.

指導教授

許秉瑜(Ping-Yu Hsu)

審核日期

2011-1-18

推文