Industrial Solutions

Amsterdam Metro Traffic Signalling System The Recipe Program - RAP Third Party Date Exchange

Windows On Data

A number of applications using a similar architecture and code have been developed and are in intensive use in different industries. They are characterized by detailed custom functionality built into the same framework. Result- efficient development, implementation and maintenance and zero license fees!

The applications are characterised by a down to earth approach and development in most cases of around 3 – 4 months between first discussions and use. All of them are in intensive use and are actively maintained. Several have been modified multiple times as business processes changes. Inspite of this they have retained the initial architecture and have not become difficult to maintain as functionality has grown or become more complex.

The framework uses Microsoft SQL Server, Microsoft .Net and several libraries which have been developed over the last 10 years. It includes source code generation for rapid development. Sources code is a deliverable; reducing dependence on the developer. Here is a brief summary of these applications:

ABC Forecasting using Consumption Analysis

SAP Consumption data (Transfer Orders) and BOMs (Bills of Material) are the input for showing the relationship between raw materials and finished product. Is used for reducing the cost of right offs and costs of keeping stock. Just one example of how this information is used: Finished product using high risk raw materials (expensive, few finished products, erratic ordering) are identified as candidates for precise forecasting with customers.

HWE Hardware Engineering

The application is used to maintain installation data for valves, pumps and other equipment in a large automated production company.

Load Order Planning 2011 (B&B)

The application is used for detailed planning of orders on loading bridges and other limited resources. Uses orders released for production from the third party ERP package. Orders are dragged and dropped on to planning schemas with ample opportunity for adding advice and comments as preparation for production. The planning is printed using Excel. Orders are subsequently tracked as they are processed providing the data for showing how orders were executed relative to the planning.

Pricing Tool 2008 (B&B)

Creation of quotes for finished product using SAP and Optiva data. A quote can combine the costs of raw material, intermediate materials, packing, transport and a number of other factors. Being able to process quotes quickly while retaining records and while having reference points as ‘sanity checks’ is an essential part of giving the customer what they want. This tool is about giving the users a maximum of flexibility within a framework of checks and balances.

Semaphore 2010

The application is a production tool which shows the state of orders as they are being processed. An order is executed in a series of steps executed at various resources. The proven principle is that showing operators the status of equipment and orders is enough for them to shorten lead time; and that reduces complexity. The tool visualizes SAP and TekLogix data and provides reports and functionality for allocating orders to operators.

RED Recipe Editor. 2010.

A Recipe Editor (RED) for Paint Production Recipes. 2010. The application allows users to make production recipes based on SAP BOMs (Bills of Material). A single BOM may be used for several production recipes, each recipe depending on the routing/equipment train used for production. The editor ensures that all materials are included in the correct way in the recipe and allows production steps to be added. The editor continually checks the recipe for errors to ensure that it will be executed correctly in production. During production, orders arriving from SAP are merged with the correct recipe to produce a complete production recipe which is executed on the mixers by production operators.

Recipe program, RAP 2004 (B&B).

The Recipe program, RAP, was developed for Cargill Flavours BV. Cargill is a multi-national company specialising in growing, processing and supply of foodstuffs. The Recipe program was developed with a small group of end-users using prototypes over a period of 3 months; RAP means 'speedy' in Dutch! It was a fixed price project. Fruit juices are combined to specify end product, a model being used to calculate critical parameters and prices. The immediate re-calculation of price and quality parameters allows a recipe developer to optimise recipes quickly and accurately. Reports for the product developers and management were an important part of the project. An unexpected side effect of its use is that developers are now using each other's recipes, which has led to rationalisation and a better appreciation of the relationship between complexity, cost, uniformity and creativity. This type of program plays a part in a complex production process. Interfaces with existing systems ensure that only 'approved' raw material are used in new recipes and that raw material cost and specification are up to date and accurate. It is used by more than 20 users in several countries on a daily basis. The raw material specifications and prices are synchronised with the Lab Control (Unilab) and Commercial systems (Optiva and ERP).

TPI Third Party Instruction coordinator. 2004

TPI is a simple, transparent, business-to-business application. It automates the excution of instructions. The instructions are initiated by Cargill Juice BV and are executed by their warehouses, suppliers and third party transporters. The status of orders is tracked and displayed for users on both sides of the information exchange.

The existing administrative ERP systems are in effect loosely coupled improving accuracy and efficiency. Management information concerning the exceptions, modifications, the production time etc., is used to improve the process. The data exchange uses XML and the instructions are sent using existing communication methods to avoid security problems. In the past the information was exchanged using fax and email.

Batch Calc. 2005


Order accounting data is imported from an existing ERP system. Models for allocating costs are applied and the resulting data can be viewed in multiple ways for balancing and allocating costs.