b) The model was solved using excel solver and part of the results is provided in table 1 below. Use it to answer the questions that follow. (1) What is the optimal solution for Telefonika's problem? (ii) Determine the total weekly profit that Telefonika makes? (ii) Which resource constraint(s) are binding? Give a reason. (iv) If Telefonika could raise its budget by GH1,500 per week or increase the weekly hours to 150, which should it choose and why? AN(S marks) c) () Which resource is not fully utilized? Justify your answer. () If Telefonika's profit per unit from Galaxy S4 phones was GHC200 instead of GHC300, how could that affect the optimal solution? How could that affect profit? (ii) What is the minimum profit for Galaxy S3 so that it will attain a positive value in the optimal solution? AN (5 marks) Table 1: Solver Output Variable cells Reduce Allowabl Allowabl Final d Objective e Coefficie Valu Decreas Name Cost nt Increase e 1E+30 290.91 3 0 600 Cell $B$9 $B$10 SB$11 Galaxy S2 Galaxy S3 Galaxy S4 0 400 -320 0 320 900 1E+30 600 6 300 Constrain ts Shado Constrain Allowabl Allowabl Final w t e Valu Decreas Cell Name e Price R.H. Side Increase e budget LHS $F$4 9000 0 12000 1E+30 3000 labour LHS 120 30 120 40 120 SF$5 $F$6 SF$7 Space LHS 9 0 20 1E+30 11 mix LHS 0 180 0 10 7.5 b) The model was solved using excel solver and part of the results is provided in table 1 below. Use it to answer the questions that follow. (1) What is the optimal solution for Telefonika's problem? (ii) Determine the total weekly profit that Telefonika makes? (ii) Which resource constraint(s) are binding? Give a reason. (iv) If Telefonika could raise its budget by GH1,500 per week or increase the weekly hours to 150, which should it choose and why? AN(S marks) c) () Which resource is not fully utilized? Justify your answer. () If Telefonika's profit per unit from Galaxy S4 phones was GHC200 instead of GHC300, how could that affect the optimal solution? How could that affect profit? (ii) What is the minimum profit for Galaxy S3 so that it will attain a positive value in the optimal solution? AN (5 marks) Table 1: Solver Output Variable cells Reduce Allowabl Allowabl Final d Objective e Coefficie Valu Decreas Name Cost nt Increase e 1E+30 290.91 3 0 600 Cell $B$9 $B$10 SB$11 Galaxy S2 Galaxy S3 Galaxy S4 0 400 -320 0 320 900 1E+30 600 6 300 Constrain ts Shado Constrain Allowabl Allowabl Final w t e Valu Decreas Cell Name e Price R.H. Side Increase e budget LHS $F$4 9000 0 12000 1E+30 3000 labour LHS 120 30 120 40 120 SF$5 $F$6 SF$7 Space LHS 9 0 20 1E+30 11 mix LHS 0 180 0 10 7.5