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
Tags:	Add Tag No Tags, Be the first to tag this record!

id	my-uthm-ep.10993
record_format	uketd_dc
spelling	my-uthm-ep.109932024-05-20T01:36:47Z Demand forecasting using time series analysis and economic order quantity model for inventory control: a case study of a construction company 2023-06 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 http://eprints.uthm.edu.my/10993/ http://eprints.uthm.edu.my/10993/1/24p%20PANG%20HUI%20ER.pdf text en public http://eprints.uthm.edu.my/10993/2/PANG%20HUI%20ER%20COPYRIGHT%20DECLARATION.pdf text en staffonly http://eprints.uthm.edu.my/10993/3/PANG%20HUI%20ER%20WATERMARK.pdf text en validuser mphil masters Universiti Tun Hussein Onn Malaysia Fakulti Pengurusan Teknologi dan Perniagaan
institution	Universiti Tun Hussein Onn Malaysia
collection	UTHM Institutional Repository
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
qualification_name	Master of Philosophy (M.Phil.)
qualification_level	Master's degree
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
granting_institution	Universiti Tun Hussein Onn Malaysia
granting_department	Fakulti Pengurusan Teknologi dan Perniagaan
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
_version_	1804890132661141504

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

Similar Items