Reference no: EM131033853
Use Solver to create a Sensitivity Report for question 15 at the end of Chapter 3, and answer the following questions:
a. Is the solution degenerate?
b. Is the solution unique?
c. Explain the signs of the reduced costs for each of the decision variables. That is, considering the optimal value of each decision variable, why do the sign of its associated reduced cost make economic sense?
d. Suppose the cost per pound for Feed 3 increased by $3. Would the optimal solution change? Would the optimal objective function value change?
e. If the company could reduce any of the nutrient requirements, which one should it choose and why?
f. If the company could increase any of the nutrient requirements, which one should it choose and why?
1. The Beef-Up Ranch feeds cattle for Midwestern farmers and delivers them to process-ing plants in Topeka, Kansas, and Tulsa, Oklahoma. The ranch must determine the amounts of cattle feed to buy so that various nutritional requirements are met while minimizing total feed costs. The mixture fed to the cows must contain different levels of four key nutrients and can be made by blending three different feeds. The amount of each nutrient (in ounces) found in each pound of feed is summarized as follows: Nutrient (in ounces) per Pound of FeedNutrientFeed 1Feed 2Feed 3 A324B313C102D684 The cost per pound of feeds 1, 2, and 3 are $2.00, $2.50, and $3.00, respectively. The minimum requirement per cow each month is 4 pounds of nutrient A, 5 pounds of nutrient B, 1 pound of nutrient C, and 8 pounds of nutrient D. However, cows should not be fed more than twice the minimum requirement for any nutrient each month. (Note that there are 16 ounces in a pound.) Additionally, the ranch can only obtain 1,500 pounds of each type of feed each month. Because there are usually 100 cows at the Beef-Up Ranch at any given time, this means that no more than 15 pounds of each type of feed can be used per cow each month. a. Formulate a linear programming problem to determine how much of each type of feed a cow should be fed each month. b. Create a spreadsheet model for this problem, and solve it using Solver c. What is the optimal solution?
|
Entirely different organization-still be outstanding leader
: Could an outstanding leader in one organization move into an entirely different organization and still be an outstanding leader? For example, could a great football coach with evident leadership abilities be hired as a CEO of a large company such as ..
|
|
Is the acid strong or weak
: Select the Lewis structure for the ion formed by the acid when it ionizes.
|
|
How would you use active listening in a job interview
: How would you use active listening in a job interview to ‘interview' the interviewer? How will you find out as much as possible about the job and organisation
|
|
Using the competing values framework
: Using the competing values framework as a point of reference, how would you describe the current organizational culture at IDEO? Provide examples to support your conclusions
|
|
Explain signs of reduced costs for each of decision variable
: Is the solution degenerate? Is the solution unique? Explain the signs of the reduced costs for each of the decision variables. That is, considering the optimal value of each decision variable, why do the sign of its associated reduced cost make econo..
|
|
What percentage of the total carbohydrates comes from sugars
: What percentage of the total carbohydrates comes from sugars? What is the most prevalent ingredient in this product other than water?
|
|
Objective function and constraints in simple verbal terms
: Burger Office Equipment produces two types of desks, standard and deluxe. Deluxe desks have oak tops and more-expensive hardware and require additional time for finishing and polishing. Standard desks require 80 board feet of pine and 10 hours of lab..
|
|
Is this a good assumption
: A man says that the oil was reduced at a rate of 20mg/kg each year and in one year will be free of contamination. Is this a good assumption?
|
|
Calculate the control limits for a p control chart
: We have taken 11 samples of 96 bulbs each from a manufacturing line and found the following proportions of defectives: .04, .06, .03, .02, .05, .03, .02, .04, .04, .05, and .06. Calculate the control limits for a p control chart. Show steps.
|