Classic New Orleans desserts include pralines, pecan pie and Bananas Foster. A recipe for a dozen pralines takes a cup of pecans, two cups of brown sugar, a cup of granulated sugar, a half teaspoon of vanilla and a tablespoon of rum. A pecan pie takes two cups of pecans, a cup of brown sugar, a cup of cane syrup, a cup of granulated sugar, a teaspoon of vanilla, and a tablespoon of rum. A recipe for Bananas Foster requires a cup of pecans, a cup of brown sugar, a cup of granulated sugar, a banana, and a tablespoon of rum. Your pantry has on hand 24 cups of pecans, 40 cups of brown sugar, 12 cups of cane syrup, 20 cups of granulated sugar, 40 teaspoons of vanilla, twelve bananas, and 64 tablespoons of rum. We want to maximize profit. The objective coefficient represents profit for each. Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $D$4 Praline 20 o 22.68 22.12 0.28 $E$4 Pecan Pie 0 0 22.4 0.28 7.4 $F$4 Foster 0 -7.4 15 7.4 1E+30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $G$5 Pecans 20 0 24 1E+30 4 $G$6 Brown Sugar 40 0.28 40 0 4 $G$7 Cane Syrup o 0 12 1E+30 12 $G$8 White Sugar 20 22.12 20 1.333333333 0 $G$9 vanilla 10 0 40 1E+30 30 $G$10 Bananas 0 0 12 1E+30 12 $G$11 Rum 20 0 64 1E+30 44 Find the profit in the chart above. What is the profit for each recipe of a dozen pralines? Classic New Orleans desserts include pralines, pecan pie and Bananas Foster. A recipe for a dozen pralines takes a cup of pecans, two cups of brown sugar, a cup of granulated sugar, a half teaspoon of vanilla and a tablespoon of rum. A pecan pie takes two cups of pecans, a cup of brown sugar, a cup of cane syrup, a cup of granulated sugar, a teaspoon of vanilla, and a tablespoon of rum. A recipe for Bananas Foster requires a cup of pecans, a cup of brown sugar, a cup of granulated sugar, a banana, and a tablespoon of rum. Your pantry has on hand 24 cups of pecans, 40 cups of brown sugar, 12 cups of cane syrup, 20 cups of granulated sugar, 40 teaspoons of vanilla, twelve bananas, and 64 tablespoons of rum. We want to maximize profit. The objective coefficient represents profit for each. Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $D$4 Praline 20 o 22.68 22.12 0.28 $E$4 Pecan Pie 0 0 22.4 0.28 7.4 $F$4 Foster 0 -7.4 15 7.4 1E+30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $G$5 Pecans 20 0 24 1E+30 4 $G$6 Brown Sugar 40 0.28 40 0 4 $G$7 Cane Syrup o 0 12 1E+30 12 $G$8 White Sugar 20 22.12 20 1.333333333 0 $G$9 vanilla 10 0 40 1E+30 30 $G$10 Bananas 0 0 12 1E+30 12 $G$11 Rum 20 0 64 1E+30 44 Find the profit in the chart above. What is the profit for each recipe of a dozen pralines
