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?
-
Assume that banks do not hold excess reserves and those households do not hold currency, so the only form of money is checkable deposits. To simplify the analysis, suppose the banking system has...
-
Question 1 (25 marks) The Dolly Company ("DolyCo") produces three types of dolls that they sell to the local market. The three dolls namely Pony, Girly and Noku are manufactured from the same...
-
Cherokee Wood Products Company prepared the following factory overhead cost budget for the Press Department for August of the current year, during which it expected to require 6,000 hours of...
-
A real-estate broker in Washington, DC, purchased 3 two-bedroom houses in a depressed market for a combined cost of $1,000,000. He expects the cleaning and repair costs on each house to average...
-
Please review Colorado Mandatory Reporting Requirements Regarding Children (CRS 19-3-304): 1. Identify one interesting point of the statute. Discuss why the statute is necessary Discuss how it works...
-
What is each shareholder's realized gain or loss? b. What is each shareholder's recognized gain or loss? c. What is each shareholder's basis in their stock? When does their holding period begin? d....
-
B bed Mercury, Incorporated, produces cell phones at its plant in Texas. A year ago, a consumer survey ranked the company's cell phones low in product quality. Shocked by this result. Jorge Gomez,...
-
The identification strategy employed by Goldstein and Udry (2008) to examine the impact of ambiguous and contested land rights on investment and productivity in agriculture in Akwapim, Ghana involves...
-
Investigate the interdisciplinary approaches of advanced resilient urban planning and design, incorporating principles of climate resilience, green infrastructure, and community engagement to address...
-
This laboratory work intends to familiarize you with Unix and C/C++ Standard I/Os. You will code a program that reads a given file using Unix read() system call as well as C/C++ fgetc()/fread()...
-
If you used the adjusted tangible book value method to value AFC, how would you determine the market value of the patent?
-
What is meant by Electronic Banking? How do e-banks work? Discuss the following: Its Importance Its Benefits Rights Responsibilities Fees What are the types of E-banking. Be able to discuss/explain...
-
Find A U B. (Use the roster method to write the set. Enter EMPTY or for the empty set.) A = {-6, -3, -1} B = {-1, 1, 3} AUB=
-
For the following exercises, rewrite the sum as a product of two functions or the product as a sum of two functions. Give your answer in terms of sines and cosines. Then evaluate the final 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...
-
Many choices involve _________ of something to do rather than whether to do something.
-
In acting rationally, people respond to _________.
-
Economists emphasize _________ thinking because the focus is on additional, or _________, choices, which involve the effects of _________ or _________ the current situation.
Study smarter with the SolutionInn App