+ Reply to Thread
Results 1 to 5 of 5

optimisation

Hybrid View

  1. #1
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,380

    Re: optimisation

    It seems to me that your problem is incomplete. With most any optimization problem, I find that the first step is to come up with an "objective function" -- the function that will tell us what "optimal" means. If you were to do this by hand using paper, pencil, and calculator/slide rule, how would you determine which combination is optimal? How would you measure/calculate how optimal something is?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  2. #2
    Registered User
    Join Date
    03-19-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: optimisation

    MrShorty, that's a good question. Suppliers a,b and c have tendered for a contract and have provided total costs for products 1 and 2. I can allocate any percentage of the contract to whatever supplier. So, I guess what I am after is the best possible percentage of contract that makes up product 1 and 2 that represents the least cost to the overall contract.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Workbook optimisation
    By tuph in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-05-2015, 04:31 PM
  2. Optimisation using the bisection method
    By random_d in forum Excel General
    Replies: 2
    Last Post: 01-11-2015, 01:17 PM
  3. Solver using VBA for portfolio optimisation
    By natalie28 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-16-2014, 04:16 AM
  4. Panel cutting optimisation
    By Markg76 in forum Excel General
    Replies: 3
    Last Post: 03-11-2014, 01:54 PM
  5. [SOLVED] Code Optimisation - Run Speed
    By swizard in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-01-2013, 10:22 AM
  6. Optimisation of code
    By munkee in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-17-2009, 10:26 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1