Hello,
I would like increase the gross requirement of a bill-of-materials by a certain scrap factor:
Data ProductStructure;
Input @3 Product $2. @ 7 Component $3. @11 Qty @16 RID $15. @32 ScrapFactor;
Datalines;
P2 C1 0.80 Component 0.1
P2 C4 0.20 Component 0
C1 C11 0.50 Component 0
C1 C12 0.50 Component 0
;
Run;
Data PartMaster;
Input @3 Descr $3. @7 Text $35. @45 LeadTime;
Datalines;
P2 Product_2 0
C1 Component_1 2
C4 Component_4 3
C11 Subcomponent_1 3
C12 Subcomponent_2 0
;
Run;
Proc BOM Data=ProductStructure
PMData=PartMaster
Out=BOM_Result;
Structure / Part=Descr
Parent=Product
Component=Component
Quantity=Qty
Factor=ScrapFactor
ID=(Text)
RID=(RID);
Run;
The value of qty_prod in bom_result should be 0.44 for both c11 and c12. However, no matter which scrap factor I choose, I always get the same result. In my example "factor" is working exactly like "rid" (I simply get an additional column) which does not really make sense to me.
Do I have to calculate the actual demand myself using a data step or is there a way to make proc bom do it for me?
Thanks&kind regards