Purchase Solution

Linear programming for Southfork Feed Company

Not what you're looking for?

Ask Custom Question

Using Excel, please solve for the following:

The Southfork Feed Company makes a feed mix from four ingredients-oats, corn, soybeans, and a vitamin supplement. The company has 300 pounds of oats, 400 pounds of corn, 200 pounds of soybeans, and 100 pounds of vitamin supplement available for mix. The company has the following recipe for the mix:

? At least 30% of the mix must be soybeans
? At least 20% of the mix must be the vitamin supplement
? The ratio of corn to oats cannot exceed 2 to 1
? The amount of oats cannot exceed the amount of soybeans
? The mix must be at least 500 pounds

A pound of oats costs $0.50, a pound of corn is $1.20; a pound of soybean is $0.60, and a pound of vitamin supplement is $2.00. The feed company wants to know the number of pounds of each ingredient to put in the mix in order to minimize costs.

Formulate a linear programming model for this program,

Attachments
Purchase this Solution

Solution Summary

Solution contains formulation of a linear programming model.

Solution Preview

Hello

Please see the files attached for all the details. Hope this helps you.

Updated file attached with following ...

Purchase this Solution


Free BrainMass Quizzes
Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Operations Management

This quiz tests a student's knowledge about Operations Management

Basics of corporate finance

These questions will test you on your knowledge of finance.