SHOW ALL THE WORK AND EVEYTHING IN EXCEL CLEARLY WITH NUMBERS AND LETTERS. SHOW ALL THE FORMULAS AND EVERYTHING STEP BY STEP.

Problem 6: Aldo Lab 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. $18 Test Type 1 Test Type 2 Test Type 3 Test Type 4 Revenue per test $15 $12 $20 Time on Machine1 3 minutes 4 minutes 4 minutes 5 minutes Time on Machine 2 5 minutes 3 minutes 5 minutes 4 minutes 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 anytime 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. C. What is the optimal solution