
Chandpur Enterprises Limited, Steel Divi...
Bodily, Samuel E.,...
Chandpur Enterprises Limited, Steel Division
Bodily, Samuel E.; Mittal, Akshay
QA-0761 | Published April 6, 2011 Case
Collection: Darden School of Business
Product Details
The managing director of a steel plant faces the decision of how much of each raw material to order for the plant for the following month. Due to lower and upper bounds on the amounts of each raw material in a batch and varying amounts of electricity and time consumed for different raw materials, one can't simply use the cheapest raw material. A linear program and the solver optimization function of Excel will provide the optimal amounts that meet the constraints. Interestingly, the best mixture for a batch is not the best mixture for a monthly plan. Shadow prices indicate the value of relaxing constraints. The typical monthly model from a student will be nonlinear, although it can be written as a linear model. This case provides the basis for an introductory class on linear programming and linear versus nonlinear models.
1. Linear modeling 2. Use of solver to find the optimized solution 3. Concept of shadow price and positive impact of flexing the constraints 4. Introduction of nonlinear models and associated challenges (local maxima versus global maxima) 5. Converting nonlinear models to linear models
Get Ahead in Class

Clear, Complete, and Concise: Avoiding t...
Lipson, Marc L.

Business Valuation in Mergers and Acquis...
Schill, Michael J....

A Brief Introduction to Macroeconomics
Murphy, Daniel

Moral Theory, Frameworks, and the Langua...
Wicks, Andrew C.; ...

Three Empirical Methods for Calculating ...
Zhang, Zhihao; Whi...

The Basics of Multivariate Regressions i...
Batova, Tatiana

Advanced Tableau Tips and Tricks
Palomba, Anthony

Digital Marketing Metrics: Measuring Wha...
Venkatesan, Rajkum...

Disruption, Response, and Transformation...
Chen, Ming-Jer; Mc...

Using AI to Expand Your Leadership Commu...
Murray, Meghan

Understanding Organizational Culture: An...
Martin, Sean; Kemp...

A Brief Introduction to Managerial Accou...
Lynch, Luann J.

How to Prototype a Prototype
Chao, Raul O.

The Strategist’s Toolkit
Lenox, Michael; Ha...

Finance People
Schill, Michael J.