Optimization Using Solver

[shivahsingh]

So I need to find out the minimum cost network using solver, but I am so lost on how to use it. I know it somewhat involves the simplex method from linear algebra but not sure how to put the constraints and output in excel. Below is the table.

Inputs - Costs, Capacities, Demands Demand Region Production and Transportation Cost per 1,000,000 Units Fixed Low Fixed High Supply Region East Coast West Coast South Coast North Coast Cost ($) Capacity Cost ($) Capacity East Coast 81 92 101 130 7,000 15 10,500 25 West Coast 117 77 108 98 5,500 15 8,250 25 South Coast 102 105 95 119 7,500 15 11,250 25 North Coast 115 125 90 59 5,100 15 7,650 25 Demand 7 13 8 12 Decision Variables Demand Region - Production Allocation (1000 Units) Plants Plants Supply Region East Coast West Coast South Coast North Coast (1=open) (1=open) East Coast West Coast South Coast North Coast Constraints Supply Region Excess Capacity East Coast West Coast South Coast North Coast East Coast West Coast South Coast North Coast Unmet Demand Objective Function Cost = <colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody> </tbody>

<tbody>
</tbody>