Solver - Solver We will use Solver, an Excel add-in, to...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
1 Solver We will use Solver, an Excel add-in, to solve Linear Programming problems. Add-In: An additional piece of software that Excel loads into memory when needed. In Excel, go to Tools Add Ins, put a check beside the Solver option and click OK. Note: Solver is not installed on the hard disk by default. Therefore, the first time you run it you may be prompted for the Microsoft Office CD. You should only have to go through this once. After choosing Solver in the Add-Ins list, go to Tools Solver to access Solver.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 Example: Product Mix Decision Unit Profit: Camshafts $25/unit, Gears $18/unit Resources needed: Steel, Labor, Machine Time. In total, 5000 lbs steel available, 1500 hours labor, and 1000 hours machine time. Camshafts need 5 lbs steel, 1 hour labor, 3 hours machine time. Gears need 8 lbs steel, 4 hours labor, 2 hours machine time. How many camshafts & gears to make in order to maximize profit?
Background image of page 2
3 Understanding the Problem Text-Based Formulation Decision Variables: Number of camshafts to make, number of gears to make Objective Function: Maximize profit Constraints: Don’t exceed amounts available of steel, labor, and machine time.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
4 Algebraic Formulation
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/01/2012 for the course STRATEGY Om121 taught by Professor Abhinavdhar during the Spring '12 term at Harvard.

Page1 / 14

Solver - Solver We will use Solver, an Excel add-in, to...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online