Dhawal Sharma
New Member
Hi Gurus!
I have a order position data here. What I wish to achieve is to create a datewise report for execution of orders with two prime objectives.
- Ensure that priroities are met. No order (UID) overshoots its respective Delivery date.
- Ensure the full utilization of capacities.
The date wise plan (lets call it 'schedule') should be made considering capacity in terms of manhours. The schedule will assign work for all working days, excluding any sundays. The manhours needed for each UID is mentioned in data.
It will first pick the UID with nearest Delivery date and assign for a day, then if the capacity permits, new UID with next nearest date will be assigned. If the new UID considered is having more manhours needed than balance capacity, UID qty need to be broken down in parts and only that much qty be assigned for the day which completes the capacity for day.
There can a on UID order which has qty requiring manhours much more than capacity. such UIDs need to start a few days before the delivery date so that the last piece finishes before or on delivery date given.
Our Schedule should cover these cases and inform the no. of pieces to finish date wise to finally ensure ontime delivery.
In case the capacity is less for distributing high qty UIDs, we have a provision for calling on contract manpower and add a 20 manhours capacity.
these are the logics and i feel this can be made. But! I am clueless about how to do it.. Closest reference work I have is this.. https://chandoo.org/wp/formula-forensics-no-031/
Thanks Beforehand for your help!
I have a order position data here. What I wish to achieve is to create a datewise report for execution of orders with two prime objectives.
- Ensure that priroities are met. No order (UID) overshoots its respective Delivery date.
- Ensure the full utilization of capacities.
The date wise plan (lets call it 'schedule') should be made considering capacity in terms of manhours. The schedule will assign work for all working days, excluding any sundays. The manhours needed for each UID is mentioned in data.
It will first pick the UID with nearest Delivery date and assign for a day, then if the capacity permits, new UID with next nearest date will be assigned. If the new UID considered is having more manhours needed than balance capacity, UID qty need to be broken down in parts and only that much qty be assigned for the day which completes the capacity for day.
There can a on UID order which has qty requiring manhours much more than capacity. such UIDs need to start a few days before the delivery date so that the last piece finishes before or on delivery date given.
Our Schedule should cover these cases and inform the no. of pieces to finish date wise to finally ensure ontime delivery.
In case the capacity is less for distributing high qty UIDs, we have a provision for calling on contract manpower and add a 20 manhours capacity.
these are the logics and i feel this can be made. But! I am clueless about how to do it.. Closest reference work I have is this.. https://chandoo.org/wp/formula-forensics-no-031/
Thanks Beforehand for your help!