Question

Recipe - Units of Measure

  • 29 March 2023
  • 1 reply
  • 62 views
L
Rank
Userlevel 1
Badge +3

I have a question regarding recipe structure and wondering if anyone has seen a similar scenario and has recommendations?

 

  • Raw materials are purchased in kg.
  • BOM also calls for mixing of these by kg (or grams).
  • Some of the materials contain bacteria. At goods inwards this bacteria level is measured (CFU/g).
  • The BOM is based on the suppliers quoted minimum CFU/g. However, in most cases the suppliers will deliver to a higher concentration (meaning less kg are required to achieve the desired concentration level).
  • The result is that the BOM must be recalculated and adjusted on each shop order, depending on the CFU/g of the available raw materials. Raw materials are potentially expensive, so it does not make sense to issue more than required CFU.
  • This also creates an issue for MRP / planning as CFU is not known and plan is only based on kg. When adjustments are made too late, this can cause sudden changes in material availability.

 

Are the any recommendations or suggestions to handle this within IFS or even partly within IFS?

1 reply

anbouk
Rank
Userlevel 6
Badge +16

Liam,

Based on your description, I think that the best option is to add a custom field to capture the CFU/g since each raw material will be lot batch tracked so that you can keep a record of the CFU/g per batch upon receipt.

Then you need to display this field on the shop order form (it would need to sum up the issued components CFU/g) and then the raw materials can be tweaked accordingly based on the sum.

However, as you stated, MRP will not take this into account when planning supply since the rules are based on the qty required, but the minimum concentration could be shown on the created requisitions.

I also think it would be good to show the custom field on the inventory parts in stock overview screen so that total CFU/g could be manually calculated at any stage during planning.

Regards,

Antony

 

Reply


Terms & ConditionsCookie settings