Test Header
Overview
Business Problem
A Brittish food processing plant needs to be able to track all it's ingredients to the supplier
Exmos Solution
Develop a database which the programmable logic controllers (PLC) update and users can interrogate via a web interface
Tools Used
- SQL Server 2000
- ASP.net
- Developer DXperience Controls
Benefits
Full traceability of the ingredients used in their product.
Business Problem
A British food processing company needs to be able to tell their customers the origin of each of their products ingredients. Our customer's plant processes hundreds of tonnes of food a day. Rather than producing a finished product our customer processes raw ingredients into a mix which is frozen and sent to their customer. These customers then use these mixes to produce their finished product.
The raw ingredients come from many suppliers and the factory has many customers looking for similar mixes. On the factory floor there are containers holding up to 19 tonnes of raw ingredients. As the customers are looking for similar product mixes the raw ingredients are often mixed without a customer, or final prodcut in mind. If you view the diagram below:
For example if one customer was looking for scrambled egg mix and one was looking for pancake batter, the factory would mix egg and milk, which could be used in both recipes. In these mixes their may be eggs from more than one supplier.
Pellentesque consequat, turpis sit amet.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque eleifend, odio sit amet commodo mollis, turpis turpis cursus sapien, at consequat massa leo rhoncus turpis. Sed quis odio nec tortor cursus laoreet. Nam tincidunt. Nullam malesuada, massa quis cursus sagittis, urna lacus aliquet metus, vitae lacinia ante dolor non elit. Donec facilisis nibh in libero. Nunc sagittis. Vivamus a nisl. Curabitur in elit vel orci lacinia vestibulum. Aliquam erat volutpat. Integer cursus, tortor nec gravida porttitor, purus tortor scelerisque odio, non aliquet mauris diam ultricies orci. Maecenas eros nunc, fermentum id, pharetra at, ultrices ac, est. Quisque egestas facilisis ligula. Phasellus et neque eu purus imperdiet ultricies. Ut dignissim enim. Vestibulum ut nisi nec ligula aliquam semper. Suspendisse potenti. Nulla facilisi. Suspendisse justo.
Donec tincidunt nulla non justo. Cras erat. Vestibulum et nulla. Vivamus non quam eget enim semper suscipit. Nulla pharetra pulvinar neque. Maecenas nec lectus id lorem pulvinar cursus. Suspendisse odio lorem, auctor id, vestibulum id, placerat sed, libero. Nunc sit amet risus ac lectus pharetra imperdiet. Aenean egestas condimentum turpis. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Nunc eget neque. Ut sed lectus. Sed ante mauris, blandit eget, molestie sed, hendrerit auctor, velit. Morbi cursus. Nullam eget nisi.
Phasellus blandit metus nec lectus.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce leo orci, elementum ac, iaculis sit amet, faucibus condimentum, sem. Nullam viverra sem laoreet ipsum. Nullam commodo tempus augue. Aliquam erat volutpat. Vestibulum in quam. Cras porttitor sodales orci. Pellentesque condimentum faucibus sapien. Integer lacus neque, fringilla tincidunt, semper nec, sollicitudin non, quam. Donec hendrerit rutrum ligula. Integer rhoncus nisl. Aliquam ut augue.
Aliquam magna. Pellentesque leo. Aliquam erat volutpat. Aenean odio lectus, ultricies at, blandit vel, imperdiet in, justo. Nulla varius velit nec metus scelerisque porta. Mauris et tortor. Nullam metus. Etiam purus nisl, egestas ut, consequat in, consectetur et, purus. Morbi a eros hendrerit urna egestas dictum. Fusce non leo. Nulla accumsan, lectus facilisis congue aliquet, nunc massa luctus nisl, in iaculis nisl libero sed erat.