Q1 2026 Margin vs FY2025 — مقارنة الهامش
34.78%
FY 2025 Gross Margin
GP: EGP 10,598,827 · Avg Qtr: EGP 2,649,707
→
30.08%
Q1 2026 Gross Margin
GP: EGP 2,882,763 · USD impact
⚠
−4.70 pp margin compression driven by USD appreciation increasing external lab costs from 65.2% → 69.9% of revenue. GP increment = EGP 233,056 → Management incentive Q1: EGP 23,306.
Team Q1 2026 Achievement
CS Team Summary — خدمة العملاء
Sales Targets & Actuals — 2026
✎
Targets auto-calculate from Annual Total × Seasonality%. Click actual values to edit. All changes update across all sections instantly.
Sales Incentive Calculator — All Reps
Ahmed Ferra — Management Incentive Tracker — 10% of Q_n 2026 GP minus Q_n 2025 GP
⚠
Ahmed Ferra only — calculated using actual external lab costs (not a fixed margin %) as per the Q1 comparison shown in management review. USD rate is primary variable. Q1 2025 baseline = FY2025 GP ÷ 4 = EGP 2,649,707. Q1 2026 GP at 30.08% → increment EGP 233,056 → incentive EGP 23,306.
Q1 2026 Detailed Calculation — الحساب التفصيلي
All Quarters Summary
Enter / Update Quarterly Actuals — ★ External costs column is critical for margin tracking
Profit Distribution — 2026
2026 Distribution Policy
10%
GP Inc → Mgmt
30%
NP → Reserve
30%
NP → Development
30%
NP → Owners ÷2
10%
NP → Operational Maintenance
P&L Waterfall
Annual Accumulator — المجمع السنوي
FY2025 — Owners Profit Share Distribution توزيع أرباح الملاك 2025
✓
2025 Policy: No Management Incentive — Net Profit = Gross Profit − Indirect Overheads. GP calculated using ACTUAL external lab costs (EGP 19,876,631 = 65.22% of revenue) → GM 34.78%. Distribution: 30% Reserve / 30% Development / 30% Owners / 10% Working Capital.
Configuration & Settings — Reusable for Any Year
ℹ
All parameters are editable and immediately reflected across all dashboard sections. This template can be reused for any year by updating these settings. Staff can be added, removed, or modified at any time.
Field Visits & Fair Evaluation — linked to MASS Visit Tracker
ℹ
Activity figures come from the monthly summary published in the Visit Tracker (Performance → Publish to MASSdx dashboard). The blended score below is an evaluation indicator combining results and effort; it does not change the approved incentive schemes or salaries.
CS Team KPIs — Customer Success 2026
🎯
CS Team incentive (agreed): EGP 300 per eligible patient, regardless of the number of tests. Eligible sources: social-media leads and doctors/labs on no field rep's list (including far or low-rate doctors not worth frequent visits). Every lead is logged in the CS leads sheet; when it becomes a real case it is added here with its LIS case number. Cases from doctors already on a field rep's list go to Dr. Hatem, who approves payment when the rep brought the case through the company's online ads. Wrong entries are rejected. Payment after Dr. Hatem's review. The 4-pillar KPI score is for evaluation only.