# Task 1 answer key — private Accepted paid sales source rows: S01,S02,S03,S06,S07,S10,S12,S13,S14 (9 orders). S04 duplicates S03; S09 is superseded by S10; S05 pending; S08 cancelled; S11 September; S15 November. Gross Workshop 1920 (5 orders), Course 900 (4), total 2820. Applied refunds R01=240 Workshop and R02=60 Course; total 300. R03 duplicate, R04 pending, R05 orphan, R06 amount unknown, R07 November. R06 is an unresolved October settled Course refund: results below are calculable/provisional, not final. Ads A01,A02,A03,A05,A06 total 450 (Workshop 300, Course 150); A04 duplicate, A07 November. Net revenue Workshop 1680, Course 840, total 2520. Contribution after ads Workshop 1380, Course 690, total 2070. Net revenue/paid order: Workshop 336.00, Course 210.00, overall 280.00. Course and combined net/contribution/per-order figures depend on resolving RF05, never silently zero. Workshop is unaffected by RF05. The orphan RF04 separately requires investigation; its product is unknown and must not be assigned. 13 excluded/unresolved source rows in total: 6 sales, 5 refunds, 2 ads. Do not penalize retaining excluded rows in cleaned files if clearly marked and not included in aggregates. Correct handling and traceability matter more than layout.