chap8_ho3_optimization_solution

chap8_ho3_optimization_solution - 700 $B$3>=0...

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

View Full Document Right Arrow Icon
FAL Computer Production Answer Report Worksheet: [chap8_ho3_optimization_solution.xlsx]Production Mix Report Created: 4/28/2010 3:12:24 PM Target Cell (Max) Cell Name Original Value Final Value $E$19 Profit $0 $1,270,000 Adjustable Cells Cell Name Original Value Final Value $B$2 Discount desktop Quantity 0 0 $B$3 Discount laptop Quantity 0 700 $B$4 Premium desktop Quantity 0 800 $B$5 Premium laptop Quantity 0 0 Constraints Cell Name Cell Value Formula Status Slack $E$8 Total number of hours used 4500 $E$8<=$E$9 Binding 0 $E$10 Number of desktops produced 800 $E$10<=$E$11 Binding 0 $E$12 Number of laptops produced 700 $E$12<=$E$13 Not Binding 200 $E$14 Number of discount computers produced 700 $E$14<=$E$15 Binding 0 $E$16 Number of premium computers produced 800 $E$16<=$E$17 Not Binding 200 $B$2 Discount desktop Quantity 0 $B$2>=0 Binding 0 $B$3 Discount laptop Quantity
Background image of page 1

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

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

Unformatted text preview: 700 $B$3&gt;=0 Not Binding 700 $B$4 Premium desktop Quantity 800 $B$4&gt;=0 Not Binding 800 $B$5 Premium laptop Quantity 0 $B$5&gt;=0 Binding Production Mix Page 2 Quantity Hours Unit Profit Discount desktop 2 $600 Discount laptop 700 3 $800 Premium desktop 800 3 $1,000 Premium laptop 5 $1,300 Constraints Total number of hours used 4500 Labor hours available 4,500 Number of desktops produced 800 Total demand for desktop computers 800 Number of laptops produced 700 Total demand for laptop computers 900 Number of discount computers produced 700 Total demand for discount computers 700 Number of premium computers produced 800 Total demand for premium computers 1,000 Hourly cost of labor $20 Profit $1,270,000...
View Full Document

This note was uploaded on 04/28/2010 for the course IS 6 taught by Professor 6 during the Spring '10 term at Alfred State College.

Page1 / 2

chap8_ho3_optimization_solution - 700 $B$3&amp;amp;gt;=0...

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