گروه بندی موجودی ها بر اساس ویژی ها و مشخصات آنها جهت تخصیص سیستم برنامه ریزی و کنترل مناسب

“Inventory classification based on their
characteristics to assign appropriate planning and
control system “

Abstract:
Many organizations keep thousands of items in their warehouses,
which may worth more than fifty percent of all company’s
expenses. Controlling of these items by one material planning and
control system may not be rational or economic. Every methodology
has different cost and service level in different environments.
Therefore, the tool required in order to categorize the material based
upon suitability of material planning and control system. Proper
planning and control of materials and parts has always been an
important issue in manufacturing and business. Some techniques
have been developed and introduced in the last few decades to fulfill
this task in a systematic and effective manner which can be
categorized into three main groups of push, pull and traditional
systems. Each system has advantages and pitfalls and selecting the
best choice depends on individual material’s characteristics.
Therefore, in this research we present a model to classify material
and components in a manufacturing company by applying a
multiple criteria classification model and using comprehensive
criteria.
Finally we implement our model in a home appliances company
using real data.
Key words: Inventory control & planning, Multiple criteria
classification, JIT, MRP.

پیوست:
MODEL:
! Introducing required sets;
SETS:
GROUP;
CRITERIA;
ALTERNATIVE;
WEIGHT(GROUP,CRITERIA):W;
VALUE(GROUP,ALTERNATIVE,CRITERIA):V;
GROUP_VALUE(GROUP,ALTERNATIVE):GV;
! Decision Variables;
AFFILIATION(GROUP,ALTERNATIVE):S;
ENDSETS
DATA:
GROUP=1..3;
CRITERIA= VOLUME FRAGILITY VALUE ESSENTIALITY PERISHABILITY
S_GRADE S_DISTANCE SPECIFICITY LEAD_TIME OBSOLESCENCE FLUCTUATION;
ALTERNATIVE=1..942;
W= 0.104 0.101 0.101 0.104 0.094 0.107 0.104 0.094 0.104 0.091 0.000
۰.۱۲۲ ۰.۰۲۶ ۰.۱۰۵ ۰.۱۳۱ ۰.۱۰۵ ۰.۰۹۱ ۰.۱۰۴ ۰.۱۰۵ ۰.۱۰۵ ۰.۱۰۵ ۰.۰۰۰
۰.۱۲۵ ۰.۱۱۷ ۰.۱۲۵ ۰.۱۱۳ ۰.۱۱۷ ۰.۰۵۴ ۰.۰۰۰ ۰.۱۰۹ ۰.۰۲۳ ۰.۱۰۹ ۰.۱۰۶;
V=@OLE(“C:BOOK”);
@OLE(“C:S.xlsx”)=S;
ENDDATA
! Binary Constraint;
@FOR(AFFILIATION(G,A):@BIN(S(G,A)));
@FOR(GROUP_VALUE(G,A):GV(G,A)=@SUM(VALUE(G,A,C):V(G,A,C)*W(G,C)));
! Objective Function;
MAX=@SUM(AFFILIATION(G,A):S(G,A)*GV(G,A));
! Constraints;
@FOR(ALTERNATIVE(A):@SUM(AFFILIATION(G,A):S(G,A))=1);
@FOR(GROUP(G)|G#EQ#1:@SUM(AFFILIATION(G,A):S(G,A))<=188);
END

MODEL:
! Introducing required sets;
SETS:
GROUP;
CRITERIA;
ALTERNATIVE;
WEIGHT(GROUP,CRITERIA):W;
VALUE(GROUP,ALTERNATIVE,CRITERIA):V;
GROUP_VALUE(GROUP,ALTERNATIVE):GV;
! Decision Variables;
AFFILIATION(GROUP,ALTERNATIVE):S;
ENDSETS
DATA:
GROUP=JIT MRP ROP;
CRITERIA= VOLUME FRAGILITY VALUE ESSENTIALITY PERISHABILITY
S_GRADE S_DISTANCE SPECIFICITY LEAD_TIME OBSOLESCENCE FLUCTUATION;
ALTERNATIVE=1..942;
W= 0.104 0.101 0.101 0.104 0.094 0.107 0.104 0.094 0.104 0.091 0.000
۰.۱۲۲ ۰.۰۲۶ ۰.۱۰۵ ۰.۱۳۱ ۰.۱۰۵ ۰.۰۹۱ ۰.۱۰۴ ۰.۱۰۵ ۰.۱۰۵ ۰.۱۰۵ ۰.۰۰۰
۰.۱۲۵ ۰.۱۱۷ ۰.۱۲۵ ۰.۱۱۳ ۰.۱۱۷ ۰.۰۵۴ ۰.۰۰۰ ۰.۱۰۹ ۰.۰۲۳ ۰.۱۰۹ ۰.۱۰۶;
V=@OLE(“C:BOOK”);
@OLE(“C:S.xlsx”)=S;
ENDDATA
! Binary Constraint;
@FOR(AFFILIATION(G,A):@BIN(S(G,A)));
@FOR(GROUP_VALUE(G,A):GV(G,A)=@SUM(VALUE(G,A,C):V(G,A,C)*W(G,C)));
! Objective Function;
MAX=@SUM(AFFILIATION(G,A):S(G,A)*GV(G,A));
! Constraints;
@FOR(ALTERNATIVE(A):@SUM(AFFILIATION(G,A):S(G,A))=1);
END