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

need help!!! need help solving this in Excel  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 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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!