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

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

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

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

View Full Document
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
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

{[ snackBarMessage ]}

What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern