Results 1 to 6 of 6

Excel: Logistics cost optimization with constrained destination points?

Threaded View

swapnil_bhrdwj Excel: Logistics cost... 09-10-2019, 09:25 AM
MrShorty Re: Excel: Logistics cost... 09-10-2019, 10:16 AM
swapnil_bhrdwj Re: Excel: Logistics cost... 09-10-2019, 11:27 AM
MrShorty Re: Excel: Logistics cost... 09-10-2019, 12:36 PM
Alf Re: Excel: Logistics cost... 09-10-2019, 01:03 PM
Alf Re: Excel: Logistics cost... 09-10-2019, 01:58 PM
  1. #1
    Registered User
    Join Date
    09-10-2019
    Location
    India
    MS-Off Ver
    2016
    Posts
    2

    Excel: Logistics cost optimization with constrained destination points?

    We are trying to run a model, which will help us minimize the overall logistics cost. We have different type of vehicles available in the fleet, each with a different capacity and different tariff.

    As a result of this solution, we want to reach an outcome, where not only the logistics cost incurred by me is the lowest, but at the same time, I want to ensure that most of number of vehicles used by me are touching two drop points. All drop points available can be assumed to be equidistant for the sake of simplicity. The way we have modeled this problem is not helping because solver is throwing an error that we are trying to solve a NSP (Non Smooth Problem)

    Objective fn: sum(derived_cost,criteria(Combination>0))

    VehicleConfiguration.png
    Optimization.png

    Will be grateful if someone can help.
    Attached Images Attached Images
    Last edited by swapnil_bhrdwj; 09-10-2019 at 11:24 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Constrained regression using Excel solver
    By samquerty in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 01-30-2017, 11:05 AM
  2. MRP logistics
    By ppiotrexx in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-09-2016, 04:47 PM
  3. Am I Excel-constrained or RAM-constrained
    By OhNo in forum Excel General
    Replies: 10
    Last Post: 02-05-2015, 10:14 PM
  4. Conversion table logistics
    By jondh18 in forum Excel General
    Replies: 2
    Last Post: 01-10-2015, 07:41 PM
  5. Replies: 0
    Last Post: 06-14-2012, 04:42 PM
  6. Help with some logistics
    By StompS in forum Excel General
    Replies: 1
    Last Post: 01-11-2006, 01:10 PM
  7. Cost optimization
    By banpo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-05-2005, 09:15 AM

Tags for this Thread

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