Please note: Please show all solution processes either in excel and or in a word document to received full credit. If you have the solutions in two documents, make sure to upload both files. 1. The student center at Worcester State University has five student clubs, any of which can be placed into any of five physical departmental locations in the center. Call the student clubs A, B, C, D, and E, and the location 1, 2, 3, 4, and 5. The current set of assignments is A-3, B-1, C-5, D-2, and E-4. The (symmetric) matrix of physical departmental locations distances in student center, in yards is shown below. The matrix of work flow (estimated trips per day) is among student clubs is shown below. The school estimates that each trip costs approximately $2. a) How much costs the student center to operate based on the current assignment? (5 points) b) Find the new set of assignments that generates the minimum cost? (15 points) and how much is the minimum cost? (5 c) How much WSU is able to save by reprograming the assignments b) vs. a). ( 5 points) b) Find the new set of assignments that generates the minimum cost? (15 points) and how much is the minimum cost? (5 points) c) How much WSU is able to save by reprograming the assignments b) vs. a). (5 points) BA-312 Final Exam 2. The following table details the tasks required for Masschusetts-based Liberty Industries, Inc. to manufacture a fully portable industrial vacuum cleaner. Demand forecasts indicate a need to operate with a cycle time of 5 minutes. a. Draw the precedence diagram for the set of tasks. (10 points) b. Calculate the theoretical minimum number of workstations. (5 points) d. What tasks are assigned to which stations? Explain why? (10 points) e. Does the solution have the minimum number of stations? Explain. (5 points) f. How much idle time is there, summed over all workstations? (5 points) g. What is the efficiency of this line? (5 points) 3. A local department store sells 175 units per month of a certain large box facial tissue. The unit cost per box to the store is $2.50 and the cost of placing an order has been estimated to be $12.00. The store uses an inventory carrying charge of I=27% per year. Determine (a) the optimal order quantity, (b) the order frequency, and (c) the annual holding and setup cost. If, through automation of the purchasing process, the ordering cost can be cut to $4.00, what will be (d) the new economic order quantity, (e) the order frequency, and (f) annual holding and setup costs? Explain these results. Total 30 points