Productos y Servicios Financieros Tipos y Costos

EVOLUTIVO POR TIPO DE CARTERA BANCOS PRIVADOS 2010 MILES DE

2.4 Productos y Servicios Financieros Tipos y Costos

bunching factor 3 is better in just two order while bunching factor 1gave poor schedule result in all.

4.3 Results of Ten Different Orders Scheduled with Best Bunching Factor

The adoption of a particular bunching factor is dependent on the earliest finishing time for all orders, therefore after simulating the order with different bunching factors, the best bunching factor was selected for scheduling of the batch of ordersand the result for ten different batch of orders for ten months is presented in table 4.4(a-j).

0 20 40 60 80 100 120 140

Type 1 Type 2 Type 3

Number of days

Type

Order 10

bf1 bf2 bf3 0

20 40 60 80 100 120 140

Type 1 Type 2 Type 3

Number of days

Type

Order 9

bf1 bf2 bf3

115

Table 4.4a: Schedule result using the best bunching factor for Month 1

S/NO ORDER

NO BEST

BUNCHING FACTOR

FINISHING

TYPE ORDER SIZE (KG)

RELEASE

DAYS EARLIEST EVENT

DATE

LATEST EVENT

DATE

1 1 2 1 16 2 2^nd Feb 4^th Feb

2 1 2 2 13 3 3rd Feb 6^th Feb

3 1 2 2 13 4 4^th Feb 7^th Feb

4 1 2 3 13 5 6^th Feb 8^th Feb

5 1 2 3 36 6 7^th Feb 9^th Feb

6 1 2 1 27 7 8^th Feb. 10^th Feb

7 1 2 2 20 8 9^th Feb 11^th Feb

8 1 2 2 22 9 10^th Feb 13^th Feb

9 1 2 3 38 10 11^th Feb 14^th Feb

10 1 2 1 32 12 14^th Feb 16^th Feb

11 1 2 2 29 14 16^th Feb 18th Feb

12 1 2 3 40 16 18^nd Feb 21st Feb

13 1 2 3 50 17 20^th Feb 22^nd Feb

14 1 2 1 43 20 23^rd Feb 25^thFeb

15 1 2 2 51 22 25^th Feb 28^th Feb

16 1 2 3 54 24 28^th Feb 2^nd Mar

17 1 2 3 59 26 2^nd Mar 4^th Mar

18 1 2 1 51 30 7^th Mar 9^th Mar

19 1 2 2 62 34 11^th Mar 14^th Mar

20 1 2 3 82 37 15^th Mar 17^th Mar

21 1 2 1 60 41 20^th Mar 22^nd Mar

22 1 2 3 83 44 23^rd Mar 25^th Mar

23 1 2 2 104 49 29^th Mar 31^st Mar

24 1 2 3 85 51 31^st Mar 3^rd April

25 1 2 1 70 55 5^th April 7^th April

26 1 2 3 88 58 8^th April 11^th April

27 1 2 3 102 62 13^th April 15^th April

28 1 2 1 96 69 21^th April 24^th April

29 1 2 3 107 72 25^th April 27^th April

30 1 2 1 101 79 3^rd May 5^th May

Table 4.4b: Schedule result using the best bunching factor for Month 2

S/NO ORDER

BEST BUNCHING

FACTOR

FINISHING TYPE

ORDER SIZE (KG)

RELEASE DATE

EARLIEST EVENT

DATE

LATEST EVENT DATE

1 2 2 1 22 1 4 th May 6^th May

2 2 2 2 30 3 6^thMay 9^thMay

3 2 2 3 47 5 9^thMay 11^thMay

4 2 2 1 23 7 11^thMay 13^thMay

5 2 2 2 30 8 12^thMay 14^thMay

116

6 2 2 3 62 10 14^ttMay 17^thMay

7 2 2 1 23 11 16^thMay 18^thMay

8 2 2 2 35 13 18^thMay 20^thMay

9 2 2 1 25 15 20^stMay 23^rdMay

10 2 2 2 38 17 23^rdMay 25^thMay

11 2 2 3 72 19 25^thMay 27^thMay

12 2 2 1 34 21 27^thMay 30^thMay

13 2 2 2 55 24 31^st May 2^nd Jun

14 2 2 3 79 27 3^rd Jun 6^thJun

15 2 2 1 39 30 7^th Jun 9^thJun

16 2 2 3 87 33 10^thJun 13^thJun

17 2 2 2 60 36 14^thJun 16^thJun

18 2 2 1 45 39 17^thJun 20^thJun

19 2 2 3 98 42 21^stJun 23^rdJun

20 2 2 1 46 45 24^thJun 27^thJun

21 2 2 2 63 48 28^thJun 30^thJun

22 2 2 3 109 52 2^ndJul 5^thJul

23 2 2 1 51 55 6^thJul 8^th Jul

24 2 2 2 78 59 11^thJul 13^thJul

25 2 2 1 56 63 15^rdJul 18^thJul

26 2 2 2 101 69 22^ndJul 25^thJul

27 2 2 1 71 73 27^thJul 29^thJul

28 2 2 2 104 78 2^ndAug 4^thAug

29 2 2 1 75 83 9^thAug 1^thAug

30 2 2 1 83 89 16^th Aug 19^th Aug

Table 4.4c: Schedule result using the best bunching factor for Month 3

S/NO ORDER

BEST BUNCHING

FACTOR

FINISHING TYPE

ORDER SIZE (KG)

RELEASE DATE

EARLIEST EVENT

DATE

LATEST EVENT DATE

1 3 2 1 22 1 17^th Aug 19^th Aug

2 3 2 2 24 3 19^thAug 22^ndAug

3 3 2 3 13 3 20^thAug 23^rdAug

4 3 2 3 15 4 20^thAug 23^rdAug

5 3 2 1 27 6 24^thAug 26^thAug

6 3 2 2 42 8 26^thAug 29^thAug

7 3 2 3 47 9 27^thAug 30^thAug

8 3 2 1 27 11 31^st Aug 2^nd Sep

9 3 2 3 51 13 3^rdSep 6^thSep

10 3 2 3 54 15 5^thSep 7^thSep

11 3 2 1 30 17 7^thSep 9^thSep

12 3 2 2 57 20 8^thSep 10^thSep

13 3 2 2 65 23 16^thSep 19^thSep

14 3 2 3 77 25 17^thSep 20^thSep

15 3 2 1 46 28 20^thSep 22^ndSep

16 3 2 3 85 31 26^thSep 28^thSep

117

17 3 2 1 55 35 28^thSep 30^thSep

18 3 2 2 76 39 30^thSep 3^rd Oct

19 3 2 3 87 42 8^th Oct 11^th Oct

20 3 2 1 63 46 12^th Oct 14^th Oct

21 3 2 3 99 49 17^th Oct 19^th Oct

22 3 2 2 102 55 21^st Oct 24^th Oct

23 3 2 3 103 59 5^thNov 8^thNov

24 3 2 1 67 63 7^thNov 9^thNov

25 3 2 3 106 66 18^thNov 21^stNov

26 3 2 1 69 71 22^ndNov 24^thNov

27 3 2 3 108 75 1^stDec 4^thDec

28 3 2 1 76 80 11^thDec 13^thDec

29 3 2 1 87 86 27^thDec 29^thDec

30 3 2 1 103 93 19^th Jan 21^st Jan

Table 4.4d: Schedule result using the best bunching factor for Month 4

S/NO ORDER

BEST BUNCHING

FACTOR

FINISHING TYPE

ORDER SIZE (KG)

RELEASE DATE

EARLIEST EVENT

DATE

LATEST EVENT DATE

1 4 2 1 20 1 21^stJan 23^rdJan

2 4 2 2 22 2 23^rdJan 26^thJan

3 4 2 3 26 3 25^thJan 27^thJan

4 4 2 3 29 4 26^thJan 28^thMar

5 4 2 1 22 6 27^thJan 29^thJan

6 4 2 2 51 8 30^thJan 2^nd Feb

7 4 2 3 30 9 1^st Feb 3^rd Feb

8 4 2 1 29 11 3^rd Feb 5^th Feb

9 4 2 3 46 12 8^th Feb 10^th Feb

10 4 2 3 49 14 9^th Feb 11^th Feb

11 4 2 1 32 16 10^th Feb 12^th Feb

12 4 2 2 59 19 12^th Feb 15^th Feb

13 4 2 3 52 21 16^th Feb 18^th Feb

14 4 2 3 59 23 23^rd Feb 25^th Feb

15 4 2 1 55 26 24^th Feb 26^th Feb

16 4 2 2 71 30 26^th Feb 28^th Feb

17 4 2 3 70 32 6^thMar 8^thMar

18 4 2 1 57 36 8^thMar 10^thMar

19 4 2 2 75 40 10^thMar 13^thMar

20 4 2 3 70 42 13^thMar 15^thMar

21 4 2 3 85 45 21^stMar 23^rdMar

22 4 2 1 59 49 22^ndMar 24^thMar

118

23 4 2 2 98 54 25^thMar 28^thMar

24 4 2 3 88 57 3^rd April 5^thApril

25 4 2 1 67 62 5^thApril 7^thApril

26 4 2 3 98 65 11^thApril 13^thApril

27 4 2 1 74 69 20^thApril 22^ndApril

28 4 2 3 101 73 24^thApril 26^thApril

29 4 2 3 104 76 2^nd May 4^thMay

30 4 2 1 77 81 4^thMay 6^thMay

Table 4.4e: Schedule result using the best bunching factor for Month 5

S/NO ORDER

BEST BUNCHING

FACTOR

FINISHING TYPE

ORDER SIZE (KG)

RELEASE DATE

EARLIEST EVENT

DATE

LATEST EVENT DATE

1 5 3 1 15 1 5^thMay 8^thMay

2 5 3 1 16 2 6^thMay 9^thMay

3 5 3 2 19 3 9^thMay 11^thMay

4 5 3 2 30 5 11^thMay 13^thMay

5 5 3 3 38 7 13^thMay 16^thMay

6 5 3 3 47 8 15^thMay 17^thMay

7 5 3 1 17 10 16^thMay 18^thMay

8 5 3 1 18 11 17^th May 19^thMay

9 5 3 1 24 12 18^thMay 20^thMay

10 5 3 3 64 14 24^thMay 26^thMay

11 5 3 1 36 17 29^thMay 31^stMay

12 5 3 3 68 19 3^rd Jun 6^th Jun

13 5 3 1 38 21 9^thJun 12^thJun

14 5 3 3 82 24 15^thJun 17^thJun

15 5 3 1 38 27 20^thJun 22^ndJun

16 5 3 3 85 30 26^thJun 28^thJun

17 5 3 1 39 32 26^thJun 2^nd Jul

18 5 3 3 86 35 30^thJun 7^th Jul

19 5 3 1 41 38 5^th Jul 11^th Jul

20 5 3 3 86 41 9^th Jul 18^th Jul

21 5 3 1 48 44 16^th Jul 21^st Jul

22 5 3 3 86 47 19^th Jul 28^th Jul

23 5 3 1 72 52 26^th Jul 5^th Aug

24 5 3 3 88 55 3^rd Aug 10^th Aug

25 5 3 3 107 58 8^th Aug 21^st Aug

26 5 3 1 74 63 18^th Aug 25^th Aug

27 5 3 1 75 68 12^th Aug 14^th Aug

28 5 3 1 75 73 19^th Aug 22^nd Aug

29 5 3 1 90 79 25^th Aug 28^th Aug

30 5 3 1 107 86 9^th Sep 11^th Sep

119

Table 4.4f: Schedule result using the best bunching factor for Month 6

S/NO ORDER

BEST BUNCHING

FACTOR

FINISHING TYPE

ORDER SIZE (KG)

RELEASE DATE

EARLIEST EVENT

DATE

LATEST EVENT DATE

1 6 2 1 12 1 10^th Sep 13th Sep

2 6 2 1 13 2 11^th Sep 14^th Sep

3 6 2 2 38 4 14^th Sep 16^th Sep

4 6 2 3 20 5 15^th Sep 17^th Sep

5 6 2 3 22 6 16^th Sep 18^th Sep

6 6 2 3 23 6 22^nd Sep 24^th Sep

7 6 2 3 27 7 23^rd Sep 25^th Sep

8 6 2 1 41 10 24^th Sep 27^th Sep

9 6 2 2 46 12 27^th Sep 29^th Sep

10 6 2 3 30 13 29^th Sep 31^st Sep

11 6 2 3 37 14 30^th Sep 2^nd Oct

12 6 2 1 52 17 2^nd Oct 4^th Oct

13 6 2 2 63 21 4^th Oct 6^th Oct

14 6 2 3 47 23 5^th Oct 7^th Oct

15 6 2 3 51 25 12^th Oct 14^th Oct

16 6 2 2 73 28 18^th Oct 20^th Oct

17 6 2 3 52 29 19^th Oct 21^st Oct

18 6 2 1 89 35 22^nd Oct 25^th Oct

19 6 2 3 53 37 26^th Oct 28^th Oct

20 6 2 3 62 39 4^th Nov 6^th Nov

21 6 2 2 96 45 9^th Nov 11^th Nov

22 6 2 3 82 48 11^th Nov 13^th Nov

23 6 2 3 87 51 19^th Nov 21^st Nov

24 6 2 2 99 56 24^th Nov 26^th Nov

25 6 2 3 98 59 2^nd Dec 4^th Dec

26 6 2 2 105 64 14^th Dec 16^th Dec

27 6 2 3 98 67 15^th Dec 17^th Dec

28 6 2 3 101 71 23^rd Dec 27^th Dec

29 6 2 2 110 77 5^th Jan 7^th Jan

30 6 2 3 102 80 7^th Jan 9^th Jan

Table 4.4g: Schedule result using the best bunching factor for Month 7

S/NO ORDER

BEST BUNCHING

FACTOR

FINISHING TYPE

ORDER SIZE (KG)

RELEASE DATE

EARLIEST EVENT

DATE

LATEST EVENT DATE

1 7 3 1 37 2 11^th Jan 13^th Jan

2 7 3 2 18 3 12^th Jan 14^th Jan

3 7 3 2 38 5 14^th Jan 16^th Jan

4 7 3 3 14 6 15^th Jan 18^th Jan

5 7 3 3 24 6 16^th Jan 19^th Jan

120

6 7 3 3 35 8 19^th Jan 21^st Jan

7 7 3 1 50 12 22^nd Jan 25^th Jan

8 7 3 2 47 14 26^th Jan 28^th Jan

9 7 3 3 41 15 27^th Jan 29^th Jan

10 7 3 3 55 17 29^th Jan 1^st Mar

11 7 3 2 59 21 5^th Mar 8^th Mar

12 7 3 3 76 24 9^th Mar 11^th Mar

13 7 3 1 52 27 10^th Mar 12^th Mar

14 7 3 2 60 30 16^th Mar 18^th Mar

15 7 3 3 81 33 18^th Mar 20^th Mar

16 7 3 1 79 39 23^rd Mar 25^th Mar

17 7 3 3 93 42 29^th Mar 1^st April

18 7 3 2 78 46 7^th April 9^th April

19 7 3 1 88 51 16^th April 18^th April

20 7 3 2 79 55 18^th April 21^st April

21 7 3 1 89 61 6^th May 8^th May

22 7 3 2 80 65 7^th May 10^th May

23 7 3 2 84 70 19^th May 21^st May

24 7 3 1 92 76 27^th May 29^th May

25 7 3 2 88 80 8^th Jun 10^th Jun

26 7 3 1 98 87 17^th Jun 19^th Jun

27 7 3 2 95 92 21^st Jun 23^rd Jun

28 7 3 2 107 98 10^th Jul 13^th Jul

29 7 3 1 102 105 16^th Jul 19^th Jul

30 7 3 1 102 112 29^th Jul 31^st Jul

Table 4.4h: Schedule result using the best bunching factor for Month 8

S/NO ORDER

BEST BUNCHING

FACTOR

FINISHING TYPE

ORDER SIZE (KG)

RELEASE DATE

EARLIEST EVENT

DATE

LATEST EVENT DATE

1 8 2 1 24 1 31^st Jul 3^rd Aug

2 8 2 3 37 2 4^th Aug 6^th Aug

3 8 2 1 27 4 7^th Aug 10^th Aug

4 8 2 2 39 6 9^th Aug 11^th Aug

5 8 2 3 46 8 11^th Aug 13^th Aug

6 8 2 1 39 11 14^th Aug 17^th Aug

7 8 2 2 64 15 17^th Aug 19^th Aug

8 8 2 3 59 17 18^th Aug 20^th Aug

9 8 2 3 66 19 25^th Aug 27^th Aug

10 8 2 1 55 22 28^th Aug 1^st Sep

11 8 2 2 74 26 1^st Sep 3^rd Sep

12 8 2 3 66 28 3^rd Sep 5^th Sep

13 8 2 3 72 31 10^th Sep 12^th Sep

14 8 2 1 57 35 12^th Sep 15^th Sep

15 8 2 2 100 40 21^st Sep 23^rd Sep

16 8 2 3 76 42 23^rd Sep 28^th Sep

121

17 8 2 3 81 45 2^nd Oct 5^th Oct

18 8 2 1 91 51 6^th Oct 8^th Oct

19 8 2 3 82 54 11^th Oct 13^th Oct

20 8 2 3 85 56 23^rd Oct 26^th Oct

21 8 2 1 94 62 27^th Oct 29^th Oct

22 8 2 3 87 65 1^st Nov 3^rd Nov

23 8 2 3 88 68 13^th Nov 16^th Nov

24 8 2 1 99 75 17^th Nov 19^th Nov

25 8 2 3 94 78 22^nd Nov 24^th Nov

26 8 2 3 94 81 6^th Dec 9^th Dec

27 8 2 3 95 85 15^th Dec 17^th Dec

28 8 2 3 99 88 27^th Dec 30^th Dec

29 8 2 3 106 91 10^th Jan 13^th Jan

30 8 2 3 110 95 19^th Jan 21^st Jan

Table 4.4i: Schedule result using the best bunching factor for Month 9

S/NO ORDER

BEST BUNCHING

FACTOR

FINISHING TYPE

ORDER SIZE (KG)

RELEASE DATE

EARLIEST EVENT

DATE

LATEST EVENT DATE

1 9 2 1 30 2 21^st Jan 23^rd Jan

2 9 2 2 11 2 22^nd Jan 24^th Jan

3 9 2 2 25 4 23^rd Jan 26^th Jan

4 9 2 3 12 5 24^th Jan 27^th Jan

5 9 2 3 31 6 26^th Jan 28^th Jan

6 9 2 2 38 8 30^th Jan 3^rd Feb

7 9 2 3 35 9 1^st Feb 4^th Feb

8 9 2 3 41 10 3^rd Feb 5^th Feb

9 9 2 1 31 12 4^th Feb 6^th Feb

10 9 2 3 54 14 10^th Feb 12^th Feb

11 9 2 1 32 16 11^th Feb 13^th Feb

12 9 2 2 49 18 13^th Feb 15^th Feb

13 9 2 3 63 20 17^th Feb 19^th Feb

14 9 2 1 41 23 18^th Feb 20^th Feb

15 9 2 2 61 27 21^st Feb 24^th Feb

16 9 2 1 42 30 26^th Feb 28^th Feb

17 9 2 3 65 32 29^th Feb 1^st May

18 9 2 2 68 35 4^th Mar 7^th Mar

19 9 2 3 68 37 5^th Mar 8^thMar

20 9 2 1 52 40 9^thMar 11^thMar

21 9 2 3 76 43 12^th Mar 15^th Mar

22 9 2 2 82 47 18^thMar 21^stMar

122

23 9 2 3 81 50 21^stMar 23^rdMar

24 9 2 1 56 54 22^ndMar 24^thMar

25 9 2 2 96 59 1^st Apr 3^rd Apr

26 9 2 3 110 62 5^th Apr 7^th Apr

27 9 2 1 59 66 6^th Apr 8^th Apr

28 9 2 1 62 70 20^th Apr 22^nd Apr

29 9 2 1 69 75 4^th May 6^th May

30 9 2 1 106 82 25^th May 27^th May

Table 4.4j: Schedule result using the best bunching factor for Month 10

S/NO ORDER

BEST BUNCHING

FACTOR

FINISHING TYPE

ORDER SIZE (KG)

RELEASE DATE

EARLIEST EVENT

DATE

LATEST EVENT DATE

1 10 2 1 13 1 26^th May 27^th May

2 10 2 2 22 3 30^th May 1^st Jun

3 10 2 3 16 4 31^st May 2^nd Jun

4 10 2 3 22 5 1^st Jun 3^rd Jun

5 10 2 1 19 6 2^nd Jun 4^th Jun

6 10 2 1 19 7 3^rd Jun 6^th Jun

7 10 2 2 34 8 4^th Jun 7^th Jun

8 10 2 3 35 9 7^th Jun 9^th Jun

9 10 2 3 36 10 8^th Jun 10^th Jun

10 10 2 2 39 12 11^th Jun 14^th Jun

11 10 2 3 39 13 14^th Jun 16^th Jun

12 10 2 1 46 16 16^th Jun 18^th Jun

13 10 2 3 43 18 21^st Jun 23^rd Jun

14 10 2 3 43 19 22^nd Jun 24^th Jun

15 10 2 1 46 22 24^th Jun 27^th Jun

16 10 2 2 68 26 25^th Jun 28^th Jun

17 10 2 3 46 28 29^th Jun 1^st Jul

18 10 2 3 53 29 6^th Jul 8^th Jul

19 10 2 1 51 33 7^th Jul 9^th Jul

20 10 2 2 99 38 11^th Jul 13^th Jul

21 10 2 3 58 40 13^th Jul 15^th Jul

22 10 2 3 73 43 20^th Jul 22^nd Jul

23 10 2 1 68 47 22^nd Jul 25^th Jul

24 10 2 2 109 53 1^st Aug 3^rd Aug

25 10 2 3 102 56 2^nd Aug 4^th Aug

26 10 2 1 70 61 11^th Aug 13^thAug

27 10 2 3 110 65 16^th Aug 18^th Aug

28 10 2 1 70 69 25^th Aug 27^th Aug

29 10 2 1 83 75 16^th Sep 18^th Sep

30 10 2 1 108 82 25^th Sep 27^th Sep

123

Table 4.3(a-j) shows result of the best bunching factor for ten different orders with their release days. The earliest event date and latest event dates were presented for the customer to know on demand the likely time to expect delivery of goods.

In document Preferencias en el uso de productos y servicios financieros que ofrecen las Instituciones del Sistema Financiero Regulado Ecuatoriano, año 2011, Plaza Quito (página 56-63)