Problem 5.6 Use the Simplex Method in Solver

A medical manufacturing facility assembles and packages syringes. There are two (2) packaging machines. There are 3 types of syringes to package A, B, and C. Machine 1 can package 100 of type (A), 50 of type (B), and 25 of type (C) in an hour. Machine 2 is newer and can package 150 of Type (A), 75 of type (B), and 50 of type (C) in an hour. Running machine 1 for an hour cost $230 and running machine (B) for an hour cost $275. To meet customer demand, 1,000 of type (A) syringes, 800 type (B) syringes, and 600 type (C) syringes must be produced daily. Machine 1 can run for 8 hours a day and machine 2 can run for 10 hours a day. The medical device manufacturing company wants to minimize the cost of running both machines. How many hours should each machine run to meet daily demand? Set up and answer this question in Excel using the simplex method in solver. Highlight your final answers so that the hours each machine should run should be light green the total cost to run both machines for a day is in light orange.

X1 - hrs of machine 1 X2 - hrs of machine 2 MIN Z = 230x1 +275X2 S.t. # of syringe A 100 X, + 150 X2 > 1,000 # of syringe B 50 X1 + 75 X2 2 800 # of syringe C 25 X1 + 50 X2 2 600 (Hint: you will need to include constraints for the max time each machine can run in 1 day)