Rahmat Wijaya, Rr. Erlina, Nova Mardiana, Jurusan Manajemen, Universitas Lampung
{"title":"移动平均法与指数平滑法在Pd地区香蕉片销售预测中的比较Dwi Putra Tulang bawangbarat","authors":"Rahmat Wijaya, Rr. Erlina, Nova Mardiana, Jurusan Manajemen, Universitas Lampung","doi":"10.55927/jfbd.v2i2.4913","DOIUrl":null,"url":null,"abstract":"Sales forecasts predict a company's sales. PD Dwi Putra's banana chip sales have fluctuated every month for the past few years, resulting in stock shortages and excesses. Forecasting using historical sales data uses time series methods like moving average and exponential smoothing. This study compares the two forecasting methods to find the lowest error rate and the best method for the company to use for the next four years. The exponential smoothing method outperforms the moving average method for MAPE, MSE, and MAD values, so it is used for future forecasting. According to research, companies should use exponential smoothing with parameter α = 0.6 for the next four years because it has the lowest forecasting error rate. Thus, these parameters are used to forecast the next few years.","PeriodicalId":189308,"journal":{"name":"Journal of Finance and Business Digital","volume":"37 6","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2023-07-04","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"Comparison of Moving Average and Exponential Smoothing Methods in Sales Forecasting of Banana Chips Products in Pd. Dwi Putra Tulang Bawang Barat\",\"authors\":\"Rahmat Wijaya, Rr. Erlina, Nova Mardiana, Jurusan Manajemen, Universitas Lampung\",\"doi\":\"10.55927/jfbd.v2i2.4913\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"Sales forecasts predict a company's sales. PD Dwi Putra's banana chip sales have fluctuated every month for the past few years, resulting in stock shortages and excesses. Forecasting using historical sales data uses time series methods like moving average and exponential smoothing. This study compares the two forecasting methods to find the lowest error rate and the best method for the company to use for the next four years. The exponential smoothing method outperforms the moving average method for MAPE, MSE, and MAD values, so it is used for future forecasting. According to research, companies should use exponential smoothing with parameter α = 0.6 for the next four years because it has the lowest forecasting error rate. Thus, these parameters are used to forecast the next few years.\",\"PeriodicalId\":189308,\"journal\":{\"name\":\"Journal of Finance and Business Digital\",\"volume\":\"37 6\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2023-07-04\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Journal of Finance and Business Digital\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.55927/jfbd.v2i2.4913\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Journal of Finance and Business Digital","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.55927/jfbd.v2i2.4913","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
Comparison of Moving Average and Exponential Smoothing Methods in Sales Forecasting of Banana Chips Products in Pd. Dwi Putra Tulang Bawang Barat
Sales forecasts predict a company's sales. PD Dwi Putra's banana chip sales have fluctuated every month for the past few years, resulting in stock shortages and excesses. Forecasting using historical sales data uses time series methods like moving average and exponential smoothing. This study compares the two forecasting methods to find the lowest error rate and the best method for the company to use for the next four years. The exponential smoothing method outperforms the moving average method for MAPE, MSE, and MAD values, so it is used for future forecasting. According to research, companies should use exponential smoothing with parameter α = 0.6 for the next four years because it has the lowest forecasting error rate. Thus, these parameters are used to forecast the next few years.