Loading...
|
Please use this identifier to cite or link to this item:
https://nccur.lib.nccu.edu.tw/handle/140.119/51189
|
| Title: | 台灣季節性消費品銷售預測之研究
The investigation of forecasting models for the sales of seasonal consumer products in Taiwan |
| Authors: | 潘家鋒
Pan, Jason |
| Contributors: | 張逸民
Chang, Yegming
潘家鋒
Pan, Jason |
| Keywords: | 季節性消費品
銷售量預測
MSE
sales forecast
seasonal consumer products
winters
decomposition
mean square error
NCSS |
| Date: | 2010 |
| Issue Date: | 2011-10-05 14:29:05 (UTC+8) |
| 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. |
| Reference: | References
Armstrong, J.S. (2005), Principles of Forecasting: A Handbook for Researchers and
Practitioners, Scott Armstrong (ed.): Norwell, MA: Kluwer Academic Publishers.
Armstrong, J.S. (2005), The Forecasting Canon: Nine Generations To Improve Forecast
Accuracy, Foresight: The International Journal of Applied Forecasting, Vol. 1, Issue1, 2005.
Armstrong, J.S. (2010), Methodology Tree for Forecasting, Forecastingprinciples.com. April 24,
2010.
Bails,D.G. (1993), Business
Fluctuations/D.G.Bails,L.C.Peppers,London:PrenticeHallInternational.
Bolt, G. (1994), SalesForecasting.London:KoganPage.
Box, G.E.P. and G.M.Jenkins (1976.)TimeSeriesAnalysis:ForecastingandControl.SanFrancisco:
Holden-Day,Revised.
Bowerman,B.L.andO’Connel (1993), Forecastingand TimeSeries:AnAppliedApproach,3
rd
ed,
Belmont,California:DuxburyPress.
Chang, P.C., C.H. Liu, J.L. Lin, C.Y. Fan and C. S.P. Ng(2009), “A Case Based Dynamic Time
Window search to Assist the Neural Network for Stock Trading Prediction” Expert Systems with
Applications 36(3P2), 6889-6898.
Chang, P.C., C. Y. Fan , C.H. Liu, J.L. Lin, C.Y. Fan and W.H.Huang (2009),”Sales forecasting
for thin film transistor liquid crystal display products with data clustering and an evolving neural
network model” Proceeding of the Institution of Mechanical Engineers, Part B, Journal of
Engineering Manufacturing 222(5), 625-635.
Clemen, R. T. (1989),Combining forecasts: A review and annotated bibliography/R.T.Clemen
InternationalJournalofForecasting,No.5,559–583.
Dutta, S.and S. Shekkar (1988), “Bond rating: a non-conservative application,” Proceedings of
the International Joint Conference on Neural Networks, 443-450.
Evans M. K.(2002), Practical business forecasting, Wiley-Blackwell, P.11.
Faraway,J.andC.Chatfield, (1998.), “Timeseriesforecastingwith neuralnetwork: acomparative
studyusingtheairlinedata”,AppliedStatistics,47,pp.231–250.
Georgoff, D. M. and R. Murdick (1986), “Managers’Guide to Forecasting,” Harvard Business
Review, January-February,110-120.
70
Goodwin, P. ( 2002), Integratingmanagement judgment and statistical methodstoimproveshorttermforecasts/
P.Goodwin//Omega:InternationalJournalofManagementScience,Vol.30,p.127–35.
Green,K.C. (2007), Structuredanalogiesforforecasting/K.C.Green,J.S. Armstrong//International
JournalofForecasting,No. 23, p.365–376.
Hanke,J.E.andA.G.Reitsch (1995), BusinessForecasting,PrenticeHall,EnglewoodCliffs,NJ.
Hall,S.G. (1994), AppliedEconomicsForecastingTechniques/S.G.Hall,
Cambridge:UniversityPress.
Hansen,J.V. and R.D.Nelson ( 2003.), “Forecastingandrecombining time-seriescomponentsby
usingneural networks”,JournaloftheOperationalResearchSociety,54(3),pp.307–317.
Herbig,P.,J.Milewicz,J.E.Golden (1994),
“DifferencesinForecastingBehaviorbetweenIndustrialProduct Firms and Consumer Product
Firms”, Journal of Business and Industrial Marketing,Vol.9,No.1, pp.60–69.
Hill,T.M.O’ConnorandW.Remus( 1996), “Neuralnetworkmodelsfortimeseriesforecasts”,
ManagementScience,42,pp.1082–1092.
Hintze,J.L., (2009), NumberCruncherStatisticalSystem (NCSS), WWW.NCSS.COM. Kaysville,
Utah, USA.
Holt, C.C. (1957), “ForecastingSeasonaland Trends byExponentiallyWeightedMoving
Averages.”CarnegieInstituteofTechnology,Pittsburgh,USA1957.
Huang, k. and Yu T.H. (2006), The application of neural networks to forecast fuzzy time series,
Physical A, 363,481-491.
Hyndman, R.J. (2004), “The interaction between trend and seasonality,” International Journal of
Forecasting, 20: 561– 563,
Johnston, M. W.and G.W.Marshall(2003), Sales Force Management, 7thed. (New York:
McGraw-Hill, Irwin, 131.
Kamijo,K.and T. Tanigawa (1990), “Stock price pattern recognition - a recurrent neural network
approach,” Proceedings of the 1990 International Joint Conference on Neural Networks, 215-222.
71
Kennedy,P.A. (1999), GuidetoEconometrics,4thed. /P.A.Kennedy, Blackwell:MaldenMass.
Kinnear,T.C. (1996), MarketingResearch,5thed. /T.C.Kinnear,J.R. Taylor,NewYork:McGrawHill,
KimotoT. andK.Asakawa (1990), “Stock market prediction system with modular neural
networks,” Proceedings of the International Joint Conference on Neural Networks, I-1-7.
Kirsten, R. (2000), Business Cycles: Market Structure and Market Interaction/
R.Kirsten,Heidelberg:Physica-Verlag.
Larrick,R.P. (2006),Intuitionsaboutcombiningopinions:Mis-appreciationof
theaveragingprinciple/R.P.Larrick,J.B.Soll//ManagementScience,No.52,p.111–127.
Lawrence,R. Small (1980), Sales Forecasting in Canada (Ottawa: The Conference Board of
Canada, 1980), 3-7.
Makridakis,S. (1998),Forecasting:Methods andApplications,3rded. /S.
Makridakis,S.C.Wheelwright,R.J.Hyndman,NewYork:John Wiley&Sons.
Makridakis, Wheelwright and Hyndman, (1998), “Forecasting Methods: Theory and Application”
Chapter3, John Wiley & Sons, Inc., Hoboken, NJ. USA.
McGuigan,J.R. (1989),ManagerialEconomics/J.R.McGuigan,R.C.
Moyler,NewYork:WestPublishingCompany.
Mentzer,J.T.andK.B.Kahn (1995),ForecastingTechniqueFamiliarity,
Satisfaction,Usage,andApplication, Journal ofForecasting, Vol.14, 465-476
Nelson,M.,T.Hill,T. Remus and M.O’Connor, (1999), “Timeseriesforecastingusingneural
networks:Should thedatabedeseasonalizedfirst?”JournalofForecasting,18,pp.359–367.
Persons,W.M., (1919.) “Indicesofbusinessconditions”,ReviewofEconomicsandStatistics, pp.5–107.
Persons,W.M. (1923), “Correlationoftimeseries”, JournalofAmericanStatisticalAssociation,18,pp.5–
107.
Peterson,H.C. and W. C. Lewis (1999), ManagerialEconomics,NewJersey:PrenticeHall.
Rao R. and James E. Cox, Jr. (1987), Sales Forecasting Methods: A survey of Recent
Developments (Cambridge, MA: Marketing Science Institute), 17.
Reekie,W.D. and J.N.Crook (1998),
ManagerialEconomics:EuropeanText,NewYork:PrenticeHall.
Refenes,A. N. (1993), “Currency exchange rate prediction and neural network design strategies,”
Neural Computing and Applications, vol. 1, no.1.
Schoenenburg, E. (1990), “Stock price prediction using neural networks: a project report,”
Neurocomputing, vol. 2, 17-27.
Suhartono, Subanar andGuritno (2005), Journal Technical Industry, Vol.7, No.1:22-30
Surkan, A.and J. Singleton (1990), “Neural networks for bond rating improved by multiple
hidden layers,” Proceedings of the 1990 International Joint Conference on Neural Networks, II-
157162.
Thomopoulos, N. T. (1988), “Applied Forecasting Methods” the Stuart School of Business,
Illinois Institute of Technology, Chicago
White, H. (1988), “Economic prediction using neural networks: the case of IBM daily stock
returns,” Proceedings of the International Joint Conference on Neural Networks, III-261-265.
Winters, P.R. (1960), “ForecastingSalesby ExponentiallyWeightedMovingAverages”
ManagementScience,April 1960, pp. 324—342.
Yamaba, S.and H. Kurashima(1991), “Decision support system for position optimization on
currency option dealing,” Proceedings of the First International Conference on Artificial
Intelligence Applications on Wall Street, 160-165.
Zhang,G.,B.E.Patuwo andM.Y.Hu (1998), “Forecastingwithartificialneuralnetworks:Thestate
oftheart”,InternationalJournalofForecasting,14,pp.35–62 |
| Description: | 碩士
國立政治大學
企業管理研究所
98355070
99 |
| Source URI: | http://thesis.lib.nccu.edu.tw/record/#G0098355070 |
| Data Type: | thesis |
| Appears in Collections: | [企業管理學系] 學位論文
|
Files in This Item:
| File |
Size | Format | |
|---|
| 507001.pdf | 680Kb | Adobe PDF2 | 870 | View/Open |
|
All items in 政大典藏 are protected by copyright, with all rights reserved.
|
