UNIVERSITY OF THE WEST INDIES – OPEN CAMPUS Semester II, MAY 2011-12 MGMT 2026 – Assignment Problem Sheet This Problem Sheet Contains FOUR (4) Questions Instructions: Attempt all Questions QUESTION 1 : Layout – Line Balancing After an extensive product analysis, using group technology, Bob Barker has identified a product he believes should be pulled out of his process facility and handled in a work cell. Bob has identified the following operations as necessary for the work cell . The customer expects delivery of 250 units per day, and the work day is 420 minutes. Operations Standard Time (minutes) Shear 1.1 Bend 1.1 Weld 1.7 Clean 3.1 Paint 1.0 a) Compute the total task time for all tasks. [5 marks] b) How many employees should be cross-tr ained for the cell ? [15 marks] c) Which operation may warrant special treatment ? [5 marks] QUESTION 2 Layout – Load Distance Analysis Six processes are to be laid out in six rooms along a long corridor at Linda Babat Bookkeeping Service. The distance between adjacent work centers is 40 feet. The number of trips between work centers is given in the following table: TRIPS BETWEEN ROOMS To From A B C D E F A 18 25 73 12 54 B 96 23 31 45 C 41 22 20 D 19 57 E 48 F a) Assign the processes to the rooms in a way that minimizes the total flow using a method that places rooms with highest flow adjacent to each other. {Develop at least two options} [15 marks] b) Which among the assignment options minimizes the total traffic flow ? [10 marks] QUESTION 3 Location – LP Transportation model Drew Rosen Corp is considering adding a fourth plant to its three existing facilities in Decatur, Minneapolis and Carbondale. Both St Louis and East St Louis are being considered. To From Existing Plants at DEMAND Decatur Minneapolis Carbondale Blue Earth $20 $17 $21 250 Ciro $25 $27 $20 200 Des Moines $22 $25 $22 350 CAPACITY 300 200 150 To From Proposed Plants at East St Louis St Louis Blue Earth $29 $27 Ciro $30 $28 Des Moines $30 $31 CAPACITY 150 150 a) Draw a well-annotated source-destination diagram to depict the existing shipping arrangement. [5 marks] b) Determine the optimal shipping plan and cost using the three existing plants.[Use the minimum cell cost method] [5 marks] c) Compare the optimal shipping plan and cost for the existing plants plus each of the proposed plants in turn. [Use the minimum cell cost method] [10 marks] d) Which of the proposed plant locations is best ? [5 marks] QUESTION 4 Forecasting The number of transistors, in millions, made at a plant in Japan during the past five years, is as follows: YEAR TRANSISTORS 1 140 2 160 3 190 4 200 5 210 a) Using the formula, compute the intercept and slope of the line. [10 marks] b) Use the straight line equation: i. To draw a graph representing the regression line. [3 marks] ii. To determine a value for year 6 by manual extrapolation [2 marks] c) Redo the problem using “excel” software solely [10 marks] Note: Although the above questions are marked out of a total of 100 marks the contribution towards the final course mark would be prorated to reflect a maximum of 20 marks.