Ch. 8 Q4 An Initial solution has been given to the following workcenter layout problem. Each location is 160 feet long and 80 feet wide as shownon the following figure. Use the centers of departments for distances and measure distance using metropolitan-rectilinear distance.CawallnyDEPARTMENTDEPARTMENTA0Total costABсD80' AB160' 160 160сB200сDC3520080'80"D6515250Given the flows described and a cost of $5 per unit per foot, compute the total cost for the layout.HHOLOfs 101f6< Prev4 of 8ly47 +

Determine the distance by taking mid points: From/to Distances(D)(in square foot) A to B…

Answered: An Initial solution has been given to…

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

Formulate the following as a linear programmingproblem: A greenhouse operator plans to bid for the job ofproviding flowers for city parks. He will use tulips, daffodils,and flowering shrubs in three types of layouts. A Type 1layout uses 30 tulips, 20 daffodils, and 4 flowering shrubs.A Type 2 layout uses 10 tulips, 40 daffodils, and 3 floweringshrubs. A Type 3 layout uses 20 tulips, 50 daffodils, and 2flowering shrubs. The net profit is $50 for each Type 1layout, $30 for each Type 2 layout, and $60 for each Type 3layout. He has 1,000 tulips, 800 daffodils, and 100 floweringshrubs. How many layouts of each type should be used toyield maximum profit?36 Explain how your formulation in Problem 35 changesif both of the following conditions are added:a The number of Type 1 layouts cannot exceed thenumber of Type 2 layouts.b There must be at least five layouts of each type.
Assign nine automobile service departments to bays in a 3 × 3 grid so that the closeness ratings Problem 2 in the following matrix are satisfied. (The unimportant and ordinary-importance ratings have been omitted to simplify the example.) The location of department 4 must be in the upper right-hand corner of the grid to satisfy a town ordinance.
A manufacturing firm has four plants and wants to find the most efficient means of meeting the requirements of its four customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are shown in the table below: Customer (requirement) Factory (capacity) Customer 1 (125) Customer 2 (150) Customer 3 (175) Customer 4 (75) A (100) $ 15 $ 10 $ 20 $ 17 B (75) $ 20 $ 12 $ 19 $ 20 C (100) $ 22 $ 20 $ 25 $ 14 D (250) $ 21 $ 15 $ 28 $ 12 How many arcs will the network have?
Solve the following Linear Programming model using the graphical method (USING EXCEL){Write the steps of construction} Q1)MaximizeH = x + 3y Objective functionsubject tox + y ≤ 502x + y ≤ 60 x ≥ 0, y ≥ 0
A manufacturing system is used to produce a product.Each unit of product must be processed sequentially through workstations.V -----> W -----> X -----> Y The capacity of each workstation are as follows:Workstation V, 24 units per hour,Workstation W, 16 units per hour, Workstation X, 32 units per hour,Workstation Y, 26 units per hour. The raw material is always available in the front of workstation V. The utilization rate of workstation X is ________ percent. Use at least 4 decimals.You must show your calculation steps and brief explanation on your Excel spreadsheets.
Consider the network in the following figure. Edges that are not pictured have a length of ∞. Image attatched (a) What is the optimal TSP tour on this network, and what is its total length, z*? What is the optimal 1-tree Tˆ* on this network (“rooted” at node 1), and what is its total length, z(Tˆ*)? (b) Find the best Held-Karp lower bound you can. That is, find weights to add to one or more nodes so that z* and the right-hand side of the following formula are as close as possible. z* ≥ z(Tˆ*) + SUM{i∈N} λi(di(Tˆ*) − 2) Image attatched Here Tˆ* is the optimal 1-tree under the revised distance matrix, z(Tˆ*) is its cost and di(Tˆ*) is the degree of node i in 1-tree Tˆ*.
The Doan Modianos Manufacturing Company isputting out seven new electronic components. Each ofModianos'eight plants has the capacity to add one more product to its currentline of electronic parts. The unit manufacturing costs forproducing the different parts at the eight plants are shown in theaccompanying table. How should Modianos assign the new productsto the plants in order to minimize manufacturing costs?
A manufacturing system is used to produce a product.Each unit of product must be processed sequentially through workstations.V -----> W -----> X -----> Y The capacity of each workstation are as follows:Workstation V, 16 units per hour,Workstation W, 22 units per hour, Workstation X, 13 units per hour,Workstation Y, 18 units per hour. The raw material is always available in the front of workstation V. The manufacturing system has a cycle time of __________ minutes per unit. Use at least 4 decimals.You must show your calculation steps and brief explanation on your Excel spreadsheets.
A company needs to locate three departments (X, Y, and Z) in the three areas (I, II, and III) of a new facility. They want to minimize interdepartmental transportation costs, which are expected to be $.50 per load meter moved. An analyst has prepared the following flow and distance matrices: Distances (meters) Flows (Loads per week) From/To I II III From/To X Y Z I - 10 20 X - 0 80 II - - 10 Y 30 - 150 III - Z 100 130 -If the company were to locate departments X, Y, and Z in areas 1, 2, and 3, respectively, what would be the total distance (in meters) loads would be moved each week?A. 3,100B. 3,600C. 6,200D. 7,200E. 8,200 Work must…
. David’s Sport Supplies is a store that sells sports equipmentand gear for teenagers and young adults. David’s is in the processof assigning the location of storage areas in its warehouse (Figure10-16) to minimize the number of trips made to retrieve neededitems. Given here in Table 10-14 are the departments that needto be located, the number of trips made per week for eachdepartment, and the area needed by each department.
Mitch just built 4 franchise locations for his newest pizzerias and wants to decide where to put his headquarters. He makes 1 weekly visit to his Northside store (X = 3, Y = 10), 2 visits to his Eastside store (X = 4, Y = 6), 3 visits to his Southside store (X = 2, Y = 5) & 4 visits to his Westside store (X = 1, Y = 4). __________ 1. Using the store visits as weights, compute the coordinates of the center of gravity to help him with his location decision.
Consider the relationship chart for the a fast-food restaurant, Assume that the areas required for each department are: Department Area Required (Square feet) (CB) 300 (CF) 200 (PS) 200 (DD) 200 (CS) 300 Assume facility dimension of 6 (horizontal) by 8 (vertical) squares, where each square is 5 feet on a side. As a result, for example the CB department requires 12 squares. Develop a layout for the fast-food restaurant.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS