Question: If the marketing department wanted to decrease the price of Whole product by $0.25, would the optimal solution change? you should answer only like this
If the marketing department wanted to decrease the price of Whole product by $0.25, would the optimal solution change?
you should answer only like this
4. Variable Cels Cell Name $C$5 Pounds produced Whole $D$5 Pounds produced Cluster $E$5 Pounds produced Crunch $F$5 Pounds produced Roasted $G$5 Pounds produced Crispy Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 1000 -1 381730769 1.930769231 1.381730769 1E+30 400 -1.08 1.04 1.08 1E430 0 0.509583333 1.146666667 0.509583333 1E+30 190 0 1.325 1E30 0.407666667 150 -2.385 0 2.385 1E+30 Constraints Cell Name $H$16 Huling Used SH$17 Roasting Used SHS18 Coating Used $M$19 Packaging Used SH$20 Labeling Used SH$23 Nuts Used SH$24 Chocolate Used SH$25 Butter Used Final Value 1740 3120 1325 3600 1775 686 068 3806 Shadow Price 0 0 0 1.325 0 0 0 0 Constraint R.H. Side 3600 3600 3000 3600 3000 1100 800 600 Allowable Increase 1E+30 1E30 1E+30 10 1E430 1E.30 1E+30 15.30 Allowable Decrease 1860 480 2275 190 1825 414 132 214 The Molokai Nut Company Molokal Nut Company Pounds produced Min Red Max Needed Whole 1000 1000 99999 Cluster 400 400 500 Crunch Roasted Crispy 0 190 150 0 0 150 150 200 400 Unit Selling Price Unit Variable Cost Unit Profit Margin $5.1000 $3.6000 $3.4000 $4.6250 $4.2000 $3.1692 $2 5600 $2 2533 $3.3000 $2.7020 $1.9308 $1.0400 $1.1467 $1.3250 1.498 Total Profit $2,598.52 Machine Use Hulling Roasting Coating Packaging Labelling Minutes required per pound 1.00 1.00 1.00 1.00 2.00 1.50 1.00 1.75 1.00 0.70 0.20 0.00 2.50 1.60 1.25 1.00 1.00 0.90 0.90 1.00 1.00 1.25 0.30 1.80 1.50 Used 1740 3120 1229 3000 1775 Available 3600 3600 3600 3600 3600 Used Direct Materials Nuts Chocolate Butter Ingredients required per pound 0.40 0.30 0.20 0.40 0.40 0.50 0.80 0.20 0.20 0.20 0.00 0.40 0.60 0.20 0.20 Available 1100 800 600 3116 10. If the marketing department wanted to decrease the price of the whole product by $0.25, would the optimal solution change? (2 points) No, it could decrease by $0.3057 without changing the optimal solution

you should answer only like this Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
