Optimization Using Solver

shivahsingh

New Member
Joined
Oct 1, 2014
Messages
10
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 LowFixed High
Supply RegionEast CoastWest CoastSouth CoastNorth CoastCost ($)CapacityCost ($)Capacity
East Coast 81 92 101 130 7,00015 10,50025
West Coast 117 77 108 98 5,50015 8,25025
South Coast 102 105 95 119 7,50015 11,25025
North Coast 115 125 90 59 5,10015 7,65025
Demand713812
Decision Variables
Demand Region - Production Allocation (1000 Units)PlantsPlants
Supply RegionEast CoastWest CoastSouth CoastNorth Coast(1=open)(1=open)
East Coast
West Coast
South Coast
North Coast
Constraints
Supply RegionExcess Capacity
East Coast
West Coast
South Coast
North Coast
East CoastWest CoastSouth CoastNorth 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.

Watch MrExcel Video

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top