The department of engineering at a university in New Jersey must assign six faculty members to their new offices. The following closeness matrix indicates the expected number of contacts per day between professors. The available office spaces (1-6) for the six faculty members are shown in Figure K.12. Assume equal-sized offices. The distance between Offices 1 and 2 (and between offices 1 and 3) is 1 unit, whereas the distance between offices 1 and 4 is 2 units. Professor A B C D E F a. CLOSENESS MATRIX Contacts Between Professors ABCDE 4 1 3 - 5 2 4 12 N N 6 2 a. Because of their academic positions, Professor A must be assigned to office 1, Professor C must be assigned to office 2, and Professor D must be assigned to office 6. Which faculty members should be assigned to offices 3, 4, and 5, respectively, to minimize the total weighted-distance score? b. What is the weighted-distance score of your solution? 7 1 F 10 4 T

The department of engineering at a university in New Jersey must assign six faculty members to their new offices. The following closeness matrix indicates the expected number of contacts per day between professors. The available office spaces (1-6) for the six faculty members are shown in Figure K.12. Assume equal-sized offices. The distance between Offices 1 and 2 (and between offices 1 and 3) is 1 unit, whereas the distance between offices 1 and 4 is 2 units. Professor A B C D E F a. CLOSENESS MATRIX Contacts Between Professors ABCDE 4 1 3 - 5 2 4 12 N N 6 2 a. Because of their academic positions, Professor A must be assigned to office 1, Professor C must be assigned to office 2, and Professor D must be assigned to office 6. Which faculty members should be assigned to offices 3, 4, and 5, respectively, to minimize the total weighted-distance score? b. What is the weighted-distance score of your solution? 7 1 F 10 4 T

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

A company receives parts from suppliers to be used in its manufacturing departments. The quality control department must perform two operation when shipments are received:i) Operation A-draw a random sample, package, and deliver to testing, andii) Operation B-test the materials and issue a disposition reportThere are currently six shipments waiting to be processed. The time estimates for processing these six shipments through quality control are:Shipment Operation A (hours) Operation B (hours)1 1.5 1.02 1.1 2.73 1.2 1.44 0.7…
b) A company receives parts from suppliers to be used in its manufacturing departments. The quality control department must perform two operations when shipments are received: Operation A – draw a random sample, package, and deliver to testing; and Operation B – test the materials and issue a disposition report. There are currently six shipments waiting to be processed. The time estimates for processing these six shipments through quality control are given in the table below. Shipment Operation A (hours) Operation B (hours) A 1.5 1.0 В 1.1 2.7 1.2 1.4 D 0.7 1.6 E 1.6 1.5 F 1.9 2.9 Use Johnson's Rule to set the sequence of processing the shipments through Quality Control. i. ii. How much total time is required to process all the six shipments through Quality Control? Show all times on a Gantt Chart. w lu
Diablo Electronics manufactures four unique products (A, B, C, and D) that are fabricated and assembledin five different workstations (V, W, X, Y, and Z) using a small batch process. Each workstation is staffedby a worker who is dedicated to work a single shift per day at an assigned workstation. Batch setuptimes have been reduced to such an extent that they can be considered negligible. A flowchart denotesthe path each product follows through the manufacturing process as shown in Figure 5.2, where eachproduct’s price, demand per week, and processing times per unit are indicated as well. Inverted trianglesrepresent purchased parts and raw materials consumed per unit at different workstations. Diablo canmake and sell up to the limit of its demand per week, and no penalties are incurred for not being able tomeet all the demand.Which of the five workstations (V, W, X, Y, or Z) has the highest utilization, and thus serves as the bottle-neck for Diablo Electronics?
CC Car Wash specializes in car cleaning services. The servicesoffered by the company, the exact service time, and the resources needed for each of them aredescribed in the table following: service description processing time resources used A. Wash Exterior car washing anddrying 10 min. 1 automated washingmachine B. Wax Exterior car waxing 10 min. 1 automated waxingmachine C. Wheel cleaning Detailed cleaning of all wheels 7 min. 1 employee D. Interior cleaning Detailed cleaning inside thecar 20 min. 1 employee The company offers the following packages to their customers: Package 1: Includes only car wash (service A). Package 2: Includes car wash and waxing (services A and B). Package 3: Car wash, waxing, and wheel cleaning (services A, B, and C). Package 4: All four services (A, B, C, and D).Customers of CC Car Wash visit the station at a constant rate (you can ignore any effects ofvariability) of 40 customers per day. Of these customers, 40 percent buy Package 1, 15…
3 35 The customers go to the company are at the rate of one arrival every 12 minutes. The time between arrivals follows an exponential distribution. Each customer gets the service with mean 8 minutes. There is just one person to serve. Company management wants to learn performance values for the service. Answer the following questions for the company. a. Determine the arrival frequency, service frequency and system utilization factor b. Determine the probability that no customer in the service c. Determine expected number of customers in system d. Determine expected number of customers in queue e. Determine expected waiting time in system f. Determine expected waiting time in queue
Consider the following tasks that must be assigned to four workers on a conveyor-paced assembly line (i.e., a machine-paced line flow). Each worker must perform at least one task. There exists unlimited demand unless stated otherwise. Time to Complete Task (seconds): Task 1: 30 Task 2: 25 Task 3: 15 Task 4: 20 Task 5: 15 Task 6: 20 Task 7: 50 Task 8: 15 Task 9: 20 Task 10: 25 Task 11: 15 Task 12: 20 The current conveyor-paced assembly-line configuration assigns the workers in the following way: • Worker 1: Tasks 1, 2, 3 • Worker 2: Tasks 4, 5, 6 • Worker 3: Tasks 7, 8, 9 • Worker 4: Tasks 10, 11, 12 What is the direct labor content (in seconds per unit)?
Choice Bank receives credit card applications that need to be reviewed for a decision. There are two types of applications; preapproved, and non-preapproved. Preapproved applications only need a quick review and therefore take 6 minutes to process. Applications that are not preapproved need a secondary credit check and take 15 minutes to process. 8. The bank receives 10 preapproved applications every hour and 6 applications that are not preapproved every hour. What is the utilization of the process?
Instructions: Solve using Excel Solver. Create the linear programming model and get the optimal solution to the problem. (Follow the steps and format in the photo below) 1. A company manufactures two products X1 and X2 on three machines A, B, and C. X1 requires 1 hour on machine A and 1hour on machine B and yields a revenue of Php 30. Product X2 requires 2 hours on machine A and 1 hour on machine B and 1 hour on machine C and yields revenue of PhP 50. In the coming planning period the available time of three machines A, B, and C are 2000 hours, 1500 hours and 600 hours respectively. Find the optimal product mix.
Andromeda Books is a small independent publisher of fictionand nonfiction books. Each week the publisher receives anaverage of eight unsolicited manuscripts to review (Poissondistributed). The publisher has 12 freelance reviewers in thearea who read and evaluate manuscripts. It takes a revieweran average of 10 days (exponentially distributed) to read amanuscript and write a brief synopsis. (Reviewers work on their own, seven days a week.) Determine how long the pub-lisher must wait on average to receive a reviewer’s manu-script evaluation, how many manuscripts are waiting to be reviewed, and how busy the reviewers are.
1. Multiple Choice Questions  Considering the assignment problem, which of the following criteria are preferred for making the assignments. Single zero contained by the only row Single zero contained by the only column  Single zero contained by the row/column  More than one zero contained by the column  The allocated cells of the matrix in the transportation problem is known as: Unoccupied cells Occupied cells Loop cells Intersection cells For optimal solution through modified distribution method , which of the mathematical formula is utilized after check the condition for degeneracy problem m+n-1 Cij = Ui + Vj Ui = Vj – Cij All of these The starting and ending time-points in the network activity diagram is known as: An activity  The arrow line  Event  Node  The cell evaluation outcome for all the non-allocated values of the matrix becomes zero or positive, then which of the following statement would be considered towards an optimal solution. The most negative…
A community health system’s nurse team consists of 12 nurses working in the localcommunity. It takes a nurse 1.5 hours to complete one patient visit (including travel timeand breaks).a. What is the capacity of the nurse team over the course of a 9-hour workday?b. Assuming the demand for the nurses is 60 patients per day, what is the utilization ofthe nurse team?c. Assuming the demand for the nurses is 60 patients per day, what is the cycle time?
William Beebe owns a small shoe store. He has 10 pairs of shoes that requireresoling and polishing. He has a machine that can resole one pair of shoes at atime, and the time required for the operation varies with the type and condition of theshoe and the type of sole that is used. Shoes are polished on a machine dedi-cated tothis purpose as well, and polishing is always done after resoling. His assistant generally does the polishing while Mr. Beebe does the resoling. The resoling and polishingtimes (in minutes) are Shoes Resoling Time Polishing Time1 14 32 28 13 12 24 6 55 10 106 14 67 4 128 25 89 15 510 10 5In what order should the shoes be repaired in order to minimize the total makespanfor these 10 jobs?