Develop a logistic | academiascholars.com

1. QUESTION
The task is to develop a logistics model with three warehouses and six destinations. It’s important that you know how to use the Excel equation =sumproduct(_:_,_:_) for this exercise. If you are not sure how it works search ‘sumproduct excel’ on your browser.

You can log in to this website https://bookshelf.vitalsource.com The account number is [email protected] The password is Abcde123.The chapter 7 inside is about this assignment

Subject	Computer Technology	Pages	2	Style	APA

COST	ROUTE	UNITS	C1	C2	C3	C4	C5	C6	C7	C8	C9
1.60	A1	0	1						1
1.80	A2	0		1					1
1.10	A3	200			1				1
1.50	A4	150				1			1
1.70	A5	450					1		1
1.00	A6	100						1	1
1.40	B1	0	1							1
1.20	B2	300		1						1
1.30	B3	0			1					1
1.10	B4	200				1				1
1.90	B5	0					1			1
0.80	B6	0						1		1
1.30	C1	300	1								1
1.50	C2	100		1							1
1.70	C3	0			1						1
1.80	C4	0				1					1
1.90	C5	0					1				1
2.00	C6	0						1			1
		2430	300	400	200	350	450	100	900	500	400
			300	400	200	350	450	100	900	500	400


		The optimal solution states that 200 units are to be transported from warehouse A to livestock operation 3, 250 units from A to 4, 150 units from A to Operation 4, 450 units from A to 5, 100 units from A to 6, 300 units from B top Opertion 2, 200 units from B to operation 4, 300 units from C to Operation 1, 100 units from C to Operation 2. The total logistical cost of the shipment of feed supplements from warehouses to livestock operation points is 2430.