题名

根據銷售資料提升啤酒釀造廠生產排程品質之研究

并列篇名

A Study on Improving the Quality of Brewery Production Scheduling Based on Sales Data

DOI

10.6626/MR.2013.13(1).01

作者

黃允成(Yun-Cheng Huang);陳怡妗(Yi-Chin Chen);鄧智杰(Chih-Chieh Teng)

关键词

啤酒 ; 最佳化 ; 生產排程 ; Beer ; Optimization ; Production Scheduling

期刊名称

管理研究學報

卷期/出版年月

13卷1期(2013 / 06 / 01)

页次

1 - 37

内容语文

繁體中文

中文摘要

啤酒需求具有不確定性與季節變化之特性。過去以需求預測與半成品庫存評估投料量,未仔細安排生產排程之最佳時機,導致供需難以平衡。本研究由收集歷史銷售資料推估需求分配,並藉由統計方法區分淡旺季之需求,並利用最佳化技術尋找當季每週最適生產量以達期望總利潤最大化之目標。根據每週最適生產量,建構混合整數線性規劃模型,求解最適生產排程,以達總生產損失最小化之目標,提升生產排程之品質,最後以實際案例驗證模式之可行性與效率性。

英文摘要

Demand of beer is uncertain and has seasonal fluctuation. Over the past years, based on demand forecast and quantity of semi-finished product to assess the input amount of materials, and have not evaluated the optimal production time, so it was difficult to balance the demand and supply. This research is based on historical data to infer the demand distribution, and applied statistical cluster analysis technique to classify the off-season and season demand. We applied the optimization technique to search for an optimal production quantity to maximize the total expected profit. We also establish a mixed-integer linear programming model for production scheduling to minimize the total production losses according to the given production quantity per week. Therefore, the quality of production scheduling was improved. Finally, this paper takes a real case to demonstrate the validity of the proposed model.

主题分类 社會科學 > 管理學
参考文献
  1. Aburto, L.,Weber, R.(2007).Improved supply chain management based on hybrid demand forecasts.Applied Soft Computing,7(1),136-144.
  2. Adonyi, R.,Biros, G.,Holczinger, T.,Friedler, F.(2008).Effective scheduling of a large-scale paint production system.Journal of Cleaner Production,16(2),225-232.
  3. Blomer, F.,Gunther, H.O.(1998).Scheduling of a multi-product batch process in the chemical industry.Computers in Industry,36(2),245-259.
  4. Chen, K. K.,Chang, C. T.(2007).A seasonal demand inventory model with variable lead time and resource constraints.Applied Mathematical Modelling,31(11),2433-2445.
  5. Gallet, C. A.,List, J. A.(1998).Elasticities of beer demand revisited.Economics Letters,61(1),67-71.
  6. Joly, M.,Pinto, J. M.(2003).Mixed-Intrger programming techniques for the scheduling of fuel oil and asphalt production.Institution of Chemical Engineers,81(4),427-447.
  7. Krever, M.,Wunderink, S.,Dekker, R.,Schorr, B.(2005).Inventory control based on advanced probability theory, an application.European Journal of Operational Research,162(2),342-358.
  8. Ross, Sheldon M.(2009).Introduction to Probability and Statistics for Enginers and Scientists.UK:Elsevier Academic Press.
  9. Schmide, G.(1996).Modelling production scheduling systems.International Journal of Production Economics,46-47,109-118.
  10. Spitter, J. M.,Kok, A. G.,Dellaert, N. P.(2005).Timing production in LP models in a rolling schedule.International Journal of Production Economics,93-94,319-329.
  11. Vanderhaegen, B.,Neven, H.,Verachtert, H.,Derdelinckx, G.(2006).The chemistry of beer aging - a critical review.Food Chemistry,95(3),357-381.
  12. Wu, L. Y.,Hu, Y. D.,Xu, D. M.,Hua, B.(2003).Solving batch production scheduling using genetic algorithm.Computer Aided Chemical Engineering,15,648-653.
  13. 沈明來(1998)。實用多變數分析(初版)。台北市:九州圖書。
  14. 陳雲明(2002)。台中市,國立朝陽科技大學。
  15. 黃允成(2001)。報童模式在機率性需求與數量折扣下最適訂購量與訂價策略之研究。工業工程學刊,18,43-52。
  16. 蔡登茂(1998)。未來供給不確定下最佳經濟訂購批量訂定之研究。正修學報,11,131-146。