Muhammad Afif, Purwandi (2020) A Development of Inventory Policy and Material Requirement Planning System: Case Study on Bottled Water Company. Other thesis, Institut Teknologi Sepuluh Nopember.
Preview |
Text
02411640000020-Undergraduate_Thesis.pdf Download (1MB) | Preview |
Abstract
A Development of Inventory Policy and Material Requirement Planning System: Case Study on Bottled Water Company
============================================================
PT. XYZ is one of the largest bottled water companies in Indonesia with 800 billion IDR annual revenue and has been continuously expanding its business. Under its operation, the company has been facing numerous challenges in inventory control issues, particularly on inventory policy and material requirement planning (MRP) system. On inventory policy, the company implements generalized inventory policy across all products, indicating that the policy does not yet consider a unique behavior between each product. On the MRP system, the company has a difficulty to accurately measure how many goods to be purchased and its scheduling system. This issue has been happening due to the insufficiency of the existing system to perform the procurement system effectively and efficiently. This research aims to develop a better MRP system and strategic inventory policy that will be examined by Monte Carlo Simulation. The suggested MRP system comprises of the development and integration of four main parts, namely the master data, bill of material, demand management, and planning & monitoring. Two MRP models are developed, namely the improved MRP Excel model and software requirement specification for digitalization purposes. To ensure that the system produces more robust and efficient inventory control, usability testing must be carried out consisting of both system usability scale assessment and feedback form. In the inventory policy, three methodologies are assessed including the existing system, continuous review (s, S), and Fixed-Order-Interval (FOI). The simulations results suggest the company to implement 21 continuous review (s, S), 4 FOI, and maintaining two existing inventory policy across 27 observed finished goods. By implementing those suggested policies, the company can reduce the total cost up to around 40 billion IDR while still maintaining the service level above the target of 99.5%.
| Item Type: | Thesis (Other) |
|---|---|
| Uncontrolled Keywords: | Keywords: Continuous Review (s, S), Fixed-Order-Interval (FOI), Material Requirement Planning System, Monte Carlo simulation. |
| Subjects: | T Technology > T Technology (General) > T57.62 Simulation T Technology > T Technology (General) > T58.62 Decision support systems |
| Divisions: | Faculty of Industrial Technology > Industrial Engineering > 26201-(S1) Undergraduate Thesis |
| Depositing User: | Muhammad Afif Purwandi |
| Date Deposited: | 20 Aug 2020 07:45 |
| Last Modified: | 30 Oct 2023 08:14 |
| URI: | http://repository.its.ac.id/id/eprint/79382 |
Actions (login required)
 |
View Item |