Toys (1) - Microsoft Excel 14.0 Answer Report Worksheet:...

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

View Full Document Right Arrow Icon
Microsoft Excel 14.0 Answer Report Worksheet: [Toys.xlsx]Purchase Plan Report Created: 11/2/2011 9:16:56 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.187 Seconds. Iterations: 11 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Max) Cell Name Original Value Final Value $J$8 Total Profit $- $241,159.83 Variable Cells Cell Name Original Value Final Value Integer $B$4 Baby Toy Number Purchased 0 34378.0511619 Contin $B$5 Cosmetic Kit Number Purchased 0 0 Contin $B$6 Jewlery Kit Number Purchased 0 5000 Contin $B$7 Ktchinette kit Number Purchased 0 39378.0511619 Contin Constraints Cell Name Cell Value Formula Status Slack $B$12 Budget 1,000,000 Number Purchased $1,000,000.00 $B$12<=$C$12 Binding 0 $B$13 Cosmetic+Kitchenette>=.5(Baby+Jewlery) Number Purchased
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.

This note was uploaded on 11/24/2011 for the course BUS 301 taught by Professor Karake during the Fall '11 term at Maryland.

Page1 / 4

Toys (1) - Microsoft Excel 14.0 Answer Report Worksheet:...

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