
Chandpur Enterprises Limited, Steel Divi...
Mittal, Akshay
Chandpur Enterprises Limited, Steel Division
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
Products To Upsell

Global Medical Imaging, LLC
Hess, Edward D.; G...

Enchanting Travels
Hess, Edward D.; M...

Better World Books
Hess, Edward D.; G...

Valuation of "Plain-Vanilla" Interest-Ra...
Conroy, Robert M.;...

FindingFIT
Clawson, James G.

List Testing Exercise: Economic Selectio...
Pfeifer, Phillip E...

An Introduction to Case Teaching (Part 1...
Clawson, James G.

What Is Giving Voice to Values? (VIDEO)
Gentile, Mary

Giving Voice to Values: An Educators' Pr...
DARDEN, Darden

Digital Marketing Simulation: Media Attr...
Venkatesan, Rajkum...

Dr. Bronner's: Do Psychedelics Fit with ...
Freeman, R. Edward...

AMP - Strategic Innovation & Entrepreneu...
Gupta, Uday

Accounting for Owners’ Equity
Lynch, Luann J.; B...

Test Syllabus 45
Daren Business Sch...

Athlete Brands: How to Benefit from Your...
Whitler, Kimberly ...

What is Design Thinking? (VIDEO)
Liedtka, Jeanne M.

Copyright Permissions
Daren Business Sch...

Thinking Strategically About Communicati...
West, June A.

Optix Corporation
Powell, Elizabeth ...

Leaders Bank: Creating a Great Place to ...
Hess, Edward D.; G...

LG Investments, LLC: A Family Business i...
Hess, Edward D.

Finance People
Schill, Michael J.