Solve Problem 32 using an electronic spreadsheet. To do so, enter the building numbers in column A,
Question:
Solve Problem 32 using an electronic spreadsheet. To do so, enter the building numbers in column A, the x coordinates in column B, and the associated weights in column C. Sort columns A, B, and C in ascending order by using column B as the primary sort key. Now accumulate the weights (column C) in column D using the sum function. Divide the total accumulated weight by 2 and visually identify the optimal x coordinate value. It will be where the cumulative weight first exceeds half the total cumulative weight. Repeat the process for the y coordinates.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Production And Operations Analysis
ISBN: 9781478623069
7th Edition
Authors: Steven Nahmias, Tava Lennon Olsen
Question Posted: