Skip to main content

LUP Student Papers

LUND UNIVERSITY LIBRARIES

Inventory Control at AQ Electric Suzhou

Boklund, Sebastian and Lindblad, Frej (2013) MIO920
Production 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:
author
Boklund, Sebastian and Lindblad, Frej
supervisor
organization
course
MIO920
year
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},
}