Chp8_-_Solver_Scenario

Chp8_-_Solver_Scenario - Perfected Packaging Packaging...

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

View Full Document Right Arrow Icon
Perfected Packaging Packaging Order Optimization Machine 1 Machine 2 Machine 3 Bags per Minute on Machine 9 7 6 Cost per Minute of Machine $2.90 $2.50 $1.94 Optimal Consumer-Sized on Machine 200 0 1200 Optimal Retail-Sized on Machine 1300 300 Optimal Industrial-Sized on Machine 300 Total Minutes for Order 200.00 42.86 200.00 Total Cost for Order $580.00 $107.14 $388.00 Order Constraints Total Minutes for Order 200 Consumer-Sized Needed for Order 1400 Retail-Sized Needed for Order 1600 Industrial-Sized Needed for Order 300
Background image of page 1

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

View Full DocumentRight Arrow Icon
1400 1600 300 $1,075.14 Total Bags for Order
Background image of page 2
Microsoft Excel 12.0 Answer Report Worksheet: [Perfected Packaging2.xlsx]Order Optimization Report Created: 11/17/2008 8:18:29 AM Target Cell (Min) Cell Name Original Value Final Value $E$13 Total_Cost $348.00 $757.94 Adjustable Cells Cell Name Original Value Final Value $B$8 Optimal_Consumer_Machine1 1500 288 $B$9 Optimal_Retail_Machine1 -515 697 $B$10 Optimal_Industrial_Machine1
Background image of page 3

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

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

This note was uploaded on 03/02/2010 for the course COSC COSC1702 taught by Professor Lajoie during the Winter '10 term at Algoma University.

Page1 / 6

Chp8_-_Solver_Scenario - Perfected Packaging Packaging...

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

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