International Journal of Applied Science and Engineering Research
  • Year: 2013
  • Volume: 2
  • Issue: 3

Forecasting Product Sales for Masters Energy Oil and Gas Using Different Forecasting Methods

  • Author:
  • Ezeliora Chukwuemeka Daniel, Chinwuko Emmanuel Chuka
  • Total Page Count: 15
  • Page Number: 241 to 255

Department of Industrial and Production Engineering, Nnamdi Azikiwe University, Awka, Anambra State, Nigeria

*Corresponding author e-mail: cezeliora@gmail.com

Online published on 11 September, 2014.

Abstract

This research work addresses the problem of forecasting for product sales using different forecasting techniques and models. It focuses on the application of different forecasting methods in the case study company. Product sales of their monthly sales data were gathered in the case study company over the months for three years. The data were collected, modeled and analyzed using different forecasting methods. The models and methods used were three period moving average, weighted moving average and simple exponential smoothing models. These were used to forecast for monthly and quarterly using the historical data collected. From the result analysis, forecasts of three years in the future were developed. This is to their future sales of the products within the next three years in the future. In conclusion, there is always a need to use more than one forecasting methods, to avoid errors during forecasting and to choose a better forecast.

Keywords

Forecasting, Moving Average, Weighted Moving Average, Simple Exponential Smoothing