10.8 Part A, B, C, D, E, F (*not G) 10.8 A regional laboratory that performs nontraditional tests is planning to offer new diagnostic 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 Test Type - I II III IV V Available Resources Profit ($) 8 10 8 7 10 Staff (minutes) 15 15 15 20 25 3,400 Auto Analyzer Equipment (minutes) 20 40 40 60 45 6,000 Materials 12 15 16 14 14 2.700 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? g. How much additional revenue can be expected if the resources are selected in part (1) for expansion without violating the current solution