+10.7% versus Plan
AdventureWorks performance review
AdventureWorks beats Plan—but volume is not the reason
The management question is how to protect margin while reducing product and geographic concentration.
Clara
Actual vs Plan sales extract; values shown without currency.
Actual vs Plan
A 3.03m sales uplift converts into 1.14m of gross margin
37.7% of gross-sales upside
Plan was 39.14%
15,912 units in both scenarios
Gross margin = Salesamount − Discount − Cogs; source currency is unknown.
Sales bridge
The sales bridge is entirely rate-driven
Values in millions; currency unknown.
Actual reaches 31.39m with no unit variance; this is not evidence of demand growth.
Plan 28.36m + uplift 3.03m = Actual 31.39m.
Product economics
Road Bikes carry scale; Mountain Bikes carry margin quality
Road Bikes
52.1% of Actual gross sales
36.6% after discounts and COGS
Price, discount, and sourcing by product and region
Mountain Bikes
34.2% of Actual gross sales
44.0%—about eight points above Road Bikes
Protect the pricing and sourcing economics
Actual scenario; source currency is unknown.
Portfolio map
Mountain Bikes combine scale with the strongest bike margin
Actual scenario; margin uses net sales.
Mountain Bikes are the clearest defend-and-invest franchise in this extract.
Bubble area represents units; source currency is unknown.
Commercial exposure
The business is concentrated by geography and product—not by customer
of Actual gross sales
of Actual gross sales
of Actual gross sales
Named-customer aggregation in the Actual scenario.
Evidence quality
FY2019 looks like growth, but the population changed with it
6.25m in FY2018 → 16.89m in FY2019
3,222 → 10,483
3,219 → 8,963
31 → 61
Treat the increase as population expansion until completeness and like-for-like coverage are documented.
A stable product, customer, geography, and period perimeter would change this conclusion.
Fiscal year runs July–June in this analysis.
Evidence boundary
The extract supports commercial diagnosis—not a full company valuation
Reconciled to the source rows
supportedUse for portfolio and scenario review
No source field or metadata
openKeep values unitless
Population changes materially by year
partialRequire like-for-like coverage
No opex, cash flow, returns, or inventory
openDo not infer enterprise economics
Semantic contract is structurally valid but remains draft-unreviewed.
Management agenda
Protect the margin engine, test the scale engine, fix the evidence base
Preserve Mountain Bike pricing and sourcing that support a 44.0% margin rate.
Commercial + sourcingExplain the Road Bike margin gap by product, discount, region, and cost assumption.
Finance + categoryCreate a like-for-like fiscal view with documented coverage and confirmed currency.
Data ownerThe current evidence supports a commercial action plan—not a growth victory lap.
Clara recommendation based on the reviewed AdventureWorks extract.