Optimal Transport Planning for the Supply to a Fruit Logistic Centre

Abstract

This chapter presents a mixed integer linear programming developed to support operational decision making in the transport planning for a fruit logistic centre (FLC). The FLC is part of a fruit supply chain. Associated cooperatives store and supply fruits on demand to fulfil orders received at the logistic centre. The model mitigates the cost of manually managing the planning of trips to transfer fruits from storages at cooperatives to the logistic centre and avoiding idle times in the packaging lines. This is done determining the number of trips to do by available trucks and the load they have to carry to the logistic centre. The model is tested on a real case represented by an important Spanish cooperative during the winter season as a prior test to the more complex. In view of results, the model is ready to be integrated into the ERP of the logistic centre and extended to deal with the more complex case presented during harvest season.

Appendices

Appendix 1: Distance Between Cooperatives and the FLC

Coop code	FLC distance	Transportation time (h)
1	36	4.20
2	12	1.40
3	10	1.33
4	28	2.93
5	28	3.93
6	38	3.27
7	35	4.17
8	48	3.60
9	30	3.00
10	26	1.87
11	17	2.57
12	13	2.43
13	27	3.90
14	8	2.27
15	50	2.67
16	35	2.17
17	10	1.33
18	48	4.60
19	22	3.73
20	42	3.40
21	27	3.90
22	0	0.00
23	5	2.17
24	30	4.00
25	30	3.00
26	24	2.80
27	42	4.40
28	40	3.33
29	8	2

Appendix 2: Stock per Cooperative, Variety and Category (in ton)

Coop code	Variety	Category								Total
		101	104	108	201	202	215	218	220
2	Conference	1,409	0	0	0	0	0	0	0	1,409
2	Alexandrine	66	2	0	0	17	0	0	0	85
3	Blaquilla	209	0	0	0	0	16	0	0	225
3	Conference	1,102	55	0	0	0	146	0	0	1,303
3	Alexandrine	102	0	0	0	0	43	0	0	145
3	Red Delicious	127	40	0	0	0	0	0	0	167
3	Golden	611	0	0	0	0	69	0	0	680
5	Golden	178	47	0	0	0	0	0	0	225
6	Conference	785	0	0	0	0	0	0	0	785
6	Alexandrine	134	0	0	0	0	0	0	0	134
6	Golden	997	0	0	0	0	0	0	0	997
11	Conference	194	0	0	0	0	0	0	0	194
11	Golden	341	0	0	0	0	0	0	0	341
12	Conference	542	0	0	0	0	0	0	0	542
12	Golden	493	0	0	0	0	0	0	0	493
14	Blaquilla	131	8	0	0	0	0	0	0	139
14	Conference	481	30	0	0	0	0	0	0	511
14	Golden	237	0	0	0	0	0	0	0	237
17	Blaquilla	180	0	0	0	0	0	0	0	180
17	Conference	1,750	0	0	0	0	0	0	0	1,750
17	Golden	1,750	0	0	0	0	0	0	0	1,750
21	Blaquilla	149	11	0	0	0	0	0	0	160
21	Conference	261	0	0	0	0	0	0	0	261
21	Golden	489	0	0	0	0	0	0	0	489
23	Conference	684	0	0	0	0	16	0	0	700
23	Golden	653	71	0	2	0	0	0	0	726
24	Conference	343	63	0	0	0	0	0	0	406
24	Golden	520	0	0	0	0	0	0	0	520
25	Conference	220	0	0	0	0	0	0	0	220
25	Golden	353	47	0	0	0	0	0	0	400
26	Golden	261	0	0	0	0	0	0	0	261
28	Golden	291	5	0	0	0	0	0	0	296
29	Blaquilla	353	78	0	0	0	0	0	0	431
29	Conference	225	0	0	0	0	0	0	131	356
29	Golden	290	0	0	0	0	0	0	0	290

Appendix 3: Demand (in ton) and Minimum Stock in the FLC (in kg)

Variety	Minimum stock per category								Demand
	101	104	108	201	202	215	218	220
Blaquilla	240	60							50
Conference	400	100							50
Alexandrine	80	20							0
Red Delicious									0
Golden	320	80							68