Suppose you are a cattle producer who is attempting to increase the weight of your cattle...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Suppose you are a cattle producer who is attempting to increase the weight of your cattle by 300 pounds to bring them up to market weight. Since you have already negotiated a fixed price for these cattle once they are at market weight, your objective is to minimize the cost of getting the cattle up to their market weight. Having consulted with an animal nutrition specialist, they advise that you can get these cattle up to market weight by meeting the nutritionist's minimum specified weekly nutritional requirements. These nutritional requirements must meet minimum standards for carbohydrates, proteins, and vitamins. The minimum requirements for each of these nutritional supplements are listed below in Table 1. In order to get the cattle up to weight, you have three types of feeds you can use. Feed 1 consists of a corn diet, feed 2 consists of a mixed grain diet, and feed 3 consists of an alfalfa diet. In order to meet the nutritional requirements of the cattle, you can use any combination of the feeds you would like. The cost of each type of feed and the nutritional contents of each are listed in Table 1. Table 1: Nutritional Contents, Feed Requirements, and Costs Nutritional Component Carbohydrates Proteins Vitamins Cost Per Pound Bag of Corn 9,900 3,300 1,100 $42 Bag of Grain 2,200 8,800 2,200 $36 Bale of Hay MacBook Air 4,400 6,600 6,600 $30 Minimum Weekly Nutritional Requirement 22,000 19,800 16,500 Given the information above please answer the following questions. 1. Please write a mathematical model for this problem.. 2. Can you solve this model using the graphical method? Why or why not? 3. Please develop a spreadsheet model for this problem. Use the guidelines for building good spreadsheets. 4. Please explain which cells are the changing cells, the data cells, and the target cells. 5. What is the cost you get when you examine the solution of 1 bag of corn, 2 bag of grain, and 2 bales of alfalfa? 6. Using solver, please find the cost minimizing solution to the problem, i.e., the number of bales and bags? 7. What is the minimum cost of purchasing the cost minimizing solution? 8. How much money do you ave using the cost minimizing solution over the solution given in question 5? Problem C: Suppose you are a cattle producer who is attempting to increase the weight of your cattle by 300 pounds to bring them up to market weight. Since you have already negotiated a fixed price for these cattle once they are at market weight, your objective is to minimize the cost of getting the cattle up to their market weight. Having consulted with an animal nutrition specialist, they advise that you can get these cattle up to market weight by meeting the nutritionist's minimum specified weekly nutritional requirements. These nutritional requirements must meet minimum standards for carbohydrates, proteins, and vitamins. The minimum requirements for each of these nutritional supplements are listed below in Table 1. In order to get the cattle up to weight, you have three types of feeds you can use. Feed 1 consists of a corn diet, feed 2 consists of a mixed grain diet, and feed 3 consists of an alfalfa diet. In order to meet the nutritional requirements of the cattle, you can use any combination of the feeds you would like. The cost of each type of feed and the nutritional contents of each are listed in Table 1. Table 1: Nutritional Contents, Feed Requirements, and Costs Nutritional Component Carbohydrates Proteins Vitamins Cost Per Pound Bag of Corn 9,900 3,300 1,100 $42 Bag of Grain 2,200 8,800 2,200 $36 Bale of Hay MacBook Air 4,400 6,600 6,600 $30 Minimum Weekly Nutritional Requirement 22,000 19,800 16,500 Given the information above please answer the following questions. 1. Please write a mathematical model for this problem.. 2. Can you solve this model using the graphical method? Why or why not? 3. Please develop a spreadsheet model for this problem. Use the guidelines for building good spreadsheets. 4. Please explain which cells are the changing cells, the data cells, and the target cells. 5. What is the cost you get when you examine the solution of 1 bag of corn, 2 bag of grain, and 2 bales of alfalfa? 6. Using solver, please find the cost minimizing solution to the problem, i.e., the number of bales and bags? 7. What is the minimum cost of purchasing the cost minimizing solution? 8. How much money do you ave using the cost minimizing solution over the solution given in question 5? Problem C:
Expert Answer:
Answer rating: 100% (QA)
I will provide you with the solution to the problem using the given mathematical model spreadsheet model and Solver in Excel 1 Mathematical Model The mathematical model for this problem is a linear pr... View the full answer
Related Book For
Microeconomics An Intuitive Approach with Calculus
ISBN: 978-0538453257
1st edition
Authors: Thomas Nechyba
Posted Date:
Students also viewed these finance questions
-
D Question 2 33.3 pts What entry modes (discuss in details of your understanding) do hospitality companies use when they expand in the global market place? What are the considerations when they make...
-
A sample containing an alkali sulfate is dried, weighed and dissolved in dilute HCl. Barium chloride solution is added in excess to precipitate barium sulfate, and the precipitate is digested in the...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
A line charge density pL of length L lies parallel to an infinite sheet of surface charge density ps. How much work is required to rotate the line charge so that it is vertical?
-
Consider a four-year project with the following information: initial fixed asset investment = $490,000; straight-line depreciation to zero over the four-year life; zero salvage value ; price = $32;...
-
TangoCo is developing its annual financial statements for the current year. The following amounts were correct at December 31, current year: cash, $48,800; investment in stock of PIL Corporation...
-
The following TI-84 Plus display presents the results of a test of the null hypothesis H0: 1 = 0. a. What is the alternate hypothesis? b. What is the value of the test statistic? c. How many degrees...
-
The calculations for a factorial experiment involving four levels of factor A, three levels of factor B, and three replications resulted in the following data: SST = 280, SSA = 26, SSB = 23, SSAB =...
-
Your task is to estimate VaR for an equity portfolio using the "Model-Building" approach. Suppose you have invested in two of the Fama-French factors, namely Mkt-RF and HML. Assume conditionally the...
-
The G. Saussy Manufacturing company is putting out four new electronic components. Each of Saussy's four plants has the capacity to add one more product to its current line of electronic parts. The...
-
Identify the segment of the hospitality industry in which you plan to focus your career (at least for the next few years). Do the organizations/companies in that field have sales departments? If so,...
-
What is the difference between an accounting entity and a legal entity?
-
What is a standard approach to estimate an equity beta?
-
Consider Figure 11.10, which shows the locus of feasible contracts for the population of the nation of Pcoria. The indifference curves are concave, which represents the fact that consumers want full...
-
What are the potential pitfalls of analyzing a transaction like this one based on its IRR or cash multiple?
-
How do we estimate a firms unlevered cost of capital using data from comparable publicly traded firms?
-
Classify each of the following organic reactions. CH3-CH-CH-CH3 CH3-CH-CH=CH + HCI O CH3-C-O-CH3 + CH3-NH2 CH3-C-NH-CH3 + CH3-OH H-C-O-CH CH3-CH-CH-OH + HBr CH3-CH-CH-Br + HO Reset O OH CH3-CH +...
-
Can partitioned join be used for r r.A s? Explain your answer
-
In 2005, the U.S. Congress passed a bill to extend daylight savings time earlier into the spring and later into the fall (beginning in 2007). The change was made as part of an Energy Bill, with some...
-
In Table 14.1, the last column indicates the predicted change in the number of firms within an industry when economic conditions change. A: In two cases, the table makes a definitive prediction,...
-
Every Thanksgiving, my wife and I debate about how we should prepare the turkey we will serve (and will then have left over). My wife likes preparing turkeys the conventional way roasted in the oven...
-
Fill in the Blank. In the finite element method, \(a(n)\) ___________ solution is assumed within each element.
-
The stiffness matrix of a bar element is given by a. \(\frac{E A}{l}\left[\begin{array}{ll}1 & 1 \\ 1 & 1\end{array} ight]\) b. \(\frac{E A}{l}\left[\begin{array}{rr}1 & -1 \\ -1 & 1\end{array}...
-
What is the basis for the derivation of transformation matrices?
Study smarter with the SolutionInn App