Project Description

About The Client

A Belgian company, has been a partner to the furniture industry since 1967. As a distributor of hinges, lift systems and drawer systems for kitchen and interior builders, they have been the market leader for years. They have been exporting to Switzerland, France, Germany, the United Kingdom and Israel. Thanks to its 220 dedicated employees, and ongoing investment in technology and automation, the company is growing year on year.

Problem

To pre-calculate each day the sales prices for all customers and for all the products sold for every customer. It should be possible to calculate the prices for a single customer.

Solutions

For each customer-product combination there can be multiple prices to be calculated: the actual price plus zero or more future prices.

These data will be imported into BI to make comparisons for past, present and future turnover per customer (group) and/or product (group)

This results in approximately 500.000 prices to be calculated (only current price, no future price). Approximately 10 prices per second (in a single tread) can be calculated which would take up to 14 hours for the calculation. Therefore, parallel executing is needed and caching wherever possible.

Parallel processing

On one AOS approximately 10 parallel tasks can be executed, this results in approximately 70 prices/sec per AOS which results in 2 hours of calculation (tested on virtualized SQL server and AOS).

If we use 4 AOS servers then we could go to (2×60 + 2×40) = 200 prices/sec. which would reduce the calculation time to less than one hour.

Results

Price pre-calculation is now possible with this customization.

Request a Business Management Consultation