Executed rule: Fee waiver limit · FY2026 approval thresholds

RX-4

Waiver an agent may grant on three card replacements

Context

Waiver allowed = × ÷ 100

= 128.25 EGP

Click a term to unfold it in place; the i shows where a source value lives.

The values this execution used, each with the cell it was read from.

Click a term to unfold it in place; the i shows where a source value lives.

#	Variable_id	Variable_title	Formula_id	Formula / value origin	Type
1	V-1	Quantity [3]	—	INPUT!quantity [3]	Source data
2	V-2	Service fee [150.00]	—	MD-11!SRV-CARD-REPLACE.fee [150.00]	Source data
3	V-9	Service charge [450.00]	IR-1	×	Calculated
4	V-3	VAT standard rate [14%]	—	MD-21!EG-VAT-STD.rate [14%]	Rule value
5	V-10	VAT amount [63.00]	IR-2	× ÷ 100	Calculated
6	V-11	Total charge [513.00]	IR-3	+	Calculated
7	V-4	Largest fee waiver without approval [25%]	—	MD-24!FEE-WAIVER-RATE@2026.value [25%]	Source data
8	V-12	Waiver allowed [128.25]	IR-4	× ÷ 100	Calculated

Each variable in the order it was evaluated: sources first, then each formula with the values it used.

#1V-1QuantitySource data3 units
Address: INPUT!quantity · Given by whoever runs the calculation (Quantity)
#2V-2Service feeSource data150.00 EGP
Address: MD-11!SRV-CARD-REPLACE.fee · Master data cell, as of 2026-10-15 · record given by input "service"
Master data table: MD-11 · Retail Service Offerings 2026 · Record SRV-CARD-REPLACE · Record version 1 · Column fee
#3V-9Service chargeCalculated450.00 EGP
IR-1 · AR-1 Service charge: 3 × 150.00 = 450.00
#4V-3VAT standard rateRule value14% %
Address: MD-21!EG-VAT-STD.rate · Selected from MD-21, MD-22
Master data table: MD-21 · VAT Codes — Egypt · Record EG-VAT-STD · Record version 1 · In effect from 2017-07-01 to … · Column rate
Selection rule FN-12: jurisdiction = EG (context country), treatment = standard, in effect on 2026-10-15 · Records matched: 1
#5V-10VAT amountCalculated63.00 EGP
IR-2 · AR-2 Value-added tax: 450.00 × 14% ÷ 100 = 63.00
#6V-11Total chargeCalculated513.00 EGP
IR-3 · AR-3 Amount including VAT: 450.00 + 63.00 = 513.00
#7V-4Largest fee waiver without approvalSource data25% %
Address: MD-24!FEE-WAIVER-RATE@2026.value · Master data cell, as of 2026-10-15
Master data table: MD-24 · Approval Thresholds FY2026 · Record FEE-WAIVER-RATE@2026 · Record version 1 · In effect from 2026-01-01 to 2026-12-31 · Column value
#8V-12Waiver allowedCalculated128.25 EGP
IR-4 · AR-4 Fee waiver limit: 513.00 × 25% ÷ 100 = 128.25