Get instant access to this case solution for only $19
New England Feed Supply Case Solution
Formulation analyst Jeff Smith of NEFS is considering three animal feed mixes for combined formulae to complete an order for the coming week. He is however faced with the issue of not having enough of one of the ingredients - meat meal. This hinders his ability to be able to produce enough to deliver on order.
Case Analysis for New England Feed Supply
Meat meal is an essential ingredient for all the product mix and therefore Jeff is faced with two options at the moment. He could either amend the mixture formula for the three different feeds keeping to the available quantity of meat meal i.e. 80 tons or he could purchase additional meat meal for a significantly higher price. In order to assist him in choosing either one of the options, a linear programming method using solver has been exercised to calculate the minimum total cost for three different scenarios.
Jeff has used linear programming method to find out the optimal mix formulation for all three products with the given constraint of 80 tons’ meat meal when the entire order requires 168 tons of the meat meal. The excel file attached has been used to calculate the minimum total cost that NEFS is bound to incur with the different feed mixes having applied all constraints.
In the first excel, sheet formulations are given with 168 tons of meat meal used and the combined problem incurs a total cost of $186,887. This is a base case scenario where the price of any additional meat meal i.e. anything above 80 tons is also assumed to cost $339 per ton - the regular weighted average price for contract purchases every month. The solver has not been set to incorporate the higher price that additional tons of meat meal would cost if bought on the spot market.
Get instant access to this case solution for only $19
Get Instant Access to This Case Solution for Only $19
Standard Price
$25
Save $6 on your purchase
-$6
Amount to Pay
$19
Different Requirements? Order a Custom Solution
Calculate the Price
Related Case Solutions
Get More Out of This
Our essay writing services are the best in the world. If you are in search of a professional essay writer, place your order on our website.