**Please indicate the cell formulas you use**

PROBLEM 3: (26 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 a claim is summarized in the following table. Processing Time in Hours Claim Type 2 3 4 2 3 2 4 Secretary B 5 3 1 3 2 1 5 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 an insurance claim should be processed by each secretary to minimize the total processing time. WANI NUWIN Sensitivity Report Adjustable Cells Final Value 5 0 0 0 Cell $C$13 $D$13 $E$13 $F$13 $C$14 $D$14 SE$14 $F$14 $C$15 $D$15 SE$15 SF$15 Name A1 A2 A3 A4 B1 B2 B3 B4 C1 C2 C3 C4 0 0 0 3 0 4 2 0 Reduced Cost 0 1 1 3 2 3 2 0 1 0 0 4 Objective Coefficient 2 3 2 4 4 5 3 1 3 2 1 5 Allowable Allowable Increase Decrease 1 1E+30 1E+30 1 1E+30 1 1E+30 3 1E+30 2 1E+30 3 1E+30 2 3 1E+30 1E+30 1 1 1E+30 1 1E+30 1E+30 4 Constraints Shadow Price Cell Name $G$13 A constraint $G$14 B constraint $G$15 C constraint $C$16 Claim Type 1 $D$16 Claim Type 2 $E$16 Claim Type 3 $F$16 Claim Type 4 Final Value 10 3 10 5 4 2 3 NN OOO Constraint R.H. Side 40 40 40 5 4 2 3 Allowable Increase 1E+30 1E+30 1E+30 15 15 30 37 Allowable Decrease 30 37 30 5 1 1 2 3 Use the Sensitivity Report to answer the following questions: A) What is the total minimal processing time in hours? (2 mark) 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? (2 mark) C) Assume that secretary C can process a type 4 claim in 6 hours rather than 5 hours. How would this impact the current optimal solution? (2 mark) D) Currently, secretary C is not processing any type 4 claims. Suppose that we force secretary C to process one type 4 claim. What impact would this have on the optimal solution? (4 mark) E) Which constraints are binding? (4 mark) F) Suppose that secretary A has a total of 45 weekly hours. What impact would this have on the current optimal solution? (4 mark) G) What is the total number of unused weekly hours for secretary B? (4 marks) H) Suppose that the number of type 4 claims increases to 4. What impact would this have on the current optimal solution? (4 marks)