臺灣博碩士論文加值系統

本研究的目的是幫助生產計劃人員處理原材料的加工過程。 為了改進這一工作流程，研究中提出了一種基於微軟Visual Basic for Applications編寫的程式模型，通過將VBA應用到工作流程中來實現更高效的原材料準備，並開發了該程序幫助生產計劃人員更方便快捷地工作。 由使用開發程序的結果可以看出使用本程序和不使用本程序的區別。 很明顯，該程序為生產計劃人員提供了一種簡單有效的方法。 此外，本模型可以顯著縮短工作時間。

The purpose of this study is to help production planners on the process of raw material. To improve this working process, a computer model written on Visual Basic for Applications of Microsoft is proposed in the research to achieve the raw material preparation more efficiently by applied VBA into work process and developed the program to help production planners work more convenient and quickly. And the results of used the developed program can be seen that the difference between using this program and without using this program. It is very clear that this program offers an easy and efficient way for production planners. Moreover, the proposed model can shorten the working significantly.

摘要.................................................................................... i
Abstract................................................................................ ii
Acknowledgement......................................................................... iii
Table of contents....................................................................... iv
List of Tables.......................................................................... vii
List of Figures......................................................................... viii
Definition and Abbreviation............................................................. x
Chapter 1. Introduction................................................................. 1
1.1 Research Overview............................................................... 1
1.2 Scope of Research............................................................... 3
1.3 Research Methods................................................................ 4
1.4 Research Objectives............................................................. 5
1.5 Expected Results................................................................ 6
Chapter 2. Literature Review............................................................ 7
2.1 Production Planning............................................................. 7
2.1.1 Type of production planning..................................................... 8
2.1.2 Production Planning Department.................................................. 9
2.1.3 The relationship between Production Planning/Controlling and other functions.... 11
2.2 Forecasting..................................................................... 11
2.3 Why-Why Analysis................................................................ 13
2.4 VBA............................................................................. 14
2.4.1 Programming basic of VBA........................................................ 15
2.4.2 Visual Basic Editor............................................................. 16
2.4.3 Type of variables............................................................... 17
2.4.4 Variables declaration........................................................... 18
2.4.5 Type of constant................................................................ 18
2.4.6 Operators....................................................................... 19
Chapter 3. Data and Methodology......................................................... 21
3.1 Current working condition....................................................... 21
3.2 Data sources.................................................................... 23
3.3 Working flow chart without and with using this program.......................... 26
3.3.1 The working flow chart without using this program............................... 26
3.3.2 The working flow chart with using this program.................................. 28
3.4 Analyze the data by other functions in Microsoft Excel.......................... 29
3.5 Analyze the data by VBA......................................................... 32
3.5.1 Forecasting calculation......................................................... 33
3.5.2 Add New Material Data........................................................... 36
3.5.3 Search Data..................................................................... 37
Chapter 4. Analysis and Results......................................................... 40
4.1 The process of running the program.............................................. 40
4.2 The results of the developed program............................................ 41
4.3 The results of used the program................................................. 46
Chapter 5. Conclusion................................................................... 48
5.1 Conclusion...................................................................... 48
5.2 Limitation of the research...................................................... 48
5.3 Suggestion for further study.................................................... 49
References.............................................................................. 50
Appendix I Raw material forecasting data................................................ 53
Appendix II The defect rate at 20% results.............................................. 57
Appendix III The defect rate at 30% results............................................. 59
Extended Abstract....................................................................... 61

1.Tokola, H. and E. Niemi. Short-term Production Planning Methods from the Cost, Planning, and Lead-Time Points of View. in FAIM 2012-22nd International Conference on Flexible Automation and Intelligent Manufacturing. 2012. Tampere University of Technology.
2.Team, I.E. Key Differences Between Short-Term and Long-Term Planning. 2021 [cited 2021 January 20]; Available from: https://www.indeed.com/career-advice/career-development/short-term-vs-long-term-planning.
3.Anuratr. Production Planning. 2016; Available from: http://share.sparcidea.com/index.php/22-general-management/5s?fbclid=IwAR2LpWBLdVzohikfmdZ9pj-01IikRFZRcqe-ZRR6cgaaMcpcxjQq6t1WVD0.
4.Jovanovic. The differences between long-term and short-term planning. 2021 [cited 2021 December 23]; Available from: https://clockify.me/blog/managing-tasks/short-term-planning-and-long-term-planning/?fbclid=IwAR1Ll9Oux9ckNycYIHrPknh7SDYdMlwfUBPL2JZNBAGuz05vq9CUg65hbcc.
5.Uthai, School Planning:Concepts and Principles. 1995, Bangkok, Thailand: SD Press.
6.PLANETTOGETHER. Five Types of Production Planning. 2021 [cited 2021 March 26]; Available from: https://www.planettogether.com/blog/five-types-of-production-planning.
7.MITSDE. TYPES OF MATERIAL MANAGEMENT. 2019 [cited 2019 December 30]; Available from: http://blog.mitsde.com/types-of-material-management/?fbclid=IwAR2FgXezlXizVjM0oa8PA4AZBK8pXIa3Dg-D2ow0AGxwIlmycuj1ZvUzM48.
8.Siriporn, Improvement of raw material inventory control : a case study of coil manufacturing industry. 2005, King Mongkut 's University of Technology North Bangkok: King Mongkut 's University of Technology North Bangkok.
9.Hemeimat, R., et al., Forecasting spare parts demand using statistical analysis. American journal of operations research, 2016. 6(02): p. 113.
10.Rungnapa, Reduction of product shortages by using Forecasting techniques A Case Study: Aicello (Thailand) Co., Ltd, in Engineering Management. 2014, Dhurakij Pundit University: Dhurakij Pundit University.
11.Wawak. Why why analysis. 2019 [cited 2019 December 1]; Available from: https://ceopedia.org/index.php/Why_why_analysis?fbclid=IwAR3h7-5g6KMK--fKdJNZLODMVkwg_gODDZlGiKYeaTjuwdhQ8AU_GTeg2po.
12.Itsaret and Tipkesorn, Development of a Training Package on WHY-WHY ANALYSIS Techniques by Using Problem-Based Learning to Analyze Root Cause in Production. Academic Journal Bangkokthonburi University, 2015. 4(2): p. 200-213.
13.Tamonwan and Phimonnat, Case Study for the Development Program aiding
the selective process of Vehicle tires, in Materials Handling and Logistics Engineering. 2019, King Mongkut’s University of Technology North Bangkok: Department of Materials Handling and Logistics Engineering.
14.Kittikorn. Why-Why Analysis, the starting point for improving waste reduction. 2019 [cited 2019 March 2]; Available from: https://leantpm.co/2019/03/02/why-why-analysis-%E0%B8%88%E0%B8%B8%E0%B8%94%E0%B9%80%E0%B8%A3%E0%B8%B4%E0%B9%88%E0%B8%A1%E0%B8%95%E0%B9%89%E0%B8%99%E0%B8%AA%E0%B8%B9%E0%B9%88%E0%B8%81%E0%B8%B2%E0%B8%A3%E0%B8%9B%E0%B8%A3%E0%B8%B1/?fbclid=IwAR3dCr_LcobPGqXC1.
15.Kenton. Visual Basic for Applications (VBA). 2020 [cited 2020 August 27]; Available from: https://www.investopedia.com/terms/v/visual-basic-for-applications-vba.asp.
16.Dusit, Advance Excel, Programimg with Macro & VBA 2011, Bangkok, Thailand: Provision.
17.Kitinan, Basic Excel VBA. 2013, Nonthaburi: IDC Premier.
18.DCRUBDOTCOM. Excel VBA, Introduction to data management by programing in Excel. 2019 [cited 2019 December 20]; Available from: https://www.dcrub.com/excel-vba?fbclid=IwAR1HCYAhwl9T-gd-5wsJd-f1siicOlMMPESjGjjU-URHrueEPfitU22mUqY.
19.Gibson. VBA in Excel: What is Visual Basic for Applications, How to Use. 2021 [cited 2021 December 11]; Available from: https://www.guru99.com/creating-your-first-visual-basic-for-applications-vba-in-excel.html?fbclid=IwAR25fZteI8GeuB7HRHXAaHODih22Iz1F1CmbcIwwSqtSn5YprGYasGoC24M.
20.Yotsaphon and Sirawit, Developing a Program for Inventory Tracking During Production Of Gabion, in Industrial Engineering. 2019, Chiang Mai University: Chiang Mai University.
21.Siriporn, DevelopmentofaProgramforEvaluatingQuestionnairebyUsing VBA inMicrosoftExcel. SNRU Journal of Science and Technology, 2014. 6(12): p. 59-70.
22.Kittipong, et al., Development of Excel VBA Employee Revenue Processing Program in Oil Establishments. Journal of Modern Learning Development, 2020. 5(5): p. 42-55.
23.Blayney, P.J. and Z. Sun, Using excel and excel VBA for preliminary analysis in big data research, in Managerial Perspectives on Intelligent Big Data Analytics. 2019, IGI Global. p. 110-136.