P oyec o de in de ca e a
Ga nie Lionel
Design and
implemen a ion o a
solu ion o Vendo
Managed In en o y
Au o : Ga nie Lionel
Di ec o : Ramón Sal ado
Con oca o ia: Mayo 2010
Ti ulación: O ganización Indus ial
Escola Tècnica Supe io d’Enginye ia Indus ial de Ba celona
2/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
3/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
Summa y
Vendo Managed In en o y (VMI) is a ool selec ed by Schneide Elec ic o op imize i s Supply Chain.
The basic p inciple o VMI i ha he manu ac u e is esponsible o managing he s ock o i s
cus ome s, ha a e mainly dis ibu o s.
VMI is complex since i links wo di e en o ganiza ions wi h wo di e en IT sys ems. Ha ing he keys o
he cus ome s’ s ock is a g ea esponsibili y, pa icula ly oday when he p essu e on he cos s is
pe manen . As a consequence, he manu ac u e needs o each high le els o pe o mance i he wan s
o imp o e i s ela ion wi h he cus ome . Any ailu e can mean a loss o business.
F om 2005 o 2007 Schneide Elec ic did a pilo expe ience wi h one o i s big Du ch cus ome . Looking
a he logis ic KPIs his expe ience was a eal success. Bo h companies we e e y happy abou he
esul s. Bu he esou ces in es ed by Schneide Elec ic in his p ojec we e qui e impo an . This closed
he doo o any implemen a ion o VMI on a la ge scale.
The a ge o my p ojec was o imp o e he e iciency o ou in e nal VMI p ocesses in o de o educe
he in es men o ime needed o implemen and main ain new cus ome s.
An analysis o he ime spen on a ious asks showed ha he e we e a lo o manual s eps and
ope a ions. Fu he mo e he solu ion implemen ed o he i s cus ome was complex and wi h limi ed
capaci ies. By de eloping a new ool Schneide Elec ic could indus ialize VMI.
Once i has been iden i ied ha a new ool was needed, I had o de ine an a chi ec u e ha allows:
To handle a lo o da a
To implemen easily new cus ome s
To educe signi ican ly he ime needed o un up VMI
The solu ion is based on a se o Access da abases communica ing wi h each o he s. Th ee main
da abases a e he co e o his p ojec . Cus ome ’s da a is s o ed in a speci ic da abase (one da abase pe
cus ome ), ano he da abase is used o he in e ace and a hi d one is making he calcula ions and
communica ions be ween he o he s.
As a esul all he ope a ions a e simpli ied o he use . He can ca y ou mos o his asks only wi h one
click when i could ake him one comple e day in he pas .
Once his solu ion was de eloped, he i s VMI cus ome mig a ed o i wi hou any issue (Fully
anspa en o he cus ome ). I has hen been implemen ed success ully wi h a new cus ome in a
eco d ime!
Un o una ely, due o he global c isis, Schneide Elec ic empo a y decided summe 2008 o slow down
he implemen a ion o VMI since e en i i is cos ing less oday, i is s ill ep esen ing a cos .
4/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
5/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
Glossa y
Abb e ia ion
Desc ip ion
DB
Da abase
ETSEIB
Escola Tècnica Supe io d'Enginye ia Indus ial de Ba celona
FTE
Full Time Employee ( ep esen s 8 hou s o wo k in he Ne he lands)
RDC
Regional Dis ibu ion Cen e
ROI
Re u n On In es men
SPO
S ock Pa ame e Op imize
SE
Schneide Elec ic
VMI
Vendo Managed In en o y
6/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
7/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
Index
1. In oduc ion ..................................................................................................... 9
2. P esen a ion o he p ojec and he company ............................................... 11
2.1. Schneide Elec ic: Make he mos o you ene gy ...................................... 11
2.1.1. His o y o Schneide Elec ic .................................................................................. 11
2.1.2. Business o Schneide Elec ic .............................................................................. 12
2.1.3. Schneide Elec ic: A global company .................................................................... 14
2.1.4. Regional Dis ibu ion Cen e o Ven ay .................................................................. 15
2.2. Vendo Managed In en o y ......................................................................... 16
2.2.1. De ini ion o Vendo Managed In en o y (VMI) ...................................................... 16
2.2.2. Bene i s o VMI ...................................................................................................... 16
2.2.3. Flows o in o ma ion in VMI ................................................................................... 17
2.2.4. Di e en le els o implica ion in VMI ...................................................................... 19
2.3. Pu pose o he p ojec ................................................................................. 19
3. De elopmen o he p ojec ........................................................................... 21
3.1. Plan: Iden i ica ion o he equi emen s ....................................................... 21
3.1.1. Di e en ope a ions necessa y o un wi h VMI ...................................................... 22
3.1.2. Si ua ion a p ojec launch ..................................................................................... 23
3.2. Analyze: Measu e and ind he poin s o imp o emen s .............................. 25
3.2.1. Design as solu ion ha can handle se e al cus ome s........................................... 25
3.2.2. Reduce he ime in es men pe cus ome ............................................................. 26
3.2.3. E alua ion o he p ojec cos s ............................................................................... 32
3.2.4. Calcula ion o he Re u n On In es men ............................................................... 33
3.3. De elop: C ea e he solu ion complying wi h he equi emen s ................... 35
3.3.1. Design o he a chi ec u e ...................................................................................... 35
3.3.2. The esul .............................................................................................................. 38
3.4. Tes : Make su e he solu ion is wo king p ope ly ......................................... 40
3.5. E alua e: E alua e ha he solu ion designed mee s he equi emen s ...... 41
Conclusions ......................................................................................................... 45
1. Conclusions o he p ojec ........................................................................... 45
8/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
2. Recommenda ions ....................................................................................... 45
3. Acknowledgemen s ...................................................................................... 46
4. Pe sonal imp essions ................................................................................... 47
Appendix .............................................................................................................. 49
A. Calcula ions ................................................................................................. 49
A.1. Es ima ion o he sa ings ....................................................................................... 49
A.2. Es ima ion o he cos s ........................................................................................... 51
B. Documen s ................................................................................................... 55
B.1. Speci ica ion o ile exchanges ............................................................................... 55
C. Publica ions .................................................................................................. 58
D. Bibliog aphy ................................................................................................. 60
9/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
1. In oduc ion
Vendo Managed In en o y (VMI) is a way o op imize he supply chain whe e he supplie is esponsible
o managing he s ock o his cus ome . This is o example one o he success ul business models used
by Wal-Ma , he wo ld's la ges public co po a ion by e enue1.
Since 2005 Schneide Elec ic is in es iga ing he possibili ies o implemen ing VMI wi h some o i s big
cus ome s. This ool would be a way o Schneide Elec ic o inc ease i s supply chain pe o mance, bu
also o s eng hen i s ela ions wi h i s cus ome s.
F om summe 2005 o summe 2007 Schneide Elec ic did a success ul pilo p ojec wi h one o hei
Du ch cus ome . Va ious KPIs showed some posi i e e ec s on he supply chain pe o mance. Se ice
le el o he end cus ome inc eased by 6 poin s while educing in en o y le els a dis ibu o side. The
ela ion wi h he a ge ed cus ome also s ongly imp o ed.
Bu he esou ces in es ed by Schneide Elec ic on his pilo p ojec we e high. Wi h his se up
Schneide Elec ic could no imagine implemen ing VMI on a la ge scale, e en wi h he posi i e esul s
ha i showed.
When I was hi ed summe 2007, my mission was o imp o e he ools and p ocesses in o de o make
VMI mo e e icien . So in a i s s ep I had o analyze he cu en se up in o de o see whe e he
po en ial poin s o imp o emen we e. Ou o his analysis I saw ha indeed a lo o s eps in he
ope a ing p ocesses we e manual and could be pa ly au oma ed. Fu he mo e, as my p edecesso wen
in o some hing o ally new o he company, he solu ion ha was buil was e y complex and wi h
limi ed capaci ies. Wi h hindsigh i was possible o simpli y i and make i mo e powe ul.
1 Sou ce: 2008 Fo une Global 500 - h p://money.cnn.com/magazines/ o une/global500/2008/index.h ml
16/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
2.2. Vendo Managed In en o y
2.2.1. De ini ion o Vendo Managed In en o y (VMI)
VMI is a means o op imizing Supply Chain pe o mance in which he manu ac u e is esponsible o
main aining he dis ibu o ’s in en o y le els. The manu ac u e has access o he dis ibu o ’s
in en o y da a and is esponsible o gene a ing pu chase o de s.
Fi s e e ences o VMI appea ed a he end o he 90s, e en i we “don’ ac ually know how he VMI
concep o igina ed”4.
The manu ac u e ecei es elec onic da a ha ells him he dis ibu o ’s sales and s ock le els. The
manu ac u e is esponsible o c ea ing and main aining he in en o y plan. Finally, Unde VMI, he
manu ac u e gene a es he o de , no he dis ibu o .
VMI does no change he "owne ship" o in en o y. I emains as i did p io o VMI.
2.2.2. Bene i s o VMI
DUAL BENEFITS:
Bo h pa ies a e in e es ed in gi ing be e se ice o he end cus ome . Ha ing he co ec i em
in s ock when he end cus ome needs i , bene i s all pa ies in ol ed.
A ue pa ne ship is o med be ween he Manu ac u e and he Dis ibu o . They wo k close
oge he and s eng hen hei ies.
4 In en o y Classi ica ion Inno a ion: Pa ing he Way o Elec onic Comme ce and Vendo Managed In en o y -
Russ B oeckelmann (1999)
h p://books.google. /books?id=kCJylW0ddxAC
17/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
DISTRIBUTOR BENEFITS:
A dec ease in s ock-ou s and a dec ease in in en o y le els.
Planning and o de ing cos will dec ease due o he esponsibili y being shi ed o he
Manu ac u e .
The o e all se ice le el is imp o ed by ha ing he igh p oduc a he igh ime.
The dis ibu o ge s all he knowledge o he manu ac u e on i s p oduc s.
The manu ac u e is mo e ocused han e e on p o iding g ea se ice.
MANUFACTURERS BENEFITS:
Visibili y o he Dis ibu o ’s Poin o Sale da a makes o ecas ing easie .
P omo ions can be mo e easily inco po a ed in o he in en o y plan.
A educ ion in Dis ibu o o de ing e o s (which in he pas would p obably lead o a e u n)
Visibili y o S ock Le els helps o iden i y p io i ies ( eplenishing o s ock o a s ock-ou ?). Be o e
VMI, a manu ac u e has no isibili y o he quan i y and he p oduc s ha a e o de ed. Wi h
VMI, he manu ac u e can see he po en ial need o an i em be o e he i em is o de ed.
2.2.3. Flows o in o ma ion in VMI
VMI be ween wo en i ies implies ha he manu ac u e and he dis ibu o a e exchanging addi ional
da a on a egula basis:
In en o y le els – F om dis ibu o o manu ac u e
This ells he manu ac u e he dis ibu o ’s in en o y le el. Fo each e e ence i con ains:
The cu en s ock quan i y
The quan i y in o de
The quan i y ese ed o some cus ome o de s
The backo de quan i y (s ock ou )
The s ock s a us ( e e ence s ocked o no )
18/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
This in o ma ion is usually communica ed on a daily basis
Sales his o y – F om dis ibu o o manu ac u e
This ells he manu ac u e he dis ibu o ’s sales quan i ies. Fo each e e ence i con ains:
The quan i y sold o e he las pe iod
The numbe o sold lines
Fo ecas s can also be p o ided by he dis ibu o
This in o ma ion is usually communica ed on a mon hly basis
O de p oposal – F om manu ac u e o dis ibu o
This communica es o he dis ibu o he e e ences and he quan i ies ha he manu ac u e ad ices o
o de . Fo each e e ence i con ains:
The ShipTo loca ion (since se e al wa ehouses can be handled o he same dis ibu o )
The o de quan i y
This in o ma ion is usually communica ed on a daily basis. To inc ease e iciency ag eemen s can be
done be ween he dis ibu o and he manu ac u e o place o de s only on ce ain days o he week.
Pu chase O de , O de Acknowledgemen and In oice a e sen acco ding o he s anda d low
Gene al lows o in o ma ion in VMI se up
Pu chase O de
O de Acknoledgmen
In oice
O de P oposal
In en o y le els
Sales his o y
Dis ibu o
Final
cus ome s
Final
cus ome
need
Deli e y
Balance
needs
essou ces
19/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
2.2.4. Di e en le els o implica ion in VMI
VMI implies an implica ion a di e en le els, om he de ini ion o he dis ibu o ‘s ock collec ion o he daily
o de ing ac i i ies.
Di e en le els o implica ion
2.3. Pu pose o he p ojec
Summe 2007 VMI was al eady implemen ed as a pilo wi h one Du ch cus ome . As his expe ience was
a i s y, i was no op imized. A his ime he p io i y was o se up p ocesses o un VMI li e wi h one
cus ome and ully unde s and he concep o VMI. As i was i s designed, he need o esou ces on
Schneide Elec ic side was high o :
New p ojec implemen a ion
Day o day managemen o cus ome ’s in en o y le els
Op imiza ion o he s ock pa ame e s
(Sa e y s ock, o ecas s, O de quan i y)
Bene i s & s akes o each le el
Gene a ion o he PO
(Needs and esou ces balance wi h lo size and deli e y
calenda )
Communica ion
(Da a exchange, global isibili y and KPI sha ing)
De ini ion o he dis ibu o s ock
collec ion
(Dis ibu o s a egy, SE logis ic o e s a egy,
ma ke ing inpu )
Be e A ailabili y o Schneide p oduc s (con olled
logis ic o e )
S ock con ol o he dis ibu o
Be e unde s anding o he consump ion pa e n o
he dis ibu o
Be e s ock managemen
Be e o ecas ing
Reduc ion o obsole e s ock
Cos educ ion in o de p ocessing a he dis ibu o
Be e eme gency ea men when “long lead imes” o
ma e ial sho age
Be e packing usage a e
S onge link wi h he dis ibu o
Dis ibu o commi men
20/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
Fu he mo e, he echnical solu ion implemen ed was based on a simple Excel ile which limi ed s ongly he
po en ial o VMI.
One comple e esou ce was a ec ed o VMI only o p ojec managemen . Ano he esou ce was
wo king a 20% as a VMI s ock con olle on he daily ac i i ies ( e iew o he o de p oposals,
adjus men o s ock pa ame e s, mee ings…)
As Schneide Elec ic wan ed o implemen VMI on a la ge scale i became ob ious ha a mo e e icien
solu ion needed o be designed.
I was hi ed in July 2007 as a p ojec manage o
De elop and implemen a solu ion o indus ialize VMI
Design as solu ion ha can handle se e al cus ome s
Reduce he ime in es men pe cus ome
This speci ic p ojec ook place om July 2007 o June 2008.
21/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
3. De elopmen o he p ojec
To d i e his p ojec a me hodology close o he DMAIC (6 Sigma5) has been ollowed.
O e iew o he me hodology used
This me hodology helps o s uc u e he p ojec and ensu e ha pe manen imp o emen is going on.
The ollowing pa o he p esen PFC will be in line wi h his s uc u e.
3.1. Plan: Iden i ica ion o he equi emen s
The i s s ep o he p ojec consis ed in iden i ying he a ious equi emen s in o de o ha e a ull
pic u e:
Wha needs o be done?
Wha is he cu en si ua ion?
Which a e he poin s o imp o emen ?
5 Lean Six Sigma o Supply Chain Managemen - James William Ma in (2006)
De elop
Plan
Analyze
Tes
E alua e
Implemen
Ini ializa ion
o he p ojec
22/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
3.1.1. Di e en ope a ions necessa y o un wi h VMI
He e a e lis ed all he ac ions in he scope o VMI.
3.1.1.1 Daily o de ing ac i i ies
Ge da a om he dis ibu o
Balance he needs s. he esou ces
Re iew o he p oposal by manu ac u e
Send he o de p oposal o he cus ome
3.1.1.2 Append he da a sen by he cus ome
Managemen o he ile exchanges (sales ile)
Reco d sales his o y
Reco d s ock his o y
Reco d p oduc in o ma ion
3.1.1.3 Upda e o o ecas s
Ge he sales his o y
Ge he in o ma ion on ends om Ma ke ing
Calcula ion o o ecas s
Upda e he o ecas s in he sys em
3.1.1.4 Upda e s ock pa ame e s
Calcula ion o s ock pa ame e s
Include he special ag eemen s coming om ma ke ing (example: s ocking o a new p oduc )
Upda e he s ock pa ame e s in he sys em
3.1.1.5 Analyze he da a (s ock and sales)
Follow up o s ock alue
Inpu o s ock collec ion de ini ion (based on sales equency)
Iden i ica ion o p oduc s o be e u ned
Analysis o backo de s (p oduc s no deli e ed on ime)
23/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
Ac ions and esponsibili ies in he VMI se up
3.1.2. Si ua ion a p ojec launch
1.1.1 In e ace be ween Schneide Elec ic and he dis ibu o
As VMI was al eady li e wi h one cus ome a p ojec launch, a pa o he solu ion was al eady in place.
In o de o manage he daily low o in o ma ion and make he balance o needs, a web based solu ion
om he ma ke was selec ed.
This solu ion is p oposed by he Danish company Videli y6.
Videli y:
Collec s he daily in en o y ile om he dis ibu o
T ansla es he ile i necessa y (= mo e lexibili y o he dis ibu o )
Makes he balance needs- esou ces based on he s ock pa ame e s uploaded by he
manu ac u e
C ea es he o de p oposal
Sends he o de p oposal o he dis ibu o a e he alida ion by he manu ac u e
This ool is hos ed on a Schneide Elec ic se e .
6 h p://www. ideli y.com/
24/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
Gene al lows o in o ma ion in VMI se up including Videli y
3.1.2.1 A ailable Schneide Elec ic ools
Wi h i s long pas , Schneide Elec ic became expe in Supply Chain and Logis ics. Yea a e yea some
powe ul ools we e de eloped o suppo hese ac i i ies.
In 2006 was de eloped SPO (S ock Pa ame e s Op imize ). This ool is an Access based p og am
speci ically de eloped by Schneide Elec ic o calcula e he s ock pa ame e s used in i s wa ehouses.
I appea ed clea ly ha SPO should be used o VMI since
I is a e y powe ul ool ha al eady showed excellen esul s
I is cus omizable; mul iple pa ame e s can be modi ied o i o he wa ehouse speci ica ions
Schneide Elec ic s ock con olle s al eady know pe ec ly his applica ion: no need o ain
hem on a new applica ion
SPO is he p og am ha will be used o he calcula ion o s ock pa ame e s
Pu chase O de
O de Acknoledgmen
In oice
Dis ibu o
Final
cus ome s
Final
cus ome
need
Videli y
Deli e y
Balance needs
essou ces
In en o y le els
O de P oposal
S ock
pa ame e s
Valida ion
Copy
25/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
3.2. Analyze: Measu e and ind he poin s o imp o emen s
The main a ge s o he p ojec we e o:
Design as solu ion ha can handle se e al cus ome s
Reduce he ime in es men pe cus ome
3.2.1. Design as solu ion ha can handle se e al cus ome s
The exis ing solu ion was based on Excel iles and mac os. The capaci y o Excel being limi ed o 65536
lines, his es ic ed s ongly he po en ial o he solu ion. Usually a dis ibu o is usually handling a ound
4000 Schneide Elec ic e e ences pe wa ehouse. I his cus ome has 2 wa ehouses his means ha
one ile would no be enough o s o e one yea o mon hly consump ion (96000 eco ds).
The capaci y o he solu ion needs o be inc eased by selec ing he igh pla o m
3.2.1.1 E alua ion o he amoun o da a
4000 e e ences pe wa ehouse in a e age
2 wa ehouses pe cus ome
10 cus ome s
Da a o be eco ded o a leas 3 yea s
1 upda e o he pa ame e s pe mon h
A ound 3 million eco ds only o eco ding o sales his o y
As a consequence i is necessa y o use a da abase.
3.2.1.2 Connec i i y
The p og am de eloped has o communica e wi h o he modules:
SPO which is an Access da abase
32/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
Fig 3.2.2. Es ima ion o he new cos s s. o iginal cos s (de ailed calcula ion in Appendix)
Based on his ime measu emen , wi h he o iginal se up, he equi alen o one addi ional esou ce (FTE)
is needed on yea 2 and an addi ional one on yea 5 (c Fig Fig 3.2.2.).
Wi h he new se up he i s ex a FTE is only necessa y on yea 5.
The cos o he esou ces needed o un VMI would be di ided by wo
3.2.3. E alua ion o he p ojec cos s
Wi h he ac ual s ong p essu e on cos s his p ojec had o use as less esou ces as possible. As a
solu ion was al eady in place he goal was o euse as much exis ing hings as possible.
So in o de o ha e a clea iew on he bene i s o his p ojec , a clea dis inc ion needs o be made
be ween wha is needed bu al eady in place and wha is needed bu new.
O e he 12 mon hs pe iod, he ime should be spli be ween:
- P ojec managemen (p elimina y analysis, p ojec ollow up, mee ings) 50 days
- De elopmen and es ing o he Access ool 70 days
- Expe ience sha ing wi h o he SE o ganiza ions 15 days
33/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
- Cus ome implemen a ions and ollow up (no di ec ly linked o he p ojec i sel ) 50 days
- O he ask no linked o VMI 30 days
135 wo king days can be di ec ly in oiced o he p ojec .
Wi h a daily cos o 200 Eu os, his makes a o al o 27 000 Eu os.
Addi ional 30 days o mee ing wi h di e en pa ies in ol ed o he di e en phases o he p ojec
(s ock con olle s, manage s and o he colleagues)
Wi h an a e age cos o 200 Eu os, his makes a o al o 6 000 Eu os
Rega ding he IT ools, Access 2003 is al eady a ailable on he compu e s ha will be used o VMI
and o he de elopmen . Looking a he equi emen s he e is no need o go o a newe e sion o
Access.
No change needed in Videli y.
SPO is a s anda d Schneide ool so no speci ic cos . As his ool is an Access based ool, small
adap a ion can be done locally.
ERP con igu a ion al eady done, no new de elopmen s needed
The o al cos o he design and he implemen a ion o his p ojec is 33 000 Eu os
3.2.4. Calcula ion o he Re u n On In es men
Based on he p e ious calcula ion, he ROI is eached when he sum o he sa ings is equal o he
o al p ojec cos :
𝑆𝑎𝑣𝑖𝑛𝑔𝑠 = 𝑃𝑟𝑜𝑗𝑒𝑐𝑡 𝑐𝑜𝑠𝑡
𝑛 × (24 × 𝑛 + 88) × 200 = 33 000
34/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
24 𝑛2 + 88 𝑛 − 165 = 0
𝑑𝑒𝑙𝑡𝑎 = 88 2 − 4 × 24 × (−165) = 23 584
𝑛 = −88 – 23584
2 × 24
𝑛= 1,37 𝑦𝑒𝑎𝑟𝑠
𝑹𝑶𝑰 = 𝟏𝟔,𝟒 𝒎𝒐𝒏𝒕𝒉𝒔
The Re u n On In es men o his p ojec is equal o 16,4 mon hs.
This means ha wi hin he expec ed condi ions and hypo hesis o he u u e he sa ings gene a ed
by his p ojec will be highe han he cos s in ol ed a e a pe iod o 16,4 mon hs
35/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
3.3. De elop: C ea e he solu ion complying wi h he equi emen s
3.3.1. Design o he a chi ec u e
Requi emen s o he ool o be de eloped
In o de o inc ease lexibili y a modula app oach is aken. Fo each o he ollowing ac i i ies one
module has been c ea ed:
Impo a ion o da a (Impo DB)
This module needs o be cus ome speci ic in o de o gi e mo e lexibili y o he cus ome . I
ans o ms he in o ma ion coming om he cus ome in o he o ma used by he p og am.
I is impo an o ha e his lexibili y since all he cus ome s a e no able o p o ide he
in o ma ion exac ly as we would like (blocs se by hei ERP).
SAP
Videli y
SPO
Cus ome
sales epo
VMI ool:
Communica e wi h he
cus ome , Videli y, SAP and
SPO
Be lexible and use iendly
S o e he in o ma ion
Can be di e en depending
on he cus ome !
36/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
Calcula ion o o ecas s (Fo ecas DB)
As he e was no o ecas ing ool ha could be adap ed o VMI a speci ic o ecas ing ool
needed o be de eloped. Calcula ion o s ock pa ame e s wi h SPO is mainly using he
his o ical da a. In he VMI p ocess o ecas s a e mainly used o es ima e how long in
ad ance an o de needs o be placed (in o de o s ay abo e he sa e y s ock). So a u
es ima ion done wi h simple o mulas is enough.
S o ing o cus ome sales, in en o y and p oduc da a (Mas e da a DB)
In o de o limi he esou ces needed as solu ion is o c ea e one mas e da a da abase pe
cus ome . The main ad an age is ha a e a couple o yea s he e is no a ile o se e al
Giga Oc e s. E en i Mic oso Access could handle i , i would un oo slow. Ha ing one
da abase pe cus ome also limi s he isk o losing all he in o ma ion.
S o ing o common p oduc in o ma ion coming om Schneide Elec ic (Common DB)
Some o he p oduc in o ma ion is he same o di e en cus ome s. I includes he cu en
s ock s a us, he li e cycle s a us o he p oduc , he lo sizes… Some high le el cus ome
in o ma ion and he da abase use s’ in o ma ion also needed o be eco ded in a common
place. All his in o ma ion is g ouped in one da abase ha is used o all he cus ome s.
Use in e ace including epo ing (In e ace DB)
The ool needed o be use iendly in o de o educe he cos s o aining and educe he
ime needed o make he ope a ions. In o de o seg ega e s o ed da a, que ies and use
in e ace, a speci ic module has been done. I is a way o p e en use s om modi ying he
ables o he que ies. I also p e en s he use om accessing di ec ly he cus ome da a ha
is con iden ial.
Co e o he applica ion o manage and link all he o he modules (Co e DB)
All hese di e en modules needed o be linked. In o de o make u u e main enance easie
all he p ocessing o he in o ma ion and con ol o he module is done ia one da abase.
This da abase only con ains que ies and VBA modules.
37/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
O ganiza ion and in e ac ions be ween he a ious modules
O ganiza ion o he a ious modules
The de elopmen o he p ojec has been spli in o 4 di e en phases.
In e ace DB
Mas e da a
DB
Common
DB
SAP
Fo ecas ing
DB
Videli y
SPO
Impo DB
Dis ibu o speci ic
Cus ome sales
epo
Co e DB
Cus ome
Schneide
Elec ic
Videli y
38/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
3.3.1.1 Phase 1: S anda dize he equi emen s
Lis all he da a ha is necessa y and he equency o exchange
De ine s anda ds8 o he ile exchanges
3.3.1.2 Phase 2: Build he da a ables and ans e exis ing da a o he new ables
Build common da abases and ables
De ine he model o all cus ome speci ic ables
3.3.1.3 Phase 3: C ea e/Modi y calcula ion modules
C ea ion o he o ecas ing da abase
Modi ica ion o SPO in o de o be able o link i o he VMI ool
3.3.1.4 Phase 4: Build he exchanges
C ea e he p og am (Co e) ha will supe ise all he ope a ions s ep by s ep and link he da a
wi h he calcula ion modules
3.3.2. The esul
All he p ocess s eps a e accessible ia one in e ace. A lo o s eps a e au oma ed > Mon hly upda e is
done much as e
The solu ion is easy o use > The need o aining s ongly educed
Some ools a e a ailable o analysis > A lo o ime is sa ed o he analysis o he da a
8 See appendix 5.2.1
39/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
3.3.2.1 Connec ion o he in e ace
3.3.2.2 Menu upda e o s ock pa ame e s
40/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
3.3.2.3 Selec ion o he o ecas ing model
3.3.2.4 Example o epo ing ool
3.4. Tes : Make su e he solu ion is wo king p ope ly
The es ing o he di e en modules was done du ing he de elopmen . Once e e y hing was build he
comple e solu ion has been es ed. No majo bugs ha e been ound.
41/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
The ool was hen es ed li e wi h he implemen a ion o new dis ibu o in No embe 2007.
F om his poin on an o de p oposal was sen on a daily basis o he dis ibu o . The dis ibu o was
hen compa ing his p oposal wi h wha he was ac ually o de ing ou o he VMI p ocess. A e one
mon h he dis ibu o us ed ou p oposals and ga e alida ion o Go Li e om he i s o Decembe
2007.
Once we we e ully sa is ied and con iden wi h he solu ion implemen ed i has been ex ended o he
p e iously exis ing VMI cus ome .
3.5. E alua e: E alua e ha he solu ion designed mee s he
equi emen s
The esul is sa is ac o y. Bo h Schneide Elec ic and dis ibu o s a e e y happy o he se ice p o ided.
Financial impac
The sa ings iden i ied a he beginning o he p ojec a e me on Schneide Elec ic side.
On dis ibu o ’ side, wi h a compa able le el o p oduc a ailabili y (c Fig Fig 3.5.1.) he s ock co e age
s ongly educed (c Fig Fig 3.5.2.) Tha means ha he dis ibu o has lowe alue in his s ock so mo e
cash in his hands. This is due o he ac ha he igh p oduc s a e pu on he shel es o he dis ibu o .
49/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
Appendix
A. Calcula ions
A.1. Es ima ion o he sa ings
Hypo hesis: 1 new cus ome implemen ed e e y qua e and one con olle being able o manage 4
cus ome s:
Fi s yea :
Janua y : One cus ome al eady in place + Implemen a ion o a new cus ome
Ap il : Implemen a ion o a new cus ome
July : Implemen a ion o a new cus ome
Oc obe : Implemen a ion o a new cus ome + T aining o a new con olle
Sa ings linked o implemen a ion o a new cus ome
4 new cus ome s he i s yea
𝑆𝑎𝑣𝑖𝑛𝑔 𝑛𝑒𝑤 𝑐𝑢𝑠𝑡𝑜𝑚𝑒𝑟 = 15 × 4 = 60 𝑑𝑎𝑦𝑠
Sa ings linked o implemen a ion o he as e calcula ion o s ock pa ame e s
1 day is sa ed o each calcula ion o s ock pa ame e s
The calcula ion is done once a mon h pe cus ome
Fo he i s wo cus ome s, he sa ing will be made o e he 12 mon hs
Fo he cus ome implemen ed in Ap il he sa ing will be made o e 9 mon hs
Fo he cus ome implemen ed in July he sa ing will be made o e 6 mon hs
Fo he cus ome implemen ed in Oc obe he sa ing will be made o e 3 mon hs
𝑆𝑎𝑣𝑖𝑛𝑔 𝑐𝑎𝑙𝑐𝑢𝑙𝑎𝑡𝑖𝑜𝑛 𝑜𝑓 𝑝𝑎𝑟𝑎𝑚𝑒𝑡𝑒𝑟𝑠 = 1 𝑑𝑎𝑦 × (2 × 12 + 9 + 6 + 3) = 42 𝑑𝑎𝑦𝑠
50/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
Sa ings linked o he aining o s ock con olle s
One s ock con olle needs o be ained du ing he i s yea
𝑆𝑎𝑣𝑖𝑛𝑔 𝑡𝑟𝑎𝑖𝑛𝑖𝑛𝑔 = 10 𝑑𝑎𝑦𝑠
The o al expec ed sa ing o he i s yea should be a ound 112 days. This ep esen s almos hal o an
employee!
Gene aliza ion:
Wi h his model o implemen a ion (4 new cus ome s pe yea ) he gene al o mula o he sa ings
gene a ed du ing he yea n is:
Numbe o cus ome al eady implemen ed a he beginning o he yea n:
1 al eady implemen ed a he p ojec s a up
4 implemen ed e e y yea
𝑁𝑢𝑚𝑏𝑒𝑟 𝑜𝑓 𝑐𝑢𝑠𝑡𝑜𝑚𝑒𝑟𝑠 𝑎𝑡 𝑡𝑒 𝑒𝑛𝑑 𝑜𝑓 𝑦𝑒𝑎𝑟 𝑛 = 4 𝑥 (𝑛 − 1) + 1
𝑆𝑎𝑣𝑖𝑛𝑔𝑠 𝑙𝑖𝑛𝑘𝑒𝑑 𝑡𝑜 𝑖𝑚𝑝𝑙𝑒𝑚𝑒𝑛𝑡𝑎𝑡𝑖𝑜𝑛 𝑛𝑒𝑤 𝑐𝑢𝑠𝑡𝑜𝑚𝑒𝑟𝑠 𝑦𝑒𝑎𝑟 𝑛 = 15 𝑑𝑎𝑦𝑠 × 4 𝑐𝑢𝑠𝑡𝑜𝑚𝑒𝑟𝑠 =
60 𝑑𝑎𝑦𝑠
𝑆𝑎𝑣𝑖𝑛𝑔𝑠 𝑙𝑖𝑛𝑘𝑒𝑑 𝑡𝑜 𝑐𝑎𝑙𝑐𝑢𝑙𝑎𝑡𝑖𝑜𝑛 𝑜𝑓 𝑝𝑎𝑟𝑎𝑚𝑒𝑡𝑒𝑟𝑠 𝑜𝑛 𝑦𝑒𝑎𝑟 𝑛 =
1 𝑑𝑎𝑦 𝑠𝑎𝑣𝑒𝑑 𝑝𝑒𝑟 𝑚𝑜𝑛𝑡 𝑎𝑛𝑑 𝑝𝑒𝑟 𝑐𝑢𝑠𝑡𝑜𝑚𝑒𝑟 ×
(𝑇𝑜𝑡𝑎𝑙 𝑛𝑢𝑚𝑏𝑒𝑟 𝑜𝑓 𝑐𝑢𝑠𝑡𝑜𝑚𝑒𝑟𝑠 𝑎𝑡 𝑦𝑒𝑎𝑟 𝑛 𝑠𝑡𝑎𝑟𝑡 × 12 𝑚𝑜𝑛𝑡𝑠+
𝐹𝑖𝑟𝑠𝑡 𝑐𝑢𝑠𝑡𝑜𝑚𝑒𝑟 𝑜𝑓 𝑡𝑒 𝑦𝑒𝑎𝑟 × 12 𝑚𝑜𝑛𝑡𝑠+
𝑆𝑒𝑐𝑜𝑛𝑑 𝑐𝑢𝑠𝑡𝑜𝑚𝑒𝑟 × 9 𝑚𝑜𝑛𝑡𝑠+
𝑇𝑖𝑟𝑑 𝑐𝑢𝑠𝑡𝑜𝑚𝑒𝑟× 6 𝑚𝑜𝑛𝑡𝑠+
𝐹𝑜𝑢𝑟𝑡 𝑐𝑢𝑠𝑡𝑜𝑚𝑒𝑟× 3 𝑚𝑜𝑛𝑡𝑠 )
51/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
𝑆𝑎𝑣𝑖𝑛𝑔𝑠 𝑙𝑖𝑛𝑘𝑒𝑑 𝑡𝑜 𝑐𝑎𝑙𝑐𝑢𝑙𝑎𝑡𝑖𝑜𝑛 𝑜𝑓 𝑝𝑎𝑟𝑎𝑚𝑒𝑡𝑒𝑟𝑠 𝑜𝑛 𝑦𝑒𝑎𝑟 𝑛 =
1 × ((4 × (𝑛 − 1) + 1) × 12 + 12 + 9 + 6 + 3)
𝑆𝑎𝑣𝑖𝑛𝑔𝑠 𝑙𝑖𝑛𝑘𝑒𝑑 𝑡𝑜 𝑐𝑎𝑙𝑐𝑢𝑙𝑎𝑡𝑖𝑜𝑛 𝑜𝑓 𝑝𝑎𝑟𝑎𝑚𝑒𝑡𝑒𝑟𝑠 𝑜𝑛 𝑦𝑒𝑎𝑟 𝑛 = (48𝑛 − 6) 𝑑𝑎𝑦𝑠
𝑆𝑎𝑣𝑖𝑛𝑔𝑠 𝑙𝑖𝑛𝑘𝑒𝑑 𝑡𝑜 𝑡𝑟𝑎𝑖𝑛𝑖𝑛𝑔 𝑜𝑛 𝑦𝑒𝑎𝑟 𝑛 = 10 𝑑𝑎𝑦𝑠
𝑇𝑜𝑡𝑎𝑙 𝑠𝑎𝑣𝑖𝑛𝑔𝑠 𝑜𝑛 𝑦𝑒𝑎𝑟 𝑛 = 60 + (48𝑛 – 6) + 10
𝑇𝑜𝑡𝑎𝑙 𝑠𝑎𝑣𝑖𝑛𝑔𝑠 𝑜𝑛 𝑦𝑒𝑎𝑟 𝑛 = 48𝑛 + 64
Wi h his o mula i is hen possible o calcula e he cumula ed sa ings ob ained a he end o yea n.
𝐶𝑢𝑚𝑢𝑙𝑎𝑡𝑒𝑑 𝑠𝑎𝑣𝑖𝑛𝑔 𝑜𝑛 𝑦𝑒𝑎𝑟 𝑛 = (48𝑛 + 64)
𝑛
𝑖=1
𝐶𝑢𝑚𝑢𝑙𝑎𝑡𝑒𝑑 𝑠𝑎𝑣𝑖𝑛𝑔 𝑜𝑛 𝑦𝑒𝑎𝑟 𝑛 = 24 𝑛 × ( 𝑛 + 1 ) + 64 𝑛
𝐶𝑢𝑚𝑢𝑙𝑎𝑡𝑒𝑑 𝑠𝑎𝑣𝑖𝑛𝑔 𝑜𝑛 𝑦𝑒𝑎𝑟 𝑛 = 𝑛 × ( 24 𝑛 + 88 )
Wi h an a e age cos o 200 Eu os pe day, he o al sa ings on yea n co esponds o 10560 𝑛 +
12800 eu os
A.2. Es ima ion o he cos s
Wi h an es ima ion o 1 new cus ome implemen ed e e y qua e and one con olle being able o
manage 4 cus ome s:
52/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
Fi s yea :
Janua y : One cus ome al eady in place + Implemen a ion o a new cus ome
Ap il : Implemen a ion o a new cus ome
July : Implemen a ion o a new cus ome
Oc obe : Implemen a ion o a new cus ome + T aining o a new con olle
Cos s linked o implemen a ion o a new cus ome
𝐶𝑜𝑠𝑡 𝑙𝑖𝑛𝑘𝑒𝑑 𝑡𝑜 𝑖𝑚𝑝𝑙𝑒𝑚𝑒𝑛𝑡𝑎𝑡𝑖𝑜𝑛 𝑜𝑓 𝑛𝑒𝑤 𝑐𝑢𝑠𝑡𝑜𝑚𝑒𝑟
= 15 𝑑𝑎𝑦𝑠 𝑓𝑜𝑟 𝑖𝑚𝑝𝑙𝑒𝑚𝑒𝑛𝑡𝑎𝑡𝑖𝑜𝑛 × 4 𝑐𝑢𝑠𝑡𝑜𝑚𝑒𝑟𝑠
𝐶𝑜𝑠𝑡 𝑙𝑖𝑛𝑘𝑒𝑑 𝑡𝑜 𝑖𝑚𝑝𝑙𝑒𝑚𝑒𝑛𝑡𝑎𝑡𝑖𝑜𝑛 𝑜𝑓 𝑎 𝑛𝑒𝑤 𝑐𝑢𝑠𝑡𝑜𝑚𝑒𝑟 = 60 𝑑𝑎𝑦𝑠
Cos s linked o he calcula ion o new s ock pa ame e s
𝐶𝑜𝑠𝑡 𝑙𝑖𝑛𝑘𝑒𝑑 𝑡𝑜 𝑡𝑒 𝑐𝑎𝑙𝑐𝑢𝑙𝑎𝑡𝑖𝑜𝑛 𝑜𝑓 𝑝𝑎𝑟𝑎𝑚𝑒𝑡𝑒𝑟𝑠 =
0,5 𝑑𝑎𝑦 𝑝𝑒𝑟 𝑚𝑜𝑛𝑡 𝑎𝑛𝑑 𝑝𝑒𝑟 𝑐𝑢𝑠𝑡𝑜𝑚𝑒𝑟 𝑡𝑜 𝑟𝑢𝑛 𝑡𝑒 𝑐𝑎𝑙𝑐𝑢𝑙𝑎𝑡𝑖𝑜𝑛𝑠×
(𝐶𝑢𝑠𝑡𝑜𝑚𝑒𝑟 𝑎𝑙𝑟𝑒𝑎𝑑𝑦 𝑖𝑛 𝑝𝑙𝑎𝑐𝑒×12 𝑚𝑜𝑛𝑡𝑠+
𝐹𝑖𝑟𝑠𝑡 𝑐𝑢𝑠𝑡𝑜𝑚𝑒𝑟 𝑜𝑓 𝑡𝑒 𝑦𝑒𝑎𝑟 × 12 𝑚𝑜𝑛𝑡𝑠+
𝑆𝑒𝑐𝑜𝑛𝑑 𝑐𝑢𝑠𝑡𝑜𝑚𝑒𝑟 𝑜𝑓 𝑡𝑒 𝑦𝑒𝑎𝑟 × 9 𝑚𝑜𝑛𝑡𝑠 +
𝑇𝑖𝑟𝑑 𝑐𝑢𝑠𝑡𝑜𝑚𝑒𝑟 𝑜𝑓 𝑡𝑒 𝑦𝑒𝑎𝑟 × 6 𝑚𝑜𝑛𝑡𝑠 +
𝐹𝑜𝑢𝑟𝑡 𝑐𝑢𝑠𝑡𝑜𝑚𝑒𝑟 𝑜𝑓 𝑡𝑒 𝑦𝑒𝑎𝑟 × 3 𝑚𝑜𝑛𝑡𝑠 )
𝐶𝑜𝑠𝑡 𝑙𝑖𝑛𝑘𝑒𝑑 𝑡𝑜 𝑡𝑒 𝑐𝑎𝑙𝑐𝑢𝑙𝑎𝑡𝑖𝑜𝑛 𝑜𝑓 𝑝𝑎𝑟𝑎𝑚𝑒𝑡𝑒𝑟𝑠 = 0,5 𝑑𝑎𝑦 × (12 + 12 + 9 + 6 + 3)
𝐶𝑜𝑠𝑡 𝑙𝑖𝑛𝑘𝑒𝑑 𝑡𝑜 𝑡𝑒 𝑐𝑎𝑙𝑐𝑢𝑙𝑎𝑡𝑖𝑜𝑛 𝑜𝑓 𝑝𝑎𝑟𝑎𝑚𝑒𝑡𝑒𝑟𝑠 = 21 𝑑𝑎𝑦𝑠
Cos s linked o he aining o s ock con olle s
𝐶𝑜𝑠𝑡 𝑜𝑓 𝑡𝑟𝑎𝑖𝑛𝑖𝑛𝑔 = 7 𝑑𝑎𝑦𝑠
53/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
Cos s linked o he daily o de ing ac i i ies
𝐶𝑜𝑠𝑡 𝑙𝑖𝑛𝑘𝑒𝑑 𝑡𝑜 𝑡𝑒 𝑑𝑎𝑖𝑙𝑦 𝑜𝑟𝑑𝑒𝑟𝑖𝑛𝑔 𝑎𝑐𝑡𝑖𝑣𝑖𝑡𝑖𝑒𝑠 =
10 𝑚𝑖𝑛𝑢𝑡𝑒𝑠 𝑑𝑎𝑦 𝑝𝑒𝑟 𝑑𝑎𝑦 𝑎𝑛𝑑 𝑝𝑒𝑟 𝑐𝑢𝑠𝑡𝑜𝑚𝑒𝑟 𝑡𝑜 𝑜𝑟𝑑𝑒𝑟×
(𝐶𝑢𝑠𝑡𝑜𝑚𝑒𝑟 𝑎𝑙𝑟𝑒𝑎𝑑𝑦 𝑖𝑛 𝑝𝑙𝑎𝑐𝑒× 21 𝑑𝑎𝑦𝑠 × 12 𝑚𝑜𝑛𝑡𝑠+
𝐹𝑖𝑟𝑠𝑡 𝑐𝑢𝑠𝑡𝑜𝑚𝑒𝑟 𝑜𝑓 𝑡𝑒 𝑦𝑒𝑎𝑟 × 21 𝑑𝑎𝑦𝑠 × 12 𝑚𝑜𝑛𝑡𝑠+
𝑆𝑒𝑐𝑜𝑛𝑑 𝑐𝑢𝑠𝑡𝑜𝑚𝑒𝑟 × 21 𝑑𝑎𝑦𝑠 × 9 𝑚𝑜𝑛𝑡𝑠+
𝑇𝑖𝑟𝑑 𝑐𝑢𝑠𝑡𝑜𝑚𝑒𝑟× 21 𝑑𝑎𝑦𝑠 × 6 𝑚𝑜𝑛𝑡𝑠+
𝐹𝑜𝑢𝑟𝑡 𝑐𝑢𝑠𝑡𝑜𝑚𝑒𝑟× 21 𝑑𝑎𝑦𝑠 × 3 𝑚𝑜𝑛𝑡𝑠 )
𝐶𝑜𝑠𝑡 𝑙𝑖𝑛𝑘𝑒𝑑 𝑡𝑜 𝑡𝑒 𝑑𝑎𝑖𝑙𝑦 𝑜𝑟𝑑𝑒𝑟𝑖𝑛𝑔 𝑎𝑐𝑡𝑖𝑣𝑖𝑡𝑖𝑒𝑠 = 10 × 21 × (12 + 12 + 9 + 6 + 3)
𝐶𝑜𝑠𝑡 𝑙𝑖𝑛𝑘𝑒𝑑 𝑡𝑜 𝑡𝑒 𝑑𝑎𝑖𝑙𝑦 𝑜𝑟𝑑𝑒𝑟𝑖𝑛𝑔 𝑎𝑐𝑡𝑖𝑣𝑖𝑡𝑖𝑒𝑠 = 8820 𝑚𝑖𝑛𝑢𝑡𝑒𝑠
𝐶𝑜𝑠𝑡 𝑙𝑖𝑛𝑘𝑒𝑑 𝑡𝑜 𝑡𝑒 𝑑𝑎𝑖𝑙𝑦 𝑜𝑟𝑑𝑒𝑟𝑖𝑛𝑔 𝑎𝑐𝑡𝑖𝑣𝑖𝑡𝑖𝑒𝑠 = 18,3 𝑑𝑎𝑦𝑠
The expec ed cos s o he i s yea should be a ound 106 days.
Gene aliza ion
Wi h his model o implemen a ion (4 new cus ome s pe yea ) he gene al o mula o he cos s
gene a ed du ing he yea n is:
𝑇𝑜𝑡𝑎𝑙 𝑐𝑜𝑠𝑡𝑠 𝑜𝑛 𝑦𝑒𝑎𝑟 𝑛 =
15 × 4 +
0,5 × 12 × ((4 × (𝑛 − 1) + 1) + 12 + 9 + 6 + 3
12 +
7 +
10 × 21 × 12 × 4 × 𝑛 − 1 + 1 + 12 + 9 + 6 + 3
60 × 8
Cos o implemen a ion
Cos o pa ame e calcula ion
Cos o aining
Cos o daily o de ing
54/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
𝑇𝑜𝑡𝑎𝑙 𝑐𝑜𝑠𝑡𝑠 𝑜𝑛 𝑦𝑒𝑎𝑟 𝑛 = 45𝑛 + 531 / 8
𝑇𝑜𝑡𝑎𝑙 𝑐𝑜𝑠𝑡𝑠 𝑜𝑛 𝑦𝑒𝑎𝑟 𝑛 ≈ 45𝑛 + 66
Yea
1
2
3
4
5
6
O iginal cos in days
215.4
305.4
395.4
485.4
575.4
665.4
New cos in days
104.4
149.4
194.4
239.4
284.4
329.4
Sa ings in days
111
156
201
246
291
336
55/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
B. Documen s
B.1. Speci ica ion o ile exchanges
56/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
57/60
Design and implemen a ion o a solu ion o Vendo Managed In en o y - GARNIER Lionel
