Question: Using Lingo software or excel solve the following problem. The ABC company produces two types of cattle feed, both consisting totally of wheat and alfalafa.

Using Lingo software or excel solve the following problem.

  1. The ABC company produces two types of cattle feed, both consisting totally of wheat and alfalafa. Feed 1 must contain at least 80% of wheat, and feed 2 must contain at least 60% alfalafa. Feed 1 sells for $1.50/lb and feed 2 sells for $1.30/lb. The company can purchase up to 1,000 lbs of wheat at $0.5/lb and up to 800 lbs of alfalfa at $0.4/lb. Demand for each type of feed is unlimited.
  2. Define the decision variables. Is it a Linear Programming model? Explain.
  3. Formulate the model and solve to maximize the profit. Report the result.
  4. How many lbs of wheat and alfalfa did the company buy?
  5. How does the solution change if each decision variable is restricted to be an integer?

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 General Management Questions!

Q:

USE LINGO TO SOLVE 1 . a . Formulate and solve the base model. Report the results and explain one reduced cost and one shadow price as applicable to the problem. b . Remodel the problem # 1 ( optimal...

Q:

FarmProd produces two types of cattle feed, both consisting totally of wheat and barley. Feed 1 must contain at least 80% wheat, and feed 2 must contain at least 60% barley. Feed 1 sells for EELS per...

Q:

Feedco produces two types of cattle feed, both consisting totally of wheat and alfalfa. Feed 1 must contain at least 80% wheat, and feed 2 must contain at least 60% alfalfa. Feed 1 sells for...

Q:

Feedco produces two types of cattle feed, txth consisting of wheat and alfalfa. Feed 1 must contain at least 80% wheat, and feel 2 must contain at least 60% alfalfa. Feed 1 sells for $1.5 per pound,...

Q:

In the rest of this chapter, we lead the reader through the formulation of several more complicated linear programming models. The most important step in formulating an LP model is the proper choice...

Q:

please show all steps on how it is done in excel displaying variables, objective function and constraints then solved using solver Cattle Feed Company produces two types of cattle feed. Both feeds...

Q:

Linear Programming (Statistics) 1. The Outdoor Furniture Corporation manufactures two products, benches and picnic tables, for use in yards and parks. The firm has two main resources: its carpenters...

Q:

A discrete sequence {xn} can be converted into a continuous representation x(t) = ts X n= (t n ts) xn, where ts is the sampling period. (a) State two characteristic properties of Dirac's function. [2...

Q:

i need the solution for quastion 5 only but i will upload the whole quastions for u to have the full informations ( quastion 5 requiers an excel sheet) stc ksa 7:05 AM 1 0 50% The questions...

Q:

MATHEMATICS FOR MACHINE LEARNING Marc Peter Deisenroth A. Aldo Faisal Cheng Soon Ong Contents Foreword 1 Part I Mathematical Foundations 9 1 Introduction and Motivation 11 1.1 Finding Words for...

Q:

Draw a line perpendicular to the line that contains the points (1, 6) and (6, 4) and passes through the point (-2,8). Graph Layers After you add an object to the graph you can use Graph Layers to...

Q:

4. Try to find the displacement magnification factor at point 1 and the bending moment magnification factor at point 0 of the illustrated system; are they the same as the magnification factor when...

Q:

A western customer who doesn't like a product may tell the sales person no thanks I don't really like that one in Eastern customer who doesn't like the product may tell the sales person I will think...

Q:

help find codifications on the website www.fasb.org Access the FASB Accounting Standards Codification at the FASB website (wmw tasb.org) and select Basic View for free access Determine the specific...