Executed rule: Total charge · retail quote

RX-2

Three account statements, Alexandria branch

Context

Total charge = +

= 85.50 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 [25.00]	—	MD-11!SRV-STATEMENT.fee [25.00]	Source data
3	V-9	Service charge [75.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 [10.50]	IR-2	× ÷ 100	Calculated
6	V-11	Total charge [85.50]	IR-3	+	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 data25.00 EGP
Address: MD-11!SRV-STATEMENT.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-STATEMENT · Record version 1 · Column fee
#3V-9Service chargeCalculated75.00 EGP
IR-1 · AR-1 Service charge: 3 × 25.00 = 75.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 amountCalculated10.50 EGP
IR-2 · AR-2 Value-added tax: 75.00 × 14% ÷ 100 = 10.50
#6V-11Total chargeCalculated85.50 EGP
IR-3 · AR-3 Amount including VAT: 75.00 + 10.50 = 85.50