\f\fProduced Ordered Profit Contribution Per Pound Regular Mix Deluxe Mix 17500 10625 10,000 3,000 1.65 2.00 Almonds Brazil Nuts Filberts Pecans Walnuts Total Profit 0.15 0.25 0.25 0.10 0.25 $ 24,925.00 0.20 0.20 0.20 0.20 0.20 Holiday Mix 5000 5,000 2.25 0.25 0.15 0.15 0.25 0.20 Nuts Needed 6,000 7,250 7,250 5,125 7,500 Sign <= <= <= <= <= Purchased 6,000 7,500 7,500 6,000 7,500 Surplus 250 250 875 - Cost per Shipment 7,500 7,125 6,750 7,200 7,875 You created this PDF from an application that is not licensed to print to novaPDF printer (http://www.novapdf.com) You created this PDF from an application that is not licensed to print to novaPDF printer (http://www.novapdf.com) You created this PDF from an application that is not licensed to print to novaPDF printer (http://www.novapdf.com) You created this PDF from an application that is not licensed to print to novaPDF printer (http://www.novapdf.com) You created this PDF from an application that is not licensed to print to novaPDF printer (http://www.novapdf.com) Max 1.65R + 2.00D + 2.25H - 36450 s.t. R > 10000 Regular Mix ordered > 3000 Deluxe Mix ordered H > 5000 Holiday Mix ordered D .15R + .20D + .25H < 6000 Almonds available .25R + .20D + .15H < 7500 Brazil Nuts available .25R + .20D + .15H < 7500 Filberts available .25R + .20D + .20H < 7500 Pecans available .10R + .20D + .25H < 6000 Walnuts available R, D, H > 0 Here, R = Regular Mix D = Deluxe Mix H = Holiday Mix Produced Ordered Profit Contribution Per Pound Regular Mix Deluxe Mix 17500 10625 10,000 3,000 1.65 2.00 Almonds Brazil Nuts Filberts Pecans Walnuts Total Profit 0.15 0.25 0.25 0.10 0.25 $ 24,925.00 0.20 0.20 0.20 0.20 0.20 Holiday Mix 5000 5,000 2.25 0.25 0.15 0.15 0.25 0.20 Nuts Needed 6,000 7,250 7,250 5,125 7,500 Sign <= <= <= <= <= Purchased 6,000 7,500 7,500 6,000 7,500 Surplus 250 250 875 - Cost per Shipment 7,500 7,125 6,750 7,200 7,875 Microsoft Excel 14.0 Answer Report Worksheet: [Solution.xlsx]Sheet1 Report Created: 9/16/2016 2:56:02 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.015 Seconds. Iterations: 3 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 $D$16 Total Profit Regular Mix Original Value $ 24,925.00 Final Value ### Variable Cells Cell Name $D$6 Produced Regular Mix $E$6 Produced Deluxe Mix $F$6 Produced Holiday Mix Original Value 17500 10625 5000 Final Value Integer 17500 Contin 10625 Contin 5000 Contin Constraints Cell Name $G$10 Almonds Nuts Needed $G$11 Brazil Nuts Nuts Needed $G$12 Filberts Nuts Needed $G$13 Pecans Nuts Needed $G$14 Walnuts Nuts Needed $D$6 Produced Regular Mix $E$6 Produced Deluxe Mix $F$6 Produced Holiday Mix Cell Value Formula 6,000 $G$10<=$I$10 7,250 $G$11<=$I$11 7,250 $G$12<=$I$12 5,125 $G$13<=$I$13 7,500 $G$14<=$I$14 17500 $D$6>=$D$7 10625 $E$6>=$E$7 5000 $F$6>=$F$7 Status Binding Not Binding Not Binding Not Binding Binding Not Binding Not Binding Binding Slack 0 250 250 875 0 7500 7625 0 onNegative Microsoft Excel 14.0 Sensitivity Report Worksheet: [Solution.xlsx]Sheet1 Report Created: 9/16/2016 2:56:02 PM Variable Cells Cell Name $D$6 Produced Regular Mix $E$6 Produced Deluxe Mix $F$6 Produced Holiday Mix Final Reduced Objective Value Cost Coefficient 17500 0 1.65 10625 0 2 5000 -0.175 2.25 Allowable Allowable Increase Decrease 0.35 0.15 0.2 0.1076923077 0.175 1.00000E+030 Constraints Cell $G$10 $G$11 $G$12 $G$13 $G$14 Name Almonds Nuts Needed Brazil Nuts Nuts Needed Filberts Nuts Needed Pecans Nuts Needed Walnuts Nuts Needed Final Shadow Constraint Allowable Value Price R.H. Side Increase 6000 8.5 6000 583.33333333 7250 0 7500 1.00000E+030 7250 0 7500 1.00000E+030 5125 0 6000 1.00000E+030 7500 1.5 7500 250 Allowable Decrease 610 250 250 875 750 Microsoft Excel 14.0 Limits Report Worksheet: [Solution.xlsx]Sheet1 Report Created: 9/16/2016 2:56:02 PM Objective Cell Name $D$16 Total Profit Regular Mix Variable Cell Name $D$6 Produced Regular Mix $E$6 Produced Deluxe Mix $F$6 Produced Holiday Mix Value $ 24,925.00 Value 17500 10625 5000 Lower Objective Limit Result 10000 12550 3000 9675 5000 24925 Upper Objective Limit Result 17500 24925 10625 24925 5000 24925 \f\f\fProduced Ordered Profit Contribution Per Pound Regular Mix Deluxe Mix 17500 10625 10,000 3,000 1.65 2.00 Almonds Brazil Nuts Filberts Pecans Walnuts Total Profit 0.15 0.25 0.25 0.10 0.25 $ 24,925.00 0.20 0.20 0.20 0.20 0.20 Holiday Mix 5000 5,000 2.25 0.25 0.15 0.15 0.25 0.20 Nuts Needed 6,000 7,250 7,250 5,125 7,500 Sign <= <= <= <= <= Purchased 6,000 7,500 7,500 6,000 7,500 Surplus 250 250 875 - Cost per Shipment 7,500 7,125 6,750 7,200 7,875 You created this PDF from an application that is not licensed to print to novaPDF printer (http://www.novapdf.com) You created this PDF from an application that is not licensed to print to novaPDF printer (http://www.novapdf.com) You created this PDF from an application that is not licensed to print to novaPDF printer (http://www.novapdf.com) You created this PDF from an application that is not licensed to print to novaPDF printer (http://www.novapdf.com) You created this PDF from an application that is not licensed to print to novaPDF printer (http://www.novapdf.com) Max 1.65R + 2.00D + 2.25H - 36450 s.t. R > 10000 Regular Mix ordered > 3000 Deluxe Mix ordered H > 5000 Holiday Mix ordered D .15R + .20D + .25H < 6000 Almonds available .25R + .20D + .15H < 7500 Brazil Nuts available .25R + .20D + .15H < 7500 Filberts available .25R + .20D + .20H < 7500 Pecans available .10R + .20D + .25H < 6000 Walnuts available R, D, H > 0 Here, R = Regular Mix D = Deluxe Mix H = Holiday Mix Produced Ordered Profit Contribution Per Pound Regular Mix Deluxe Mix 17500 10625 10,000 3,000 1.65 2.00 Almonds Brazil Nuts Filberts Pecans Walnuts Total Profit 0.15 0.25 0.25 0.10 0.25 $ 24,925.00 0.20 0.20 0.20 0.20 0.20 Holiday Mix 5000 5,000 2.25 0.25 0.15 0.15 0.25 0.20 Nuts Needed 6,000 7,250 7,250 5,125 7,500 Sign <= <= <= <= <= Purchased 6,000 7,500 7,500 6,000 7,500 Surplus 250 250 875 - Cost per Shipment 7,500 7,125 6,750 7,200 7,875 Microsoft Excel 14.0 Answer Report Worksheet: [Solution.xlsx]Sheet1 Report Created: 9/16/2016 2:56:02 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.015 Seconds. Iterations: 3 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 $D$16 Total Profit Regular Mix Original Value $ 24,925.00 Final Value ### Variable Cells Cell Name $D$6 Produced Regular Mix $E$6 Produced Deluxe Mix $F$6 Produced Holiday Mix Original Value 17500 10625 5000 Final Value Integer 17500 Contin 10625 Contin 5000 Contin Constraints Cell Name $G$10 Almonds Nuts Needed $G$11 Brazil Nuts Nuts Needed $G$12 Filberts Nuts Needed $G$13 Pecans Nuts Needed $G$14 Walnuts Nuts Needed $D$6 Produced Regular Mix $E$6 Produced Deluxe Mix $F$6 Produced Holiday Mix Cell Value Formula 6,000 $G$10<=$I$10 7,250 $G$11<=$I$11 7,250 $G$12<=$I$12 5,125 $G$13<=$I$13 7,500 $G$14<=$I$14 17500 $D$6>=$D$7 10625 $E$6>=$E$7 5000 $F$6>=$F$7 Status Binding Not Binding Not Binding Not Binding Binding Not Binding Not Binding Binding Slack 0 250 250 875 0 7500 7625 0 onNegative Microsoft Excel 14.0 Sensitivity Report Worksheet: [Solution.xlsx]Sheet1 Report Created: 9/16/2016 2:56:02 PM Variable Cells Cell Name $D$6 Produced Regular Mix $E$6 Produced Deluxe Mix $F$6 Produced Holiday Mix Final Reduced Objective Value Cost Coefficient 17500 0 1.65 10625 0 2 5000 -0.175 2.25 Allowable Allowable Increase Decrease 0.35 0.15 0.2 0.1076923077 0.175 1.00000E+030 Constraints Cell $G$10 $G$11 $G$12 $G$13 $G$14 Name Almonds Nuts Needed Brazil Nuts Nuts Needed Filberts Nuts Needed Pecans Nuts Needed Walnuts Nuts Needed Final Shadow Constraint Allowable Value Price R.H. Side Increase 6000 8.5 6000 583.33333333 7250 0 7500 1.00000E+030 7250 0 7500 1.00000E+030 5125 0 6000 1.00000E+030 7500 1.5 7500 250 Allowable Decrease 610 250 250 875 750 Microsoft Excel 14.0 Limits Report Worksheet: [Solution.xlsx]Sheet1 Report Created: 9/16/2016 2:56:02 PM Objective Cell Name $D$16 Total Profit Regular Mix Variable Cell Name $D$6 Produced Regular Mix $E$6 Produced Deluxe Mix $F$6 Produced Holiday Mix Value $ 24,925.00 Value 17500 10625 5000 Lower Objective Limit Result 10000 12550 3000 9675 5000 24925 Upper Objective Limit Result 17500 24925 10625 24925 5000 24925 \f\f