MAT500 Assignment 4 Solution

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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
Stateline Shipping and Tansport Company A model for shipping the waste directly from the 6 plants to the 3 waste disposal sites
Background image of page 2
Image of page 3
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 Right Arrow Icon
Ask a homework question - tutors are online