# Qualitative Characteristic Essay

291 Words2 Pages
Personal Assignment 1 Instructions * Answer ALL. Total marks : 30 marks. ( 10% ) * All work must be done in Excel. * On the assignment cover, your name and student ID. * Submit hardcopy of work by Monday 2nd April 2012 at the beginning of lecture. Question 1 ( 10 marks ) Three jobs have to be assigned to three people. The table shows the work hours for each employee in the respective job. Employee | Job X | Job Y | Job Z | A | 16 | 20 | 13 | B | 25 | 18 | 16 | C | 17 | 22 | 24 | (a) Find the optimal assignment that will minimize the total working hours. ( 9 marks ) (b) Calculate the total working hours. ( 1 mark ) Question 2 ( 10 marks ) Complete the following transportation table for initial solution, using | To | D | E | F | Supply | From | | | | | | A | | | 9 | | 5 | | 3 | 400 | B | | | 7 | | 3 | | 7 | 300 | C | | | 10 | | 2 | | 8 | 200 | Demand | | 450 | | 220 | | 230 | | 900 | (a) Northwest Corner Method ( 4.5 marks ) (b) Least Cost Method ( 4.5 marks ) (c) Which initial solution produces the lowest total cost ? ( 1 mark ) Question 3 ( 10 marks ) Suki Corp specializes in manufacturing computer tables. It is considering of building a new factory to manufacture the tables. The size of the factory is either large, medium and small. The following table shows the payoff ( in thousands ) for the proposed factory under three market conditions ( strong, fair, poor ). Alternative | Payoff | | Strong Market | Fair Market | Poor Market | Large Facility | 90 | 70 | 10 | Medium Facility | 60 | 50 | 15 | Small Facility | 30 | 30 | 25 | Probability | 0.5 | 0.3 | 0.2 | (a) Find the best decision under risk, using Expected Opportunity Loss.