BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
user24feb
Barite | Level 11

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

1 ACCEPTED SOLUTION

Accepted Solutions
Danny_Shaw
SAS Employee

Hi user24feb,

 

The Qty_Prod (quantity per product) variable in Indent BOM data set denotes the quantity of the component required to make one unit of the product.  It only uses quantity per assembly information and does not take into account the scrap factor.  The gross requirement (Gros_Req) variable in Summarized Parts data set will use the scrap factor along with other information (such as quantity on hand and quantity per)  in computing the value.  You can use the SUMMARYOUT= option in PROC BOM statement to create a Summarized Parts data set and find the gross and net requirements from the data set.

 

I hope this will answer your question.  Please feel free to contact me if you have any questions.

 

Thanks and best wish,

Danny

View solution in original post

3 REPLIES 3
Danny_Shaw
SAS Employee

Hi user24feb,

 

The Qty_Prod (quantity per product) variable in Indent BOM data set denotes the quantity of the component required to make one unit of the product.  It only uses quantity per assembly information and does not take into account the scrap factor.  The gross requirement (Gros_Req) variable in Summarized Parts data set will use the scrap factor along with other information (such as quantity on hand and quantity per)  in computing the value.  You can use the SUMMARYOUT= option in PROC BOM statement to create a Summarized Parts data set and find the gross and net requirements from the data set.

 

I hope this will answer your question.  Please feel free to contact me if you have any questions.

 

Thanks and best wish,

Danny

user24feb
Barite | Level 11
Sorry, I forgot the summary output (again; because I usually avoid it.
Danny_Shaw
SAS Employee
Glad this answers your question! Please feel free to contact me if you have any questions.

sas-innovate-2024.png

 

Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

Register now!

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 880 views
  • 0 likes
  • 2 in conversation