Question
In: Operations Management
Solve the following LP problem using the Solver in MS Excel. A farmer wants to customize...
Solve the following LP problem using the Solver in MS Excel.
A farmer wants to customize his fertilizer for his current crop. He can buy plant food mix A and plant food mix B. Each cubic yard of food A contains 20 pounds of phosphoric acid, 30 pounds of nitrogen and 5 pounds of potash. Each cubic yard of food B contains 10 pounds of phosphoric acid, 30 pounds of nitrogen and 10 pounds of potash. He requires a minimum of 460 pounds of phosphoric acid, 960 pounds of nitrogen and 220 pounds of potash. If food A costs $30 per cubic yard and food B costs $35 per cubic yard, how many cubic yards of each food should the farmer blend to meet the minimum chemical requirements at a minimal cost? What is this cost?
Solutions
Expert Solution
Below is the LP Formulation and Excel solver solution -
LP Formulation
Minimize Costs Z = 30A+35B
s.t. constraints -
20A+10B >=460 ---> Phosporic acid
30A+30B >=960 ---> Nitrogen
5A+10B >=220 ---> Potash
A,B >= 0
Solver solution
Minimum cost = 1020 $
A = 20 cubic yards, B = 12 cubic yards
keosha answered 1 year agoRelated Solutions
Solve the following LP problem using the Solver in MS Excel. A municipality has two incinerators...
Solve the following LP problem using the Solver in MS
Excel.
A municipality has two incinerators for burning trash .
Incinerator A costs $3 .80 per ton of trash to operate, and has a
capacity of 28 tons per day . Incinerator B costs $4 .25 per ton to
operate, and has a capacity of 30 tons per day . The municipality
produces over 100 tons of trash per day, and all trash not burned
in the incinerators must be...
2. Solve the following LP problem graphically; confirm your results using Solver in MS Excel. Maximize...
2. Solve the following LP problem graphically; confirm your
results using Solver in MS Excel.
Maximize profit = 20x1 + 10x2
Subject to: 5x1 + 4x2 ≤ 250
2x1 + 5x2 ≤ 150
x1, x2 ≥ 0
How to solve using Excel Solver: This is an assignment problem with 10 applicants and 5...
How to solve using
Excel Solver: This is an assignment problem with 10 applicants and
5 positions. Determine the optimal assignments that Brenda Last
should make. Use the data to determine the optimal assignments, but
do not complete questions in the last two paragraphs of the
text
Formulate a linear programming model for this problem.
List the objective
function (minimize or maximize) and all model constraints.
Solve problem using MS Excel’s Solver
Hint: Use the
“integer” constraint
Highlight the
"winning"...
Solve the following problem with Excel Solver: (Leave no cells blank - be certain to enter...
Solve the following problem with Excel Solver: (Leave no
cells blank - be certain to enter "0" wherever required. Do not
round intermediate calculations. Round your answers to 2 decimal
places.)
Maximize Z
=
8X + 17Y.
8X + 14Y
≤
143
Resource A
1X + 2Y
≤
75
Resource B
3Y
≤
12
Resource C
Decision for X
Decision for Y
Total profit
$
Resources
Used
Resource A
Resource B
Resource C...
1. Solve the following integer optimization model by using Excel Solver: Maximize Z = 5x1 +...
1. Solve the following integer optimization model by using Excel
Solver:
Maximize Z = 5x1 + 6x2
Subject to
3x1 + 4x2 < 10
4x1 + 2x2 < 15
x1, x2 > 0 and
integer
Please show how to use the excel solver as well as steps. :)
SOLVE THE FOLLOWING 2 LINEAR PROGRAMMING PROBLEMS USING EXCEL AND THE SOLVER ADD-IN. PLEASE SHOW ME...
SOLVE THE FOLLOWING 2 LINEAR PROGRAMMING PROBLEMS USING
EXCEL AND THE SOLVER ADD-IN. PLEASE SHOW ME ALL THE EXCEL
STEPS.
PROBLEM #1: Maximize Z = $60X +
$90Y
Subject to: 60X + 30Y >= 1,500
100X + 100Y <= 6,000
Y >= 30
X, Y >= 0
PROBLEM #2: Minimize Z = $3,000X + $1,000Y
Subject to: 60X + 20Y >=
1,200
10X + 10Y >=
400
...
Solve the following linear programming problem using Solver. Be sure to write in your optimal solution...
Solve the following linear programming problem using Solver. Be
sure to write in your optimal solution below the problem. Max Z =
20X1 + 30X2 + 25X3 + 32X4 s.t. 4X1 + 8X2 + 5X3 + 6X4 ≤ 40 X1 + X2 ≥
3 (X1 + X2) ≤ (X3 + X4) ?1 ?2 ≥ 3 2 X1 = __________ X2 =
___________ X3 = ___________ X4 = ___________ Z = ____________
Solve the following linear programming problem using Solver. Be sure to write in your optimal solution...
Solve the following linear programming problem using Solver. Be
sure to write in your optimal solution below the problem.
Max Z = 20X1 + 30X2 + 25X3 + 32X4
s.t. 4X1 + 8X2 + 5X3 + 6X4 ≤ 40
X1 + X2 ≥ 3
(X1 + X2) ≤ (X3 + X4)
x1/x2 ≥ 3/2
X1 = __________X2 = ___________X3 = ___________X4 = ___________Z
= ____________
Set up and solve an LP model using Excel to crash this project to 24 days....
Set up and solve an LP model using Excel to crash this project
to 24 days. What is the total crashing cost?
ACTIVITY
IMMEDIATE PREDECESSORS
STANDARD TIME (Days)
STANDARD COST
CRASH TIME (Days)
CRASH COST
A
--
7
$2,000
5
$3,500
B
A
10
$3,000
8
$4,700
C
A
8
$3,400
7
$3,700
D
C
6
$1,600
4
$2,600
E
C
7
$1,900
4
$4,000
F
D,E
5
$1,200
3
$2,800
G
B,C
11
$8,200
8
$10,900
H
F,G
4...
Can you provide solution in the Excel using Solver for the below problem ? On Monday...
Can you provide solution in the Excel using Solver for the below
problem ?
On Monday morning, you have $3000 in cash on hand. For the next
seven days, the following cash requirements must be met: Monday,
$5000; Tuesday, $6000; Wednesday, $9000; Thursday, $2000; Friday,
$7000; Saturday, $2000; Sunday, $3000. At the beginning of each
day, you must decide how much money (if any) to withdraw from the
bank. It costs $10 to make a withdrawal of any size. You...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- A researcher wishes to estimate the proportion of adults who have high-speed Internet access. What size...
- (1) What are some pitfalls in writing an RFP? What information should be provided as part...
- You are creating an enhanced entity relationship model for a campus information system. A junior team...
- 1.-Evolving into Multinationalism. As a firm evolves from purely domestic into a true multinational enterprise, it...
- A guidance counselor claims that high school students in a college preparation program have higher ACT...
- As a supervisor of a production department, you must decide the daily production totals of a...
- how can a virus encode a protein larger than the size of its genome?
ADVERTISEMENT