Instructions
Complete and Solve the following Models:
Apply proper formatted headings to show optimum solution, answer, sensitivity
analysis on excel sheets.
A. Solve the following LP Model Graphically:
Maximize Z = 4x1+5x2
Subject to x1+2x2<= 10
6x1+6x2<= 36
x1<= 4 and x1,x2>=0
B. Solve the following LP Model using Solver
1.A Product Mix Example
2 A Diet Example
3 An Investment Example
4 A Marketing Example
5 A Transportation Example
6 A Blend Example
7 A Multiperiod Scheduling Example
8 A Data Envelopment Analysis Example
C. Solve the following Mixed Integer Model
Maximize Z = $9000x1+1500x2+1000x3
Subject to $50000x1+12000x2+8000x3 <= $250,000
x1<= 4 condominiums
x2 <= 15 acres
x3 <= 20 bonds
x2 >= 0 and x1,x3>= 0 and integer
D. Solve Transshipment and Assignment Model
1. World Foods, Inc., imports food products such as meats, cheese, and pastries to
the United States from warehouses at ports in Hamburg, Marseilles, and Liverpool.
Ships from these ports deliver the products to Norfolk, New York, and Savannah,
where they are stored in company warehouses before being shipped to distribution
centers in Dallas, St. Louis, and Chicago. The products are then distributed to
specialty food stores and sold through catalogs. The shipping costs ($/1,000 lb.)
from the European ports to the U.S. cities and the available supplies (1,000 lb.) at
the European ports are provided in the following table:
U.S. City
European Port 4. Norfolk 5. New York 6. Savannah Supply
1.Hamburg $420 $390 $610 55
2. Marseilles 510 590 470 78
3. Liverpool 450 360 480 37
The transportation costs ($/1,000 lb.) from each U.S. city of the three distribution
centers and the demands (1,000 lb.) at the distribution centers are as follows:
Distribution Center
Warehouse 7. Dallas 8. St. Louis 9. Chicago
4. Norfolk $ 75 $ 63 $81
5. New York 125 110 95
6. Savannah 68 82 95
Demand 60 45 50
Determine the optimal shipments between the European ports and the warehouses
and the distribution centers to minimize total transportation costs.
2. An electronics firm produces electronic components, which it supplies to various
electrical manufacturers. Quality control records indicate that different employees
produce different numbers of defective items. The average number of defects
produced by each employee for each of six components is given in the following
table:
Component
Employee A B C D E F
1 30 24 16 26 30 22
2 22 28 14 30 20 13
3 18 16 25 14 12 22
4 14 22 18 23 21 30
5 25 18 14 16 16 28
6 32 14 10 14 18 20
Determine the optimal assignment that will minimize the total average number of
defects produced by the firm per month.
Due on Mar 4, 2024 11:59 PM
