Get instant access to this case solution for only $19

New England Feed Supply Case Solution

Solution Id Length Case Author Case Publisher
1530 532 Words (3 Pages) Peter C Bell, Drew Parker Ivey Publishing : 9A98E034
This solution includes: A Word File A Word File and An Excel File An Excel File

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


Save $6 on your purchase


Amount to Pay


Different Requirements? Order a Custom Solution

Calculate the Price

Approximately ~ 1 page(s)

Total Price


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.

Essay Writing Service
whatsapp chat icon

Hi there !

We are here to help. Chat with us on WhatsApp for any queries.

close icon