Our team of 3 developed a comprehensive decision support system for Springfield Beans to evaluate two environmentally sustainable initiatives: transitioning to compostable drinkware and implementing a reusable mug discount program. The project employed probabilistic modeling, Monte Carlo simulations, and data-driven visualizations to compare the financial and operational impacts of each solution.

I took the lead in designing and building the interactive dashboard, integrating multiple simulation results to provide actionable insights. The dashboard featured dynamic inputs, visual summaries, and real-time comparisons, enabling decision-makers to explore scenarios and evaluate key metrics, such as cost structures, projected revenue changes, and bottom-line improvements. I also took initiative in making our dashboard visually appealing.

The compostable model analyzed incremental material costs, adoption probabilities, and potential demand increases tied to marketing investments. Similarly, the reusable mug simulation incorporated discount incentives, customer behavioral probabilities (10%-15%), and marketing-driven demand projections to determine cost savings and waste reduction potential. Both models were integrated into a flexible, user-friendly Excel environment featuring robust navigation, scenario testing, and error-proof inputs.

During the competition, we presented our findings to Deloitte consultants, who provided detailed scoring and constructive feedback on improving model assumptions and refining visual outputs. Collaborating in a group of three, I played a pivotal role in linking data sources, constructing complex visual graphs, and optimizing system usability.

Our data-driven approach, technical rigor, and effective communication led us to finalist placement in the competition, affirming our ability to deliver analytical solutions with real-world business impact.