LINEAR PROGRAMMING MODEL PROBLEM URGENT

Oranges are grown, picked and then stored in warehouses in Tampa, Miami and Fresno. These warehouses supply oranges to markets in New York, Philadelphia, Chicago, and Boston. The following table shows the shipping costs per truckload (in hundreds of dollars), supply, and demand. Because of an agreement between distributors, shipments are prohibited from Miami to Chicago.

	To (cost, in $100s)
From	New York	Philadelphia	Chicago	Boston	Supply
Tampa	9	14	12	17	200
Miami	11	10	6	10	200
Fresno	12	8	15	7	200
Demand	130	170	200	150

For this problem provide:

1. The mathematical formulation

b. The optimal solution using Excel.