| 研究生: |
黃俊達 Huang, Jun-Ta |
|---|---|
| 論文名稱: |
商業智慧應用於資金管理之研究 A Study of Applying Business Intelligence in Working Capital Management |
| 指導教授: |
李昇暾
Li, Sheng-Tun |
| 學位類別: |
碩士 Master |
| 系所名稱: |
管理學院 - 經營管理碩士學位學程(AMBA) Advanced Master of Business Administration (AMBA) |
| 論文出版年: | 2012 |
| 畢業學年度: | 100 |
| 語文別: | 中文 |
| 論文頁數: | 61 |
| 中文關鍵詞: | 商業智慧 、資料倉儲 、營運資金 |
| 外文關鍵詞: | Business intelligence, Data warehouse, working capital |
| 相關次數: | 點閱:126 下載:3 |
| 分享至: |
| 查詢本校圖書館目錄 查詢臺灣博碩士論文知識加值系統 勘誤回報 |
資金是支持企業營運活動的根本,無法即時獲得適量的營運資金為企業經營失敗的主因之一。營運資金管理為財務主管經常性營運決策的核心工作之一,然而,目前並無有效的資金預測技術,加上經濟環境變化莫測,產業結構及交易型態複雜,金融商品眾多等等因素,加劇資金管理的困難度。本研究採個案探討的方式,希望藉由商業智慧(BI)雛型系統的模擬建置,協助個案公司營運資金的管理更有效率、更正確,並能提供預測模擬資訊以利決策判斷的參考。
鑑於大多數企業於資金管理上並無系統以茲支援,故本研究建置一BI雛型系統導入資金管理層面,希冀為企業之決策擬定所帶來之助益包含(一)企業於專案進行前或特殊需求時,執行BI的模擬功能獲取資金變動之影響,藉由不同之模擬結果,選擇最佳的決策方案。(二)由BI即時產生的各項資金報表,決策管理階層可清楚掌握資金整體概況,並依決策需求進行各樣查詢分析;亦可藉由每日資金的詳細時程表,進行資金變動的監控,一旦不符即刻採取因應措施;並與外部銀行匯率連結,隨時計算匯兌損益影響數,以茲作為換匯時點的參考。(三)編製以現金為基礎之報表,可提供為預算編列時之參考或特定專題分析時,改變營運活動之參考資訊。
Working capital (WC) is critical for business success. As a matter of fact, one of the major reasons for going bankruptcy is capital shortage in Taiwan. On the other hand, working capital management is key function for chief financial officers (CFOs).In practice,there is no effective way in predicating working capital.And the working capital management become more difficult because of the unpredictable economic environment, the complexity of the industrial structure , trading patterns, and many financial products etc.. This is a study of using BI system to integrate working capital management to provide timely, correct and forecasting information for decision-makers.
For most businesses,there is no any system to support their working capital management. And this study built a BI system to help. The beneficial results after integrating BI system into working capital management are (1) predicting the several projects’ movement of working capital,and then choice the best one. (2) automatically preparing working capital statement,so that decision-makers could catch the overall situations of working capital. Also could get the details and monitor the implementation.BI system planed for linking the exchange rate from bank, and calculating exchange gains or losses on time. According to the exchange gains or losses, decision-makers could hereby as a swap point of reference. (3)providing the information of budget or other subjects in cash flow basic. To base on these information, the business could improve the operating activities.
一. 中文部分
1. 尹相志,SQL Server 2008 OLAP多維度分析,台北市:精誠資訊,中華民國98年。
2. 呂長軒,基於商業智慧之學術平衡計分卡系統,國立成功大學資訊管理研究所碩士論文,中華民國99年。
3. 林桂香,企業營運資金供需與產業季節指數關聯性之研究-以記憶體模組產業為例,國立臺北大學,中華民國99年。
4. 吳涵雯,景氣變動對營運資金管理之影響與相關議題之研究,國立成功大學會計系博士論文,中華民國91 年。
5. 徐俊明,財務管理原理,二版,雙葉書廊,中華民國95 年。
6. 張柏齡,資料倉儲建立研究及成果,中原大學資訊管理學系碩士論文,中華民國91 年。
7. 國立中央大學管理學院 ERP 中心,「商業智慧」,滄海書局,中華民國100年。
8. 張智浩,「邁克爾‧波特的戰略智慧」,憲業企管顧問有限公司,中華民國96年。
9. 莊立民譯,策略管理(Strategic management:formulation,implementation,and control,8th ed.),美商麥格羅‧希爾國際股份有限公司台灣分公司,麗文文化事業股份有限公司,中華民國94年。
10. 陳隆麒,當代財務管理,二版,華泰書局,中華民國93 年。。
11. 黃小雲,我國企業營運資金管理相關議題之實證研究—產業效果、流動性及短期融資之探討,國立成功大學會計系碩士論文,中華民國90年。
12. 曾守正、周韻寰,資料庫系統應用實務:SQL Sever 2008版,華泰書局,中華民國99 年。
13. 謝劍平,財務管理:新觀念與本土化四版,智勝文化,中華民國95 年。
二.英文部分
14. Bernstein, P. A., & Haas, L. M. (2008). Information integration in the enterprise. (Li, Shue, & Lee, 2008), 51(9), 72.
15. Buytendijk, F., (2001). The BI Framework Provides Return of Integration.Gartner Group, Research Note SPA-13-8990, 11 Jully.
16. Chee, T., Chan, L. K., Chuah, M. H., Tan, C. S., Wong, S. F. & Yeoh, W.(2009). Business Intelligence Systems: State-of-the-Art Review and Contemporary Applications. Symposium on Progress in Information & Communication Technology , Vol. 2 , No. 4, pp. 16-30.
17. Deloof.(2003). M. Does Working Capital Management affect profitability of Belgian Firms? Journal of Business Finance & Accounting, Vol.30 No 3 & 4, pp 573-587.
18. Davis, M. (2002). Using business intelligence for competitive advantage.CRMToday.
19. E. Pourabbas, M. Rafanelli(2000) . Hierarchies and Relative Operators in the OLAP Environment. SIGMOD Record,Vol. 29, No.1, pp. 32-37
20. Eljelly, A. (2004). Liquidity-Profitability Tradeoff: An empirical investigation in an emerging market.International Journal of Commerce & Management, Vol 14 No 2, pp 48-61.
21. Inmon, W. H. (2005). Building the Data Warehouse (4 ed.). New York: Wiley.
22. Imran Omer Chhapra and Nousheen Abbas Naqvi.(2010). Relationship between Efficiency Level of Working Capital Management and Profitability of Firms in the Textile Sector of Pakistan. Indus Journal of Management & Social Sciences, 4 (1):30-42
23. K. W. Chau, Ying Cao, M. Anson, Jianping Zhang(2002). Application of data warehouse and Decision Support System in construction management. Automation in Construction, Vol. 12, pp.213-224, www.elsevier.com/locate/autcon.
24. Lazaridis, J.; Tryfonidis, D (2006). Relationship between working capital management and profitability of listed companies in the Athens Stock Exchange. Journal of Financial Management and Analysis.Vol. 19 (1), pp 26-35.
25. Larissa T. Moss, & Shaku Atre (2003).Business Intelligence Roadmap: The Complete Project Lifecycle for Decision-Support Applications (1st ed.).Boston, MA: Addison-Wesley.
26. Li, S.-T., Shue, L.-Y., & Lee, S.-F. (2008). Business intelligence approach to supporting strategy-making of ISP service management. Expert Systems with Applications, 35(3), 739-754.
27. Marks, Wendy T., and Frolick, Mark N.(2001). Building Customer Data Warehouses for a Marketing and Service Enviromnet: A Case Study. Information Systems Management, Vol.18 Issue 3, pp. 51-56
28. Mike Biere (2003). Business intelligence for the enterprise (1st ed.).Bilbao,Spain: IBM Press.
29. Osisioma, B. C. (1997). Sources and Management of Working Capital. Journal of Management Science, 2, (January).
30. Padachi K. (2006). Trends in Working Capital Management and Its Impact on Firms’ Performance: An Analysis of Mauritian Small Manufacturing Firms. International Review of Business Research Papers, 2 (2):45 -58.
31. Rouibah, K., & Ould-ali, S. (2002). PUZZLE: a concept and prototype for linking business intelligence to business strategy. Journal of Strategic Information Systems, 11(2), 133-152.
32. Raheman, A. and Nasr, M. (2007). Working Capital Management and Profitability – Case Of Pakistani Firms. International Review of Business Research Papers, 3 (1), 279-300.
33. Ranjan, J. (2008). Business justification with business intelligence. Vine, 38(4), 461-475.
34. Sell, D., Cabral, L., Motta, E., Domingue, J., & Pacheco, R. (2005). Adding Semantics to Business Intelligence. Processings of the 16th International Workshop on Database and Expert Systems Applications.
35. Surajit Chaudhuri,Umeshwar Dayal,and Vivek Narasayya(2011). BI technologies are essential to running today’s businesses and this technology is going through sea changes. Communications of the ACM,Vol.54,No.8
36. Turban, E., Aronson, J. E., Liang, T.P., & Sharda, R. (2006). Decision Support and Business Intelligence Systems (8ed.). Upper Saddle River, NJ: Prentice Hall.
37. Vitt, E., Luckevich, M., & Misner, S. (2002). Business Intelligence: Making better decisions faster: Microsoft Press.
38. Visemith, William Muffee.( 2001). Working Capital and Its Impact on the Profitability of Cameroon Development Corporation (CDC). African Journal of Finance and Management, 10 (1): 69-83.
39. Van Horne, J.C and J.M, Wachowicz. (2004). Fundamentals of Financial Management (12th Edition). New York: Prentice Hall Publishers.
40. Watson, Hugh J., Annino, David, A., Wixom, Barbara H., Avery, K. Liddell, and Rutherford, Mathew(2001). Current Practices in Data Warehousing. Imformation Systems Management, Vol.18 Issue 1, pp. 47-55
校內:2018-12-31公開