MAT500 Assignment 4 Solution

# MAT500 Assignment 4 Solution - Microsoft Excel 12.0 Answer...

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

Microsoft Excel 12.0 Answer Report Worksheet: [10 Assigment 4 solution-1.xls]Sheet1 Report Created: 8/26/2011 3:32:06 PM Target Cell (Min) Cell Name Original Value Final Value \$C\$13 Cost = Whitewater 0 2822 Adjustable Cells Cell Name Original Value Final Value \$C\$5 Kingsport Whitewater 0 35 \$D\$5 Kingsport Los Canos 0 0 \$E\$5 Kingsport Duras 0 0 \$C\$6 Danville Whitewater 0 0 \$D\$6 Danville Los Canos 0 0 \$E\$6 Danville Duras 0 26 \$C\$7 Macon Whitewater 0 0 \$D\$7 Macon Los Canos 0 0 \$E\$7 Macon Duras 0 42 \$C\$8 Selma Whitewater 0 1 \$D\$8 Selma Los Canos 0 52 \$E\$8 Selma Duras 0 0 \$C\$9 Columbus Whitewater 0 29 \$D\$9 Columbus Los Canos 0 0 \$E\$9 Columbus Duras 0 0 \$C\$10 Allentown Whitewater 0 0 \$D\$10 Allentown Los Canos 0 28 \$E\$10 Allentown Duras 0 10 Constraints Cell Name Cell Value Formula Status Slack \$C\$12 Shipped Whitewater 65 \$C\$12<=\$C\$11 Binding 0 \$D\$12 Shipped Los Canos 80 \$D\$12<=\$D\$11 Binding 0 \$E\$12 Shipped Duras 78 \$E\$12<=\$E\$11 Not Binding 27 \$G\$5 Kingsport Shipped 35 \$G\$5=\$F\$5 Not Binding 0 \$G\$6 Danville Shipped 26 \$G\$6=\$F\$6 Not Binding 0 \$G\$7 Macon Shipped 42 \$G\$7=\$F\$7 Not Binding 0 \$G\$8 Selma Shipped 53 \$G\$8=\$F\$8 Not Binding 0 \$G\$9 Columbus Shipped 29 \$G\$9=\$F\$9 Not Binding 0 \$G\$10 Allentown Shipped 38 \$G\$10=\$F\$10 Not Binding 0

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

View Full Document
Stateline Shipping and Tansport Company A model for shipping the waste directly from the 6 plants to the 3 waste disposal sites
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 11/15/2011 for the course ACCOUNTING MAT540 taught by Professor Georgemaruschock during the Summer '11 term at Strayer.

### Page1 / 3

MAT500 Assignment 4 Solution - Microsoft Excel 12.0 Answer...

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

View Full Document
Ask a homework question - tutors are online