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

View previous topic View next topic Go down

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

Post  kimballforum on Sat Feb 11, 2012 12:02 pm

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

kimballforum

Posts : 1
Join date : 2012-02-11

View user profile

Back to top Go down

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

Post  ngalemmo on Mon Feb 13, 2012 2:38 pm

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)?
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

both

Post  nodderwaak3 on Mon Feb 20, 2012 7:41 am

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

nodderwaak3

Posts : 1
Join date : 2012-02-20

View user profile

Back to top Go down

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

Post  ngalemmo on Mon Feb 20, 2012 4:30 pm

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.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

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

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum