Context
-
Key figures: 500+ employees, 50M+ USD yearly turnover
- Before: Company was using Excel for estimating their product costs before production, which uses a custom computation method.
- The rest of the operations are executed on SAP.
Main Challenge
-
Understand the empirical logic of the excel calculator, and all hypothesis, from the production team.
- Implement all formulas and approval process.
- Create tables in Odoo for the whole product database and materials.
Solution
-
Integration of Odoo Community with custom tables, views and formulas dedicated to the calculator purpose.
- Each product sheet could have multiple versions and an approval process from user to manager.
- Each product sheet could be exported as an excel document with pictures for the team to share with related partners.
Result
-
Mission accomplished and delivered!