


































































Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
This is my school homeworkThis is my school homework
Typology: Study notes
1 / 74
This page cannot be seen from the preview
Don't miss anything!
Microsoft Excel 16.0 Answer Report Worksheet: [Book1]Sheet Report Created: 5/6/2025 4:43:18 AM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.016 Seconds. Iterations: 3 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance %, Assume NonNegative Objective Cell (Max) Cell Name Original Value Final Value $B$15 Total Profit Small 0 1092 Variable Cells Cell Name Original Value Final Value $B$12 Number to make Small 0 30 $C$12 Number to make Medium 0 29 $D$12 Number to make Large 0 25 Constraints Cell Name Cell Value Formula $B$20 Beads Used/Produced 1542 $B$20<=$D$ $B$21 Thread (inches) Used/Produced 356 $B$21<=$D$ $B$22 Glue (ounces Used/Produced 22 $B$22<=$D$ $B$23 Min Small Production Used/Produced 30 $B$23>=$D$ $B$24 Max Large Production Used/Produced 25 $B$24<=$D$ $B$12 Number to make Small 30 $B$12>= $C$12 Number to make Medium 29 $C$12>= $D$12 Number to make Large 25 $D$12>=
ns are satisfied. nce %, Assume NonNegative Integer Contin Contin Contin Status Slack Not Binding 258 Not Binding 124 Binding 0 Binding 0 Binding 0 Not Binding 30 Not Binding 29 Not Binding 25
Allowable Allowable Increase Decrease 2.4 1E+ 0.5714285714 3 1E+030 0. Allowable Allowable Increase Decrease 1E+030 258 1E+030 124 3.5833333333 7.25 <- since the shadow price is positive, that means the dollar amount th 36.25 30 20.714285714 25
means the dollar amount the company can save is 52 or every additional unit added to the right hand side
Input Data Item Small Medium Large Profit Per Unit 8 13 19 Bead (each) 14 18 24 Thread (inch) 3 4 6 Glue (ounce) 0.2 0.25 0. Decision Variables Small Medium Large Number to make 30 29 25 <-- the cells solver will change Objective Function Total Profit 1092 Constraints Resource Used/Produced Sign Available/Limit Beads 1542 <= 1800 Thread (inches) 356 <= 480 Glue (ounces 22 <= 22 Min Small Productio 30 >= 30 Max Large Productio 25 <= 25
ells solver will change)