Inventory Control at AQ Electric Suzhou
(2013) MIO920Production Management
- Abstract
- This report details the process and result of developing a mathematical inventory control model to be use by AQ Electric Suzhou. The mathematical model was written in Microsoft Excels inherent programming language Visual Basic and utilizes printouts such as sales history, bill of materials, component data etc. from AQ Electric Suzhous ERP system Monitor to derive a demand history for each component. Each component is then given a compound Poisson lead time demand distribution with an optimization of reorder point in a (R,Q) continuous review inventory system with regards to service level and maximum inventory constraints. The results were that AQ Electric Suzhou would find it difficult to achieve the target on time delivery and target... (More)
- This report details the process and result of developing a mathematical inventory control model to be use by AQ Electric Suzhou. The mathematical model was written in Microsoft Excels inherent programming language Visual Basic and utilizes printouts such as sales history, bill of materials, component data etc. from AQ Electric Suzhous ERP system Monitor to derive a demand history for each component. Each component is then given a compound Poisson lead time demand distribution with an optimization of reorder point in a (R,Q) continuous review inventory system with regards to service level and maximum inventory constraints. The results were that AQ Electric Suzhou would find it difficult to achieve the target on time delivery and target inventory turn rate simultaneously without changing input parameters such as minimum order quantities and lead times. (Less)
Please use this url to cite or link to this publication:
http://lup.lub.lu.se/student-papers/record/4024475
- author
- Boklund, Sebastian and Lindblad, Frej
- supervisor
- organization
- course
- MIO920
- year
- 2013
- type
- M1 - University Diploma
- subject
- other publication id
- 13/5460
- language
- English
- id
- 4024475
- date added to LUP
- 2013-09-13 15:37:00
- date last changed
- 2013-09-13 15:37:00
@misc{4024475, abstract = {{This report details the process and result of developing a mathematical inventory control model to be use by AQ Electric Suzhou. The mathematical model was written in Microsoft Excels inherent programming language Visual Basic and utilizes printouts such as sales history, bill of materials, component data etc. from AQ Electric Suzhous ERP system Monitor to derive a demand history for each component. Each component is then given a compound Poisson lead time demand distribution with an optimization of reorder point in a (R,Q) continuous review inventory system with regards to service level and maximum inventory constraints. The results were that AQ Electric Suzhou would find it difficult to achieve the target on time delivery and target inventory turn rate simultaneously without changing input parameters such as minimum order quantities and lead times.}}, author = {{Boklund, Sebastian and Lindblad, Frej}}, language = {{eng}}, note = {{Student Paper}}, title = {{Inventory Control at AQ Electric Suzhou}}, year = {{2013}}, }