Oracle WIP Scheduling,Lead times computation scenarios – Part 2

Purpose: How the wip scheduling calculates the start date and end dates, how lead time works are computed and rolled up.

This post is similar to my earlier post except the difference in this case resource is available for 8 hours while in earlier post, resource was available for 24 hours.

Do spare a minute to go through that in order to understand BOM structure that I have defined. After that, continue reading this post.

1.    Compute lead time for 212150-00

Mfg Lead time Resources are available 8 hours
212150-00 2/8 = .25 days

2.  Running compute lead times and then lead time rollup for 3067770-1212

Lead times Resources are available 8 hours  
Cumulative Manufacturing time 9 +1.125+ .25 = 10.375 Assuming that SUB assembly 212150-00 is not in on hand and also needs to be manufactured
Fixed lead time 72/8=9 Sum of lot based resource
Variable Lead time 9/8=1.125 Sum of item based resource
Total lead time ( Processing lead time ) 10.125 Fixed + Variable
Cumulative Total 10.375 Assuming that SUB assembly 212150-00 is not in on hand and also purchase components are also not present and needs to be ordered. Since we do not mentioned any lead time for purchase items, it will be counted as 0
Lead time calculations in Routing

4.    Routing of 306770-1212

In Routing, you see this columns as automatically updated

Total lead time = 10.125 *24 = 243 hours

Operation # Resource Department Operation Description Usage rate Resource Cost Multiply this by 100 to get %
10 Manpower APJ3600 MDM Assembly 2 45 per hr Item 0
20 Manpower APJ3600 Print assembly 2 45 per hr Item 2/243
30 Manpower APJ3600 final assembly 2 45 per hr Item 4/243
40 Manpower APJ3600 Burn 72 Non costed Lot 6/243
50 Manpower APJ3600 Packaging 3 45 per hr Item 222/243
Lead time calculations in Routing

5.   WIP Scheduling

 

Quantity Start date End date
1 6th March 20th march 9+1*1.125=10.125
2 6th March 21st march 9+2*1.125= 11.25

It is because of Job start date is 9th march, WIP assumes it will be released at the beginning of the day.

1 thought on “Oracle WIP Scheduling,Lead times computation scenarios – Part 2”

Leave a Reply