cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X

Material Consumption in CWC

pshashipreetham
17-Peridot

Material Consumption in CWC

Hi,

 

Is there a feature like Material Consumption in CWC, where the user enters a Material Name and a quantity the Operator consumed?

 

Thanks,

Shashi Preetham,
Email: psp316r@outlook.com,
Mobile: +91 8099838001.
4 REPLIES 4

Hi @pshashipreetham ,
Unfortunately CWC doesn't have that feature available, there is no way to point material consumption during the order execution.

Hi @Ivens ,

 

Isn't this an essential feature that needs to be part of CWC? So, do all the features related to material consumption need to be customised?

 

Thanks,

Shashi Preetham,
Email: psp316r@outlook.com,
Mobile: +91 8099838001.

Hi @pshashipreetham ,

 

    I'll check that with our product manager next week, maybe they already have that in the roadmap and I'm not aware. If that's not the case I'll open a request to have this feature implemented on the future versions of CWC.

mstarnaud
15-Moonstone
(To:Ivens)

There is nothing that does this out of the box, but we can use some built-in functionalities to complete what you're interested in.

 

CWC will count production, not consumption. With one exception : the Parts Validation type step. This means CWC can know you made 100 cars, but the only way to know that it used 400 tires and 100 engines is either adding custom tables & data, or setting up the BOMs and having a Parts Validation step as part of the work instruction. But even then, the information would not be shown using out of the box method, you would need to add custom code to aggregate this information and display it. Let's look at some possibilities :

 

- CWC has a report called the Performance Report. It can be interesting in that it shows the number of executions of each work instruction and step and can be filtered by time, station, product and more. It doesn't show list of input materials, but you could couple this with a custom query that multiplies the report's result (number of executions) by the step's input materials. Also, if you are using BOMs and Part Validation type steps, then this data (input materials) should be available in the database, you would just need to write the query to go on top of the Performance Report.

 

- If you want to see the produced and wasted quantities, I believe that using RTPPM's KPI Engine can make it work. It does require having RTPPM installed. Then after having RTPPM in place, I think you would just need to add the equipments in the TimesliceSchedule table as shown in "SQL Code for KPI Engine Models" in this documentation page. You could filter by time and product, among other things. Here's an example of statistics we can see in the KPI Dashboard : 

mstarnaud_0-1736280252471.png

However, like I mentioned this isn't really "consumption" of input materials, it's the count of the output. So you can know that you produced 100 cars, but not that you used 400 tires and 100 engines to make them.

 

- You could also create a brand new report to collect this information. This would require writing a custom query that either collects the list of serial number executions and link the product's BOM, or the list of Part Validation steps executed and their results.

 

- If you want immediate notifications instead of reports, there is the possibility of using the Production Endpoint that calls a custom service whenever a work instruction is finished. Usually the goal of this service is to report the execution to another system like an ERP. This custom service could contain a custom query to get the information from the database : either the BOM or the results of a Part Validation step. So for example you could make it so when you finish executing a work instruction that builds a car, it sends a message to ERP that its BOM (4 tires, engine, etc.) was consumed.

Announcements


Top Tags