hello team
I got a question and working on it very hard but can not find any way to calculate the data since it's very complicated
Can any one help me to solve this?
here is the question:
In shifts 8 to 16 and 16 to 24, how many driver are needed to deliver all orders on time?
hypothesis:
1 - Air and ground distance is ignored.
2 - The origin of all orders is one point and all these orders are for one day.
3 - Each driver can place two consecutive orders as long as the registration distance between the two is less than or equal to 5 minutes.
Receive and otherwise move after receiving the first order.
4 - The time of order preparation and other times are omitted.
5 - It is assumed that the driver in any case by receiving one or two orders 45 minutes after receiving the second.
Order) If it has received two orders, it is ready to receive the next orders. Delivery time
The same orders are considered and it is assumed that if you receive 2 orders, they are both in the same route
They are.
6 - It is assumed that the maximum number of driver required in each shift is considered and is on the clock.
If the number of non-crowded driver exceeds the number of orders, a queue will be formed for the driver.
7- It is assumed that the driver are recruited and it is possible to dismiss them during short order hours
And driver who receive their last order at the end of the period, for example at 15:55, after distribution
Orders do not return to the origin and are not present in the next shift.
* For example: Order No. 1 and 2 by driver A, Order No. 3 by driver B and Order No. 4 by driver
C changes.
I got a question and working on it very hard but can not find any way to calculate the data since it's very complicated
Can any one help me to solve this?
here is the question:
In shifts 8 to 16 and 16 to 24, how many driver are needed to deliver all orders on time?
hypothesis:
1 - Air and ground distance is ignored.
2 - The origin of all orders is one point and all these orders are for one day.
3 - Each driver can place two consecutive orders as long as the registration distance between the two is less than or equal to 5 minutes.
Receive and otherwise move after receiving the first order.
4 - The time of order preparation and other times are omitted.
5 - It is assumed that the driver in any case by receiving one or two orders 45 minutes after receiving the second.
Order) If it has received two orders, it is ready to receive the next orders. Delivery time
The same orders are considered and it is assumed that if you receive 2 orders, they are both in the same route
They are.
6 - It is assumed that the maximum number of driver required in each shift is considered and is on the clock.
If the number of non-crowded driver exceeds the number of orders, a queue will be formed for the driver.
7- It is assumed that the driver are recruited and it is possible to dismiss them during short order hours
And driver who receive their last order at the end of the period, for example at 15:55, after distribution
Orders do not return to the origin and are not present in the next shift.
* For example: Order No. 1 and 2 by driver A, Order No. 3 by driver B and Order No. 4 by driver
C changes.
| Order ID | Order Number | Create Time | Next Order time duration | Shop User Air Distance | Ground Distance | Time Slot |
727 | 1 | 08:08:00 | 0 | 1000 | 2100 | 08-16 |
728 | 2 | 08:12:00 | 04:00.0 | 2087 | 4382.7 | 08-16 |
729 | 3 | 08:12:00 | 00:00.0 | 3334 | 7001.4 | 08-16 |
730 | 4 | 8:18:00 | 06:00.0 | 1366 | 2868.6 | 08-16 |
731 | 5 | 08:28:00 | 10:00.0 | 447 | 938.7 | 08-16 |
732 | 6 | 08:28:00 | 00:00.0 | 551 | 1157.1 | 08-16 |
733 | 7 | 08:30:00 | 02:00.0 | 551 | 1157.1 | 08-16 |
734 | 8 | 08:34:00 | 04:00.0 | 447 | 938.7 | 08-16 |
735 | 9 | 08:36:00 | 02:00.0 | 447 | 938.7 | 08-16 |
736 | 10 | 08:38:00 | 02:00.0 | 2703 | 5676.3 | 08-16 |
737 | 11 | 08:40:00 | 02:00.0 | 2039 | 4281.9 | 08-16 |
738 | 12 | 08:44:00 | 04:00.0 | 2302 | 4834.2 | 08-16 |
739 | 13 | 08:46:00 | 02:00.0 | 2302 | 4834.2 | 08-16 |
740 | 14 | 08:48:00 | 02:00.0 | 2984 | 6266.4 | 08-16 |
741 | 15 | 08:52:00 | 04:00.0 | 2302 | 4834.2 | 08-16 |
742 | 16 | 08:54:00 | 02:00.0 | 2711 | 5693.1 | 08-16 |
743 | 17 | 09:04:00 | 10:00.0 | 1369 | 2874.9 | 08-16 |
744 | 18 | 09:06:00 | 02:00.0 | 2380 | 4998 | 08-16 |
745 | 19 | 09:08:00 | 02:00.0 | 3596 | 7551.6 | 08-16 |
746 | 20 | 09:08:00 | 00:00.0 | 2396 | 5031.6 | 08-16 |
747 | 21 | 09:14:00 | 06:00.0 | 844 | 1772.4 | 08-16 |
748 | 22 | 09:28:00 | 14:00.0 | 3383 | 7104.3 | 08-16 |
749 | 23 | 09:28:00 | 00:00.0 | 1395 | 2929.5 | 08-16 |
750 | 24 | 09:28:00 | 00:00.0 | 617 | 1295.7 | 08-16 |
751 | 25 | 09:28:00 | 00:00.0 | 1281 | 2690.1 | 08-16 |
752 | 26 | 09:32:00 | 04:00.0 | 3665 | 7696.5 | 08-16 |
753 | 27 | 09:32:00 | 00:00.0 | 613 | 1287.3 | 08-16 |
754 | 28 | 09:40:00 | 08:00.0 | 3232 | 6787.2 | 08-16 |
755 | 29 | 09:42:00 | 02:00.0 | 2632 | 5527.2 | 08-16 |
