Appendix A The calculation of the delivery reliability
System WeekT >LB <-2 LB -2 LB -1 LB 0 LB 1 LB 2 LB 3 LB >3 Total In timeToo lateReliability
SI 62 47 0 0 18 42 1 0 0 0 61 60 1 98%
SI 62 48 0 0 32 55 0 1 0 0 88 87 1 99%
SI 62 49 0 0 38 34 8 1 0 0 81 72 9 89%
SI 62 50 0 0 36 38 0 0 0 0 74 74 0 100%
SI 62 51 0 1 21 78 1 0 0 0 101 100 1 99%
SI 62 52 0 0 24 70 2 0 0 0 96 94 2 98%
SI 62 53 0 0 11 44 10 0 0 0 65 55 10 85%
SI 62 1 0 1 6 55 5 0 0 0 67 62 5 93%
SI 62 2 0 0 22 67 3 1 1 0 94 89 5 95%
SI 62 3 0 0 36 67 6 0 0 0 109 103 6 94%
SI 62 4 0 0 2 40 1 0 0 0 43 42 1 98%
SI 62 5 0 0 49 82 0 0 0 0 131 131 0 100%
SI 62 6 0 1 78 40 0 0 0 0 119 119 0 100%
SI 62 7 0 0 56 40 0 0 0 0 96 96 0 100%
SI 62 8 0 1 58 41 5 0 0 0 105 100 5 95%
SI 62 9 0 0 68 20 0 0 0 0 88 88 0 100%
SI 62 10 0 1 57 17 0 0 0 0 75 75 0 100%
SI 62 11 0 0 65 4 0 0 0 0 69 69 0 100%
SI 62 12 0 0 70 26 0 0 0 0 96 96 0 100%
SI 62 13 0 0 31 27 0 0 0 0 58 58 0 100%
SI 62 14 0 0 36 46 0 0 0 0 82 82 0 100%
SI 62 15 0 1 13 57 0 0 0 0 71 71 0 100%
SI 62 16 0 0 9 85 0 0 0 0 94 94 0 100%
SI 62 17 0 1 19 75 0 0 0 0 95 95 0 100%
SI 62 18 0 0 58 23 0 0 0 0 81 81 0 100%
SI 62 19 0 0 38 51 0 0 0 0 89 89 0 100%
Total shipments 2228
Average reliability 98%
This data is derived from the weekly generated administration on delivery reliability.
Therefore LB is a Dutch abbreviation and can be translated to Delivery reliability. If an order is delivered in the agreed upon week this would be stated as LB 0. One week earlier is LB –1 etc.
Appendix B The calculation of the lead time
OpCo System Period LT 0 LT 1 LT 2 LT 3 LT 4 LT avg
All OpCos SI 62 200447 0 7 50 2 0 1,9
All OpCos SI 62 200448 0 28 38 17 3 1,7
All OpCos SI 62 200449 0 28 34 11 3 1,8
All OpCos SI 62 200450 0 14 48 5 2 1,7
All OpCos SI 62 200451 1 6 73 19 0 1,9
All OpCos SI 62 200452 0 17 56 12 9 1,8
All OpCos SI 62 200453 0 0 33 4 7 2,4
All OpCos SI 62 200501 0 6 23 24 6 2,5
All OpCos SI 62 200502 0 0 37 43 2 2,7
All OpCos SI 62 200503 0 13 25 51 10 2,4
All OpCos SI 62 200504 1 0 27 14 1 2,3
All OpCos SI 62 200505 1 42 46 23 19 1,9
All OpCos SI 62 200506 1 58 31 8 5 1,3
All OpCos SI 62 200507 0 21 64 0 7 1,7
All OpCos SI 62 200508 1 42 36 7 1 2
All OpCos SI 62 200509 2 49 12 9 1 1,2
All OpCos SI 62 200510 1 44 14 0 16 1,2
All OpCos SI 62 200511 0 33 13 2 9 1,7
All OpCos SI 62 200512 0 41 39 0 16 1,5
All OpCos SI 62 200513 0 14 28 3 0 1,7
All OpCos SI 62 200514 1 9 49 16 7 2,1
All OpCos SI 62 200515 0 2 66 2 0 2
All OpCos SI 62 200516 0 0 71 1 0 2
All OpCos SI 62 200517 0 2 19 24 0 2,5
All OpCos SI 62 200518 0 0 6 15 0 2,7
All OpCos SI 62 200519 0 0 16 25 34 3,2
Total shipments 1934 1,992308
This data is derived from the weekly generated administration on delivery time. Therefore LT is an Dutch abbreviation for delivery time. LT 0 delivery found place the same week as the order was taken in. LT 1 means that delivery took place one week later.
Appendix C The calculation of value finished goods and components
The value of the inventory is calculated by the formula presented here with a Z value of 0,67 this corresponds with a service level of 75%
SI 62 SI 68 SI 92 IM 3003
Forecast 4000 3150 450 96
Value components 121.107 106.734 79.431 24.645
Fluctuation 0,50 0,50 0,50 -
Lead time 13 13 13 13
SI 62 SI 68
Forecast 4000 3150
Value components 116.356,06 102.546,24
Fluctuation 0,50 0,50
Lead time 12 12
SI 92
Forecast 450
Value components 79.431
Fluctuation 0,50
Lead time 14
ns fluctuatio factor
inventory = • 13• •
50 Forecast
The lead time accounts for the number of weeks Neopost Technologies needs to replenish the inventory. When the delivery time policy is shortened by one week the current lead time of 13 is reduced by one week and vice versa. The SI 62 and the SI 68 are therefore calculated with a lead time of 12 and the SI 92 with a lead time of 14. The inventory value of 3 for the IM 3003 is manually determined and is no relationship with the formula presented.
