A has two machines that analyze various blood samples. Recently, the demand for analyzing blood samples has increased and the lab director is planning to use linear programming to maximize the revenue for the lab. The lab gets blood samples for four types of special blood tests in the evening that must be completed the next day. The revenue from each type of special test and the time (in minutes) it takes on each machine is shown below. Any machine can be used to process any type of the tests. Every day, each machine can be used for 12 hours (720 minutes). If anvtime is left over in any machine, the lab can do routine tests which take 3 minutes pertest on either machine and the lab earns a revenue of $9 per test. There are usually about 200 routine tests waiting to be done which could be done whenever the lab has time. This morning, the lab needs to complete 80 type 1,75 type 2, 40 type 3, and 60 type 4 tests. How many tests of each type should be done on each machine today? (Hint: 10 decision variables) a. Formulate the Integer Linear Programming model for this problem. b. Create a spreadsheet model for this problem and solve it using Solver. A has two machines that analyze various blood samples. Recently, the demand for analyzing blood samples has increased and the lab director is planning to use linear programming to maximize the revenue for the lab. The lab gets blood samples for four types of special blood tests in the evening that must be completed the next day. The revenue from each type of special test and the time (in minutes) it takes on each machine is shown below. Any machine can be used to process any type of the tests. Every day, each machine can be used for 12 hours (720 minutes). If anvtime is left over in any machine, the lab can do routine tests which take 3 minutes pertest on either machine and the lab earns a revenue of $9 per test. There are usually about 200 routine tests waiting to be done which could be done whenever the lab has time. This morning, the lab needs to complete 80 type 1,75 type 2, 40 type 3, and 60 type 4 tests. How many tests of each type should be done on each machine today? (Hint: 10 decision variables) a. Formulate the Integer Linear Programming model for this problem. b. Create a spreadsheet model for this problem and solve it using Solver