SOLVE THE FOLLOWING 2 LINEAR PROGRAMMING PROBLEMS USING EXCEL AND THE SOLVER ADD-IN. ONLY PRINT OUT AND SUBMIT SHEET 1 (EXCEL WORKSHEET WITH THE FINAL SOLUTION):
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
40X + 160Y >= 2,400
X, Y >= 0