Question: Solve with excel please... B. Use the non-adjacent load approach (find the largest factor) Initial Layout B Building A to C= Building A to F=

Solve with excel please...

Solve with excel please... B. Use the

B. Use the non-adjacent load approach (find the largest factor) Initial Layout B Building A to C= Building A to F= Building D to C= Building D to F= Total Load Distance = C. Please rearrange the buildings so that the total load distance would be reduced Layout 2 O" non adjacent pair loads Building C to D= Building C to F= Building D to F= Building A to F= Building C to E= Total Load Distance = D. Please rearrange the buildings so that the total load distance would be reduced B non adjacent pair loads Building A to E= Building C to F= Building A to F= Building A to D= Building D to F= Total Load Distance = 1. The college wants to layout the facility to reduce the number of students/staffs travel distance between the buildings. Please use the following matrix flow chart to complete the answers. A B Buildings A - Lecture Building B - Library C - Study Hall D - Concert Hall E - Aula Maxima F - Student Services o E F Flow Matrix A B D E F A 7 20 5 6 2 B 8 0 10 15 6 0 8 10 0 6 30 7 10 D 5 3 E 10 10 1 20 - 6 F 0 6 0 3 4 A. Please fill out the triangular (aggregate) flow matrix chart A B D E F F B Imow C D E F B. Use the non-adjacent load approach (find the largest factor) Initial Layout B Building A to C= Building A to F= Building D to C= Building D to F= Total Load Distance = C. Please rearrange the buildings so that the total load distance would be reduced Layout 2 O" non adjacent pair loads Building C to D= Building C to F= Building D to F= Building A to F= Building C to E= Total Load Distance = D. Please rearrange the buildings so that the total load distance would be reduced B non adjacent pair loads Building A to E= Building C to F= Building A to F= Building A to D= Building D to F= Total Load Distance = 1. The college wants to layout the facility to reduce the number of students/staffs travel distance between the buildings. Please use the following matrix flow chart to complete the answers. A B Buildings A - Lecture Building B - Library C - Study Hall D - Concert Hall E - Aula Maxima F - Student Services o E F Flow Matrix A B D E F A 7 20 5 6 2 B 8 0 10 15 6 0 8 10 0 6 30 7 10 D 5 3 E 10 10 1 20 - 6 F 0 6 0 3 4 A. Please fill out the triangular (aggregate) flow matrix chart A B D E F F B Imow C D E F

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

OL 325: Final Project Guidelines and Rubric Overview Acting as a recently hired compensation consultant, you will assist the burgeoning online music firm e-sonic to develop an internally consistent...

Hi! Good afternoon will you please help me answer and analyze these following problem set? Thank you so much. It is my reviewer for the exam. 1. Find the Slope of the graph of the function at the...

Image transcription text Module 5 Discussion A' Instructions: This discussion will be completed in two parts, and will give you an opportunity to reect upon this week's content and to interact with...

3 COLLEGE ALGEBRA - TRIGONOMETRY Business and Finance (MAT115) This course will start with a review of basic algebra (factoring, solving linear equations, and equalities, etc.) and proceed to a study...

I need your help with this: Can you please quote from the attached chapters / resource if possible? Corporations often use different costs of capital for different operating divisions. Using an...

Process Strategy Chapter 3 Copyright 2013 Pearson Education, Inc. publishing as Prentice Hall 03 -01 What is Process Strategy? Process Strategy The pattern of decisions made in managing processes, so...

JPMA-01726; No of Pages 12 Available online at www.sciencedirect.com ScienceDirect International Journal of Project Management xx (2015) xxx - xxx www.elsevier.com/locate/ijproman Does Agile work? A...

CASE 25 Southwest Airlines in 2014: Culture, Values, and Operating Practices Arthur A. Thompson John E. Gamble The University of Alabama Texas A&M University-Corpus Christi n 2014, Southwest Airlines...

Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...

a. What value of chi-square for 5 degrees of freedom subdivides the area under the distribution curve such that 5% is to the right and 95% is to the left? b. What is the value of the 95th percentile...

Aspartame is an artificial sweetener. Give the (R, S) designation for each chirality center of aspartame. Aspartame OCH H3N

6. What exceptions might call for inventory valuation at net realizable value?

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...