NLC Calculator — Mahavir Mobile Shop

NLC Sheet — Live

Type MOP and all values calculate instantly. Data syncs live across all devices in real time.

#	Series	Model Name	Total Quantity	MOP (₹)	MOP W/O GST MOP ÷ GST	DP MOP − DP Less%	DP W/O GST DP ÷ GST	Adv Payment × Adv%	Billing Price DP − Adv / DP	Bill Less MOP − DP	CN × CN%	1% Pmt × Pmt%	Quarterly 1 × Qtr1%	Quarterly 2 × Qtr2%	Total CN ↓ Per piece	Grand Total CN Qty + boosters	CN % of MOP W/O GST	Payment Level A / B / C / D	Booster 1 ₹ or %	Quantity	Booster 2 ₹ or %	Quantity	Booster 3 ₹ or %	Quantity
	TOTALS

Total MOP

₹0.00

sum of all products

Grand Total CN

₹0.00

quantity plus boosters

Avg CN %

0.00%

average of MOP W/O GST

Products

active rows

Formula Reference — from your Excel Sheet1

DP = MOP − DP Less%

DP W/O GST = DP ÷ GST

Adv Payment = DP W/O GST × Adv%

Billing Price = DP − Adv Payment

Bill Less = MOP − DP

CN = DP W/O GST × CN%

1% Pmt = DP W/O GST × Pmt%

Quarterly 1 = DP W/O GST × Qtr1%

Quarterly 2 = DP W/O GST × Qtr2%

Total CN = Adv Payment + Bill Less + CN + 1% Pmt + Qtr1 + Qtr2

Grand Total CN = Total CN × Total Qty + enabled booster extras

Booster % = Total CN per piece × booster %

CN % = Grand Total CN ÷ total MOP W/O GST × 100