Cite

Product usage for a product group containing three products

PRODUCT USAGE NUMBERU1U2U3
0000
1100
2010
3110
4001
5101
6011
7111

Initial details of products within the non-sterile product group

DEMANDAVG. UNIT COST
NSP1260NOK* 0.172
NSP2461NOK 0.127
NSP3162NOK 0.133

Cost when products are reduced from product group

DESIGN POINT(1,1)(2,1)(3,1)(3,2)(4,1)(5,1)(5,2)(6,1)(6,2)
DescriptionNSP1 is used. NSP2 & NSP3 are substituted by NSP1NSP2 is used. NSP1 & NSP3 are substituted by NSP2NSP1 &NSP2 are used. NSP3 is substituted by NSP1NSP1& NSP2 are used. NSP3 is substituted by NSP2NSP3 is used. NSP1 & NSP2 are substituted by NSP3NSP1 & NSP3 are used. NSP2 is substituted by NSP1NSP1 & NSP3 are used. NSP2 is substituted by NSP3NSP2 & NSP3 are used. NSP1 is substituted by NSP2NSP2 & NSP3 are used. NSP1 is substituted by NSP3
ProductNSP1NSP2NSP3NSP1NSP2NSP3NSP1NSP2NSP3NSP1NSP2NSP3NSP1NSP2NSP3NSP1NSP2NSP3NSP1NSP2NSP3NSP1NSP2NSP3NSP1NSP2NSP3
Initial Demand(Units)260000461026046102604610001622600162260016204611620461162
Added Demand(Units)523000422016200016200072146100004610260000260
Modified Demand(Units)883000883042246102606230008837210162260062307211620461422
Logistics Cost of Products(NOK)133.390.000.000.00114.730.0092.2582.940.0072.4396.40.000.000.00117.31120.540.0050.2872.430.0098.550.00103.6950.280.0082.9481.12
Total Cost of Products(NOK)285.190.000.000.00226.940.00164.8141.520.00117.13175.560.000.000.00234.82244.490.0071.84117.130.00181.460.00195.3171.840.00141.52137.28
Logistics Cost for Product Group(NOK)133.39114.73175.19168.83117.31170.82170.98153.97164.06
Total Cost for Product Group(NOK)285.19226.94306.32292.69234.82316.33298.59267.15278.8
% saving Logistics Cost35.1444.2114.8117.9142.9616.9416.8625.1320.23
% saving Total Cost13.7131.337.3111.4428.954.299.6519.1715.64

Substitution factor of the product group

SP1SP2
SP112
SP211

Overall results

STERILENON-STERILETOTAL
Current ProcessNumber of Products16456862331
Logistics Cost (NOK)2 027 4371 240 1023 267 540
Total Cost (NOK)9 890 4396 334 96416 225 404
All products used with optimised InventoryNumber of Products16456862331
% reduction in number of Products0.000.000.00
Logistics Cost (NOK)663 507245 603909 110
% reduction in logistics Cost67.2780.1972.18
Total Cost (NOK)7 651 8305 572 99013 224 820
% reduction in total Cost22.6312.0318.49
Substitution ModelNumber of Products15245452069
% reduction in number of Products7.3620.5511.24
Logistics Cost (NOK)636 228215 468851 696
% reduction in logistics Cost68.6282.6273.93
Total Cost (NOK)7 123 5965 483 92712 607 523
% reduction in total Cost27.9713.4322.30

Number of possible product usage and design points based on size of product groups

SIZE OF PRODUCT GROUPNO. OF POSSIBLE PRODUCT USAGENo. OF DESIGN POINTS
111
233
3710
531196
825541393
1010232237921
15327671.39 * 1011

Design points for a product group of three products

DESIGN POINTSU1U2U3W1JW2JW3J
1,11000 1 10 0 00 0 0
2,10100 0 01 0 10 0 0
3,11100 0 10 0 00 0 0
3,21100 0 00 0 10 0 0
4,10010 0 00 0 01 1 0
5,11010 1 00 0 00 0 0
5,21010 0 00 0 00 1 0
6,10110 0 01 0 00 0 0
6,20110 0 00 0 01 0 0
7,11110 0 00 0 00 0 0

Cost when all the products in the product group are used

DESIGN POINT: (7, 1)NSPjNSP2NSP3TOTAL
Demand (Units)260461162883
Logistics Cost (NOK)72.4382.9450.28205.66
Total Cost (NOK)117.13141.5271.84330.49

Initial data of the product group

DEMANDAVG. UNIT COST
SP150NOK 54.95
SP237NOK 73.53

Cost when both products are used

DESIGN POINT: (3,1)SP1Sp2TOTAL
Demand (Units)503787
Logistics Cost (NOK)577.20576.111 153.31
Total Cost (NOK)3 324.463 296.706 621.15

Cost when only one product is used

DESIGN POINT(1,1)(2,1)
DescriptionSP1 is used. SP2 is substituted by SP1SP2 is used. SP1 is substituted by SP2
ProductSP 1SP2SP1SP2
Initial Demand(Units)500037
Added Demand(Units)740050
Modified Demand(Units)1240087
Logistics Cost of Products(NOK)903.110.000.00876.99
Total Cost of Products(NOK)7 716.300.000.007 274.05
Logistics Cost for Product Group(NOK)903.11876.99
Total Cost for Product Group(NOK)7 716.307 274.05
% saving Logistics Cost21.6923.96
% saving Total Cost- 16.54-9.86

Notations used in the substitution model

NOTATIONDESCRIPTION
NTotal number of products within the product group
i, jProduct number within the product group; i, j ∈ (1,...,N)
PNotation used for product usage number
MNotation used for the design point
Uip$U_{i}^{p}${1,0,$\left\{ \begin{matrix}1, \\0, \\\end{matrix} \right.$if product i within the product group is used in the product usage number Otherwise
UiM$U_{i}^{M}${1,0,$\left\{ \begin{matrix}1, \\0, \\\end{matrix} \right.$if product / within the product group is used in the design point M Otherwise
UjM$U_{j}^{M}${1,0,$\left\{ \begin{matrix}1, \\0, \\\end{matrix} \right.$if product j within the product group is used in the design point M Otherwise
WjiM$W_{ji}^{M}$if product j within the product group is used in the design point M where UjM$U_{j}^{M}${1,0,$\left\{ \begin{matrix}1, \\0, \\\end{matrix} \right.$Otherwise
SijM$S_{ij}^{M}${X,0,$\left\{ \begin{matrix}\text{X,} \\0, \\\end{matrix} \right.$if x units of product i can substitute 1 unit of product j within the product group at the design point M Otherwise
Where x is a real number
RijM$R_{ij}^{M}${1,ifSijM00,ifSijM=0$\left\{ \begin{array}{*{35}{l}}1, & \text{if}\,S_{ij}^{M}\ne 0 \\0, & \text{if}\,S_{ij}^{M}=0 \\\end{array} \right.$
IDi$I{{D}_{i}}$Initial demand of product i within the product group
CDiM$CD_{i}^{M}$Modified demand of product i within the product group at the design point M with the replacement factor
DiM$D_{i}^{M}$Modified demand of product i within the product group at the design point M with the conversion factor
LCiM$LC_{i}^{M}$Logistics cost of product i within the product group at the design point M
TCiM$TC_{i}^{M}$Total cost of product i within the product group at the design point M
LCM$L{{C}^{M}}$Summation of logistics cost of products in the product group at the design point M
TCM$T{{C}^{M}}$Summation of the total cost of products in the product group at the design point M