We decided to adjust a bit MRPEasy software for several our customers from food manufacturing industry. Having some tips from them we started to learn, what bigger and older “colleagues” offer for food industry.
After search in Google we have refined the typical description for “food manufacturing software”. Even the first link drived us to professionally styled website with the following information:
“Company X offers a complete food manufacturing software solution for food and beverage manufacturers. Company X’s food manufacturing software functionality includes formula and recipe management, forward and backward lot traceability, scalable batches, product grade management, bi-product and co-product processing, multi-level yield management, private-label operations, and good manufacturing practices (GMP) support.”
What is that? That is BS, sorry. The list of functionalities above contains nothing specific for the food industry.
The most important differences with other industries, when your produce food, are:
- raw materials have expiry date;
- final products have shelf life time;
- sometimes the software may help with calculation of nutrition content, but this is truly specific function.
So we decided to implement the following functionality:
a) Products have a property “Shelf life (in days)”. It is optional: some products may have it and others may not have it.
b) When you create a new purchase order or stock lot, there is a field “Expiry date”. By default it contains a value that is calculated based on shelf life, but it can be edited manually.
c) In Stock – Stock lots a column is added: “Expiry date”. You can sort or search stock lots by this date.
d) When software tries to book stock items (when creating a manufacturing order or booking a customer order), it books only products that are not expired.
e) When software tries to book stock items that have expiry date, it books them not by FIFO, but by expiry date (products that expire first are booked first).
f) When creating a manufacturing order, the software automatically calculates Expiry date based on shelf life.
g) The software does not automatically delete expired stock lots. These lots can be found in Stock – Stock lots when searching lots that have expiry date less than today. If they should be deleted, it must be done manually.
Do you have any comments?