Routing-Based RCCP (Oracle Capacity Help)


	Previous	Next		Contents	Index	Navigation	Glossary	Library

Routing-Based RCCP

Routing-based RCCP calculates and compares required capacity to available capacity for the individual resources you assign to operations on your routings. Required and available capacity are stated in hours per week per resource.

Required Hours Calculation

Routing-based RCCP:

Calculates the required hours for each resource by taking each master schedule entry for a bill of resource item, and multiplying the master schedule quantity by the total hours on each bill of resource requirement that references the resource.

Calculates the required date for each resource by offsetting the master schedule date by the setback days defined on the bill of resource requirement. Since Oracle Capacity assumes infinite capacity, all the required hours for the resource are allocated to the required date.

Buckets the required hours into weekly buckets.

The following table shows three master schedule entries for A and illustrates how, for each entry, routing-based RCCP calculates required hours and dates for D1, R2. Remember that during the bill of resource load, Oracle Capacity calculated that 24 hours of D1, R2 is required to build one unit of A, and that setback days for D1, R2 is 3 days. In this example, 10 units of item A are required on 07-FEB. Routing-based RCCP calculates the required hours as 10 x 24 = 240 hours, and the required date as 07-FEB - 3 days = 02-FEB. 05-FEB and 06-FEB are non workdays.

Item Master Schedule Date Master Schedule Qty Required Hours Required Date

A 07-FEB 10 240 02-FEB

A 10-FEB 10 240 07-FEB

A 15-FEB 10 240 10-FEB

Table 1 - 4. Required Hours and Required Dates for D1, R2 (Page 1 of 1)

Item	Master Schedule Date	Master Schedule Qty	Required Hours	Required Date
A	07-FEB	10	240	02-FEB
A	10-FEB	10	240	07-FEB
A	15-FEB	10	240	10-FEB
Table 1 - 4. Required Hours and Required Dates for D1, R2 (Page 1 of 1)

The following table illustrates how routing-based RCCP buckets the required hours for D1, R2 into weekly buckets. The example assumes that the first bucket starts on 31-JAN.

Week Start Date Department Resource Required Hours

31-JAN D1 R2 240

07-FEB D1 R2 480

Table 1 - 5. Bucketed Required Hours and Required Dates for D1, R2 (Page 1 of 1)

Week Start Date	Department	Resource	Required Hours
31-JAN	D1	R2	240
07-FEB	D1	R2	480
Table 1 - 5. Bucketed Required Hours and Required Dates for D1, R2 (Page 1 of 1)

Available Hours Calculation

Routing-based RCCP calculates available hours for a resource using the resource availability information you define in Oracle Bills of Material.

You can define resources, departments, shifts, and shift calendars in Oracle Bills of Material. Having defined your departments, resources, and shifts, you can assign shifts to resources and resources to departments.

Routing-based RCCP calculates available hours for a resource by summing the available hours for each shift that uses the resource using the following formula:

For 24-hour resources, routing-based RCCP modifies the formula as follows:

Capacity units represents the number of resource units available to a department. Shift hours per day and shift days per week reflect the availability times you specify for each shift. Workdays per week reflect the number of workdays in the week based on the workday calendar you define using the Define Workday Calendar window in Oracle Bills of Material.

The following table illustrates how routing-based RCCP would calculate available hours for D1, R2 assuming that you have assigned it to two shifts, Shift 1 and Shift 2. In this example, the available hours for D1, R2 on Shift 1 is 2 x 6 x 5 = 60 hours. Routing-based RCCP would calculate the total hours available for D1, R2 as 60 + 80 = 140 hours per week.

Shift Capacity Units Shift Hours/Day Shift Days/Week Available Hours

Shift 1 2 6 5 60

Shift 2 2 8 5 80

Table 1 - 6. Available Hours for D1, R2 (Page 1 of 1)

Shift	Capacity Units	Shift Hours/Day	Shift Days/Week	Available Hours
Shift 1	2	6	5	60
Shift 2	2	8	5	80
Table 1 - 6. Available Hours for D1, R2 (Page 1 of 1)

Utilization Calculation

Routing-based RCCP calculates capacity utilization for each resource by dividing the total required hours per week by the total available hours per week, using the following formula:

The following table illustrates how routing-based RCCP would calculate capacity utilization for D1, R2 for the weeks starting 31-JAN and 07-FEB. In this example, the capacity utilization for D1, R2, for the week starting 31-JAN, is 240/140 x 100% = 171%

Week Start Date Required Hours Available Hours Capacity Utilization

31-JAN 240 140 171%

07-FEB 480 140 343%

Table 1 - 7. Capacity Utilization for D1, R2 (Page 1 of 1)

Week Start Date	Required Hours	Available Hours	Capacity Utilization
31-JAN	240	140	171%
07-FEB	480	140	343%
Table 1 - 7. Capacity Utilization for D1, R2 (Page 1 of 1)

Notice that rough cut analysis reveals that D1, R2 is overloaded in both periods. This is illustrated in the following diagram.

Routing-Based RCCP

Required Hours Calculation

Available Hours Calculation

Utilization Calculation

See Also