I know how to do question 1,

I only need help with Question 2

Thanks.

Question 1 An electronic component manufacturer has two facilities producing a range of resistors. Facility 1 costs 2000 per day to operate. Facility 2 costs 2500 per day to operate. The production capacities per day are as follows: Resistors 1% tolerance: Resistors 5% tolerance Resistors 10% tolerance Facility 1 400 300 200 Facility 2 300 400 500 Orders 25,000 27,000 30,000 How many days should the manufacturer operate each facility in order to minimise its costs and still produce sufficient resistors to meet its orders? a. Formulate the problem as a linear programming model (hint: let X1 represent the number of days that Facility 1 should operate and X2 represent the number of days that Facility 2 should operate). b. Solve the problem using graphical linear programming (corner point) techniques. 15 marks Question 2 Solve question 1 above using Excel. The graph and minimum cost result should automatically update if any of the constraints or objective function change. 25 marks