Excel2 - Cell Name Value Price R.H. Side Increase Decrease...

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

View Full Document Right Arrow Icon
Microsoft Excel 11.0 Answer Report Man Hong Wong Worksheet: [Excel2]Sheet1 860843373 Report Created: 3/14/2007 8:53:51 PM Target Cell (Max) Cell Name Original Value Final Value $F$11 Profit Total 0 46 Adjustable Cells Cell Name Original Value Final Value $C$10 Quantity Product X1 0 5 $D$10 Quantity Product X2 0 3 Constraints Cell Name Cell Value Formula Status Slack $F$13 Mach 1 Used 5 $F$13<=$E$13 Not Binding 1 $F$14 Mach 2 Used 19 $F$14<=$E$14 Binding 0 $F$15 Mach 3 Used 8 $F$15<=$E$15 Binding 0
Background image of page 1

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

View Full DocumentRight Arrow Icon
Microsoft Excel 11.0 Sensitivity Report Worksheet: [eXCEL HW PR.2.xls]Sheet1 Report Created: 3/14/2007 8:53:51 PM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$10 Quantity Product X1 5 0 5 2 0.33 $D$10 Quantity Product X2 3 0 7 0.5 2 Constraints Final Shadow Constraint Allowable Allowable
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Cell Name Value Price R.H. Side Increase Decrease $F$13 Mach 1 Used 5 6 1.00E+030 1 $F$14 Mach 2 Used 19 2 19 5 1 $F$15 Mach 3 Used 8 1 8 0.33 1.67 Homework for Credit Assignment Product Mix Problem Man Hong Wong 860843373 Problem 2 TA Jing T 1:10-2:00 Product X1 X2 Available Product Minutes Molding 1 6 painting 2 3 19 packing 1 1 8 Unit Profit $5.00 $7.00 Product X1 Product X2 Variables: Quantity 5 3 Total Objective Function: Margin : 5 7 Profit 46 Available Used Constraints: Mach 1 1 6 5 Mach 2 2 3 19 19 Mach 3 1 1 8 8 Formulation: Maximize: $5 Prod X1 + $7 X2 Subject To: Prod X1 <= 6 2 Prod X1 + 3 Prod X2 <= 19 1 Prod X1 + 1 Prod X2 <= 8 Prod X1, Prod X2 >= 0...
View Full Document

This note was uploaded on 04/16/2008 for the course SCHL 1 taught by Professor None during the Spring '08 term at UC Riverside.

Page1 / 3

Excel2 - Cell Name Value Price R.H. Side Increase Decrease...

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