<< Click to Display Table of Contents >> Navigation:  Tools Menu > Consumption Workbench

Consumption Workbench is a tool for comparing the MBOM and process consumption, and change the process consumption accordingly. Go to Tools >>> Consumption Workbench to launch the tool.

To begin, add parts and assemblies that are undergoing an mBOM change. To do this, click Add>>Add assemblies from Library (simple search) or Add Assemblies from BOM (BOM search).

 

In this example, the user is selecting an assembly that they are currently working on using the simple component search. After searching, find the relevant revision in the folder, select it, and click Add.

 

•Add Button: Allows the user to add the Routing and the Assemblies to compare.

•Remove Button: Allows the user to remove the selected Routing and Assemblies.

•Populate Routings from Assemblies: Automatically populates the Routings from the selected Assemblies, looking through the database to find any instances of the assembly in a routing and pulling those cases into the selection automatically.

In this example, the Populate Routings From Assemblies was selected, bringing in all Routings where this assembly is currently being consumed. De-select a routing or operation by unchecking the box to the left.

 

Go into the Consumption Workbench by clicking “Close” on the workbench Input tab.

•Edit Selection: Will allow the user to change the selected Routing and Assemblies. (Will take the user back to Edit selection window in step 1).

•Save: Save the data in the consumption Workbench

•Re compare: It will re compare the BOM to Consumption, flagging all changes as needed.

•Update: Automatically update all the changes in the consumption.  (The user does not have to manually make any changes to the consumption). This is dependent on rules agreed upon by the business and the Proplanner team. A standard example of this is automatically replacing a part that has been replaced in the mBOM by comparing Find Number/Sequence number in the BOM to the equivalent number in consumption.

*This feature may or may not be available in your application, depending on your preferences. Please contact a Proplanner representative for more information.

•Add Consumption: It will allow the user to add assemblies from Library or BOM

•Model Option Data: Allow the user to update the model and option mapping for consumption. Click View Existing to view the existing checked in copy. Click Edit New Consumption to change the model mapping of the row selected on the ‘New consumption’ sheet on the bottom right. This will bring up the same model/option mapping editor from the activity.  

Edit as you would within the activity section.

*Note that this menu can be brought up by right clicking on a row and selecting ‘Edit Model Option Mapping’

**Note that this will not affect Activity Model Option Mapping 

 

The screen that comes up next has three sections:

The first section: (top-Left) contains the processes: Routing, Operations, and Activities

The second section: (on the right) contains folders for parts being Added, Deleted, and Changed

The third section: (bottom-right) contains the consumption sheet for the selected activity, which is split into two parts: Existing Consumption and New Consumption. To see the changes in the Existing Consumption and New Consumption, user will have to click on the Activities on the left side of the screen.

For this example, I am replacing 4567892 with 9788055 so I have a delete of the old part and an Add for the new part. Right clicking on the part to be removed and clicking Show Parent Processes will take me to the relevant activity. This is a case where the Automatic Change could be used to automatically perform the replace based on the BOM dates and OpSeqNo.

 

 

Drag the Add into the New Consumption table, and remove or time out the old part. Then click Recompare. The pending changes made across all assemblies since checking out the routing are shown.

 

The color legends at the bottom of the page will highlight according to the change made. If it’s an Add, Delete or change from the existing consumption.

 

 

 

Definitions:

 

Add: The selection criteria is Parent ID – Child ID – Child Revision combination, i.e., if there is a part under the parent of the revision that is not being consumed under any activity under the routing, it will show up under this folder. Specifically,

(1)Find the activity under the routing where the part needs to be consumed. (If you want to add a new activity to consume this part, close the workbench, add the activity under the routing, and then restart the workbench.)

(2)Click on the activity. The consumption of this activity will be shown below the process sheet in the consumption sheet.

(3)Drag the part from the Add folder and drop it in the consumption sheet.

(4)A part can be consumed in its entire BOM quantity under one activity or across multiple activities. Please note the quantities must match up.

(5)Once the Add change is done, click the “Recompare” icon on the top; this will refresh the list of parts under the Add folder.

 

Delete: The selection criteria is Parent ID – Child ID – Child Revision, i.e., if there is a consumption record for a part under this parent, but this part no longer exists in the MBOM, it will show up under this Delete folder.

(1)Right-click on each deleted part and click the “Show Parent Processes” option.

(2)The routing tree at the top will now show the activities consuming this part. Click on the activity, and the consumption sheet for the activity will be shown at the bottom.

(3)You now need to delete the row of this part from the consumption sheet. Once the deletion is handled, click the ”Recompare” icon to refresh the Delete folder.

 

Change: The selection criteria is Parent ID – Child ID – Child Revision – From Date – To Date – Quantity – OpSeqNo, i.e., for a MBOM record, if there is no record matching it in the consumption, it will show up under this folder. Under this folder, you should look at

A.Qty, Effective From, Effective To, OpSeqNo as well as

B.Prev. Qty, Prev. Effective From, Prev. Effective To, and Prev. OpSeqNo

Any data in A or B is being picked up from the MBOM (consumption). Following are all the cases:

(1)Quantity Change in MBOM if, under this folder, you see a pair of records (the same Parent – Child – Revision combination from MBOM consumption, respectively) with the same OpSeqNo & Prev. OpSeqNo, but different Qty & Prev. Qty. The Effective From/To and Prev. Effective From/To may or may not be different. To handle the quantity change,

A.Right-click the record and click the “Show Parent Processes” option. All the activities consuming this part will be shown under the routing tree.

B.Delete this part from the consumption from each activity shown in the routing tree.

C.Drag the MBOM record of this part (with the new Qty) from the Change folder and drop it under the consumption of one or multiple activities. Then change the quantity in consumption (if you drop the MBOM record to multiple activities) accordingly to make sure they match the quantity in the MBOM. For example, if you drag an MBOM record with quantity 2 and drops it to two activities, you also need to change the quantity in the consumption of both activities from 2 to 1.

D.Click the “Recompare” button to refresh the Change folder.

(2)Data Change in the MBOM if, under this folder, you see a pair of records (the same Parent – Child – Revision combination from MBOM and consumption, respectively) with the same data except dates. To handle the change,

A.Right-click the record with Prev. date (i.e., the record from consumption). All the activities consuming this part will be shown under the routing tree.

B.Right-click and delete this record from the activity consumption. Then drag the corresponding MBOM record from the Change folder and drop it in consumption.

C.Click the “Recompare” button to refresh the Change folder.

(3)OpSeqNo Change in the MBOM if, under this folder, you see a pair of records (the same Parent – Child – Revision combination from MBOM and consumption, respectively) with different OpSeqNo and Prev. OpSeqNo. The other data may or may not be different. To handle the OpSeqNo change,

A.Right-click the record with Prev. OpSeqNo (i.e. the record from consumption) All the activities consuming this part will be shown under the routing tree.

B.Delete this record from consumption for all of these activities.

C.Drag the MBOM record (with the new OpSeqNo) from the Change folder and drop it in the consumption of one or multiple activities. Change the quantity as necessary to ensure the consumption quantity matches the MBOM quantity.

D.Click the “Recompare” to refresh the Change folder.

If all three folders are empty, the process consumption matches the MBOM as of the date selected.