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/studentpapers/record/4024475
 author
 Boklund, Sebastian and Lindblad, Frej
 supervisor

 Peter Berling ^{LU}
 organization
 course
 MIO920
 year
 2013
 type
 M1  University Diploma
 subject
 other publication id
 13/5460
 language
 English
 id
 4024475
 date added to LUP
 20130913 15:37:00
 date last changed
 20130913 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}, }