VRP Solver improvements to minimize cost
- Status: Pending
- Hadiah: $310
- Penyertaan diterima: 1
- Pemenang: ranashahed2000
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 "[login to view URL] MPQ=10" and "[login to view URL] 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 [login to view URL] Populate Near Storage Location, and,
- "Run Setup KPIs" macro under new [login to view URL] Setup Operational KPIs.
4. Improve map display in [login to view URL] worksheet. We need to:
- Center map around depot location after we run '[login to view URL] 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!!
Penyertaan teratas dari peraduan ini