Excel Solutions needed:

A company has two plants producing windmills with the following capacities:

• Vietnam: 27 per week
• New Mexico: 35 per week

The company has three customers with the following demands per week.

• Iowa Wind Mills: 15 per week
• Madrid Equipments: 18 per week
• Kiev Alternative Energy: 12 per week

Following are the transportation costs between each production plant and each customer.

Distribution centers

Plants Iowa Madrid Kiev

Vietnam 650 700 600

New Mexico 450 560 700

a) Build a transportation network.

b) Write down a linear program that optimizes transportation cost.

c) Solve the LP using excel solver and interpret the solution.

(Make sure to upload the Excel worksheet)