Journals Information
Universal Journal of Management Vol. 5(9), pp. 413 - 417
DOI: 10.13189/ujm.2017.050901
Reprint (PDF) (264Kb)
Forecasting the Inventory Needs for the City Schools Division of Mabalacat Using Moving Average and Exponential Smoothing
Ronilyn M. Telan *, Mary Ann F. Quioc
Mabalacat City College, Philippines
ABSTRACT
This study focused on the development of a decision-support system to forecast the inventory needs of the City Schools Division of Mabalacat. Each Property Custodian, called District Property Custodian for primary and Secondary School Supply Officer for secondary, is responsible for determining the needs and excess items of schools within their jurisdiction. Their tasks involve itemization of each school's physical properties to be able to forward proper requests for additional needs to division office. Such task requires time to be finished as the bulk of data needed to be processed and analyzed are increasing annually. Hence, delays had been experienced from requests to the delivery of the requested items. The Property Custodians should be able to plan the demand or identify the number of needed equipment and items of each school within their jurisdictions before the request will be delivered. The said manual procedures in the inventory had been automated in the new system. In order to forecast the necessary number of items for each school in the division office, the researchers applied Moving Average and Exponential Smoothing. The data resulted in the said forecast had been used to request items with neither minimal excess nor insufficiency that results in wastage.
KEYWORDS
Decision-support System, Moving Average, Exponential Smoothing, Inventory Forecasting
Cite This Paper in IEEE or APA Citation Styles
(a). IEEE Format:
[1] Ronilyn M. Telan , Mary Ann F. Quioc , "Forecasting the Inventory Needs for the City Schools Division of Mabalacat Using Moving Average and Exponential Smoothing," Universal Journal of Management, Vol. 5, No. 9, pp. 413 - 417, 2017. DOI: 10.13189/ujm.2017.050901.
(b). APA Format:
Ronilyn M. Telan , Mary Ann F. Quioc (2017). Forecasting the Inventory Needs for the City Schools Division of Mabalacat Using Moving Average and Exponential Smoothing. Universal Journal of Management, 5(9), 413 - 417. DOI: 10.13189/ujm.2017.050901.