Planning Intern Summer 2027

Simple Modern; Moore (OK); On-site; USD 55,000 - 75,000; Full time

Job summary

Simple Modern is seeking a data-focused planning professional to analyze stockouts, forecast demand and support assortment decisions. You will review eCommerce and retail performance, monitor inventory health, and coordinate with Operations to address supply constraints.

You will build analyses on product performance, explain changes to forecasts, and contribute to weekly variance reporting with cross-functional teams.

Qualifications

• 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.

Responsibilities

• Analyze stockouts on eCommerce and measure transfer of demand to in-stock products by product type.
• Review physical retail performance by store to identify best sellers and drivers.
• Assist in Amazon PO review and weekly inventory coverage checks.
• Monitor inbound containers and communicate urgency to support Operations.
• Build analyses tracking design performance relative to average and explain variance to forecasts.

Skills

Data analysis

Curiosity

Communication of analysis

Tools

Excel

Job description

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!

About the Team

The Planning team is positioned at the intersection of Merchandising, Sales, Finance and Operations. We analyze sales, monitor category trends, support company goals, and create forecasts that fuel our purchase decisions. We function as a highly collaborative team focused on making sure we have the right product at the right time at the right price.

Core Project – Substitution Behavior

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.

Other Projects and Recurring Responsibilities

• Analyze physical retail performance by store. Analyze each store’s performance to answer the question: what sells best in which stores, and why?
• Assist in Amazon purchase order review and acceptance.
• Review Amazon’s weekly inventory coverage and supply health.
• Monitor inbound containers and supply chain for inventory constraints and communicate urgency to assist the Operations team.
• 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.
• Weekly variance report versus forecast. Analyze the prior week’s sales versus our forecast and investigate what drove the variance.

Helpful Skills

• 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