There is one problem to be solved. You are not required to submit any answer report or sensitivity report for question. Define your decision variables clearly.

The Sun Company has three plants (X, Y, and Z) and it works with two warehouses, one in Ankara and one in Bursa. The supply capacities of the plants are 600, 520, and 400 products for plants X, Y, and Z, respectively. Customers A, B, and C demand 440, 520, and 550 products from the Sun Company respectively. Relevant unit shipping cost information is presented in the below table. Additionally, it is stated that the warehouse in Ankara has to distribute at least 600 products and the warehouse in Bursa has to distribute at least 500 products.

To minimize the total shipment cost, provide

• LP model
• Excel solution.

(in TL)	To			To
From	Ankara	Bursa	From	A	B	C
X	3	4	Ankara	4	3	2
Y	2	5	Bursa	2	5	3
Z	4	2