18 Advanced 135 Columns Fill xv fx Duplicates Validation What-11 Analysis Group Ungroup Subtotal B F G H 1 K L M N O P R 3 4 5 6 7 8 9 10 (4.5 marks) The Kartick Company is trying to determine how much of each of two products to produce over the coming planning period. There are three departments, A, B, and C, with limited labor hours available in each department. The manager runs the excel solver and following table is the sensitivity report. Could you please help manager to answer following questions? (1) How much of each of two products they should produce? (0.5 mark) (ii) What is their optimum solution? (1 mark) (iii) What would be the effect on the optimal solution if the labor availability of Department B increased from 32 to 40? Explain (1 mark) (iv) What would be the effect on the optimal solution if the labor availability of Department C decreased from 50 to 10? Explain (1 mark) (v) What would be the effect on the optimal solution if the labor availability of Department A increased from 100 to 110? Explain (1 mark) 12 3 5 6 7 m Variable Cells Cell $B$3 SCS3 Cost Final Value 80 Name X1 Product 1) X2 ( Product 2) Reduced Objective Allowable Allowable Coefficient Increase Decrease 0 33 47 27 0 24 99 14 68 Constraints Cell SD$6 SD$7 SD$8 Name Labor availability in Department A Labor availability in Department B Labor availability in Department C Final Value 100 32 50 Shadow Constraint Allowable Allowable Price R.H. Side Increase Decrease 29 100 14 73 0 36 1.00E+30 4 27 50 68 35 +