{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Toys (1)

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

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

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 19689.02558094 \$B\$13>=\$C\$13 Not Binding 19689.02558 \$B\$14 C+K<=B+J Number Purchased 0 \$B\$14<=\$C\$14 Binding 0 \$B\$15

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}