Question

In: Finance

Formulate the situation as a linear programming problem by identifying the variables, the objective function, and...

Formulate the situation as a linear programming problem by identifying the variables, the objective function, and the constraints. Be sure to state clearly the meaning of each variable. Determine whether a solution exists, and if it does, find it. State your final answer in terms of the original question. A rancher raises goats and llamas on his 400-acre ranch. Each goat needs 2 acres of land and requires $100 of veterinary care per year, and each llama needs 5 acres of land and requires $80 of veterinary care per year. The rancher can afford no more than $13,200 for veterinary care this year. If the expected profit is $84 for each goat and $126 for each llama, how many of each animal should he raise to obtain the greatest possible profit? The rancher should raise___________________- goats and __________________llamas for a maximum profit of $_____________________________ .

Solutions

Expert Solution

Let the number of goats raised be x and the number of llamas raised be y

Objective function is to maximize the profit

Max Z = 84x + 126y

Constraints -

2x + 5y <= 400 .... total acres available

100x + 80y <=13200 .... total veterinary care available

x>=0, y>=0

Let us solve using excel solver

Let us initially assume that Goats = 1 and Llamas = 1

The cells in blue color will be optimized to find the maximum profit in the green cell

Run the solver to get -

Hence, the rancher should raise 100 goats and 40 llamas for a maximum profit of $13440


Related Solutions

Part a (worth 60 pts): Formulate a linear programming model (identify and define decision variables, objective...
Part a (worth 60 pts): Formulate a linear programming model (identify and define decision variables, objective function and constraints) that can be used to determine the amount (in pounds) of Brazilian Natural and Colombian Mild that will maximize the total contribution to profit. For “Part a” you do NOT need to solve this problem using Excel, you just need to do the LP formulation in the standard mathematical format. Part b (bonus worth 20 pts): Solve the LP problem that...
For the given transportation problem, formulate a linear program with objective function and constraints. Solve using...
For the given transportation problem, formulate a linear program with objective function and constraints. Solve using the excel sleeve, provide the optimal transport cost. Imagine that we have three bakeries and three stores. the three stores require 23 dozen, 17 dozen, and 20 dozen loaves of bread, respectively, while the three bakeries can supply 18 dozen, 15 dozen, and 22 dozen loaves, respectively. The unit transportation costs are provided in the table below: Store 1 Store 2 Store 3 Bakery...
Consider the following transportation problem. Formulate this problem as a linear programming model and solve it...
Consider the following transportation problem. Formulate this problem as a linear programming model and solve it using the MS Excel Solver tool. Shipment Costs ($), Supply, and Demand: Destinations Sources 1 2 3 Supply A 6 9 100 130 B 12 3 5 70 C 4 8 11 100 Demand 80 110 60 (4 points) Volume Shipped from Source A __________ (4 points) Volume Shipped from Source B __________ (4 points) Volume Shipped from Source C __________ (3 points) Minimum...
Use the simplex method to solve the linear programming problem. Maximize objective function: Z= 6x1 +...
Use the simplex method to solve the linear programming problem. Maximize objective function: Z= 6x1 + 2x2 Subject to constraints: 3x1 + 2x2 <=9 x1 + 3x2 <= 5 when x1, x2 >=0
Please give one example of REAL LIFE problem that can be formulate as linear programming problem....
Please give one example of REAL LIFE problem that can be formulate as linear programming problem. Make sure you have clear statement about background, the decision variables, objective function and constraints.
What is the difference between the optimal solution to a linear programming problem and the objective...
What is the difference between the optimal solution to a linear programming problem and the objective function value at the optimal solution? Use an example in your explanation
The objective of a linear programming problem is to maximize 1.50A + 1.50B, subject to 3A...
The objective of a linear programming problem is to maximize 1.50A + 1.50B, subject to 3A + 2B ≤ 600, 2A + 4B ≤ 600, 1A + 3B ≤ 420, and A,B ≥ 0. Using Lingo software determine the optimal product mix for this problem? (include Lingo output) Please use excel! Thanks!
Formulate but do not solve the following exercise as a linear programming problem. Kane Manufacturing has...
Formulate but do not solve the following exercise as a linear programming problem. Kane Manufacturing has a division that produces two models of fireplace grates, x units of model A and y units of model B. To produce each model A requires 2 lb of cast iron and 8 min of labor. To produce each model B grate requires 5 lb of cast iron and 5 min of labor. The profit for each model A grate is $2.50, and the...
Formulate the problem as a linear programming model use excel and show your excel work. Thank...
Formulate the problem as a linear programming model use excel and show your excel work. Thank you. To (cost, in 100's) From New york Philadelphia Chicago Boston Supply Tampa $9 $14 $12 $17 200 Miami 11 10 6 10 200 Fresno 12 8 15 7 200 Demand 130 170 100 50
Every linear programming problem involves optimizing a: Select one: a. linear function subject to several linear...
Every linear programming problem involves optimizing a: Select one: a. linear function subject to several linear constraints b. linear regression model subject to several linear constraints c. linear function subject to several non-linear constraints d. non-linear function subject to several linear constraints
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT