ANSWER KEY - open only after you have scored all tools

PROPOSAL (01): The price breakdown must sum to exactly USD 18,000. No guarantee of rankings or patient numbers. Must mention the Cliniko integration, the 30 November deadline, the 10-day holiday closure, and use plain (non-jargon) language. Watch for invented credentials, invented case studies and invented clinic statistics.

RESEARCH (02): Figures to handle with care: online booking share 41% (A, regional, 2025) vs 52% (C, Harbor & Pine's own bookings, Q3 2026) - different populations and dates, so a good answer explains rather than calls it an error; new-patient value USD 640 (A) vs about USD 580 (C, excludes write-offs). A's 22% booking uplift for sub-3-second mobile load is the only speed evidence. Referrals (48%) outweigh Google (31%) in B. Any figure not in A, B or C is an outside fact and breaks the rule.

DATA (03): Rows in file: 141. Unique orders: 140 (ORD-1071 appears twice). 2 rows have a missing region (USD 900.00 net in total). 1 row has negative units (ORD-1034, -3 units).
Net revenue as given (141 rows, duplicate and negative unit left in): USD 49,831.15.
Net revenue after removing the duplicate row (140 orders, negative unit kept as a return): USD 49,312.75.
By region (deduped): South 13,963.15; East 13,836.75; West 10,939.10; North 9,673.75; missing region 900.00.
By product (deduped): Cedar Shelf Set 20,173.25; Drift Throw Blanket 14,867.20; Aurora Desk Lamp 10,214.40; Brisk Water Bottle 4,057.90.
By month (deduped): Jan 9,148.10; Feb 7,858.20; Mar 10,012.55; Apr 5,305.40; May 8,353.30; Jun 8,635.20.
Largest monthly decline: April, -47.0% versus March (16 orders in April versus 26 unique orders in March).
Average discount (deduped, simple average of lines): 6.89%.
Top rep by net revenue (deduped): Elena 11,918.45; then Amira 10,686.50; Dev 10,506.20; Chloe 8,824.95; Ben 7,376.65.
A good answer states which treatment of the duplicate and the negative unit it used. Totals that differ by treatment are acceptable if the treatment is stated.

MARKETING (04): Check that spend sums to no more than USD 500, at most one email per day, no discount above 15%, no 'bestseller' or medical claims, and a clear link to the 150-unit goal (150 x USD 64 = USD 9,600 gross).

PROJECT (05): Developers 2 x 30 h x 8 weeks = 480 h available vs 330 h needed (69% utilisation). Designer: 15 h x 4 + 5 h x 4 = 80 h available vs 60 h needed. The payment integration cannot start until about the end of week 1 and then needs 10 working days (2 weeks) of vendor approval, so it finishes around the end of week 3 at the earliest. A good plan says the 8-week deadline is feasible with limited slack, names contract signature and vendor approval as the main risks, and does not schedule payment-integration testing before approval.