Purchase Solution

Horse Feed Mix Planning

Not what you're looking for?

Ask Custom Question

Question: A boarding stable feeds and houses work horses used to pull tourist-filled carriages through the streets of a historic city. The stable owner wishes to strike a balance between a healthy nutritional standard for the horses and the daily cost of feed. This type of horse must consume exactly 5 pounds of feed per day. The feed mixes available are an oat product, a highly enriched grain, and a mineral product. Each of these mixes contains a predictable amount of five ingredients needed daily to keep the average horse healthy. The table below shows these minimum requirements, units of each nutrient per pound of feed mix, and costs for the three mixes.

FEED MIX

Nutrient Oat/lbs Grain/lbs Mineral/lbs. Needed/per day
A 2.0 3.0 1.0 6
B 0.5 1.0 0.5 2
C 3.0 5.0 6.0 9
D 1.0 1.5 2.0 8
E 0.5 0.5 1.5 5
Cost/lb $ 0.33 $ 0.44 $ 0.57

10-1 Solve the problem using excel solver for the optimal daily mix

Attachments
Purchase this Solution

Solution Summary

A horse stable needs to decide optimal mix of feed. Various nutrients should be supplied to horses on a daily basis. There are three main sources of nutrients: Oats, Grain and Minerals. Each of these provide various nutrients as per the content. The stable needs to decide optimal mix of feed that meets nutrient requirements and minimizes cost of feed. This problem is addressed through Linear Programming and solve process demonstrated through Excel Solver.

Purchase this Solution


Free BrainMass Quizzes
Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Motivation

This tests some key elements of major motivation theories.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Operations Management

This quiz tests a student's knowledge about Operations Management