Sales Regions Plant locations East Midwest South West Plant Capacity Los Angeles $5.0 $3.5 $4.2 $2.2 10,000 Atlanta $3.2 $2.6 $1.8 $4.8 12,000 New York City $2.5 $3.1 $3.3 $5.4 14,000 36,000 Regional...

How do i do this excel using solver.

Extracted text: Sales Regions Plant locations East Midwest South West Plant Capacity Los Angeles $5.0 $3.5 $4.2 $2.2 10,000 Atlanta $3.2 $2.6 $1.8 $4.8 12,000 New York City $2.5 $3.1 $3.3 $5.4 14,000 36,000 Regional Demand 9,000 6,000 6,000 13,000 34,000 Decision variables Shipment volume (in units) Objective function Minimize total shipment costs Sales Regions Plant locations East Midwest South West Los Angeles Atlanta New York City Demand Satisfaction Total received Total required East >= 9,000 Midwest >= 6,000 South >= 6,000 West >= 13,000 Capacity availability Total Shipped Total capacity Los Angeles <= 10,000="" atlanta="" 12,000="" new="" york="" city="" 14,000=""><>