ATCValve Production_Annotated

ATCValve Production_Annotated - Microsoft Excel 11.0 Answer...

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

View Full Document Right Arrow Icon
Microsoft Excel 11.0 Answer Report Worksheet: [ATCValve Production.xls]Valve Production Report Created: 11/15/2004 2:05:09 PM Target Cell (Max) Cell Name Original Value Final Value $J$8 Total Total Profit $3,190.00 $20,984.00 Adjustable Cells Cell Name Original Value Final Value $H$5 Valve 102-45 Number Produced 1.00 117.00 $H$6 Valve 102-46 Number Produced 1.00 28.00 $H$7 Valve 102-47 Number Produced 1.00 90.00 Constraints Cell Name Cell Value Formula Status Slack $C$9 Time Used Casting 500.00 $C$9<=$C$12 Binding 0 $E$9 Time Used Final Assembly 70.50 $E$9<=$C$14 Not Binding 29.5 $D$9 Time Used Machining 348.90 $D$9<=$C$13 Not Binding 151.1 $I$5 Valve 102-45 Percentage 50% $I$5<=$C$18 Not Binding 0 $I$6 Valve 102-46 Percentage 12% $I$6<=$C$18 Not Binding 0.38 $I$7 Valve 102-47 Percentage 38% $I$7<=$C$18 Not Binding 0.12 $I$5 Valve 102-45 Percentage 50% $I$5>=$C$17 Not Binding 40% $I$6 Valve 102-46 Percentage 12% $I$6>=$C$17 Not Binding 2% $I$7 Valve 102-47 Percentage 38% $I$7>=$C$17 Not Binding
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 7

ATCValve Production_Annotated - Microsoft Excel 11.0 Answer...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online