Planning Intern Summer 2027

Simple Modern exists to give generously. As a leading drinkware and consumer goods company, Simple Modern gives at least 10% of annual profits to communities around the world, equaling millions in donations since the company’s founding in 2015. The Oklahoma-owned company offers premium quality products and unique styles for adults and kids at generous prices. Mission-driven and values-based, Simple Modern has grown into a category leader for retail partners like Amazon, Target and Walmart, serving customers in all 50 states and eight countries around the world. To learn more about Simple Modern, visit www.simplemodern.com.

We also foster a vibrant workplace culture, with a mission-driven and values-centered approach that seeks to cultivate relational connection and a sense of purpose. Join us in making a difference while enjoying a fulfilling work experience!

When one of our SKUs is unavailable, some customers buy a different color or size from us and some buy nothing. This project will entail reviewing stockouts on our eCommerce sales channels and measuring where and at what rate sales transfer to other in-stock products, by product type. Your goals will be to determine which products have the highest loss exposure to a stockout and to establish a loss or transference ratio matrix by product. You’ll build an AI-powered model to pull and clean data, analyze where demand transfers and where it disappears, and stress test your conclusions.

1. →Analyze physical retail performance by store. Analyze each store’s performance to answer the question: what sells best in which stores, and why?
2. →Assist in Amazon purchase order review and acceptance.
3. →
   1. →Review Amazon’s weekly inventory coverage and supply health.
   2. →Monitor inbound containers and supply chain for inventory constraints and communicate urgency to assist the Operations team.
4. →Build an analysis that tracks how designs perform relative to average. We consistently bring fresh designas to our customers, and a big part of buying properly to support demand is having data to support which designs are most likely to resonate with customers.
5. →Weekly variance report versus forecast. Analyze the prior week’s sales versus our forecast and investigate what drove the variance.

• Familiarity with Excel and data sets
• Curious and willing to solve ambiguous problems
• Able to explain your analysis out loud and defend the assumptions in it