Project #4: Chandpur Enterprises Limited Creating and optimizing linear models in Excel Background Businesses are often faced with complex decisions that are not easy to solve using typical "rules of thumb." In this project, you will find a solution for one of these complex decisions by creating a spreadsheet assignment in Excel and using Solver to find the best solution. Learning goals 1. Create a linear model in Excel 2. Use Solver to find an optimized solution 3. Understand and explain what makes a model "linear" 4. Understand the concept of shadow price and the effect of modifying constraints 5. Use shadow prices and reduced costs to find opportunities to add value 6. Learn about nonlinear models and their associated challenges (local vs global maxima) 7. See how to convert a nonlinear model to a linear model Instructions Download case and data This case and the corresponding data are available in the same coursepack from which you got the Rocket Fuel case. Link to the Harvard Business School Press website is in the syllabus . Request edit ac Assignment questions 1. If you were making only one batch, what is the best batch you could make? What is the profit associated with this batch? You will answer this question by creating a linear optimization model in Excel. Discuss your findings in a text box. 2. Did the regulatory constraint of 4,000 kg per batch of finished product hamper your ability to make more profit? Is it worthwhile to seek regulatory approval to increase that limit? Specifically discuss the shadow price and interpret its meaning. 3. CEL has used some amount of all seven raw materials in the past. A vendor may be somewhat unhappy if CEL does not order a particular type of raw material. How much profit will Akshay Mittal lose if he must use at least one unit of a raw material in a batch given he would otherwise not use that raw material? 4. What implications does your optimal batch from question one have on monthly contribution margin (profits)? 5. Do you have any further suggestions for how to improve monthly profits? X Calibri ' 11 101