簡易檢索 / 詳目顯示

研究生: 許芷珊
Hsu, Chih-Shan
論文名稱: 運用自迴歸模型與歷史銷售數據預測蘭花銷售
Orchid Sales Forecasting Using Autoregressive Models and Historical Sales Data
指導教授: 侯建任
Hou, Jian-Ren
學位類別: 碩士
Master
系所名稱: 管理學院 - 工業與資訊管理學系
Department of Industrial and Information Management
論文出版年: 2026
畢業學年度: 114
語文別: 中文
論文頁數: 48
中文關鍵詞: 蘭花銷售預測自迴歸模型時間序列分析特徵選取滑動視窗法
外文關鍵詞: orchid sales forecasting, autoregressive model, time-series analysis, feature selection, sliding window
相關次數: 點閱:3下載:0
分享至:
查詢本校圖書館目錄 查詢臺灣博碩士論文知識加值系統 勘誤回報
  • 蘭花為臺灣具高經濟價值之重要農作物,外銷實力居世界前三大蘭花出口國之列。然而,由於其生產週期長達數月甚至一年,產銷過程長期面臨市場需求波動劇烈與預測不確定性高等挑戰。多數業者仍以經驗法或歷年同期數據作為銷售預估依據,難以及時因應節慶需求、經濟景氣變動或突發事件(如疫情)所造成的市場劇烈變化,導致庫存累積與營運成本上升。
    為此,本研究旨在建立一套具可行性與解釋力之量化預測模型架構,以協助業者提升生產規劃與資源配置效率。本研究以自迴歸模型(Autoregressive Model, AR)為核心,用以捕捉蘭花歷史銷售資料中的時間序列結構與自我相關特性。同時,為了提高預測準確度與模型解釋力,導入遞迴特徵消除交叉驗證法(Recursive Feature Elimination with Cross-Validation, RFECV)進行特徵選取,從花色、節慶與價格等多項變數中篩選出對需求變化最具影響力之關鍵特徵變數。此外,採用滑動視窗法進行動態模型訓練與驗證,使模型能適應資料隨時間變動的特性。
    綜上所述,本研究期望藉由比較納入特徵變數前後模型的預測表現,建構一套具結構清晰、統計基礎穩健且可實務應用的蘭花銷售量預測系統,以協助業者在高度不確定的市場環境中,做出更精準且數據導向之決策。

    Taiwan is among the world's top three orchid exporters, yet the long production cycle and volatile market demand make sales forecasting highly uncertain. Most growers still rely on expert experience and same-period historical figures, which leads to overstocking and elevated operating costs. This study develops a quantitative and interpretable forecasting framework for monthly orchid sales. An autoregressive (AR) model serves as the baseline; an ARIMA model captures richer time-series structure; and an ARX model augments AR with exogenous features selected through Recursive Feature Elimination with Cross-Validation (RFECV). A sliding-window scheme is used for dynamic training and six-step-ahead out-of-sample validation, and statistical errors are translated into an asymmetric operating-cost matrix. Across 470 comparable samples, ARIMA achieved the lowest proportional error (MAPE), whereas ARX achieved the lowest absolute error (MAE and RMSE) and the largest cost reduction relative to AR. Product attributes such as flower color contributed more than festival effects. The results show that the statistically most accurate model is not necessarily the most cost-effective, and that model selection should depend on the decision objective and the available data conditions.

    摘要 i 英文延伸摘要 ii 誌謝 v 表目錄 viii 圖目錄 ix 1 緒論 1 1.1 研究背景 1 1.2 研究動機 1 1.3 研究目的 2 1.4 研究範圍 3 2 文獻探討 4 2.1 農產品銷售量預測的重要性與發展 4 2.2 時間序列模型在銷售預測中的應用 5 2.3 自迴歸模型與其應用 6 2.4 特徵選取在時間序列預測中的角色 7 3 研究方法 9 3.1 研究流程 9 3.2 研究資料與變數 11 3.3 模型建立與方法說明 12 3.3.1 資料前處理與變數選取 12 3.3.2 模型訓練與參數調整 13 3.3.3 模型評估與驗證 14 3.4 小結 15 4 分析結果 16 4.1 模型整體預測表現比較 16 4.2 特徵變數影響與需求結構分析 23 4.3 成本效益與實務決策分析 24 4.3.1 成本計算基礎 25 4.3.2 成本計算方法 25 4.3.3 ARX 與 AR 之成本比較 26 4.3.4 ARIMA 與 AR 之成本比較 27 4.4 模型應用情境決策分析 29 4.5 小結 30 5 結論與建議 31 5.1 模型效能數據分析 31 5.1.1 整體表現比較 31 5.1.2 模型適用性與資料條件分析 32 5.2 商業應用價值 32 5.3 學術研究貢獻 34 5.4 研究限制與未來研究方向 35 參考文獻 36

    Ahaggach, H., Abrouk, L., and Lebon, E. (2024). Systematic mapping study of sales fore-casting: Methods, trends, and future directions. Forecasting, 6(3):502–532.

    Arunraj, N. S., Ahrens, D., and Fernandes, M. (2016). Application of sarimax model to forecast daily sales in food retail industry. International Journal of Operations Research and Information Systems (IJORIS), 7(2):1–21.

    Badal, P. S., Kamalvanshi, V., Goyal, A., Kumar, P., and Mondal, B. (2022). Forecasting potato prices: application of arima model. Economic Affairs, (4):491–496.

    Eiglsperger, J., Haselbeck, F., Stiele, V., Serrano, C. G., Lim-Trinh, K., Menrad, K., Han-nus, T., and Grimm, D. G. (2024). Forecasting seasonally fluctuating sales of perishable products in the horticultural industry. Expert Systems with Applications, 249:123438.

    Hossain, M. M. and Abdulla, F. (2016). Forecasting potato production in bangladesh by arima model. J Adv Stat, 1(4):191–198.

    Huber, J. and Stuckenschmidt, H. (2020). Daily retail demand forecasting using machine learning with emphasis on calendric special days. International Journal of Forecasting, 36(4):1420–1438.

    Jahin, M. A., Shahriar, A., and Amin, M. A. (2025). Mcdfn: supply chain demand forecasting via an explainable multi-channel data fusion network model. Evolutionary Intelligence, 18(3):66.

    Jenčová, S., Vašaničová, P., Košíková, M., and Miškufová, M. (2025). A time series approach to forecasting financial indicators in the wholesale and retail trade. World, 6(1):5.

    Kittichotsatsawat, Y., Boonprasope, A., Rauch, E., Tippayawong, N., and Tippayawong, K. Y. (2023). Forecasting arabica coffee yields by auto-regressive integrated moving av-erage and machine learning approaches. AIMS Agriculture & Food, 8(4).

    Li, J., He, D., and Lu, X. (2024). Sales forecasting and classification model and pricing research of agricultural perishables based on stl-arima. Highlights in Business, Economics and Management, 33:281–288.

    Luis-Rojas, S., Ramírez-Valverde, B., Díaz-Bautista, M., Pizano-Calderón, J., and Ro-dríguez López, C. (2020). Vanilla (vanilla planifolia) production in mexico: analysis and forecast.

    MacLachlan, M. J., Adjemian, M. K., Etienne, X., Sweitzer, M., Volpe Iii, R., and Zeng, W. (2025). Adaptive food price forecasting improves public information in times of rapid economic change. Nature Communications, 16(1):6282.

    Observatory of Economic Complexity (2023). Orchids (hs: 060313). https://oec.world/en/profile/hs/orchids?selector1013id=2023&selector1699id=usdOption&selector1777id=valueOption&selector2367id=Year.Retrieved August 7, 2025, from the Observatory of Economic Complexity website.

    Sandeep, K., Sharma, S., Sharma, A., and Lohia, m. (2025). Forecasting of rice production in india using linear time series models. 17:19.

    Sanjith Bharatharajan Nair, R. E. (2023). An autoregressive integrated moving average model approach in agriculture: A case study. UGC and HEI Recognised Journal, 10:703–718.

    Sujjaviriyasup, T. and Pitiruek, K. (2013). Hybrid arima-support vector machine model for agricultural production planning. Applied Mathematical Sciences, 7(57):2833–2840.

    TogaCloud 資訊中心 (n.d.). 台灣蘭花出口統計資料查詢. https://www.togacloud.org.tw/InfoCenter?id=11653. Retrieved Month Day, Year, from TogaCloud資訊中心 website.

    Yoo, T.-W. and Oh, I.-S. (2020). Time series forecasting of agricultural products’sales volumes based on seasonal long short-term memory. Applied sciences, 10(22):8169.

    臺南市政府主計處 (2023). 臺南市花卉生產及市場銷售分析報告 [pdf]. Available from https://share.google/cAVWWIf2r9LSe5DBc. Retrieved Month Day, Year, from 臺南市政府主計處 website.

    QR CODE