Ludovic* is a business engineer within a well-known industrial ETI but whose name we will not mention for obvious reasons. His mission in the company is to carry out estimates and commercial offers in an international and very technical environment. Ludovic's company is a leader in its field of activity and generates 60% of its turnover from exports.
For 10 years Ludovic has traveled the world to develop the company's turnover. He is fluent in English of course and graduated from a prestigious business school.
To simplify his work, Ludovic worked on his spreadsheet, a solution used within the company as a price study tool. As his needs grew, his spreadsheet was enriched with tabs and columns and it's sometimes a little complex to navigate but overall it doesn't work too badly. Ludovic is quite proud of himself because his tool has recently been generalized to subsidiaries even abroad and it is he who provides the training which costs practically nothing for the company.
Last month, an engineering school intern arrived in the sales department and was asked to work on Ludovic's tool so that he could learn the job and benefit from advice from a senior.
It's sometimes interesting to welcome a new eye and Ludovic did not hesitate to show the different vbA developments and tables, very proud to share his expertise.
But now, the innocent trainee that he is, put his finger on a calculation formula that did not seem correct to him. It didn't take him long to realize that the USD/EUR exchange rate was actually calculated backwards.
Ludovic didn't believe it at first, it must be said that he has been working with his file for a while and in any case he doesn't often use this USD conversion so he doesn't really remember how he had it. does his calculation. However, he had to face the facts and note that on his last estimate for an American client, his quote showed a shortfall of €130,000 or perhaps a dollar, we don't really know anymore.
To make matters worse, the customer has just accepted the quote so he won't even be able to send him an updated version to make up for it. Too badindeed!
* assumed name in fact his name is Bernard.
