The invention generally relates to the field of a supply chain management and more specifically relates to the field of a deviation analysis result for a work order.
In a supply chain management, orders given by a customer to a supplier have to be processed typically within a specified period of time. A customer order for a finished product drives the supply chain management. Each customer order has a request date by which the customer would like to receive the complete order. Receiving the completed order depends on a supplier manufacturing process. To efficiently track the order the customer will need consolidated information of the order including time taken to manufacture a product, initial start date of the manufacture process, probable end date of the manufacture process. Typically tracking the order involves determining a deviation result for the order at a final delivery stage. The existing methods and systems typically do not meet the need of tracking the order determining the deviation result for the order using a time tolerance and a quantity tolerance.
Disclosed is a method and system for generating a deviation result for a work order. The generation of the deviation analysis results involves initiating a deviation analysis for a work order, determining a comparison group for the deviation analysis based on an available data and a planned data, generating a deviation analysis result for the comparison group and updating a status of the work order with the deviation analysis result.
A better understanding of embodiments of the invention are illustrated by examples and not by way of limitation, the embodiments can be obtained from the following detailed description in conjunction with the following drawings, in which:
Disclosed is a method and system for generating a deviation result for a work order. The generation of the deviation analysis results involves initiating a deviation analysis for a work order, determining a comparison group based on an available data and a planned data, generating a deviation analysis result for the comparison group and updating a status of the work order with the deviation analysis result.
In business scenario 300, there are three available data, namely a first available data 316, a second available data 318 and a third available data 328 mathematically denoted as Da1, Da2, Da3 respectively. The business scenario 300 has three planned data namely a first planned data 342, a second planned data 354, a third planned data 368 denoted as Dp1, Dp2, Dp3 respectively. In business scenario 300, the planned data is in format Dp=[Tp, Qp; Tpmin, Tpmax, Qpmin, Qpmax], where Dp=planned data, Tp=planned time, Qp=planned value, Tpmin=minimum tolerance time value, Tpmax=maximum tolerance time value, Qpmin=minimum tolerance quantity value, Qpmax=maximum tolerance quantity value. The available data is in format Da=[Ta, Qa], where Ta=available time, Qa=available quantity.
In business scenario 300, a first planned data 344 is Dp1=[T1, 10, T1−2 days, T1+1 day, 9, 12] where planned time is at time instance T1, planned value is 10, minimum time tolerance value is T1−2 days means 2 days lesser than the planned time, maximum time tolerance value is T1+1 day means 1 day more than the planned time, minimum quantity tolerance value is 9, maximum quantity tolerance value is 12. A second planned data 356 is Dp2=[T2, 7, T2−2 days, T2+1 days, 6, 9] where planned time is instance T2, planned value is 7, minimum time tolerance value is T2−2 days means 2 days lesser than the planned time, maximum time tolerance value is T2+1 day means 1 day more than the planned time, minimum quantity tolerance value is 6, maximum quantity tolerance value is 9. A third planned data 362 is Dp3=[T2+2 days, 6, T2, T2+3 days, 5, 8] where planned time is time instance T2+2 d means 2 days more than the planned time, planned value is 6, minimum time tolerance value is T2, maximum time tolerance value is T2+3 days, minimum quantity tolerance value is 5, maximum tolerance value is 8. In business scenario 300, first available data is Da1=[T1−2 days, 6], where available time is time instance T1−2 days means 2 days lesser than the planned time, available quantity is 6, second available data is Da2=[T1+1 day, 7] where available time is time instance T1+1 day means 1 day more than the planned time, available quantity is 7. A third available data is Da3=[T2, 16] where available time is time instance T2 and available quantity is 16. The available data and the planned data can be visualized in a table format for better understanding.
Planned data is as given below:
T2 + 3 days
Available data is as given below:
In business scenario 300, there are three available data namely the first available data 316, the second available data 318 and the third available data 328 mathematically denoted as Da1, Da2, Da3 respectively. The business scenario 300 has three planned data namely a first planned data 342, a second planned data 354, a third planned data 368 denoted as Dp1, Dp2, Dp3 respectively. A first available data 316 with available quantity 6, a second planned data 318 with planned value 7 lie within the time tolerance of a tolerance box 310 of the first planned data 342 with planned value 10. The third available data 328 with available quantity 16 lies within the time tolerance of a tolerance box 312 of the second planned data 354 with planned value 7 and the third planned data 368 with planned value 6.
Determining a comparison group includes determining an assignment result and a deviation result. The determination of the assignment result includes filling the planned data to a minimum tolerance value, a planned value and a maximum tolerance value.
In tolerance box 310 for the first planned data 342 a minimum quantity tolerance value is 9, a maximum quantity tolerance value is 12 and a planned value is 10. In tolerance box 310 for the first planned data 342 a minimum time tolerance value is T1−2 days and a maximum time tolerance value is T1+2 days. In tolerance box 312 for the second planned data 354 a minimum quantity tolerance value is 6, a maximum quantity tolerance value is 9 and a planned value is 7. In tolerance box 312 for the second planned data 354 a minimum time tolerance value is T2−2 days and a maximum time tolerance value is T2+2 days. In tolerance box 314 for the third planned data 368 a minimum quantity tolerance value is 5, a maximum quantity tolerance value is 8 and a planned value is 6. In tolerance box 314 for the third planned data 368 a minimum time tolerance value is T2 and a maximum time tolerance value is T2+3 days.
The determination of the assignment further includes assigning the first available data 316 with available quantity 6 and second available data 318 with available quantity 7 to the first planned data 342 as the first available data 316 and the second available data 318 lie in a time tolerance of the tolerance box 310. Assign the third available data 328 with available quantity 16 to the second planned data 354 with planned value 7 and third planned data 368 with planned value 6 as the third available data 328 lies within time tolerance of tolerance box 312 and tolerance box 314. In mathematical notation: Da1→Dp1, Da2→Dp1, Da3→Dp2, Dp3. Consider filling the first planned data 342, the second planned data 354 and the third planned data 368 to a minimum tolerance value. Assign full planned quantity 6 of the first available data 316 to the first planned data 342. The assigned first available data 316 fills the planned data 342 as first partial planned data 344. In mathematical notation: Da1[6]+Dp1. In the next step assign a second partial available data 320 with quantity 3 of second available data 318 to the first planned data 342 to fill planned data 342 to its minimum tolerance value with quantity 9. The assigned second partial available data 320 fills the first planned data 342 as a second partial planned data 346. In mathematical notation: Da1[6]+Da2[3]→Dp1. Filling the minimum tolerance value 9 of the first planned data is achieved by summing up the first partial planned data 344 and the second partial planned data 346. Assign a first available partial data 330 with quantity 6 of the third available data 328 to the second planned data 354 to fill the minimum tolerance value 6 of second planned data 354. The assigned first available partial data 330 fills the second planned data 342 as first partial planned data 354. In mathematical notation: Da3[6]→Dp2. Assign second partial data 332 with quantity 3 of the third available data 328 to third planned data 368 to fill minimum tolerance value 5 of the third planned data 368. The assigned second partial available data 332 of the third available data 328 fills the third planned data 368 as the first planned partial data 362. In mathematical notation: Da3[5]→Dp3. The minimum tolerance value for the first planned data 342, the second planned data 354 and the third planned data 368 is filled by the first available data 316, the second available data 318 and the third available data 328 based on a scenario defined by the work order.
Consider filling the first planned data 342, the second planned data 354 and the third planned data 368 to a planned value. The planned value of the first planned data 342 is 10, the second planned data 354 is 7 and the third planned data 368 is 5. Assign full quantity 6 of the first available data 316 to first planned data 342. The assigned first available data 316 fills the first planned data 342 as the first planned partial data 344. In mathematical notation: Da1[6]→Dp1. Assign second available partial data 322 with quantity 4 of the second available data 318 to the first planned data 342 to fill planned value. The assigned second available partial data 322 fills the first planned data 342 as a third planned partial data 348. In mathematical notation: Da1[4]→Dp1. Filling the planned value is achieved by summing first available data 316 and the third planned partial data 348. In mathematical notation: Da1[6]+Da1[4]→Dp1. Assign third partial available data 334 with quantity 7 of the third available data 328 to the second planned data 354 to fill planned value. The assigned third partial available data 334 fills the planned data 354 as a second partial planned data 358. In mathematical notation: Da3[7]→Dp2. Assign a fourth available partial data 336 with quantity 6 of third available data 328 to third planned data 368 to fill planned value. The assigned fourth available partial data 336 fills the third planned data 368 as a second planned partial data 364. In mathematical notation: Da3[6]→Ds3. The planned value for the first planned data 342, the second planned data 354 and the third planned data 368 is filled by the first available data 316, the second available data 318 and the third available data 328 based on a scenario defined by the work order.
Consider filling the first planned data 342, the second planned data 354 and the third planned data 368 to a maximum tolerance value. The maximum tolerance value of the planned data is filled by the quantity available data based on the scenario defined by the work order. The maximum tolerance value of the first planned data 342 is 12, the second planned data 354 is 9 and the third planned data 368 is 8. Assign quantity 6 of first available data 316 to the second planned data 342. In mathematical notation: Da1[6]→Dp1. Assign a fourth available partial data 326 with quantity 6 of the second available data 318 to the first planned data 342 to fill the first planned data 342 to maximum tolerance value 12. The assigned fourth available partial data 326 of the second available data 318 fills the first planned data 342 as a fourth planned partial data 350. Filling the maximum tolerance value of the first planned data 342 is achieved by summing first available data 316 and the third partial available data 324. In mathematical notation: Da1[6]+Da2[6]→Dp1. Assign a fifth available partial data 338 with quantity 9 of the third available data 328 the second planned 354 data to fill maximum tolerance value 9. The fifth available partial data 338 of the third available data 328 fills the second planned data 354 as a third partial planned data 360. In mathematical notation: Da3[9]→Dp2. Assign sixth available partial data 340 with quantity 7 of the third planned data 328 to third planned quantity 368 to fill maximum tolerance value 8. The sixth available partial data 340 fills the third planned data 368 as third partial planned data 366. In mathematical notation: Da3[7]→Dp3, resulting in having assigned the full quantity of 16 of Da3 filling almost the maximum tolerance value 8 of Da3. Assign the partial quantity of the second available data 318 to the first planned data 342 exceeding its tolerable maximum value. So now we have Da1[6]+Da2[7]→Dp1, thus assigning a total of 13 and thereby exceeding the maximum tolerance value 12 of first planned data 342 by quantity 1 shown as fifth planned partial data 352 in the first planned data 342. The assignment result for business scenario 300 in mathematical notation is, first assignment result is Da1[T1−2 days, 6]+Da2[T1+1 day, 7]→Dp1[T1, 10, T1−2 days, T1+1 day, 9, 12], second assignment result is Da3[T2, 9]→Dp2[T2, 7, T2−2 days, T2+1 day, 6, 9] and third assignment result is Da3[T2, 7]→Dp3[T2+2 days, 6, T2, T2+3 days, 5, 8]
A deviation result is generated based on the assignment result. For every planned data event of work order there is the deviation analysis result. The deviation result includes of a quantity tolerance result and a time tolerance result. The quantity tolerance result may include low quantity, quantity within tolerance, high quantity. For each planned data the quantity result is determined by a total quantity which was assigned to it from the available data. If the total assigned quantity lies below the minimum tolerance value the result is low quantity. If the total assigned quantity lies between the minimum tolerance value and the maximum tolerance value, the result is quantity within tolerance. If the total assigned quantity lies above the maximum tolerance value the result is high quantity.
The time tolerance result may include early completion, completion time within tolerance and late completion. If the earliest assigned available data is earlier than the minimum time tolerance value and no assigned data is later than the maximum time tolerance value, the result is early completion. If all assigned available data lie within the minimum time tolerance value and the maximum time tolerance value, the result is completion within tolerance. If there is one assigned available data which lies above the upper time limit the result is late completion.
In business scenario 300, the time instance of the available data in the first assignment result lie within the tolerance of the planned data. In mathematical notation: T1−2 days, T1+1 dayε[T1−2, T1+1 day]. The total quantity 6+7=13 of the assigned available data lies above the maximum quantity tolerance value [9, 12] of the planned data. The deviation result for the first planned data 342 is high quantity, completion time within tolerance value.
The time instance of the available data in the second assignment lies within the tolerance of the planned data. In mathematical notation: T2ε[T2−2, T2+1 day]. The quantity 9 of the available data is equal to the maximum quantity tolerance value of the planned data [6, 9]. The deviation result for the second planned data 354 is quantity within tolerance value, completion time within tolerance.
The time instance of the available data in the third assignment lies within the tolerance of the planned data. In mathematical notation T2ε[T2, T2+3 days]. The quantity 7 of the available data lies within the maximum quantity tolerance value of the planned data [5, 8]. The deviation result for the third planned data 368 is quantity within tolerance value, completion time within tolerance.
Consider business scenario 400, where planned data is in format Dp=[Tp, Qp, Tpmin, Tpmax, Qpmin, Qpmax], where Dp=planned data, Tp=planned time, Qp=planned value, Tpmin=minimum tolerance time, Tpmax=maximum tolerance time, Qpmax=minimum tolerance quantity, Qpmax=maximum tolerance quantity. Available data is in format Da=[Ta, Qa], where Ta=available time, Qa=available quantity.
In business scenario 400, a first planned data is Dp1=[T1, 10, T1−2 days, T1+1 day, 9, 12] where planned time is at time instance T1, planned value is 10; minimum time tolerance value is T1−2 days means 2 days lesser than the planned time, maximum time tolerance value is T1+1 day means 1 day more than the planned time, minimum quantity tolerance value is 9, maximum quantity tolerance value is 12. A second planned data is Dp2=[T1+15, 6, T1+13 days, T1+16 days, 5, 8] where planned time instance is T1+15 days, planned value is 6, minimum time tolerance value is T1+13 days means 12 days more than the planned time, maximum time tolerance value is T2+16 days means 16 days more than the planned time, minimum quantity tolerance value is 5, maximum quantity tolerance value is 8. In business scenario 400, first available data is Da1=[T1−2 days, 5], where available time is T1−2 days means 2 days lesser than the planned time, available quantity is 5, second available data is Da2=[T1+5 day, 9] where available time is time instance T1+5 day means 5 days more than the planned time, available quantity is 9. A third available data is Da3=[T1+11 days, 3] where available time is T1+11 days and available quantity is 3.
The available data and the planned data can be visualized in a table format for better understanding
Planned data is as given below:
Available data is as given below:
In business scenario 400, there are three available data namely first available data 414, second available data 416 and third available data 428 mathematically denoted as Da1, Da2, Da3 respectively. Business scenario 400 has two planned data namely first planned data 430 and second planned data 440 mathematically denoted as Dp1 and Dp2 respectively. A first available data 414 with quantity 5 lies within the time tolerance box 410 of the first planned data 430 with quantity 10. A second available data 416 with quantity 9 and a third available data 428 with quantity 4 do not lie within the tolerance box 410 of the first planned data 430 and the tolerance box 412 of the second planned data 440.
Determining a comparison group includes determining an assignment result and a deviation result. The determination of the assignment result includes filling the planned data to a minimum tolerance value, planned value and a maximum tolerance value.
In tolerance box 410 for the first planned data 430 a minimum quantity tolerance value is 9, a maximum quantity tolerance value is 12 and a planned value is 10. In tolerance box 410 for the first planned data 430 a minimum time tolerance value is T1−2 days and a maximum time tolerance value is T1+2 days. In tolerance box 412 for the second planned data 440 a minimum quantity tolerance value is 5, a maximum quantity tolerance value is 8 and a planned value is 6. In tolerance box 412 for the second planned data 440 a minimum time tolerance value is T1+13 days and a maximum time tolerance value is T1+16 days.
The determination of the assignment further includes assigning the first available data 414 to the first planned data 430. In mathematical notation: Da1→Dp1. Assign the first available data 414 with quantity 5 to the first planned data 430. The first available data 414 fills the first planned data as a first partial planned data 432. In mathematical notation: Da1[5]→Dp1. Since the second available quantity 416 and the third available quantity 428 do not lie within the time tolerance box 412 they are not assigned to the second planned data 440. Considering the time instances of the second available data 416 and the third available data 428, they are assigned to the first planned data 430 and the second planned data 440 based on the time instances. In the next step assign third available data 428 with quantity 4 to the second planned data 440. The third available data 428 fills the second planned data 440 as a first partial planned data 442. In mathematical notation Da3[3]→Dp2.
Consider filling the first planned data 430 and the second planned data 440 to its minimum tolerance value. The third available data 428 is closer in time to the second planned data 440 than the first planned data 430. Assign first available partial data 418 with quantity 4 of the second available data 416 to the first planned data 430 to fill the first planned data 430 to its minimum tolerance value 9. The second available data 416 fills the first planned data 430 as a second partial planned data 434. Filling the minimum tolerance value of the first planned data 430 is achieved by summing first available data 414 and the first partial available data 418. In mathematical notation Da1[5]+Da2[4]→Ds1. Assign second partial available data 420 with quantity 2 to the second planned data 440 to fill the second planned data 440 to its minimum tolerance value 5. The second partial available data 420 fills the second planned data 440 as a second partial planned data 444. In mathematical notation: Da2[2]+Da3[3]→Dp2.
Consider filling the first planned data 430 and the second planned data 440 to its planned value. Assign the first available data 414 to the first planned data 430. Assign a third partial available data 422 with quantity 5 of second available data 416 to the first planned data 430 to fill first planned data 430 to its planned value 10. The third partial available data 422 fills the first planned data 430 as the third partial planned data 436. Filling the planned value of the first planned data 430 is achieved by summing first available data 414 and the third partial planned data 436 of the first planned data 430. In mathematical notation: Da1[5]+Da2[5]→Dp1. Assign a fourth available partial data 424 with quantity 3 of the second available data 416 to the second planned data 440 to fill second planned data 440 to its planned value 6. The fourth available partial data 424 fills the second planned data 440 as third partial planned data 446. In mathematical notation: Da2[3]+Da3[3]→Dp2. Assign fifth available partial data 426 of the second available data 416 to the first planned data 430 to fill first planned data 430 above its planned value as fourth partial planned data 438. In mathematical notation: Da1[5]+Da2[6]→Dp1.
The assignment result for business scenario 400 is a first assignment result Da1[T1−2 days, 5]+Da2[T1+5 days, 6]→Dp1[T1, 10, T1−2 days, T1+1 day, 9, 12] and the second assignment result is Da2[T1+5 days, 3]+Da3 [T1+11 days, 3]+Da2[T1+15, 6, T1+13 days, T1+16 days, 5, 8].
The time instance of the first available event in the first assignment lies within the time tolerance: T1−2 dε[T1−2 days, T1+1 day], but the time instance of the second available data T1+5 d is above the maximum time tolerance value of [T1−2 days, T1+1 d]. The total quantity of the available events 5+6=11 lies within the maximum quantity tolerance value [9, 12]. Therefore the deviation result for the first planned data 430 is quantity within tolerance value and late completion.
Time instances of the available events T1+5 d and T1+11 d are below the minimum tolerance value of the planned data [T1+13 days, T1+16 d]. The total quantity of the available events 3+3=6 lies within the maximum quantity tolerance value [5, 8]. Therefore the deviation result for the second planned data is quantity within tolerance value and early completion.
It should be appreciated that reference throughout this specification to one embodiment or an embodiment means that a particular feature, structure or characteristic described in connection with the embodiment is included in at least one embodiment of the present invention. These references are not necessarily all referring to the same embodiment. Furthermore, the particular features, structures or characteristics may be combined as suitable in one or more embodiments of the invention.