Exam 1 Excel part w SOLUTIONS

Exam 1 Excel part w SOLUTIONS - Microsoft Excel 12.0...

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

View Full Document Right Arrow Icon
Microsoft Excel 12.0 Sensitivity Report Worksheet: [Book1]Electronics Firm Report Created: 3/7/2011 11:19:33 AM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $H$7 X1 1200 0 1 1 1 $I$7 X2 1000 0 4 1.00E+030 2 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $J$11 Max X1 1200 0 4000 1.00E+030 2800 $J$12 Max X2 1000 2 1000 600 300 $J$13 circuit board constr 2200 0 2500 1.00E+030 300 $J$14 assembly time constr 800 4 800 75 300
Background image of page 1

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

View Full DocumentRight Arrow Icon
An firm produces two products, A and B. Each uses the sam 2,500 available this week. Also, the company has allocated assembly time this week for producing these products of w (.25 hours) each, and the B requires 30 minutes (.5 hours) e forecasts that it could sell a maximum of 4,000 A's and a m the A are $1.00 each, and profits for the B are $4.00 each. Let X1 = quantity of A produced X2 = quantity of B produced MAX: X1 + 4X2 Subject to: X1 <= 4000 X2 <= 1000 X1 + X2 <= 2500 0.25X1 + 0.5X2 <= 800 X1, X2 >= 0 The solution : X1* = 1200; X2* = 1000; Feasible range for C1: 0 - 2; for C2: 2 - infinity; if we change one of the coefficients and stay within these intervals, the solution will not change Shadow prices : zero when the contraint is not
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 14

Exam 1 Excel part w SOLUTIONS - Microsoft Excel 12.0...

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

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