Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Binary integer non-linear programming excel solver premium

Howdy,

I am working a homework problem involving non-linear programming for
an operations research class. The problem is in three parts. The
objective is to minimize the total distance traveled between a
facility and thirty different towns each year by optimally locating
the facility amongst the towns. There are a fixed number of trips
between each facility and each town each year. The second and third
parts of the problem require locating two and three facilities. I
believe I’ve got the first part correct. Excel’s solver give a
consistent and reasonable answer. Of course, two and three facilities
seems to produce local minima. I’ve downloaded and I’m trying to use
Frontline systems Premium solver add-in. Other than randomly sorting
through different starting points, how do I configure the premium
solver to identify the global maximum for each case? Thanks for any
advice or help.

-g
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Binary integer non-linear programming excel solver premium Gary[_3_] Excel Worksheet Functions 3 September 14th 08 07:58 AM
Using Solver - integer solution Dil Excel Discussion (Misc queries) 3 May 12th 07 02:31 PM
Solver bug - Won't return Integer GeoJack Excel Discussion (Misc queries) 3 December 16th 06 09:15 PM
Solver returns non binary answer in binary constrained cells Navy Student Excel Worksheet Functions 6 September 1st 05 03:11 PM
Linear Programming Franklin Excel Discussion (Misc queries) 1 January 22nd 05 09:27 PM


All times are GMT +1. The time now is 02:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"