tracking input to output (or purchase to sales for that matter)

suppose:

a company which buys raw materials in kg (uom) from different suppliers. these materials will undergo n cleaning process steps. With each process other raw materials can be added. Sometimes cleaned products will be merged with other cleaned products into another cleaning processes. All cleaning processes can be different. Finally the end product in kg (uom) will be cut into pieces and can be sold to different customers.
one more thing: the set of cleaning processes is not a fixed set of steps and can depend on the issues on the raw materials.
and finally: selling parts of the end products does not happen all on the same day, but can be for example over the course of n days

basically this boils down to different inputs, on which different processes are applied, resulting in different end product for different customers --> which require a view on traceability.

requirement 1: when customer x bought a part of a certain product, we would like to know the original raw materials in it and vice versa - raw material --> end customer (impact analysis when something is wrong with the end product + checking in which other end products potentially the same raw materials were used)
requirement 2: when customer x bought a part of a certain product, which cleaning processes it went through

please help in which technique or combination of techniques to use here.

tx,
kf

Are you trying to track the actual material back to the source for recall purposes or are you simply trying to report on materials used regardless of actual source? How is inventory and materials tracked today (operationally)?

hi ngalemmo,

it' s about both.
* track the actual resulting material back to the source for recall purposes
* track the orginal material forward to the target for additional recall purposes

thanks for your feedback

kf

Lot tracking, basically?

You would need a process fact table with work order, set, lot issues, material, customer (if known at the time), etc... If it's not made to order, then a second order fact referencing the lots or serial numbers used to fulfill the order.