Question 2 (12 marks) Sher Corp produces and sells digital device accessories. It iscurrently planning its daily
Question:
Question 2 (12 marks)
Sher Corp produces and sells digital device accessories. It iscurrently planning its daily production of
cordless microphones of 2 designs, Mic A and Mic B. The labour costand material used for the production
of each unit of Mic A and Mic B is given in the table below.
Labour cost per hour RM8
Material cost per unit RM6
Labour (hours) to produce Mic A is 0.5 hours
Labour (hours) to produce Mic B is 0.75 hours
Raw materials to produce Mic A is 1 unit
Raw materials to produce Mic B is 1.25 units
Each Mic A and Mic B can sell for RM22 and RM32 respectively.Resources available for its daily
production are 240 labour hours and 500 units of materials.
(a) Set up the linear programming model stated in a worksheet tocompute Sher Corp’s optimal solution and
maximum profit 8 marks
(b) If Sher Corp has to produce at least 120 units of Mic A for itspromotion sales in mid-February, what is
its optimal solution and maximum profit?
ANSWERS IN EXCEL FILE PLS