Solution.xlsx

	A	B	C	D	E	F	G	H	I	J	L	M	N	O
1	Exhibit 1										Exhibit 2
2							Avg. Monthly Demand				Service
3							Popular Variant		Uncommon Variant			Agarwal Road Assistance Ltd.	Mohanlal Transport Services Ltd.
4	Cities	Latitude	Longitude	Maximum Capacity	Minimum Capacity	Fixed Cost for setup of each Warehouse ($'000)	Each Large Dealer	Each Small Dealer	Each Large Dealer	Each Small Dealer	Transit time (LT)	18	21	days
5	Ahmedabad	23.03	72.58	7200	600	65	446	94	304	56	Variability (SD)	2.5	2.8	days
6	Bangalore	12.93	77.57	36000	3000	100	1590	564	2160	186	Transportation charges (incl. Insurance Premium)	$0.42	$0.33	$/order
7	Bhopal	23.26	77.41	8400	700	30	340	117	535	58
8	Bhubaneswar	20.29	85.82	16800	1400	40	840	293	910	57
9	Chandigarh	30.74	76.77	14400	1200	45	603	236	897	64
10	Chennai	13.07	80.24	54000	4500	120	2459	945	3166	180
11	Delhi	28.61	77.23	50400	4200	100	1391	634	3859	416
12	Gandhinagar	23.24	72.65	15600	1300	45	841	293	784	32
13	Guwahati	16.15	91.73	18000	1500	30	909	350	966	25
14	Hyderabad	17.39	78.49	28800	2400	110	1119	505	1881	95
15	Jaipur	26.92	75.78	21600	1800	60	840	397	1410	53
16	Kolkata	22.5	88.36	45600	3800	120	444	772	4306	178
17	Lucknow	26.85	80.94	31200	2600	80	1374	607	1876	43
18	Mumbai	19.07	72.88	57600	4800	140	1665	732	4335	468
19	Patna	25.61	85.16	32400	2700	70	355	477	3020	198
20	Pondicherry	11.91	79.81	36000	3000	80	764	619	2986	131
21	Raipur	21.25	81.63	21600	1800	60	1125	335	1125	115
22	Ranchi	23.34	85.29	19200	1600	50	439	310	1561	90
23	Shimla	31.1	77.17	16800	1400	60	709	249	1041	101
24	Trivandrum	8.52	76.94	30000	2500	70	1833	518	1292	107
25	Factory	12.99	79.72
26
28
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103