*Please include Spreadsheets and formulas, if applicable*

1. Top-Speed Bicycle manufactures 21-speed bicycles. The firm has plants in two cities: New Orleans and Omaha. The New Orleans plant has capacity of 20,000 units, and the Omaha plant has a 15,000 unit capacity.

The company ships bicycles to three destinations: New York, Chicago, and Los Angeles. New York demand is 10,000. Chicago demand is 8,000, and Los Angeles demand is 17,000. The shipping costs vary by source and destination. The table below gives per-bicycle shipping costs.

Top-Speed wants to develop a shipping plan for the next year to minimize shipping costs.

1. Write an LP model that can be used to find the minimum cost shipping plan.
2. Write the optimal shipping and minimum cost below.

	NY	Chicago	LA
New Orleans
Omaha
Total Cost =