Problem 20 Send

# Problem 20 Send - MicrosoftExcel12.0AnswerReport...

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

Microsoft Excel 12.0 Answer Report Worksheet: [Problem 20 Question.xlsx]Sheet1 Report Created: 10/11/2010 2:16:21 PM Target Cell (Min) Cell Name Original Value Final Value \$B\$19 Total Cozt (Z)= Yi 0 720750000 Adjustable Cells Cell Name Original Value Final Value \$B\$4 A 0 0 \$C\$4 B 0 12000 \$D\$4 C 0 0 \$E\$4 D 0 0 \$B\$5 A 0 0 \$C\$5 B 0 0 \$D\$5 C 0 8000 \$E\$5 D 0 0 \$B\$6 A 0 6000 \$C\$6 B 0 0 \$D\$6 C 0 0 \$E\$6 D 0 0 \$B\$7 A 0 0 \$C\$7 B 0 2000 \$D\$7 C 0 0 \$E\$7 D 0 8000 \$B\$8 A 0 0 \$C\$8 B 0 0 \$D\$8 C 0 0 \$E\$8 D 0 2000 \$B\$13 Yi 0 1 \$B\$14 Yi 0 1 \$B\$15 Yi 0 1 \$B\$16 Yi 0 1 \$B\$17 Yi 0 1 Constraints Cell Name Cell Value Formula Status Slack \$H\$4 Selection Constraint 0 \$H\$4<=\$J\$4 Binding 0 \$H\$5 Selection Constraint -10000 \$H\$5<=\$J\$5 Not Binding 10000 \$H\$6 Selection Constraint -8000 \$H\$6<=\$J\$6 Not Binding 8000 \$H\$7 Selection Constraint 0 \$H\$7<=\$J\$7 Binding 0 \$H\$8 Selection Constraint -14000 \$H\$8<=\$J\$8 Not Binding 14000 \$B\$9 Total Received A 6000 \$B\$9=\$B\$10 Not Binding 0 \$C\$9 Total Received B 14000 \$C\$9=\$C\$10 Not Binding 0 \$D\$9 Total Received C 8000 \$D\$9=\$D\$10

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.