SAS Optimization, and SAS Simulation Studio

turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-09-2015 09:59 AM

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

Accepted Solutions

Solution

11-17-2015
01:30 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to user24feb

11-13-2015 10:14 AM

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

All Replies

Solution

11-17-2015
01:30 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to user24feb

11-13-2015 10:14 AM

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Danny_Shaw

11-17-2015 01:30 AM

Sorry, I forgot the summary output (again; because I usually avoid it.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to user24feb

11-17-2015 12:11 PM

Glad this answers your question! Please feel free to contact me if you have any questions.