Turn GBI’s sales concentration into a disciplined growth portfolio

A category generating most revenue can be a strategic strength and a source of exposure. The assignment’s question was whether GBI relied too heavily on Touring Bikes and how business intelligence could improve Off-Road performance. The decision needs a sharper objective: grow total contribution while preserving customer service and the economics of the successful category.

The revised report describes 47,992 transactions, with 25,767 Finished Bike records retained after excluding accessories and safety gear. This consistent scope matters: comparing bicycle revenue with a broader product denominator would distort the concentration diagnosis. The analysis covers 2006 to June 2013 and should be interpreted as a historical simulation.

Touring accounts for US$315.05 million and Off-Road US$68.33 million in the revised report. Off-Road’s 21.17% unit share exceeds its 17.82% revenue share, indicating lower realised revenue per unit. Its 50.17% gross margin also trails Touring’s 53.16%. Together these measures distinguish volume, selling value and margin; any improvement plan should identify which lever it is changing.

The category remains commercially material at gross-profit level. However, gross margin does not establish net profitability once dealer support, warranty, distribution and promotion costs are considered. The smallest reported product contribution is the Women’s Off Road Bike at 7.50% of bicycle revenue. This justifies further diagnosis, rather than an automatic discontinuation or discount decision.

German sales organisations show higher Off-Road revenue shares than the US organisations, while the US generates more absolute Off-Road revenue. These are different signals: relative mix can guide peer comparison, whereas absolute contribution can indicate commercial scale. Neither proves that a territory has poor dealer coverage, low customer interest or a positioning problem.

The revised report shows the lowest pooled revenue in Q3. Yet the dataset ends in June 2013, giving quarters unequal exposure. Raw totals cannot establish a seasonal downturn without complete-year or comparable-period analysis. The portfolio rewrite therefore replaces an immediate Q3 campaign conclusion with a requirement to validate recurring patterns, stock availability and dealer order timing.

Maintaining the current portfolio protects an established revenue base but leaves potential Off-Road opportunities unexplored. Broad discounting could lift volume while weakening contribution and brand positioning. Dealer recruitment or product redesign could help, but both require evidence about local demand, channel economics and product objections that the historical transactions do not provide.

The preferred first move is a targeted dealer pilot pairing product training, demonstration availability or improved display with explicit measurement. Interview stronger and weaker dealers to select the intervention. Within-company revenue share is not competitive market share: a BCG growth-share classification requires external market evidence that these records do not provide.

The proposed BI design has a transaction-level sales fact table and controlled product, dealer, geography and date dimensions, consistent with Microsoft’s dimensional modelling guidance. Finance should approve revenue and gross-profit definitions; category mappings and partial periods need visible treatment. Aggregate gross margin must use total profit divided by total revenue, avoiding an unweighted average of transaction percentages.

The sales review should connect every exception to an owner and next action. Combine revenue, units and margin with dealer participation, stock availability, enquiries and demonstration conversion. Review a dealer’s context before changing incentives. Forecasting and automated alerts should follow a reconciled baseline and outperform a simple seasonal benchmark before influencing inventory or campaign decisions.

Compare participating dealers with a credible matched or randomised comparison group over equivalent selling periods. Track incremental gross profit after incentives, campaign costs and demonstration support, alongside inventory ageing and any displacement of Touring sales. Separate orders shipped into the channel from consumer sell-through when data becomes available.

The revised report proposes growth and mix targets, but these need a coherent revenue bridge: category share depends on both Off-Road and Touring performance. Set targets after reconciling that bridge with capacity and dealer economics. Scale only interventions with repeatable contribution gains and acceptable service outcomes; portfolio share should remain a diagnostic measure rather than the sole success criterion.