Question: need help!!! need help solving this in Excel 82: 84 (Animal feed mix problem) The Battery Park Stable focds and houses the horses used to



82: 84 (Animal feed mix problem) The Battery Park Stable focds and houses the horses used to pull tourist-filled carriages through the streets of Charleston's historic waterfront area. The stable owner, an ex-racehorse trainer, recognizes the need to set a nutritional diet for the horses in his care. At the same time, he would like to keep the overall daily cost of feed to a minimum. The feed mixes available for the horses' diet are an oat product, a highly enriched grain, and a mineral product. Each of these mixes contains a certain amount of five ingredients needed daily to keep the average horse healthy. The table on this page shows these minimum requirements, units of each ingredient per pound of feed mix, and costs for the three mixes. Data for Problem 8.4 DIET REQUIREMENT OAT PRODUCT (INGREDIENTS) (UNITS/IB) (UNITS/LB) GIRAIN MINERAL MINIMUM DAILY PRODUCT REQUIREMENT (UNITS) (UNITS/LB) (UNITS/LB) \begin{tabular}{lllll} A & 2 & 3 & 1 & 6 \\ B & 0.5 & 1 & 0.5 & 2 \\ C & 3 & 5 & 9 \\ D & 1 & 1.5 & 8 \\ E & 0.5 & 0.5 & 1.5 & 5 \\ \hline \end{tabular} Cost/lb $0.09 $0.14 $0.17 Solution (Written statement of what the decision maker should do) SOLVE THE LP USING THE SOLVER TOOL (re-name to match variable letter chosen) Constraints (rename the labels) LHS RHS Constraint 1 Constraint 2 Constraint 3 Constraint 4 Constraint 5 Constraint 6
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
