AV Center: Introduction The next four questions refer to the following informati

Question

AV Center: Introduction The next four questions refer to the following information After some special presentations, the employees of the AV Center have to move projectors back to classrooms. The table below indicates the buildings where the projectors are now (the sources), where they need to go (the destinations), and a measure of the distance between sites Destination Business Education Parsons Hall Holmstedt Hall Supply Source Baker Ha 10 Tirey Hall Arena Demand 2 12 15 12 35 10 20 14 20 10 10 Question 11 3 pts AV Center: Part 1 Draw and upload a network diagram for this problem Upload| Choose a File

Explanation / Answer

Network diagram

2) LP model

Decision variables: Xij = Number of projectors to move from source i to destination j, where i=1,2,3 and j=4,5,6,7

Objective: Minimize Z = Dij*Xij , where Dij is the distance between source i and destn j

s.t.

X1j <= 35

X2j <= 10

X3j <= 20

Xi4 =12

Xi5 = 20

Xi6 = 10

Xi7 = 10

Xij >= 0

3) Solution using Excel Solver

Formula: D19 =SUMPRODUCT(B4:E6,B13:E15)

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.