MBM Products Calculator
Godhra Branch • Operational Analytics

Schemes & Discounts Calculator
MBM Products

This smart Nuvoco MBM Products calculator inputs dealer order quantities across liquids, cover blocks, and adhesives. It automatically applies scheme discounts, rates, and gifts to calculate final landing prices with printable sheets.

Liquid Scheme Construction Chemicals Liquid products • QD • CD • Whitegood gift • SP/PP handling
Cover Block Scheme Cover Block Cover Block pieces • Quantity discount • Cash discount
Tile Adhesive Scheme Tile Adhesive Zone-wise rate • MT-based QD • Truck-load discount
Reference Scheme Rules All slabs, gift eligibility and discount rules in one view

CC Scheme — Product Inputs

CC Result — Excel Columns

GrpProductQty. (lit.)Qty. (pack or bucket)Rate (Rs.)Total value (Rs.)Net value (without GST)QD SlabQDCD SlabCDFinal net valueWG slabWG tentative price (Rs.)SP/PP handlingGross benefit to dealerFinal landing to dealerPer lit. price

CB Scheme — Product Inputs

CB Result — Excel Columns

GrpProductQty. (pcks)Qty. (pack)Rate (Rs.)Total value (Rs.)Net value (without GST)QD SlabQDCD SlabCD---Gross benefit to dealerFinal landing to dealerPer pck price

TA Scheme — Product Inputs

Important: TA rate is linked to Zone + Product + Total MT. Therefore adding/removing a product can change the rate for all TA rows, exactly as the workbook does.

TA Result — Excel Columns

GrpZoneProductQty. (bags)Qty. (MT)Rate (Rs.)Total value (Rs.)Net value (without GST)QD SlabQDCD SlabCD-Truck load slab & per bag discountTruck load discount-Gross benefit to dealerFinal landing to dealerPer bag price

CC Scheme Rules

VolumeQDCDSP/PP
0–99 LNo QD4%₹0
100–200 L₹3004%₹0
201–499 L7%4%₹0
500–999 L10%4%₹0
1,000–1,999 L13%4%₹5/L
2,000+ L15%4%₹5/L

CB Scheme Rules

Volume slabQD / pcCD
0–149₹04%
150–179₹154%
180–252₹204%
253–504₹224%
505–1020₹254%
1021+₹304%

TA Scheme Rules

MTQD / bagCDTruck slabTruck discount / bag
<10₹04%None₹0
10–<20₹114%10 MT₹5
20–<30₹124%
30–<50₹134%35 MT₹8
50+₹144%35 MT₹8
25 MT threshold25 MT₹6

CC Gift / Whitegood Eligibility

Minimum LitresGift ItemTentative ValueScheme Value Used In Benefit
Workbook logic reproduced: CC QD/CD/SP-PP/gift are calculated on total CC litres/net value; CB QD is per-piece rate multiplied by total pieces and CD is 4% of total net value; TA rate is determined by zone + product + total MT and TA QD/truck discount are based on total bags. Gift is the last eligible slab, not the first matching slab.