Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Classic New Orleans desserts include pralines, pecan pie, and Bananas Foster all three are absolutely essential to eat on any trip to the city.

Classic New Orleans desserts include pralines, pecan pie, and Bananas Foster — all three are absolutely essential to eat on any trip to the city. Chefs may quibble about this ingredient list as there are dozens of variations on each recipe, but these ingredients are common to most formulations. 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 and makes two servings. Bananas Foster is considered a dessert for two and is priced accordingly at $15. 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. Pralines sell for $22.68 per dozen and a pecan pie costs $22.40. The Sensitivity Report from an Excel formulation of this problem is shown below. What is your optimal solution (in order of X, Y, Z, max)

Variable Cells
FinalReducedObjectiveAllowableAllowable
CellNameValueCostCoefficientIncreaseDecrease
$C$20X20022.6822.120.28
$D$20Y0022.40.287.4
$E$20Z0-7.4157.41E+30
Constraints
FinalShadowConstraintAllowableAllowable
CellNameValuePriceR.H. SideIncreaseDecrease
$G$13Pecans LHS200241E+304
$G$14Brown Suger LHS400.284004
$G$15Cane Syrup LHS00121E+3012
$G$16White Suger LHS2022.12201.3333333330
$G$17Vanilla LHS100401E+3030
$G$18Bananas LHS00121E+3012
$G$19Rum LHS200641E+3044

Step by Step Solution

3.34 Rating (151 Votes )

There are 3 Steps involved in it

Step: 1

Variable Cells Final Reduced Object... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Calculus Early Transcendentals

Authors: James Stewart

7th edition

538497904, 978-0538497909

More Books

Students also viewed these Mathematics questions