Jumbo Pot is a restaurant chain. The operator has two distribution centers, which deliver beef to 5 restaurants. Each year the consumption of each restaurant is shown in the following table.

Restaurant A B C D E

Cons (Tons) 500 300 200 150 50

The capacities of the distribution centers appear below.

Distribution Center Capacity (Tons)

1 1,000

2 800

The delivery costs (baht) per ton appear below.

Fromn/To A B C D E

1 500 1,000 800 500 300

2 800 300 800 500 500

Set the delivery schedule (amount of beef from each distribution center to each restaurant with the minimal delivery cost. Model the problem as a linear program and solve for an optimal solution by USING EXCEL SOLVER