Hey guys, hope someone can give me some guidance.
We are a steel fabricator and one of our primary commodities is sheets of steel of varying grades. We have multi level/multi assembly bills of materials and may use different thickness and sheet size of steel. We have all steel parts setup as counted units UOM as we buy and issue in full sheets. We miscellaneously issue sheets of steel to a non-nettable location - each of our production jobs consumes a small quantity of the sheet via a cutting operation and this is backflushed. On our production method we will list the quantity required as a decimal ie if we 10% of a sheet we would have 0.1 in the qty required field.
Currently we do not populate the weight fields in E10.
I have new requirement being driven by our safety group, where they would like the weight of the part at any given stage on the bill of material to be shown. We would then highlight on the route card and also on screen when start production happens on the job where for example the part weight is over a certain weight and maybe require specialised lifting equipment or a multi-person team to manipulate.
We would have a number of calculations - first the steel sheet size which would be length x width X thickness X gravity. If we have a piece part that is cut from that sheet we would want a weight for that part. If that piece part is then joined to another piece part we would want their combined weight and so on until we get the final weight of the saleable part.
On the steel sheet size I can potential work this out from the part and/or setup a UOM conversion 1 ea=x kgs.
The question I have is whether or not there is any simplistic way in-system of rolling this up to calculate the weight of the manufactured piece part at each level - for example using UOM conversion in some way I can’t fathom out- and referencing this weight within the MES/route card or if I am going to have to do this outside of the system and then import back in for each part using the DMT.
I hope that this makes sense.