Yield Optimization & Constraint-Based Modeling Questions
Techniques for optimizing yield and performance under constraints using constraint-based modeling, including linear programming, integer programming, and related optimization methods, applied to operations, manufacturing, supply chain, and product optimization.
EasyTechnical
95 practiced
Given the table schema:transactions(transaction_id PK, sku_id INT, store_id INT, qty_sold INT, sold_at TIMESTAMP)Write a PostgreSQL query that computes weekly demand per sku_id per store for the last 52 weeks and flags SKUs with fewer than 5 weeks of sales as 'is_sparse'. Return columns: sku_id, store_id, week_start, weekly_qty, is_sparse. Explain how you handle weeks with zero sales.
HardTechnical
105 practiced
Design an identification and estimation strategy to measure the causal impact of reallocating inventory across regions on overall conversion yield when interference and capacity constraints exist. Discuss randomized designs (cluster or stratified), instrumental variables, synthetic control approaches, and how to adjust estimators for limited supply and spillovers between units.
EasyTechnical
88 practiced
When would you favor heuristic or metaheuristic approaches (e.g., greedy, simulated annealing, genetic algorithms) over exact LP/MIP solvers for yield optimization problems? Provide concrete problem characteristics (nonlinearity, very large combinatorial space, solution-quality requirements) and practical trade-offs between solution quality and time-to-solution.
MediumTechnical
149 practiced
Compare robust optimization and stochastic programming for handling uncertainty in yield optimization. Provide example scenarios where each approach is more appropriate, discuss computational trade-offs, and describe practical steps to derive uncertainty sets for robust optimization or scenarios for stochastic programming.
MediumTechnical
95 practiced
How would you use sensitivity analysis from an LP to decide whether to expand capacity of a particular machine? Describe which outputs you would inspect (dual values/shadow prices, allowable increase/decrease, reduced costs), how to convert a shadow price into a dollar value to compare against investment cost, and what caveats exist for large capacity changes.
Unlock Full Question Bank
Get access to hundreds of Yield Optimization & Constraint-Based Modeling interview questions and detailed answers.
Sign in to ContinueJoin thousands of developers preparing for their dream job.