Executed rule: Total charge · retail quote

RX-1

Two card replacements, Cairo branch

Context

Total charge = +

= 342.00 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 [2]	—	INPUT!quantity [2]	Source data
2	V-2	Service fee [150.00]	—	MD-11!SRV-CARD-REPLACE.fee [150.00]	Source data
3	V-9	Service charge [300.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 [42.00]	IR-2	× ÷ 100	Calculated
6	V-11	Total charge [342.00]	IR-3	+	Calculated

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

#1V-1QuantitySource data2 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 chargeCalculated300.00 EGP
IR-1 · AR-1 Service charge: 2 × 150.00 = 300.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 amountCalculated42.00 EGP
IR-2 · AR-2 Value-added tax: 300.00 × 14% ÷ 100 = 42.00
#6V-11Total chargeCalculated342.00 EGP
IR-3 · AR-3 Amount including VAT: 300.00 + 42.00 = 342.00