VRP Solver improvements to minimize cost

  • Status: Closed
  • Prize: $310
  • Entries Received: 1
  • Winner: ranashahed2000

Contest Brief

VRP solver model had been adjusted to customer's requirement to handle multi trip and pickup target to maximize profit. Now focus is model be capable to minimize unit cost at high % complete level, time window type equal hard is working well, new macros are included into vrp solver menu, and better visualization capabilities.
So they are 4 objectives to achieve here:
1. Modify VRP solver codes with time window type=Soft to keep maximizing profit (product unit price > $0) or minimizing cost (product unit price = $0) with a low and fix minimum pickup quantity (MPQ). Attached file VRP_Z_Soft with 2 examples of solutions. See worksheets "4.Solution MPQ=10" and "4.Solution MPQ=21". Based on achieving % completes vs target >=98% and the lowest unit cost, second solution seems to be the lowest unit cost solution that must be reached with MPQ<=21 units.
2. Modify VRP solver codes with time window type=Hard to keep maximizing profit or minimizing cost with a low and fix minimum pickup quantity. Attached file VRP_Z_Hard. It contains an example about vrp model is not working well at a multi-trip scenario. Need to update codes similar to ones with time window type=Soft.
3. Add to VRP Spreadsheet Solver menu the following macros:
- "Near ST" macro under 1.Locations/1.4 Populate Near Storage Location, and,
- "Run Setup KPIs" macro under new 7.KPIs/7.1 Setup Operational KPIs.
4. Improve map display in 5.visualization worksheet. We need to:
- Center map around depot location after we run '5.Setup Visualization' macro
- Zoom in/Zoom out map getting more or less details in the background such us: major locations, roads, etc
- Scroll map down/up/left/right with arrow keys and not only with vertical/horizontal side bars.

The agreed amount will be split on 4 payments, one per objective and will be released only after each objetive is tested and approved by employer. All communications must be through freelancer chat, don't ask for other via please.

Thank you for your interest. WE ARE LOOKING FOR VB PROGRAMMERS WITH PREVIOUS EXPERIENCE ON VRP SOLVER CODES ONLY. Happy bidding!!

Recommended Skills

Employer Feedback

“@ranashahed2000 won the contest on 31 December 2020”

Profile image omserran, Ecuador.

Top entries from this contest

View More Entries

Public Clarification Board

  • TraciY
    TraciY
    • 4 years ago

    Is it ok to have the password and take a look at the code? Thanks.

    • 4 years ago
    1. ranashahed2000
      ranashahed2000
      • 4 years ago

      Already I have unlocked it.

      • 4 years ago

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!