All of the other constraints and priorities remained the same. Based on this snippet of the sensitivity report, what should happen during this production run?

William ran the original model in Excel and discovered that he was walking away from significant income. He reformulated the model with a new profit constraint of 16R + 24W + d2+ + d2- = 550.

Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$14 Rotgut 10 0 0 0 0
$C$14 White Lightning 15 0 0 0 0
$D$16 Hours d1+ 0 1 1 1E+30 1
$E$16 Hours d1- 7 0 0 1 0
$D$17 Profit d2+ 30 0 0 0 0
$E$17 Profit d2- 0 0 0 1E+30 0


Answer: William should produce 10 batches of Rotgut and 15 batches of white lightning. The d2+ variable is 30, so the secondary objective of $550 profit will fall short by $30. This could also be confirmed simply by $24 × 15 + $16 × 10 = $520. The d1- variable is 7, meaning that the required time of 65 hours falls short of the 72 hours William thought he had available. This should give him plenty of time to hide the ten pounds of sugar that he has left over, load up The General, and drive to Lubbock.

Business

You might also like to view...

Our culture's current fascination with novels and movies such as the Harry Potter Series and The Lord of the Rings, in which the magician and the patriarch triumph over the sorcerer and the dictator, emphasizes the importance of ________

A) consumption movies B) archetypes C) extroversion overcoming introversion D) the superego overcoming the id

Business

A firm that is based in France designs jewelry and takes custom orders from around the world. They design up to 15 pieces of jewelry in a year and ensure that each design uses distinctive stones and is unique

Such nichemanship is an example of ________ specialist role. A) customer-size B) product C) product-feature D) job-shop E) quality-price

Business

Compare and contrast the use of negative and positive appeals in advertising messages

What will be an ideal response?

Business

The main points of your memo should be included in __________________

a. the first lines of your text b. an index c. a summary of the memo d. any attachments you include

Business