10.8 A regional laboratory that performs nontraditional tests is planning to offer new diag- nostic tests for regional hospitals. Current analyzers and staff are capable of performing these tests. The laboratory manager assessed the required staff and analyzer times, as well as the chemical materials required for a bundle of fifty vials for each type of test listed in Table EX 10.8. Table EX 10.8 Available Resources Test Type Profit ($) Staff (minutes) Auto Analyzer Equipment (minutes) 8 15 20 12 L 10 15 40 15 III 8 15 40 16 IV 7 20 60 14 V 10 25 45 14 3,400 6,000 2,700 Materials a. Formulate this as a linear programming problem. b. Solve the problem using Excel Solver. c. For the optimal solution, in terms of profit, which test(s) should be offered? d. What is/are the optimal volume(s)? e. What is the total expected profit from the new tests? f. Which resources should be expanded