Design
Pricing Optimization for a Sustainable Fashion Brand
Overview
What this challenge is about.
You are provided with historical sales data for similar products, including price, quantity sold, and cost. For each new product, you have estimated demand curves (linear or constant elasticity) and production capacity limits. Your task is to build an optimization model in Excel that maximizes total profit subject to constraints (capacity, minimum price, etc.). Implement a VBA user form that lets the product manager input changes (e.g., cost increase, capacity change) and automatically runs Solver to find new optimal prices. Success means the model recommends prices that increase profit by at least 10% compared to a heuristic pricing strategy.
The Brief
What you'll do, and what you'll demonstrate.
Create an Excel optimization model with VBA automation to set profit-maximizing prices for a sustainable fashion brand's new collection.
Earning criteria — what you'll demonstrate
- Build a constrained optimization model in Excel using Solver
- Implement a VBA user form to interact with Solver
- Analyze demand elasticity and its impact on pricing decisions
- Interpret optimization results and provide business recommendations
Program Fit
Where this fits in your program.
Sharpens the same skills your degree expects you to demonstrate.
Skills
Skills you'll demonstrate.
Each one shows up on your verified credential.
Careers
Roles this prepares you for.
Real titles. Real skill bridges. Pick the one closest to your trajectory.
Career mappings coming soon.