If your procurement strategy relies on entering a single "discount" line item on a spreadsheet, you are miscalculating your landed cost. In commercial supply chains, vendors rarely offer flat discounts. They offer cascading, multi-tiered incentives: a 10% volume discount, followed by a 5% seasonal promo, followed by a 2% early-payment deduction. Attempting to calculate these compound percentages manually for hundreds of SKUs is an administrative nightmare that results in overpaying suppliers and underpricing your own inventory. This Memento system acts as a rigid, automated financial funnel, forcing raw unit prices through a strict three-tier discount matrix to output an unassailable final cost.
The Vendor Connection
A price means nothing if it isn't tethered to the supplier who offered it. This database fundamentally intertwines inventory with its source.
Instead of typing a vendor's name into a blank box, the system uses a relational link to a dedicated "Vendors" sub-library. When a procurement officer logs a new "Item", they must link it directly to the exact "Company". This secondary library forces the capture of the "Contact Person" and mandates specific communication channels ("Landline", "Mobile#", "Email"). By hard-coding the inventory to the CRM, you never have to hunt through a separate system to find out who to call when a delivery is late or a price quote needs to be honored.
The Cascading Math Problem
The core of this template is its ruthless automation of compound discounting. It doesn't just subtract a percentage; it recalculates the baseline at every tier.
The process begins with the raw "Unit Price". The system then applies the first discount tier, "D1", using a complex background script to instantly calculate the "AfterD1" price (if D1>0, Unit Price + (Unit Price * D1/100)...). But it doesn't stop there. It then applies the second tier, "D2", to the newly discounted AfterD1 price, not the original baseline. It repeats this exact logic for a final "D3" tier.
Locking the Final Landed Cost
This sequential calculation is exactly how major distributors invoice, and by mirroring that logic, the database ensures your numbers perfectly match the supplier's final bill. The entire complex matrix culminates in a single, JavaScript-rendered field: the "Cost Price". Formatted automatically with the correct currency symbol (₱), this final number is the absolute bottom-line cost to the business, ready to be pushed to the sales or inventory tracking teams without any further human calculation.