Thursday, 28 March 2013

Project Pegging in ASCP


Project Pegging in ASCP

Only after the option “Enable Pegging”, plan will start calculating pegging information 


In Plan with Pegging Not Enabled

Pegging Information is not calculated

When Pegging is enabled in Plan Options


Pegging is calculated



"Soft" and "Hard" Pegging

The choice of hard pegging and soft pegging depends completely on your business environment.
Hard pegging is used in always-used project manufacturing environments such as defense contractors since materials are procured and must be strictly allocated to specific projects.
Soft pegging is generally the standard for commercial practices where inventory is considered "common" and can be re-allocated to any customer based on schedule date and current business priorities.

In some cases, commercial practices still require the ability to allocate supply across their supply chain to a specific customer. In these cases, a combination of both methods is used. Oracle provides a feature called 'seiban' that uses hardpegging and the project attribute to allocate supplies to a specific sales order or forecast across the supply chain. Since the pegging feature is controlled by an item attribute, this can be deployed for selected items.


General Settings
* End Assembly/Soft Pegging (for end assemblies)
* Soft Pegging (for buy items)
* End Assembly/Hard Pegging (for end assemblies with projects)
* Hard Pegging (for buy items with projects)


Pegging
-------------
Enter the pegging option.

Soft Pegging - This option allocates supply to demand based on the Reservation Level option set in the MRP Plan options

End Assembly Pegging - This option traces the end assembly the item is pegged to at the top of the bill of material. Even if you do not select end assembly pegging, you can still calculate and view end assemblies on–line.

End Assembly/ Soft Pegging - Choose this option for both soft pegging and end assembly pegging.

Hard Pegging - This option allocates supply to demand based on the Reservation Level option set in the MRP Plan options. This pegs supply to demand and demand to supply by project at all levels of a bill of material.  This allows you to pre–allocate supply to demand and generate planned orders based on the plan level options.

End Assembly/ Hard Pegging - Choose this option for both hard pegging and end assembly pegging.

None - This option disables project material allocation, end assembly pegging, and full pegging.

You must use the memory–based planner to calculate end assembly pegging.



For all Scenarios, following is the setting




Scenario 1
Item
Pegging
Item Type
Planning
SK_PEG00
End Assembly / Hard Pegging
Finished good
MPS Planning
SK_PEG01
End Assembly / Hard Pegging
Subassembly
MRP Planning
SK_PEG02
End Assembly / Soft Pegging
Subassembly
MRP Planning
SK_PEG03
Hard Pegging
Purchased item
MRP Planning
SK_PEG04
Soft Pegging
Purchased item
MRP Planning

BOM



Create forecast with Project reference




Pegging Information is fully displayed



Project Number Reference

Item
Order Type
Project Number
Task Number
SK_PEG00
Forecast
WARRANTY 2002 PACKAGES

SK_PEG00
Planned order
WARRANTY 2002 PACKAGES

SK_PEG01
Planned order
WARRANTY 2002 PACKAGES

SK_PEG01
Planned order demand
WARRANTY 2002 PACKAGES

SK_PEG02
Planned order


SK_PEG02
Planned order demand
WARRANTY 2002 PACKAGES

SK_PEG03
Planned order
WARRANTY 2002 PACKAGES

SK_PEG03
Planned order demand
WARRANTY 2002 PACKAGES

SK_PEG04
Planned order


SK_PEG04
Planned order demand



The Item SK_PEG02’ the Planned Order does not carry the Project Reference
The Item SK_PEG04’ the Planned Order does not carry the Project Reference


Scenario 2

Changing SK_PEG02
Item
Old Pegging
New Pegging

SK_PEG00
End Assembly / Hard Pegging
End Assembly / Hard Pegging

SK_PEG01
End Assembly / Hard Pegging
End Assembly / Hard Pegging

SK_PEG02
End Assembly / Soft Pegging
End Assembly / Hard Pegging

SK_PEG03
Hard Pegging
Hard Pegging

SK_PEG04
Soft Pegging
Soft Pegging


Item
Order Type
Project Number
SK_PEG00
Forecast
WARRANTY 2002 PACKAGES
SK_PEG00
Planned order
WARRANTY 2002 PACKAGES
SK_PEG01
Planned order
WARRANTY 2002 PACKAGES
SK_PEG01
Planned order demand
WARRANTY 2002 PACKAGES
SK_PEG02
Planned order
WARRANTY 2002 PACKAGES
SK_PEG02
Planned order demand
WARRANTY 2002 PACKAGES
SK_PEG03
Planned order
WARRANTY 2002 PACKAGES
SK_PEG03
Planned order demand
WARRANTY 2002 PACKAGES
SK_PEG04
Planned order

SK_PEG04
Planned order demand
WARRANTY 2002 PACKAGES

The Item SK_PEG02’ the Planned Order carries the project Reference
The Item SK_PEG04’ the Planned Order demand gets the Project Reference from its parent as its Hard Pegged now.






Scenario 3

Changing SK_PEG02
Item
Old Pegging
New Pegging

SK_PEG00
End Assembly / Hard Pegging
End Assembly / Hard Pegging

SK_PEG01
End Assembly / Hard Pegging
End Assembly / Hard Pegging

SK_PEG02
End Assembly / Hard Pegging
Hard Pegging

SK_PEG03
Hard Pegging
Hard Pegging

SK_PEG04
Soft Pegging
Soft Pegging


Item
Order Type
Project Number
SK_PEG00
Planned order
WARRANTY 2002 PACKAGES
SK_PEG00
Forecast
WARRANTY 2002 PACKAGES
SK_PEG01
Planned order
WARRANTY 2002 PACKAGES
SK_PEG01
Planned order demand
WARRANTY 2002 PACKAGES
SK_PEG02
Planned order
WARRANTY 2002 PACKAGES
SK_PEG02
Planned order demand
WARRANTY 2002 PACKAGES
SK_PEG03
Planned order
WARRANTY 2002 PACKAGES
SK_PEG03
Planned order demand
WARRANTY 2002 PACKAGES
SK_PEG04
Planned order

SK_PEG04
Planned order demand
WARRANTY 2002 PACKAGES

The Item SK_PEG02’ the Planned Order carries the project Reference
The Item SK_PEG04’ the Planned Order demand gets the Project Reference from its parent as its Hard Pegged now.


Scenario 4

Changing SK_PEG00
Item
Old Pegging
New Pegging

SK_PEG00
End Assembly / Hard Pegging
Soft Pegging

SK_PEG01
End Assembly / Hard Pegging
End Assembly / Hard Pegging

SK_PEG02
End Assembly / Hard Pegging
Hard Pegging

SK_PEG03
Hard Pegging
Hard Pegging

SK_PEG04
Soft Pegging
Soft Pegging



Item
Order Type
Project Number
SK_PEG00
Planned order

SK_PEG00
Forecast
WARRANTY 2002 PACKAGES
SK_PEG01
Planned order
WARRANTY 2002 PACKAGES
SK_PEG01
Planned order demand

SK_PEG02
Planned order
WARRANTY 2002 PACKAGES
SK_PEG02
Planned order demand

SK_PEG03
Planned order
WARRANTY 2002 PACKAGES
SK_PEG03
Planned order demand
WARRANTY 2002 PACKAGES
SK_PEG04
Planned order

SK_PEG04
Planned order demand
WARRANTY 2002 PACKAGES



Pegging for SK_PEG00 Demand




Scenario 5

Release of SK_PEG00 and SK_PEG01
Created 2 Discrete jobs

Item
Order Type
Project Number
WIP Job Project Number
SK_PEG00
Planned order
 --
 --
SK_PEG01
Planned order
WARRANTY 2002 PACKAGES
WARRANTY 2002 PACKAGES


With Discrete jobs (unreleased WIP Jobs)
Item
Old Pegging
New Pegging

SK_PEG00
End Assembly / Hard Pegging
Soft Pegging

SK_PEG01
End Assembly / Hard Pegging
End Assembly / Hard Pegging

SK_PEG02
End Assembly / Hard Pegging
Hard Pegging

SK_PEG03
Hard Pegging
Hard Pegging

SK_PEG04
Soft Pegging
Soft Pegging


Pegging with WIP Jobs
Item
Order Type
Project Number
SK_PEG00
Discrete job

SK_PEG00
Forecast
WARRANTY 2002 PACKAGES
SK_PEG01
Discrete job
WARRANTY 2002 PACKAGES
SK_PEG01
Discrete job demand

SK_PEG02
Planned order
WARRANTY 2002 PACKAGES
SK_PEG02
Discrete job demand

SK_PEG03
Planned order
WARRANTY 2002 PACKAGES
SK_PEG03
Discrete job demand
WARRANTY 2002 PACKAGES
SK_PEG04
Planned order

SK_PEG04
Planned order demand
WARRANTY 2002 PACKAGES


Receive Raw material
Item
Subinventory
Locator
UOM
Quantity
SK_PEG03
Stock
'MD.B01.B9.STK..
EA
5
SK_PEG04
Stock
'MD.B01.B9.STK..
EA
5

No reference to Project

Item
Order Type
Qty/Rate
Project Number
SK_PEG00
Discrete job
10

SK_PEG00
Forecast
-10
WARRANTY 2002 PACKAGES
SK_PEG01
Discrete job
10
WARRANTY 2002 PACKAGES
SK_PEG01
Discrete job demand
-10

SK_PEG02
Discrete job demand
-10

SK_PEG02
Planned order
10
WARRANTY 2002 PACKAGES
SK_PEG03
Discrete job demand
-10
WARRANTY 2002 PACKAGES
SK_PEG03
On Hand
5

SK_PEG03
Planned order
10
WARRANTY 2002 PACKAGES
SK_PEG04
On Hand
5

SK_PEG04
Planned order
5

SK_PEG04
Planned order demand
-10
WARRANTY 2002 PACKAGES

The Onhand of 5 is not considered in case of SK_PEG03 as its Hard Pegged
The Onhand of 5 is considered in case of SK_PEG04 as its Soft Pegged

Scenario 6

Item
Old Pegging
New Pegging

SK_PEG00
Soft Pegging
End Assembly / Hard Pegging

SK_PEG01
End Assembly / Hard Pegging
End Assembly / Hard Pegging

SK_PEG02
Hard Pegging
End Assembly / Soft Pegging

SK_PEG03
Hard Pegging
Hard Pegging

SK_PEG04
Soft Pegging
Soft Pegging



Receive Raw material
Item
Subinventory
Locator
UOM
Quantity
SK_PEG03
Stock
MD.B01.B9.STK.WARRANTY 2002 PACKAGES.
EA
5


Item
Project Number
Order Type
Qty/Rate
SK_PEG00
WARRANTY 2002 PACKAGES
Forecast
-10
SK_PEG00
WARRANTY 2002 PACKAGES
Planned order
10
SK_PEG01
WARRANTY 2002 PACKAGES
Planned order
10
SK_PEG01
WARRANTY 2002 PACKAGES
Planned order demand
-10
SK_PEG02

Planned order
10
SK_PEG02
WARRANTY 2002 PACKAGES
Planned order demand
-10
SK_PEG03
WARRANTY 2002 PACKAGES
On Hand
4
SK_PEG03

On Hand
5
SK_PEG03
WARRANTY 2002 PACKAGES
Planned order
6
SK_PEG03
WARRANTY 2002 PACKAGES
Planned order demand
-10
SK_PEG04

On Hand
5
SK_PEG04

Planned order
5
SK_PEG04

Planned order demand
-10

The On hand of 4 is considered in case of SK_PEG03 as it located in the same Project


------------------------------

For below Scenario, following is the setting

The netting logic for Project Planning also takes into account excess common supply for project demand for hard pegged items. This netting logic is available only if the reservation level option for the plan is set to Planning Group.



Reservation Level is changed from Project to Planning Group

Item
Planning Group
Project Number
Order Type
Qty/Rate
SK_PEG00
B01_HOU
WARRANTY 2002 PACKAGES
Forecast
-10
SK_PEG00
B01_HOU
WARRANTY 2002 PACKAGES
Planned order
10
SK_PEG01
B01_HOU
WARRANTY 2002 PACKAGES
Planned order
10
SK_PEG01
B01_HOU
WARRANTY 2002 PACKAGES
Planned order demand
-10
SK_PEG02


Planned order
10
SK_PEG02
B01_HOU
WARRANTY 2002 PACKAGES
Planned order demand
-10
SK_PEG03


On Hand
5
SK_PEG03
B01_HOU
WARRANTY 2002 PACKAGES
On Hand
4
SK_PEG03
B01_HOU
WARRANTY 2002 PACKAGES
Planned order
1
SK_PEG03
B01_HOU
WARRANTY 2002 PACKAGES
Planned order demand
-10
SK_PEG04


On Hand
5
SK_PEG04


Planned order
5
SK_PEG04


Planned order demand
-10

In this case the Item on Hand in Common locator is considered as the Reservation level is set at Planning Group Level

 Perform a Project Burrow transaction

Item
Subinventory
 Locator
SK_PEG03
Stock
MD.B01.B9.STK.WARRANTY 2002 PACKAGES.

To Subinv
To Locator
Quantity
Scheduled Payback Date
Stock
MD.B01.B9.STK.SERVICE BULLETINS 2002.
2
31-Oct-08

Onhand


For getting the Payback Demand and Supply, while collecting data set ‘Payback Demand / Supply’ to Yes

Pegging after planning
Item
Firm
Order Type
Qty/Rate
Project Number
SK_PEG00

Planned order
10
WARRANTY 2002 PACKAGES
SK_PEG00

Forecast
-10
WARRANTY 2002 PACKAGES
SK_PEG01

Planned order
10
WARRANTY 2002 PACKAGES
SK_PEG01

Planned order demand
-10
WARRANTY 2002 PACKAGES
SK_PEG02

Planned order
10

SK_PEG02

Planned order demand
-10
WARRANTY 2002 PACKAGES
SK_PEG03

On Hand
5

SK_PEG03

On Hand
2
SERVICE BULLETINS 2002
SK_PEG03

On Hand
2
WARRANTY 2002 PACKAGES
SK_PEG03
*
Payback Supply
2
WARRANTY 2002 PACKAGES
SK_PEG03

Planned order
6
WARRANTY 2002 PACKAGES
SK_PEG03

Planned order demand
-10
WARRANTY 2002 PACKAGES
SK_PEG03

Payback Demand
-2
SERVICE BULLETINS 2002
SK_PEG04

On Hand
5

SK_PEG04

Planned order
10
WARRANTY 2002 PACKAGES
SK_PEG04

Planned order demand
-10

* Payback Supply is Firm by default

Details of Payback Demand


The Receiving Project is treated as Demand and the Qty is pegged to the Onhand in that project (SERVICE BULLETINS 2002). The ‘Suggested Due date’ on the Demand is the ‘Scheduled Payback Date’


Details of Payback Supply
The Shipping Project qty is treated as Supply incoming with Sugg Due date as the ‘Scheduled Payback Date’

For the Planned Order Demand, the Payback Supply is pegged with Due date



For below Scenario, following is the setting

The Reservation Level is set back to Project level



Item
Planning Group
Project Number
Order Type
Qty/Rate
SK_PEG00
B01_HOU
WARRANTY 2002 PACKAGES
Forecast
-10
SK_PEG00
B01_HOU
WARRANTY 2002 PACKAGES
Planned order
10
SK_PEG01
B01_HOU
WARRANTY 2002 PACKAGES
Planned order
10
SK_PEG01
B01_HOU
WARRANTY 2002 PACKAGES
Planned order demand
-10
SK_PEG02


Planned order
10
SK_PEG02
B01_HOU
WARRANTY 2002 PACKAGES
Planned order demand
-10
SK_PEG03
B01_HOU
WARRANTY 2002 PACKAGES
On Hand
2
SK_PEG03
B01_HOU
SERVICE BULLETINS 2002
On Hand
2
SK_PEG03


On Hand
5
SK_PEG03
B01_HOU
WARRANTY 2002 PACKAGES
Planned order
8
SK_PEG03
B01_HOU
WARRANTY 2002 PACKAGES
Planned order demand
-10
SK_PEG04


On Hand
5
SK_PEG04


Planned order
5
SK_PEG04


Planned order demand
-10
The On hand which is in different Project, gets pegged to excess