Gilpers Tranche Pricing Console
The console turns a multi-step, error-prone workflow into a single guided flow that now takes minutes instead of hours. It reduces the risk of mis-priced documents, protects margins when exchange rates move, and makes the business easier to audit because every document ties back to a stored tranche. It also frees time for higher-value work (like local content consultancy) and gives the company a foundation for future automation such as reminders, reporting, or an internal AI assistant to answer “What did we quote this client last year?”.
Key Facts
The Challenge
Gilpers Engineering is a small oil & gas services firm that supplies industrial lubricants in fixed 6-month tranches to a few long-term clients. For every tranche, my dad (the founder) had to juggle multiple Excel sheets and Word templates to: compute the right USD→NGN rate, derive a price per 209-litre drum, and then manually fill out a quotation. When the client accepted and sent a purchase order, he repeated the process to create a matching invoice and delivery note, making sure every figure and date aligned with the original quotation. All of this lived in different files, email threads, and WhatsApp messages with no single source of truth. Re-creating an old quotation months later meant hunting for the exact spreadsheet and FX assumptions he’d used at the time. A small typo in the exchange rate or rate per drum could quietly wipe out the margin on an entire 6-month supply. The challenge for this project was to turn that fragile, memory-driven workflow into a single, reliable system: one place to configure a tranche, lock in its pricing assumptions, and regenerate the full document pack (quotation, invoice, delivery note) consistently whenever the client came back.