Order Bundling and Ranking

DarkCloud67 · #1 (**permalink**) December 12th, 2008, 21:32

I have an issue where I need to rank orders to do priority based order bundling.

I can possibly force delivery dates and date focus but is there a way to rank by a numerical hierarchy? 1's before 2's?

Thanks,

Rick

joecallan · #2 (**permalink**) December 15th, 2008, 18:03

Are you talking about Sequencing Requirements for Multistop Shipments? If so, you should look into the Dropoff Routing Sequence Functionality. If not, please clarify your requirements.

DarkCloud67 · #3 (**permalink**) December 15th, 2008, 19:08

No, it would be ranking orders based on a process code If you were to have 1 spot available on a shipment, a code that equates to a rank of 1 would get priority over a code with a rank of 2 or 3.

The only way I can think to do this is with agents and setting dates and date focus in order to get order bundling to assign spots correctly.

However, there may be cases were a rank of 2 out weighs a rank of 1.

Rick

anirban1982 · #4 (**permalink**) September 5th, 2009, 15:12

Hi Rick,

Were you able to get this? Also wanted to know what you meant by doing it through Date focus?
Please do let me know if you were able to get this. I am also trying a similar scenario. I am on 5.5 CU4

Regards,
Anirban Roy

DarkCloud67 · #5 (**permalink**) September 7th, 2009, 13:22

No, I was not able to get it working. There is ranking in version 6.0 but I have not had a chance to work with it.

By Date Focus, I was referring to the Date Emphasis on the Order Release. It can be sent to pickup, delivery or both. With pickup OTM only honors the pickup dates and not the delivery dates, delivery does the opposite and both causes OTM to use both pickup and delivery dates when calculating shipments and if the shipment is feasible.

It is set to a default of both in OTM.

Rick

LourensGlog · #6 (**permalink**) September 8th, 2009, 08:24

Rick,

OTM is not able to handle your requirement automatically, due to the nature of the bulk plan (BP) routine. OTM will try to build shipments for all orders you select for the bulk plan, and will only fail to plan those orders for which no shipments can be built (for many reasons like no rate, dates not feasible, etc.). To be clear, those failed orders will ALWAYS fail to plan, either if you plan them alone or with a bunch of other orders together.

What you would like is to have OTM fail to plan an order based on some conditions that are not known prior to the BP result. To me, this sounds like a chicken and egg scenario.

OTM does have some optimizing routines that run after the BP is completed, but these do not include kicking out orders from the BP result.

The solution I could see working is to set up some saved queries (SQ) for the BP:

SQ1: Orders with Rank 1
SQ2: Orders with Rank 1 and 2
SQ3: Orders with Rank 1, 2 and 3

First run a BP for SQ1, look at the resulting shipments and tender (lock the shipment) the ones that have no spots available. Then run a BP for SQ2: the orders on the shipments that were not full will be replanned with the Rank 2 orders. Note that you may run into a problem here that the second BP result could create a full shipment with Rank 1 and 2 orders, and a half full shipment with Rank 1 orders, so you need some manual intervention here.

Hope this is clear.

Lourens