Poké Inn · Business operations
Sales analysis & product bundles
I studied sales in Excel and changed how products were grouped into featured meal combinations. The reported rate of choosing those combinations increased by 30%.
01 · The business question
A business operations internship involving sales analysis and product bundle decisions.
How can sales data inform product bundles that customers choose more often?
02 · My contribution
- Reviewed sales patterns in Excel to guide changes to product combinations.
- Redesigned the combinations, with a reported 30% relative increase in how often customers selected a featured combination.
03 · The finding
The reported rate of choosing a featured combination increased by 30%. This is a relative change. The original rates and comparison period are not available here.
Project overview
Use a sales pattern to rethink a product bundle
Revised featured product combinations informed by sales analysis.
The original selection rates and measurement period are not published here. The outcome is a reported relative improvement.
Poké Inn / Product combinations
- Reviewed
- Sales patterns in Excel
- Changed
- Featured product combinations
reported relative increase in featured combo selection
The original selection rates and comparison period are not published here.
04 · The decision
Use sales patterns to decide which products to offer together. Review how often customers choose the featured combination after making a change.
05 · Work delivered
- Excel sales analysis
- Redesigned product bundles
- Reported featured combo selection improvement
Learning notes
An operating change needs a defined outcome.
- Sales patterns can point to a bundle worth revising. The bundle decision and the metric used to review it should stay connected.
- A relative change is easier to interpret when the baseline and comparison period are available. Those details are not included in the published project record.
A next questionFor a follow up test, define the eligible orders, baseline selection rate, and comparison window before changing another bundle.
Terms explained
- Product bundle
- Products offered together as one combination.
- Selection rate
- How often the featured option is chosen among the eligible purchases being measured.
- Relative improvement
- A change compared with the starting rate. For example, a 30% relative increase from 10% would reach 13%. Those numbers are an illustration, not this project’s baseline.
Context & measurement notes
A reported relative improvement in featured combo selection. Baseline rates and the comparison period are not available here.