{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Parket Sisters

# Parket Sisters - Microsoft Excel 11.0 Answer Report...

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

Microsoft Excel 11.0 Answer Report Worksheet: [Book1]Sheet1 Report Created: 2/11/2008 5:32:00 PM Target Cell (Max) Cell Name Original Value Final Value \$E\$5 Per Unit Profit Total Profit 13 2766.67 Adjustable Cells Cell Name Original Value Final Value \$B\$3 BP 0 700 \$C\$3 MP 1 0 \$D\$3 FP 2 133.33 Constraints Cell Name Cell Value Formula Status Slack \$E\$8 Plastic Total Profit 1000 \$E\$8<=\$G\$8 Binding 0 \$E\$9 Chrome Total Profit 866.67 \$E\$9<=\$G\$9 Not Binding 333.33 \$E\$10 Stainless Steel Total Profit 2000 \$E\$10<=\$G\$10 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: [Book1]Sheet1 Report Created: 2/11/2008 5:32:00 PM Adjustable Cells Final Reduced Objective Allowable Cell Name Value Cost Coefficient Increase \$B\$3 BP 700 0 3 2 \$C\$3 MP 0 -1.38 3 1.38 \$D\$3 FP 133.33 0 5 1.75 Constraints Final Shadow Constraint Allowable Cell Name Value Price R.H. Side Increase \$E\$8 Plastic Total Profit 1000 1.17 1000 200 \$E\$9 Chrome Total Profit 866.67 0 1200 1.00E+030 \$E\$10 Stainless Steel Total Profit 2000 0.8 2000 555.56
Allowable Decrease 0.78 1.00E+030 2 Allowable Decrease 466.67 333.33 333.33

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

View Full Document
Decision Variables BP MP FP Total 700 0 133.33 833.33 Total Profit Per Unit Profit 3 3 5 2766.67
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}