QUESTION 1/1 1. A workshop produces a gadget with two parts A and 8 plus its package C. A, B and C must be processed through workstations 1, 2 and 3 The accountant analyses cost and sales data and states that each part A and B produced will yield a R3, R2 contribution to profit respectively. Each package C produced will reduce the profit by R1. The production manager specifies the following: A cost of up to R9 is incurred at workstation 1, at least R2 at workstation 2 and at least RS at workstation 3. Each part A produced costs RI on workstation 1, R2 on workstation 2 and R3 on workstation 3. Producing each part B costs R3 on workstation 1, R3 on workstation 2 and R2 is reduced from the cost at workstation 3. Producing each part costs R1 on workstation 1, reduces R1 from the cost at workstation 2 and adds a cost of R1 at workstation 3. Solve with the simplex Method, using Excel Solver. 20] . Generate a sensitivity analysis report What is the maximum amount of profit that the company can get by having some additional hours at workstation 1? 14) [3) lll. iv. What is the lowest number of hours allowable at workstation 2? 13)