dc.contributor.advisor | 張逸民 | zh_TW |
dc.contributor.advisor | Chang, Yegming | en_US |
dc.contributor.author (Authors) | 潘家鋒 | zh_TW |
dc.contributor.author (Authors) | Pan, Jason | en_US |
dc.creator (作者) | 潘家鋒 | zh_TW |
dc.creator (作者) | Pan, Jason | en_US |
dc.date (日期) | 2010 | en_US |
dc.date.accessioned | 5-Oct-2011 14:29:05 (UTC+8) | - |
dc.date.available | 5-Oct-2011 14:29:05 (UTC+8) | - |
dc.date.issued (上傳時間) | 5-Oct-2011 14:29:05 (UTC+8) | - |
dc.identifier (Other Identifiers) | G0098355070 | en_US |
dc.identifier.uri (URI) | http://nccur.lib.nccu.edu.tw/handle/140.119/51189 | - |
dc.description (描述) | 碩士 | zh_TW |
dc.description (描述) | 國立政治大學 | zh_TW |
dc.description (描述) | 企業管理研究所 | zh_TW |
dc.description (描述) | 98355070 | zh_TW |
dc.description (描述) | 99 | zh_TW |
dc.description.abstract (摘要) | The trend seasonal demand pattern is encountered when both trend and seasonal influences are interactive. The problem of this research is to project the seasonal market sales using ice cream and fresh milk in Taiwan as examples. In order to improve the accuracy of forecast, two different methods are validated and the best forecasting method is selected based on the minimum Mean Square Error. In this study, we present two forecasting models used for evaluation to predict seasonal market sales of ice cream, fresh milk, and air conditioner in Taiwan. It includes Winters multiplicative seasonal trend model and the Decomposition method. Two different methods are validated and the best forecasting method is selected based on the minimum Mean Square Error. After the validation process, Winters multiplicative seasonal trend model is selected based on the minimum MSE, and the monthly sales forecast for the year of 2011 is conducted using the data(60 months). Number Cruncher Statistical System (NCSS) is used for analyzing the data which proves useful and powerful. In summary, the results demonstrate that Winters multiplicative seasonal trend model has the smallest mean square error in this case. Therefore, we conclude that both Winters multiplicative seasonal trend model and the Decomposition model are well fitted for forecasting the seasonal market sales. Yet, Winters multiplicative seasonal trend model is the better method to be used in this study since it generates the smallest mean square error (MSE) during the period of validation. | en_US |
dc.description.tableofcontents | TABLE OF CONTENTSACKNOWLEDGEMENTS................. iABSTRACT......................... iiTABLE OF CONTENTS................ iiiTABLES........................... vFIGURES.......................... viiCHAPTER1Introduction............. 11.1 Problem Statement............ 21.2 Research Objectives.......... 31.3 Research Data................ 31.4 Organization of the Thesis... 4CHAPTER 2 Literature Review...... 5CHAPTER 3Two Forecasting Models for the Seasonal Demand........................... 123.1 Winters Multiplicative Trend Seasonal Model............................ 123.2 Decomposition Forecasting.... 163.3 Estimation and Validation.... 213.4 Forecasting Accuracy......... 213.5 Software used in the research 22CHAPTER 4Data Collection and Analysis......................... 234.1 Data......................... 234.2 Results of Forecasting for the Monthly Sales of Ice Cream............................ 254.2.1 Validation................. 254.2.2 Forecasts.................. 344.3 Results of Forecasting for the Monthly Sales of Fresh Milk............................. 374.3.1 Validation ................ 374.3.2 Forecasts.................. 474.4 Results of Forecasting for the Monthly Sales of Air Conditioner...................... 514.4.1 Validation ................ 514.4.2 Forecasts.................. 60CHAPTER 5Conclusion, Implications, and Future Research ........................ 655.1 Conclusions ................. 655.2 Implications ................ 665.3 Research Limitations ........ 665.4 Future Research ............. 67References....................... 69Appendix A....................... 73Appendix B ...................... 76Appendix C ...................... 80Appendix D....................... 83Appendix E ...................... 86Appendix F....................... 91Appendix G....................... 94Appendix H....................... 98Appendix I ...................... 104 | zh_TW |
dc.language.iso | en_US | - |
dc.source.uri (資料來源) | http://thesis.lib.nccu.edu.tw/record/#G0098355070 | en_US |
dc.subject (關鍵詞) | 季節性消費品 | zh_TW |
dc.subject (關鍵詞) | 銷售量預測 | zh_TW |
dc.subject (關鍵詞) | MSE | zh_TW |
dc.subject (關鍵詞) | sales forecast | en_US |
dc.subject (關鍵詞) | seasonal consumer products | en_US |
dc.subject (關鍵詞) | winters | en_US |
dc.subject (關鍵詞) | decomposition | en_US |
dc.subject (關鍵詞) | mean square error | en_US |
dc.subject (關鍵詞) | NCSS | en_US |
dc.title (題名) | 台灣季節性消費品銷售預測之研究 | zh_TW |
dc.title (題名) | The investigation of forecasting models for the sales of seasonal consumer products in Taiwan | en_US |
dc.type (資料類型) | thesis | en |
dc.relation.reference (參考文獻) | References | zh_TW |
dc.relation.reference (參考文獻) | Armstrong, J.S. (2005), Principles of Forecasting: A Handbook for Researchers and | zh_TW |
dc.relation.reference (參考文獻) | Practitioners, Scott Armstrong (ed.): Norwell, MA: Kluwer Academic Publishers. | zh_TW |
dc.relation.reference (參考文獻) | Armstrong, J.S. (2005), The Forecasting Canon: Nine Generations To Improve Forecast | zh_TW |
dc.relation.reference (參考文獻) | Accuracy, Foresight: The International Journal of Applied Forecasting, Vol. 1, Issue1, 2005. | zh_TW |
dc.relation.reference (參考文獻) | Armstrong, J.S. (2010), Methodology Tree for Forecasting, Forecastingprinciples.com. April 24, | zh_TW |
dc.relation.reference (參考文獻) | 2010. | zh_TW |
dc.relation.reference (參考文獻) | Bails,D.G. (1993), Business | zh_TW |
dc.relation.reference (參考文獻) | Fluctuations/D.G.Bails,L.C.Peppers,London:PrenticeHallInternational. | zh_TW |
dc.relation.reference (參考文獻) | Bolt, G. (1994), SalesForecasting.London:KoganPage. | zh_TW |
dc.relation.reference (參考文獻) | Box, G.E.P. and G.M.Jenkins (1976.)TimeSeriesAnalysis:ForecastingandControl.SanFrancisco: | zh_TW |
dc.relation.reference (參考文獻) | Holden-Day,Revised. | zh_TW |
dc.relation.reference (參考文獻) | Bowerman,B.L.andO’Connel (1993), Forecastingand TimeSeries:AnAppliedApproach,3 | zh_TW |
dc.relation.reference (參考文獻) | rd | zh_TW |
dc.relation.reference (參考文獻) | ed, | zh_TW |
dc.relation.reference (參考文獻) | Belmont,California:DuxburyPress. | zh_TW |
dc.relation.reference (參考文獻) | Chang, P.C., C.H. Liu, J.L. Lin, C.Y. Fan and C. S.P. Ng(2009), “A Case Based Dynamic Time | zh_TW |
dc.relation.reference (參考文獻) | Window search to Assist the Neural Network for Stock Trading Prediction” Expert Systems with | zh_TW |
dc.relation.reference (參考文獻) | Applications 36(3P2), 6889-6898. | zh_TW |
dc.relation.reference (參考文獻) | Chang, P.C., C. Y. Fan , C.H. Liu, J.L. Lin, C.Y. Fan and W.H.Huang (2009),”Sales forecasting | zh_TW |
dc.relation.reference (參考文獻) | for thin film transistor liquid crystal display products with data clustering and an evolving neural | zh_TW |
dc.relation.reference (參考文獻) | network model” Proceeding of the Institution of Mechanical Engineers, Part B, Journal of | zh_TW |
dc.relation.reference (參考文獻) | Engineering Manufacturing 222(5), 625-635. | zh_TW |
dc.relation.reference (參考文獻) | Clemen, R. T. (1989),Combining forecasts: A review and annotated bibliography/R.T.Clemen | zh_TW |
dc.relation.reference (參考文獻) | InternationalJournalofForecasting,No.5,559–583. | zh_TW |
dc.relation.reference (參考文獻) | Dutta, S.and S. Shekkar (1988), “Bond rating: a non-conservative application,” Proceedings of | zh_TW |
dc.relation.reference (參考文獻) | the International Joint Conference on Neural Networks, 443-450. | zh_TW |
dc.relation.reference (參考文獻) | Evans M. K.(2002), Practical business forecasting, Wiley-Blackwell, P.11. | zh_TW |
dc.relation.reference (參考文獻) | Faraway,J.andC.Chatfield, (1998.), “Timeseriesforecastingwith neuralnetwork: acomparative | zh_TW |
dc.relation.reference (參考文獻) | studyusingtheairlinedata”,AppliedStatistics,47,pp.231–250. | zh_TW |
dc.relation.reference (參考文獻) | Georgoff, D. M. and R. Murdick (1986), “Managers’Guide to Forecasting,” Harvard Business | zh_TW |
dc.relation.reference (參考文獻) | Review, January-February,110-120. | zh_TW |
dc.relation.reference (參考文獻) | 70 | zh_TW |
dc.relation.reference (參考文獻) | Goodwin, P. ( 2002), Integratingmanagement judgment and statistical methodstoimproveshorttermforecasts/ | zh_TW |
dc.relation.reference (參考文獻) | P.Goodwin//Omega:InternationalJournalofManagementScience,Vol.30,p.127–35. | zh_TW |
dc.relation.reference (參考文獻) | Green,K.C. (2007), Structuredanalogiesforforecasting/K.C.Green,J.S. Armstrong//International | zh_TW |
dc.relation.reference (參考文獻) | JournalofForecasting,No. 23, p.365–376. | zh_TW |
dc.relation.reference (參考文獻) | Hanke,J.E.andA.G.Reitsch (1995), BusinessForecasting,PrenticeHall,EnglewoodCliffs,NJ. | zh_TW |
dc.relation.reference (參考文獻) | Hall,S.G. (1994), AppliedEconomicsForecastingTechniques/S.G.Hall, | zh_TW |
dc.relation.reference (參考文獻) | Cambridge:UniversityPress. | zh_TW |
dc.relation.reference (參考文獻) | Hansen,J.V. and R.D.Nelson ( 2003.), “Forecastingandrecombining time-seriescomponentsby | zh_TW |
dc.relation.reference (參考文獻) | usingneural networks”,JournaloftheOperationalResearchSociety,54(3),pp.307–317. | zh_TW |
dc.relation.reference (參考文獻) | Herbig,P.,J.Milewicz,J.E.Golden (1994), | zh_TW |
dc.relation.reference (參考文獻) | “DifferencesinForecastingBehaviorbetweenIndustrialProduct Firms and Consumer Product | zh_TW |
dc.relation.reference (參考文獻) | Firms”, Journal of Business and Industrial Marketing,Vol.9,No.1, pp.60–69. | zh_TW |
dc.relation.reference (參考文獻) | Hill,T.M.O’ConnorandW.Remus( 1996), “Neuralnetworkmodelsfortimeseriesforecasts”, | zh_TW |
dc.relation.reference (參考文獻) | ManagementScience,42,pp.1082–1092. | zh_TW |
dc.relation.reference (參考文獻) | Hintze,J.L., (2009), NumberCruncherStatisticalSystem (NCSS), WWW.NCSS.COM. Kaysville, | zh_TW |
dc.relation.reference (參考文獻) | Utah, USA. | zh_TW |
dc.relation.reference (參考文獻) | Holt, C.C. (1957), “ForecastingSeasonaland Trends byExponentiallyWeightedMoving | zh_TW |
dc.relation.reference (參考文獻) | Averages.”CarnegieInstituteofTechnology,Pittsburgh,USA1957. | zh_TW |
dc.relation.reference (參考文獻) | Huang, k. and Yu T.H. (2006), The application of neural networks to forecast fuzzy time series, | zh_TW |
dc.relation.reference (參考文獻) | Physical A, 363,481-491. | zh_TW |
dc.relation.reference (參考文獻) | Hyndman, R.J. (2004), “The interaction between trend and seasonality,” International Journal of | zh_TW |
dc.relation.reference (參考文獻) | Forecasting, 20: 561– 563, | zh_TW |
dc.relation.reference (參考文獻) | Johnston, M. W.and G.W.Marshall(2003), Sales Force Management, 7thed. (New York: | zh_TW |
dc.relation.reference (參考文獻) | McGraw-Hill, Irwin, 131. | zh_TW |
dc.relation.reference (參考文獻) | Kamijo,K.and T. Tanigawa (1990), “Stock price pattern recognition - a recurrent neural network | zh_TW |
dc.relation.reference (參考文獻) | approach,” Proceedings of the 1990 International Joint Conference on Neural Networks, 215-222. | zh_TW |
dc.relation.reference (參考文獻) | 71 | zh_TW |
dc.relation.reference (參考文獻) | Kennedy,P.A. (1999), GuidetoEconometrics,4thed. /P.A.Kennedy, Blackwell:MaldenMass. | zh_TW |
dc.relation.reference (參考文獻) | Kinnear,T.C. (1996), MarketingResearch,5thed. /T.C.Kinnear,J.R. Taylor,NewYork:McGrawHill, | zh_TW |
dc.relation.reference (參考文獻) | KimotoT. andK.Asakawa (1990), “Stock market prediction system with modular neural | zh_TW |
dc.relation.reference (參考文獻) | networks,” Proceedings of the International Joint Conference on Neural Networks, I-1-7. | zh_TW |
dc.relation.reference (參考文獻) | Kirsten, R. (2000), Business Cycles: Market Structure and Market Interaction/ | zh_TW |
dc.relation.reference (參考文獻) | R.Kirsten,Heidelberg:Physica-Verlag. | zh_TW |
dc.relation.reference (參考文獻) | Larrick,R.P. (2006),Intuitionsaboutcombiningopinions:Mis-appreciationof | zh_TW |
dc.relation.reference (參考文獻) | theaveragingprinciple/R.P.Larrick,J.B.Soll//ManagementScience,No.52,p.111–127. | zh_TW |
dc.relation.reference (參考文獻) | Lawrence,R. Small (1980), Sales Forecasting in Canada (Ottawa: The Conference Board of | zh_TW |
dc.relation.reference (參考文獻) | Canada, 1980), 3-7. | zh_TW |
dc.relation.reference (參考文獻) | Makridakis,S. (1998),Forecasting:Methods andApplications,3rded. /S. | zh_TW |
dc.relation.reference (參考文獻) | Makridakis,S.C.Wheelwright,R.J.Hyndman,NewYork:John Wiley&Sons. | zh_TW |
dc.relation.reference (參考文獻) | Makridakis, Wheelwright and Hyndman, (1998), “Forecasting Methods: Theory and Application” | zh_TW |
dc.relation.reference (參考文獻) | Chapter3, John Wiley & Sons, Inc., Hoboken, NJ. USA. | zh_TW |
dc.relation.reference (參考文獻) | McGuigan,J.R. (1989),ManagerialEconomics/J.R.McGuigan,R.C. | zh_TW |
dc.relation.reference (參考文獻) | Moyler,NewYork:WestPublishingCompany. | zh_TW |
dc.relation.reference (參考文獻) | Mentzer,J.T.andK.B.Kahn (1995),ForecastingTechniqueFamiliarity, | zh_TW |
dc.relation.reference (參考文獻) | Satisfaction,Usage,andApplication, Journal ofForecasting, Vol.14, 465-476 | zh_TW |
dc.relation.reference (參考文獻) | Nelson,M.,T.Hill,T. Remus and M.O’Connor, (1999), “Timeseriesforecastingusingneural | zh_TW |
dc.relation.reference (參考文獻) | networks:Should thedatabedeseasonalizedfirst?”JournalofForecasting,18,pp.359–367. | zh_TW |
dc.relation.reference (參考文獻) | Persons,W.M., (1919.) “Indicesofbusinessconditions”,ReviewofEconomicsandStatistics, pp.5–107. | zh_TW |
dc.relation.reference (參考文獻) | Persons,W.M. (1923), “Correlationoftimeseries”, JournalofAmericanStatisticalAssociation,18,pp.5– | zh_TW |
dc.relation.reference (參考文獻) | 107. | zh_TW |
dc.relation.reference (參考文獻) | Peterson,H.C. and W. C. Lewis (1999), ManagerialEconomics,NewJersey:PrenticeHall. | zh_TW |
dc.relation.reference (參考文獻) | Rao R. and James E. Cox, Jr. (1987), Sales Forecasting Methods: A survey of Recent | zh_TW |
dc.relation.reference (參考文獻) | Developments (Cambridge, MA: Marketing Science Institute), 17. | zh_TW |
dc.relation.reference (參考文獻) | Reekie,W.D. and J.N.Crook (1998), | zh_TW |
dc.relation.reference (參考文獻) | ManagerialEconomics:EuropeanText,NewYork:PrenticeHall. | zh_TW |
dc.relation.reference (參考文獻) | Refenes,A. N. (1993), “Currency exchange rate prediction and neural network design strategies,” | zh_TW |
dc.relation.reference (參考文獻) | Neural Computing and Applications, vol. 1, no.1. | zh_TW |
dc.relation.reference (參考文獻) | Schoenenburg, E. (1990), “Stock price prediction using neural networks: a project report,” | zh_TW |
dc.relation.reference (參考文獻) | Neurocomputing, vol. 2, 17-27. | zh_TW |
dc.relation.reference (參考文獻) | Suhartono, Subanar andGuritno (2005), Journal Technical Industry, Vol.7, No.1:22-30 | zh_TW |
dc.relation.reference (參考文獻) | Surkan, A.and J. Singleton (1990), “Neural networks for bond rating improved by multiple | zh_TW |
dc.relation.reference (參考文獻) | hidden layers,” Proceedings of the 1990 International Joint Conference on Neural Networks, II- | zh_TW |
dc.relation.reference (參考文獻) | 157162. | zh_TW |
dc.relation.reference (參考文獻) | Thomopoulos, N. T. (1988), “Applied Forecasting Methods” the Stuart School of Business, | zh_TW |
dc.relation.reference (參考文獻) | Illinois Institute of Technology, Chicago | zh_TW |
dc.relation.reference (參考文獻) | White, H. (1988), “Economic prediction using neural networks: the case of IBM daily stock | zh_TW |
dc.relation.reference (參考文獻) | returns,” Proceedings of the International Joint Conference on Neural Networks, III-261-265. | zh_TW |
dc.relation.reference (參考文獻) | Winters, P.R. (1960), “ForecastingSalesby ExponentiallyWeightedMovingAverages” | zh_TW |
dc.relation.reference (參考文獻) | ManagementScience,April 1960, pp. 324—342. | zh_TW |
dc.relation.reference (參考文獻) | Yamaba, S.and H. Kurashima(1991), “Decision support system for position optimization on | zh_TW |
dc.relation.reference (參考文獻) | currency option dealing,” Proceedings of the First International Conference on Artificial | zh_TW |
dc.relation.reference (參考文獻) | Intelligence Applications on Wall Street, 160-165. | zh_TW |
dc.relation.reference (參考文獻) | Zhang,G.,B.E.Patuwo andM.Y.Hu (1998), “Forecastingwithartificialneuralnetworks:Thestate | zh_TW |
dc.relation.reference (參考文獻) | oftheart”,InternationalJournalofForecasting,14,pp.35–62 | zh_TW |