Cover Image

Demand forecasting using time series analysis and economic order quantity model for inventory control: a case study of a construction company

Inventory management, is the process of ensuring the right amount supply is available in a company. It helps the company to maintain inventory level and fulfill the customers’ needs and wants. But unfortunately, there are still many construction companies fail to practice a systematic inventory mana...

Full description

Saved in:
Bibliographic Details
Main Author: Pang, Hui Er
Format: Thesis
Language:English
English
English
Published: 2023
Subjects:
T Technology (General)
Online Access:http://eprints.uthm.edu.my/10993/1/24p%20PANG%20HUI%20ER.pdf
http://eprints.uthm.edu.my/10993/2/PANG%20HUI%20ER%20COPYRIGHT%20DECLARATION.pdf
http://eprints.uthm.edu.my/10993/3/PANG%20HUI%20ER%20WATERMARK.pdf
http://eprints.uthm.edu.my/10993/
Tags: Add Tag
No Tags, Be the first to tag this record!
id my.uthm.eprints.10993
record_format eprints
spelling my.uthm.eprints.109932024-05-20T01:36:47Z http://eprints.uthm.edu.my/10993/ Demand forecasting using time series analysis and economic order quantity model for inventory control: a case study of a construction company Pang, Hui Er T Technology (General) Inventory management, is the process of ensuring the right amount supply is available in a company. It helps the company to maintain inventory level and fulfill the customers’ needs and wants. But unfortunately, there are still many construction companies fail to practice a systematic inventory management process in this fast-growing industrial era. Apart from that, they are also lack of proper forecasting techniques for predicting accurate demand. Therefore, the purpose of this study is to identified a suitable inventory management model by integrating the monthly order system, Economic Order Quantity (EOQ) and forecasting techniques. This study is conducted as a case study based on a construction company located in Singapore. Numerical data from the year 2014 to year 2017 for the raw materials is collected from the company’s inventory record. The raw materials are diesel, quarry dust, concrete dan industrial gas. All the data are analysed by Microsoft Excel add-in tool (Xrealstats), QM for Windows and Microsoft Excel. The data from 2014 until 2016 is used by six main forecasting techniques and three performance measure to predict the best forecasted data for 2017. After identifying the most accurate forecasted demand quantity, it is used in the monthly order system and EOQ to compute the minimum total inventory cost. Decisions tree analysis is used to compare minimum total inventory cost in identifying the suitable inventory management model. As a final result, after analysing the minimum total inventory cost, the best suitable forecasting technique and inventory model for all the raw materials is linear regression and EOQ respectively. The EOQ and forecasting techniques proposed in this research are potential to predict the budget for the raw materials efficiently. This will enable the management of the construction company to prevent any financial issues in raw material purchasing in the future 2023-06 Thesis NonPeerReviewed text en http://eprints.uthm.edu.my/10993/1/24p%20PANG%20HUI%20ER.pdf text en http://eprints.uthm.edu.my/10993/2/PANG%20HUI%20ER%20COPYRIGHT%20DECLARATION.pdf text en http://eprints.uthm.edu.my/10993/3/PANG%20HUI%20ER%20WATERMARK.pdf Pang, Hui Er (2023) Demand forecasting using time series analysis and economic order quantity model for inventory control: a case study of a construction company. Masters thesis, Universiti Tun Hussein Onn Malaysia.
institution Universiti Tun Hussein Onn Malaysia
building UTHM Library
collection Institutional Repository
continent Asia
country Malaysia
content_provider Universiti Tun Hussein Onn Malaysia
content_source UTHM Institutional Repository
url_provider http://eprints.uthm.edu.my/
language English
English
English
topic T Technology (General)
spellingShingle T Technology (General)
Pang, Hui Er
Demand forecasting using time series analysis and economic order quantity model for inventory control: a case study of a construction company
description Inventory management, is the process of ensuring the right amount supply is available in a company. It helps the company to maintain inventory level and fulfill the customers’ needs and wants. But unfortunately, there are still many construction companies fail to practice a systematic inventory management process in this fast-growing industrial era. Apart from that, they are also lack of proper forecasting techniques for predicting accurate demand. Therefore, the purpose of this study is to identified a suitable inventory management model by integrating the monthly order system, Economic Order Quantity (EOQ) and forecasting techniques. This study is conducted as a case study based on a construction company located in Singapore. Numerical data from the year 2014 to year 2017 for the raw materials is collected from the company’s inventory record. The raw materials are diesel, quarry dust, concrete dan industrial gas. All the data are analysed by Microsoft Excel add-in tool (Xrealstats), QM for Windows and Microsoft Excel. The data from 2014 until 2016 is used by six main forecasting techniques and three performance measure to predict the best forecasted data for 2017. After identifying the most accurate forecasted demand quantity, it is used in the monthly order system and EOQ to compute the minimum total inventory cost. Decisions tree analysis is used to compare minimum total inventory cost in identifying the suitable inventory management model. As a final result, after analysing the minimum total inventory cost, the best suitable forecasting technique and inventory model for all the raw materials is linear regression and EOQ respectively. The EOQ and forecasting techniques proposed in this research are potential to predict the budget for the raw materials efficiently. This will enable the management of the construction company to prevent any financial issues in raw material purchasing in the future
format Thesis
author Pang, Hui Er
author_facet Pang, Hui Er
author_sort Pang, Hui Er
title Demand forecasting using time series analysis and economic order quantity model for inventory control: a case study of a construction company
title_short Demand forecasting using time series analysis and economic order quantity model for inventory control: a case study of a construction company
title_full Demand forecasting using time series analysis and economic order quantity model for inventory control: a case study of a construction company
title_fullStr Demand forecasting using time series analysis and economic order quantity model for inventory control: a case study of a construction company
title_full_unstemmed Demand forecasting using time series analysis and economic order quantity model for inventory control: a case study of a construction company
title_sort demand forecasting using time series analysis and economic order quantity model for inventory control: a case study of a construction company
publishDate 2023
url http://eprints.uthm.edu.my/10993/1/24p%20PANG%20HUI%20ER.pdf
http://eprints.uthm.edu.my/10993/2/PANG%20HUI%20ER%20COPYRIGHT%20DECLARATION.pdf
http://eprints.uthm.edu.my/10993/3/PANG%20HUI%20ER%20WATERMARK.pdf
http://eprints.uthm.edu.my/10993/
_version_ 1800094636883050496
score 13.211869

Similar Items