AI Costing & Pricing Engine
Overview of product costings, import sheets, and pricing formulas.
Total Products
274
Across all suppliers and subcategories
Active Brand
Synology
Profile: Default (Sample Config)
Exchange Rate
320.00 LKR
Standard USD to Local Conversion
Tax & Categories
12
Configured tax bands & categories
Costing Formula Logic
All prices imported in USD are computed into local LKR reseller costings based on active category tax bands, shipping factors, and dealer margin percentages:
LKR Cost = (Disti_USD + Shipping_USD + Tax_USD + Warranty_USD) * Exchange_Rate
| Shipment Mode | Formula Cost Components |
|---|---|
| Standard Import | Disti Cost + 5% Shipping + Tax (9% / 11% / 15%) + 5% Warranty |
| Hand Carry | (Disti Cost * Rate) + Fixed Trip Charge + 5% RMA Buffer |
Recent Pricelist Uploads
| Supplier | Filename | Import Date | Status |
|---|---|---|---|
| Synology | PriceBook(2026-05-20).xls | 2026-05-20 16:58 | Active |