Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You are a horse trainer who raises and trains several horses for global race competitions. You are trying to determine the optimal amount of mix
You are a horse trainer who raises and trains several horses for global race competitions. | ||||||||||
You are trying to determine the optimal amount of mix to give horses daily while minimizing costs. | ||||||||||
Horse require a minimum 220 units of fats, 198 units of carbs, and 165 units of protein daily. | ||||||||||
You are considering three feeds, Feed A, Feed B, and Feed C. | ||||||||||
Each feed containts the following units of each nutritional ingredient in one pound of the feed: | ||||||||||
Units of nutrients in 1 pound of the feed | ||||||||||
Feed A | Feed B | Feed C | ||||||||
Fats | 99 | 22 | 44 | |||||||
Carbs | 33 | 88 | 66 | |||||||
Protein | 11 | 22 | 66 | |||||||
It costs $0.74 for each pound of feed A, $0.62 for each pound of Feed B, and $0.50 for each pound of Feed C. | ||||||||||
A) Write the linear program formulation (e.g., the objective function, decision variables, and constraints | ||||||||||
B) Build the model in excel and solve | ||||||||||
C) Conclude on the answer (interpret the results in a sentence or two. | ||||||||||
YOU MUST solve and answer in excel |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started