Diet formulation is a process by which different feed ingredients are combined to provide the necessary nutrition to animals at different stages of production. A diet should supply all essential nutrients and energy to maintain vital physiological functions of growth, reproduction, and health of animals. The table below shows the nutrient contents of the different available feed ingredients in the area, their market prices, and the minimum nutrient requirements of carp. Determine using Excel Solver the best combination (quantity in kg) of the different feed ingredients to produce 100 kg of feed that can supply all the listed nutrient requirements at the least cost. Specific instructions: a) formulate the mathematical linear programming problem that you are going to solve; b) solve the linear program using Excel Solver (copy the linear program structure that you made in Excel); and c) copy, paste, and interpret all the outputs from the Excel Solver.
Diet formulation is a process by which different feed ingredients are combined to provide the necessary nutrition to animals at different stages of production. A diet should supply all essential nutrients and energy to maintain vital physiological functions of growth, reproduction, and health of animals. The table below shows the nutrient contents of the different available feed ingredients in the area, their market prices, and the minimum nutrient requirements of carp. Determine using Excel Solver the best combination (quantity in kg) of the different feed ingredients to produce 100 kg of feed that can supply all the listed nutrient requirements at the least cost. Specific instructions: a) formulate the mathematical linear programming problem that you are going to solve; b) solve the linear program using Excel Solver (copy the linear program structure that you made in Excel); and c) copy, paste, and interpret all the outputs from the Excel Solver.
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
Please help
Transcribed Image Text:2. Feed Ration
Diet formulation is a process by which different feed ingredients are combined to provide the
necessary nutrition to animals at different stages of production. A diet should supply all
essential nutrients and energy to maintain vital physiological functions of growth,
reproduction, and health of animals. The table below shows the nutrient contents of the
different available feed ingredients in the area, their market prices, and the minimum nutrient
requirements of carp. Determine using Excel Solver the best combination (quantity in kg) of
the different feed ingredients to produce 100 kg of feed that can supply all the listed nutrient
requirements at the least cost. Specific instructions:
a) formulate the mathematical linear programming problem that you are going to solve;
b) solve the linear program using Excel Solver (copy the linear program structure that you
made in Excel); and
c) copy, paste, and interpret all the outputs from the Excel Solver.
Transcribed Image Text:Nutrient contents of different feed ingredients, their markt prices, and mininum mutrient requirements of carp.
NUTRIENT CONTENT OF FEED INGREDIENTS
Groundmut Soybean Rice Wheat
Fish Brewer Til Cake
MINIMUM
cake
cake
bran
Bran
Meal Waste
NUTRIENT
CONTENT
REQUIREMENT
OF THE FEED
Protein content (%)
38
37.03 13.24
13.9
55
22.8
45
38
Lipids (%)
Carbohydrate (%)
Calcium (%)
Phosphorus (%)
9.01
7.1
4.3
4.2
1.8
17.8
12
27.99
28.03 42.65
55.6
46.4
24.5
26
0.25
0.06
0.2
4.5
0.5
0.65
1.5
2.5
0.6
Market price (P/kg)
Sources: Reddy, D.V.Priniciples of Animal Nutrition and Feed Technology: Jhingran V.G. Fish and Fisheries
24
25 34.8
12
10
15
of India: Market Suvey
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 7 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.