簡易檢索 / 詳目顯示

研究生: 羅克曼
Rhochmad Wahyu Illahi
論文名稱: 印尼蝦輸日之預測分析
Forecasting Analysis of Indonesia’s Shrimp Export to Japan
指導教授: 陳淑恩
Shwu-En Chen
Ratya Anindita
學位類別: 碩士
Master
系所名稱: 國際學院 - 農企業管理國際碩士學位學程
International Master's Degree Program in Agribusiness Management
畢業學年度: 107
語文別: 英文
論文頁數: 88
中文關鍵詞: 蝦出口,預測,印度尼西亞,ARIMA蝦出口預測印度尼西亞ARIMA
外文關鍵詞: Shrimp Export, Forecast, Indonesia, ARIMA, Shrimp Export, Forecast, Indonesia, ARIMA
DOI URL: http://doi.org/10.6346/THE.NPUST.AM.020.2019.D04
相關次數: 點閱:14下載:1
分享至:
查詢本校圖書館目錄 查詢臺灣博碩士論文知識加值系統
  • 印度尼西亞是世界上最大的蝦類生產國,主要出口到美國和日本,佔蝦出口的三分之一以上。蝦捕獲結果和出口在不同季節和不同年份波動,故在經營管理和農業政策上採用準確方法來預測出口,是非常重要。本研究的研究目的是分析預測印度尼西亞蝦出口到日本的最佳模型。
    印度尼西亞蝦出口數據是1989-2017年的時間序列。本研究利用移動平均法,單指數平滑法,最小平方趨勢法,二次趨勢法和Box-Jenkins(ARIMA)模型,以1989-2017年期間印度尼西亞蝦出口到日本資料,來預測2018年出口。然後,預測誤差分析是利用MAPE(平均絕對百分比誤差),MAD(平均絕對偏差)和MSE(均方誤差)分析。本研究數據分析是使用Minitab 第17版和Microsoft Excel。
    本研究預測2018年印度尼西亞蝦出口到日本的結果,以3期之移動平均模型預測值為27,080,419公斤;以單指數平滑模型平滑係數⍺分別為0.2、0.5、0.9,預測值分別為30,942,641公斤、28,444,131公斤、和30,191,341公斤。最小平方趨勢模型預測為27,101,974.88公斤。二次趨勢趨勢模型預測為19,089,500公斤,ARIMA模型預測(0,1,1)為24,213,800公斤。
    最後,因為ARIMA(0,1,1)模型在MAPE、MAD、MSE皆具有最小的預測誤差值,表示其比其他預測方法更能準確地預測,故本研究選擇ARIMA(0,1,1)為最佳預測模型。

    Indonesia, the largest shrimp producer in the world, exports shrimp mainly to the US and Japan, accounting for more than one third of the shrimp export. The shrimp catch results and exports fluctuate in different seasons and different years. It is important to adopt an accuracy method to forecast export as a guideline for management strategy and agricultural policy. The purpose of this study was to analyze the best model to forecast Indonesia’s shrimp export to Japan.
    Data of Indonesia’s Shrimp exports are time series during 1989-2017. Moving Averages, Single Exponential Smoothing, Least Squares Trend, Quadratic Trend, and Box-Jenkins (ARIMA) models were used to predict the Indonesia’s shrimp export to Japan during 1989-2017 and to forecast export in 2018. Then, the forecast error analysis was analyzed by MAPE (Mean Absolute Percentage Error), MAD (Mean Absolute Deviation), and MSE (Mean Square Error). Minitab 17 application and Microsoft Excel were used for data analysis.

    By 3-period Moving Average model, the Indonesia's shrimp export to Japan in 2018 is forecast as 27,080,419 kg. By Single Exponential Smoothing Model with smoothing coefficient ⍺ equaling 0.2, 0.5, and 0.9, shrimp exports are forecast as 30,942,641 kg, 28,444,131 kg, and 30,191,341 kg, respectively. Forecast with Least Squares Trend model is 27,101,974.88 kg. Forecasts of shrimp exports are 19,089,500 kg and 24,213,800 kg respectively through Quadratic Trend Model and ARIMA model (0, 1, 1).
    As a result, ARIMA (0, 1, 1) was selected as the best model as forecasting model because it has the smallest forecasting errors evaluated by MAPE, MAD, and MSE and is able to predict more accurately than other forecasting models.

    Table of Content

    Abstract (摘要)…............................................................................................
    I

    Abstract……....................................................................................................
    III

    Acknowlegment...............................................................................................
    V
    Table of Content..............................................................................................
    VI
    List of Table.....................................................................................................
    IX

    List of Figure...................................................................................................
    XII

    1. Introduction.................................................................................................
    1
    1.1
    Research Background............................................................................
    1

    1.2
    Research Question.................................................................................
    3

    1.3
    Research Objectives..............................................................................
    4

    1.4
    Research Contribution...........................................................................
    6

    2. Literature Review........................................................................................
    7
    2.1
    Classification and Morphology ….…………........................................
    7

    2.2
    Basic Concept of Demand.....................................................................
    9

    2.2.1 Factor Affecting Demand……………………………………….. 10
    2.3
    Forecasting….……………………………………...............................
    13

    2.3.1 Forecasting Type………………………………………………... 15
    2.3.2 Quantitative Forecasting Method...……………………………... 17
    2.3.3 Periodical Time Forecasting Method…….……………………... 18
    2.4
    Previous Research ……………………………………........................
    23
    3. Methodology................................................................................................
    27
    3.1
    Time Series Analysis….........................................................................
    27

    3.1.1 Moving Average Model (MA Model)......….…………………... 28
    3.1.2 Single Exponential Smoothing Model...….…………………….. 29
    3.1.3 Least Square Trend Model (Linear Trend Model)…..………….. 30
    3.1.4 Quadratic Trend Model (Non Linear Trend Model)…..………... 31
    3.1.5 Box-Jenkins Model (ARIMA Model)..…….…………………... 32
    3.1.6 Accuracy……………………. ……..…….………………...…... 35
    3.1.7 Comparison Criteria of the Best Model Forecasting ….…...…... 37
    3.2
    Data Sources ……….….......................................................................
    38
    3.3
    Research Framework…........................................................................
    38
    4. Result and Discussion.................................................................................
    40
    4.1
    Shrimp Export…......…........................................................................
    40
    4.2
    Forecasting of Indonesia’s shrimp export to Japan..............................
    42
    4.2.1 Forecasting with Moving Average Model (MA Model)………... 42
    4.2.2 Forecasting with Single Exponential Smoothing Model.............. 44
    4.2.3 Forecasting with Least Square Trend (Linear Trend Model)….... 49
    4.2.4 Forecasting with Quadratic Trend (Non Linear Trend Model)..... 50
    4.2.5 Forecasting with Box Jenkins Model (ARIMA Model).……….. 52
    4.3
    Forecasting Accuracy Measurement....................................................
    61
    4.3.1 Mean Absolute Percentage Error (MAPE)....…………………... 61
    4.3.2 Mean Absolute Deviation (MAD)…………….………………... 62
    4.3.3 Mean Square Error (MSE)………………………...…..………... 63
    4.4
    Selection of the Best Forecasting Model.............................................
    64
    4.5
    Forecasting of Indonesia’s Shrimp Export with the Best Model…....
    65
    4.6
    Implication of Result…..…………….................................................
    67
    5. Conclusion and Recommendation.............................................................
    68
    5.1
    Conclusion…..……………………….................................................
    68
    4.6
    Recommendation....………………….................................................
    69
    6. References…................................................................................................
    70
    Appendix 1. Session Windows of Moving Average Model ………………..
    74
    Appendix 2. Session Windows of Single Exponential Model α = 0.2….…..
    75
    Appendix 3. Session Windows of Single Exponential Model α = 0.5….…..
    76
    Appendix 4. Session Windows of Single Exponential Model α = 0.9.……..
    77
    Appendix 5. Session Windows of Least Square Trend (Linear Trend Model)
    78
    Appendix 6. Session Windows of Quadratic Trend (Non-Linear Trend Model)...……………………………………………………… 79
    Appendix 7. Session Windows of Autocorrelation Function ………………..
    80
    Appendix 8. Session Windows of Partial Autocorrelation Function………..
    81
    Appendix 9. Session Windows of ARIMA Model (1,1,0) .. ………………..
    82
    Appendix 10. Session Windows of ARIMA Model (0,1,1) ………………..
    83
    Appendix 11. Session Windows of ARIMA Model (1,1,1) ………………..
    84
    Appendix 12. Calculation of MAD, MSE, and MAPE Accuracy…………..
    85
    Appendix 13. Session Windows of Best Model {ARIMA Model (0,1,1)}…. 86
    Biosketch of Author………………………………………………………...
    88

    Ajeng, S. 2011. Demand Forecasting for Planning the Procurement of Durian Fruit Supplies in Durian Harum Bintaro Place, Jakarta. Thesis. University of Islam Negeri Syarif Hidyatullah. Jakarta.

    Arsyad, L. 1995. Business Forecasting. BPFE. Yogyakarta.

    Assauri, S. 1984. Techniques & Method of Forecasting: Applications in Economic & Business. Edition 1. Publisher Institution Faculty of Economic University of Indonesia. Jakarta

    Dian. 2006. Classification and Morphology Vannamei Shrimp (Litopenaeus vannamei)

    Directorate General of National Export Development. 2014. Export News: Fish and Fish Products. Directorate General of National Export Development, Ministry of Commerce. Jakarta

    Douma, Marieke and Jeroen V Wijk. 2012. ASC Certified Shrimp: can extensive shrimp farming benefit? A case study of Indonesia. Working paper no 202/21

    Fattah, M. dan P. Purwanti. 2017. Fisheries Industry Management. UB Press. Malang. 214 hlm (157-159)

    Febianti, Y Nisa. 2014. Demand in Microeconomics. FKIP Unswagati

    Firdaus, M. 2006. Time Series Analysis of One Variety. Jakarta: IPB Press.

    Gaspersz, V. 2000. Managerial Economics: Making Business Decisions. Revised Edition and Expansion. Gramedia Pustaka Utama. Jakarta.

    Gusdian, E., A. Muis, dan A. Lamusa. 2016. Forecasting Demand for Bread at “Tiara Rizki” Industry in di Boyaoge, Tatanga Distric Palu City. E-Journal Agrotekbis. 4 (1): 97-105

    Handoko, T. H. 2011. Basic of Management and Operations. Edition 1. BPFE. Yogyakarta. 462 hlm.

    Herjanto, E. 2007. Operation Management. Grasindo. Jakarta.
    Indonesian statistics center. 2018. Bulletin of Foreign Trade Statistics of Exports by Commodity Group and Country, November 2017. Jakarta: Badan Pusat Statistik.

    Jacobs, F. R. and R. B. Chase. 2016. Operation Management and Supply Chain. Edition 14 Book 2. Salemba Empat. Jakarta.

    Juanti, F., A. Jumiati, dan E. Santoso. 2014. Economic Landscape Fisheries Sub Sector in Economy of Sidoarjo Regency: Model Input Output and Analytical Hierarchy Process. E-Journal Economic Business and Accounting. 1 (1): 42-52.

    Khusharyanto, A. 2011. Analysis of Forecasting Sales of Textbooks Type LKS in CV. Harapan Baru Karanganyar. Thesis. Faculty of Economics. University of Sebelas Maret. Surakarta

    Linda, Puspa. 2014. Forecasting Sales of ”Teh Botol Sosro” at PT. Sinar Sosro Sumatera the Northern Part in 2014 with Arima Box-Jenkins Method. Saintia Mathematics ISSN: 2337-9197 Vol. 02, No. 03 (2014), pp. 253–266.

    Lubis, Adrian D. 2013. Analysis of Factors that Affect Indonesia’s Export Performance. Foreign Trade Research and Development Center, Ministry of Trade. Jakarta.

    Makridakis, S., Wheelwright, S. C., and V. E McGee. 1999. Method and Application of Forecasting. Edition 2 Jilid 1. Penerbit Erlangga. Jakarta.

    Manurung, A. H. 1990. Business Forecasting Technique and Economic. Rineka Cipta. Jakarta

    Mentzer, J.T. & Moon, M.A. 2005. Sales Forecasting Management - A Demand Management Approach, 2nd ed. Thousand Oaks, CA: Sage.

    Ministry of Commerce of the Republic of Indonesia. 2011. Performance Report of the Secretary of Commerce RI Year 2011. Jakarta

    Mulyono, S. 2000. Business Forecasting and Econometrics. Edition 1. BPFE. Yogyakarta

    Nachrowi, N. D. and H. Usman. 2004. Decision Making Techniques. Grasindo. Jakarta.
    Nasapi, M., I. Santoso, and M. Effendi. 2014. Forecasting Demand for Pasteurized Milk Used Artificial Neural Network Method and Time Series (Case Study in Milk Cooperative SAE Pujon, Malang). Journal EECCIS. 6 (1): 1-12.

    Nasution, A. H. and Y. Prasetyawan. 2008. Production Planning and Control. Graha Ilmu. Yogyakarta.

    Nuhman. 2009. The Influence of the Percentage of Feeding on Survival and Growth Rate of Vannamei (Litopenaeus vannamei). Department of Fisheries Faculty of Technology Marine and Fisheries University of Hang Tuah, Surabaya. Journal Fisheries and Marine Science Vol. 1, No. 2.

    Octora, M. and Kuntoro. 2013. Comparison of ARIMA (Box Jenkins) and Winter Methods in Forecasting the Number of Cases of Dengue Fever. Journal Biometric and Population. 2 (1): 88-98.

    Prasetya, H. and F. Lukiastuti. 2011. Operation Management. CAPS. Yogyakarta. 152 hlm.

    Render, B. and J. Heizer. 2001. Operation Management Principles. Salemba Empat. Jakarta.

    Sinulingga, S. 2013. Production Planning and Control. Graha Ilmu. Yogyakarta.

    Stevenson, W. J. and S. C. Chuong. 2014. Operation Management: Asia Perspektif. Edition 9 Book 1. Salemba Empat. Jakarta.

    Sugianto, Romi. 2017. Fluctuation of Indonesian Shrimp Export to Japan in 2010-2014. JOM FISIP Vol. 4 No. 2.

    Sugiyono. 2012. Quantitative and Qualitative Methods, and R&D. Alfabeta. Bandung. 334 hlm.

    Suwingnyo. 1990. Classification and morphology Black Tiger Shrimp (Penaeus monodon)

    Tajerin and Mohammad Noor. 2004. Indonesian Shrimp Competitiveness in the International Market: an Analysis with market share approach use Econometric Model. Journal Economic Development 9 No. 2
    Tohir, A. 2011. Forecasting Analysis of Crude Palm Oil (CPO) in PT. Kharisma Pemasaran Bersama (KPB) Nusantara. Thesis. University of Islam Negeri Syarif Hidyatullah. Jakarta.

    Wardah, siti. 2016. Forecasting Analysis of Banana Chips (Case Study: Home Industry Arwana Food Tembilahan). University of Islam Indragiri, Tembilahan. Journal Technic Industry, Vol. XI, No. 3

    Whelan, Joseph. Kamil Masefer. 1996. Economic Supply and Demand.

    Yacob, E Nugraha. 2009. Demand Forecasting Analysis Method of Oxygen product in PT. Samator Gresik. Faculty of Technic, University of Sebelas Maret. ISSN: 2579-6429

    Yanti, N. P. L. P. 2016. Forecasting Analysis of Soy Sauce in Soy Sauce Company Manalagi Bali. Thesis. University of Udayana. Jimbaran Hill.

    下載圖示
    QR CODE