!!!NEED EXCEL SOLUTION!!!

Nash Auto has two plants, two warehouses, and three customers. The plants are in Detroit and Atlanta, the warehouses are in Denver and New York, and the customers are in Los Angeles, Chicago, and Philadelphia. Cars are produced at plants, then shipped to warehouses, and finally shipped to customers. Detroit can produce 150 cars per week, and Atlanta can produce 100 cars per week. Los Angeles requires 80 cars per week, Chicago requires 70, and Philadelphia requires 60. It costs $10,000 to produce a car at each plant. The costs of shipping a car between various cities are listed in the file attached. Assume that during a week, at most 50 cars can be shipped from a warehouse to any particular city. Determine how to meet Nashs weekly demands at minimum cost.

Nash Auto data
Unit shipping costs
	From \ To	Denver	NY	LA	Chicago	Philly
	Detroit	$1.253	$637
	Atlanta	$1.398	$841
	Denver			$1.059	$996	$1.691
	NY			$2.786	$802	$250

-Draw the network flow for the problem and place the numbers on the network where appropriate.

-Define decision variables

-Build an appropriate LP Model

-Solve the model

-Explain the sensitivity report.

-Suggest some strategies to improve the solution.