Optimization Using Solver

shivahsingh

New Member
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>

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Replies
2
Views
183
Replies
1
Views
2K
Replies
5
Views
340
Replies
2
Views
2K
Replies
3
Views
579

1,130,210
Messages
5,640,872
Members
417,174
Latest member
diegomuser

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back