lTlS 1P9? Winter 2022 PROBLEM 2: (30 marks) An insurance company has three secretaries, A, B, and C that each is capable of processing four different types of insurance claims. The amount of time required by each secretary to process a particular type of claim is summarized in the following table. Processing Time in Hours Claim Ty}; A Secretary B C On a typical week, the insurance firm has 5 type 1 claims, 4 type 2 claims, 2 type 3 claims, and 3 type 4 claims. Each secretary works a maximum of 40 hours per week. The office manager wants to know how many of each type of insurance claim should be processed by each secretary to minimize the total processing time. Scusiavitykewn Moonwalk\": Final Reduced Oblacllve Alumnus Allow-bk Cell Name Value Cos! Comment increase Deer-an 7771 W" 1E330, 1E+30 _ 1_ , 19307, . > .. Acuoooa'w'm OJONUNu,-.F'a A2 M. A! El 82 3.3 at Cl 02 98 50 Final Shadow Constraint Allowabie Allowable Name Valua Prion R.H. Side Increase Decrease 36513 A constrain 10 u do 1830 so .565\"! wmmi3m4_1:9_ui 7367515 goons!!!\" in do 1E+30 so swlmjmsLS 5 ls . 50$!_CPED_IP_2__L__t 1i 4 ngs Chin rm 3 2 so 3 2 2 5316 Claim Tm 4 3 37 3 Use the Sensitivity Report to answer the following questions: A) What is the total minimal processing time in hours? (3 marks) B) Suppose that secretary A can process a type 2 claim in two hours rather than three hours. How would this impact the current optimal solution? (3 marks) C) Assume that secretary C can process a type 4 claim in 6 hours rather than 5 I115 1P9? Winter 2022 hours. How would this impact the current optimal solution? (3 marks) ru 1-.._.__;u., 222,222,,95