Using Excel solver, solve the following
pdf
keyboard_arrow_up
School
Clark University *
*We aren’t endorsed by this school
Course
3820
Subject
Industrial Engineering
Date
Feb 20, 2024
Type
Pages
3
Uploaded by SuperRain2740
Using Excel solver, solve the following
14. The Electrocomp Corporation manufactures two electrical products: air
conditioners and large fans. The assembly process for each is similar in that
both require a certain amount of wiring and drilling. Each air conditioner takes
3 hours of wiring and 2 hours of drilling. Each fan must go through 2 hours of
wiring and 1 hour of drilling. During the next production period, 240 hours of
wiring time are available, and up to 140 hours of drilling time may be used.
Each air conditioner sold yields a profit of $25. Each fan assembled may be
sold for a $15 profit. Formulate and solve this LP production mix situation to
find the best combination of air conditioners and fans that yields the highest
profit. Use the corner point graphical approach.
●
15 Electrocomp’s management realizes that it forgot to include two critical constraints
(see
Problem 7-14
). In particular, management decides that there should be a minimum
number of air conditioners produced in order to fulfill a contract. Also, due to an
oversupply of fans in the preceding period, a limit should be placed on the total number
of fans produced.
a.
If Electrocomp decides that at least 20 air conditioners should be
produced but no more than 80 fans should be produced, what would be
the optimal solution? How much slack or surplus is there for each of the
four constraints?
b.If Electrocomp decides that at least 30 air conditioners should be produced but
no more than 50 fans should be produced, what would be the optimal solution?
How much slack or surplus is there for each of the four constraints at the optimal
solution?
19 MSA Computer Corporation manufactures two models of smartphones, the Alpha 4 and the
Beta 5. The firm employs five technicians, working 160 hours each per month, on its assembly
line. Management insists that full employment (i.e.,
all
160 hours of time) be maintained for each
worker during next month’s operations. It requires 20 labor hours to assemble each Alpha 4
computer and 25 labor hours to assemble each Beta 5 model. MSA wants to see at least 10
Alpha 4s and at least 15 Beta 5s produced during the production period. Alpha 4s generate
$1,200 profit per unit, and Beta 5s yield $1,800 each. Determine the most profitable number of
each model of smartphone to produce during the coming month.
23 Consider this LP formulation:Graphically illustrate the feasible region, and apply the isocost
line procedure to indicate which corner point produces the optimal solution. What is the cost of
this solution?
24.
The stock brokerage firm of Blank, Leibowitz, and Weinberger has analyzed and recommended
two stocks to an investors’ club of college professors. The professors were interested in factors
such as short-term growth, intermediate growth, and dividend rates. The data for each stock are
as follows:
Each member of the club has an investment goal of (1) an appreciation of no less than $720 in
the short term, (2) an appreciation of at least $5,000 in the next three years, and (3) a dividend
income of at least $200 per year. What is the smallest investment that a professor can make to
meet these three goals?
29.
●
29 Graphically analyze the following problem:
1.
What is the optimal solution?
2.
If the first constraint is altered to
�
+3
�
≤8,
does the feasible region or optimal solution
change?
30.
●
29 Graphically analyze the following problem:
Maximize profit=$4
�
+$6
�
subject to
�
+2
�
≤8 hours6
�
+4
�
≤24 hours
1.
What is the optimal solution?
2.
If the first constraint is altered to
�
+3
�
≤8,
does the feasible region or optimal solution
change?
44 Working with chemists at Virginia Tech and George Washington Universities,
landscape contractor Kenneth Golding blended his own fertilizer, called “Golding-Grow.”
It consists of four chemical compounds: C-30, C-92, D-21, and E-11. The cost per pound
for each compound is indicated as follows:
The specifications for Golding-Grow are as follows: (1) E-11 must constitute at least 15%
of the blend; (2) C-92 and C-30 must together constitute at least 45% of the blend; (3)
D-21 and C-92 can together constitute no more than 30% of the blend; and (4)
Golding-Grow is packaged and sold in 50-pound bags.
1.
Formulate an LP problem to determine what blend of the four chemicals will allow
Golding to minimize the cost of a 50-pound bag of the fertilizer.
2.
Solve using a computer to find the best solution.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help